Search Results igs_ru_trg_group_cd




Overview
Explore in AI Chat

Overview

The table IGS_RU_TRG_GROUP_CD is a core reference data object within the Oracle E-Business Suite Student System (IGS). It functions as a master table for storing valid Turing Rule Group Codes. These codes are a fundamental component of the rule engine architecture, used to categorize and organize Turin Rules, which are business rules applied to various student-related processes. The table's primary role is to maintain a controlled list of these grouping identifiers, ensuring data integrity and consistency when rules are assigned to specific functional groups across the application modules in both releases 12.1.1 and 12.2.2.

Key Information Stored

Based on the provided metadata, the central data element stored in this table is the Turing Rule Group Code itself. The primary key constraint IGS_RU_TGC_PK is defined on the GROUP_CD column, confirming it as the unique identifier. While the exact full column list is not detailed in the excerpt, a table of this nature in the IGS schema typically includes standard descriptive and control columns such as DESCRIPTION, CLOSED_IND (to mark a code as inactive), and standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and OBJECT_VERSION_NUMBER) for auditing and data versioning.

Common Use Cases and Queries

This table is primarily accessed during the setup and maintenance of Turin Rules. Administrators use the valid codes from this table when creating or modifying rules via the application's user interface. Common reporting and validation SQL patterns include querying all active group codes or verifying the existence of a specific code before assigning it to a rule. A typical query would be:

  • SELECT group_cd, description FROM igs.igs_ru_trg_group_cd WHERE closed_ind = 'N' ORDER BY group_cd;

This table is also frequently joined to the IGS_RU_TURIN_RULE_GR table in reports that analyze rules by their functional grouping, enabling administrators to list all rules belonging to a particular group code.

Related Objects

The primary documented relationship for IGS_RU_TRG_GROUP_CD is with the IGS_RU_TURIN_RULE_GR table, which stores the Turin Rule Group definitions. A foreign key constraint exists where the GROUP_CD column in IGS_RU_TURIN_RULE_GR references the GROUP_CD column in IGS_RU_TRG_GROUP_CD. This enforces referential integrity, ensuring that every rule group is associated with a valid code from this master table. This relationship is critical for navigating from a high-level group code down to the specific rules assigned to it.