Search Results dsp_title




Overview
Explore in AI Chat

Overview

IGS_PS_UNIT_OFR_OPT_GRD_SCHM_V is a reporting view within the Oracle E-Business Suite Student System (IGS) module. It consolidates unit offering information for a given calendar instance together with the associated offering option, offering pattern, and unit version attributes. The view exposes a denormalized, read-only projection of data drawn from the offering option and calendar instance entities, joined to unit version data to supply descriptive attributes such as unit status and unit title.

The view is classified as obsolete in Oracle EBS 12.1.1 and 12.2.2 documentation. The ETRM metadata records it with the designation "Not implemented in this database," meaning the view text is preserved for reference but the object is not deployed in a standard installation. It is therefore relevant primarily for historical analysis, upgrade assessment, or research into legacy Student System reporting structures rather than for active development. The suffix "GRD_SCHM" suggests an association with graded scheme or grading pattern reporting, though this is not explicitly confirmed in the documented metadata.

Underlying Base Objects

The view text references three base tables, all within the IGS schema:

  • IGS_PS_UNIT_OFR_OPT (alias UOO) — the unit offering option table, which supplies the core offering record, including unit code, version number, calendar type, calendar instance sequence, location, unit class, and the offering option identifier (UOO_ID).
  • IGS_CA_INST (alias CI) — the calendar instance table, which supplies the calendar instance start and end dates exposed as DSP_CI_START_DT and DSP_CI_END_DT.
  • IGS_PS_UNIT_VER (alias UV) — the unit version table, which supplies the unit status (DSP_UNIT_STATUS) and unit title (DSP_TITLE).

The joins are established on unit code and version number between the offering option and unit version tables, and on calendar type and sequence number between the offering option and calendar instance tables. No additional base objects are documented beyond these three. All user-facing attributes are derived from these sources; the view itself introduces no persistent storage.

Key Columns

  • ROW_ID — the ROWID of the underlying IGS_PS_UNIT_OFR_OPT row, useful as a surrogate key.
  • UNIT_CD, VERSION_NUMBER — identify the unit and its version.
  • CAL_TYPE, CI_SEQUENCE_NUMBER — identify the calendar type and calendar instance sequence.
  • LOCATION_CD, UNIT_CLASS, UOO_ID — offering-level attributes including location, classification, and the primary offering option identifier.
  • DSP_CI_START_DT, DSP_CI_END_DT — display-oriented start and end dates of the calendar instance.
  • DSP_UNIT_STATUS — the status of the unit version, exposed for display purposes.
  • DSP_TITLE — the unit title, the column most frequently referenced by users searching for "dsp_title"; it provides the human-readable name of the unit being offered.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

The principal use case is reporting on unit offerings for a calendar instance alongside the unit title and status, which supports curriculum publication, offering catalogues, and schedule extracts. A representative query is:

  • SELECT UNIT_CD, VERSION_NUMBER, DSP_TITLE, DSP_UNIT_STATUS, DSP_CI_START_DT, DSP_CI_END_DT FROM IGS_PS_UNIT_OFR_OPT_GRD_SCHM_V WHERE CAL_TYPE = :cal_type AND CI_SEQUENCE_NUMBER = :seq;
  • SELECT UOO_ID, DSP_TITLE FROM IGS_PS_UNIT_OFR_OPT_GRD_SCHM_V WHERE DSP_UNIT_STATUS = 'ACTIVE';

Because the object is not implemented in current databases, queries against it will fail unless the view is manually recreated from the documented view text. Its primary value is as a reference model for constructing equivalent reporting joins between IGS_PS_UNIT_OFR_OPT, IGS_CA_INST, and IGS_PS_UNIT_VER in supported custom views.