Search Results offset_cons_type_meaning




Overview
Explore in AI Chat

Overview

APPS.IGS_EN_DISC_DL_CONS_V is a supplementary Oracle E-Business Suite view owned by the APPS schema and registered under FND Design Data as IGS.IGS_EN_DISC_DL_CONS_V. It exposes configuration data relating to offset constraints for non-standard unit section discontinuation deadline setup within the Oracle Student System (IGS) product family. The view is classified as a supplementary view used to simplify Forms coding, meaning it exists primarily to support the Oracle Forms-based user interface rather than to serve as a documented integration or reporting interface. Oracle explicitly warns that querying or altering data through this view is not recommended, because the definition may change dramatically across minor or major releases. In EBS 12.1.1 and 12.2.2 the object remains VALID within the APPS schema, and developers who encounter it typically do so while troubleshooting enrollment deadline logic or investigating the source of an "offset constraint" value displayed on a form. The column most often searched for, OFFSET_CONS_TYPE_MEANING, is a denormalized lookup description surfaced by the view to spare the Forms layer from performing a separate lookup join at runtime.

Underlying Base Objects

The documented dependency list identifies two referenced objects: the base table APPS.IGS_EN_DISC_DL_CONS and the lookup view APPS.IGS_LOOKUPS_VIEW. The base table stores the actual offset constraint records, keyed by DISC_DL_CONS_ID, with the constraint condition, resolution, and a foreign key (NON_STD_DISC_DL_STP_ID) pointing to IGS_EN_NSD_DLSTP, which holds the non-standard unit section discontinuation deadline step definitions. IGS_LOOKUPS_VIEW supplies the descriptive meaning for the OFFSET_CONS_TYPE_CD lookup code, producing the OFFSET_CONS_TYPE_MEANING column. The view is not referenced by any other database object, confirming that it sits at the leaf of the dependency chain and functions purely as a convenience access path for the application layer.

Key Columns

  • ROW_ID — ROWID pseudocolumn identifying each row in the view result set.
  • DISC_DL_CONS_ID — System-generated sequence number uniquely identifying an offset constraint for non-standard unit section discontinuation deadline setup.
  • OFFSET_CONS_TYPE_CD — The stored lookup code representing the constraint type.
  • OFFSET_CONS_TYPE_MEANING — The translated description of the constraint type, derived from IGS_LOOKUPS_VIEW; this is the column most commonly referenced in ad hoc queries and form blocks.
  • CONSTRAINT_CONDITION — The condition under which the constraint applies.
  • CONSTRAINT_RESOLUTION — Numeric indicator of how the constraint is resolved.
  • NON_STD_DISC_DL_STP_ID — Foreign key to IGS_EN_NSD_DLSTP linking the constraint to its parent deadline step.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.

Common Use Cases and Queries

The principal practical use of this view is diagnostic: determining which constraint types and meanings are attached to a given non-standard discontinuation deadline step, or resolving an OFFSET_CONS_TYPE_MEANING value observed in the enrollment forms. A typical query joins back to the parent step table to provide context:

SELECT c.disc_dl_cons_id, c.offset_cons_type_cd, c.offset_cons_type_meaning, c.constraint_condition, c.constraint_resolution FROM apps.igs_en_disc_dl_cons_v c WHERE c.non_std_disc_dl_stp_id = :step_id;

Because the view is not a supported reporting interface, any integration or extract requirement should be implemented against the base table IGS_EN_DISC_DL_CONS joined directly to IGS_LOOKUPS_VIEW, rather than depending on this supplementary view, which may be redefined in a future release.