Results for “igs_ad_ofr_resp_stat”

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

Overview

IGS_AD_OFR_RESP_STAT is a reference (lookup) table within the Oracle EBS Student System (IGS) product family, which Oracle classifies as obsolete in Release 12.1.1 and 12.2.2. The table describes user-defined admission offer response statuses and, critically, maps each user-defined status to a corresponding system admission offer response status. The table is owned by the IGS schema and, per ETRM documentation, is not implemented in the reference database, meaning it exists as part of the legacy data model rather than an active seeded object.

The primary key is IGS_AD_OFR_RESP_STAT_PK, defined on the ADM_OFFER_RESP_STATUS column. Relationship metadata classifies this object as hub-leaning in a Data Vault heuristic model. In practice, this means the table behaves as a business-key hub: its primary key is a stable, non-surrogate business identifier (the offer response status code) rather than a system-generated sequence, and downstream tables reference it directly through that code. Institutions that implemented the IGS admission offer workflow should treat this as the authoritative definition list for admission offer response statuses.

Key Information Stored

The table contains 10 documented columns. The most significant are:

• ADM_OFFER_RESP_STATUS — The primary key and business-key column. A unique index, IGS_AD_OFR_RESP_STAT_U1, enforces uniqueness on this single column, making it the sole documented business-key candidate.
• DESCRIPTION — The user-visible name or description of the user-defined offer response status.
• S_ADM_OFFER_RESP_STATUS — The system-defined offer response status to which the user-defined status maps. This is the core mapping attribute of the table.
• SYSTEM_DEFAULT_IND — Indicator identifying whether the row is the system default status.
• CLOSED_IND — Indicator denoting whether the response status represents a closed (terminal) state for the admission offer response cycle.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS WHO columns providing audit lineage for each row.

Because the primary key is the business code itself, there is no separate surrogate key column. Application logic resolves statuses by joining on ADM_OFFER_RESP_STATUS rather than on an internal numeric ID.

Common Use Cases and Queries

The principal use of this table is decoding offer response status values stored on applicant instance records and cross-referencing institution-specific statuses against Oracle-delivered system statuses. A typical lookup query is:

• Listing all defined statuses with their system mapping: SELECT ADM_OFFER_RESP_STATUS, DESCRIPTION, S_ADM_OFFER_RESP_STATUS FROM IGS_AD_OFR_RESP_STAT ORDER BY ADM_OFFER_RESP_STATUS;
• Identifying terminal statuses for funnel reporting: filter on CLOSED_IND = 'Y' to isolate statuses that close an applicant's offer response.
• Finding the default status: filter on SYSTEM_DEFAULT_IND = 'Y'.
• Validating user-defined statuses against system statuses by comparing ADM_OFFER_RESP_STATUS and S_ADM_OFFER_RESP_STATUS, useful when auditing mapping completeness after an upgrade.
• Admissions reporting that aggregates applicants by response status, joining IGS_AD_PS_APPL_INST_ALL to this table on ADM_OFFER_RESP_STATUS to obtain descriptive labels.

Because the object is obsolete and not implemented in the reference database, these queries apply only to installations where the legacy IGS admission workflow was deployed.

Related Objects

Two documented foreign keys reference this table, establishing it as a parent in both relationships:

• IGS_AD_PS_APPL_INST_ALL — References IGS_AD_OFR_RESP_STAT through IGS_AD_PS_APPL_INST_ALL.ADM_OFFER_RESP_STATUS. This is the principal consumer, storing the admission offer response status against each applicant instance. Join on IGS_AD_PS_APPL_INST_ALL.ADM_OFFER_RESP_STATUS = IGS_AD_OFR_RESP_STAT.ADM_OFFER_RESP_STATUS.
• IGS_UC_MAP_OFF_RESP — References IGS_AD_OFR_RESP_STAT through IGS_UC_MAP_OFF_RESP.ADM_OFFER_RESP_STATUS. This table provides the UCAS-style mapping layer, joining on the same ADM_OFFER_RESP_STATUS column.

These two child tables represent the full documented dependency surface: one operational (applicant instance status) and one mapping-oriented (offer response mapping). No views or PL/SQL APIs are documented in the supplied metadata.