View: IGS_AD_IMP_MATCHES_P_V

Product:	IGS - Student System
Description:	Gets the person details for the import process from the interface and person statistic tables
Implementation/DBA Data:	APPS.IGS_AD_IMP_MATCHES_P_V

View Text

SELECT IP.ROWID ROW_ID
, IP.INTERFACE_ID
, IP.BATCH_ID
, IP.PERSON_ID
, IP.GIVEN_NAMES
, SUBSTR(IP.GIVEN_NAMES
, 1
, 1) GIVEN_NAME_1_CHAR
, IP.SURNAME
, NULL SURNAME_5_CHAR
, IP.PREFERRED_GIVEN_NAME
, IP.SEX
, IP.BIRTH_DT
, IP.PREF_ALTERNATE_ID
, SI.ETHNIC_ORIGIN
, IP.CREATED_BY CREATED_BY
, IP.CREATION_DATE CREATION_DATE
, IP.LAST_UPDATED_BY LAST_UPDATED_BY
, IP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, IP.REQUEST_ID REQUEST_ID
, IP.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, IP.PROGRAM_ID PROGRAM_ID
, IP.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM IGS_AD_INTERFACE IP
, IGS_AD_STAT_INT SI
WHERE IP.INTERFACE_ID = SI.INTERFACE_ID(+)

Columns