Search Results igs_ca_da_pair_u1

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:

• DT_ALIAS (VARCHAR2(10), Mandatory): The primary or context date alias name that defines the start of a paired relationship.
• RELATED_DT_ALIAS (VARCHAR2(10), Mandatory): The related date alias name that pairs with DT_ALIAS to define the end of a period. The combination of these two columns forms the table's unique primary key (IGS_CA_DA_PAIR_PK).
• Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Audit columns tracking the creation and modification history of each record.

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.