Search Results igs_co_s_perlt_rptgp_pk

Overview

The IGS_CO_S_PERLT_RPTGP_ALL table is a core data structure within the Oracle E-Business Suite Student System (IGS) for releases 12.1.1 and 12.2.2. It functions as a transactional detail table that manages repeating data groups associated with system-generated correspondence for a person. Its primary role is to store and organize variable, multi-instance data elements (repeating groups) that are populated into standardized letters or communications. This enables the system to produce personalized correspondence where certain sections of data, such as course enrollments or fee details, can repeat multiple times for a single recipient. The table's design supports complex, hierarchical data relationships within the correspondence process.

Key Information Stored

The table's structure is defined by a composite primary key that precisely identifies each unique repeating group instance for a person's letter. The key columns are PERSON_ID, CORRESPONDENCE_TYPE, LETTER_REFERENCE_NUMBER, SPL_SEQUENCE_NUMBER, LETTER_REPEATING_GROUP_CD, and SEQUENCE_NUMBER. These fields collectively link the repeating data to a specific person, a specific letter template, and a specific instance of that letter being produced. Additional critical columns include SPLRG_SEQUENCE_NUMBER, which orders the repeating group instances, and SUP_REPEATING_GROUP_CD with SUP_SPLRG_SEQUENCE_NUMBER, which establish parent-child relationships between nested repeating groups within the same letter.

Common Use Cases and Queries

This table is central to the runtime generation of correspondence. Common use cases include troubleshooting data visibility issues in produced letters, auditing the historical correspondence sent to a person, and generating reports on letter content. A typical query retrieves all repeating group data for a specific letter instance to verify populated values.

Sample SQL Pattern:
SELECT * FROM igs.igs_co_s_perlt_rptgp_all
WHERE person_id = 12345
AND correspondence_type = 'ENRL_CONF'
AND letter_reference_number = 1001
ORDER BY letter_repeating_group_cd, splrg_sequence_number;

Another common pattern involves joining to the person letter header table (IGS_CO_S_PER_LTR_ALL) to correlate repeating group details with the overall letter status and metadata.

Related Objects

The table maintains integral relationships with several other Student System objects, as defined by its foreign key constraints.

• Primary Key: IGS_CO_S_PERLT_RPTGP_PK on (PERSON_ID, CORRESPONDENCE_TYPE, LETTER_REFERENCE_NUMBER, SPL_SEQUENCE_NUMBER, LETTER_REPEATING_GROUP_CD, SEQUENCE_NUMBER).
• Referenced Foreign Keys (Parent Tables):
  • IGS_CO_LTR_RPT_GRP_ALL: Validates the repeating group code (CORRESPONDENCE_TYPE, LETTER_REFERENCE_NUMBER, LETTER_REPEATING_GROUP_CD).
  • IGS_CO_S_PER_LTR_ALL: Links to the parent person letter record (PERSON_ID, CORRESPONDENCE_TYPE, LETTER_REFERENCE_NUMBER, SPL_SEQUENCE_NUMBER).
  • IGS_CO_S_PERLT_RPTGP_ALL (Self-Referential): Establishes hierarchical relationships between repeating groups via (PERSON_ID, CORRESPONDENCE_TYPE, LETTER_REFERENCE_NUMBER, SPL_SEQUENCE_NUMBER, SUP_REPEATING_GROUP_CD, SUP_SPLRG_SEQUENCE_NUMBER).
• Referencing Foreign Keys (Child Tables):
  • IGS_CO_S_PER_LT_PARM_ALL: Stores the actual parameter values for each repeating group instance, linked via the full primary key.
  • IGS_CO_S_PERLT_RPTGP_ALL (Self-Referential): Child repeating groups reference their parent group within the same table.