View: IGS_PE_PERSON_V

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

View Text

SELECT P.ROWID ROW_ID
, P.PARTY_ID PERSON_ID
, P.PARTY_NUMBER PERSON_NUMBER
, P.PARTY_NAME PERSON_NAME
, P.PARTY_TYPE PARTY_TYPE
, IGS_EN_GEN_007.ENRP_GET_STUDENT_IND(P.PARTY_ID) STUDENT_IND
, IGS_EN_GEN_003.ENRP_GET_ENCMBRD_IND(P.PARTY_ID) ENCUMBERED_IND
, IGS_EN_GEN_003.GET_STAFF_IND(P.PARTY_ID) STAFF_MEMBER_IND
, P.VALIDATED_FLAG VALIDATED_FLAG
, P.PERSON_LAST_NAME SURNAME
, P.PERSON_FIRST_NAME GIVEN_NAMES
, P.PERSON_MIDDLE_NAME MIDDLE_NAME
, P.PERSON_NAME_SUFFIX SUFFIX
, P.PERSON_PRE_NAME_ADJUNCT PRE_NAME_ADJUNCT
, L2.MEANING PRE_NAME_ADJUNCT_MEANING
, P.PERSON_TITLE TITLE
, P.PERSON_TITLE || ' ' || P.PERSON_FIRST_NAME || ' ' || P.PERSON_LAST_NAME TITLE_NAME
, PP.PERSON_NAME INITIAL_NAME
, PP.PERSON_NAME INITIAL_LAST_NAME
, P.PERSON_LAST_NAME || '
, ' || P.PERSON_TITLE || ' ' || NVL(P.KNOWN_AS
, P.PERSON_FIRST_NAME) CONTEXT_BLOCK_NAME
, P.EMAIL_ADDRESS EMAIL_ADDR
, P.SALUTATION SALUTATION
, NVL(P.KNOWN_AS
, SUBSTR (P.PERSON_FIRST_NAME
, 1
, DECODE(INSTR(P.PERSON_FIRST_NAME
, ' ')
, 0
, LENGTH(P.PERSON_FIRST_NAME)
, (INSTR(P.PERSON_FIRST_NAME
, ' ')-1)))) || ' ' || P.PERSON_LAST_NAME PREFERRED_NAME
, P.KNOWN_AS PREFERRED_GIVEN_NAME
, PD.PROOF_OF_INS PROOF_OF_INS
, PD.PROOF_OF_IMMU PROOF_OF_IMMU
, PD.LEVEL_OF_QUAL LEVEL_OF_QUAL_ID
, PD.MILITARY_SERVICE_REG MILITARY_SERVICE_REG
, PD.VETERAN VETERAN
, L3.MEANING VETERAN_MEANING
, DECODE(PP.DATE_OF_DEATH
, NULL
, NVL(PD.DECEASED_IND
, 'N')
, 'Y') DECEASED_IND
, PP.PERSON_NAME FULL_NAME
, PP.GENDER SEX
, L1.MEANING SEX_MEANING
, PP.DATE_OF_DEATH DECEASED_DATE
, PP.DATE_OF_BIRTH BIRTH_DT
, PD.ARCHIVE_EXCLUSION_IND ARCHIVE_EXCLUSION_IND
, PD.ARCHIVE_DT ARCHIVE_DT
, PD.PURGE_EXCLUSION_IND PURGE_EXCLUSION_IND
, PD.PURGE_DT PURGE_DT
, PIT.PERSON_ID_TYPE PERSON_ID_TYPE
, PIT.API_PERSON_ID API_PERSON_ID
, PD.FUND_AUTHORIZATION FUND_AUTHORIZATION
, P.CREATED_BY CREATED_BY
, P.CREATION_DATE CREATION_DATE
, P.LAST_UPDATED_BY LAST_UPDATED_BY
, P.LAST_UPDATE_DATE LAST_UPDATE_DATE
, P.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, P.REQUEST_ID REQUEST_ID
, P.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, P.PROGRAM_ID PROGRAM_ID
, P.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, P.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, P.ATTRIBUTE1 ATTRIBUTE1
, P.ATTRIBUTE2 ATTRIBUTE2
, P.ATTRIBUTE3 ATTRIBUTE3
, P.ATTRIBUTE4 ATTRIBUTE4
, P.ATTRIBUTE5 ATTRIBUTE5
, P.ATTRIBUTE6 ATTRIBUTE6
, P.ATTRIBUTE7 ATTRIBUTE7
, P.ATTRIBUTE8 ATTRIBUTE8
, P.ATTRIBUTE9 ATTRIBUTE9
, P.ATTRIBUTE10 ATTRIBUTE10
, P.ATTRIBUTE11 ATTRIBUTE11
, P.ATTRIBUTE12 ATTRIBUTE12
, P.ATTRIBUTE13 ATTRIBUTE13
, P.ATTRIBUTE14 ATTRIBUTE14
, P.ATTRIBUTE15 ATTRIBUTE15
, P.ATTRIBUTE16 ATTRIBUTE16
, P.ATTRIBUTE17 ATTRIBUTE17
, P.ATTRIBUTE18 ATTRIBUTE18
, P.ATTRIBUTE19 ATTRIBUTE19
, P.ATTRIBUTE20 ATTRIBUTE20
, P.ATTRIBUTE21 ATTRIBUTE21
, P.ATTRIBUTE22 ATTRIBUTE22
, P.ATTRIBUTE23 ATTRIBUTE23
, P.ATTRIBUTE24 ATTRIBUTE24
, TO_DATE(NULL) WH_UPDATE_DATE
, P.GLOBAL_ATTRIBUTE_CATEGORY
, P.GLOBAL_ATTRIBUTE1
, P.GLOBAL_ATTRIBUTE2
, P.GLOBAL_ATTRIBUTE3
, P.GLOBAL_ATTRIBUTE4
, P.GLOBAL_ATTRIBUTE5
, P.GLOBAL_ATTRIBUTE6
, P.GLOBAL_ATTRIBUTE7
, P.GLOBAL_ATTRIBUTE8
, P.GLOBAL_ATTRIBUTE9
, P.GLOBAL_ATTRIBUTE10
, P.GLOBAL_ATTRIBUTE11
, P.GLOBAL_ATTRIBUTE12
, P.GLOBAL_ATTRIBUTE13
, P.GLOBAL_ATTRIBUTE14
, P.GLOBAL_ATTRIBUTE15
, P.GLOBAL_ATTRIBUTE16
, P.GLOBAL_ATTRIBUTE17
, P.GLOBAL_ATTRIBUTE18
, P.GLOBAL_ATTRIBUTE19
, P.GLOBAL_ATTRIBUTE20
, P.ORIG_SYSTEM_REFERENCE
, P.PERSON_MIDDLE_NAME
, P.PERSON_ACADEMIC_TITLE
, P.PERSON_PREVIOUS_LAST_NAME
, P.PERSON_IDEN_TYPE
, P.PERSON_IDENTIFIER
, P.CATEGORY_CODE
, ADC.DESCRIPTION LEVEL_OF_QUAL
, PD.ORACLE_USERNAME
, PD.BIRTH_CITY BIRTH_CITY
, PD.BIRTH_COUNTRY BIRTH_COUNTRY
, NULL BIRTH_COUNTRY_DESC
, P.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, P.STATUS
, PD. FELONY_CONVICTED_FLAG
FROM HZ_PARTIES P
, IGS_PE_HZ_PARTIES PD
, HZ_PERSON_PROFILES PP
, IGS_PE_PERSON_ID_TYPE_V PIT
, FND_LOOKUP_VALUES L1
, FND_LOOKUP_VALUES L2
, IGS_AD_CODE_CLASSES ADC
, IGS_LOOKUP_VALUES L3
WHERE P.PARTY_ID = PIT.PE_PERSON_ID(+) AND P.PARTY_ID = PD.PARTY_ID(+) AND P.PARTY_ID = PP.PARTY_ID AND PP.CONTENT_SOURCE_TYPE = 'USER_ENTERED' AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE) AND PP.GENDER = L1.LOOKUP_CODE(+) AND L1.LOOKUP_TYPE(+) = 'HZ_GENDER'
AND L1.LANGUAGE(+) = USERENV('LANG')
AND L1.VIEW_APPLICATION_ID(+) = 222
AND L1.SECURITY_GROUP_ID(+) = 0 AND P.PERSON_PRE_NAME_ADJUNCT = L2.LOOKUP_CODE(+) AND L2.LOOKUP_TYPE(+) = 'CONTACT_TITLE'
AND L2.LANGUAGE(+) = USERENV('LANG')
AND L2.VIEW_APPLICATION_ID(+) = 222
AND L2.SECURITY_GROUP_ID(+) = 0 AND ADC.CODE_ID(+) = PD.LEVEL_OF_QUAL
AND PD.VETERAN = L3.LOOKUP_CODE(+)
AND L3.LOOKUP_TYPE(+) = 'VETERAN_STATUS'

Columns