Search Results dsp_description




Overview
Explore in AI Chat

Overview

IGS_CA_DA_INST_TYPE_V is a reporting view within the Oracle EBS IGS — Student System module. In the ETRM 12.2.2 metadata, the product/module is explicitly flagged as Obsolete, and the view is documented as "Not implemented in this database." This means the object is a legacy artifact carried in the ETRM dictionary rather than an active, supported database object in current 12.1.1 or 12.2.2 installations. Its presence is nonetheless relevant to upgrade analysis, custom code remediation, and historical reporting audits where obsolete Student System objects may still be referenced.

Functionally, the view presents a denormalized, display-oriented projection of calendar instance data. It joins three Student System calendar tables and exposes a curated set of columns — notably DSP_DESCRIPTION, DSP_START_DT, DSP_END_DT, and DSP_CAL_STATUS — that were designed to serve user-facing forms, reports, and integrations needing calendar type descriptors alongside instance-level date and status information. The "DSP_" prefix signals display-layer intent: the view flattens normalized keys into human-readable attributes. The user search term "dsp_description" maps directly to the view's DSP_DESCRIPTION column, which sources IGS_CA_TYPE.DESCRIPTION.

Underlying Base Objects

The view text is documented as a three-table join over the IGS calendar schema:

Join predicates link the calendar instances and date/alias instances on the composite key (CAL_TYPE, SEQUENCE_NUMBER), and link calendar type descriptions on CAL_TYPE. ETRM explicitly notes Referenced base objects: none documented, indicating the object is not part of the officially supported schema. Implementers should verify object existence via DBA_VIEWS before relying on it.

Key Columns

  • ROW_ID — ROWID of the IGS_CA_DA_INST row, useful as a pseudo-key for flashback or deduplication logic.
  • DSP_START_DT / DSP_END_DT — Calendar instance start and end dates.
  • DSP_CAL_STATUS — Instance calendar status code.
  • DSP_DESCRIPTION — Descriptive text of the calendar type (from IGS_CA_TYPE.DESCRIPTION); the primary target for searches like "dsp_description".
  • DT_ALIAS, SEQUENCE_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER — Date alias and composite key attributes for calendar positioning.
  • ABSOLUTE_VAL — Absolute positional value used in academic calendar sequencing.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — WHO audit columns for change tracking and data lineage.

Common Use Cases and Queries

Typical uses include validating calendar setup, extracting calendar type descriptions for reporting, and reconciling date aliases against instances during EBS upgrades where Student System references must be retired or replaced.

Sample query to retrieve calendar descriptions with instance dates:

  • SELECT DSP_DESCRIPTION, CAL_TYPE, DT_ALIAS, DSP_START_DT, DSP_END_DT, DSP_CAL_STATUS
  • FROM IGS_CA_DA_INST_TYPE_V
  • WHERE DSP_CAL_STATUS = 'A'
  • ORDER BY DSP_START_DT;

Because the object is flagged obsolete and not implemented, a prior existence check is prudent:

  • SELECT view_name, text FROM DBA_VIEWS WHERE view_name = 'IGS_CA_DA_INST_TYPE_V';
  • If no rows return, retrieve equivalent data directly from IGS_CA_INST, IGS_CA_TYPE, and IGS_CA_DA_INST using the documented join.

Where customizations still reference DSP_DESCRIPTION, remediation should redirect queries to IGS_CA_TYPE.DESCRIPTION joined by CAL_TYPE.