HWR_VLTR_REGN_RGSTR

Details

Name
REGISTEREDWORKFORCE REGION

Name

REGISTEREDWORKFORCE

REGION

SQL_Statement
SELECT COUNT(DISTINCT(A.PERSON_ID)) REGISTEREDWORKFORCE , C.COUNTRY REGION FROM PER_ALL_ASSIGNMENTS_M A, PER_LOC_ADDRESS_USAGES_F B, PER_ADDRESSES_F C, (select PERSON_ID AS PERSONID from PER_ALL_ASSIGNMENTS_M) R, (select USERNAME as USERNAME, PERSON_ID as PERSONID from PER_USERS) S, (select USER_NAME AS USERNAME, HCM_PERSON_ID from HWR_vltr_per_profile_vl) T 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 and S.USERNAME = T.USERNAME and R.PERSONID = S.PERSONID and R.PERSONID = A.PERSON_ID GROUP BY C.COUNTRY ORDER BY C.COUNTRY

SQL_Statement

SELECT COUNT(DISTINCT(A.PERSON_ID)) REGISTEREDWORKFORCE , C.COUNTRY REGION

FROM PER_ALL_ASSIGNMENTS_M A,

PER_LOC_ADDRESS_USAGES_F B,

PER_ADDRESSES_F C,

(select PERSON_ID AS PERSONID

from PER_ALL_ASSIGNMENTS_M) R,

(select USERNAME as USERNAME,

PERSON_ID as PERSONID

from PER_USERS) S,

(select USER_NAME AS USERNAME,

HCM_PERSON_ID

from HWR_vltr_per_profile_vl) T

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

and

S.USERNAME = T.USERNAME and

R.PERSONID = S.PERSONID

and R.PERSONID = A.PERSON_ID

GROUP BY C.COUNTRY ORDER BY C.COUNTRY