Search Results igs_en_cat_mapping_pk

Overview

The IGS_EN_CAT_MAPPING table is a core data structure within the Oracle E-Business Suite Student System (IGS) module. Its primary function is to define and maintain the relationship between two critical student classifications: enrollment categories and admission categories. This mapping is essential for ensuring data integrity and operational logic as a student progresses through their academic lifecycle. The table acts as a reference point, allowing the system to correctly associate a student's admission classification with the appropriate ongoing enrollment classification, which governs aspects like fee assessment, academic standing, and reporting. Its role is foundational for processes that require a consistent transition from admission status to active enrollment status.

Key Information Stored

The table's structure is concise, consisting of two primary columns that form a composite primary key. The ENROLMENT_CAT column stores the code for the category under which a student is formally enrolled for a term or program. The ADMISSION_CAT column stores the code for the category under which the student was originally admitted to the institution. The relationship defined by a row in this table indicates that for a given admission category, a specific enrollment category is the valid corresponding classification. This one-to-one or one-to-many mapping is controlled and validated by the primary key constraint (IGS_EN_CAT_MAPPING_PK).

Common Use Cases and Queries

A primary use case is during the enrollment process, where the system automatically determines the correct enrollment category for a student based on their recorded admission category. This is critical for batch enrollment jobs and individual student enrollment forms. For reporting, the table is frequently joined to student data to analyze populations by their admission-to-enrollment pathways. A common diagnostic or validation query would check for students whose current enrollment category does not align with the mapped value from their admission category. A typical SQL pattern to retrieve the full mapping is:

• SELECT enrolment_cat, admission_cat FROM igs.igs_en_cat_mapping ORDER BY admission_cat;

To find the enrollment category for a specific admitted student, a join would be performed between the student's admission record (likely in IGS_AD_APPLICATIONS or related tables), this mapping table, and the enrollment record.

Related Objects

The IGS_EN_CAT_MAPPING table maintains formal foreign key relationships with two key reference tables, ensuring data consistency. The ADMISSION_CAT column is a foreign key referencing the IGS_AD_CAT_ALL table, which contains the master list of all valid admission categories. The ENROLMENT_CAT column is a foreign key referencing the IGS_EN_ENROLMENT_CAT table, which is the master list of all valid enrollment categories. These relationships enforce that only predefined, valid codes from the respective master tables can be used in the mapping. Consequently, this table is a central link between the admission (AD) and enrollment (EN) functional areas of the Student System.