Search Results igs_ps_fac_ovr_wl




Overview
Explore in AI Chat

Overview

IGS_PS_FAC_OVR_WL is a table within the IGS – Student System (Obsolete) product family of Oracle E-Business Suite, documented for releases 12.1.1 and 12.2.2. The table stores assigned tasks for faculty, functioning as a record of faculty workload overrides. Its role in the E-Business Suite is to capture deviations or exceptions applied against standard faculty workload assignments, including the effective period of the override, the resulting new expected workload, and a coded reason for the change.

The ETRM metadata records that this object is not implemented in the source database from which the documentation was generated. This is significant: the table definition survives in the data model reference, but the object itself may not be physically instantiated in all environments. Any development or reporting effort against IGS_PS_FAC_OVR_WL should confirm physical existence in the target instance before proceeding.

The heuristic Data Vault classification mined from the foreign key structure is link. Treated as a modeling suggestion, this indicates that IGS_PS_FAC_OVR_WL primarily resolves relationships — specifically between a faculty workload record in IGS_PS_FAC_WL and an override reason in IGS_PS_WL_OVER_RESN — rather than acting as an independent hub of business entities or as a descriptive satellite.

Key Information Stored

The documented physical schema consists of 11 columns, owned by the IGS schema.

  • FAC_OVR_WL_ID — the surrogate primary key, enforced by the constraint IGS_PS_FAC_OVR_WL_PK and by the unique index IGS_PS_FAC_OVR_WL_U1. This is also the only documented business-key candidate, since the unique index covers the same single column.
  • FAC_WL_ID — foreign key to IGS_PS_FAC_WL, identifying the faculty workload assignment to which the override applies. This column supplies the primary link semantics of the table.
  • START_DATE and END_DATE — the effective date boundaries of the override, establishing the temporal validity of the exception.
  • NEW_EXP_WL — the new expected workload value resulting from the override; the operative business data element of the row.
  • OVERRIDE_REASON — foreign key to IGS_PS_WL_OVER_RESN, providing the coded justification for the override and forming the second reference relationship.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS audit columns recording who created and last modified the record and when.

Common Use Cases and Queries

Typical reporting scenarios include auditing faculty workload exceptions for an academic period, reconciling override reasons against institutional policy categories, and comparing overridden expected workloads with baseline assignments.

  • Listing active overrides for a faculty workload record:

    SELECT o.FAC_OVR_WL_ID, o.START_DATE, o.END_DATE, o.NEW_EXP_WL, o.OVERRIDE_REASON FROM IGS_PS_FAC_OVR_WL o WHERE o.FAC_WL_ID = :fac_wl_id AND TRUNC(SYSDATE) BETWEEN o.START_DATE AND NVL(o.END_DATE, TRUNC(SYSDATE));

  • Resolving the reason code to its description by joining to IGS_PS_WL_OVER_RESN on OVERRIDE_REASON.
  • Trend analysis of override frequency by reason, grouping on OVERRIDE_REASON and filtering CREATION_DATE to the reporting window.

Related Objects

  • IGS_PS_FAC_WL — parent faculty workload table; joined via IGS_PS_FAC_OVR_WL.FAC_WL_ID = IGS_PS_FAC_WL.FAC_WL_ID.
  • IGS_PS_WL_OVER_RESN — override reason reference table; joined via IGS_PS_FAC_OVR_WL.OVERRIDE_REASON = IGS_PS_WL_OVER_RESN.OVERRIDE_REASON.
  • IGS_PS_FAC_OVR_WL_PK — primary key constraint on FAC_OVR_WL_ID.
  • IGS_PS_FAC_OVR_WL_U1 — unique index on FAC_OVR_WL_ID, the documented business-key candidate.