Results for “igs_uc_crse_keywrds”

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

Overview

IGS.IGS_UC_CRSE_KEYWRDS is a transactional table within the Oracle E-Business Suite Student System (IGS) product family. It stores the keywords that are associated with a course for a given UCAS (Universities and Colleges Admissions Service) admission cycle. UCAS is the centralised admissions service through which applicants apply to higher-education programmes in the United Kingdom, and the keyword records held here support the publication and synchronisation of course-level descriptive terms to UCAS. The object synchronises with the UCAS view uvCourseKeyword, which confirms its role as a staging and interoperability structure between the institution's course catalogue and the external UCAS data exchange.

From a modelling perspective, the heuristic Data Vault classification mined from the foreign-key structure is link. This is a reasonable suggestion: the table connects a UCAS course definition to a reference keyword, rather than acting as a standalone hub of business entities or a pure descriptive satellite. Practitioners designing a Data Vault representation of IGS data may therefore treat it as an associative (link) construct that resolves the many-to-many style relationship between courses and keywords.

Key Information Stored

The table is documented with 18 columns on ETRM 12.1.1. The most significant are summarised below.

• CRSE_KEYWORD_ID — the surrogate primary key, enforced by the unique index IGS_UC_CRSE_KEYWRDS_PK. It uniquely identifies each course-keyword association.
• UCAS_PROGRAM_CODE, INSTITUTE, UCAS_CAMPUS, OPTION_CODE, KEYWORD — together these form the business-key candidate enforced by unique index IGS_UC_CRSE_KEYWRDS_U1. They identify the specific UCAS programme, the delivering institute, the campus, the option within the programme, and the keyword applied.
• KEYWORD — holds the keyword value itself and is a foreign key to IGS_UC_REF_KEYWORDS, ensuring only reference-validated keywords are linked.
• PREFERENCE — indicates the ordering or priority of the keyword where multiple keywords are attached to the same course.
• SYSTEM_CODE — a foreign key to IGS_UC_CRSE_DETS, linking the keyword record to its parent UCAS course detail record.
• ACTIVE, DELETED, SENT_TO_UCAS — status flags controlling the lifecycle and the transmission state of the record to UCAS.
• DATETIMESTAMP — the timestamp associated with the UCAS record.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns and UPDATER for the updating actor.

Common Use Cases and Queries

Typical uses include confirming which keywords are published for a course, auditing what has been transmitted to UCAS, and reconciling IGS course data against the UCAS inbound view. A representative query joins the parent course detail and the keyword reference:

• SELECT k.UCAS_PROGRAM_CODE, k.INSTITUTE, k.UCAS_CAMPUS, k.OPTION_CODE, r.KEYWORD, k.PREFERENCE, k.SENT_TO_UCAS FROM IGS.IGS_UC_CRSE_KEYWRDS k, IGS.IGS_UC_REF_KEYWORDS r WHERE k.KEYWORD = r.KEYWORD AND k.SYSTEM_CODE = :p_system_code AND NVL(k.DELETED,'N') = 'N' ORDER BY k.PREFERENCE;
• Reporting of untransmitted rows: filter on SENT_TO_UCAS = 'N' AND ACTIVE = 'Y' to identify data awaiting extraction.
• Keyword frequency analysis by programme, joining to IGS_UC_CRSE_DETS on SYSTEM_CODE.

Related Objects

The most significant related objects, derived from documented foreign-key and primary-key relationships, are:

• IGS_UC_CRSE_DETS — parent course detail table; joined on SYSTEM_CODE (and shares the programme/institute/campus columns).
• IGS_UC_REF_KEYWORDS — reference table of valid keywords; joined on KEYWORD.
• UCAS view uvCourseKeyword — external view with which this table synchronises.
• The unique indexes IGS_UC_CRSE_KEYWRDS_PK and IGS_UC_CRSE_KEYWRDS_U1, which expose the surrogate and business keys respectively.