Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity contains information about the various alternate identifiers for a person. |
Implementation/DBA Data: | Not implemented in this database |
SELECT HZP.PARTY_NUMBER
, API.API_PERSON_ID
, API.PERSON_ID_TYPE
, API.START_DT
, API.END_DT
, API.API_PERSON_ID_UF
, API.REGION_CD
, PIT.DESCRIPTION
, '_DF:IGS:IGS_PE_ALT_PERS_ID_FLEX:API'
, API.PE_PERSON_ID
, API.CREATED_BY
, API.CREATION_DATE
, API.LAST_UPDATED_BY
, API.LAST_UPDATE_DATE
FROM IGS_PE_ALT_PERS_ID API
, IGS_PE_PERSON_ID_TYP PIT
, HZ_PARTIES HZP
WHERE HZP.PARTY_ID=API.PE_PERSON_ID
AND PIT.PERSON_ID_TYPE=API.PERSON_ID_TYPE WITH READ ONLY