Search Results igs_ps_stage




Overview
Explore in AI Chat

Overview

The IGS_PS_STAGE table is a core data object within the Oracle E-Business Suite Student System (IGS). It represents the structural definition of program stages within a specific version of an academic program (course). A stage is a distinct, evaluative phase in a student's progression through a program. Each stage is defined by a code and is intrinsically linked to the rules engine of the system, allowing for automated evaluation of a student's eligibility to progress from one stage to the next. The table's primary role is to store the master list of these stages, establishing the framework against which individual student progression is measured and managed.

Key Information Stored

The table's structure centers on uniquely identifying a stage within the context of its parent program version. The primary key is a composite of three columns: COURSE_CD (the code for the academic program), VERSION_NUMBER (the specific version of that program), and SEQUENCE_NUMBER (which defines the order of the stage). Other critical columns include COURSE_STAGE_TYPE, which classifies the stage (e.g., via a foreign key to IGS_PS_STAGE_TYPE), and DESCRIPTION. The table also typically contains standard Oracle EBS audit columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY to track data maintenance.

Common Use Cases and Queries

This table is central to student progression and academic planning workflows. Common use cases include configuring the progression pathway for a new program version, generating reports on stage definitions for academic governance, and providing the master data for screens that manage stage-based rules. A frequent reporting query involves joining the stage to its parent program version to list all stages in sequence. For example:

  • SELECT psv.course_cd, psv.version_number, stg.sequence_number, stg.course_stage_type, stg.description FROM igs_ps_stage stg JOIN igs_ps_ver_all psv ON stg.course_cd = psv.course_cd AND stg.version_number = psv.version_number WHERE psv.course_cd = 'BSC_CS' ORDER BY stg.sequence_number;
  • Another critical pattern is querying stages along with their attached progression rules (via IGS_PS_STAGE_RU) to audit the rule-set governing academic advancement.

Related Objects

The IGS_PS_STAGE table sits within a key relationship hierarchy in the Student System. Its documented foreign key relationships are as follows:

  • IGS_PS_VER_ALL: This is the parent table. Each stage record must belong to a valid program version, joined on (COURSE_CD, VERSION_NUMBER).
  • IGS_PS_STAGE_TYPE: The stage type is validated via a foreign key relationship on the COURSE_STAGE_TYPE column.
  • IGS_PS_STAGE_RU: This child table stores the specific rules associated with each stage. The relationship is defined on the primary key columns: (VERSION_NUMBER, COURSE_CD, CST_SEQUENCE_NUMBER), where CST_SEQUENCE_NUMBER corresponds to IGS_PS_STAGE.SEQUENCE_NUMBER.

These relationships ensure data integrity and enable the complex rule-based evaluation of student progression through defined academic stages.