Search Results igs_ps_unit_category_all




Overview
Explore in AI Chat

Overview

The IGS_PS_UNIT_CATEGORY_ALL table is a core entity within the Oracle E-Business Suite Student System (IGS) module, specifically for releases 12.1.1 and 12.2.2. It functions as a junction table that manages the many-to-many relationship between academic units (courses or subjects) and their associated classification categories. Each record in this table defines a specific category assignment for a specific version of a unit, enabling institutions to classify units for various administrative, reporting, and curricular purposes. Its role is critical for organizing and segmenting the unit catalog based on attributes like discipline, level, delivery mode, or institutional requirement type.

Key Information Stored

The table's structure is defined by a composite primary key and foreign key relationships. The primary key columns are UNIT_CD, VERSION_NUMBER, and UNIT_CAT, which together uniquely identify a category assignment for a unit version. The UNIT_CD and VERSION_NUMBER columns reference a specific version of a unit from the IGS_PS_UNIT_VER_ALL table. The UNIT_CAT column references a valid category code defined in the IGS_PS_UNIT_CAT table. This design allows a single unit version to be associated with multiple distinct categories, as indicated in the entity description.

Common Use Cases and Queries

This table is central to queries that filter, report on, or apply business rules based on unit classifications. Common use cases include generating lists of all units belonging to a specific category (e.g., "Graduate Level" or "Online Delivery"), validating category assignments during unit setup, and supporting enrollment or progression rules that depend on unit types. A typical reporting query would join this table to the unit and category description tables:

  • SELECT u.unit_cd, u.version_number, c.unit_cat, cat.description FROM igs_ps_unit_category_all u, igs_ps_unit_cat cat WHERE u.unit_cat = cat.unit_cat AND u.unit_cd = 'MATH101';

This retrieves all category assignments for a given unit code. Data integrity is maintained by the primary key constraint, preventing duplicate category assignments for the same unit version.

Related Objects

The table maintains documented foreign key relationships with two key master tables in the Student System, as per the provided metadata:

  • IGS_PS_UNIT_VER_ALL: This is the parent table for unit definitions. The relationship is established via the UNIT_CD and VERSION_NUMBER columns in IGS_PS_UNIT_CATEGORY_ALL, ensuring that a category can only be assigned to a valid, existing unit version.
  • IGS_PS_UNIT_CAT: This is the parent table containing the valid list of category codes and their descriptions. The relationship is via the UNIT_CAT column, ensuring that every category assigned to a unit references a defined and controlled value.

These relationships are critical for maintaining referential integrity and ensuring that all unit category assignments are based on authorized master data.