Search Results dflt_cat_ind

Overview

The IGS_CO_CAT_MAP table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Student System (often part of the Campus Solutions or Oracle Student Management product). Owned by the IGS schema, this table functions as a control and mapping mechanism within the correspondence management subsystem. Its primary role is to define and enforce business rules that restrict which correspondence categories can be allocated to students based on their admission category. This ensures that communications, such as system-generated letters and documents, are appropriately targeted and relevant to the student's application type and status.

Key Information Stored

The table stores mapping records with three critical user-defined columns that establish the business rule, alongside standard audit columns. The CORRESPONDENCE_CAT column holds a code representing a predefined set of correspondence items. The ADMISSION_CAT column contains a code for a group of applicants processed through common admission procedures. The pivotal DFLT_CAT_IND column is a flag (typically 'Y' or 'N') that specifies whether the associated correspondence category is the default for the linked admission category. Only one record per admission category should logically have this indicator set, defining the standard communication set for that applicant group. The CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN columns provide standard EBS "Who" audit information.

Common Use Cases and Queries

A primary use case is validating and determining the permissible or default correspondence category for a student during an automated or manual correspondence process. System logic would query this table using the student's admission category to fetch the allowed or default correspondence categories. Administrators may also use this data for setup validation and reporting. Common SQL patterns include identifying the default category for a specific admission path or listing all valid mappings.

• Find the default correspondence category for a given admission category: SELECT CORRESPONDENCE_CAT FROM IGS.IGS_CO_CAT_MAP WHERE ADMISSION_CAT = '&ADM_CAT' AND DFLT_CAT_IND = 'Y';
• List all valid correspondence category mappings for reporting: SELECT ADMISSION_CAT, CORRESPONDENCE_CAT, DFLT_CAT_IND FROM IGS.IGS_CO_CAT_MAP ORDER BY ADMISSION_CAT, DFLT_CAT_IND DESC;

Related Objects

Based on the provided dependency information, the IGS_CO_CAT_MAP table is referenced by an object named IGS_CO_CAT_MAP within the APPS schema, which is likely a synonym or a view providing a public interface to the underlying IGS table. The table itself does not reference other objects. Its integrity is enforced by two indexes: IGS_CO_CAT_MAP_U1, a unique constraint on the combination of CORRESPONDENCE_CAT and ADMISSION_CAT preventing duplicate mappings, and IGS_CO_CAT_MAP_N1, a non-unique index on ADMISSION_CAT for performance on lookups by admission category. This table is foundational for modules that generate student correspondence, and it would logically relate to master tables defining the valid lists of CORRESPONDENCE_CAT and ADMISSION_CAT codes, though those specific foreign key relationships are not detailed in the provided metadata.