Search Results mapping_set_cd




Overview
Explore in AI Chat

Overview

The IGS_EN_UNIT_SET_MAP table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Student Management (iGrants) module. It functions as a mapping or configuration table that defines logical groupings and sequences of academic unit sets. Its primary role is to establish relationships between a defined mapping set and specific unit set versions, enabling structured academic planning and progression rules. The table is essential for processes that require an ordered list of unit sets, such as mapping prerequisite streams or defining enrollment patterns within a program structure.

Key Information Stored

The table's design centers on four key columns that form its composite primary key, defining a unique mapping entry. The MAPPING_SET_CD is a VARCHAR2(30) field acting as the "Grouping Name," which identifies the specific mapping configuration. The SEQUENCE_NO (NUMBER) dictates the order of unit sets within that group. The STREAM_UNIT_SET_CD (VARCHAR2(10)) holds the code for the academic unit set that belongs to the stream, and the US_VERSION_NUMBER (NUMBER) specifies the precise version of that unit set. Standard FND "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track row-level audit information. The mandatory nature of the primary key columns underscores the criticality of complete and unique mapping definitions.

Common Use Cases and Queries

A primary use case is retrieving the ordered sequence of unit sets for a specific mapping configuration, which is vital for generating academic pathway reports or validating student progression. For example, to audit all mappings for a configuration code 'MAJOR_STREAM_101', a developer or analyst would execute:

  • SELECT MAPPING_SET_CD, SEQUENCE_NO, STREAM_UNIT_SET_CD, US_VERSION_NUMBER FROM IGS.IGS_EN_UNIT_SET_MAP WHERE MAPPING_SET_CD = 'MAJOR_STREAM_101' ORDER BY SEQUENCE_NO;

Another common scenario involves joining this table to the unit set definition table (IGS_EN_UNIT_SET_ALL) to get descriptive details for the mapped unit sets. This is frequently used in custom enrollment reports or interfaces that need to present a human-readable academic plan. Data integrity checks often query for mappings that reference invalid or inactive unit set versions by leveraging the foreign key relationships.

Related Objects

The IGS_EN_UNIT_SET_MAP table maintains defined relationships with other critical EBS tables, as indicated by its foreign key constraints. Its MAPPING_SET_CD column references the IGS_PS_US_PRENR_CFG table, linking the mapping group to a broader unit set pre-enrollment configuration. Furthermore, the STREAM_UNIT_SET_CD column references the IGS_EN_UNIT_SET_ALL table, which is the master repository for all academic unit set definitions. The primary key index, IGS_EN_UNIT_SET_MAP_PK, enforces uniqueness on the combination of these four key columns. The table is also referenced by an APPS synonym (IGS_EN_UNIT_SET_MAP), which is the standard access point for application code within the EBS environment.