Search Results igs_ru_ngc_pk

Overview

The IGS_RU_NRG_GROUP_CD table is a core reference data object within the Oracle E-Business Suite (EBS) Student System (IGS). It functions as a master table for storing named rule group codes. In the context of the Student System's rule engine, these codes categorize and organize related sets of named rules, which are predefined business logic constructs used to enforce academic policies, progression requirements, or other institutional regulations. The table's primary role is to ensure data integrity and consistency by providing a validated list of permissible group codes that can be assigned to specific named rule definitions elsewhere in the application.

Key Information Stored

Based on the provided ETRM documentation, the table's structure centers on a single primary key column. The most critical data element stored is the GROUP_CD column, which serves as the unique identifier for a named rule group. This column is the table's primary key (constraint IGS_RU_NGC_PK). While the excerpt does not list additional descriptive columns, such as a description or an inactive date, which are typical in EBS reference tables, the GROUP_CD itself is the essential code referenced by dependent transactional tables to associate a rule with its logical grouping.

Common Use Cases and Queries

This table is primarily used in administrative and setup contexts. A common use case is during the initial configuration or maintenance of the Student System's rule base, where an administrator needs to define a new group for organizing academic rules. Reporting and validation queries frequently join this table to transactional rule tables. A typical SQL pattern involves listing all active rule groups or querying which rules belong to a specific group.

• Sample Query to List All Rule Group Codes:
  SELECT group_cd FROM igs.igs_ru_nrg_group_cd ORDER BY group_cd;
• Sample Validation Join:
  SELECT rgr.group_cd, rgr.rule_cd
FROM igs.igs_ru_named_rule_gr rgr
WHERE EXISTS (
SELECT 'X' FROM igs.igs_ru_nrg_group_cd gc WHERE gc.group_cd = rgr.group_cd
)

Related Objects

The IGS_RU_NRG_GROUP_CD table has a direct parent-child relationship with the IGS_RU_NAMED_RULE_GR table, as documented by the foreign key. The IGS_RU_NAMED_RULE_GR table stores the individual named rule definitions and uses the GROUP_CD column to link each rule back to its governing group code in IGS_RU_NRG_GROUP_CD.

• Foreign Key Relationship: The column IGS_RU_NAMED_RULE_GR.GROUP_CD is a foreign key referencing IGS_RU_NRG_GROUP_CD.GROUP_CD. This enforces that every group code assigned to a named rule must exist in the master IGS_RU_NRG_GROUP_CD table.