Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity contains information about the academic catalog of a person. |
Implementation/DBA Data: | Not implemented in this database |
SELECT HZP.PARTY_NUMBER
, PSD.EFFECTIVE_START_DATE
, PSD.EFFECTIVE_END_DATE
, PSD.IN_STATE_TUITION
, PSD.TUITION_ST_DATE
, PSD.TUITION_END_DATE
, CIA1.ALTERNATE_CODE
, PSD.MATR_CAL_TYPE
, PSD.MATR_SEQUENCE_NUMBER
, CIA1.START_DT
, CIA1.END_DT
, CIA2.ALTERNATE_CODE
, PSD.INIT_CAL_TYPE
, PSD.INIT_SEQUENCE_NUMBER
, CIA2.START_DT
, CIA2.END_DT
, CIA3.ALTERNATE_CODE
, PSD.RECENT_CAL_TYPE
, PSD.RECENT_SEQUENCE_NUMBER
, CIA3.START_DT
, CIA3.END_DT
, CIA4.ALTERNATE_CODE
, PSD.CATALOG_CAL_TYPE
, PSD.CATALOG_SEQUENCE_NUMBER
, CIA4.START_DT
, CIA4.END_DT
, '_LA:PSD.FURTHER_EDUCATION_CD:IGS_LOOKUP_VALUES:PE_FUR_EDU:MEANING'
, '_LA:PSD.RELIGION_CD:IGS_LOOKUP_VALUES:PE_RELIGION:MEANING'
, '_LA:PSD.SOCIO_ECO_CD:IGS_LOOKUP_VALUES:PE_SOCECO_STAT:MEANING'
, '_DF:IGS:IGS_PE_PERS_STAT:PSD'
, PSD.PERSON_ID
, PSD.CREATION_DATE
, PSD.CREATED_BY
, PSD.LAST_UPDATED_BY
, PSD.LAST_UPDATE_DATE
FROM IGS_PE_STAT_DETAILS PSD
, HZ_PARTIES HZP
, IGS_CA_INST_ALL CIA1
, IGS_CA_INST_ALL CIA2
, IGS_CA_INST_ALL CIA3
, IGS_CA_INST_ALL CIA4
WHERE PSD.PERSON_ID=HZP.PARTY_ID
AND CIA1.CAL_TYPE(+)=PSD.MATR_CAL_TYPE
AND CIA1.SEQUENCE_NUMBER(+)=PSD.MATR_SEQUENCE_NUMBER
AND CIA2.CAL_TYPE(+)=PSD.INIT_CAL_TYPE
AND CIA2.SEQUENCE_NUMBER(+)=PSD.INIT_SEQUENCE_NUMBER
AND CIA3.CAL_TYPE(+)=PSD.RECENT_CAL_TYPE
AND CIA3.SEQUENCE_NUMBER(+)=RECENT_SEQUENCE_NUMBER
AND CIA4.CAL_TYPE(+)=PSD.CATALOG_CAL_TYPE
AND CIA4.SEQUENCE_NUMBER(+)=PSD.CATALOG_SEQUENCE_NUMBER WITH READ ONLY