Search Results igs_pr_ou_unit_all




Overview
Explore in AI Chat

Overview

The table IGS_PR_OU_UNIT_ALL is a core data object within the Oracle E-Business Suite Student System (IGS). It functions as a detail table within the Progression Rules module, specifically managing the unit-level components of Outcome-based Progression Rules. Its primary role is to store the specific academic units (subjects or courses) that are either mandated or prohibited for a student's enrollment in a subsequent academic period based on the outcome of a defined progression rule. This table is essential for automating and enforcing academic policy, ensuring students enroll in appropriate units that align with their progression status, such as being required to repeat failed units or being excluded from advanced units due to prerequisite failures.

Key Information Stored

The table's structure is designed to link specific units to a parent progression rule outcome. Its primary key is a composite of four columns, establishing a unique record for each unit associated with a rule outcome. The critical columns include PROGRESSION_RULE_CAT, PRA_SEQUENCE_NUMBER, and PRO_SEQUENCE_NUMBER, which together form a foreign key reference to the parent outcome rule in the IGS_PR_RU_OU_ALL table. The UNIT_CD column stores the code identifying the specific academic unit that is either required or excluded. This design allows a single progression rule outcome to mandate or prohibit enrollment in multiple specific units, providing granular control over a student's academic pathway.

Common Use Cases and Queries

A primary use case is the batch generation of enrollment recommendations or restrictions for a cohort of students after the assessment of a progression period. System processes query this table to determine which units should be automatically added to a student's upcoming study plan or flagged as ineligible. For reporting, administrators may query the table to audit the units attached to active progression rules. A typical SQL pattern involves joining to the parent outcome table to retrieve the full context of the rule.

SELECT ou_unit.unit_cd, ou.rule_outcome
FROM igs_pr_ou_unit_all ou_unit,
     igs_pr_ru_ou_all ou
WHERE ou_unit.progression_rule_cat = ou.progression_rule_cat
  AND ou_unit.pra_sequence_number = ou.pra_sequence_number
  AND ou_unit.pro_sequence_number = ou.pro_sequence_number
  AND ou.progression_rule_cat = 'ACAD_STANDING';

Related Objects

The table maintains a strict hierarchical relationship within the Progression Rules subsystem. Its existence is dependent on a defined progression rule outcome, as enforced by its foreign key constraint.

  • IGS_PR_RU_OU_ALL: This is the primary parent table. IGS_PR_OU_UNIT_ALL references it via the composite foreign key on columns (PROGRESSION_RULE_CAT, PRA_SEQUENCE_NUMBER, PRO_SEQUENCE_NUMBER). This relationship ties the specific unit to its governing rule outcome.

As a detail table, IGS_PR_OU_UNIT_ALL is likely referenced by various student enrollment planning and academic advising interfaces and reports within the IGS module to apply the concrete unit-level directives defined by the broader progression rules engine.