Search Results igs_co_cat_map

Overview

The IGS_CO_CAT_MAP table is a data object within the Oracle E-Business Suite Student System (IGS), which is documented as obsolete. Its primary function is to enforce business rules governing student communications by defining and restricting the allocation of correspondence categories based on a student's admission category. This mapping ensures that specific types of correspondence, such as letters or notifications, are only available or appropriately assigned to students admitted under certain programs or categories. The table acts as a junction or validation entity between admission categories and correspondence categories, central to maintaining data integrity in student communication workflows.

Key Information Stored

The table's structure is defined by a composite primary key, which consists of two critical columns. The CORRESPONDENCE_CAT column stores the code or identifier for a type of correspondence. The ADMISSION_CAT column stores the code or identifier for a student's admission category. Together, each unique row in this table represents a valid pairing, indicating that the specified correspondence category is permissible for students belonging to the linked admission category. The absence of a mapping would typically restrict the allocation of that correspondence type.

Common Use Cases and Queries

A primary use case is the validation process when generating correspondence for a student. Before assigning a correspondence category, the system would query this table to confirm the student's admission category is authorized for that communication type. For reporting and administration, queries might list all valid mappings or identify which admission categories are linked to a specific correspondence type. A typical SQL pattern to retrieve all permitted correspondence categories for a given admission category would be:

• SELECT correspondence_cat FROM igs_co_cat_map WHERE admission_cat = :p_adm_cat;

Conversely, to audit mappings, an administrator might run a query joining to the related descriptive tables (IGS_CO_CAT, IGS_AD_CAT_ALL) to produce a more readable report of the restrictions in place.

Related Objects

The IGS_CO_CAT_MAP table maintains referential integrity through foreign key relationships to two core tables. The ADMISSION_CAT column is a foreign key referencing the IGS_AD_CAT_ALL table, which holds the master list of admission categories. The CORRESPONDENCE_CAT column is a foreign key referencing the IGS_CO_CAT table, the master table for correspondence categories. These relationships ensure that mappings can only be created for valid, pre-existing categories in the system. It is crucial to note the ETRM metadata explicitly states this table is "Not implemented in this database," indicating it may exist in the data dictionary but is not populated or actively used in a standard deployment.