Search Results unit_cat




Overview
Explore in AI Chat

Overview

The IGS_PS_UNIT_CATEGORY_ALL table is a core data entity within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) or Campus Solutions modules under the IGS (iGrants) schema. It functions as a junction table that defines the relationship between academic units and institution-defined unit categories. Its primary role is to enable the classification of a single unit offering into multiple categorical dimensions, such as "Core," "Elective," "Major," or "Lab," providing essential flexibility for curriculum management, program requirements, and reporting. The inclusion of the `ORG_ID` column and the `_ALL` suffix indicates it is a multi-org table, storing data partitioned by operating unit, which is a critical architectural feature for multi-institution implementations in EBS.

Key Information Stored

The table stores a unique association between a unit, its version, and a category code. The key columns are the composite primary key and the operating unit identifier. The mandatory columns `UNIT_CD` and `VERSION_NUMBER` together uniquely identify a specific version of an academic unit, which is typically a foreign key relationship to a unit definition master table. The `UNIT_CAT` column holds the institution-defined category code applied to that unit version. Standard EBS "Who" columns (`CREATED_BY`, `CREATION_DATE`, `LAST_UPDATED_BY`, `LAST_UPDATE_DATE`, `LAST_UPDATE_LOGIN`) audit all changes. The `ORG_ID` is crucial for data isolation in a shared instance, ensuring queries and processes only access data relevant to a specific operating unit.

  • UNIT_CD, VERSION_NUMBER, UNIT_CAT: Composite primary key defining the unique unit-category assignment.
  • ORG_ID: Operating unit identifier enabling Multi-Org architecture.
  • Standard Who Columns: Track the user and timestamp for record creation and modification.

Common Use Cases and Queries

This table is central to queries that list or filter units based on their categorical attributes. A common use case is generating a report of all units categorized as a "Core" requirement within a specific academic program or for a given operating unit. It is also essential for validating program completion rules, where a student must complete a certain number of units from specific categories. When joining to the unit master table (e.g., `IGS_PS_UNIT_VER`), detailed reports on categorized units can be produced.

Sample Query 1: Retrieve all unit-category assignments for a specific operating unit (ORG_ID=123).

SELECT UNIT_CD, VERSION_NUMBER, UNIT_CAT
FROM IGS.IGS_PS_UNIT_CATEGORY_ALL
WHERE ORG_ID = 123
ORDER BY UNIT_CD, UNIT_CAT;

Sample Query 2: Find all units assigned a specific category (e.g., 'ELECTIVE').

SELECT UNIT_CD, VERSION_NUMBER
FROM IGS.IGS_PS_UNIT_CATEGORY_ALL
WHERE UNIT_CAT = 'ELECTIVE';

Related Objects

As a fundamental junction table, IGS_PS_UNIT_CATEGORY_ALL is referenced by other application objects within the EBS framework. The dependency information confirms it is referenced by an object named `IGS_PS_UNIT_CATEGORY_ALL` under the APPS synonym, which is typically a public synonym or a view that facilitates application access. The unit code and version number columns strongly imply a foreign key relationship to a unit version master table, such as `IGS_PS_UNIT_VER`. For complete context, one should examine the relevant form personalizations, concurrent programs, and APIs within the Student Management module that manage unit setup and program requirements, as they will likely read from or write to this table to maintain category assignments.