Search Results igs_ad_prcs_cat_ltr




Overview
Explore in AI Chat

Overview

The table IGS_AD_PRCS_CAT_LTR is a data object within the Oracle E-Business Suite module IGS (Student System), which is documented as obsolete. This table functions as a configuration or mapping table, defining the specific system-generated letters (correspondence) that are produced for distinct admission process categories. Its role is to establish a formal link between an admission category, the type of admission process, and the predefined correspondence templates or letters used within that process flow, thereby automating and standardizing communication in the admissions lifecycle.

Key Information Stored

The table's structure is defined by a composite primary key, indicating that the unique record is identified by the combination of three columns. The key columns are ADMISSION_CAT, which holds the code for the admission category; S_ADMISSION_PROCESS_TYPE, which stores the type of admission process; and CORRESPONDENCE_TYPE, which contains the code for the specific letter or correspondence. While the provided metadata does not list all columns explicitly, the foreign key relationships suggest the presence of a LETTER_REFERENCE_NUMBER column, which likely points to the detailed definition or template of the letter in a related correspondence table.

Common Use Cases and Queries

Primary use cases involve the setup and retrieval of letter assignments for admission workflows. Administrators would use this table to configure which acceptance, rejection, or request-for-information letters are automatically triggered for different types of applicants (e.g., undergraduate, graduate) and processes (e.g., early decision, regular admission). A common reporting query would join this table to the admission category master table to list all configured letters. A typical SQL pattern for retrieving this mapping would be:

  • SELECT ltr.admission_cat, ltr.s_admission_process_type, ltr.correspondence_type, cat.description FROM igs_ad_prcs_cat_ltr ltr, igs_ad_prcs_cat_all cat WHERE ltr.admission_cat = cat.admission_cat AND ltr.s_admission_process_type = cat.s_admission_process_type;

Another critical use case is validating letter availability before generating correspondence for an applicant within a specific admission category and process.

Related Objects

This table maintains defined relationships with other entities in the Student System schema, primarily through foreign key constraints. The documented relationships are:

  • IGS_AD_PRCS_CAT_ALL: This is the master table for admission process categories. The IGS_AD_PRCS_CAT_LTR table references it via the columns ADMISSION_CAT and S_ADMISSION_PROCESS_TYPE. This ensures that a letter configuration is always associated with a valid, pre-defined admission category and process type.
  • An unspecified Correspondence Table: The foreign key on the CORRESPONDENCE_TYPE and LETTER_REFERENCE_NUMBER columns indicates a relationship to a separate table that stores the master definition of correspondence types and their content (likely named IGS_CORRESPONDENCE or similar). This links the configuration to the actual letter template.

The primary key IGS_AD_PRCS_CAT_LTR_PK enforces uniqueness on the combination of these three key columns, preventing duplicate letter assignments for the same admission process category.