Results for “igs_en_unit_set_cat”

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

Overview

The IGS_EN_UNIT_SET_CAT table resides in the IGS schema (IGS - Student System) and functions as a reference, or lookup, entity within Oracle E-Business Suite 12.1.1 and 12.2.2. It defines the available categories of unit sets — for example, Major, Minor, Stream, and List. A unit set is a grouping of academic units (subjects or courses) that a student follows toward completion of a program, and the category assigned to each unit set determines how the institution interprets and processes that grouping for enrolment, progression, and graduation rules.

Because the table holds a controlled vocabulary of category codes rather than transactional student data, it acts as a stable reference source consumed by configuration and setup tables. From a Data Vault modelling perspective, the mined FK relationship data classifies this entity as hub-leaning: the primary key UNIT_SET_CAT behaves as a business key that is referenced by downstream tables, making the table a natural hub candidate around which satellites and links would be modelled. Within the operational EBS data model, it is a low-volume, slowly changing setup table that provides the semantic meaning of unit-set categories used throughout the Student System.

Key Information Stored

The documented physical schema contains ten columns, of which the following are the most significant:

• UNIT_SET_CAT — The category code itself. It is both the single-column primary key (constraint IGS_EN_UNIT_SET_CAT_PK) and the business-key candidate documented by the unique index IGS_EN_UNIT_SET_CAT_U1. In practice the surrogate and business key coincide, so values such as MAJOR, MINOR, STREAM, and LIST uniquely identify each row.
• DESCRIPTION — The descriptive text displayed to users, giving the human-readable meaning of the category code.
• S_UNIT_SET_CAT — The system-owned or seeded variant of the category code, typically used to distinguish Oracle-delivered values from institution-defined ones.
• RANK — A numeric ordering attribute that controls the display or processing sequence of categories.
• CLOSED_IND — A status flag indicating whether a category is closed and therefore no longer selectable for new unit-set definitions.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard Oracle who-column audit set that records row creation and modification metadata.

Common Use Cases and Queries

Typical usage centres on validation lookup, setup administration, and reporting. A common query pattern retrieves only active categories for use in a list of values:

• SELECT unit_set_cat, description FROM igs_en_unit_set_cat WHERE closed_ind = 'N' ORDER BY rank;
• Joining to IGS_DA_SETUP to determine which categories are configured as the major, minor, and track unit sets for an institution.
• Reporting on the distribution of unit sets by category to support curriculum analysis.
• Validating user-supplied category values against the unique index before insert into dependent setup tables.

Related Objects

The documented foreign key relationships show that IGS_DA_SETUP is the principal dependent table, referencing this entity through three distinct columns:

• IGS_DA_SETUP.WIF_MAJOR_UNIT_SET_CAT → IGS_EN_UNIT_SET_CAT.UNIT_SET_CAT
• IGS_DA_SETUP.WIF_MINOR_UNIT_SET_CAT → IGS_EN_UNIT_SET_CAT.UNIT_SET_CAT
• IGS_DA_SETUP.WIF_TRACK_UNIT_SET_CAT → IGS_EN_UNIT_SET_CAT.UNIT_SET_CAT

The primary key constraint IGS_EN_UNIT_SET_CAT_PK and unique index IGS_EN_UNIT_SET_CAT_U1 enforce integrity on UNIT_SET_CAT, ensuring that every reference from IGS_DA_SETUP resolves to a valid, uniquely defined category.