View: IGS_AD_INTERFACE_V

Product:	IGS - Student System
Description:	Created using a join condition between igs_ad_interface and igs_lookups_view
Implementation/DBA Data:	APPS.IGS_AD_INTERFACE_V

View Text

SELECT I.ROWID ROW_ID
, I.INTERFACE_ID INTERFACE_ID
, I.INTERFACE_RUN_ID INTERFACE_RUN_ID
, I.PERSON_NUMBER PERSON_NUMBER
, I.BATCH_ID BATCH_ID
, I.SURNAME SURNAME
, I.GIVEN_NAMES GIVEN_NAMES
, DECODE ( I.SEX
, NULL
, NULL
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE I.SEX = LOOKUP_CODE
AND LOOKUP_TYPE = 'HZ_GENDER'
AND VIEW_APPLICATION_ID = 222
AND SECURITY_GROUP_ID = 0
AND LANGUAGE = USERENV('LANG') )) SEX_MEANING
, I.BIRTH_DT BIRTH_DT
, I.PREF_ALTERNATE_ID PREF_ALTERNATE_ID
, I.PERSON_ID PERSON_ID
, I.MATCH_IND MATCH_IND
, I.STATUS STATUS
, I.CREATED_BY CREATED_BY
, I.CREATION_DATE CREATION_DATE
, I.LAST_UPDATED_BY LAST_UPDATED_BY
, I.LAST_UPDATE_DATE LAST_UPDATE_DATE
, I.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, I.REQUEST_ID REQUEST_ID
, I.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, I.PROGRAM_ID PROGRAM_ID
, I.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, I.SOURCE_TYPE_ID
, I.PREFERRED_GIVEN_NAME
, I.SEX SEX
, I.TITLE TITLE
, I.SUFFIX SUFFIX
, I.LEVEL_OF_QUAL LEVEL_OF_QUAL
, I.PROOF_OF_INSURANCE PROOF_OF_INSURANCE
, I.PROOF_OF_IMMUN PROOF_OF_IMMUN
, I.MILITARY_SERVICE_REG MILITARY_SERVICE_REG
, I.VETERAN VETERAN
, I.PERSON_MATCH_IND PERSON_MATCH_IND
, I.ERROR_CODE ERROR_CODE
, I.RECORD_STATUS RECORD_STATUS
, I.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, I.ATTRIBUTE1 ATTRIBUTE1
, I.ATTRIBUTE2 ATTRIBUTE2
, I.ATTRIBUTE3 ATTRIBUTE3
, I.ATTRIBUTE4 ATTRIBUTE4
, I.ATTRIBUTE5 ATTRIBUTE5
, I.ATTRIBUTE6 ATTRIBUTE6
, I.ATTRIBUTE7 ATTRIBUTE7
, I.ATTRIBUTE8 ATTRIBUTE8
, I.ATTRIBUTE9 ATTRIBUTE9
, I.ATTRIBUTE10 ATTRIBUTE10
, I.ATTRIBUTE11 ATTRIBUTE11
, I.ATTRIBUTE12 ATTRIBUTE12
, I.ATTRIBUTE13 ATTRIBUTE13
, I.ATTRIBUTE14 ATTRIBUTE14
, I.ATTRIBUTE15 ATTRIBUTE15
, I.ATTRIBUTE16 ATTRIBUTE16
, I.ATTRIBUTE17 ATTRIBUTE17
, I.ATTRIBUTE18 ATTRIBUTE18
, I.ATTRIBUTE19 ATTRIBUTE19
, I.ATTRIBUTE20 ATTRIBUTE20
, I.ATTRIBUTE21 ATTRIBUTE21
, I.ATTRIBUTE22 ATTRIBUTE22
, I.ATTRIBUTE23 ATTRIBUTE23
, I.ATTRIBUTE24 ATTRIBUTE24
, I.MIDDLE_NAME MIDDLE_NAME
, I.PRE_NAME_ADJUNCT PRE_NAME_ADJUNCT
, I.PERSON_TYPE_CODE PERSON_TYPE_CODE
, I.FUNNEL_STATUS FUNNEL_STATUS
, I.BIRTH_CITY
, I.BIRTH_COUNTRY
, BTCH.BATCH_DESC
, I.FELONY_CONVICTED_FLAG
FROM IGS_AD_INTERFACE I
, IGS_AD_IMP_BATCH_DET BTCH
WHERE I.BATCH_ID = BTCH.BATCH_ID

Columns