Search Results igs_co_ltr_parm_type




Overview
Explore in AI Chat

Overview

The IGS_CO_LTR_PARM_TYPE table is a core data dictionary table within the Oracle E-Business Suite Student System (IGS) module. It serves as the master repository for defining user-configurable letter parameter types. These parameter types are essential for the correspondence generation functionality, as they define the dynamic data elements that can be merged into standardized letter templates. The table's primary role is to provide a validated list of available parameter types, ensuring data integrity and consistency across all letter-related processes in the application, from admissions communication to general student correspondence.

Key Information Stored

The table's structure is designed to catalog unique parameter types. Its central column is LETTER_PARAMETER_TYPE, which serves as the primary key. This column stores the unique code identifying each user-defined parameter type, such as 'APPLICANT_NAME' or 'COURSE_START_DATE'. The table maintains a critical foreign key relationship to the IGS_CO_S_LTR_PARAM table via the S_LETTER_PARAMETER_TYPE column. This relationship links the user-defined type to its system-defined source or validation rules, governing how the parameter's data is sourced and processed during the mail merge operation.

Common Use Cases and Queries

This table is primarily referenced during the setup and execution of correspondence generation. Administrators query it to review or maintain the list of available parameters when creating or modifying letter templates. A common reporting use case involves auditing which parameter types are in active use. A typical SQL query to list all defined parameter types and their associated system sources would be:

  • SELECT lpt.letter_parameter_type, slp.meaning FROM igs_co_ltr_parm_type lpt, igs_co_s_ltr_param slp WHERE lpt.s_letter_parameter_type = slp.s_letter_parameter_type;

Another frequent operational query is to validate a parameter type before using it in a template or batch process, often by checking for its existence in this master table.

Related Objects

The IGS_CO_LTR_PARM_TYPE table is central to the correspondence data model, with documented relationships to several key tables. The primary key IGS_CO_LTR_PARM_TYPE_PK on LETTER_PARAMETER_TYPE is referenced by the following foreign keys:

  • IGS_AD_APPL_LTR_PHR.LETTER_PARAMETER_TYPE: Links parameter types to specific phrases used in admissions application letters.
  • IGS_CO_LTR_PR_RSTCN_ALL.LETTER_PARAMETER_TYPE: Associates parameter types with restriction rules that control their availability or usage.
  • IGS_CO_LTR_PARAM.LETTER_PARAMETER_TYPE: Connects the master parameter type definition to its specific instance values stored for individual letters or correspondence runs.

Furthermore, this table references the IGS_CO_S_LTR_PARAM table via its own foreign key on S_LETTER_PARAMETER_TYPE, establishing the link to system-level parameter definitions.