Search Results igsbv_cal_prd_evnt_pairs

Overview

The IGSBV_CAL_PRD_EVNT_PAIRS view is the base view for the Calendar Period Event Pairs entity within the Oracle E-Business Suite Student System (IGS) module. It defines the pairing of two date alias instances, thereby enabling the definition of a period of time that is inclusive of the two date aliases. In practical terms, this view exposes the structural relationship between a starting date alias instance and its related (ending) date alias instance, both of which are anchored to specific calendar instances and calendar types.

This object belongs to the IGS - Student System product, which is flagged as Obsolete in the documented metadata. As a result, the view is principally encountered in legacy EBS 12.1.1 and 12.2.2 environments that still reference historical academic calendar configurations. It is not implemented in the current database, meaning no runtime deployment exists for this object in the documentation set examined. The view is defined WITH READ ONLY, so it serves purely as a query and reporting construct rather than a DML target.

Its role in reporting and integration is to flatten the join between date alias pair definitions and their constituent alias instances, presenting both derived and absolute date values for each side of the pair. Downstream reports, academic calendar extracts, and period-definition inquiries can therefore resolve a "from-to" window without manually joining the pair table to the alias-instance table twice.

Underlying Base Objects

The view is defined over three base objects, all in the IGS calendar schema family:

• IGS_CA_DA_INST_PAIR DA — the driving table holding the pairing record that links a date alias instance to a related date alias instance.
• IGS_CA_DA_INST DA1 — the alias instance supplying the first (primary) date alias in the pair.
• IGS_CA_DA_INST DA2 — the alias instance supplying the second (related) date alias in the pair.

The join is performed on the composite key of DT_ALIAS, SEQUENCE_NUMBER, CAL_TYPE, and CI_SEQUENCE_NUMBER for each side. For the primary alias, DA.DT_ALIAS = DA1.DT_ALIAS and equivalent conditions are applied; for the related alias, DA.RELATED_DT_ALIAS = DA2.DT_ALIAS and equivalent conditions are applied. Note that the ETRM documentation records no referenced base objects formally, though the view text itself identifies the three tables above.

The view also invokes two server-side functions to compute derived values: IGS_CA_GEN_001.CALP_SET_ALIAS_VALUE and IGS_CA_GEN_002.CALS_CLC_DT_FROM_DAI. These functions convert absolute values and compute the calendar date from a date alias instance, respectively.

Key Columns

The view exposes the following principal columns:

• DATE_ALIAS, DATE_ALIAS_INST_SEQ_NUM, CALENDAR_TYPE, CAL_INST_SEQ_NUM — identify the primary date alias instance within its calendar instance context.
• RELATED_DATE_ALIAS, RELATE_DATE_ALIAS_INST_SEQ_NUM, RELATED_CALENDAR_TYPE, RELATED_CAL_INST_SEQ_NUM — identify the paired (related) date alias instance.
• DATE_ALIAS_INST_ABSOLUTE_VALUE — the raw stored value of the primary alias instance.
• DATE_ALIAS_INST_ALIAS_VALUE — the alias value transformed via CALP_SET_ALIAS_VALUE.
• DATE_ALIAS_INST_DERIVED_VALUE — the calendar date computed by CALS_CLC_DT_FROM_DAI for the primary alias.
• REL_DATE_ALIAS_INST_ABSOLT_VAL, REL_DATE_ALIAS_INST_ALIAS_VAL, REL_DATE_ALIAS_INST_DERVD_VAL — the equivalent absolute, alias-transformed, and derived date values for the related alias instance.
• CREATED — the creation audit column (corresponding to CREATED_BY and CREATION_DATE in the view text).

Common Use Cases and Queries

Typical uses include resolving academic period boundaries, validating that a period's start precedes its end, and feeding date windows into enrollment or scheduling processes. A basic retrieval of all defined pairs is shown below.

• List all period event pairs with their derived date values:

  SELECT date_alias,
         calendar_type,
         date_alias_inst_derived_value,
         related_date_alias,
         related_calendar_type,
         rel_date_alias_inst_derd_val
  FROM   igsbv_cal_prd_evnt_pairs;

• Filter pairs belonging to a specific calendar type:

  SELECT date_alias, related_date_alias
  FROM   igsbv_cal_prd_evnt_pairs
  WHERE  calendar_type = :p_cal_type;

• Validate chronological ordering of the pair:

  SELECT date_alias, related_date_alias
  FROM   igsbv_cal_prd_evnt_pairs
  WHERE  date_alias_inst_derived_value >
         rel_date_alias_inst_derd_val;

Because the view is read-only and the product is obsolete, any new development should confirm availability before relying on it, but existing reports and extracts can safely query it in supported 12.1.1 and 12.2.2 instances where the IGS calendar objects remain installed.