Search Results igs_co_ltr_rpt_grp_pk

Overview

The table IGS_CO_LTR_RPT_GRP_ALL is a core data structure within the Oracle E-Business Suite Student System (IGS) module, specifically for the Correspondence functionality. It is a multi-organization (_ALL) table designed to store master definitions for repeating parameter groups used in correspondence letters. Its primary role is to establish and manage logical groupings of repeating parameters, enabling the generation of dynamic content within standardized letter templates. This table is essential for defining the hierarchical and relational structure of data elements that can be iterated upon when a letter is produced, ensuring data consistency and linkage across complex correspondence outputs in versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by its primary key, which uniquely identifies a repeating group within the context of a specific letter template. The critical columns are:

• CORRESPONDENCE_TYPE: Identifies the category or class of correspondence.
• LETTER_REFERENCE_NUMBER: A unique identifier for the specific letter template.
• LETTER_REPEATING_GROUP_CD: The code that uniquely identifies the repeating group within the letter.
• SUP_REPEATING_GROUP_CD: A self-referencing foreign key column that allows for the nesting of repeating groups by pointing to a parent group's code, establishing hierarchical relationships.

The combination of the first three columns forms the primary key (IGS_CO_LTR_RPT_GRP_PK), enforcing uniqueness at the database level.

Common Use Cases and Queries

This table is central to the setup and execution of correspondence processes. A primary use case is during the letter generation workflow, where the application references defined groups to correctly loop through and populate repeating data sections, such as lists of course enrollments or fee details within a student statement. For reporting and troubleshooting, common SQL patterns involve joining to parent letter definitions and related parameter tables. For instance, to list all repeating groups for a specific letter, a query would be: SELECT * FROM igs_co_ltr_rpt_grp_all WHERE correspondence_type = '&TYPE' AND letter_reference_number = '&REF_NUM'; Another critical query involves resolving group hierarchies to understand nested data structures: SELECT child.* FROM igs_co_ltr_rpt_grp_all child, igs_co_ltr_rpt_grp_all parent WHERE child.sup_repeating_group_cd = parent.letter_repeating_group_cd AND child.correspondence_type = parent.correspondence_type AND child.letter_reference_number = parent.letter_reference_number;

Related Objects

Based on the documented foreign key relationships, IGS_CO_LTR_RPT_GRP_ALL is integral to several related objects:

• IGS_CO_S_LTR: The base letter definition table. The foreign key (CORRESPONDENCE_TYPE, LETTER_REFERENCE_NUMBER) links each repeating group to its parent letter template.
• IGS_CO_LTR_PR_RPT_GR_ALL: This table, which stores parameters within repeating groups, references IGS_CO_LTR_RPT_GRP_ALL via its primary key columns to associate parameters with their correct group.
• IGS_CO_S_PERLT_RPTGP_ALL: Likely a table for personalizing or assigning repeating groups, it also references this table's primary key.
• Self-Referencing Foreign Key: The table references itself via the SUP_REPEATING_GROUP_CD column to the LETTER_REPEATING_GROUP_CD column, enabling the creation of sub-group hierarchies within a single letter.

These relationships underscore the table's role as a central hub for defining the structural framework of repeatable data segments in correspondence.