Search Results related_dt_alias




Overview
Explore in AI Chat

Overview

The IGS_CA_DA_PAIR table is a core configuration table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Institutional Global Systems (IGS) module, which manages academic and administrative functions. Its primary role is to define logical pairs of date aliases. A date alias is not an actual calendar date but a named event, such as "START_SEMESTER_BREAK." By pairing two such aliases, the system can define a period of time, enabling the modeling of academic intervals like breaks, enrollment periods, or terms. This pairing is fundamental for time-based constraints and scheduling logic across the student lifecycle management components of EBS.

Key Information Stored

The table stores the relationship between two date aliases to demarcate a period. The key columns are:

The table's unique index (IGS_CA_DA_PAIR_U1) enforces that each (DT_ALIAS, RELATED_DT_ALIAS) combination is distinct, while a non-unique index (IGS_CA_DA_PAIR_N1) on RELATED_DT_ALIAS supports reverse lookups.

Common Use Cases and Queries

A primary use case is defining institutional breaks. For example, pairing 'START_SEM_BREAK' with 'END_SEM_BREAK' allows the system to identify the span of a semester break when actual date instances are assigned in a holiday calendar. This is critical for calculating deadlines, validating date entries, and generating academic calendars. Common queries involve retrieving all pairs for a given date alias or validating period definitions.

Sample Query 1: Retrieve all pairs for a specific date alias:
SELECT dt_alias, related_dt_alias
FROM igs.igs_ca_da_pair
WHERE dt_alias = 'START_SEM_BREAK';

Sample Query 2: List all defined date alias pairs:
SELECT dt_alias, related_dt_alias, creation_date
FROM igs.igs_ca_da_pair
ORDER BY dt_alias;

Related Objects

The IGS_CA_DA_PAIR table has defined foreign key relationships with the core date alias definition table, ensuring referential integrity. The related objects are:

  • TABLE: IGS.IGS_CA_DA: The master table for date alias definitions. IGS_CA_DA_PAIR references it twice:
    • Foreign Key: IGS_CA_DA_PAIR.DT_ALIAS → IGS_CA_DA
    • Foreign Key: IGS_CA_DA_PAIR.RELATED_DT_ALIAS → IGS_CA_DA
    This ensures both aliases in a pair are valid, predefined entities within the system.
  • The table is also referenced by the APPS synonym IGS_CA_DA_PAIR, which is the standard access point for EBS application code and reports.