Results for “igs_ps_unit_cat”

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

Overview

IGS_PS_UNIT_CAT is a reference (lookup) table within the Oracle E-Business Suite Student System product (IGS), owned by the IGS schema. It stores user-defined unit categories that a university uses to classify all units (courses) offered by the institution. In EBS 12.1.1 and 12.2.2, this table serves as a controlled vocabulary for academic unit classification, allowing institutions to group units by type — for example, "Core," "Elective," "Postgraduate," or "Undergraduate" — without being constrained to seeded values.

Each row represents a single unit category definition. Because the table acts as a stable reference source whose primary key is referenced by several dependent transactional and descriptive entities, the heuristic Data Vault classification mined from the foreign key structure is hub-leaning. In Data Vault modeling terms, IGS_PS_UNIT_CAT can be treated as a hub, with its UNIT_CAT business key distributed as a foreign key into associated link and satellite structures.

Key Information Stored

The table is documented with eight columns in the 12.1.1 physical schema. The principal columns are:

• UNIT_CAT — the unit category code. This is the business key of the table and the column referenced by all dependent foreign keys.
• DESCRIPTION — the user-facing description of the category, presented to users when assigning a category to a unit.
• CLOSED_IND — a flag indicating whether the category is closed and therefore no longer selectable for new unit assignments. Closed categories typically remain valid for historical records.
• CREATED_BY, CREATION_DATE — audit columns capturing who created the row and when.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — audit columns capturing the most recent modification to the row.

The surrogate primary key is defined by the constraint IGS_PS_UNIT_CAT_PK on UNIT_CAT. A unique index, IGS_PS_UNIT_CAT_U1, is also defined on UNIT_CAT, confirming UNIT_CAT as the definitive business-key candidate. The table therefore uses the category code itself as its primary identifier, and no separate system-generated surrogate column is documented.

Common Use Cases and Queries

Typical usage includes validating that only open categories are offered during unit creation, reporting unit counts by category for curriculum analysis, and populating list-of-values (LOV) pickers in the Student System forms. A common lookup query retrieves active categories:

• SELECT unit_cat, description FROM igs_ps_unit_cat WHERE closed_ind = 'N' ORDER BY unit_cat;
• SELECT c.unit_cat, c.description, COUNT(a.unit_cd) FROM igs_ps_unit_cat c, igs_ps_unit_category_all a WHERE c.unit_cat = a.unit_cat GROUP BY c.unit_cat, c.description;
• SELECT * FROM igs_ps_unit_cat WHERE unit_cat = :p_unit_cat;

Reporting scenarios frequently join the category definition to the units assigned to it to produce category roll-ups, accreditation extracts, and catalog publications.

Related Objects

The documented foreign key relationships identify the tables that depend on this object:

• IGS_PS_UNIT_CATEGORY_ALL — joins on IGS_PS_UNIT_CATEGORY_ALL.UNIT_CAT = IGS_PS_UNIT_CAT.UNIT_CAT. This association table links unit categories to individual units.
• IGS_PS_USEC_CATEGORY — joins on IGS_PS_USEC_CATEGORY.UNIT_CAT = IGS_PS_UNIT_CAT.UNIT_CAT. This table associates unit categories with unit sections or related scheduling constructs.

Both referencing tables carry UNIT_CAT as a foreign key, making the category code the primary integration point for any query or interface working with unit classification across the Student System.