Search Results related_date_alias




Overview
Explore in AI Chat

Overview

APPS.IGSFV_CAL_PRD_EVNT_TYPE_PAIRS is a Business Intelligence System (BIS) view in the Oracle E-Business Suite APPS schema, owned by the IGS product (Oracle Student Systems / Student Information). It exposes the entity "Calendar Period Event Type Pairs," whose purpose is to describe the combination of date aliases into pairs. In the IGS academic calendar model, a date alias represents a named event or point in time within a calendar, and pairing two aliases defines a bounded period of time that is inclusive of both aliases. This view therefore functions as a reporting and integration surface over that pairing definition, allowing external queries, reports, and downstream interfaces to resolve which related date alias is bound to a given context date alias without navigating the underlying normalized base tables directly.

Because it is a view rather than a table, it carries no independent storage and inherits its data and validity from the referenced base objects. Its status is VALID and it is registered in FND Design Data under the application short name IGS.

Underlying Base Objects

The documented dependency information states that APPS.IGSFV_CAL_PRD_EVNT_TYPE_PAIRS references the following base objects in the APPS schema: IGS_CA_DA and IGS_CA_DA_PAIR. These are the calendar date-alias table and the date-alias pairing table respectively. IGS_CA_DA supplies the date-alias definitions and their descriptions, while IGS_CA_DA_PAIR supplies the association between a date alias and its related (paired) date alias. The view joins these two sources so that each paired relationship is enriched with descriptive text for both the context alias and its related alias.

The metadata also indicates that APPS.IGSFV_CAL_PRD_EVNT_TYPE_PAIRS is not referenced by any database object, meaning it sits at the top of the dependency chain and is intended purely for read access by reports and integrations rather than as a building block for further database objects.

Key Columns

  • DATE_ALIAS (VARCHAR2(10)) — The name of the context date alias (the event) that anchors the pairing.
  • RELATED_DATE_ALIAS (VARCHAR2(10)) — The name of the date alias paired with the context alias. This is the column a user searching for "related_date_alias" would be directed to; its pairing with DATE_ALIAS defines the inclusive period of time. As a name/user key rather than a surrogate ID, it is the natural join key against the primary calendar date alias lookup.
  • DATE_ALIAS_DESCRIPTION (VARCHAR2(60)) — Descriptive text for the context date alias.
  • RELATED_DATE_ALIAS_DESCRIPTION (VARCHAR2(60)) — Descriptive text for the related (paired) date alias.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard Who audit columns, enabling traceability of when and by whom the record was created and last modified.

Common Use Cases and Queries

This view is typically used when reporting on academic calendar period definitions, validating that date-alias pairings are configured consistently, and driving integrations that need human-readable descriptions of paired calendar events. A basic query retrieving all pairings is shown below:

  • SELECT DATE_ALIAS, RELATED_DATE_ALIAS, DATE_ALIAS_DESCRIPTION, RELATED_DATE_ALIAS_DESCRIPTION FROM APPS.IGSFV_CAL_PRD_EVNT_TYPE_PAIRS;
  • To find the pairings for a specific context alias:
    SELECT RELATED_DATE_ALIAS, RELATED_DATE_ALIAS_DESCRIPTION FROM APPS.IGSFV_CAL_PRD_EVNT_TYPE_PAIRS WHERE DATE_ALIAS = :p_date_alias;
  • To surface all distinct related aliases in use:
    SELECT DISTINCT RELATED_DATE_ALIAS, RELATED_DATE_ALIAS_DESCRIPTION FROM APPS.IGSFV_CAL_PRD_EVNT_TYPE_PAIRS ORDER BY RELATED_DATE_ALIAS;

Because the view is not referenced by other database objects and is exposed directly in the APPS schema, report developers can query it without additional joins, using RELATED_DATE_ALIAS as the linkage to any other context that stores date-alias names.