Search Results att_mode

Overview

The IGS_CO_S_LTR_PARAM table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle's Student Systems) product family. It serves as the master repository for system-recognized parameters that can be dynamically merged into correspondence or letter templates. This table defines the universe of available data tokens—such as student surname, location, or attendance mode (ATT_MODE)—that can be inserted into template-driven communications, enabling personalized and automated document generation. Its role is critical for configuring and maintaining the correspondence engine's data mapping capabilities.

Key Information Stored

The table's structure is designed to define, describe, and control the execution logic for each merge parameter. The primary and most significant column is S_LETTER_PARAMETER_TYPE (VARCHAR2(10)), which stores the unique code for the parameter, such as 'SURNAME', 'LOCATION', or 'ATT_MODE'. The DESCRIPTION column (VARCHAR2(60)) provides a clear, human-readable explanation of the parameter's purpose. A critical functional column is CODE_BLOCK (VARCHAR2(2000)), which contains the PL/SQL code executed as dynamic SQL to retrieve the correct data value for the parameter during the merge process. The CLOSED_IND flag controls whether the parameter definition is open for use or closed. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track auditing information.

Common Use Cases and Queries

A primary use case is the administration and review of available merge parameters for letter template configuration. System administrators query this table to understand what data points are available for inclusion in templates. For instance, to find the parameter related to a user's search for "att_mode", the following query would be executed:

• SELECT s_letter_parameter_type, description, closed_ind FROM igs.igs_co_s_ltr_param WHERE UPPER(s_letter_parameter_type) LIKE '%ATT_MODE%' OR UPPER(description) LIKE '%ATTENDANCE%';

Another common operational query retrieves all active parameters for documentation or integration purposes:

• SELECT s_letter_parameter_type, description, code_block FROM igs.igs_co_s_ltr_param WHERE closed_ind = 'N' ORDER BY 1;

During the letter generation runtime, the system internally references the CODE_BLOCK for a specific S_LETTER_PARAMETER_TYPE to execute the logic that fetches the actual data value for a given student or context.

Related Objects

The IGS_CO_S_LTR_PARAM table acts as a parent reference table for several key objects in the correspondence module, as defined by its primary key and foreign key relationships. Its primary key, IGS_CO_S_LTR_PARAM_PK, is on the S_LETTER_PARAMETER_TYPE column. This key is referenced by the following tables:

• IGS_CO_LTR_PARM_TYPE: Links system parameters to specific letter templates, defining which parameters are applicable to which template.
• IGS_CO_S_LTR_PR_ARG: Stores arguments required for the PL/SQL code block defined in the parent parameter's CODE_BLOCK column.
• IGS_CO_S_LTR_PR_RSTN: Likely defines restrictions or validations for the use of a system parameter in certain contexts.

These relationships ensure data integrity and form the foundation for the flexible and configurable correspondence system within Oracle EBS IGS.