[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Full View for UCAS Course Details Table |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CR.UCAS_PROGRAM_CODE UCAS_COURSE_CODE
, CR.OSS_PROGRAM_CODE OSS_PROGRAM_CODE
, CR.OSS_PROGRAM_VERSION OSS_PROGRAM_VERSION
, CR.INSTITUTE UCAS_INSTITUTE_CODE
, CR.UVCOURSE_UPDATER UCAS_UVCOURSE_UPDATER
, CR.UVCRSEVAC_UPDATER UCAS_UVCOURSEVACANCY_UPDATER
, CR.SHORT_TITLE UCAS_COURSE_SHORT_TITLE
, CR.LONG_TITLE UCAS_COURSE_LONG_TITLE
, CR.UCAS_CAMPUS UCAS_CAMPUS
, CR.OSS_LOCATION OSS_LOCATION
, CR.FACULTY UCAS_FACULTY
, CR.TOTAL_NO_OF_SEATS TOTAL_NUMBER_OF_SEATS
, CR.MIN_ENTRY_POINTS MIN_ENTRY_POINTS
, CR.MAX_ENTRY_POINTS MAX_ENTRY_POINTS
, CR.CURRENT_VALIDITY CURRENT_VALIDITY
, CR.DEFERRED_VALIDITY DEFERRED_VALIDITY
, CR.TERM_1_START TERM_1_START_DATE
, CR.TERM_1_END TERM_1_END_DATE
, CR.TERM_2_START TERM_2_START_DATE
, CR.TERM_2_END TERM_2_END_DATE
, CR.TERM_3_START TERM_3_START_DATE
, CR.TERM_3_END TERM_3_END_DATE
, CR.TERM_4_START TERM_4_START_DATE
, CR.TERM_4_END TERM_4_END_DATE
, CR.CL_UPDATED CLEARING_UPDATED_FLAG
, CR.CL_DATE CLEARING_UPDATED_DATE
, CR.VACANCY_STATUS VACANCY_STATUS
, CR.NO_OF_VACANCY NUMBER_OF_VACANCIES
, CR.SCORE SCORE
, CR.RB_FULL ROUTE_B_FULL
, CR.SCOT_VAC SCOTTISH_VACANCY
, CR.SENT_TO_UCAS SENT_TO_UCAS_FLAG
, CR.OSS_ATTENDANCE_TYPE OSS_ATTENDANCE_TYPE
, CR.OSS_ATTENDANCE_MODE OSS_ATTENDANCE_MODE
, CR.JOINT_ADMISSION_IND JOINT_ADMISSION_INDICATOR
, CR.OPEN_EXTRA_IND OPEN_EXTRA_INDICATOR
, CR.CLEARING_OPTIONS CLEARING_OPTIONS_FLAG
, CR.IMPORTED IMPORTED_FLAG
, CR.KEYWRDS_CHANGED KEYWORDS_CHANGED_FLAG
, CR.SYSTEM_CODE UCAS_SYSTEM_CODE
, DE.NAME UCAS_SYSTEM_NAME
, DE.DESCRIPTION UCAS_SYSTEM_DESCRIPTION
, CO.INST_CODE UCAS_INSTITUTION_ABBREVIATION
, CO.INST_NAME UCAS_INSTITUTION_NAME
, VE.TITLE OSS_PROGRAM_TITLE
, VE.SHORT_TITLE OSS_PROGRAM_SHORT_TITLE
, TY.DESCRIPTION OSS_ATTENDANCE_TYPE_DESC
, MO.DESCRIPTION OSS_ATTENDANCE_MODE_DESC
, 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_DETS CR
, IGS_UC_DEFAULTS DE
, IGS_UC_COM_INST CO
, IGS_PS_VER_ALL VE
, IGS_EN_ATD_TYPE_ALL TY
, IGS_EN_ATD_MODE_ALL MO
WHERE CR.SYSTEM_CODE = DE.SYSTEM_CODE
AND CR.INSTITUTE = CO.INST
AND CR.OSS_PROGRAM_CODE = VE.COURSE_CD (+)
AND CR.OSS_PROGRAM_VERSION = VE.VERSION_NUMBER (+)
AND CR.OSS_ATTENDANCE_TYPE = TY.ATTENDANCE_TYPE (+)
AND CR.OSS_ATTENDANCE_MODE = MO.ATTENDANCE_MODE (+) WITH READ ONLY