Search Results igs_co_ltr_rpt_grp

Overview

The table IGS_CO_LTR_RPT_GRP is a core data object within the Oracle E-Business Suite Student System (IGS) module, specifically for the correspondence management functionality in releases 12.1.1 and 12.2.2. It serves a critical structural role in defining and managing repeating parameter groups for correspondence letters. These groups are logical constructs that link related, repeating data parameters (such as multiple course enrollments or addresses) within a single letter template, enabling the generation of complex, data-driven correspondence. The table's primary key, IGS_CO_LTR_RPT_GRP_PK, uniquely identifies each repeating group definition for a specific letter.

Key Information Stored

The table's structure is defined by its primary and foreign key columns, which establish its relationships within the correspondence data model. The primary key is a composite of three columns: CORRESPONDENCE_TYPE, LETTER_REFERENCE_NUMBER, and LETTER_REPEATING_GROUP_CD. These columns collectively identify a unique repeating group for a letter template. A significant column is SUP_REPEATING_GROUP_CD, which facilitates a recursive or hierarchical relationship within the table itself, allowing for the nesting of repeating groups. This self-referencing foreign key enables the creation of complex, multi-level data structures within a single correspondence piece.

Common Use Cases and Queries

The primary use case for this table is during the setup and generation of correspondence letters that require iterative data sections. For instance, a transcript letter may need to list all completed courses, each requiring the same set of parameters (course code, title, grade). A developer or system administrator would query this table to understand the defined group structure for a letter. A common query pattern involves joining to the parent letter definition table (IGS_CO_S_LTR) to list all repeating groups for a specific correspondence type.

• Sample Query: SELECT lrg.* FROM igs_co_ltr_rpt_grp lrg JOIN igs_co_s_ltr l ON lrg.correspondence_type = l.correspondence_type AND lrg.letter_reference_number = l.letter_reference_number WHERE l.correspondence_type = 'TRANSCRIPT';
• Reporting Use: Reports analyzing correspondence template complexity or validating data integrity for letter generation would reference this table to enumerate and verify defined repeating groups and their hierarchical relationships.

Related Objects

IGS_CO_LTR_RPT_GRP is centrally connected to several key tables in the IGS correspondence schema, as documented by its foreign key relationships.

• Primary Parent: IGS_CO_S_LTR, via columns CORRESPONDENCE_TYPE and LETTER_REFERENCE_NUMBER. This links each repeating group definition to its master letter template.
• Self-Reference (Hierarchy): IGS_CO_LTR_RPT_GRP references itself via the SUP_REPEATING_GROUP_CD column to create subordinate group relationships.
• Key Child Table: IGS_CO_LTR_PR_RPT_GR references this table's primary key. This child table stores the specific parameters assigned to each repeating group, making IGS_CO_LTR_RPT_GRP the structural parent for the actual parameter values.