Search Results igs_co_ltr_pr_rpt_gr_pk

Overview

The table IGS_CO_LTR_PR_RPT_GR is a component of the Oracle E-Business Suite's Student System (IGS), specifically within the correspondence module. As indicated by its "Obsolete" status in the provided ETRM metadata, this table is part of a legacy feature set that is no longer actively developed or implemented in new database instances. Its primary function is to define the specific parameter types that are permissible within a letter's repeating group. A repeating group is a dynamic section of a correspondence template that can be populated with multiple instances of related data. This table acts as a control structure, linking a correspondence letter template, its defined repeating groups, and the specific data parameters that can be used to populate each iteration of that group during letter generation.

Key Information Stored

The table's structure is defined by a composite primary key, which uniquely identifies each valid parameter-to-group association. The critical columns are:

• CORRESPONDENCE_TYPE and LETTER_REFERENCE_NUMBER: Together, these columns uniquely identify the master correspondence letter template to which this parameter rule applies.
• LETTER_REPEATING_GROUP_CD: This code identifies the specific repeating group within the letter template where the parameter can be used.
• LETTER_PARAMETER_TYPE: This column stores the code for the type of data parameter (e.g., a specific student attribute, course code, or date field) that is authorized for use within the associated repeating group.

Common Use Cases and Queries

Given its obsolete status and control nature, direct operational use is minimal in active implementations. Its primary historical use cases involved setup, validation, and reporting on correspondence template definitions. Administrators or developers would query this table to understand or audit the data structure of letter templates. A typical query would retrieve all parameters available for a specific letter's repeating group to aid in template design or troubleshooting. For example:

SELECT LETTER_PARAMETER_TYPE FROM IGS_CO_LTR_PR_RPT_GR WHERE CORRESPONDENCE_TYPE = 'ADM_LTR' AND LETTER_REFERENCE_NUMBER = 1001 AND LETTER_REPEATING_GROUP_CD = 'COURSE_LIST';

Reporting use cases would focus on generating a data dictionary or impact analysis for letter templates, especially when considering changes to underlying parameter definitions or decommissioning specific letter types.

Related Objects

Based on the provided relationship data, IGS_CO_LTR_PR_RPT_GR has defined dependencies on other tables in the correspondence module. The documented foreign keys are:

• Self-Referencing Foreign Key: The table references itself on the columns CORRESPONDENCE_TYPE, LETTER_REFERENCE_NUMBER, and LETTER_PARAMETER_TYPE. This suggests a hierarchical or validating relationship between parameter types, though the exact nature is not detailed in the excerpt.
• Foreign Key to IGS_CO_LTR_RPT_GRP: The table references the IGS_CO_LTR_RPT_GRP table via the composite key (CORRESPONDENCE_TYPE, LETTER_REFERENCE_NUMBER, LETTER_REPEATING_GROUP_CD). This is the fundamental relationship that ties a parameter rule to its parent repeating group definition. Any parameter type recorded in IGS_CO_LTR_PR_RPT_GR must have a valid, pre-existing repeating group defined in IGS_CO_LTR_RPT_GRP.