Search Results igs_co_s_ltr_pr_rstn_pk

Overview

The table IGS_CO_S_LTR_PR_RSTN is a data object within the Oracle E-Business Suite (EBS) Student System (IGS). Its primary function is to define and enforce restrictions on system letter parameter types for specific correspondence types. In essence, it acts as a control table that dictates which parameters (S_LETTER_PARAMETER_TYPE) are valid or restricted for use when generating a particular type of system-generated correspondence (CORRESPONDENCE_TYPE). This ensures data integrity and consistency in automated letter generation by preventing incompatible parameters from being associated with a letter template. It is critical to note that, per the provided ETRM documentation, this table is part of the "Student System (Obsolete)" module and was marked as "Not implemented in this database" for the documented instance, indicating it may be a legacy or planned structure not actively used in all deployments of EBS 12.1.1 or 12.2.2.

Key Information Stored

The table's structure is defined by a composite primary key and two foreign key relationships. The primary key, IGS_CO_S_LTR_PR_RSTN_PK, is composed of two columns that uniquely identify each restriction rule. The S_LETTER_PARAMETER_TYPE column stores the code for a specific parameter type that is being restricted. The CORRESPONDENCE_TYPE column stores the code for the type of correspondence to which the restriction applies. Together, each record represents a single rule stating that a given parameter type cannot be used with a given correspondence type. The table does not appear to contain descriptive or audit columns beyond these identifiers, suggesting its purpose is purely relational.

Common Use Cases and Queries

The primary use case is administrative setup and validation during the letter generation process. A system process or a forms-based setup interface would query this table to validate parameter selections or to present only allowed parameters to a user. For example, before populating a letter, a validation routine would check for restrictions. A common query pattern would be a join to the parameter and correspondence type descriptive tables to generate a readable list of all active restrictions.

• Validation Check: SELECT 'RESTRICTED' FROM igs_co_s_ltr_pr_rstn WHERE correspondence_type = :corr_type AND s_letter_parameter_type = :param_type;
• Reporting All Restrictions: SELECT ct.correspondence_type, ct.description, pt.param_type, pt.meaning FROM igs_co_s_ltr_pr_rstn r, igs_co_type ct, igs_co_s_ltr_param pt WHERE r.correspondence_type = ct.correspondence_type AND r.s_letter_parameter_type = pt.s_letter_parameter_type ORDER BY 1, 3;

Related Objects

IGS_CO_S_LTR_PR_RSTN has defined dependencies on two other core tables in the correspondence system, as established by its foreign keys. The CORRESPONDENCE_TYPE column is a foreign key referencing the IGS_CO_TYPE table, which holds the master list of all available correspondence types (e.g., admission letters, fee notices). The S_LETTER_PARAMETER_TYPE column is a foreign key referencing the IGS_CO_S_LTR_PARAM table, which defines the master list of all system letter parameters (e.g., student name, course code, due date). These relationships ensure that restriction rules can only be created for valid, pre-defined correspondence and parameter types, maintaining referential integrity within the module.