Search Results igs_en_disc_dl_cons_v

Overview

The view IGS_EN_DISC_DL_CONS_V belongs to the IGS – Student System product family within Oracle E-Business Suite, a module that is now designated as obsolete in the ETRM reference for releases 12.1.1 and 12.2.2. The view is described in the documentation as presenting all columns related to enrollment deadline date offset constraints. In practice, it exposes the configuration records that govern how offset constraint types influence the deadline dates associated with student enrollment discontinuation processing.

The view is primarily a reporting and integration construct. Rather than storing data itself, it joins the base constraint table to a lookup view so that each constraint row is presented alongside the human-readable meaning of its offset constraint type. This allows forms, reports, concurrent programs, and interface extracts to read constraint definitions without separately resolving lookup codes. It is important to note that the ETRM metadata states the object is "not implemented in this database," which indicates the view is documented but not deployed in every environment; consumers must verify its existence before referencing it.

Underlying Base Objects

According to the documented view text, IGS_EN_DISC_DL_CONS_V is defined over two objects:

• IGS_EN_DISC_DL_CONS (aliased as DDCV) — the base table holding enrollment deadline date offset constraint definitions, including the constraint condition, resolution, and associated non-standard deadline step.
• IGS_LOOKUPS_VIEW (aliased as LKV) — the lookup view used to translate LOOKUP_CODE into the descriptive MEANING.

The join is driven by two predicates: LKV.LOOKUP_CODE = DDCV.OFFSET_CONS_TYPE_CD and LKV.LOOKUP_TYPE = 'DT_OFFSET_CONSTRAINT_TYPE'. This restricts the lookup side to the offset constraint type lookup set, ensuring that only valid, meaningful offset constraint types are returned. The documented ETRM metadata lists no further referenced base objects, so the view's dependency footprint is limited to these two sources.

Key Columns

The view projects the following columns:

• ROW_ID — the row identifier derived from the base table's ROWID; not a true primary key but useful for row-level addressing.
• DISC_DL_CONS_ID — the unique identifier of the deadline constraint record.
• OFFSET_CONS_TYPE_CD — the coded offset constraint type, drawn directly from the base table.
• OFFSET_CONS_TYPE_MEANING — the decoded, user-facing meaning of the offset constraint type, sourced from the lookup view. This is the column most commonly targeted when users search for "offset_cons_type_meaning," as it provides the descriptive label required for reports and screens.
• CONSTRAINT_CONDITION — the condition under which the offset constraint applies.
• CONSTRAINT_RESOLUTION — the action or resolution applied when the constraint condition is met.
• NON_STD_DISC_DL_STP_ID — identifier linking the constraint to a non-standard discontinue deadline step.
• Audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage involves validating and reporting the offset constraint configuration governing enrollment deadline logic, and extracting the decoded meaning for downstream interfaces. A representative query returning the decoded constraint types is:

• SELECT offset_cons_type_cd, offset_cons_type_meaning, constraint_condition, constraint_resolution FROM igs_en_disc_dl_cons_v ORDER BY offset_cons_type_cd;
• SELECT disc_dl_cons_id, offset_cons_type_meaning FROM igs_en_disc_dl_cons_v WHERE offset_cons_type_cd = :p_type;

Because the view is documented as not implemented in the reference database, and because IGS is obsolete, these queries should be run only after confirming the object's presence in the target environment.