Search Results disc_dl_cons_id




Overview
Explore in AI Chat

Overview

The IGS.IGS_EN_DISC_DL_CONS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the IGS (Oracle Student Management) module. Its primary function is to define and manage offset constraints for non-standard unit section discontinuation deadlines. In the context of academic administration, discontinuation deadlines govern the final date by which a student can withdraw from a unit or section without academic or financial penalty. This table stores the business rules—constraints and their resolutions—that determine how these deadline dates are calculated when they deviate from standard academic calendars, ensuring institutional policies are systematically enforced within the system.

Key Information Stored

The table's columns are designed to capture the constraint definition and its administrative metadata. The key business columns include DISC_DL_CONS_ID, a system-generated unique identifier for each constraint record. The OFFSET_CONS_TYPE_CD specifies the category or type of the offset constraint being applied. The CONSTRAINT_CONDITION and CONSTRAINT_RESOLUTION columns work in tandem to define the rule's logic and the numerical adjustment or resolution applied when the condition is met. Crucially, the NON_STD_DISC_DL_STP_ID is a foreign key that links each constraint record to its parent non-standard discontinuation deadline setup, establishing the core relationship. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) provide audit trails for all data changes.

Common Use Cases and Queries

This table is central to configuring and reporting on customized academic deadline policies. A primary use case involves querying all constraint rules associated with a specific non-standard deadline setup for validation or review purposes. Administrators may also run diagnostic queries to identify setups with specific constraint types. Common SQL patterns include joining to the parent setup table (via NON_STD_DISC_DL_STP_ID) to get a complete view of a policy. For example, to audit all constraints for a given setup ID:

  • SELECT ddc.* FROM igs.igs_en_disc_dl_cons ddc WHERE ddc.non_std_disc_dl_stp_id = <setup_id>;

Another reporting use case involves listing all unique constraint types in use across the system: SELECT DISTINCT offset_cons_type_cd FROM igs.igs_en_disc_dl_cons ORDER BY 1;

Related Objects

Based on the provided metadata, the primary documented relationship for the IGS_EN_DISC_DL_CONS table is a foreign key dependency. The column NON_STD_DISC_DL_STP_ID is explicitly noted as a "Foreign Key to identify the non-standard unit section discontinuation deadline setup." This indicates it references a primary key, likely named similarly (e.g., DISC_DL_STP_ID or a system-generated ID), in a parent setup table. While the exact name of the referenced table is not listed in the excerpt, its logical name would be related to non-standard discontinuation deadline steps or setups. The table itself is referenced by the APPS synonym IGS_EN_DISC_DL_CONS, which is the standard access point for EBS applications and reports. No other referencing objects are detailed in the provided dependency information.