Results for “igs_as_unit_class_all_u1”

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

Overview

IGS.IGS_AS_UNIT_CLASS_ALL is a foundational reference table in the Oracle E-Business Suite Student System (IGS) schema, delivered and validated across EBS 12.1.1 and 12.2.2. It stores the institution-defined unit classes that describe how units of study are delivered and scheduled—for example a "D-day" or "evening" offering. Each unit class maps to a unit mode that identifies the delivery context, such as on-campus, off-campus, or composite delivery. Because enrollment, assessment, and fee logic all depend on identifying the delivery class of a unit, this table functions as a central reference point for the academic structure.

The ETRM metadata classifies this object heuristically as hub-leaning within a Data Vault model. In that modeling suggestion, IGS_AS_UNIT_CLASS_ALL behaves as a hub: its primary key, UNIT_CLASS, is the durable business key surrounding which multiple downstream satellites and links would be organized. The table is stored in the APPS_TS_TX_DATA tablespace with PCT Free 10, and its unique index IGS_AS_UNIT_CLASS_ALL_U1 resides in APPS_TS_TX_IDX.

Key Information Stored

The table contains 13 documented columns. The most significant are summarized below.

• UNIT_CLASS — Institution-defined code (VARCHAR2(10)) identifying a unit class, such as D-day or evening. It is the single-column primary key (IGS_AS_UNIT_CLASS_ALL_PK) and also the column behind the unique index IGS_AS_UNIT_CLASS_ALL_U1, making it both the surrogate and the business-key candidate in practice.
• UNIT_MODE — Institution-defined mode of offering (VARCHAR2(10)). Each mode must map to a system-defined mode: ON for on-campus, OFF for off-campus, or composite, a mixture of on-campus and off-campus delivery.
• DESCRIPTION — Textual description (VARCHAR2(60)) of the institution-defined unit class.
• DAY_OF_WEEK — The day of the week on which the unit class is scheduled.
• START_TIME and END_TIME — DATE columns recording when the class commences and finishes.
• CLOSED_IND — Flag indicating whether the class is open or closed. When the closed checkbox is selected, the class cannot be used in new or modified student unit enrollments.
• ORG_ID — Operating unit identifier (NUMBER(15)), supporting multi-org partitioning of the reference data.
• Standard Who columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN capture the audit trail and are mandatory in typical EBS usage.

Common Use Cases and Queries

Typical scenarios include validating which unit classes are actively available, reporting delivery mix by unit mode, and enriching enrollment, assessment, and fee extracts with the class description. The canonical query is:

• SELECT UNIT_CLASS, UNIT_MODE, DESCRIPTION, DAY_OF_WEEK, START_TIME, END_TIME, CLOSED_IND, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, ORG_ID FROM IGS.IGS_AS_UNIT_CLASS_ALL;
• Filtering open classes only: add WHERE CLOSED_IND = 'N' to exclude classes barred from new or modified enrollments.
• Grouping offerings: SELECT UNIT_MODE, COUNT(*) FROM IGS.IGS_AS_UNIT_CLASS_ALL GROUP BY UNIT_MODE to profile on-campus, off-campus, and composite delivery.
• Joining to dependent tables on UNIT_CLASS to report assessment items, fee rates, or enrollment records with their class descriptions and schedules.

Related Objects

IGS_AS_UNIT_CLASS_ALL does not reference any database object itself, but it is referenced by numerous dependent tables through the UNIT_CLASS column. The most significant are:

• IGS_AD_PS_APLINSTUNT_ALL (UNIT_CLASS → IGS_AS_UNIT_CLASS_ALL) — applicant unit instance data.
• IGS_AS_ITEM_ASSESSOR (UNIT_CLASS) — assessment item assessor assignments.
• IGS_FI_FEE_AS_RATE, IGS_FI_FEE_AS_ITEMS, IGS_FI_FEE_AS_RT_H_ALL, IGS_FI_FTCI_ACCTS, and IGS_FI_UNIT_FEE_TRG — fee assessment, item, rate history, account, and fee trigger records tied to a unit class.
• IGS_PS_PAT_STUDY_UNT and IGS_PS_UNIT_OFR_OPT_ALL — student study unit records and unit offering options, both referencing UNIT_CLASS.

These dependencies confirm the table's hub role: UNIT_CLASS is reused widely as a foreign key, so changes to class definitions carry downstream implications for enrollment, fee, and assessment processes.