Search Results igs_en_nonstd_usec_dls

Overview

APPS.IGS_EN_DL_OFFSET_CONS_V is a supplementary database view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the APPS schema and registered under FND Design Data as IGS.IGS_EN_DL_OFFSET_CONS_V. It belongs to the Student Systems / Student Records product family within the IGS (Integrated Graduate System / Student Information) module set and is classified in ETRM documentation with a VALID status. The view is explicitly identified as a "supplementary view used to simplify forms coding," with the standard Oracle warning that direct querying or altering of its data is not recommended because its definition may change substantially across minor or major releases.

Functionally, the view consolidates offset constraint configuration data associated with non-standard unit section discontinuation deadlines in enrollment processing. It is intended primarily as a forms-coding convenience layer rather than as a supported public interface, meaning that customers and integrators should treat it as internal infrastructure rather than a stable reporting contract.

Underlying Base Objects

According to the documented dependency information, APPS.IGS_EN_DL_OFFSET_CONS_V references two base objects: IGS_EN_DL_OFFSET_CONS and IGS_LOOKUP_VALUES. The IGS_EN_DL_OFFSET_CONS table supplies the core offset constraint records, including the primary key column ENR_DL_OFFSET_CONS_ID and the foreign key NON_STD_USEC_DLS_ID, which links each constraint back to the IGS_EN_NONSTD_USEC_DLS entity referenced in the documentation. The IGS_LOOKUP_VALUES table provides the decoded meaning values for constraint types.

The view is described as "not referenced by any database object," confirming that it sits at the top of the dependency chain as a leaf view consumed only by forms or ad hoc queries. Although the documented referenced-base-object list is empty in the extracted 12.2.2 metadata, the ETRM view source and dependency section confirms the two tables above. The foreign key relationship to IGS_EN_NONSTD_USEC_DLS also connects the view conceptually to the related non-standard use case deadline setup objects the user searched for ("igs_en_nonstd_usec_dls").

Key Columns

• ROW_ID (ROWID): Row identifier for this view.
• ENR_DL_OFFSET_CONS_ID (NUMBER, 15): System-generated sequence number uniquely identifying the offset constraints for non-standard unit section discontinuation deadline setup.
• OFFSET_CONS_TYPE_CD (VARCHAR2, 30): Constraint type code.
• OFFSET_CONS_TYPE_MEANING (VARCHAR2, 80): Decoded constraint type meaning, derived via IGS_LOOKUP_VALUES.
• CONSTRAINT_CONDITION (VARCHAR2, 10): Constraint condition.
• CONSTRAINT_RESOLUTION (NUMBER): Constraint resolution.
• NON_STD_USEC_DLS_ID (NUMBER, 15): Foreign key to IGS_EN_NONSTD_USEC_DLS.
• DEADLINE_TYPE (VARCHAR2): Holds 'E' for enrollment deadline records or 'R' for retention deadline records.
• Standard WHO columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Because this is a forms-support view, the primary use case is Oracle Forms data retrieval for the offset constraint setup block. Reporting users may still query it read-only to audit how deadlines are configured for non-standard unit section discontinuation. A typical query joining back to the parent deadline setup is shown below:

SELECT v.ENR_DL_OFFSET_CONS_ID,
       v.OFFSET_CONS_TYPE_CD,
       v.OFFSET_CONS_TYPE_MEANING,
       v.CONSTRAINT_CONDITION,
       v.CONSTRAINT_RESOLUTION,
       v.DEADLINE_TYPE
FROM   APPS.IGS_EN_DL_OFFSET_CONS_V v
WHERE  v.NON_STD_USEC_DLS_ID = :p_dls_id
ORDER  BY v.DEADLINE_TYPE;

To isolate enrollment versus retention constraints, filter on DEADLINE_TYPE = 'E' or 'R'. The documentation cautions that the view may change dramatically in subsequent releases; therefore, any customization or extraction should be validated against the current release before production use.