Search Results igs_pr_ru_ca_type_all




Overview
Explore in AI Chat

Overview

The table IGS_PR_RU_CA_TYPE_ALL is a core data object within the Oracle E-Business Suite Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It functions as a junction table that defines the specific academic calendar types in which a defined progression rule is to be evaluated. This table enables the conditional testing of progression rules across different academic periods, such as semesters or terms. Administrators can configure a rule to be tested starting from a particular calendar instance and for a defined number of subsequent instances, providing granular control over the rule's application timeline within the student progression engine.

Key Information Stored

The table stores the linkage between a progression rule and the academic calendars for its evaluation. Its primary key is a composite of three columns: PROGRESSION_RULE_CAT, PRA_SEQUENCE_NUMBER, and PRG_CAL_TYPE. The PROGRESSION_RULE_CAT and PRA_SEQUENCE_NUMBER together uniquely identify the parent progression rule from the IGS_PR_RU_APPL_ALL table. The PRG_CAL_TYPE column stores the code for the academic calendar type (e.g., 'SEM', 'QTR') where the rule is applicable. Critical control columns include START_SEQUENCE_NUMBER and END_SEQUENCE_NUMBER, which define the range of specific calendar instances (e.g., Semester 1 2024, Semester 2 2024) within the calendar type where the rule testing is active, allowing for precise temporal scoping.

Common Use Cases and Queries

A primary use case is auditing or reporting on which progression rules are configured for specific academic calendars. For instance, an administrator may need to identify all rules active for the 'SEM' (Semester) calendar type in the upcoming academic year. A common reporting query involves joining this table with the rule definition (IGS_PR_RU_APPL_ALL) and calendar type descriptions. Sample SQL to list rules for a calendar type would be:

  • SELECT pra.progression_rule_cat, pra.rule_name, ctype.prg_cal_type, ctype.start_sequence_number, ctype.end_sequence_number FROM igs_pr_ru_ca_type_all ctype, igs_pr_ru_appl_all pra WHERE ctype.progression_rule_cat = pra.progression_rule_cat AND ctype.pra_sequence_number = pra.sequence_number AND ctype.prg_cal_type = 'SEM';

Another critical operational use is during the batch progression process, where the system queries this table to determine the exact set of calendar instances against which each student's academic standing must be assessed for a given rule.

Related Objects

The table maintains strict referential integrity through defined foreign key relationships, central to the Student System's data model.

  • IGS_PR_RU_APPL_ALL: This is the parent table for the progression rule definition. The foreign key on columns (PROGRESSION_RULE_CAT, PRA_SEQUENCE_NUMBER) links each calendar type assignment back to a specific rule.
  • IGS_CA_INST_ALL: This table stores instances of academic calendars. Two foreign key relationships exist:
    • One links PRG_CAL_TYPE and START_SEQUENCE_NUMBER to validate the starting calendar instance.
    • Another links PRG_CAL_TYPE and END_SEQUENCE_NUMBER to validate the ending calendar instance for the testing range.

These relationships ensure that a rule can only be scheduled for evaluation against valid, existing calendar instances within the system.