Results for “igs_ru_named_rule_gr”

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

Overview

IGS_RU_NAMED_RULE_GR is a configuration table within the IGS (Student System) product family of Oracle E-Business Suite, documented across releases 12.1.1 and 12.2.2. Its functional description is "Named Rule Group," indicating that it stores named groupings of rules used by the Oracle Student System rules engine to organize and sequence validation, selection, and message-generation logic. The object belongs to the IGS module, which is classified as Obsolete in the ETRM documentation and is therefore not implemented in current database instances. Its presence in the ETRM remains as a historical schema reference.

Under the heuristic Data Vault classification derived from the foreign key structure, this table is modeled as a link entity. In practical terms, it acts as an associative structure that resolves many-to-many relationships between named rule definitions and the underlying rule groups, return types, and message groups that participate in a rule evaluation. The physical schema is owned by IGS and comprises twelve documented columns.

Key Information Stored

The most significant columns and their roles are as follows:

• GROUP_CD — Identifies the named rule group; part of the composite primary key.
• NAME_CD — Identifies the specific named rule within the group; the second component of the composite primary key.
• DESCRIPTION — Free-text description of the named rule group entry.
• S_RETURN_TYPE — Return type associated with the rule, foreign-keyed to IGS_RU_RET_TYPE.
• RUG_SEQUENCE_NUMBER — Sequence number governing evaluation or processing order; references IGS_RU_GROUP.
• SELECT_GROUP — Group used for selection logic; references IGS_RU_GROUP.
• MESSAGE_GROUP — Group used for message generation; references IGS_RU_GROUP.
• CREATED_BY, CREATION_DATE — Standard WHO audit columns recording row insertion.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording the most recent modification.

The surrogate primary key is defined as IGS_RU_NDG_PK over (GROUP_CD, NAME_CD). Because the same column pair also appears in the unique index IGS_RU_NAMED_RULE_GR_U1, it functions as both the primary key and the business-key candidate; no separate system-generated surrogate exists for this table.

Common Use Cases and Queries

Typical uses center on retrieving rule group configuration for a given name or group code, and on resolving the related return type and message/selection groups for evaluation. A representative query joins the table to its reference tables:

• List all rules within a group: SELECT NAME_CD, DESCRIPTION, S_RETURN_TYPE, RUG_SEQUENCE_NUMBER FROM IGS_RU_NAMED_RULE_GR WHERE GROUP_CD = :group_cd ORDER BY RUG_SEQUENCE_NUMBER;
• Resolve return type descriptions: join to IGS_RU_RET_TYPE on S_RETURN_TYPE.
• Resolve message and selection groups: join to IGS_RU_GROUP on MESSAGE_GROUP, SELECT_GROUP, and RUG_SEQUENCE_NUMBER.
• Reporting on rule configuration by creation or update date using the WHO columns.

Because the product is obsolete, these queries are primarily relevant for migration analysis, historical data extraction, or auditing legacy Student System metadata.

Related Objects

The following objects are referenced by IGS_RU_NAMED_RULE_GR through documented foreign keys:

• IGS_RU_NRG_GROUP_CD — referenced by GROUP_CD.
• IGS_RU_GROUP — referenced by MESSAGE_GROUP, RUG_SEQUENCE_NUMBER, and SELECT_GROUP; the principal parent table for rule grouping behavior.
• IGS_RU_RET_TYPE — referenced by S_RETURN_TYPE; defines the return type contract for the rule.

These relationships confirm the table's role as a link between named rule definitions and the core rule group and return type reference data of the IGS rules framework.