Search Results igs_pr_ru_ou_all




Overview
Explore in AI Chat

Overview

The IGS_PR_RU_OU_ALL table is a core data object within the Oracle E-Business Suite Student System (IGS) for versions 12.1.1 and 12.2.2. It serves as the master definition table for outcomes triggered by the failure of a student progression rule. A progression rule defines academic standards, and this table stores the specific administrative actions or consequences that are applied when a student fails to meet those standards. A single progression rule can be configured with multiple distinct outcomes, allowing for complex, tiered academic governance. The table's "ALL" suffix indicates it is a multi-organization table, storing data partitioned by the operating unit.

Key Information Stored

The table's structure is centered on linking an outcome to its parent rule and defining the outcome's nature. The primary key is a composite of PROGRESSION_RULE_CAT, PRA_SEQUENCE_NUMBER, and SEQUENCE_NUMBER, uniquely identifying each outcome definition. Critical descriptive columns include PROGRESSION_OUTCOME_TYPE, which classifies the outcome (e.g., enrollment restriction, course group encumbrance) and is a foreign key to IGS_PR_OU_TYPE_ALL. The RESTRICTED_ATTENDANCE_TYPE column can specify a particular attendance mode a student is limited to, while ENCMB_COURSE_GROUP_CD can define a specific course group that becomes an encumbrance. Other attributes control the outcome's application logic, such as whether it is a default outcome or its effective dates.

Common Use Cases and Queries

This table is central to academic standing and probation processes. A common use case is identifying all potential outcomes for a specific progression rule to understand the full range of academic penalties. Administrators may run reports to audit rule configurations. For technical support, queries often join to child tables to investigate specific outcome instances applied to students.

  • Listing all outcomes for a rule: SELECT * FROM igs_pr_ru_ou_all WHERE progression_rule_cat = 'PROBATION' AND pra_sequence_number = 1 ORDER BY sequence_number;
  • Finding rules with a specific outcome type: SELECT a.progression_rule_cat, a.pra_sequence_number FROM igs_pr_ru_ou_all a, igs_pr_ou_type_all b WHERE a.progression_outcome_type = b.progression_outcome_type AND b.description = 'Enrollment Restriction';
  • Troubleshooting a student's applied outcome by joining to the student outcome table: SELECT s.* FROM igs_pr_stdnt_pr_ou_all s, igs_pr_ru_ou_all o WHERE s.progression_rule_cat = o.progression_rule_cat AND s.pro_pra_sequence_number = o.pra_sequence_number AND s.pro_sequence_number = o.sequence_number AND s.person_id = 123456;

Related Objects

The IGS_PR_RU_OU_ALL table is a central hub within the progression rule data model, with extensive foreign key relationships.