Search Results igs_en_unit_set_all




Overview
Explore in AI Chat

Overview

The IGS_EN_UNIT_SET_ALL table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) for releases 12.1.1 and 12.2.2. It serves as the master repository for defining unit sets, which are logical sub-groupings or specializations within an academic course. These groupings, such as Majors, Minors, Streams, or Strands, represent a structured collection of units (subjects) that a student can undertake as part of their broader course of study. The table's primary role is to store the definitional metadata for each unit set, which is then integrated with the Rules Sub-system to govern the completion requirements and academic progression for students enrolled in these specializations. The "_ALL" suffix indicates it is a multi-org enabled table, capable of storing data for multiple operating units.

Key Information Stored

The table's structure is designed to uniquely identify and describe each version of a unit set. The primary key is a composite of UNIT_SET_CD and VERSION_NUMBER, establishing a version-controlled model for academic structures. While the provided ETRM excerpt does not list all columns, the key fields implied by its relationships and purpose include the unit set code, a descriptive name, its effective dates (start and end), the associated course code, and the unit set type (e.g., MAJOR, MINOR). The version number is critical for tracking curriculum changes over time, allowing historical student enrollments to be linked to the specific rule version they followed.

Common Use Cases and Queries

This table is central to numerous academic and administrative processes. Common use cases include defining and maintaining curriculum specializations, validating student enrollment against unit set rules, and generating reports on student populations within specific majors or streams. For reporting, a typical query might join this table to student enrollment or course offering tables. A fundamental SQL pattern retrieves active unit sets for a given course:

  • SELECT unit_set_cd, version_number FROM igs_en_unit_set_all WHERE course_cd = '&course_code' AND SYSDATE BETWEEN start_dt AND NVL(end_dt, SYSDATE);

Another critical pattern involves joining to the IGS_PS_OFR_UNIT_SET table to understand which unit sets are offered in specific academic periods (calendars). Data from this table also feeds into fee assessment logic, where charges may be tied to a student's chosen unit set.

Related Objects

The IGS_EN_UNIT_SET_ALL table has extensive relationships across the Student System, as evidenced by its foreign key constraints. Key related objects include:

These relationships are primarily established via joins on the composite key columns: UNIT_SET_CD and VERSION_NUMBER (or US_VERSION_NUMBER).