Search Results igs_as_unit_mode




Overview
Explore in AI Chat

Overview

The IGS_AS_UNIT_MODE table is a core reference table within the Oracle E-Business Suite Student System (IGS) for releases 12.1.1 and 12.2.2. It functions as a master code table that defines the various modes in which a university unit (or course) can be offered. Its primary role is to enforce data integrity by providing a standardized list of valid offering modes, such as on-campus, distance education, or blended learning, which are then referenced by transactional tables across the student lifecycle. By centralizing this definition, it ensures consistency in how unit modes are recorded and reported throughout the application's assessment, admissions, and financial modules.

Key Information Stored

While the provided ETRM metadata does not list specific column details beyond the primary key, the table's structure is typical of a code lookup table. The central column is UNIT_MODE, which serves as the primary key (IGS_AS_UNIT_MODE_PK). This column stores the unique, short code representing the offering mode (e.g., 'ONCAMP', 'DIST', 'BLEND'). It is highly probable the table also contains descriptive columns such as DESCRIPTION to provide a full name for the mode, and standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY). Additional columns may exist to control the active status and display order of each mode value within the application's user interface.

Common Use Cases and Queries

This table is primarily used for validation, reporting, and data joins. Application forms that capture unit offering details will validate entered values against this table. Common reporting scenarios include analyzing the distribution of unit offerings by mode across different academic periods or programs. A typical query to retrieve all active unit modes for a lookup would be:

  • SELECT unit_mode, description FROM igs.igs_as_unit_mode WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE) ORDER BY s_order;

For transactional reporting, such as listing assessment items for distance education units, a developer would join this table to a transactional table using the UNIT_MODE key:

  • SELECT ai.assessment_item_code, um.description AS unit_mode FROM igs_as_unitass_item ai JOIN igs_as_unit_mode um ON ai.unit_mode = um.unit_mode WHERE um.unit_mode = 'DIST';

Related Objects

The IGS_AS_UNIT_MODE table is a parent to several key transactional tables, as documented by its foreign key relationships. The UNIT_MODE column is referenced by the following tables, indicating its critical role in linking unit mode data to specific functional areas: