Search Results igs_ca_da_inst_ofst




Overview
Explore in AI Chat

Overview

The IGS_CA_DA_INST_OFST table is a core data structure within the Oracle E-Business Suite Student System (IGS) module, versions 12.1.1 and 12.2.2. It functions as a relationship table that defines a specific offset or link between two date alias instances. In the academic context, date aliases represent significant calendar events (e.g., "Term Start," "Census Date," "Final Exam Week"). This table allows the system to establish that one calculated date instance is derived from or related to another by a defined sequence, enabling complex academic calendar scheduling and dependency tracking. Its role is critical for maintaining the integrity and logic of the academic calendar framework.

Key Information Stored

The table's structure is composed of two sets of identical columns, each set identifying a specific date alias instance. The primary key is a composite of eight columns, ensuring a unique relationship definition. The first set identifies the source or base date alias instance: DT_ALIAS, DAI_SEQUENCE_NUMBER, CAL_TYPE, and CI_SEQUENCE_NUMBER. The second set identifies the related or offset date alias instance using the corresponding OFFSET_ prefixed columns: OFFSET_DT_ALIAS, OFFSET_DAI_SEQUENCE_NUMBER, OFFSET_CAL_TYPE, and OFFSET_CI_SEQUENCE_NUMBER. Together, these columns store the precise relationship stating that the offset instance is determined relative to the base instance, forming the foundation for date calculations within the student system.

Common Use Cases and Queries

A primary use case is generating academic calendars where key dates depend on others; for example, defining that a "Fee Payment Deadline" date is always 14 days after the "Enrollment Confirmation" date. System processes and custom reports query this table to traverse these relationships and calculate final dates. A typical query pattern involves joining IGS_CA_DA_INST_OFST to the IGS_CA_DA_INST table twice—once for the base date details and once for the offset date details. For instance, to find all offset relationships for a specific calendar type, one might use: SELECT base.dt_alias, offset.offset_dt_alias FROM igs_ca_da_inst_ofst rel, igs_ca_da_inst base, igs_ca_da_inst offset WHERE rel.cal_type = :p_cal_type AND rel.dt_alias = base.dt_alias AND rel.offset_dt_alias = offset.dt_alias; This facilitates reporting on calendar date dependencies and auditing configuration.

Related Objects

The IGS_CA_DA_INST_OFST table has integral relationships with other calendar entities. It maintains two foreign key relationships to the IGS_CA_DA_INST (Date Alias Instance) table: one linking the base instance columns and another linking the offset instance columns. This enforces referential integrity, ensuring that every relationship defined points to valid date alias instances. Furthermore, the table is referenced by the IGS_CA_DA_INST_OFCNT table, as indicated by the foreign key from IGS_CA_DA_INST_OFCNT to IGS_CA_DA_INST_OFST. This suggests IGS_CA_DA_INST_OFCNT may store additional counts or details pertaining to these established offset relationships, extending their functional usage within the application.