Search Results offset_dt_code

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:

• IGS_AD_ADM_UNIT_STAT (aliased AUS) — supplied the administrative unit status description via an outer join.
• IGS_LOOKUP_VALUES (aliased LKV1) — resolved DEFINITION_CODE against lookup type DEFINITION_LEVEL.
• IGS_LOOKUP_VALUES (aliased LKV2) — resolved OFFSET_DT_CODE against lookup type OFFSET_DATE.
• IGS_OR_INST_ORG_BASE_V (aliased OU) — resolved the organization unit code to a party name, filtered to institutional organizations (INST_ORG_IND = 'O').

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

• USEC_DISC_DL_ID — primary identifier for the discontinuation deadline record.
• NON_STD_DISC_DL_STP_ID, UOO_ID — foreign keys linking the deadline to its setup step and to the unit offering option.
• USEC_DISC_DL_DATE — the calculated discontinuation deadline date; the principal business output of the record.
• USEC_DISC_TOTAL_DAYS and USEC_DISC_OFFSET_DAYS — the total span and offset used in the date calculation.
• ADMINISTRATIVE_UNIT_STATUS / DESCRIPTION — status code and its descriptive text.
• DEFINITION_CODE / DEFINITION_CODE_MEANING — definition level code resolved through the DEFINITION_LEVEL lookup.
• OFFSET_DT_CODE / OFFSET_DT_CODE_MEANING — the offset date basis code and its decoded meaning, resolved through the OFFSET_DATE lookup. This is the searched column and identifies the reference point from which the offset interval is measured.
• ORG_UNIT_CODE / ORG_DESCRIPTION — organizational owner of the deadline and its party name.
• FORMULA_METHOD, ROUND_METHOD, OFFSET_DURATION — the calculation rules applied.
• Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

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.