Search Results igs_ps_stat




Overview
Explore in AI Chat

Overview

The IGS_PS_STAT table is a core configuration entity within the Oracle E-Business Suite Student System (IGS). It serves as a master repository for user-defined program (or course) statuses. Its primary role is to provide a flexible mapping layer between business-defined statuses and the underlying system statuses that control application functionality. This design allows institutions to define a granular set of statuses tailored to their academic processes (e.g., "Provisional Admission," "Conditionally Enrolled," "Thesis Submitted") while ensuring these statuses correctly interface with the system's predefined logic for enrollment, billing, and reporting.

Key Information Stored

The table's central column is COURSE_STATUS, which acts as the primary key. This column stores the unique code for each user-defined program 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 linking to the system status (e.g., SYSTEM_STATUS). This SYSTEM_STATUS mapping is critical, as it determines the functional behavior (like active enrollment or inactive planning) associated with each user-defined status. The table may also contain standard WHO columns for auditing (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE).

Common Use Cases and Queries

This table is essential for setup, reporting, and data validation. Administrators use it to configure the valid statuses available for assignment to student program attempts. Common operational queries involve listing all active statuses or finding the system status associated with a specific user-defined code. For reporting, it is frequently joined to program attempt tables to translate status codes into meaningful descriptions. A typical query pattern is:

  • SELECT ps.course_status, ps.description, ps.system_status FROM igs_ps_stat ps WHERE SYSDATE BETWEEN ps.start_date AND NVL(ps.end_date, SYSDATE) ORDER BY 1;
  • SELECT pv.course_cd, pv.version_number, ps.description FROM igs_ps_ver_all pv, igs_ps_stat ps WHERE pv.course_status = ps.course_status;

Data integrity checks often involve verifying that all COURSE_STATUS values used in transactional tables like IGS_PS_VER_ALL have a corresponding definition in IGS_PS_STAT.

Related Objects

The IGS_PS_STAT table has a direct parent-child relationship with the Program Version table, as documented by the foreign key. The primary key (COURSE_STATUS) is referenced by the following object:

  • Table: IGS_PS_VER_ALL (Foreign Key Column: COURSE_STATUS). This is the primary relationship, where each program version record stores its current status by referencing a code defined in IGS_PS_STAT.

Given its function as a master lookup table, IGS_PS_STAT is also likely referenced by other student system entities that track program attempt status history or require status validation, though these are not explicitly listed in the provided metadata.