Results for “igs_uc_ref_awrdbdy”

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

Overview

IGS_UC_REF_AWRDBDY is a reference table in the Oracle E-Business Suite Student System (IGS) product family. It holds the list of examining or awarding boards associated with subjects, and its principal functional role is to link those awarding bodies to examination results. The table is one of the interface artifacts used by the UK UCAS integration layer, and Oracle documents it as synchronizing with the UCAS view cvRefAwardBody. The object resides in the IGS schema and is marked VALID in the ETRM 12.1.1 physical schema, where eleven columns are documented.

From a dimensional modeling perspective, the mined Data Vault classification is hub-leaning. This is a heuristic suggestion rather than a declared property: the table carries a composite unique business key and is referenced by a dependent child table, which is characteristic of a hub entity that anchors a stable set of business keys. Because the table also carries descriptive attributes such as BODY_NAME and BODY_ABBREV, it behaves as a hybrid hub with satellite-like descriptive columns, and implementers modeling the UCAS interface should treat it accordingly.

Key Information Stored

The most significant columns are the following:

• AWARDING_BODY — the identifier of the examining or awarding board. This column participates in the primary key, the unique business key, and the inbound foreign key from IGS_UC_COM_EBL_SUBJ.
• SITTING — the examination sitting to which the awarding body record applies. Also part of the composite key.
• YEAR — the academic or examination year qualifying the sitting. Together with AWARDING_BODY and SITTING it forms the full primary key.
• BODY_NAME — the descriptive name of the awarding body, used for display and reporting.
• BODY_ABBREV — the abbreviated form of the awarding body name, typically used in extracts and reconciliation output.
• IMPORTED — a flag indicating whether the row was loaded by the UCAS import process or created natively, which supports data lineage and troubleshooting.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS who-columns providing auditability and concurrency context.

The surrogate primary key is the constraint IGS_UC_REF_AWRDBDY_PK, defined over (AWARDING_BODY, SITTING, YEAR). A second unique index, IGS_UC_REF_AWRDBDY_U1, is documented over the same three columns and is therefore the confirmed business-key candidate. Because the primary key and the unique index cover identical column sets, the table has no separate single-column surrogate; the composite key serves both purposes.

Common Use Cases and Queries

The table is principally consumed during UCAS import processing and results handling. Typical scenarios include validating that an awarding body submitted in an application or result file exists for the relevant year and sitting, producing reference listings for examination boards, and joining board descriptions to result records.

A standard validation query checks existence of a board for a given key:

• SELECT AWARDING_BODY, BODY_NAME, BODY_ABBREV FROM IGS.IGS_UC_REF_AWRDBDY WHERE AWARDING_BODY = :p_body AND SITTING = :p_sitting AND YEAR = :p_year;

A reporting query resolves subject-level boards to names through the dependent table:

• SELECT s.AWARDING_BODY, r.BODY_NAME, s.SITTING, s.YEAR FROM IGS.IGS_UC_COM_EBL_SUBJ s, IGS.IGS_UC_REF_AWRDBDY r WHERE s.AWARDING_BODY = r.AWARDING_BODY AND s.SITTING = r.SITTING AND s.YEAR = r.YEAR;

A reconciliation query identifies rows loaded from UCAS rather than maintained locally:

• SELECT AWARDING_BODY, SITTING, YEAR, BODY_NAME FROM IGS.IGS_UC_REF_AWRDBDY WHERE IMPORTED = 'Y' ORDER BY YEAR, SITTING, AWARDING_BODY;

Related Objects

The documented referential relationships for this table are as follows:

• IGS_UC_COM_EBL_SUBJ — the dependent table. Its AWARDING_BODY, SITTING, and YEAR columns form a foreign key referencing IGS_UC_REF_AWRDBDY. It is the primary consumer of the reference data.
• IGS_UC_REF_AWRDBDY_PK — the primary key constraint over (AWARDING_BODY, SITTING, YEAR).
• IGS_UC_REF_AWRDBDY_U1 — the unique index over the same business-key columns.
• UCAS view cvRefAwardBody — the external UCAS reference view with which this table is synchronized during import.

Beyond these documented objects, functional integration with the wider UCAS interface is implied by the naming convention shared with other IGS_UC tables. Any customization, extract, or interface program that resolves awarding body codes to descriptions for results processing should treat this table as the authoritative reference and honor the year and sitting qualification embedded in its primary key.