[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Full View for Course Vacancy Options |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CR.UCAS_PROGRAM_CODE UCAS_PROGRAM_CODE
, CR.INSTITUTE UCAS_INSTITUTE_CODE
, CR.UCAS_CAMPUS UCAS_CAMPUS_CODE
, CR.SYSTEM_CODE UCAS_SYSTEM_CODE
, CR.OPTION_CODE OPTION_CODE
, CR.CL_UPDATED CLEARING_UPDATED
, CR.CL_DATE CLEARING_UPDATED_DATE
, CR.VACANCY_STATUS VACANCY_STATUS
, '_LA:CR.VACANCY_STATUS:IGS_LOOKUP_VALUES:IGS_UC_VAC_STATUS:MEANING' "_LA:VACANCY_STATUS_DESC"
, CR.SENT_TO_UCAS SENT_TO_UCAS
, FT1.SHORT_TITLE UCAS_COURSE_SHORT_TITLE
, FT1.LONG_TITLE UCAS_COURSE_LONG_TITLE
, FT1.OSS_PROGRAM_CODE OSS_PROGRAM_CODE
, FT1.OSS_PROGRAM_VERSION OSS_PROGRAM_VERSION
, FT1.OSS_LOCATION OSS_LOCATION_CODE
, FT1.OSS_ATTENDANCE_TYPE OSS_ATTENDANCE_TYPE
, FT1.OSS_ATTENDANCE_MODE OSS_ATTENDANCE_MODE
, FT1.CLEARING_OPTIONS CLEARING_OPTIONS_FLAG
, FT2.NAME UCAS_SYSTEM_NAME
, FT2.DESCRIPTION UCAS_SYSTEM_DESCRIPTION
, FT3.INST_CODE UCAS_INSTITUTION_ABBREVIATION
, FT3.INST_NAME UCAS_INSTITUTION_NAME
, FT4.TITLE OSS_PROGRAM_TITLE
, FT4.SHORT_TITLE OSS_PROGRAM_SHORT_TITLE
, FT5.DESCRIPTION OSS_ATTENDANCE_TYPE_DESC
, FT6.DESCRIPTION OSS_ATTENDANCE_MODE_DESC
, CR.UPDATER UPDATER_IDENTIFIER
, CR.CREATED_BY CREATED_BY
, CR.CREATION_DATE CREATION_DATE
, CR.LAST_UPDATED_BY LAST_UPDATED_BY
, CR.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_UC_CRSE_VAC_OPS CR
, IGS_UC_CRSE_DETS FT1
, IGS_UC_DEFAULTS FT2
, IGS_UC_COM_INST FT3
, IGS_PS_VER_ALL FT4
, IGS_EN_ATD_TYPE_ALL FT5
, IGS_EN_ATD_MODE_ALL FT6
WHERE CR.UCAS_PROGRAM_CODE = FT1.UCAS_PROGRAM_CODE
AND CR.INSTITUTE = FT1.INSTITUTE
AND CR.UCAS_CAMPUS = FT1.UCAS_CAMPUS
AND CR.SYSTEM_CODE = FT1.SYSTEM_CODE
AND CR.SYSTEM_CODE = FT2.SYSTEM_CODE
AND CR.INSTITUTE = FT3.INST
AND FT1.OSS_PROGRAM_CODE = FT4.COURSE_CD(+)
AND FT1.OSS_PROGRAM_VERSION = FT4.VERSION_NUMBER(+)
AND FT1.OSS_ATTENDANCE_TYPE = FT5.ATTENDANCE_TYPE(+)
AND FT1.OSS_ATTENDANCE_MODE = FT6.ATTENDANCE_MODE(+) WITH READ ONLY