Search Results IGS_PR_RU_CAT




Overview
Explore in AI Chat

Overview

The table IGS_PR_RU_CAT is a core data object within the Oracle E-Business Suite Student System (IGS), specifically designed for the progression sub-system. Its primary role is to define and manage the categories of progression rules that an institution can apply to govern student academic progress. These user-defined categories provide a layer of abstraction and flexibility, as they must map back to a system-defined rule type. This structure allows administrators to create meaningful, institution-specific rule categories (e.g., "Minimum GPA for Major," "Prerequisite Completion Check") that are logically linked to the underlying technical rule engine. Notably, the provided metadata indicates this table was marked as "Obsolete" and was "Not implemented in this database" for the referenced version, suggesting its functionality may have been superseded or migrated in later releases of EBS 12.1.1 or 12.2.2.

Key Information Stored

Based on the ETRM documentation, the central data element stored in this table is the progression rule category itself. The primary key constraint IGS_PR_RU_CAT_PK is defined on the column PROGRESSION_RULE_CAT, which would be the unique identifier for each category. The table's description emphasizes the critical link between these user-defined categories and a system-defined rule type, implying the existence of a column (such as RULE_TYPE or S_RULE_TYPE) to maintain this mapping, though it is not explicitly named in the excerpt. The foreign key relationship indicates the table also stores or references a S_RULE_CALL_CD (system rule call code), which connects the category to the rule execution framework via the IGS_RU_CALL table.

Common Use Cases and Queries

The primary use case for this table is the administrative setup and maintenance of the progression rule catalog. Common operations would include querying all available rule categories for configuration screens or validating a category during the creation of a specific progression rule. A typical query would retrieve the list of active categories and their associated system rule types for a setup interface. For example: SELECT progression_rule_cat, s_rule_call_cd FROM igs_pr_ru_cat ORDER BY 1;. In a reporting context, one might join this table to actual rule instances to analyze the distribution of rule types being applied across academic programs. As the table is noted as not implemented, these operations would be relevant in systems where it was actively used prior to obsolescence.

Related Objects

  • IGS_RU_CALL: This is a directly referenced foreign key table. The column IGS_PR_RU_CAT.S_RULE_CALL_CD references a column in IGS_RU_CALL, establishing that each progression rule category is associated with a specific rule call mechanism within the system's rule engine.
  • Progression Rule Tables: While not listed in the provided metadata, tables storing concrete progression rules (which might be named similarly to IGS_PR_RULE or IGS_PR_RU_DTL) would logically have a foreign key to IGS_PR_RU_CAT.PROGRESSION_RULE_CAT to classify each rule instance under a defined category.