Search Results igs_ps_usec_category_pk

Overview

The IGS_PS_USEC_CATEGORY table is a core data structure within the Oracle E-Business Suite Student System (IGS) module, specifically for release versions 12.1.1 and 12.2.2. It serves as a junction table that defines and manages the assignment of academic categories to individual unit sections. A unit section represents a specific offering or instance of a course unit, and its category classification is critical for academic administration, reporting, and enforcing business rules related to enrollment, fee assessment, and curriculum planning. The table's primary role is to maintain the formal relationship between a unit offering option and its designated academic classification.

Key Information Stored

The table's structure is designed to enforce data integrity through primary and unique keys while storing essential relationship data. The primary key is the surrogate key USEC_CAT_ID, which provides a unique identifier for each record. The table also enforces a unique constraint (IGS_PS_USEC_CATEGORY_UK) on the combination of UNIT_CAT and UOO_ID. This ensures that a specific unit section (UOO_ID) cannot be assigned the same unit category (UNIT_CAT) more than once. Therefore, the two critical foreign key columns are the core data points: UOO_ID, which identifies the specific unit section, and UNIT_CAT, which identifies the academic category applied to that section.

Common Use Cases and Queries

This table is central to processes that depend on the categorization of unit offerings. Common use cases include generating reports on the distribution of unit sections across different academic categories (e.g., core, elective, major, minor), driving enrollment eligibility logic based on category rules, and supporting fee calculation engines where fees are tied to unit categories. A typical query would join this table to its parent tables to retrieve a descriptive list of sections and their categories.

• Sample Query: To list all unit sections with their associated category codes, a report might use: SELECT uc.unit_cat, uoo.uoo_id FROM igs_ps_usec_category usc JOIN igs_ps_unit_ofr_opt_all uoo ON usc.uoo_id = uoo.uoo_id JOIN igs_ps_unit_cat uc ON usc.unit_cat = uc.unit_cat;
• Data integrity checks often involve verifying that every active unit section has at least one valid category record in this table.

Related Objects

The IGS_PS_USEC_CATEGORY table maintains defined foreign key relationships with two primary tables in the Student System, as documented in the ETRM metadata. These relationships are fundamental to its purpose.

• IGS_PS_UNIT_CAT: The UNIT_CAT column in IGS_PS_USEC_CATEGORY references this table. It validates that the category assigned to a unit section is a defined and valid academic category within the institution's setup.
• IGS_PS_UNIT_OFR_OPT_ALL: The UOO_ID column in IGS_PS_USEC_CATEGORY references this table. This links the category record to a specific unit offering option, which is the concrete instance of a unit being offered in a given academic period.

These relationships ensure that category assignments are always made to valid, existing unit sections and predefined category codes, maintaining the integrity of the academic structure.