Get Source System ID of HDL Uploaded Data

Query to get Source System ID of Name which is uploaded by HDL file.

select N.DISPLAY_NAME D_NAME,N.FIRST_NAME,N.LAST_NAME,N.TITLE,

N.EFFECTIVE_START_DATE START_DATE,

P.WORKER_NUMBER W_NO, 

h.*

from fusion.HRC_INTEGRATION_KEY_MAP H, PER_PERSON_NAMES_F N,PER_EMPLOYEES_CURRENT_X P

WHERE 1=1

and N.BUSINESS_GROUP_ID = 1

and N.NAME_TYPE = 'Legislation Code' /* KW, AE */

AND h.surrogate_id=N.person_name_id

AND P.PERSON_ID = N.PERSON_ID