Search Results igs_en_nstd_usec_dl_u2

Overview

IGS.IGS_EN_NSTD_USEC_DL is a transaction data table in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the IGS (Student Systems / Higher Education) schema. It stores the columns that describe non-standard unit section enrollment deadline dates. Within the broader enrollment configuration model, this table captures the calculated deadline dates applied to specific unit section offerings when a non-standard enrollment deadline setup is in force, rather than relying on default institution-wide rules.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its indexes are housed in APPS_TS_TX_IDX. The heuristic Data Vault classification mined from its foreign key structure is link. This suggests a modeling treatment in which the table acts as an associative relationship resolving the intersection between a non-standard discontinuation deadline setup record and a specific unit section offering. The table's two unique indexes and its foreign keys to the deadline setup and to the unit section offering support this interpretation.

Key Information Stored

The table contains 18 documented columns. The most significant are described below.

• NSTD_USEC_DL_ID — System-generated number uniquely identifying each non-standard unit section enrollment deadline record. This is the surrogate primary key (IGS_EN_NSTD_USEC_DL_PK) and is enforced by unique index IGS_EN_NSTD_USEC_DL_U1.
• NON_STD_USEC_DLS_ID — Foreign key identifying the non-standard unit section discontinuation deadline setup that governs this row. It references IGS_EN_NSU_DLSTP_ALL.
• UOO_ID — Foreign key identifying the unit section offering (Unit Of Offer). It references IGS_PS_UNIT_OFR_OPT_ALL.
• FUNCTION_NAME — The enrollment function to which the deadline applies. Together with UOO_ID it forms unique index IGS_EN_NSTD_USEC_DL_U2, a business-key candidate ensuring a single deadline definition per function and unit section offering.
• DEFINITION_CODE — The definition level for the enrollment function.
• ORG_UNIT_CODE — The code for the organizational unit, representing the business unit of the institution organization.
• FORMULA_METHOD — The formula used to calculate the deadline date, either Duration days or Meeting days.
• ROUND_METHOD — The rounding method applied to the result, either Standard Round or Always Round Up.
• OFFSET_DT_CODE — The offset date that is equivalent to an existing date, such as the unit section effective start date.
• OFFSET_DURATION — The duration of the offset expressed as a percentage value.
• ENR_DL_DATE — The calculated enrollment deadline date.
• ENR_DL_TOTAL_DAYS and ENR_DL_OFFSET_DAYS — Numeric values representing meeting or duration days and offset days respectively.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard WHO audit columns present on the table.

Common Use Cases and Queries

Reporting requirements commonly resolve calculated enrollment deadline dates per unit section offering, either for a given enrollment function or across the organization. A typical query joins the table to its referenced offering and setup objects:

• Listing enrollment deadlines by unit section offering: select the offering identifier, function name, and ENR_DL_DATE for active offerings during a term.
• Auditing which deadline definition applied to a specific offering, using UOO_ID and FUNCTION_NAME to trace back through the unique business-key index.
• Verifying offset and rounding configuration (OFFSET_DT_CODE, OFFSET_DURATION, ROUND_METHOD, FORMULA_METHOD) where calculated dates must be reproduced or validated against setup rules.
• Cross-checking recorded deadline dates (ENR_DL_DATE) against the derived total and offset day counts (ENR_DL_TOTAL_DAYS, ENR_DL_OFFSET_DAYS) for data-quality validation.

Related Objects

• IGS.IGS_EN_NSU_DLSTP_ALL — Referenced through NON_STD_USEC_DLS_ID; holds the non-standard unit section discontinuation deadline setup that the row derives from.
• IGS.IGS_PS_UNIT_OFR_OPT_ALL — Referenced through UOO_ID; defines the unit section offering to which the deadline applies.
• IGS_EN_NSTD_USEC_DL_PK — The primary key constraint on NSTD_USEC_DL_ID.
• IGS_EN_NSTD_USEC_DL_U1 — Unique index on NSTD_USEC_DL_ID in APPS_TS_TX_IDX.
• IGS_EN_NSTD_USEC_DL_U2 — Unique index on FUNCTION_NAME and UOO_ID, the business-key candidate underpinning the deadline-per-function-per-offering rule.