Search Results igs_ps_unit_stat_pk

Overview

The IGS_PS_UNIT_STAT table is a core reference table within the Oracle E-Business Suite's now-obsolete Student System (IGS). It defines the user-configurable statuses that can be applied to academic units (subjects or courses), such as 'Current', 'Suspended', or 'Discontinued'. Its primary role is to provide a flexible mapping layer between institution-specific status terminology and the underlying system functionality. By allowing administrators to define a wide array of statuses that map back to a smaller set of system statuses, it enables tailored business processes while maintaining consistent system behavior for actions like enrollment, grading, and reporting. The metadata explicitly notes this table was "Not implemented in this database," indicating it may exist in the data model but was not populated or activated in standard deployments of versions 12.1.1 and 12.2.2.

Key Information Stored

Based on the provided structure, the table's central attribute is the UNIT_STATUS column, which serves as the primary key (IGS_PS_UNIT_STAT_PK). This column stores the unique code for each user-defined unit status. While the full column list is not detailed in the excerpt, typical tables of this nature in the Student System would also include descriptive columns such as a description field (e.g., DESCRIPTION), an effective dating column to manage status validity over time, and a mapping column to associate the user-defined status with an internal system status code that controls functional behavior. The existence of a primary key constraint confirms UNIT_STATUS as the unique identifier for all records in this reference entity.

Common Use Cases and Queries

The primary use case is to query the valid set of unit statuses for validation, reporting, and user interface drop-down lists within the Student System modules. For instance, an administrative form for updating a unit's lifecycle state would reference this table to present the allowed options. A common reporting query would join this table to unit version details to categorize units by their operational status. A sample SQL pattern to retrieve all active status definitions might resemble:

• SELECT unit_status, description FROM igs_ps_unit_stat WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);

Given the table's role in mapping to system functionality, another critical use case involves internal processes that resolve a user-defined status to determine which system rules (e.g., allowing enrollment) should be triggered.

Related Objects

The most significant relationship for the IGS_PS_UNIT_STAT table is its foreign key association with the IGS_PS_UNIT_VER_ALL table. The UNIT_STATUS column in IGS_PS_UNIT_VER_ALL references the primary key of IGS_PS_UNIT_STAT, enforcing referential integrity. This means that the status assigned to a specific version of an academic unit must be one of the values defined in this reference table. As the Student System is marked obsolete, these tables are part of a legacy data model. They would have been central to the academic unit maintenance (Programs and Units) sub-module, and potentially related to other core student entities like offerings and enrollments through the unit version entity.