Results for “offset_duration”

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

Overview

IGS.IGS_EN_NSU_DLSTP_ALL is a transaction and reference table within the Oracle E-Business Suite IGS – Student System product family. It stores the configuration and control parameters that govern enrollment deadlines for non-standard unit sections — that is, sections whose unit weighting, scheduling, or delivery model falls outside the normal institutional pattern. The table functions as the deadline setup registry: it binds a specific deadline definition to a functional context, an academic organization unit, and a set of calculation rules (formula, rounding, offsets, and weekend handling).

In Oracle EBS 12.1.1 and 12.2.2 the object is owned by the IGS schema, carries VALID status, and exposes fifteen documented columns in the ETRM 12.1.1 physical schema. Its primary key is IGS_EN_NSU_DLSTP_ALL_PK, defined over NON_STD_USEC_DLS_ID. Two unique indexes — the business-key candidates IGS_EN_NSU_DLSTP_ALL_U1 and IGS_EN_NSU_DLSTP_ALL_U2 — reinforce natural-key uniqueness alongside the surrogate identifier. The ETRM metadata documents a single composite unique key constraint IGS_EN_NSU_DLSTP_ALL_UK1 over FUNCTION_NAME, DEFINITION_CODE, ORG_UNIT_CODE, and ORG_ID. From a Data Vault modeling perspective, the mined relationship structure classifies this table as hub-leaning: it holds a durable, business-keyed identity for a deadline setup definition that downstream tables reference by key. It should be modeled as a hub (or hub-like reference) that satellite tables and dependent offset configuration rows attach to.

Key Information Stored

The following columns are the most operationally significant of the fifteen documented:

• NON_STD_USEC_DLS_ID — the surrogate primary key (IGS_EN_NSU_DLSTP_ALL_PK). It uniquely identifies each non-standard unit section enrollment deadline setup row and is the column carried as a foreign key by all dependent tables.
• FUNCTION_NAME — the functional context or business process to which the deadline setup applies. It participates in both the primary unique constraint (UK1) and the business-key index U1.
• DEFINITION_CODE — the deadline definition being referenced. Combined with FUNCTION_NAME, ORG_UNIT_CODE, and ORG_ID, it forms the natural unique key.
• ORG_UNIT_CODE — the organizational unit (academic department, faculty, or school) that owns the deadline configuration.
• ORG_ID — the multi-organization identifier supporting the EBS multi-org security model.
• FORMULA_METHOD and ROUND_METHOD — control the arithmetic used to derive the calculated deadline date: the formula basis and the rounding convention applied to the result.
• OFFSET_DT_CODE and OFFSET_DURATION — specify the reference date code from which the offset is measured and the length of that offset. These drive the deadline offset behavior shared with IGS_EN_DL_OFFSET_CONS.
• INCL_WKEND_DURATION_FLAG — indicates whether weekend days are counted when the offset duration is applied to the reference date.
• Standard EBS audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide who/when traceability.

Common Use Cases and Queries

Primary use cases centre on validating and reporting non-standard unit section enrollment deadlines, and on controlling the enrollment window opened to students.

• Look up a deadline setup for an organization — join the business key columns to the organization definition to confirm the active configuration: SELECT NON_STD_USEC_DLS_ID, FUNCTION_NAME, DEFINITION_CODE, FORMULA_METHOD, OFFSET_DURATION FROM IGS_EN_NSU_DLSTP_ALL WHERE ORG_ID = :org_id AND ORG_UNIT_CODE = :org_unit;
• Enforce the natural key during data load or correction — check for duplicates on FUNCTION_NAME, DEFINITION_CODE, ORG_UNIT_CODE, and ORG_ID before insert.
• Resolve derived deadlines — read FORMULA_METHOD, ROUND_METHOD, OFFSET_DT_CODE, OFFSET_DURATION, and INCL_WKEND_DURATION_FLAG to compute the effective deadline date from a reference date in reporting extracts.
• Audit configuration changes — filter on LAST_UPDATE_DATE and LAST_UPDATED_BY to track setup drift across enrollment cycles.

Related Objects

Two documented foreign keys reference this table, confirming it as the parent in the relationship graph:

• IGS_EN_DL_OFFSET_CONS.NON_STD_USEC_DLS_ID — the deadline offset constants child table. Join on NON_STD_USEC_DLS_ID to retrieve the offset constant values applied to each setup.
• IGS_EN_NSTD_USEC_DL.NON_STD_USEC_DLS_ID — the non-standard unit section enrollment deadline table. Join on NON_STD_USEC_DLS_ID to link the setup definition to actual section-level deadline rows.

These two children are the primary integration points. Together with the parent setup row, they form the complete non-standard deadline model: the setup definition in IGS_EN_NSU_DLSTP_ALL, the constant inputs in IGS_EN_DL_OFFSET_CONS, and the resolved per-section deadlines in IGS_EN_NSTD_USEC_DL. Any extract, interface, or validation routine that reads or writes non-standard unit section deadlines will traverse this parent-child chain.