Results for “enrolment_cat”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_EN_CAT_MAPPING is a reference table in the IGS (Student System) product of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. Its documented purpose is to describe the mapping of enrollment categories to admission categories. In practical terms, it defines which admission categories are considered valid for a given enrollment category, thereby supporting the derivation or validation of admissions data from enrollment records during student lifecycle processing.

Under the heuristic Data Vault classification mined from its foreign key structure, this object is best modeled as a link table. It resolves a many-to-many-style association between two independent business entities — an enrollment category and an admission category — rather than storing descriptive attributes of either entity in isolation. A link classification is a modeling suggestion only; in an operational EBS context the table functions as a cross-reference or mapping table used for validation and defaulting logic.

Key Information Stored

The table is documented with eight physical columns in the ETRM 12.1.1 schema, with the IGS schema as owner. The most significant columns are:

The surrogate primary key for this object is IGS_EN_CAT_MAPPING_PK, defined on the pair (ENROLMENT_CAT, ADMISSION_CAT). Because the table uses a composite natural key rather than a generated surrogate identifier, the same column pair also serves as the primary business-key candidate through the unique index IGS_EN_CAT_MAPPING_U1 on (ENROLMENT_CAT, ADMISSION_CAT). This ensures that any given enrollment-to-admission category pairing appears at most once.

Common Use Cases and Queries

Typical usage centers on validating or defaulting admission categories when enrollment data is captured. A common query lists all admission categories mapped to a given enrollment category:

SELECT admission_cat, dflt_cat_ind
FROM   igs_en_cat_mapping
WHERE  enrolment_cat = :p_enrolment_cat;

To identify the default mapped category, the DFLT_CAT_IND column is filtered:

SELECT admission_cat
FROM   igs_en_cat_mapping
WHERE  enrolment_cat = :p_enrolment_cat
AND    dflt_cat_ind = 'Y';

Reporting use cases include validating setup completeness — detecting enrollment categories with no mapped admission categories — and auditing changes to mapping rules over time using the audit who-columns. Integration scenarios may use the table to translate incoming admission category codes into valid enrollment category contexts, or to enforce referential integrity when loading student data from external systems.

Related Objects

The following objects are directly related through documented foreign keys and the primary key definition:

  • IGS_EN_ENROLMENT_CAT — Referenced by IGS_EN_CAT_MAPPING.ENROLMENT_CAT; holds the definition of enrollment categories.
  • IGS_AD_CAT_ALL — Referenced by IGS_EN_CAT_MAPPING.ADMISSION_CAT; holds admission category definitions and is the parent of the admission category foreign key.
  • IGS_EN_CAT_MAPPING_PK — The composite primary key constraint on (ENROLMENT_CAT, ADMISSION_CAT).
  • IGS_EN_CAT_MAPPING_U1 — The unique index supporting the documented business-key candidate on (ENROLMENT_CAT, ADMISSION_CAT).
  • Enrollment and admissions processing forms and concurrent programs in the IGS module that consume enrollment-to-admission category mappings during data entry and validation.

The foreign key dependencies establish IGS_EN_CAT_MAPPING as a dependent child of both the enrollment category and admission category entity tables, which is consistent with its heuristic classification as a link object.