Search Results igs_pr_ou_ps_all

Overview

The table IGS_PR_OU_PS_ALL is a core data object within the Oracle E-Business Suite Student System (IGS) modules, specifically supporting the management of academic progression rules. Its primary role is to store the specific course codes that are directly impacted by a defined progression outcome, thereby facilitating the automated enforcement of academic policies. For instance, when a student receives a specific academic outcome (such as a suspension or program exclusion), this table defines the precise courses from which the student is barred or which trigger the encumbrance. It acts as a critical junction table, linking high-level progression rule outcomes to the granular course level, enabling the system to generate accurate and enforceable academic holds and restrictions in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to uniquely identify a course within the context of a specific progression rule outcome. Its composite primary key underscores this relationship. The most important columns include:

• PROGRESSION_RULE_CAT, PRA_SEQUENCE_NUMBER, PRO_SEQUENCE_NUMBER: These columns together form a foreign key that uniquely identifies the parent progression rule outcome record in the IGS_PR_RU_OU_ALL table. They define the specific academic rule and outcome to which the course restriction is attached.
• COURSE_CD: This column stores the code of the course that is subject to the encumbrance or exclusion resulting from the linked outcome. This is the actionable data point that the system uses to apply the restriction.

Common Use Cases and Queries

This table is central to administrative processes involving academic standing. A primary use case is the batch or real-time application of course enrollment restrictions following a disciplinary or academic performance review. System administrators and academic advisors may query this table to audit or report on which courses are restricted under certain rule outcomes. A typical query would join to the parent outcome table to get a readable description of the rule.

Sample Query: To list all courses excluded under a specific progression rule outcome category and sequence.

SELECT oups.course_cd, rou.outcome_name
FROM igs_pr_ou_ps_all oups,
     igs_pr_ru_ou_all rou
WHERE oups.progression_rule_cat = rou.progression_rule_cat
  AND oups.pra_sequence_number = rou.pra_sequence_number
  AND oups.pro_sequence_number = rou.pro_sequence_number
  AND rou.progression_rule_cat = '&RULE_CATEGORY';

Related Objects

The functionality of IGS_PR_OU_PS_ALL is intrinsically tied to its parent table through a documented foreign key relationship. The key related object is:

• IGS_PR_RU_OU_ALL (Progression Rule Outcome): This is the primary parent table. IGS_PR_OU_PS_ALL references it via the foreign key constraint on the composite columns (PROGRESSION_RULE_CAT, PRA_SEQUENCE_NUMBER, PRO_SEQUENCE_NUMBER). This relationship ensures that every course restriction is valid only for an existing, defined progression outcome. The table IGS_PR_OU_PS_ALL cannot contain an outcome identifier that does not first exist in IGS_PR_RU_OU_ALL.