Search Results igsfv_cal_prd_evnt_pairs




Overview
Explore in AI Chat

Overview

The IGSFV_CAL_PRD_EVNT_PAIRS view is a reporting and integration object within the Oracle EBS IGS — Student System module (now classified as obsolete). It presents the full entity representation of Calendar Period Event Pairs, a construct that stores the pairing of two date alias instances and enables the definition of a period of time inclusive of both date aliases. In the academic calendar model, this allows institutions to express span-based periods — for example, the interval between an enrolment open date and an enrolment close date, or between term start and term end — in terms of abstract date aliases rather than literal dates. Because the view resolves alias instances into actual (derived and absolute) date values, it serves as a convenient reporting source for downstream calendaring, scheduling, and integration logic. Note that the view is documented as not implemented in the supplied database, and the underlying IGS product line is obsolete, so it should be treated as a legacy artifact.

Underlying Base Objects

The view is defined over three base tables. The driving table is IGS_CA_DA_INST_PAIR (aliased DA), which physically stores each pairing of two date alias instances. It is joined twice to IGS_CA_DA_INST (aliased DA1 and DA2) to resolve the primary alias instance and its related alias instance respectively. The join predicates match on DT_ALIAS, SEQUENCE_NUMBER, CAL_TYPE, and CI_SEQUENCE_NUMBER for both sides. The query is declared WITH READ ONLY, confirming that the view is strictly a reporting surface over these tables. Resolution of the alias instances into calendar dates is delegated to two generated package functions: IGS_CA_GEN_001.CALP_SET_ALIAS_VALUE and IGS_CA_GEN_002.CALS_CLC_DT_FROM_DAI. Although ETRM documents no referenced base objects explicitly, these three tables and two package functions constitute the functional dependency chain.

Key Columns

Common Use Cases and Queries

Typical uses include reporting on period definitions expressed between two date aliases, validating that a span falls within a calendar instance, and feeding integrations that require concrete dates for a named period. Because the view resolves values through package functions, callers should expect row-by-row function execution and plan queries with selective predicates on calendar type or alias.

SELECT DATE_ALIAS,
       DATE_ALIAS_INST_DERIVED_VALUE,
       RELATED_DATE_ALIAS,
       REL_DATE_ALIAS_INST_DERVD_VAL
  FROM IGSFV_CAL_PRD_EVNT_PAIRS
 WHERE CALENDAR_TYPE = :p_cal_type
   AND CAL_INST_SEQ_NUM = :p_seq_num;

A second common pattern filters by the primary alias to retrieve every related span that begins at that alias:

SELECT RELATED_DATE_ALIAS,
       REL_DATE_ALIAS_INST_DERVD_VAL
  FROM IGSFV_CAL_PRD_EVNT_PAIRS
 WHERE DATE_ALIAS = :p_date_alias
 ORDER BY REL_DATE_ALIAS_INST_DERVD_VAL;

Given the obsolete status of the IGS module and the note that the view is not implemented in the supplied database, consumers on 12.1.1 or 12.2.2 should verify object existence before relying on it, and should prefer the current Student System calendaring APIs where available.