Search Results igs_en_nstd_usec_dl_v




Overview
Explore in AI Chat

Overview

The view APPS.IGS_EN_NSTD_USEC_DL_V is a reporting and integration object within the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to describe all columns related to non-standard unit section enrollment deadline dates. It exposes enrollment deadline configuration records that govern when students may enroll in non-standard unit offerings, together with descriptive attributes derived from Oracle lookups and organizational unit data. The view is defined in the APPS schema and carries a documented status of VALID in the ETRM repository for release 12.2.2. Because it is a view rather than a base table, it performs no independent data storage; instead, it presents a denormalized, presentation-ready projection of the underlying configuration table.

Underlying Base Objects

Although the supplied ETRM metadata records no formal referenced base objects, the embedded view text identifies the actual dependencies. The primary driving object is IGS_EN_NSTD_USEC_DL, aliased NSDL, which holds the non-standard unit section enrollment deadline definitions. The view outer-joins this table to three supporting objects:

All three lookup joins and the organization join use the Oracle outer-join operator (+), ensuring that deadline rows are retained even when no matching lookup or organization record exists. The view also selects NSDL.ROWID, which supports row identification for update-capable consumers.

Key Columns

Common Use Cases and Queries

The view is typically consumed by enrollment validation logic, deadline monitoring reports, and integrations that require decoded deadline configuration. A representative query retrieving deadlines for a specific organizational unit follows:

  • SELECT nstd_usec_dl_id, enr_dl_date, function_name_meaning, definition_code_meaning, org_description FROM igs_en_nstd_usec_dl_v WHERE org_unit_code = :p_org_unit_code ORDER BY enr_dl_date;
  • SELECT nstd_usec_dl_id, offset_dt_meaning, offset_duration, formula_method, round_method FROM igs_en_nstd_usec_dl_v WHERE enr_dl_date IS NULL; — identifies calculated deadlines relying on offset parameters.
  • SELECT uoo_id, COUNT(*) FROM igs_en_nstd_usec_dl_v GROUP BY uoo_id; — reconciles multiple deadline definitions per unit offering option.

Because lookup meanings are decoded in-line, the view is well suited to concurrent program data sources and BI Publisher report definitions where human-readable values are required without additional lookup joins.