Search Results admission_cat




Overview
Explore in AI Chat

Overview

The IGS.IGS_EN_CAT_MAPPING table is a core configuration table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) product, which operates under the IGS schema. Its primary function is to define the relationship between admission categories and enrollment categories. This mapping is a critical business rule that determines which enrollment category is assigned to a student upon successful admission, thereby linking the admissions process to subsequent enrollment and academic career management. The table ensures students are correctly categorized for the appropriate tuition, fee assessment, and academic policy enforcement based on their original admission path.

Key Information Stored

The table stores the mapping rules and associated metadata through the following key columns:

  • ENROLMENT_CAT: A mandatory VARCHAR2(10) column storing the unique code for an Enrolment Category. This category defines the processes for enrolling specific student groups.
  • ADMISSION_CAT: A mandatory VARCHAR2(10) column storing the code for an Admission Category, such as 'STANDARD' or 'INTERNAT', which groups applicants for common admission procedures.
  • DFLT_CAT_IND: A VARCHAR2(1) indicator specifying whether the linked enrolment category is the default for the given admission category. This is crucial when multiple mappings exist for a single admission category.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Audit columns that track the creation and modification history of each mapping record.

The table is enforced with a unique constraint (IGS_EN_CAT_MAPPING_U1) on the combination of ENROLMENT_CAT and ADMISSION_CAT, preventing duplicate mappings. A non-unique index (IGS_EN_CAT_MAPPING_N2) on ADMISSION_CAT optimizes queries to find all enrollment categories for a given admission type.

Common Use Cases and Queries

This table is primarily referenced by application logic during student enrollment setup. A common operational use case is identifying the default enrollment category for a newly admitted student based on their admission category, which dictates their academic pathway. For reporting and troubleshooting, administrators often query this table to audit configuration rules. A sample query to retrieve all mappings, highlighting the default for each admission category, is:

SELECT admission_cat, enrolment_cat, dflt_cat_ind
FROM igs.igs_en_cat_mapping
ORDER BY admission_cat, dflt_cat_ind DESC;

Another critical query pattern involves finding the specific enrollment category for a student by joining through admission records. For instance, when investigating why a student was placed in a particular enrollment category, one would join this table with the student's admission application data using the ADMISSION_CAT column as the key.

Related Objects

While the provided dependency information states the table is not referenced by other database objects, this is atypical for a core configuration table. In practice, the IGS_EN_CAT_MAPPING table is logically and functionally central to the OSM module. It is referenced by application code (e.g., PL/SQL packages and forms) within the IGS schema that handles student enrollment processing. The table's data is intrinsically linked to setup data in tables defining valid admission categories (e.g., IGS_AD_CAT) and enrollment categories (e.g., IGS_EN_CAT). Its configuration directly impacts runtime behavior in student enrollment workflows, making it a key dependency for those processes, even if not via a direct database foreign key constraint.