Results for “abbrev_code”

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

Overview

IGS_UC_REF_OFF_ABRV is a reference table within the Oracle E-Business Suite IGS (Student System) module. It holds the master list of UCAS (Universities and Colleges Admissions Service) offer abbreviations — the coded shorthand values used to describe the conditions attached to an offer of admission, such as unconditional offers, withdrawal conditions, release terms, and tariff-related notations. The table is designed to synchronize with the external UCAS view cvRefOfferAbbrev and is also consumed by the UCAS-facing view uvOfferAbbrev.

In the ETRM 12.1.1 and 12.2.2 documentation, this object is flagged as part of the IGS - Student System, which is marked obsolete in current releases. It is documented as "Not implemented in this database," meaning the definition is retained for historical and upgrade reference only. Despite this status, the table remains structurally significant for institutions that have not yet decommissioned UCAS-linked admissions processing.

The heuristic Data Vault classification mined from the foreign-key structure is hub-leaning. In Data Vault modeling terms, this suggests IGS_UC_REF_OFF_ABRV behaves as a hub — a stable set of uniquely identifiable business keys (here, the abbreviation code) around which descriptive attributes and downstream transactional relationships are organized. Modelers should treat ABBREV_CODE as the durable business key around which satellite and link structures could be built.

Key Information Stored

The table contains 18 documented columns. The most business-critical are summarized below.

• ABBREV_CODE — The primary key component, defined by the unique index IGS_UC_REF_OFF_ABRV_PK. It is the coded identifier for each offer abbreviation.
• ABBREV_TEXT — The human-readable description of the abbreviation, used in offer displays and admissions reporting.
• LETTER_FORMAT — Controls how the abbreviation is rendered on offer letters, driving correspondence formatting.
• SUMMARY_CHAR — A short summary character used in condensed offer representations.
• UNCOND — Flag indicating whether the abbreviation denotes an unconditional offer.
• WITHDRAWAL — Flag marking abbreviations associated with offer withdrawal conditions.
• RELEASE — Flag denoting release-related offer abbreviations.
• TARIFF — Relates the abbreviation to tariff-point conditions.
• IMPORTED — Indicates whether the record was loaded from the UCAS synchronization process.
• SENT_TO_UCAS — Indicates whether the abbreviation has been transmitted to the UCAS system.
• DELETED — Soft-delete flag, forming part of the unique business-key index IGS_UC_REF_OFF_ABRV_U1 (ABBREV_CODE, DELETED).
• UV_TIMESTAMP, UV_UPDATER — UCAS view synchronization metadata tracking the last external update.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS who-columns providing audit lineage.

The primary key is ABBREV_CODE; the unique business-key candidate is the combination of ABBREV_CODE and DELETED, confirming that soft-deleted rows allow re-use of a code while preserving history.

Common Use Cases and Queries

Typical usage centers on decoding abbreviation codes into readable offer text for admission letters, UCAS submissions, and status reporting. A standard lookup joins the table to condition detail records:

• Decoding offers: SELECT a.abbrev_code, a.abbrev_text FROM igs_uc_ref_off_abrv a WHERE a.deleted = 'N';
• Joining to condition detail: SELECT c.*, a.abbrev_text FROM igs_uc_cond_details c, igs_uc_ref_off_abrv a WHERE c.abbreviation = a.abbrev_code AND a.deleted = 'N';
• Auditing synchronization: SELECT abbrev_code, imported, sent_to_ucas, uv_timestamp FROM igs_uc_ref_off_abrv ORDER BY uv_timestamp DESC;
• Reporting unconditional offers: filtering on UNCOND = 'Y' to tally unconditional admissions.

Reporting use cases include UCAS return files, admissions dashboards, and reconciliation between EBS internal abbreviations and the UCAS reference view. Always filter on DELETED = 'N' unless historical analysis is required.

Related Objects

The following objects are most significant in relation to this table:

• IGS_UC_COND_DETAILS — The primary referencing table. Its column ABBREVIATION is a foreign key to IGS_UC_REF_OFF_ABRV, linking each offer condition to its abbreviation definition.
• cvRefOfferAbbrev
• uvOfferAbbrev — UCAS-facing view that consumes the abbreviation records.
• IGS_UC_REF_OFF_ABRV_PK — Primary key constraint on ABBREV_CODE.
• IGS_UC_REF_OFF_ABRV_U1 — Unique index on (ABBREV_CODE, DELETED), the business-key candidate.

Because the table is documented as obsolete, integrators should verify its physical presence before relying on it in new development, and confirm any UCAS synchronization interfaces remain active in the target environment.