Search Results correspondence_cat




Overview
Explore in AI Chat

Overview

The IGS.IGS_CO_CAT table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) or Campus Solutions modules, owned by the IGS schema. It serves as the master repository for defining correspondence categories, which are institution-defined classifications used to group and manage various types of correspondence sent to students. These categories are fundamental for organizing both system-generated and manually created correspondence items, enabling structured communication workflows and tracking within the student lifecycle.

Key Information Stored

The table stores the essential attributes that define a correspondence category. The primary column, CORRESPONDENCE_CAT (VARCHAR2(10)), holds the unique institution-defined code that identifies the category. The DESCRIPTION (VARCHAR2(60)) column provides the full name or explanation of the category's purpose. A critical functional column is CLOSED_IND (VARCHAR2(1)), which acts as an active/inactive flag; when set, it closes the category, preventing new student assignments while preserving historical data. The table also includes standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing and compliance.

Common Use Cases and Queries

This table is central to queries and reports concerning student communications. Common use cases include generating lists of all active correspondence categories for setup or maintenance purposes, validating category codes during data entry, and filtering correspondence reports by category. A typical query to retrieve all active categories for a lookup would be:

  • SELECT CORRESPONDENCE_CAT, DESCRIPTION FROM IGS.IGS_CO_CAT WHERE CLOSED_IND = 'N' ORDER BY CORRESPONDENCE_CAT;

For audit or data quality purposes, administrators might run queries to identify categories created or modified within a specific timeframe, leveraging the standard Who columns. The table is also frequently joined to transactional correspondence tables to analyze communication volumes by category type.

Related Objects

The IGS_CO_CAT table is a key parent table in the data model, referenced by several other transactional and mapping tables via foreign key relationships. These documented relationships are:

  • IGS_AD_PS_APPL_INST_ALL.CORRESPONDENCE_CAT: Links correspondence categories to specific application instances, likely tracking required communications for applicants.
  • IGS_CO_CAT_ITM.CORRESPONDENCE_CAT: Associates individual correspondence items or templates with a broader category, defining the specific documents within a category.
  • IGS_CO_CAT_MAP.CORRESPONDENCE_CAT: Likely used for mapping or translating correspondence categories to other system values or external standards.

The primary key constraint IGS_CO_CAT_PK on the CORRESPONDENCE_CAT column enforces the uniqueness of category codes, ensuring data integrity across these dependent objects.