Search Results igs_pr_ou_type_all




Overview
Explore in AI Chat

Overview

The table IGS_PR_OU_TYPE_ALL is a core reference table within the Oracle E-Business Suite Student System (IGS). It serves as the master repository for defining the possible outcomes resulting from the evaluation of academic progression rules against a student's performance. These outcomes represent the system's determination of a student's academic standing, such as being placed on suspension, exclusion, or being deemed successful. The table supports a multi-organization architecture, as indicated by the "_ALL" suffix, allowing for the definition of outcome types specific to different operating units. Each user-defined outcome type must map to a system-defined outcome type, ensuring consistency in downstream processing and application logic.

Key Information Stored

The table's primary purpose is to store the definition and control attributes for each progression outcome type. The central column is PROGRESSION_OUTCOME_TYPE, which is the primary key and holds the unique code for the outcome (e.g., 'SUSPENDED', 'EXCLUDED'). While the full column list is not detailed in the excerpt, the foreign key relationships indicate other critical attributes. These include DFLT_RESTRICTED_ATT_TYPE, which links to a default restricted attendance type (IGS_EN_ATD_TYPE_ALL) to be applied, and ENCUMBRANCE_TYPE, which links to a financial encumbrance type (IGS_FI_ENCMB_TYPE_ALL) that may be triggered by the outcome. The table likely contains descriptive columns for the outcome name and controls to indicate if the outcome requires manual intervention, is system-applied, or is considered a positive result.

Common Use Cases and Queries

This table is primarily referenced in processes related to academic progression, standing, and student status management. A common operational use case is generating a list of all configured outcome types for setup or audit purposes. For reporting, it is frequently joined to student-specific outcome tables to categorize and analyze student populations by their academic standing. A typical query would involve joining IGS_PR_OU_TYPE_ALL to IGS_PR_STDNT_PR_OU_ALL to get a descriptive report of student outcomes.

  • Sample Query: List all progression outcome types.
    SELECT progression_outcome_type, description FROM igs_pr_ou_type_all WHERE enabled_flag = 'Y' ORDER BY 1;
  • Sample Query: Find students with a specific outcome type (e.g., 'SUSPENDED').
    SELECT s.student_id, s.person_id, o.outcome_date FROM igs_pr_stdnt_pr_ou_all s, igs_pr_ou_type_all t WHERE s.progression_outcome_type = t.progression_outcome_type AND t.progression_outcome_type = 'SUSPENDED';

Related Objects

IGS_PR_OU_TYPE_ALL maintains integral relationships with several key tables in the Student System, primarily through foreign key constraints. It acts as a parent table for student outcome records and progression rule definitions.

  • IGS_PR_STDNT_PR_OU_ALL: Stores the actual progression outcomes applied to individual students. Joined via PROGRESSION_OUTCOME_TYPE.
  • IGS_PR_RU_OU_ALL: Defines the possible outcomes for a specific progression rule. Joined via PROGRESSION_OUTCOME_TYPE.
  • IGS_EN_ATD_TYPE_ALL (Parent): Provides the default restricted attendance type linked via DFLT_RESTRICTED_ATT_TYPE.
  • IGS_FI_ENCMB_TYPE_ALL (Parent): Provides the financial encumbrance type linked via ENCUMBRANCE_TYPE.