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.

  • Table: IGS_PR_RU_OU_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PR_RU_OU_ALL,  object_name:IGS_PR_RU_OU_ALL,  status:VALID,  product: IGS - Student System ,  description: This table describes the outcomes applicable to failure of the related progression rule in the way described by the attributes of the outcome. A given rule may have multiple outcomes for any given failure type if required. ,  implementation_dba_data: IGS.IGS_PR_RU_OU_ALL , 

  • Table: IGS_PR_RU_APPL_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PR_RU_APPL_ALL,  object_name:IGS_PR_RU_APPL_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes a progression rule as it is applied to one of the allowable system elements - a course version, course type, org unit or individual student course attempt. ,  implementation_dba_data: IGS.IGS_PR_RU_APPL_ALL , 

  • Table: IGS_PR_OU_AWD 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PR_OU_AWD,  object_name:IGS_PR_OU_AWD,  status:VALID,  product: IGS - Student System ,  description: Stores the awards associated with the rule for positive outcomes. ,  implementation_dba_data: IGS.IGS_PR_OU_AWD , 

  • Table: IGS_PR_OU_UNIT_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PR_OU_UNIT_ALL,  object_name:IGS_PR_OU_UNIT_ALL,  status:VALID,  product: IGS - Student System ,  description: This table contains units from which the student will be excluded or in which the student is required to enroll in the next enrollment period. ,  implementation_dba_data: IGS.IGS_PR_OU_UNIT_ALL , 

  • Table: IGS_PS_GRP_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_GRP_ALL,  object_name:IGS_PS_GRP_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes a grouping of programs, which are used for a variety of purposes within the system. ,  implementation_dba_data: IGS.IGS_PS_GRP_ALL , 

  • Table: IGS_PR_OU_FND 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PR_OU_FND,  object_name:IGS_PR_OU_FND,  status:VALID,  product: IGS - Student System ,  description: The entity stores the exclude fund codes related to a particular progression rule outcome ,  implementation_dba_data: IGS.IGS_PR_OU_FND , 

  • Table: IGS_PR_OU_TYPE_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PR_OU_TYPE_ALL,  object_name:IGS_PR_OU_TYPE_ALL,  status:VALID,  product: IGS - Student System ,  description: Describes the types of outcomes from a progression rule check. For example, suspended, excluded, successful, manual (where the outcome must be applied manually). These outcome types must map back onto system-defined outcome types. ,  implementation_dba_data: IGS.IGS_PR_OU_TYPE_ALL , 

  • Table: IGS_PR_OU_PS_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PR_OU_PS_ALL,  object_name:IGS_PR_OU_PS_ALL,  status:VALID,  product: IGS - Student System ,  description: This table contains the course codes that are used in encumbrances resulting from the outcome. For example, course exclusions. ,  implementation_dba_data: IGS.IGS_PR_OU_PS_ALL , 

  • Table: IGS_PR_OU_UNIT_SET_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PR_OU_UNIT_SET_ALL,  object_name:IGS_PR_OU_UNIT_SET_ALL,  status:VALID,  product: IGS - Student System ,  description: This table contains unit sets from which the student will be failed as a result of the related rule being failed. ,  implementation_dba_data: IGS.IGS_PR_OU_UNIT_SET_ALL , 

  • View: IGS_PR_RU_OU 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PR_RU_OU,  object_name:IGS_PR_RU_OU,  status:VALID,  product: IGS - Student System ,  implementation_dba_data: APPS.IGS_PR_RU_OU , 

  • Table: IGS_PR_STDNT_PR_OU_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PR_STDNT_PR_OU_ALL,  object_name:IGS_PR_STDNT_PR_OU_ALL,  status:VALID,  product: IGS - Student System ,  description: This table describes a progression outcome applied to a student, either manually or by the system, as a result of failing a progression rule. This detail is subject to approval, waiving etc. prior to application to the student. ,  implementation_dba_data: IGS.IGS_PR_STDNT_PR_OU_ALL , 

  • Table: IGS_EN_ATD_TYPE_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_ATD_TYPE_ALL,  object_name:IGS_EN_ATD_TYPE_ALL,  status:VALID,  product: IGS - Student System ,  description: Describes available university program attendance types ,  implementation_dba_data: IGS.IGS_EN_ATD_TYPE_ALL ,