Results for “igs_en_usec_disc_dl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS_EN_USEC_DISC_DL table belongs to the IGS – Student System product family within Oracle E-Business Suite. It is documented as an obsolete object, meaning Oracle no longer actively supports or ships it in current EBS 12.1.1 / 12.2.2 implementations, and the ETRM metadata explicitly notes "Not implemented in this database." Its purpose, as recorded in the data dictionary, is to hold the columns related to non-standard unit section discontinuation deadline dates — that is, the calculated dates on which a unit section offering (a specific administrative unit offering option) ceases to permit discontinuation under rules that differ from the standard institutional policy.

Because the table’s grain is one row per non-standard discontinuation deadline definition for a given unit offering option, a Data Vault modeling heuristic would classify this object as a link. It resolves a many-to-many style association between a unit offering option record and a non-standard discontinuation deadline step, carrying descriptive and derived date attributes alongside the relationship.

Key Information Stored

The table comprises eighteen documented columns. The most significant include:

• USEC_DISC_DL_ID — the system-generated surrogate primary key, defined by the IGS_EN_USEC_DISC_DL_PK constraint and also enforced through the unique index IGS_EN_USEC_DISC_DL_U1.
• UOO_ID and ADMINISTRATIVE_UNIT_STATUS — the composite business-key candidate, defined by unique index IGS_EN_USEC_DISC_DL_U2. UOO_ID references the unit offering option, while ADMINISTRATIVE_UNIT_STATUS distinguishes the administrative state to which the deadline rule applies.
• NON_STD_DISC_DL_STP_ID — the foreign key to the non-standard discontinuation deadline step definition in IGS_EN_NSD_DLSTP_ALL.
• USEC_DISC_DL_DATE — the resolved discontinuation deadline date calculated for the unit offering option.
• USEC_DISC_TOTAL_DAYS and USEC_DISC_OFFSET_DAYS — the total duration and the applied offset, expressed in days, used to derive the deadline.
• FORMULA_METHOD, ROUND_METHOD, OFFSET_DT_CODE, and OFFSET_DURATION — the calculation controls governing how the deadline date is computed and rounded.
• DEFINITION_CODE and ORG_UNIT_CODE — descriptive categorization and organizational context for the rule.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — standard EBS WHO-column audit attributes.

Common Use Cases and Queries

In institutional reporting, this table is queried to explain why a student’s discontinuation request for a unit section was accepted or rejected relative to a non-standard deadline. A typical join retrieves the deadline date for a unit offering option:

SELECT u.USEC_DISC_DL_DATE, u.UOO_ID, u.ADMINISTRATIVE_UNIT_STATUS
FROM IGS_EN_USEC_DISC_DL u
WHERE u.UOO_ID = :p_uoo_id
AND u.ADMINISTRATIVE_UNIT_STATUS = :p_status;

Because the deadline is derived rather than stored arbitrarily, analysts frequently reconcile USEC_DISC_DL_DATE against USEC_DISC_TOTAL_DAYS and USEC_DISC_OFFSET_DAYS to validate the calculation logic configured through FORMULA_METHOD and ROUND_METHOD. Reporting teams may also extract deadline rules by definition for calendar planning, filtering on DEFINITION_CODE or ORG_UNIT_CODE. Given its obsolete status, any query against this table in a live 12.2.2 instance should first confirm existence through ALL_TABLES before use.

Related Objects

The documented foreign key relationships and supporting metadata identify the following dependent and referenced objects:

• IGS_EN_NSD_DLSTP_ALL — referenced via IGS_EN_USEC_DISC_DL.NON_STD_DISC_DL_STP_ID; supplies the deadline step definition.
• IGS_PS_UNIT_OFR_OPT_ALL — referenced via IGS_EN_USEC_DISC_DL.UOO_ID; supplies the unit offering option to which the deadline applies.
• IGS_EN_USEC_DISC_DL_PK — the primary key constraint on USEC_DISC_DL_ID.
• IGS_EN_USEC_DISC_DL_U1 — unique index on USEC_DISC_DL_ID.
• IGS_EN_USEC_DISC_DL_U2 — unique index on UOO_ID and ADMINISTRATIVE_UNIT_STATUS, the business-key candidate.

Collectively these objects form the discontinuation deadline sub-model within the Student System, linking deadline-step configuration to concrete unit offering options.