Search Results igs_ad_ou_stat

Overview

The IGS_AD_OU_STAT table is a core data definition table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Student System (IGS) module. Its primary role is to define and manage user-configured admission outcome statuses for student applications. It acts as a mapping layer, allowing institutions to create their own descriptive status codes (e.g., "Conditional Offer," "Firm Rejection") that correspond to underlying system-defined admission outcome statuses. This provides flexibility in tailoring the application process to institutional terminology and workflows. It is critical to note that the IGS module is marked as "Obsolete" in the provided ETRM documentation, indicating it is a legacy component that may be superseded in future releases or cloud offerings.

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 essential structure. The central column is ADM_OUTCOME_STATUS, which serves as the table's primary key (IGS_AD_OU_STAT_PK). This column stores the unique code for each user-defined admission outcome status. Based on its described purpose, the table likely contains additional columns to describe each status, such as a description field, an effective date range (START_DATE, END_DATE), and a column to map the user-defined status to an internal system status. The integrity of these status codes is enforced by the primary key constraint and is referenced by several other tables in the admissions process.

Common Use Cases and Queries

The primary use case for this table is to support the configuration and reporting of application outcomes. Administrators use it to set up the valid set of decision statuses available to admissions officers. Common reporting queries would involve joining IGS_AD_OU_STAT to application transaction tables to analyze decision trends. For example, a query to list all applications with a specific outcome would join through the ADM_OUTCOME_STATUS key. A typical SQL pattern to retrieve all active user-defined statuses might resemble: SELECT adm_outcome_status, description FROM igs_ad_ou_stat WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE) ORDER BY 1;. Furthermore, the table is essential for data validation, ensuring that outcome statuses recorded in application records are restricted to the predefined set in this control table.

Related Objects

The IGS_AD_OU_STAT table is a referenced parent table for several key entities in the Student System, as evidenced by its foreign key relationships. The most direct relationship is with the IGS_AD_PS_APPL_INST_ALL table, which stores application instances, linking each to its final outcome status. It is also referenced by IGS_AD_DFLT_OUDTLS (likely default outcome details), IGS_UC_MAP_OUT_STAT (for mapping outcomes), and the IGS_UC_DEFAULTS table multiple times. The references in IGS_UC_DEFAULTS are particularly notable, linking to columns for specific system status types like OBSOLETE_OUTCOME_STATUS, PENDING_OUTCOME_STATUS, and REJECTED_OUTCOME_STATUS, highlighting its role in configuring system behavior for the admissions lifecycle.