Results for “igs_as_unit_mode”

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

Overview

IGS_AS_UNIT_MODE is a reference (lookup) table in the Oracle E-Business Suite Student System (IGS) product family. Its documented description states that it "describes available university unit offering modes." In practice, it serves as the master list of the modes in which a university unit or unit offering can be delivered or assessed — for example attendance-based, distance, or other institution-defined delivery patterns. Because it is a low-volume, stable code table referenced by many transactional and assessment-related entities, it plays the role of a central reference point for how units are offered and evaluated across the Student System.

From a dimensional modeling perspective, the heuristic Data Vault classification supplied in the metadata is hub-leaning. The table carries a compact business key (UNIT_MODE) and is referenced by numerous foreign keys rather than holding descriptive transactional history in its own right. It is therefore best treated as a reference hub (or, in Kimball terms, a small dimension) that anchors links to the dependent transactional tables.

Key Information Stored

The documented physical schema for 12.1.1 comprises nine columns. The most significant are listed below. The surrogate/primary key structure is defined by IGS_AS_UNIT_MODE_PK on UNIT_MODE, and a unique index IGS_AS_UNIT_MODE_U1 on UNIT_MODE provides the business-key candidate.

• UNIT_MODE — the primary key and business-key column. This is the code that uniquely identifies each available unit offering mode and is the value propagated into all foreign-key child tables.
• DESCRIPTION — the human-readable name or explanation of the mode, used in lists of values and reports.
• S_UNIT_MODE — a secondary or short/abbreviated representation of the unit mode, typically used for compact display or legacy compatibility.
• CLOSED_IND — an active/closed flag indicating whether the mode is still available for selection. Closed modes are retained for historical records but excluded from new entry.
• CREATED_BY, CREATION_DATE — standard WHO audit columns recording who created the reference row and when.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns recording the most recent modification, its author, and the login session.

The WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) conform to the Oracle EBS multi-org audit convention and support change tracking and data lineage.

Common Use Cases and Queries

Typical uses include populating lists of values on unit and assessment entry forms, validating mode codes on inbound data loads, and driving reporting that segments units by delivery mode. A common query retrieves the active modes for a list of values:

• SELECT unit_mode, description, s_unit_mode FROM igs_as_unit_mode WHERE NVL(closed_ind,'N') = 'N' ORDER BY unit_mode;
• Joining to assessment items: SELECT u.unit_mode, u.description, COUNT(a.unitass_item_id) FROM igs_as_unit_mode u, igs_as_unitass_item a WHERE a.unit_mode = u.unit_mode GROUP BY u.unit_mode, u.description;
• Fee analysis: aggregate fee amounts in IGS_FI_FEE_AS_ITEMS or IGS_FI_FEE_AS_RATE grouped by UNIT_MODE to compare revenue or rates across offering modes.
• Data-quality checks: identify child rows whose UNIT_MODE has no matching parent row in IGS_AS_UNIT_MODE.

Related Objects

The metadata documents seven foreign keys referencing IGS_AS_UNIT_MODE.UNIT_MODE. The most significant dependent objects are:

• IGS_AS_UNITASS_ITEM — unit assessment items, joined via UNIT_MODE.
• IGS_AS_ITEM_ASSESSOR — assessors linked to items, joined via UNIT_MODE.
• IGS_FI_FEE_AS_ITEMS — assessment fee items, joined via UNIT_MODE.
• IGS_FI_FEE_AS_RATE — assessment fee rates, joined via UNIT_MODE.
• IGS_FI_FEE_AS_RT_H_ALL — fee rate history records, joined via UNIT_MODE.
• IGS_FI_FTCI_ACCTS — fee/account configuration, joined via UNIT_MODE.
• IGS_AD_PS_APLINSTUNT_ALL — applicant instance/student records, joined via UNIT_MODE.

Because every dependent table joins on the UNIT_MODE column and the parent key is enforced by IGS_AS_UNIT_MODE_PK, changes to a mode code ripple across assessment, fee, and admissions processing, making this reference table a critical control point for data integrity in the Student System.