Search Results igs_co_type




Overview
Explore in AI Chat

Overview

The IGS_CO_TYPE table is a core reference table within the Oracle E-Business Suite (EBS) Student System (IGS) module. Its primary function is to define and maintain the master list of system-defined correspondence types available for use across the institution. A correspondence type categorizes the nature of a communication, such as an admission offer letter, a fee invoice, a grade notification, or a testamur (certificate). This table acts as a central control point, ensuring data integrity and consistency by providing a validated set of types that can be associated with various correspondence items, categories, and templates throughout the system.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key is documented as CORRESPONDENCE_TYPE. This indicates the table's central column is a code or short name that uniquely identifies each type of correspondence. Based on standard EBS design patterns for such reference tables, it likely contains additional descriptive and control columns. These may include an active/inactive indicator (e.g., CLOSED_IND), a meaningful description (e.g., DESCRIPTION), and standard WHO columns for tracking creation and modification details (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE). The table's purpose is to store this static, controlled list of valid types.

Common Use Cases and Queries

This table is fundamental for setup, reporting, and data validation. Administrators use it to review and maintain the list of available correspondence types. Common queries involve listing active types for use in concurrent program parameters or form LOVs. For instance, a report to analyze all correspondence generated for a specific purpose would join through this table. A typical validation or lookup query would be:

  • SELECT correspondence_type, description FROM igs.igs_co_type WHERE closed_ind = 'N' ORDER BY 1;

In a data integrity check, one might identify orphaned child records by joining IGS_CO_TYPE with a child table like IGS_CO_ITM to find items with an invalid correspondence_type code.

Related Objects

The IGS_CO_TYPE table is a key parent table referenced by numerous other objects in the Student System, primarily to enforce referential integrity. As documented, its primary key (CORRESPONDENCE_TYPE) is referenced by foreign keys in several important tables:

This extensive set of foreign key relationships underscores the table's central role in governing and classifying all correspondence processes within the IGS module.