Search Results s_letter_parameter_type




Overview
Explore in AI Chat

Overview

The IGS_CO_LTR_PARM_TYPE table is a core data definition table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (Campus Solutions) product. It serves as the master repository for defining all parameters that can be dynamically merged into system-generated letter templates. These parameters act as placeholders within a letter's text, which the system replaces with actual data, rules, or static text at runtime. This functionality is critical for creating personalized, context-aware communications such as admission letters, financial aid notifications, and academic status updates. The table supports both institution-defined (custom) parameters and seeded system parameters, providing a flexible framework for communication management.

Key Information Stored

The table's structure is designed to categorize and control the use of letter parameters. The primary columns and their functions are:

  • LETTER_PARAMETER_TYPE: The unique identifier (code) for a parameter, whether institution-defined or system-defined. This is the table's primary key.
  • S_LETTER_PARAMETER_TYPE: A critical column that classifies the parameter into a system-recognized category (e.g., 'LETTERTEXT', 'RULE', 'OBJECT'). It is a foreign key to the system parameter lookup (IGS_CO_S_LTR_PARAM).
  • DESCRIPTION: A clear explanation of the parameter's purpose and usage.
  • LETTER_TEXT: Holds the static text to be substituted when the S_LETTER_PARAMETER_TYPE is 'LETTERTEXT'. This text appears in every letter using this parameter code.
  • CLOSED_IND: A flag indicating whether the parameter is active ('N') or closed ('Y'). Closing a parameter prevents its assignment to new system letters, enforcing data integrity over time.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): For auditing and tracking changes.

Common Use Cases and Queries

This table is central to configuring and auditing the letter generation system. Common operational and reporting tasks include:

  • Auditing Active Parameters: Identifying all available, non-closed parameters for use in new letter templates.

    SELECT letter_parameter_type, description, s_letter_parameter_type FROM igs.igs_co_ltr_parm_type WHERE closed_ind = 'N' ORDER BY 1;

  • Identifying Text-Based Parameters: Listing all parameters that insert static text blocks into letters.

    SELECT letter_parameter_type, description, letter_text FROM igs.igs_co_ltr_parm_type WHERE s_letter_parameter_type = 'LETTERTEXT';

  • Parameter Dependency Check: Before closing a parameter, verifying if it is still referenced by active letter phrases or rules.

    -- This would involve joining to IGS_CO_LTR_PARAM, IGS_AD_APPL_LTR_PHR, etc.

Related Objects

The IGS_CO_LTR_PARM_TYPE table is a key reference point within the letter generation subsystem. Its primary and foreign key relationships are documented as follows:

  • Primary Key: IGS_CO_LTR_PARM_TYPE_PK on (LETTER_PARAMETER_TYPE).
  • Referenced Lookup Table:
    • IGS.IGS_CO_S_LTR_PARAM via column S_LETTER_PARAMETER_TYPE. This validates the system parameter category.
  • Referencing Child Tables:
    • IGS_AD_APPL_LTR_PHR via LETTER_PARAMETER_TYPE. Links parameters to application letter phrases.
    • IGS_CO_LTR_PR_RSTCN_ALL via LETTER_PARAMETER_TYPE. Associates parameters with restriction rules.
    • IGS_CO_LTR_PARAM via LETTER_PARAMETER_TYPE. The central table that assigns specific parameter values to letter requests.