Search Results igs_en_unit_set_map




Overview
Explore in AI Chat

Overview

The IGS_EN_UNIT_SET_MAP table is a core data object within the Oracle E-Business Suite Student System (IGS). It functions as a mapping or junction table, defining the relationship between a pre-enrollment configuration and the specific unit sets (or streams) that constitute it. Its primary role is to support the academic structure by allowing administrators to model complex course requirements, where a student's enrollment in a primary unit set can be mapped to one or more related, or "stream," unit sets. This mapping is essential for enforcing prerequisite rules, managing co-requisite enrollments, and automating the enrollment process in structured academic programs within Oracle EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table stores a composite record for each mapping entry, uniquely identified by its primary key. The critical columns are the mapping set code (MAPPING_SET_CD) and sequence number (SEQUENCE_NO), which together link to a pre-enrollment configuration rule. The stream unit set code (STREAM_UNIT_SET_CD) and its corresponding version number (US_VERSION_NUMBER) identify the specific academic unit set that is part of that mapping. This structure allows a single configuration rule (MAPPING_SET_CD) to be associated with multiple stream unit sets, ordered or differentiated by the SEQUENCE_NO.

Common Use Cases and Queries

A primary use case is validating and processing student enrollments. When a student enrolls in a primary unit of study, the system consults this table to determine if mandatory or optional concurrent enrollment in other unit sets is required. For reporting, administrators often query this table to audit the composition of academic streams. A typical SQL pattern involves joining to the related unit set table to get descriptive information:

  • SELECT map.*, us.unit_set_name FROM igs_en_unit_set_map map JOIN igs_en_unit_set_all us ON map.stream_unit_set_cd = us.unit_set_cd AND map.us_version_number = us.version_number WHERE map.mapping_set_cd = '&MAPPING_CODE' ORDER BY map.sequence_no;

This query lists all stream unit sets defined for a given mapping configuration, which is crucial for troubleshooting enrollment errors or reviewing program structures.

Related Objects

The IGS_EN_UNIT_SET_MAP table has defined foreign key relationships with two key tables in the Student System, as documented in the ETRM metadata:

  • IGS_PS_US_PRENR_CFG: The table references this configuration table via the MAPPING_SET_CD and SEQUENCE_NO columns. This defines the rule to which the stream mapping belongs.
  • IGS_EN_UNIT_SET_ALL: The table references this master table of all unit sets via the STREAM_UNIT_SET_CD and US_VERSION_NUMBER columns. This identifies the actual academic stream being mapped.

These relationships ensure referential integrity, meaning a mapping record must point to a valid pre-enrollment configuration and a valid, versioned unit set. Understanding these joins is critical for any data extraction or integration involving academic program rules.