[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CI.DESCRIPTION
, POD.ADM_CAL_TYPE
, POD.ADM_CI_SEQUENCE_NUMBER
, POD.ADMISSION_CAT
, AC.DESCRIPTION
, POD.DT_ALIAS
, ICD.DESCRIPTION
, POD.DAI_SEQUENCE_NUMBER
, '_LA:POD.S_ADMISSION_PROCESS_TYPE:IGS_LOOKUP_VALUES:ADMISSION_PROCESS_TYPE:MEANING'
, POD.COURSE_CD
, PSV.TITLE
, POD.VERSION_NUMBER
, CI1.DESCRIPTION
, POD.ACAD_CAL_TYPE
, POD.SEQUENCE_NUMBER
, POD.LOCATION_CD
, L.DESCRIPTION
, POD.ATTENDANCE_MODE
, ATM.DESCRIPTION
, POD.ATTENDANCE_TYPE
, ATT.DESCRIPTION
, '_LA:POD.ROLLOVER_INCLUSION_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, POD.CREATED_BY
, POD.CREATION_DATE
, POD.LAST_UPDATED_BY
, POD.LAST_UPDATE_DATE
FROM IGS_AD_PECRS_OFOP_DT POD
, IGS_AD_CAT_ALL AC
, IGS_PS_VER_ALL PSV
, IGS_AD_LOCATION_ALL L
, IGS_EN_ATD_MODE_ALL ATM
, IGS_EN_ATD_TYPE_ALL ATT
, IGS_CA_INST_ALL CI
, IGS_CA_INST_ALL CI1
, IGS_CA_DA ICD
WHERE POD.ADM_CAL_TYPE = CI.CAL_TYPE
AND POD.ADM_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND POD.ACAD_CAL_TYPE = CI1.CAL_TYPE(+)
AND POD.SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER (+)
AND POD.COURSE_CD = PSV.COURSE_CD(+)
AND POD.VERSION_NUMBER = PSV.VERSION_NUMBER(+)
AND POD.ADMISSION_CAT = AC.ADMISSION_CAT
AND POD.LOCATION_CD = L.LOCATION_CD(+)
AND POD.DT_ALIAS = ICD.DT_ALIAS
AND POD.ATTENDANCE_MODE = ATM.ATTENDANCE_MODE(+)
AND POD.ATTENDANCE_TYPE = ATT.ATTENDANCE_TYPE(+) WITH READ ONLY