Search Results igs_pr_stdnt_pr_ou_all




Overview
Explore in AI Chat

Overview

The IGS_PR_STDNT_PR_OU_ALL table is a core data structure within the now-obsolete Student System (IGS) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the master repository for recording progression outcomes that have been applied to a student's academic program. A progression outcome is a formal academic status or action, such as a warning, probation, or enrollment restriction, triggered when a student fails to meet defined academic progression rules. The table captures outcomes generated either automatically by the system or applied manually by an administrator. Crucially, it manages the lifecycle of these outcomes, as they are often subject to approval, waiver, or appeal processes before being formally enacted against the student's record.

Key Information Stored

The table's primary key uniquely identifies a student's specific progression outcome instance through a combination of PERSON_ID, COURSE_CD, and SEQUENCE_NUMBER. Key descriptive columns include PROGRESSION_OUTCOME_TYPE, which classifies the nature of the outcome (e.g., suspension, exclusion). The table links the outcome to its originating rule check via columns like PROGRESSION_RULE_CAT, PRA_SEQUENCE_NUMBER, and RULE_CHECK_DT. It also stores the practical implications of the outcome, such as a RESTRICTED_ATTENDANCE_TYPE or an ENCMB_COURSE_GROUP_CD (encumbrance course group code) to be applied. Status and process control are managed through attributes like OUTCOME_STATUS and APPROVAL_DT, reflecting the outcome's stage in the administrative workflow.

Common Use Cases and Queries

This table is central to academic standing and compliance reporting. A common operational use case is querying all active probation outcomes for students in a specific course to initiate advisor interventions. A typical reporting query would join to student and course tables to list outcomes applied within a given term.

  • Sample Query for Active Outcomes:
    SELECT sp.person_id, sp.course_cd, sp.sequence_number, pot.outcome_type_name
    FROM igs_pr_stdnt_pr_ou_all sp,
    igs_pr_ou_type_all pot
    WHERE sp.progression_outcome_type = pot.progression_outcome_type
    AND sp.outcome_status = 'APPROVED'
    AND sp.course_cd = :p_course_code;
  • Audit and History: The table supports auditing the chain of academic decisions for a student, often joined with history tables (IGS_PR_STU_OU_HIST_ALL) to show the complete timeline of progression events.
  • Workflow Integration: Data in this table typically feeds approval workflows and generates official student notifications regarding their academic status.

Related Objects

The table maintains extensive foreign key relationships with other Student System entities, as documented in the ETRM. Key relationships include: