Search Results igs_ps_unit_cat_pk

Overview

The IGS_PS_UNIT_CAT table is a core reference table within the Oracle E-Business Suite (EBS) Student System (IGS) module. It serves as the master repository for user-defined unit categories, which are essential for classifying and organizing all academic units offered by an educational institution. In the context of academic program and curriculum management, this table provides a standardized, controlled vocabulary for categorizing units, enabling consistent reporting, curriculum planning, and administrative processes across the student lifecycle. Its role is foundational, as it is referenced by other key entities that manage unit definitions and their offerings.

Key Information Stored

While the provided metadata does not list specific columns, the structure of a typical reference table like IGS_PS_UNIT_CAT can be inferred. The primary data stored includes a unique code and a description for each unit category. The primary key column, UNIT_CAT, is a critical field that stores the unique identifier for each category (e.g., 'CORE', 'ELECTIVE', 'MAJOR', 'MINOR'). Other common columns would include a descriptive name (DESCRIPTION), control columns for tracking data creation and modification (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE), and potentially an active/inactive indicator (CLOSED_IND). This structure allows institutions to define a taxonomy that aligns with their specific academic policies.

Common Use Cases and Queries

This table is primarily used in scenarios requiring the classification of academic units. Common use cases include generating curriculum reports that break down program requirements by unit category, setting up rules for course completion, and filtering units in academic advisement modules. A frequent reporting query would join this table to unit detail tables to list all units within a specific category. For example:

• SELECT uc.unit_cat, uc.description, COUNT(u.unit_code) AS unit_count FROM igs_ps_unit_cat uc, igs_ps_unit_category_all u WHERE uc.unit_cat = u.unit_cat GROUP BY uc.unit_cat, uc.description;

Another common pattern is to use this table as a validation source (LOV) when assigning a category to a unit during its setup or maintenance within the application's forms.

Related Objects

The IGS_PS_UNIT_CAT table has defined foreign key relationships with other significant tables in the Student System, as documented in the metadata. These relationships demonstrate how the master category codes are applied.

• IGS_PS_UNIT_CATEGORY_ALL: This table references IGS_PS_UNIT_CAT via the column IGS_PS_UNIT_CATEGORY_ALL.UNIT_CAT. This is the primary relationship where the category is assigned to specific unit definitions.
• IGS_PS_USEC_CATEGORY: This table references IGS_PS_UNIT_CAT via the column IGS_PS_USEC_CATEGORY.UNIT_CAT. This relationship extends the categorization to unit sections (offerings), allowing categories to be managed at the scheduling level.

The primary key constraint IGS_PS_UNIT_CAT_PK on the UNIT_CAT column enforces data integrity for these relationships.