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
, PSD.MATR_CAL_TYPE
, PSD.MATR_SEQUENCE_NUMBER
, PSD.INIT_CAL_TYPE
, PSD.INIT_SEQUENCE_NUMBER
, PSD.RECENT_CAL_TYPE
, PSD.RECENT_SEQUENCE_NUMBER
, PSD.CATALOG_CAL_TYPE
, PSD.CATALOG_SEQUENCE_NUMBER
, '_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'
, 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
WHERE PSD.PERSON_ID=HZP.PARTY_ID WITH READ ONLY