Search Results igs_ad_unit_ou_stat




Overview
Explore in AI Chat

Overview

The IGS_AD_UNIT_OU_STAT table is a core data dictionary table within the Oracle E-Business Suite Student System (IGS). It functions as a configuration and mapping table that defines user-controlled statuses for the outcomes of individual admission units (e.g., specific programs or courses within an application). Its primary role is to provide a flexible layer of user-defined statuses, such as "Unit Approved," "Unit Pending Review," or "Unit Rejected," which are then mapped internally to system-defined admission outcome statuses. This abstraction allows institutions to customize the terminology and workflow of their admission processes while maintaining the integrity of the underlying system logic in both releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is centered on defining and describing these custom status codes. The primary column is ADM_UNIT_OUTCOME_STATUS, which stores the unique code for the user-defined status. While the full column list is not detailed in the provided metadata, typical supporting columns in such configuration tables would include a description field (e.g., DESCRIPTION), an effective dating mechanism (START_DATE, END_DATE), an indicator for the system status it maps to, and standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE). The primary key constraint IGS_AD_UNIT_OU_STAT_PK enforces uniqueness on the ADM_UNIT_OUTCOME_STATUS column, ensuring each custom status code is distinct.

Common Use Cases and Queries

This table is primarily referenced in transactional and reporting contexts related to the detailed tracking of application components. A common use case is generating a report showing the distribution of outcomes across different admission units for a particular intake period. Administrators may also query this table to maintain the list of valid statuses. Sample SQL patterns include joining to the transactional table to list all applications with a specific unit outcome:

  • SELECT a.application_number, u.adm_unit_outcome_status, s.description FROM igs_ad_ps_aplinstunt_all a JOIN igs_ad_unit_ou_stat s ON a.adm_unit_outcome_status = s.adm_unit_outcome_status WHERE a.person_id = :p_id;

Another critical pattern is validating or listing all active user-defined statuses for setup purposes: SELECT adm_unit_outcome_status, description FROM igs_ad_unit_ou_stat WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE) ORDER BY 1;

Related Objects

The table has a defined parent-child relationship with key transactional tables in the admissions module. As per the documented foreign key relationship:

  • IGS_AD_PS_APLINSTUNT_ALL: This is the primary transactional table storing details of individual admission units (or "instances") within an application. Its column ADM_UNIT_OUTCOME_STATUS is a foreign key that references IGS_AD_UNIT_OU_STAT.ADM_UNIT_OUTCOME_STATUS. This enforces data integrity, ensuring that every outcome status recorded against an admission unit in IGS_AD_PS_APLINSTUNT_ALL must be a valid code defined in the IGS_AD_UNIT_OU_STAT lookup table.