Results for “igs_uc_ref_off_abrv_u1”

6 results




Overview
Explore in AI Chat

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

Overview

The table IGS.IGS_UC_REF_OFF_ABRV is a reference data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, residing in the IGS schema (the legacy UK Universities and Colleges Admissions Service, or UCAS, integration schema). It holds the list of UCAS offer abbreviations used to standardize offer conditions and decisions passed between Oracle Student System and the UCAS admissions service. The table synchronizes with the external UCAS view cvRefOfferAbbrev and is also consumed by the UCAS view uvOfferAbbrev, functioning as a cached, locally maintained mirror of controlled abbreviation codes.

The registered FND Design Data reference is IGS.IGS_UC_REF_OFF_ABRV, and the object status is VALID. Storage is allocated in the APPS_TS_TX_DATA tablespace with PCT Free 10. Based on the heuristic Data Vault classification mined from its foreign key structure, this object is hub-leaning: it behaves as a stable reference hub of abbreviation codes that dependent transactional tables link back to, rather than a fast-changing satellite of descriptive attributes.

Key Information Stored

The table carries 18 documented columns. The surrogate/business primary key is ABBREV_CODE (VARCHAR2), which uniquely identifies each offer abbreviation. The unique index IGS_UC_REF_OFF_ABRV_U1 on (ABBREV_CODE, DELETED) acts as the business-key candidate and enforces uniqueness across the soft-delete flag.

  • ABBREV_CODE — the offer abbreviation code and primary key.
  • ABBREV_TEXT (VARCHAR2, 250) — the abbreviation description, synchronized with UCAS views uvOfferAbbrev and cvRefOfferAbbrev.
  • SUMMARY_CHAR — a summary-of-conditions character, synchronized with the same UCAS views.
  • UNCOND, WITHDRAWAL, RELEASE — flags (Y/N) indicating validity for unconditional offers, withdrawal decisions, and release into Clearing respectively.
  • TARIFF — indicates whether the abbreviation is valid for use in Tariff Offers.
  • UV_UPDATER (VARCHAR2, 20) — synchronizes with the UCAS uvOfferAbbrev.Updater value.
  • UV_TIMESTAMP (DATE) — synchronization timestamp, now marked obsolete.
  • IMPORTED and SENT_TO_UCAS — indicate whether the record was imported from UCAS or sent to UCAS.
  • DELETED — marks the row for deletion (Y/N).
  • LETTER_FORMAT — documented as "No Longer Used"; retained for backward compatibility only.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

The table is queried whenever offer conditions or decisions are validated against UCAS-defined abbreviations. A typical reporting query lists all live abbreviations valid for unconditional offers:

  • SELECT ABBREV_CODE, ABBREV_TEXT, SUMMARY_CHAR FROM IGS.IGS_UC_REF_OFF_ABRV WHERE UNCOND = 'Y' AND DELETED = 'N';
  • Clearing-release reporting: ... WHERE RELEASE = 'Y' AND DELETED = 'N';
  • Tariff validation: ... WHERE TARIFF = 'Y';
  • Reconciliation against UCAS: filter on IMPORTED, SENT_TO_UCAS, or UV_UPDATER to identify unsynchronized rows.

Because LETTER_FORMAT is flagged "No Longer Used," it should be excluded from new development; its presence is a common search result artifact for users searching "letter_format."

Related Objects

The principal dependent object is IGS_UC_COND_DETAILS, whose ABBREVIATION column has a foreign key referencing this table, joining on ABBREV_CODE. This makes IGS_UC_COND_DETAILS the primary consumer of abbreviation definitions for offer conditions. The UCAS integration views uvOfferAbbrev and cvRefOfferAbbrev provide the external synchronization surface. Internally, the unique index IGS_UC_REF_OFF_ABRV_U1 and primary key IGS_UC_REF_OFF_ABRV_PK support lookups. Any UCAS offer or decision process that resolves condition codes ultimately depends on this reference hub.