HWR_VLTR_REGN_TOTAL_VL

Details

• Schema: FUSION

• Object owner: HHR

• Object type: VIEW

Columns

Name
TOTALWORKFORCE REGION

Query

SQL_Statement
SELECT COUNT(DISTINCT(A.PERSON_ID)) TOTALWORKFORCE , C.COUNTRY REGION FROM PER_ALL_ASSIGNMENTS_M A, PER_LOC_ADDRESS_USAGES_F B, PER_ADDRESSES_F C WHERE TRUNC(SYSDATE) BETWEEN A.EFFECTIVE_START_DATE AND A.EFFECTIVE_END_DATE AND A.LOCATION_ID = B.LOCATION_ID AND B.ADDRESS_USAGE_TYPE = 'MAIN' AND B.ADDRESS_ID = C.ADDRESS_ID GROUP BY C.COUNTRY ORDER BY C.COUNTRY