Search Results igs_ca_da_inst_pair_pk

Overview

The IGS_CA_DA_INST_PAIR table is a core data structure within the Oracle E-Business Suite Student System (IGS) module, present in both releases 12.1.1 and 12.2.2. Its primary function is to formally define a period of time by pairing two specific date alias instances. In the context of academic administration, a date alias is a named, configurable point in time (e.g., "Term Start," "Enrollment Deadline") within a calendar instance. This table enables the system to model relationships such as "from the start of the add/drop period to the end of the add/drop period," creating a reusable and precisely defined time span critical for scheduling, reporting, and enforcing business rules across the student lifecycle.

Key Information Stored

The table's structure is defined by two composite foreign keys, each linking to the IGS_CA_DA_INST (Date Alias Instance) table. It stores two complete sets of identifying columns to establish the pair. The first set defines the starting point of the period: DT_ALIAS, DAI_SEQUENCE_NUMBER, CAL_TYPE, and CI_SEQUENCE_NUMBER. The second set defines the ending point: RELATED_DT_ALIAS, RELATED_DAI_SEQUENCE_NUMBER, RELATED_CAL_TYPE, and RELATED_CI_SEQUENCE_NUMBER. The primary key (IGS_CA_DA_INST_PAIR_PK) encompasses all eight columns, ensuring each pairing is unique. This design enforces referential integrity, guaranteeing that both date alias instances exist within the system before a pair can be established.

Common Use Cases and Queries

This table is fundamental for processes that operate within defined academic periods. Common use cases include calculating the duration between key academic dates, determining if a current date falls within a specific administrative window (e.g., for fee assessment or grading), and generating reports on activities bounded by two calendar events. A typical query would join IGS_CA_DA_INST_PAIR to IGS_CA_DA_INST twice—once for the start alias and once for the end alias—to retrieve the actual calendar dates for a given period definition. For example, to find all defined periods for a specific academic calendar, one would filter on the CAL_TYPE and RELATED_CAL_TYPE columns. Reporting on student enrollment activity during the official "Instructional Period" would rely on the date range defined by the corresponding pair in this table.

Related Objects

The IGS_CA_DA_INST_PAIR table has a direct and exclusive dependency on the IGS_CA_DA_INST table, as indicated by its two foreign key constraints. Both foreign keys reference the IGS_CA_DA_INST table, linking the base and related date alias instances. This table is likely referenced by various program units within the Student System to resolve time periods for business logic. While specific dependent objects are not listed in the provided metadata, it is a foundational table for the calendar engine. Related objects would include the parent tables for calendar types (IGS_CA_TYPE) and calendar instances (IGS_CA_INST), as well as any forms, concurrent programs, or APIs that manage or utilize defined date alias periods.