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