Search Results igs_as_unit_class




Overview
Explore in AI Chat

Overview

The IGS_AS_UNIT_CLASS view is a reporting and integration object belonging to the IGS – Student System product family within Oracle E-Business Suite. In ETRM (E-Business Suite Technical Reference Manual) documentation for releases 12.1.1 and 12.2.2, this object is classified as part of the Student System, which is flagged as obsolete. As a result, the view is documented for backward-compatibility and reference purposes rather than as an actively maintained schema component. Its functional purpose is to present unit class scheduling records — the definition of when and how a given instructional unit is delivered — in a form that supports inquiry, reporting, and integration against the underlying _ALL table, subject to the caller's operating unit context.

Underlying Base Objects

The view is defined over a single base object: IGS_AS_UNIT_CLASS_ALL. No other referenced base objects are documented in the ETRM metadata. The view text selects a defined column list from the _ALL table and applies a row-level filter based on the organization identifier:

SELECT UC.ROWID ROW_ID, UC.UNIT_CLASS, UC.UNIT_MODE, UC.DESCRIPTION,
       UC.DAY_OF_WEEK, UC.START_TIME, UC.END_TIME, UC.CLOSED_IND,
       UC.CREATED_BY, UC.CREATION_DATE, UC.LAST_UPDATED_BY,
       UC.LAST_UPDATE_DATE, UC.LAST_UPDATE_LOGIN, UC.ORG_ID
FROM   IGS_AS_UNIT_CLASS_ALL UC
WHERE  NVL(UC.ORG_ID, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),
       ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))), -99))
       = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),
       ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))), -99)

The _ALL suffix indicates that the base table stores data across multiple operating units, while this view exposes only the rows appropriate to the current session's operating unit, derived from the CLIENT_INFO value maintained by the Multi-Org (multiple organizations) architecture. The ROW_ID column is projected from ROWID to provide a unique row identifier for the exposed record.

Key Columns

  • ROW_ID – The physical row identifier (ROWID) of the underlying _ALL record, useful for direct row addressing.
  • UNIT_CLASS – The identifier of the unit class being defined, typically the primary business key for the schedule record.
  • UNIT_MODE – The delivery mode associated with the unit class (for example, the instructional or attendance mode).
  • DESCRIPTION – Descriptive text for the unit class.
  • DAY_OF_WEEK – The day on which the class occurs within the schedule.
  • START_TIME / END_TIME – The scheduled start and end times of the class session.
  • CLOSED_IND – Indicator of whether the unit class record is closed or inactive.
  • ORG_ID – The operating unit owning the record, used by the view's Multi-Org filter.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard audit columns tracking record creation and modification.

Common Use Cases and Queries

Because the view enforces operating-unit security automatically, it is commonly used in institution-facing reports and extracts that must not expose cross-organization unit class data. A typical query retrieves schedule details for active classes:

SELECT unit_class, unit_mode, description, day_of_week,
       start_time, end_time, closed_ind
FROM   igs_as_unit_class
WHERE  closed_ind = 'N'
ORDER BY unit_class, day_of_week, start_time;

Integration routines may join the view to the underlying _ALL table via ROW_ID, or use ORG_ID to align with other Multi-Org aware objects. Note that the ETRM documentation records this view as not implemented in the reference database and the IGS Student System as obsolete; administrators should confirm the object exists and is populated in their specific instance before relying on it in production reporting or interface logic.