View: IGS_PE_PAIR_ACT_PERSON_V

Product:	IGS - Student System
Description:
Implementation/DBA Data:	APPS.IGS_PE_PAIR_ACT_PERSON_V

View Text

SELECT DP.ROWID ROW_ID
, P.PERSON_ID
, P.SURNAME
, NULL SURNAME_5_CHAR
, P.GIVEN_NAMES
, SUBSTR(P.GIVEN_NAMES
, 1
, 1) GIVEN_NAME_1_CHAR
, P.SEX
, P.BIRTH_DT
, P.API_PERSON_ID PREF_ALTERNATE_ID
, S.ETHNIC_ORIGIN
, DP.ACTUAL_PERSON_ID
, P.PERSON_NUMBER ACTUAL_PERSON_NUMBER
, DP.DUPLICATE_PERSON_ID
, DP.DUPLICATE_PAIR_ID
, DP.BATCH_ID
, DP.DUP_STATUS
, DP.MATCH_SET_ID
, DP.MATCH_CATEGORY
, DP.ADDRESS_TYPE ADDR_TYPE
, DP.LOCATION_ID
, DP.PERSON_ID_TYPE
, DP.OBSOLETE_ID
, DECODE (DP.OBSOLETE_ID
, DP.ACTUAL_PERSON_ID
, 'Y'
, DP.DUPLICATE_PERSON_ID
, 'N'
, 'N') OBSOLETE
, P.CREATED_BY
, P.CREATION_DATE
, P.LAST_UPDATED_BY
, P.LAST_UPDATE_DATE
, P.LAST_UPDATE_LOGIN
FROM IGS_PE_PERSON_V P
, IGS_PE_STAT_V S
, IGS_PE_DUP_PAIRS DP
WHERE DP.ACTUAL_PERSON_ID = P.PERSON_ID
AND P.PERSON_ID = S.PERSON_ID (+)

Columns