Search Results igs_co_ltr_pr_rstcn_all




Overview
Explore in AI Chat

Overview

The table IGS_CO_LTR_PR_RSTCN_ALL is a data object within the Oracle E-Business Suite (EBS) Student System (IGS). As indicated by its description, it is responsible for defining restrictions on user-defined letter parameter types based on correspondence types. This table establishes a many-to-many relationship, controlling which specific parameter types are valid or applicable for use with different categories of correspondence (e.g., letters, notifications). Its role is to enforce data integrity and business rules within the correspondence generation functionality of the obsolete Student System module. The metadata explicitly states this table was "Not implemented in this database," indicating it may exist as a placeholder or its functionality was superseded in the referenced EBS instances (12.1.1 / 12.2.2).

Key Information Stored

The table's structure is defined by its composite primary key, which consists of two core columns. The first, LETTER_PARAMETER_TYPE, stores the code or identifier for a user-defined parameter that can be populated within a correspondence template. The second, CORRESPONDENCE_TYPE, stores the code or identifier for a category of correspondence. Together, each unique row in this table represents a rule permitting a specific parameter type to be utilized for a specific correspondence type. No other column details are provided in the available metadata.

Common Use Cases and Queries

Given its restriction-based design, primary use cases involve validation and configuration. During the setup or generation of a letter, an application process would query this table to validate if a parameter being referenced is allowed for the letter's correspondence type. A typical query would check for the existence of a restriction record. For reporting or administrative purposes, queries might list all parameter types available for a given correspondence type or audit the configured restrictions.

  • Validation Query: SELECT 1 FROM igs_co_ltr_pr_rstcn_all WHERE letter_parameter_type = :1 AND correspondence_type = :2;
  • Configuration Report: SELECT correspondence_type, letter_parameter_type FROM igs_co_ltr_pr_rstcn_all ORDER BY 1, 2;

Related Objects

The documented foreign key relationship defines this table's primary dependency. IGS_CO_LTR_PR_RSTCN_ALL references the IGS_CO_LTR_PARM_TYPE table via the LETTER_PARAMETER_TYPE column. This ensures that any parameter type specified in a restriction must already be defined as a valid user-defined letter parameter. The relationship data confirms the primary key IGS_CO_LTR_PR_RSTCN_PK is on the combination of LETTER_PARAMETER_TYPE and CORRESPONDENCE_TYPE. No other foreign keys or referencing objects are detailed in the provided metadata.