1. Tables and Views for HCM
  2. HWR_VLTR_TOTAL_WORKFORCE_VL

HWR_VLTR_TOTAL_WORKFORCE_VL

Details

  • Schema: FUSION

  • Object owner: HHR

  • Object type: VIEW

Columns

Name

TOTALWORKFORCE

Query

SQL_Statement

select count (unique pps.person_id) TotalWorkforce

from per_periods_of_service pps,

per_all_assignments_f paa

where period_type in ('E')

and pps.person_id = paa.person_id

and pps.legal_entity_id = paa.legal_entity_id

and paa.primary_flag = 'Y'

and paa.primary_assignment_flag = 'Y'

and pps.period_of_service_id = paa.period_of_service_id

and pps.date_start = paa.effective_start_date

and pps.business_group_id = paa.business_group_id