View: IGS_PE_DUP_MATCHES_P_V

Product:	IGS - Student System
Description:	IGS_PE_DUP_MATCHES_P_V is used for the duplicate information about persons.
Implementation/DBA Data:	APPS.IGS_PE_DUP_MATCHES_P_V

View Text

SELECT P.PARTY_ID PERSON_ID
, P.PERSON_LAST_NAME SURNAME
, NULL SURNAME_5_CHAR
, P.PERSON_FIRST_NAME GIVEN_NAMES
, NULL GIVEN_NAME_1_CHAR
, PP.GENDER SEX
, PP.DATE_OF_BIRTH BIRTH_DT
, PP.DECLARED_ETHNICITY ETHNIC_ORIGIN_ID
, PIT.API_PERSON_ID PREF_ALTERNATE_ID
, P.STATUS
FROM HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, IGS_PE_PERSON_ID_TYPE_V PIT
WHERE P.PARTY_ID = PP.PARTY_ID
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE)
AND P.PARTY_ID = PIT.PE_PERSON_ID(+)

Columns