Search Results igs_en_dl_offset_cons_u2

Overview

The IGS.IGS_EN_DL_OFFSET_CONS table is a transaction-data table in the Oracle E-Business Suite higher-education product family (IGS, the Student Systems / Student Information schema). It describes the columns that govern enrollment deadline date offset constraints — the rules that determine how deadline dates are shifted (offset) relative to another reference date, and how conflicting or conditional situations are resolved. The table resides in the APPS_TS_TX_DATA tablespace with the standard PCT Free of 10, consistent with ETRM transactional objects.

Under a heuristic Data Vault classification, this object is satellite-leaning. It carries descriptive, context-dependent attributes about deadline offset rules rather than acting as a pure hub of business keys or a link between two hubs. The single foreign-key relationship it maintains — to IGS_EN_NSU_DLSTP_ALL — reinforces this, since the parent table supplies the non-standard unit section deadline context while this table holds the rule-level descriptive payload. A Data Vault practitioner would typically model this as a satellite attached to the non-standard deadline hub, keyed by the surrogate ENR_DL_OFFSET_CONS_ID.

Key Information Stored

The table exposes eleven documented columns. The most significant are:

• ENR_DL_OFFSET_CONS_ID (NUMBER, 15) — the surrogate primary key of the row, defined by IGS_EN_DL_OFFSET_CONS_PK.
• OFFSET_CONS_TYPE_CD (VARCHAR2, 30) — the offset constraint type code, a business-key participant forming part of unique index U2.
• DEADLINE_TYPE (VARCHAR2) — the deadline classification, holding the value 'E' for enrollment deadlines or 'R' for retention deadlines. This is the column most directly associated with the user search term "deadline_type," and it also participates in the U2 business key.
• NON_STD_USEC_DLS_ID (NUMBER, 15) — foreign key to IGS_EN_NSU_DLSTP_ALL, supplying the non-standard unit section deadline context; it also participates in U2.
• CONSTRAINT_CONDITION (VARCHAR2, 10) — the condition under which the offset constraint applies.
• CONSTRAINT_RESOLUTION (NUMBER) — the resolution applied when the constraint condition is met.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns present on virtually all ETRM transactional tables.

The unique index IGS_EN_DL_OFFSET_CONS_U1 covers ENR_DL_OFFSET_CONS_ID, confirming it as the surrogate PK. The composite unique index IGS_EN_DL_OFFSET_CONS_U2 (OFFSET_CONS_TYPE_CD, NON_STD_USEC_DLS_ID, DEADLINE_TYPE) identifies the natural business key: an offset constraint is uniquely identified within a non-standard deadline context and deadline type.

Common Use Cases and Queries

Typical uses include validating that only one offset constraint exists per deadline context, extracting enrollment versus retention rules, and feeding reporting on deadline behavior. A representative query filters by deadline type:

SELECT ENR_DL_OFFSET_CONS_ID, OFFSET_CONS_TYPE_CD, CONSTRAINT_CONDITION,
CONSTRAINT_RESOLUTION, DEADLINE_TYPE
FROM IGS.IGS_EN_DL_OFFSET_CONS
WHERE DEADLINE_TYPE = 'E';

To surface retention-only offset rules, substitute 'R'. Joining to the parent via NON_STD_USEC_DLS_ID gives the full deadline-step context for each rule, which is useful when auditing configured deadlines or troubleshooting why an offset produced an unexpected date. Because the table is modest in size, it is frequently extracted whole for reconciliation and configuration reviews.

Related Objects

The FK relationship identifies the principal related object. The most significant dependencies are:

• IGS.IGS_EN_NSU_DLSTP_ALL — the parent table referenced through NON_STD_USEC_DLS_ID; this is the primary join path.
• APPS.IGS_EN_DL_OFFSET_CONS — the APPS-layer synonym/view exposing the same columns for application queries.

Queries against this table should join to IGS_EN_NSU_DLSTP_ALL on NON_STD_USEC_DLS_ID to resolve deadline-step detail, and use the composite business key (OFFSET_CONS_TYPE_CD, NON_STD_USEC_DLS_ID, DEADLINE_TYPE) when enforcing or verifying uniqueness.