Results for “ucas_course_long_title”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGSFV_UC_COURSE_VAC_OPTIONS is a full (non-incremental) view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to expose course vacancy option information used in the UCAS clearing process, presenting a denormalised, reporting-ready projection of vacancy status, course descriptors, and institutional reference data. In EBS 12.1.1 and 12.2.2 the object carries a status of VALID and is defined with a WITH READ ONLY clause, confirming it is intended purely for query and reporting access rather than for DML. Because it consolidates UCAS-facing identifiers with internal OSS program, attendance, and institution attributes, it serves as a convenient single source for clearing vacancy extracts and operational enquiries.

Underlying Base Objects

The view is built over seven IGS tables joined in a single SELECT statement:

• IGS_UC_CRSE_VAC_OPS (CR) — the driving table holding course vacancy option records.
• IGS_UC_CRSE_DETS (FT1) — UCAS course detail, joined on program code, institute, campus, and system code.
• IGS_UC_DEFAULTS (FT2) — UCAS system defaults, joined on system code.
• IGS_UC_COM_INST (FT3) — institution reference data, joined on institute.
• IGS_PS_VER_ALL (FT4) — OSS program version details, outer-joined on program code and version.
• IGS_EN_ATD_TYPE_ALL (FT5) — attendance type reference, outer-joined.
• IGS_EN_ATD_MODE_ALL (FT6) — attendance mode reference, outer-joined.

The first three joins are mandatory inner joins; the program version, attendance type, and attendance mode joins use the Oracle outer-join operator (+), so vacancy rows are retained even where the corresponding OSS reference data is absent.

Key Columns

• UCAS_PROGRAM_CODE, UCAS_INSTITUTE_CODE, UCAS_CAMPUS_CODE, UCAS_SYSTEM_CODE, OPTION_CODE — UCAS clearing identifiers for the vacancy option.
• CLEARING_UPDATED, CLEARING_UPDATED_DATE — the clearing update flag and its timestamp (CL_UPDATED / CL_DATE).
• VACANCY_STATUS and VACANCY_STATUS_DESC — the status code plus a flexfield-driven description derived from IGS_LOOKUP_VALUES (IGS_UC_VAC_STATUS).
• SENT_TO_UCAS — indicator of transmission to the UCAS system.
• UCAS_COURSE_SHORT_TITLE, UCAS_COURSE_LONG_TITLE — course titles from the UCAS course detail table.
• OSS_PROGRAM_CODE, OSS_PROGRAM_VERSION, OSS_LOCATION_CODE, OSS_ATTENDANCE_TYPE, OSS_ATTENDANCE_MODE — internal program and attendance attributes.
• CLEARING_OPTIONS_FLAG — clearing options indicator.
• UCAS_SYSTEM_NAME, UCAS_SYSTEM_DESCRIPTION, UCAS_INSTITUTION_ABBREVIATION, UCAS_INSTITUTION_NAME — system and institution descriptive data.
• OSS_PROGRAM_TITLE, OSS_PROGRAM_SHORT_TITLE, OSS_ATTENDANCE_TYPE_DESC, OSS_ATTENDANCE_MODE_DESC — descriptive OSS attributes.
• UPDATER_IDENTIFIER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard audit columns.

Common Use Cases and Queries

Typical scenarios include clearing vacancy monitoring, UCAS submission reconciliation, and institution-level reporting. A representative query lists vacancy options for a given program code:

SELECT ucas_program_code, ucas_campus_code, vacancy_status, vacancy_status_desc, sent_to_ucas, ucas_course_short_title FROM apps.igsfv_uc_course_vac_options WHERE ucas_program_code = :p_program_code ORDER BY ucas_campus_code;

Filtering to items awaiting transmission to UCAS:

SELECT ucas_program_code, option_code, clearing_updated_date FROM apps.igsfv_uc_course_vac_options WHERE sent_to_ucas = 'N';

Because the view is read-only and consolidates lookup, reference, and program data, it is well suited to ad-hoc enquiry, Discoverer/BI Publisher reports, and clearing extract programs across both 12.1.1 and 12.2.2 releases.