View: IGS_PE_STAT_V

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

View Text

SELECT P.ROW_ID ROW_ID
, PP.PERSON_PROFILE_ID PERSON_PROFILE_ID
, P.PERSON_ID PERSON_ID
, P.PERSON_NUMBER PERSON_NUMBER
, PP.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PP.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PP.DECLARED_ETHNICITY ETHNIC_ORIGIN_ID
, LK3.MEANING ETHNIC_ORIGIN
, PP.MARITAL_STATUS MARITAL_STATUS
, LK1.MEANING MARITAL_STATUS_M
, PP.MARITAL_STATUS_EFFECTIVE_DATE MARITAL_STATUS_EFFECTIVE_DATE
, PP.INTERNAL_FLAG INTERNAL_FLAG
, SD.RELIGION_CD RELIGION
, CC2.MEANING RELIGION_DESC
, SD.NEXT_TO_KIN NEXT_TO_KIN
, LK2.MEANING NEXT_TO_KIN_MEANING
, PP.PLACE_OF_BIRTH PLACE_OF_BIRTH
, SD.SOCIO_ECO_CD SOCIO_ECO_STATUS
, CC4.MEANING SOCIO_ECO_STATUS_DESC
, SD.FURTHER_EDUCATION_CD FURTHER_EDUCATION
, CC5.MEANING FURTHER_EDUCATION_DESC
, PP.HOUSEHOLD_SIZE NUMBER_IN_FAMILY
, PP.HOUSEHOLD_INCOME ANN_FAMILY_INCOME
, SD.IN_STATE_TUITION IN_STATE_TUITION
, SD.TUITION_ST_DATE TUITION_ST_DATE
, SD.TUITION_END_DATE TUITION_END_DATE
, SD.MATR_CAL_TYPE
, SD.MATR_SEQUENCE_NUMBER
, SD.INIT_CAL_TYPE
, SD.INIT_SEQUENCE_NUMBER
, SD.RECENT_CAL_TYPE
, SD.RECENT_SEQUENCE_NUMBER
, SD.CATALOG_CAL_TYPE
, SD.CATALOG_SEQUENCE_NUMBER
, SD.CREATED_BY CREATED_BY
, SD.CREATION_DATE CREATION_DATE
, SD.LAST_UPDATED_BY LAST_UPDATED_BY
, SD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SD.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SD.ATTRIBUTE1 ATTRIBUTE1
, SD.ATTRIBUTE2 ATTRIBUTE2
, SD.ATTRIBUTE3 ATTRIBUTE3
, SD.ATTRIBUTE4 ATTRIBUTE4
, SD.ATTRIBUTE5 ATTRIBUTE5
, SD.ATTRIBUTE6 ATTRIBUTE6
, SD.ATTRIBUTE7 ATTRIBUTE7
, SD.ATTRIBUTE8 ATTRIBUTE8
, SD.ATTRIBUTE9 ATTRIBUTE9
, SD.ATTRIBUTE10 ATTRIBUTE10
, SD.ATTRIBUTE11 ATTRIBUTE11
, SD.ATTRIBUTE12 ATTRIBUTE12
, SD.ATTRIBUTE13 ATTRIBUTE13
, SD.ATTRIBUTE14 ATTRIBUTE14
, SD.ATTRIBUTE15 ATTRIBUTE15
, SD.ATTRIBUTE16 ATTRIBUTE16
, SD.ATTRIBUTE17 ATTRIBUTE17
, SD.ATTRIBUTE18 ATTRIBUTE18
, SD.ATTRIBUTE19 ATTRIBUTE19
, SD.ATTRIBUTE20 ATTRIBUTE20
, PP.PERSON_INITIALS
, PP.PRIMARY_CONTACT_ID
, PP.PERSONAL_INCOME
, PP.HEAD_OF_HOUSEHOLD_FLAG
, PP.CONTENT_SOURCE_TYPE
, PP.CONTENT_SOURCE_NUMBER
, PP.GLOBAL_ATTRIBUTE_CATEGORY
, PP.GLOBAL_ATTRIBUTE1
, PP.GLOBAL_ATTRIBUTE2
, PP.GLOBAL_ATTRIBUTE3
, PP.GLOBAL_ATTRIBUTE4
, PP.GLOBAL_ATTRIBUTE5
, PP.GLOBAL_ATTRIBUTE6
, PP.GLOBAL_ATTRIBUTE7
, PP.GLOBAL_ATTRIBUTE8
, PP.GLOBAL_ATTRIBUTE9
, PP.GLOBAL_ATTRIBUTE10
, PP.GLOBAL_ATTRIBUTE11
, PP.GLOBAL_ATTRIBUTE12
, PP.GLOBAL_ATTRIBUTE13
, PP.GLOBAL_ATTRIBUTE14
, PP.GLOBAL_ATTRIBUTE15
, PP.GLOBAL_ATTRIBUTE16
, PP.GLOBAL_ATTRIBUTE17
, PP.GLOBAL_ATTRIBUTE18
, PP.GLOBAL_ATTRIBUTE19
, PP.GLOBAL_ATTRIBUTE20
, P.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SD.BIRTH_CNTRY_RESN_CODE BIRTH_CNTRY_RESN_CODE
, LK4.MEANING BIRTH_CNTRY_RESN
FROM HZ_PERSON_PROFILES PP
, IGS_PE_STAT_DETAILS SD
, IGS_PE_PERSON_BASE_V P
, FND_LOOKUP_VALUES LK2
, IGS_LOOKUPS_VIEW LK3
, IGS_LOOKUP_VALUES CC2
, IGS_LOOKUP_VALUES CC4
, IGS_LOOKUP_VALUES CC5
, FND_LOOKUP_VALUES LK1
, IGS_LOOKUP_VALUES LK4
WHERE SD.PERSON_ID(+) = P.PERSON_ID
AND PP.PARTY_ID = P.PERSON_ID
AND CC2.LOOKUP_CODE (+)= SD.RELIGION_CD
AND CC2.LOOKUP_TYPE(+)='PE_RELIGION'
AND CC4.LOOKUP_CODE (+)= SD.SOCIO_ECO_CD
AND CC4.LOOKUP_TYPE(+)='PE_SOCECO_STAT'
AND CC5.LOOKUP_CODE (+)= SD.FURTHER_EDUCATION_CD
AND CC5.LOOKUP_TYPE(+)='PE_FUR_EDU'
AND LK2.LOOKUP_TYPE (+) = 'PARTY_RELATIONS_TYPE'
AND LK2.LOOKUP_CODE (+) = SD.NEXT_TO_KIN
AND LK2.LANGUAGE (+) = USERENV('LANG')
AND LK2.VIEW_APPLICATION_ID (+) = 222
AND LK2.SECURITY_GROUP_ID(+) = 0
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE)
AND LK3.LOOKUP_CODE(+) = PP.DECLARED_ETHNICITY
AND LK3.LOOKUP_TYPE (+)= 'IGS_ETHNIC_ORIGIN'
AND LK1.LOOKUP_TYPE(+) = 'MARITAL_STATUS'
AND LK1.LOOKUP_CODE(+) = PP.MARITAL_STATUS
AND LK1.LANGUAGE (+) = USERENV('LANG')
AND LK1.VIEW_APPLICATION_ID (+) = 222
AND LK1.SECURITY_GROUP_ID(+) = 0
AND LK4.LOOKUP_TYPE(+) = 'PE_SV_EV_BRTH_CNTRY_RSN'
AND LK4.LOOKUP_CODE (+) = SD.BIRTH_CNTRY_RESN_CODE

Columns