Search Results new_exp_wl

Overview

APPS.IGS_PS_FAC_OVR_WL_V is a supplementary Oracle EBS view owned by the APPS schema, registered under FND Design Data as IGS.IGS_PS_FAC_OVR_WL_V, with a status of VALID. Within the Oracle Student System (formerly Student Records / Oracle iLearning-adjacent higher education modules), the IGS_PS_ prefix identifies objects in the Student Program / program-of-study functional area, and the FAC_OVR_WL suffix denotes "faculty override workload." The view presents override records that supersede a base expected faculty workload for a defined date range, together with the reason for the override.

The view type is explicitly documented as a supplementary view used to simplify forms coding. Oracle's own documentation carries a standing caution that the view is not recommended for direct querying or data alteration, because its definition may change dramatically in subsequent minor or major releases. Consequently it should be treated as a forms-support artifact rather than a published integration interface.

Underlying Base Objects

The view is defined over the base table IGS_PS_FAC_OVR_WL, which holds the override records, and it joins to IGS_PS_WL_OVER_RESN to resolve the override reason description. It exposes FAC_WL_ID as a foreign key to the parent table IGS_PS_FAC_WL, establishing the hierarchical relationship: a base faculty workload record (IGS_PS_FAC_WL) may have one or more override rows (IGS_PS_FAC_OVR_WL) that apply to specific periods.

The ETRM metadata records that APPS.IGS_PS_FAC_OVR_WL_V is not referenced by any database object, confirming it is a terminal, presentation-layer view. The documented 12.2.2 dependency metadata lists no referenced base objects, so the join logic above is inferred from the column semantics and the object naming convention rather than from an explicit dependency listing in the excerpt.

Key Columns

• ROW_ID (ROWID) — the physical row identifier of the underlying override record.
• FAC_OVR_WL_ID (NUMBER 15) — sequence-generated surrogate primary key for each override row.
• FAC_WL_ID (NUMBER 15) — foreign key to the parent table IGS_PS_FAC_WL, linking the override to its base workload record.
• START_DATE / END_DATE (DATE) — the inclusive period during which the override applies to the expected workload.
• NEW_EXP_WL (NUMBER) — the replacement expected workload value for the period bounded by START_DATE and END_DATE. This is the column returned when users search or report on "new_exp_wl," and it is the operative figure carried by the view.
• OVERRIDE_REASON (VARCHAR2 30) — the coded reason for superseding the base workload, resolved against IGS_PS_WL_OVER_RESN.
• REASON_DESCRIPTION (VARCHAR2 80) — the descriptive text for that reason, joined from the reason table.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Who columns providing audit traceability for the override record.

Common Use Cases and Queries

The principal practical use is reporting and validation of faculty workload overrides — for example confirming which staff have a reduced or increased expected workload for a given teaching period, and why. A representative query retrieving override detail by parent workload is:

SELECT fac_wl_id, start_date, end_date, new_exp_wl, override_reason, reason_description FROM apps.igs_ps_fac_ovr_wl_v WHERE fac_wl_id = :p_fac_wl_id;

To identify currently effective overrides, filter on the system date:

SELECT fac_ovr_wl_id, fac_wl_id, new_exp_wl FROM apps.igs_ps_fac_ovr_wl_v WHERE TRUNC(SYSDATE) BETWEEN start_date AND end_date;

Aggregate reporting across periods can sum the override value by reason code:

SELECT override_reason, COUNT(*), SUM(new_exp_wl) FROM apps.igs_ps_fac_ovr_wl_v GROUP BY override_reason;

Because the view is forms-oriented and unsupported for integration, any downstream extract, interface, or custom report should be validated against the base tables IGS_PS_FAC_OVR_WL and IGS_PS_WL_OVER_RESN, and re-verified following any EBS patch or upgrade between 12.1.1 and 12.2.2.