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