Search Results offset_date_alias_description




Overview
Explore in AI Chat

Overview

The APPS.IGSBV_CAL_PRD_EVNT_TYPE_OFSTS view is a Business View delivered within the Oracle E-Business Suite Student System (IGS) product family. It serves as the base view for the entity Calendar Period Event Type Offsets, which describes the offset relationship that exists between two date aliases. In the IGS calendar model, a date alias represents a named, derivable date reference (for example, the start of an academic period or a specific event type within a calendar period). Offset values are used to derive one date alias value from a related date alias value by applying a stored day, week, month, or year displacement.

This view exposes the offset definitions alongside human-readable descriptions of both the source date alias and the related (offset) date alias. Because it is a read-only, fully joined view, it is intended for reporting, inquiry, and integration purposes rather than for transactional update. Users searching for the column offset_date_alias_description will find that field here, presented together with the numerical offset components that drive date derivation logic.

Underlying Base Objects

According to the documented view text, IGSBV_CAL_PRD_EVNT_TYPE_OFSTS is defined over three base tables:

  • IGS_CA_DA_OFST — the offset definition table (aliased DA), which stores the source date alias, the offset date alias, and the day/week/month/year offset values.
  • IGS_CA_DA (aliased DA1) — the date alias table, joined on DA.DT_ALIAS = DA1.DT_ALIAS to supply the description of the source date alias.
  • IGS_CA_DA (aliased DA2) — the date alias table joined a second time on DA.OFFSET_DT_ALIAS = DA2.DT_ALIAS to supply the description of the offset date alias.

The view is defined WITH READ ONLY, confirming its read-only nature. The ETRM 12.2.2 metadata lists no further referenced base objects beyond those inferred from the join, and the documented view text is the authoritative definition for the columns exposed.

Key Columns

Common Use Cases and Queries

Typical uses include calendar configuration review, validation of date derivation logic, and building reports that explain how one academic date is calculated from another. The following query retrieves all offset definitions with descriptive alias names:

SELECT DATE_ALIAS,
       DATE_ALIAS_DESCRIPTION,
       OFFSET_DATE_ALIAS,
       OFFSET_DATE_ALIAS_DESCRIPTION,
       NUMBER_OF_DAY_OFFSET,
       NUMBER_OF_WEEK_OFFSET,
       NUMBER_OF_MONTH_OFFSET,
       NUMBER_OF_YEAR_OFFSET
FROM   APPS.IGSBV_CAL_PRD_EVNT_TYPE_OFSTS;

To locate the offset relationship for a specific source alias:

SELECT OFFSET_DATE_ALIAS_DESCRIPTION,
       NUMBER_OF_DAY_OFFSET,
       NUMBER_OF_WEEK_OFFSET,
       NUMBER_OF_MONTH_OFFSET,
       NUMBER_OF_YEAR_OFFSET
FROM   APPS.IGSBV_CAL_PRD_EVNT_TYPE_OFSTS
WHERE  DATE_ALIAS = :p_date_alias;

Because the view already resolves both alias descriptions, it removes the need for consumers to perform the double join to IGS_CA_DA manually, making it well suited to concurrent programs, Oracle Reports, and BI Publisher data templates within the Student System.