Search Results igs_en_nsd_dlstp_all_uk1

Overview

The table IGS_EN_NSD_DLSTP_ALL is a core data structure within the Oracle E-Business Suite Student System (IGS) for releases 12.1.1 and 12.2.2. It is designed to manage the setup and configuration of discontinuation deadlines for non-standard unit sections. In academic administration, a non-standard unit section typically refers to a class offering that does not follow the regular academic calendar, such as intensive courses, workshops, or modules with atypical start and end dates. This table provides a centralized mechanism to define the specific deadlines by which students can discontinue from these sections, based on administrative unit status, definition codes, and organizational context. Its role is critical for enforcing academic and administrative policies, ensuring accurate enrollment management, and supporting related processes like fee adjustments and academic reporting.

Key Information Stored

The table's primary purpose is to store setup records for these customized deadlines. Key columns, as indicated by its constraints, include the surrogate primary key NON_STD_DISC_DL_STP_ID. The unique key constraint (IGS_EN_NSD_DLSTP_ALL_UK1) highlights the business key columns that define a specific setup rule: ADMINISTRATIVE_UNIT_STATUS (linking to IGS_AD_ADM_UNIT_STAT_ALL), DEFINITION_CODE, ORG_UNIT_CODE, and ORG_ID. The ORG_ID column signifies the table's support for multi-organization architecture. Collectively, these columns allow institutions to establish distinct discontinuation rules tailored to different administrative statuses (e.g., active, planned), unit definitions, and organizational units within the enterprise.

Common Use Cases and Queries

A primary use case is the validation and retrieval of applicable discontinuation deadlines when a student attempts to drop a non-standard unit section. Administrators also use this setup for configuring and maintaining academic calendars. Common reporting needs include listing all configured deadline rules for an organizational unit or auditing rules for a specific administrative status. Sample SQL patterns often involve joining to the administrative unit status table for descriptions and filtering by the business key columns.

• Retrieve all setup rules for a specific org unit: SELECT * FROM igs_en_nsd_dlstp_all WHERE org_unit_code = '<CODE>' AND org_id = <ID> ORDER BY definition_code;
• Find the specific rule for a given status and definition: SELECT non_std_disc_dl_stp_id FROM igs_en_nsd_dlstp_all WHERE administrative_unit_status = '<STATUS>' AND definition_code = '<CODE>' AND org_id = <ID>;

Related Objects

The table is centrally connected to several other key entities in the Student System via documented foreign key relationships. It references the IGS_AD_ADM_UNIT_STAT_ALL table through the ADMINISTRATIVE_UNIT_STATUS column to validate the administrative status. More significantly, its primary key (NON_STD_DISC_DL_STP_ID) is referenced as a foreign key by two critical transactional tables:

• IGS_EN_DISC_DL_CONS: Links discontinuation deadline considerations to a specific non-standard deadline setup record.
• IGS_EN_USEC_DISC_DL: Stores the actual discontinuation deadlines for unit sections, which are derived from the setup rules defined in this table.

These relationships confirm that IGS_EN_NSD_DLSTP_ALL serves as a master setup table, whose identifiers are propagated into operational data tables governing student enrollment actions.