Results for “igs_ge_ref_cd”

50+ results




Overview
Explore in AI Chat

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

Overview

IGS_GE_REF_CD is a general-purpose reference code table within the Oracle E-Business Suite Student System (IGS) product family. In the documented ETRM 12.1.1 schema the table is owned by the IGS schema and contains ten columns. Its stated purpose is to hold the reference codes associated with a particular reference code type, making it a central lookup repository for coded values used across student, admissions, and academic records functionality. The table is marked obsolete in the ETRM documentation and is recorded as "Not implemented in this database" for the reference implementation, meaning it should be treated as a legacy or product-specific object that is present only in installations where the Student System module has been deployed.

From a dimensional modeling perspective, the mined Data Vault classification for this object is a hub. This is a suggestion rather than a documented Oracle designation: the table carries a single-column surrogate primary key and a natural business key composed of a type plus a code, which is the classic pattern for a hub that anchors a stable set of business keys referenced by many surrounding satellites and links. Practitioners building a warehouse layer over IGS data should consider mapping REFERENCE_CODE_ID as the hub key and the type/code pair as the business key.

Key Information Stored

The table's identity is defined by two unique indexes. IGS_GE_REF_CD_PK is the primary key on REFERENCE_CODE_ID, the surrogate identifier. IGS_GE_REF_CD_U2 enforces uniqueness on the composite business key (REFERENCE_CD_TYPE, REFERENCE_CD), which is the natural key most consumers should use in joins and lookups.

  • REFERENCE_CODE_ID — the surrogate primary key; used as the foreign key target by dependent tables.
  • REFERENCE_CD_TYPE — the category or classification to which a code belongs; also a foreign key to IGS_GE_REF_CD_TYPE_ALL.
  • REFERENCE_CD — the actual code value within the type; combined with REFERENCE_CD_TYPE forms the unique business key.
  • DESCRIPTION — the human-readable meaning of the code, typically the value displayed in list of values and reports.
  • DEFAULT_FLAG — indicates whether the code is the default selection for its type.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS WHO columns capturing audit and concurrency information.

Common Use Cases and Queries

The dominant use case is decoding stored codes into descriptive text for reporting and user interfaces. A typical join retrieves the description for a code held on a transaction table:

SELECT r.REFERENCE_CD, r.DESCRIPTION FROM IGS_GE_REF_CD r WHERE r.REFERENCE_CD_TYPE = :type AND r.DEFAULT_FLAG = 'Y';

A second common pattern populates a list of values for a given type, ordered by code. A third supports validation, confirming that a supplied type/code pair exists before it is written to a dependent table, using the U2 unique index for efficient lookup. Analysts also use the table to enumerate all valid codes per type for data-quality audits, identifying orphaned or obsolete codes referenced by legacy records.

Related Objects

The table participates in a hub-and-spoke relationship with several IGS transactional and cross-reference tables. The documented foreign keys are as follows.

These dependencies confirm the table's role as a shared reference hub. Any change to a code value propagates through the composite-key relationships into admissions entry-point, unit, unit-requirement, and use-of-code tables, so maintenance should be controlled and audited.