Search Results igs_en_disc_dl_cons

Overview

The table IGS_EN_DISC_DL_CONS is a core data object within the Oracle E-Business Suite Student System (IGS) module, versions 12.1.1 and 12.2.2. It functions as a configuration table that defines and manages constraints related to discontinuation deadline date offsets. Its primary role is to establish business rules governing the calculation of deadlines by which a student can discontinue from a unit or course, based on specific offset conditions. This table is essential for enforcing institutional academic policies regarding enrollment changes and ensuring consistent deadline calculations across the student lifecycle.

Key Information Stored

The table stores constraint definitions that link offset types to specific non-standard discontinuation deadline steps. The key columns include DISC_DL_CONS_ID, which serves as the unique primary key identifier for each constraint record. The OFFSET_CONS_TYPE_CD column holds the code representing the type of offset constraint being applied. A critical foreign key column is NON_STD_DISC_DL_STP_ID, which references a specific step in a non-standard discontinuation deadline process defined in the related IGS_EN_NSD_DLSTP_ALL table. This structure allows administrators to define which offset calculation rules apply to which procedural steps.

Common Use Cases and Queries

This table is primarily accessed for system configuration and validation during enrollment transactions. A common use case is when an administrator sets up or modifies the rules for calculating discontinuation deadlines for a particular academic calendar or program. Reporting use cases involve auditing the configured constraints to ensure policy compliance. A typical query would join this table to the related non-standard deadline step table to retrieve a full view of the configured rules.

SELECT cons.disc_dl_cons_id,
       cons.offset_cons_type_cd,
       cons.non_std_disc_dl_stp_id,
       step.step_description
FROM igs.igs_en_disc_dl_cons cons,
     igs.igs_en_nsd_dlstp_all step
WHERE cons.non_std_disc_dl_stp_id = step.non_std_disc_dl_stp_id;

Related Objects

The table maintains a direct foreign key relationship, which is central to its function. It references the table IGS_EN_NSD_DLSTP_ALL via the column NON_STD_DISC_DL_STP_ID. This relationship ties each offset constraint to a specific step within a broader, non-standard discontinuation deadline process. The primary key IGS_EN_DISC_DL_CONS_PK (on DISC_DL_CONS_ID) and the unique key IGS_EN_DISC_DL_CONS_UK1 (on OFFSET_CONS_TYPE_CD, NON_STD_DISC_DL_STP_ID) ensure data integrity and prevent duplicate constraint definitions for the same step and offset type.