Search Results igs_ca_da_inst_ofcnt

Overview

The table IGS_CA_DA_INST_OFCNT 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 constraint definition table for date alias offset calculations. In the context of academic calendaring, date aliases represent significant, reusable points in time (e.g., "Semester 1 Start"). The system allows for the generation of one date alias instance by applying an offset (like "+7 days") to another base date alias instance. This table stores the specific validation rules, or constraints, that govern how such offsets are applied, ensuring the resulting calculated dates adhere to institutional business logic and calendar integrity.

Key Information Stored

The table's primary key uniquely identifies a constraint rule by combining identifiers for both the source and target date alias instances. The key columns are logically grouped: the first set identifies the target date alias instance being generated, and the second set identifies the source date alias instance from which the offset is applied. The critical column defining the rule is S_DT_OFFSET_CONSTRAINT_TYPE, which holds the code for the specific constraint logic to be enforced.

• DT_ALIAS, DAI_SEQUENCE_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER: These columns collectively identify the target Date Alias Instance (the calculated date).
• OFFSET_DT_ALIAS, OFFSET_DAI_SEQUENCE_NUMBER, OFFSET_CAL_TYPE, OFFSET_CI_SEQUENCE_NUMBER: These columns collectively identify the source Date Alias Instance (the base date for the offset).
• S_DT_OFFSET_CONSTRAINT_TYPE: The core of the table. This column stores the type of constraint applied, such as ensuring the calculated date falls on a specific day of the week, within a term, or does not violate other calendar boundaries.

Common Use Cases and Queries

This table is primarily accessed during processes that generate or validate academic calendars. A common use case is the batch generation of a full academic calendar, where the system iteratively applies offset rules defined in IGS_CA_DA_INST_OFST, consulting this table to apply the necessary constraints for each calculation. For reporting and troubleshooting, administrators may query this table to audit the constraint rules in effect for specific calendar events.

A typical query would join this table to the related offset definition table to see the full rule set:

• SELECT c.*, o.offset_dt_alias, o.offset_value
FROM igs_ca_da_inst_ofcnt c, igs_ca_da_inst_ofst o
WHERE c.dt_alias = o.dt_alias
AND c.cal_type = 'SEMESTER'
ORDER BY c.dt_alias, c.dai_sequence_number;

Direct data manipulation via DML is uncommon; configuration is typically performed through the dedicated Student System calendar administration forms, which maintain referential integrity.

Related Objects

The IGS_CA_DA_INST_OFCNT table has a direct and integral relationship with the IGS_CA_DA_INST_OFST table, as indicated by its composite foreign key. The foreign key enforces that a constraint record must correspond to a valid offset definition record. This table is a supporting object for the core date alias instance tables (e.g., IGS_CA_DA_INST) and the calendar definition tables (IGS_CA_INST, IGS_CA_TYPE). Functionally, it is invoked by PL/SQL packages within the IGS calendar engine that perform date alias generation and validation, ensuring all calculated dates comply with the established constraint rules.