Search Results round_method




Overview
Explore in AI Chat

Overview

IGS_EN_USEC_DISC_DL_V is a reporting view in the Oracle E-Business Suite Student System (IGS) module. It exposes the full set of columns associated with non-standard unit section discontinuation deadline dates — that is, the calculated cut-off dates by which a student must discontinue a non-standard unit section (a "usec") without penalty. The view denormalizes the base transactional record held in IGS_EN_USEC_DISC_DL and joins it to administrative unit status, lookup, and organization descriptions so that deadline records can be reported in human-readable terms rather than as raw coded identifiers.

The "Obsolete" product designation indicates this object belongs to the legacy Student System product line, which was superseded by later Oracle Student Cloud offerings. The ETRM metadata records that the view was not implemented in the reference database, meaning it is documented for completeness but may not exist in every 12.1.1 or 12.2.2 environment. Reports or integrations that depend on it should verify its presence in ALL_VIEWS before execution.

Underlying Base Objects

The view text shows a single driving table, IGS_EN_USEC_DISC_DL (aliased UDD), which stores the deadline rows. It is joined to four supporting objects:

All joins to the descriptive objects are outer joins ((+) syntax, consistent with pre-ANSI Oracle SQL used throughout 12.1.1/12.2.2). The only inner-style dependency is the driving table itself; no row from the base table is eliminated for missing descriptive data, which maximizes the completeness of the reported deadline set.

Key Columns

Common Use Cases and Queries

Typical use is deadline reporting for a given organization, or auditing which offset date codes are in use. The following sample returns decoded deadlines for one organization:

SELECT usec_disc_dl_date,
       offset_dt_code,
       offset_dt_code_meaning,
       usec_disc_offset_days,
       org_description
FROM   igs_en_usec_disc_dl_v
WHERE  org_unit_code = :p_org_unit_code
ORDER  BY usec_disc_dl_date;

To audit the distribution of offset date codes — the reported focus of this view — an aggregation against the resolved lookup meaning is convenient:

SELECT offset_dt_code,
       offset_dt_code_meaning,
       COUNT(*) deadline_count
FROM   igs_en_usec_disc_dl_v
GROUP  BY offset_dt_code, offset_dt_code_meaning;

For integration work, the audit columns and surrogate identifiers allow incremental extraction based on LAST_UPDATE_DATE, supporting delta loads into reporting or data-warehouse layers.