Results for “progression_rule_cd”

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

Overview

IGS_PR_RULE_ALL is a table in the IGS (Student System) schema of Oracle E-Business Suite, documented as VALID in release 12.1.1 and 12.2.2. It defines standard progression rules that govern how students advance through academic structures. A progression rule represents a reusable business definition — for example, a rule requiring a minimum number of credit points, a minimum grade point average, or a completed sequence of prerequisites — that can subsequently be applied to one of the allowable system elements: a course version, a course type, an organizational unit, or an individual student course attempt. The actual binding of a rule to a target element is performed through progression rule application, which is recorded in a separate table. This separation of definition from application allows the Student System to maintain a library of reusable rules while supporting many simultaneous applications across the institution.

From a Data Vault modeling perspective, the heuristic classification for this object is hub-leaning. This suggests it should be treated as a hub entity, because its identity is anchored by a stable business key (PROGRESSION_RULE_CAT and PROGRESSION_RULE_CD) with descriptive and operational attributes that may be better modeled as satellite data.

Key Information Stored

The table contains 12 documented columns. The primary key is the surrogate key IGS_PR_RULE_PK, which is composed of the composite business key columns PROGRESSION_RULE_CAT and PROGRESSION_RULE_CD. A unique index, IGS_PR_RULE_ALL_U1, enforces uniqueness on the same two columns, confirming them as the business-key candidates.

• PROGRESSION_RULE_CAT — the progression rule category; part of the primary key and business key, used to group related rules.
• PROGRESSION_RULE_CD — the progression rule code; the second component of the primary and business key, uniquely identifying a rule within its category.
• DESCRIPTION — the human-readable description of the rule, used in setup forms and reporting.
• RUL_SEQUENCE_NUMBER — the sequence number applied when rules are evaluated or presented in order.
• CLOSED_IND — indicates whether the rule is closed to new applications; closed rules remain for historical reference.
• MESSAGE — the message text associated with the rule, typically surfaced to users when the rule is evaluated.
• ORG_ID — the operating unit identifier, supporting multi-organization data access and partitioning.
• CREATED_BY, CREATION_DATE — standard audit columns recording who created the rule and when.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns recording the most recent modification and the login that performed it.

Common Use Cases and Queries

Institutions query this table to audit the catalogue of progression rules, to identify rules that are still active, and to drive admissions and progression processing. A typical query retrieves all open rules for an operating unit:

• SELECT progression_rule_cat, progression_rule_cd, description, rul_sequence_number FROM igs_pr_rule_all WHERE closed_ind = 'N' AND org_id = :org_id ORDER BY progression_rule_cat, rul_sequence_number;
• Joining to applications: SELECT r.progression_rule_cd, r.description, a.* FROM igs_pr_rule_all r, igs_pr_ru_appl_all a WHERE r.progression_rule_cat = a.progression_rule_cat AND r.progression_rule_cd = a.progression_rule_cd;
• Reporting on rule utilisation counts by category, and identifying rules that have no applications and may be candidates for retirement.
• Audit reporting on rules created or updated within a date range using the standard audit columns.

Related Objects

The most significant dependent object is the progression rule application table, which references this table through its composite foreign key. Other related entities include the course version, course type, organization unit, and student course attempt structures to which rules are ultimately applied.

• IGS_PR_RU_APPL_ALL — the primary referencing table; joins on PROGRESSION_RULE_CAT and PROGRESSION_RULE_CD to record where each rule is applied.
• IGS_PR_RU_APPL_ALL.PROGRESSION_RULE_CAT and PROGRESSION_RULE_CD — the documented foreign key columns in that child table.
• Course version, course type, org unit, and student course attempt entities referenced by the application records as target elements.
• Student System progression evaluation and validation APIs that consume rule definitions during enrolment and progression processing.