Results for “ucas_institute_code”

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

Overview

IGSBV_UC_COURSE_VAC_OPTIONS is a read-only base view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product. Its documented description is "Base View for Course Vacancy Options," and it exposes data required to report on UCAS (Universities and Colleges Admissions Service) course vacancy positions and clearing options. The view is delivered as a read-only construct (its definition terminates with WITH READ ONLY), indicating that it is intended purely for query, reporting, and integration purposes rather than for transactional maintenance. In the context of an EBS 12.1.1 or 12.2.2 implementation, this view is one of several IGSBV (base view) objects that provide UCAS administrators and downstream reporting tools with a denormalised, joined representation of course vacancy records against their corresponding course detail records.

Underlying Base Objects

The view text documents two source tables, both in the UCAS subsystem of the Student System:

• IGS_UC_CRSE_VAC_OPS (aliased CR) — the driving table holding course vacancy option records, including vacancy status, clearing update flags and dates, and the UCAS keys.
• IGS_UC_CRSE_DETS (aliased FT1) — the course details table supplying descriptive attributes such as short and long course titles and OSS (Oracle Student System) program, version, location, and attendance attributes.

The two tables are joined on four columns: UCAS_PROGRAM_CODE, INSTITUTE, UCAS_CAMPUS, and SYSTEM_CODE. This composite join reflects the natural key of a UCAS course record, ensuring that vacancy information is reconciled to exactly one course definition.

Key Columns

• UCAS_PROGRAM_CODE, UCAS_INSTITUTE_CODE, UCAS_CAMPUS_CODE, UCAS_SYSTEM_CODE — the composite UCAS identifier for the course. Note that the underlying column is INSTITUTE, aliased as UCAS_INSTITUTE_CODE.
• OPTION_CODE — identifies the specific vacancy option within the UCAS course.
• VACANCY_STATUS — the coded vacancy status, with a corresponding descriptive column _LA:VACANCY_STATUS_DESC resolved through the IGS_LOOKUP_VALUES lookup type IGS_UC_VAC_STATUS.
• CLEARING_UPDATED / CLEARING_UPDATED_DATE — indicators and timestamps for clearing-related updates.
• SENT_TO_UCAS — flag indicating whether the vacancy information has been transmitted to UCAS.
• UCAS_COURSE_SHORT_TITLE, UCAS_COURSE_LONG_TITLE — descriptive course titles sourced from IGS_UC_CRSE_DETS.
• OSS_PROGRAM_CODE, OSS_PROGRAM_VERSION, OSS_LOCATION_CODE, OSS_ATTENDANCE_TYPE, OSS_ATTENDANCE_MODE — links back to the internal Oracle Student System program structure.
• CLEARING_OPTIONS_FLAG — indicates clearing option availability.
• Audit columns — UPDATER_IDENTIFIER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

Common Use Cases and Queries

Typical usage includes checking which course vacancies have not yet been sent to UCAS, validating vacancy status descriptions, and reconciling UCAS course identifiers against OSS program structures. The following query, tuned to the search term ucas_institute_code, lists vacancy options for a given institute:

SELECT ucas_institute_code, ucas_program_code, ucas_campus_code,
  option_code, vacancy_status, _LA:VACANCY_STATUS_DESC,
  ucas_course_short_title, sent_to_ucas
FROM apps.igsbv_uc_course_vac_options
WHERE ucas_institute_code = :p_institute
ORDER BY ucas_program_code, option_code;

Because the view is defined WITH READ ONLY, no DML should be attempted against it; updates must target the underlying base tables IGS_UC_CRSE_VAC_OPS and IGS_UC_CRSE_DETS. All access is subject to standard APPS schema and MOAC/security profile considerations in EBS 12.1.1 and 12.2.2.