Search Results igs_en_unit_set_cat

Overview

The IGS_EN_UNIT_SET_CAT table is a core reference table within the Oracle E-Business Suite Student System (IGS). It functions as a master list defining the distinct categories or types of unit sets that an educational institution can establish and manage. A unit set represents a structured collection of academic units, such as courses or modules, that form a coherent program component. This table is fundamental for classifying these sets, enabling the system to differentiate between, for example, a primary academic focus (Major), a secondary focus (Minor), a prescribed sequence (Stream), or a general elective list. Its role is to provide a standardized, controlled vocabulary for categorizing unit sets across all student academic program structures, ensuring data integrity and consistency in related processes like degree audit, program planning, and reporting.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary key, the table's description and relationships indicate its core structure. The central column is UNIT_SET_CAT, which serves as the primary key. This column stores the unique code representing each valid unit set category, such as 'MAJOR', 'MINOR', 'STREAM', or 'LIST'. Typically, a corresponding description column (e.g., DESCRIPTION) would also exist to provide a meaningful name for each category code, though this is inferred from standard practice. The table acts as a simple but critical lookup entity, where each row defines one permissible category that can be assigned to unit set records in other transactional tables.

Common Use Cases and Queries

This table is primarily used in validation, reporting, and setup scenarios. Administrators may query it to review or maintain the list of available categories. A common operational use is to populate list-of-values (LOV) in application forms where a unit set category must be selected, such as when defining a new unit set or a Degree Audit setup rule. For reporting, it is frequently joined to transactional data to categorize unit set completions or enrollments. A typical query would retrieve all active categories:

• SELECT unit_set_cat, description FROM igs.igs_en_unit_set_cat WHERE closed_ind = 'N' ORDER BY 1;

Another essential pattern is joining to unit set details, for example, to list all unit sets classified as Majors:

• SELECT us.unit_set_cd, us.version_number, us.title FROM igs.igs_en_unit_set us WHERE us.unit_set_cat = 'MAJOR';

Related Objects

The IGS_EN_UNIT_SET_CAT table is referenced by foreign keys in other setup and configuration tables, primarily within the Degree Audit module. As per the documented metadata:

• IGS_DA_SETUP: This table references IGS_EN_UNIT_SET_CAT three times to define default unit set categories for Degree Audit (WIF - "What-If") scenarios. The specific foreign key columns are:
  • WIF_MAJOR_UNIT_SET_CAT: Links to the category designated for Major unit sets in what-if analysis.
  • WIF_MINOR_UNIT_SET_CAT: Links to the category designated for Minor unit sets.
  • WIF_TRACK_UNIT_SET_CAT: Links to the category designated for Track unit sets.

While not listed in the provided excerpt, it is highly probable that the main transactional table for unit sets, IGS_EN_UNIT_SET, contains a foreign key column (UNIT_SET_CAT) referencing this table's primary key to categorize every unit set record.