[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Base 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
, 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
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 WITH READ ONLY