Search Results date_alias_description




Overview
Explore in AI Chat

Overview

IGSFV_CAL_PRD_EVNTTYP_OVRD_RLS is a Business Intelligence System (BIS) view owned by the APPS schema in Oracle E-Business Suite. It exposes the overriding rules that apply to the seeded system date types used by the Oracle Student System calendar engine. The view is registered in FND Design Data under the identifier IGS.IGSFV_CAL_PRD_EVNTTYP_OVRD_RLS and carries a status of VALID. Its documented purpose is to present the values of overriding rules associated with seeded system date types, allowing implementers and reporting developers to enumerate how a given system date type is overridden for particular academic elements such as programmes, attendance types, or school legislation categories.

Because the object is defined as a BIS view, it is intended for read-oriented reporting and integration rather than transactional maintenance. It consolidates descriptive attributes (system date type, base description, alias, and alias description) with override values into a single queryable surface, which simplifies downstream reporting against the calendar subsystem without requiring consumers to understand the underlying normalization.

Underlying Base Objects

The documented dependency list for this view references three APPS tables:

  • IGS_CA_DA — the calendar date alias (system date type) base table, supplying the seeded system date type and its short description.
  • IGS_CA_DA_CONFIGS — the configuration table that links system date types to their allowed override elements.
  • IGS_CA_DA_OVD_VALS — the override values table, which stores the actual override element value, the user-assigned date alias, and the alias description.

The view joins these three objects to resolve the alias and description metadata against the configured override values. The ETRM metadata states that IGSFV_CAL_PRD_EVNTTYP_OVRD_RLS is not referenced by any other database object, confirming that it functions purely as a terminal reporting view. Note that the documented 12.2.2 metadata lists no referenced base objects, so the dependency information above should be verified against the actual database definition in each environment.

Key Columns

Common Use Cases and Queries

Typical uses include validating seeded override configuration, generating documentation of date alias rules per system date type, and feeding downstream extracts that map override elements to aliases. A simple listing of override rules by system date type:

SELECT SYSTEM_DATE_TYPE, SYSTEM_DATE_TYPE_DESC, OVERRIDE_ELEMENT_VALUE, DATE_ALIAS, DATE_ALIAS_DESCRIPTION FROM APPS.IGSFV_CAL_PRD_EVNTTYP_OVRD_RLS ORDER BY SYSTEM_DATE_TYPE, DATE_ALIAS;

To locate a specific alias description across all system date types:

SELECT SYSTEM_DATE_TYPE, OVERRIDE_ELEMENT_VALUE, DATE_ALIAS, DATE_ALIAS_DESCRIPTION FROM APPS.IGSFV_CAL_PRD_EVNTTYP_OVRD_RLS WHERE UPPER(DATE_ALIAS_DESCRIPTION) LIKE UPPER('%:search_term%');

Because the view is read-only and not referenced by other database objects, it is safe to query directly in reporting schemas or BI Publisher data models without impacting calendar processing.