Search Results igs_co_ltr_pr_rpt_gr_pk

Overview

The table IGS_CO_LTR_PR_RPT_GR_ALL is a core data object within the Oracle E-Business Suite Student System (IGS). It functions as a junction table that defines the association between letter parameters and the repeating groups in which they are utilized. Its primary role is to manage the structural composition of correspondence, specifically detailing which parameter types are included within a defined repeating group for a given letter template. This enables the dynamic and structured generation of personalized correspondence, such as transcripts or official letters, where specific data elements (parameters) can be repeated in a formatted section (group) based on the underlying student records.

Key Information Stored

The table stores the composite linkage between a letter parameter and a repeating group. Its structure is defined by a four-column primary key, ensuring a unique relationship for each parameter within a group for a specific letter. The critical columns are LETTER_ORDER_NUMBER, which sequences the parameter within the group; CORRESPONDENCE_TYPE and LETTER_REFERENCE_NUMBER, which together identify the parent letter template; and LETTER_REPEATING_GROUP_CD, which identifies the specific repeating group within that template. This design allows a single letter template to have multiple repeating groups, each containing an ordered set of distinct parameters.

Common Use Cases and Queries

This table is central to the correspondence engine's setup and reporting. A common operational use case is validating or auditing the parameter structure of a letter template before it is deployed. For instance, an administrator may need to list all parameters within a specific repeating group to ensure data mapping is correct. A typical query would join this table to IGS_CO_LTR_PARAM to get parameter details and to IGS_CO_LTR_RPT_GRP_ALL for group descriptions.

SELECT grp.letter_repeating_group_cd, grp.description,
       pr_rpt_gr.letter_order_number, param.parameter_name
FROM igs_co_ltr_pr_rpt_gr_all pr_rpt_gr,
     igs_co_ltr_param param,
     igs_co_ltr_rpt_grp_all grp
WHERE pr_rpt_gr.correspondence_type = 'TRANSCRIPT'
  AND pr_rpt_gr.letter_reference_number = 100
  AND pr_rpt_gr.correspondence_type = param.correspondence_type
  AND pr_rpt_gr.letter_reference_number = param.letter_reference_number
  AND pr_rpt_gr.letter_order_number = param.letter_order_number
  AND pr_rpt_gr.correspondence_type = grp.correspondence_type
  AND pr_rpt_gr.letter_reference_number = grp.letter_reference_number
  AND pr_rpt_gr.letter_repeating_group_cd = grp.letter_repeating_group_cd
ORDER BY pr_rpt_gr.letter_order_number;

Related Objects

The table maintains defined foreign key relationships with two primary master tables, enforcing referential integrity for letter configuration.

• IGS_CO_LTR_PARAM: Links via the composite key (LETTER_ORDER_NUMBER, CORRESPONDENCE_TYPE, LETTER_REFERENCE_NUMBER). This relationship ensures every parameter referenced in a repeating group is a valid, defined letter parameter.
• IGS_CO_LTR_RPT_GRP_ALL: Links via the composite key (CORRESPONDENCE_TYPE, LETTER_REFERENCE_NUMBER, LETTER_REPEATING_GROUP_CD). This relationship ensures that the repeating group code used is valid for the specified letter template.

These relationships position IGS_CO_LTR_PR_RPT_GR_ALL as a critical child table, dependent on the definitions in both IGS_CO_LTR_PARAM and IGS_CO_LTR_RPT_GRP_ALL.