Search Results offset_date




Overview
Explore in AI Chat

Overview

IGS_EN_NSD_DLSTP is a public synonym/view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environment, owned by the APPS schema. It is part of the Oracle Student System (the "IGS" application family) and, more specifically, the Enrollment / Non-Standard Registration area. The view exposes configuration data for the Non-Standard Discount Deadline Step entity (the name derives from Non-Standard Discount Deadline STeP), which governs how non-standard fee or discount deadlines are calculated for a given administrative unit.

The view joins the base table IGS_EN_NSD_DLSTP_ALL against several descriptive lookup tables to present human-readable meanings in place of codes: administrative unit status, definition level, offset date, and organization unit. It is a query-only reporting and integration object; it presents the rules that determine when a deadline falls relative to an offset date. In the search context of "offset_date," the view is directly relevant because it exposes the OFFSET_DT_CODE and its translated MEANING from the OFFSET_DATE lookup, together with OFFSET_DURATION and the weekend-inclusion flag.

Underlying Base Objects

Per the documented view text, the view is defined over five objects:

  • IGS_EN_NSD_DLSTP_ALL — the primary driving table holding the non-standard discount deadline step records. The view is essentially a read-only projection of this table's ALL rows.
  • IGS_AD_ADM_UNIT_STAT — provides the description of the administrative unit status.
  • IGS_LOOKUPS_VIEW (aliased twice, LKV1 and LKV2) — supplies lookup meanings for DEFINITION_CODE (lookup type DEFINITION_LEVEL) and for OFFSET_DT_CODE (lookup type OFFSET_DATE).
  • IGS_OR_UNIT — provides the organization unit description, joined with an outer-join ((+)) on ORG_UNIT_CD, meaning a step may exist without a matching organization unit.

The view also carries a multi-org filter. It compares NDDS.ORG_ID (defaulted to -99 when NULL) against the operating-unit value decoded from USERENV('CLIENT_INFO'), enforcing the Oracle EBS Multi-Org security model so that users see only records for their accessible organization.

Key Columns

Common Use Cases and Queries

Typical uses include reporting on deadline-step configuration, validating offset date rules, and integration extracts that feed downstream enrollment or fee processes.

SELECT non_std_disc_dlstp_id,
       administrative_unit_status,
       definition_code,
       offset_dt_code,
       offset_duration,
       incl_wkend_duration_flag
FROM   apps.igs_en_nsd_dlstp
WHERE  org_unit_code = :org_unit_code;

To inspect offset date meanings specifically:

SELECT offset_dt_code,
       description,
       offset_duration
FROM   apps.igs_en_nsd_dlstp
WHERE  definition_code = :definition_code
ORDER  BY offset_dt_code;

Because the view is read-only, all maintenance of these rules is performed against IGS_EN_NSD_DLSTP_ALL through the Oracle Student System forms rather than the view itself.