Search Results igs_ad_ofr_resp_stat_pk

Overview

The table IGS_AD_OFR_RESP_STAT is a core data dictionary table within the Oracle E-Business Suite (EBS) Student System (IGS). Its primary function is to define and store user-configured admission offer response statuses. These statuses represent the various actions an applicant can take in response to a formal admission offer, such as accepting, declining, or deferring. Crucially, this table provides a mapping layer, allowing institutions to define their own business-specific status codes that correspond to underlying system-defined statuses within the application logic. This abstraction enables flexible configuration to meet diverse institutional workflows while maintaining system integrity. It is important to note that the IGS Student System module is marked as obsolete in the provided ETRM documentation for EBS 12.1.1 and 12.2.2, indicating it is a legacy component. Furthermore, the documentation explicitly states this specific table was "Not implemented in this database," suggesting it may exist in the data model but is not populated or actively used in a standard deployment.

Key Information Stored

While the specific column list is not detailed in the provided excerpt, the table's primary key and foreign key relationships define its critical data elements. The central column is ADM_OFFER_RESP_STATUS, which serves as the table's primary key (IGS_AD_OFR_RESP_STAT_PK). This column stores the unique code for each user-defined response status. Based on the table's description, it would logically contain additional columns to describe the status (e.g., a description field) and to manage the mapping to the corresponding system status. This mapping is the table's essential purpose, allowing the configured statuses to drive correct application behavior.

Common Use Cases and Queries

The primary use case for this table is to support the configuration and querying of valid applicant responses to admission offers. In operational scenarios, it would be referenced when an applicant submits their decision and when generating reports on offer response rates. A typical query would retrieve the list of active statuses for validation or display in a lookup list. For example:

• SELECT adm_offer_resp_status, description FROM igs_ad_ofr_resp_stat WHERE enabled_flag = 'Y' ORDER BY 1;

Another common pattern involves joining this table to application records to analyze response trends. However, given the "obsolete" and "not implemented" status noted in the documentation, direct operational use in EBS 12.1.1/12.2.2 is unlikely. Its main relevance would be for analyzing legacy data migrations or understanding the historical data model.

Related Objects

The IGS_AD_OFR_RESP_STAT table maintains defined foreign key relationships with other entities in the Student System, as documented in the ETRM. These relationships ensure referential integrity for the ADM_OFFER_RESP_STATUS code.

• IGS_AD_PS_APPL_INST_ALL: This table stores details about program applications. Its column IGS_AD_PS_APPL_INST_ALL.ADM_OFFER_RESP_STATUS is a foreign key referencing IGS_AD_OFR_RESP_STAT.ADM_OFFER_RESP_STATUS. This links an application instance to the specific response status chosen by the applicant.
• IGS_UC_MAP_OFF_RESP: This table appears to be related to mapping or integration processes, potentially for centralized admissions services. Its column IGS_UC_MAP_OFF_RESP.ADM_OFFER_RESP_STATUS is also a foreign key referencing the primary key of IGS_AD_OFR_RESP_STAT, indicating the mapping configuration relies on the valid status codes defined in this master table.