Search Results igs_ad_cndnl_ofrstat




Overview
Explore in AI Chat

Overview

The IGS_AD_CNDNL_OFRSTAT table is a core reference table within the Oracle E-Business Suite Student System (IGS) module. It serves as a critical configuration point for managing the admissions lifecycle. Specifically, this table stores user-defined statuses for conditional offers of admission, which are then mapped to underlying system-defined statuses. This design provides institutions with the flexibility to customize the terminology and workflow of conditional offer stages (e.g., "Pending Conditions," "Conditions Met," "Conditions Lapsed") to match their internal processes, while maintaining a consistent system-level logic for application processing. Its role is to act as the master source for all valid conditional offer status codes used throughout the admissions subsystem.

Key Information Stored

The table's primary function is to maintain the mapping between user-configured and system statuses. The most critical column is ADM_CNDTNL_OFFER_STATUS, which serves as the table's primary key. This column holds the unique code for each user-defined conditional offer status. While the provided ETRM metadata does not list all columns, a table of this nature typically includes descriptive fields such as a status description, an effective date range (START_DATE, END_DATE), and a column storing the corresponding internal system status code to which the user-defined status maps. The existence of a primary key constraint (IGS_AD_CNDNL_OFRSTAT_PK) on the ADM_CNDTNL_OFFER_STATUS column enforces data integrity and uniqueness for these status codes.

Common Use Cases and Queries

This table is primarily referenced in transactional and reporting contexts related to applicant conditional offers. Common use cases include configuring available statuses in the application interface, updating an applicant's conditional offer status, and generating reports on the pipeline of conditional offers. A frequent query pattern involves joining this table to application detail tables to retrieve the human-readable status description for reporting.

  • Retrieving All Active Conditional Offer Statuses: SELECT adm_cndtnal_offer_status FROM igs_ad_cndnl_ofrstat WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);
  • Reporting on Applications with Conditional Offers: SELECT a.application_number, s.adm_cndtnl_offer_status FROM igs_ad_ps_appl_inst_all a JOIN igs_ad_cndnl_ofrstat s ON a.adm_cndtnl_offer_status = s.adm_cndtnl_offer_status;

Related Objects

The IGS_AD_CNDNL_OFRSTAT table is centrally linked to key transactional tables in the Admissions module, as evidenced by its foreign key relationships. It is referenced as a parent table to enforce valid status values in the following objects:

  • IGS_AD_PS_APPL_INST_ALL: This table stores details for individual program applications. Its column IGS_AD_PS_APPL_INST_ALL.ADM_CNDTNL_OFFER_STATUS is a foreign key to IGS_AD_CNDNL_OFRSTAT, ensuring that the conditional offer status assigned to any application instance is a valid, configured status.
  • IGS_AD_DFLT_OUDTLS: This table, which likely holds default outcome details for admissions, also references IGS_AD_CNDNL_OFRSTAT via its column IGS_AD_DFLT_OUDTLS.ADM_CNDTNL_OFFER_STATUS. This relationship ensures default configurations use valid status codes.

These relationships highlight the table's importance in maintaining data integrity across the conditional offer workflow, from default setup to individual application tracking.