Search Results igs_en_dl_offset_cons_v




Overview
Explore in AI Chat

Overview

IGS_EN_DL_OFFSET_CONS_V is an Oracle E-Business Suite view owned by the APPS schema and registered under the IGS (Student System) product family. It exposes the enrollment deadline date offset constraint configuration used by the Student System to govern how deadline dates are calculated and applied against enrollment records. The view is defined as a VALID database object in both EBS 12.1.1 and 12.2.2 and is documented in the ETRM repository at version 12.2.2.

Functionally, the view presents one row per enrollment deadline offset constraint, enriched with the decoded meaning of the constraint type code. It is intended for reporting, integration, and diagnostic purposes rather than transactional maintenance. Consumers include concurrent programs, Fast Formula logic, custom reports, and external integrations that need to resolve why a particular deadline was offset, which constraint condition was applied, and how that constraint was resolved.

The view is read-only. It carries the standard EBS audit columns and the ROWID pseudocolumn, which supports row identification for any custom update logic that must be redirected to the underlying base table.

Underlying Base Objects

The view is defined over two base objects owned by the IGS schema and referenced through the APPS synonym layer:

The join between the two objects is a lookup decode on LOOKUP_CODE = OFFSET_CONS_TYPE_CD, constrained by the fixed lookup type. Because the join is an inner join, rows in IGS_EN_DL_OFFSET_CONS whose OFFSET_CONS_TYPE_CD has no matching active lookup value in the DT_OFFSET_CONSTRAINT_TYPE lookup type will not appear in the view result set.

Key Columns

  • ROW_ID — the ROWID of the IGS_EN_DL_OFFSET_CONS row, used for row-level identification.
  • ENR_DL_OFFSET_CONS_ID — the primary key of the enrollment deadline offset constraint record.
  • OFFSET_CONS_TYPE_CD — the constraint type code stored on the base table.
  • OFFSET_CONS_TYPE_MEANING — the decoded description of the constraint type, obtained from IGS_LOOKUP_VALUES.MEANING for lookup type DT_OFFSET_CONSTRAINT_TYPE.
  • CONSTRAINT_CONDITION — the condition that triggers the offset constraint.
  • CONSTRAINT_RESOLUTION — the resolution applied when the constraint condition is met.
  • NON_STD_USEC_DLS_ID — the identifier linking the constraint to a non-standard usec deadline setup. This is the column most frequently targeted by the search term "non_std_usec_dls_id" and is the principal join key to non-standard deadline configuration.
  • DEADLINE_TYPE — the deadline type to which the offset constraint applies.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical usage centers on auditing deadline offset configuration and reconciling non-standard deadline records to their governing constraints.

  • List all offset constraints and their decoded types.
    SELECT enr_dl_offset_cons_id, offset_cons_type_cd, offset_cons_type_meaning, deadline_type FROM igs_en_dl_offset_cons_v;
  • Retrieve constraints tied to a specific non-standard usec deadline.
    SELECT enr_dl_offset_cons_id, constraint_condition, constraint_resolution, deadline_type FROM igs_en_dl_offset_cons_v WHERE non_std_usec_dls_id = :p_non_std_usec_dls_id;
  • Review all constraints having a non-null non-standard usec reference.
    SELECT * FROM igs_en_dl_offset_cons_v WHERE non_std_usec_dls_id IS NOT NULL;
  • Diagnose missing rows by verifying lookup values exist for the constraint type code.
    SELECT lookup_code, meaning FROM igs_lookup_values WHERE lookup_type = 'DT_OFFSET_CONSTRAINT_TYPE';

Because the view performs an inner join to the lookup, any gap between OFFSET_CONS_TYPE_CD values and the DT_OFFSET_CONSTRAINT_TYPE lookup set should be investigated when expected constraint rows are absent from query output.