Query to get Source System Id related to Employee in Fusion HCM Cloud

Please change the source system owner for which you want to check data before running below queries.

Person:

select source_system_id
from fusion.HRC_INTEGRATION_KEY_MAP h
,PER_PERSON_NAMES_F_V P
where 1=1
and h.object_name='Person'
and h.source_system_owner='WORKDAY'
and h.surrogate_id=p."PERSON_ID";

PersonName:

select source_system_id
from fusion.HRC_INTEGRATION_KEY_MAP H
,PER_PERSON_NAMES_F_V P
WHERE 1=1
and h.object_name ='PersonName'
and h.surrogate_id=p.person_name_id
and h.SOURCE_SYSTEM_OWNER ='WORKDAY';


Assignment:

select source_system_id
from fusion.HRC_INTEGRATION_KEY_MAP H
,PER_ALL_ASSIGNMENTS_M PA
where 1=1
and H.object_name='Assignment'
and H.source_system_owner='WORKDAY'
and H.surrogate_id=PA."ASSIGNMENT_ID"

Assignment Supervisor:

select source_system_id
from fusion.HRC_INTEGRATION_KEY_MAP H
,PER_ASSIGNMENT_SUPERVISORS_F_V PA
,PER_PERSON_NAMES_F_V PER_PERSON_NAMES_F_V
,PER_ALL_ASSIGNMENTS_M PER_ALL_ASSIGNMENTS_M
where 1=1
and H.object_name='AssignmentSupervisor'
and H.source_system_owner='WORKDAY'
and H.surrogate_id=pa.assignment_supervisor_id
and pa.person_id="PER_PERSON_NAMES_F_V"."PERSON_ID"
and pa.assignment_id="PER_ALL_ASSIGNMENTS_M"."ASSIGNMENT_ID"

Work Term Assignment

select source_system_id
from fusion.HRC_INTEGRATION_KEY_MAP H
,PER_ALL_ASSIGNMENTS_M PER_ALL_ASSIGNMENTS_M
where 1=1
and H.object_name='Assignment'
and H.source_system_owner='WORKDAY'
and H.surrogate_id="PER_ALL_ASSIGNMENTS_M".work_terms_assignment_id;

Address:

select source_system_id
from fusion.HRC_INTEGRATION_KEY_MAP H
,PER_PERSON_ADDRESSES_V PER_PERSON_ADDRESSES_V
WHERE 1=1
and h.object_name = 'Address'
and h.surrogate_id=PER_PERSON_ADDRESSES_V.address_id
and h.SOURCE_SYSTEM_OWNER ='WORKDAY';

Email Address:

select H.source_system_id
from fusion.HRC_INTEGRATION_KEY_MAP H
,PER_EMAIL_ADDRESSES_V PER_EMAIL_ADDRESSES_V
,PER_PERSON_NAMES_F_V PER_PERSON_NAMES_F_V
WHERE 1=1
and h.object_name = 'EmailAddress'
and h.SOURCE_SYSTEM_OWNER ='WORKDAY'
and h.surrogate_id=PER_EMAIL_ADDRESSES_V.email_address_id
and PER_EMAIL_ADDRESSES_V.PERSON_ID="PER_PERSON_NAMES_F_V"."PERSON_ID"
and TRUNC(SYSDATE) between DATE_FROM and NVL(DATE_TO,SYSDATE+1)