Results for “igs_pr_ru_cat”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_PR_RU_CAT is a configuration table within the Oracle E-Business Suite Student System (IGS) product family. It defines the categories of progression rules available for use within the progression sub-system. Each progression rule category established in this table must map back to a system-defined rule type, which provides controlled flexibility in how progression rules are classified and evaluated. In Oracle EBS 12.1.1 and 12.2.2, the table resides in the IGS schema and is marked VALID in the ETRM repository, with eleven documented columns.

From a modeling perspective, the metadata's heuristic Data Vault classification identifies this object as satellite-leaning. This reflects its role as a descriptive, attribute-bearing entity keyed by a single business identifier that references one parent lookup table (IGS_RU_CALL) rather than acting as a many-to-many link or a pure hub. The progression rule category serves as the anchor business key, and the remaining attributes describe the category's behavior.

Key Information Stored

The table's primary key is enforced through the index IGS_PR_RU_CAT_PK on the column PROGRESSION_RULE_CAT. A second unique index, IGS_PR_RU_CAT_U1, also covers PROGRESSION_RULE_CAT, confirming it as the business-key candidate that uniquely identifies each progression rule category. The most significant columns include:

• PROGRESSION_RULE_CAT — the surrogate primary key and business identifier for the rule category.
• DESCRIPTION — free-text description of the category's purpose or meaning.
• S_RULE_CALL_CD — foreign key to IGS_RU_CALL; maps the category to a system-defined rule type or call code.
• CLOSED_IND — flag indicating whether the category is closed and therefore unavailable for new rule assignments.
• MESSAGE — informational or validation message surfaced when the category is applied.
• POSITIVE_RULE_IND — indicates whether rules in this category are positive (advancing) rather than restrictive.
• CREATED_BY, CREATION_DATE — standard Oracle who-audit columns recording the creating user and timestamp.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard who-audit columns capturing the most recent modification and the login of the updating session.

The audit columns follow the conventional Oracle EBS WHO column pattern and are typically populated automatically by the application tier.

Common Use Cases and Queries

Administrators and functional consultants query this table to review the catalog of progression rule categories before configuring or modifying progression rules for academic programs. A typical lookup of active categories joins to the rule call table to expose the underlying system rule type:

• SELECT c.progression_rule_cat, c.description, c.s_rule_call_cd, c.closed_ind FROM igs.igs_pr_ru_cat c WHERE c.closed_ind = 'N';
• SELECT c.progression_rule_cat, r.rule_call_cd, c.positive_rule_ind FROM igs.igs_pr_ru_cat c, igs.igs_ru_call r WHERE c.s_rule_call_cd = r.rule_call_cd;

Reporting scenarios include auditing which categories remain open versus closed, confirming that every category maps to a valid system rule type, and tracing rule configurations back to their category definitions for academic progression analysis.

Related Objects

The documented foreign key relationships define the principal integration points for this table:

• IGS_RU_CALL — referenced by IGS_PR_RU_CAT.S_RULE_CALL_CD; the parent table supplying the system-defined rule type that each category must map onto.
• Progression rule detail tables within the IGS progression sub-system that reference PROGRESSION_RULE_CAT as a category attribute.
• IGS_PR_RU_CAT_PK and IGS_PR_RU_CAT_U1 — the primary and unique indexes enforcing the business key.
• Standard IGS Student System validation and lookup APIs that consume category values during rule evaluation.

Because the progression sub-system depends on this table as a reference source, changes to category definitions should be coordinated with rule configuration and downstream progression evaluation processes.