Search Results igs_pr_ru_appl_all




Overview
Explore in AI Chat

Overview

The IGS_PR_RU_APPL_ALL table is a core entity within the Oracle E-Business Suite Student System (IGS) module, specifically for progression rule management in versions 12.1.1 and 12.2.2. It functions as the junction table that defines the specific application of a defined progression rule to various allowable system elements. This table is central to the configuration and execution of academic progression logic, enabling institutions to enforce consistent academic standards across different student cohorts and programs. Its design supports a multi-org structure, as indicated by the '_ALL' suffix, allowing for the storage of data across multiple operating units within a single installation.

Key Information Stored

The table's primary key is a composite of PROGRESSION_RULE_CAT and SEQUENCE_NUMBER, uniquely identifying each rule application record. Key columns define the target of the rule application and link to the master rule definition. These include CRV_COURSE_CD and CRV_VERSION_NUMBER for applying a rule to a specific course version, COURSE_TYPE for applying to a course category, and columns linking to organizational units. For individual student enforcement, it holds foreign key references to specific student course attempts via SCA_PERSON_ID and SCA_COURSE_CD. The table also maintains critical foreign key links to the master rule definition in IGS_PR_RULE_ALL (via PROGRESSION_RULE_CAT and PROGRESSION_RULE_CD) and to the parent rule application details in IGS_PR_RU_OU_ALL.

Common Use Cases and Queries

A primary use case is identifying all progression rules applied to a specific course version for audit or configuration review. Administrators may also query the table to list rules targeting a particular student or course type. Common reporting needs include generating a summary of rule coverage across the academic catalog. Sample SQL patterns often involve joins with related definition tables.

  • Find all rules applied to a course version: SELECT * FROM igs_pr_ru_appl_all WHERE crv_course_cd = '&course_cd' AND crv_version_number = &version_num;
  • List rule applications for a specific rule category: SELECT pra.*, r.rule_name FROM igs_pr_ru_appl_all pra JOIN igs_pr_rule_all r ON pra.progression_rule_cat = r.progression_rule_cat WHERE pra.progression_rule_cat = '&rule_cat';

Related Objects

The IGS_PR_RU_APPL_ALL table is a central hub with extensive relationships. Its primary foreign key dependencies, as documented, are critical for understanding its integration.

  • IGS_PR_RULE_ALL: The master definition table for the progression rule being applied.
  • IGS_PS_VER_ALL & IGS_PS_TYPE_ALL: Reference tables for the course versions and course types to which rules are applied.
  • IGS_EN_STDNT_PS_ATT_ALL: Links the rule application to an individual student's course attempt.
  • IGS_PR_RU_OU_ALL: The parent table for organizational unit-specific rule details.
  • IGS_PR_SDT_PR_RU_CK_ALL & IGS_PR_RU_CA_TYPE_ALL: Child tables that likely store the results of rule checks or rule associations with course attempt types, respectively.