Results for “igs_as_unit_class_all”

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

Overview

The IGS_AS_UNIT_CLASS_ALL table belongs to the Oracle E-Business Suite Student System product family (IGS), specifically the Assessment (AS) sub-module. In the terminology of the Oracle Student System, a unit represents a discrete component of study (analogous to a course or module), and a unit class represents a specific mode or delivery variant of that unit. The table's documentation states plainly that it "describes available unit classes, which map to unit mode," meaning it functions as a reference/setup table that enumerates the valid delivery modes (for example, lecture, laboratory, tutorial, online, or distance variants) that a unit can assume, along with scheduling attributes such as day of week and start/end times.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as hub-leaning. Its single-column primary key UNIT_CLASS is a natural business key that is referenced by numerous dependent tables through foreign keys. This positional behavior — a stable, low-volume reference list whose key is reused across assessment and fee structures — is characteristic of a hub. The remaining descriptive and scheduling attributes could logically be separated into an accompanying satellite in a formal Data Vault design, but in the EBS implementation they are collapsed into this single physical table.

It should be noted that the ETRM record flags this object as obsolete and states "Not implemented in this database," indicating that in the 12.1.1 / 12.2.2 reference environments the table structure is documented but not physically deployed. The schema definition nevertheless remains authoritative for the analysis of downstream dependencies.

Key Information Stored

The documented physical schema comprises 13 columns owned by the IGS schema. The most significant are:

• UNIT_CLASS — The primary key column, defined by the unique index IGS_AS_UNIT_CLASS_ALL_U1 and the constraint IGS_AS_UNIT_CLASS_ALL_PK. It is the business identifier assigned to each class variant and is the column propagated to all foreign-key dependents.
• UNIT_MODE — The delivery mode to which the unit class maps, which the description identifies as the core semantic of the record.
• DESCRIPTION — Free-text description of the unit class.
• DAY_OF_WEEK, START_TIME, END_TIME — Scheduling attributes defining when the class takes place.
• CLOSED_IND — Boolean indicator marking the class as closed or inactive.
• ORG_ID — The multi-organization identifier supporting the "_ALL" naming convention, meaning the table is partitioned by operating unit.

The audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN complete the standard EBS who-column set. Because UNIT_CLASS is both the primary key and the sole unique-index column, it serves simultaneously as surrogate identifier and business key in this implementation.

Common Use Cases and Queries

Although the table is documented as obsolete, the same patterns applied to its successor structures are useful for reference. A typical lookup retrieves the mode and schedule for a given class:

SELECT unit_class, unit_mode, description, day_of_week, start_time, end_time
FROM igs_as_unit_class_all
WHERE org_id = :p_org_id AND NVL(closed_ind,'N') = 'N';

A join against assessment items or fee rates validates that dependent records reference a valid class:

SELECT f.unit_class, c.description, f.fee_amount
FROM igs_fi_fee_as_items f, igs_as_unit_class_all c
WHERE f.unit_class = c.unit_class;

Reporting scenarios include enrollment-by-mode analysis (joining to IGS_AD_PS_APLINSTUNT_ALL), assessment workload planning via IGS_AS_ITEM_ASSESSOR, and fee-rate derivation through the IGS_FI_* tables.

Related Objects

The table is referenced by nine documented foreign keys, making it a central reference for assessment and fee configuration. The most significant dependents are:

• IGS_AD_PS_APLINSTUNT_ALL (column UNIT_CLASS) — applicant instance unit records.
• IGS_AS_ITEM_ASSESSOR (UNIT_CLASS) — assessment item assessor assignments.
• IGS_FI_FEE_AS_RATE and IGS_FI_FEE_AS_ITEMS (UNIT_CLASS) — assessment fee rate and item definitions.
• IGS_FI_FEE_AS_RT_H_ALL and IGS_FI_FTCI_ACCTS (UNIT_CLASS) — fee rate history and fee account mappings.
• IGS_PS_PAT_STUDY_UNT and IGS_PS_UNIT_OFR_OPT_ALL (UNIT_CLASS) — student study-unit and unit offering option records.
• IGS_FI_UNIT_FEE_TRG (UNIT_CLASS) — unit fee trigger definitions.

All relationships join on UNIT_CLASS, confirming its role as a governed hub key across the assessment and fee domains.