Search Results igs_ad_ofrdfrmt_stat_pk

Overview

The IGS.IGS_AD_OFRDFRMT_STAT table is a reference (lookup) table within the Oracle EBS Student System (IGS) product family. As documented in the ETRM repository for releases 12.1.1 and 12.2.2, it "describes user-defined admission offer deferment statuses, which map to system admission offer deferment statuses." The table therefore serves as the configurable vocabulary that institutions use to label how an admission offer deferment is progressing, while preserving a link back to the seeded, system-delivered status values. This design allows an institution to rename or extend deferment statuses for operational and reporting purposes without altering the underlying system semantics that the application's processing logic depends upon.

Because the table acts as the parent of a foreign-key relationship from the applicant instance data, it is best understood as a source of controlled reference values rather than transactional data. In Data Vault terms, the metadata classification heuristically identifies this object as hub-leaning: it holds a stable, unique business key with descriptive attributes, making it a candidate for modeling as a hub (or a small reference table) with its descriptive columns treated as satellite attributes.

Key Information Stored

The table exposes ten documented columns. The most significant are summarized below.

• ADM_OFFER_DFRMNT_STATUS — The primary key column and the business key of the table (both IGS_AD_OFRDFRMT_STAT_PK and the unique index IGS_AD_OFRDFRMT_STAT_U1 are defined on it). It holds the code identifying the user-defined offer deferment status.
• DESCRIPTION — The descriptive text associated with the status code, used for display and reporting.
• S_ADM_OFFER_DFRMNT_STATUS — The corresponding system-level (seeded) deferment status, enabling the mapping between user-defined and system statuses described in the object definition.
• SYSTEM_DEFAULT_IND — Indicates whether the row represents a system-delivered default status.
• CLOSED_IND — Indicates whether the status is considered closed, i.e., no longer active for selection.
• CREATED_BY, CREATION_DATE — Standard audit columns recording the creating user and timestamp.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns capturing the most recent modification user, timestamp, and login.

Common Use Cases and Queries

Typical usage centers on validating, decoding, and reporting offer deferment statuses. A common validation query checks whether a status is active before it is assigned:

• List active, user-defined statuses with their system mapping: SELECT ADM_OFFER_DFRMNT_STATUS, DESCRIPTION, S_ADM_OFFER_DFRMNT_STATUS FROM IGS.IGS_AD_OFRDFRMT_STAT WHERE NVL(CLOSED_IND,'N') = 'N';
• Identify system defaults: WHERE SYSTEM_DEFAULT_IND = 'Y'.
• Decode a status on an applicant record by joining to IGS_AD_PS_APPL_INST_ALL on the status column.

Reporting scenarios include status distribution for admissions dashboards, auditing user-defined versus system statuses, and assessing audit-trail integrity via the LAST_UPDATED_BY and LAST_UPDATE_DATE columns.

Related Objects

The FK/PK relationship data identifies the following as the primary dependent object:

• IGS_AD_PS_APPL_INST_ALL — References this table through its column ADM_OFFER_DFRMNT_STATUS, joining on the same column name. This is the principal transactional consumer of the reference data.
• IGS_AD_OFRDFRMT_STAT_PK and IGS_AD_OFRDFRMT_STAT_U1 — The primary key and unique index that enforce the business key uniqueness of ADM_OFFER_DFRMNT_STATUS.

Additional integration is typically achieved through the related Student System admission offer and applicant instance APIs and views, which read these status codes during deferment processing.