Search Results igs_ps_fac_wl




Overview
Explore in AI Chat

Overview

IGS_PS_FAC_WL is a legacy Oracle E-Business Suite table belonging to the IGS (Student System) product family. The metadata classifies IGS as an obsolete module, and the table is explicitly documented as not implemented in the reference database. Its stated purpose is to store the workload for the faculty — that is, the allocation of teaching load assigned to an individual instructor within a specific academic calendar context.

Within the EBS data model, this object sits at the intersection of person identity and institutional calendar structures. It anchors faculty workload to a named party and to a calendar instance, and it serves as the parent for downstream assignment and override records. Based on the foreign-key topology, an entity-modeling heuristic would classify this table as satellite-leaning: it carries descriptive workload measures and attributes that hang off the person and calendar combination rather than acting as a pure hub or a pure associative link. The primary key IGS_PS_FAC_WL_PK, defined on FAC_WL_ID, provides the surrogate identifier, while the alternate unique key IGS_PS_FAC_WL_UK on PERSON_ID, CAL_TYPE, and CI_SEQUENCE_NUMBER establishes the natural business key.

Key Information Stored

The table is documented with 32 columns. The most consequential are:

  • FAC_WL_ID — surrogate primary key (IGS_PS_FAC_WL_PK and unique index IGS_PS_FAC_WL_U1) uniquely identifying each workload record.
  • PERSON_ID — foreign key to HZ_PARTIES, identifying the faculty member whose workload is recorded.
  • CAL_TYPE — foreign key to IGS_CA_INST_ALL, denoting the calendar type of the academic instance.
  • CI_SEQUENCE_NUMBER — the sequence identifier of the calendar instance, completing the reference to IGS_CA_INST_ALL.
  • CALENDAR_CAT — the calendar category, providing academic-context classification.
  • STD_EXP_WL — the standard expected workload value, the principal quantitative measure of the record.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20 — the standard EBS descriptive-flexfield block, allowing institution-specific extensions without schema change.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — audited WHO columns recording row provenance.

The unique index IGS_PS_FAC_WL_U2 on PERSON_ID, CAL_TYPE, and CI_SEQUENCE_NUMBER is the strongest business-key candidate, enforcing that a given person holds at most one workload record per calendar instance. The presence of both the surrogate and natural keys permits integration patterns that reference either identifier.

Common Use Cases and Queries

Reporting on this table typically falls into three categories: faculty loading analysis, calendar-based workload comparison, and reconciliation of assigned versus overridden workloads. A representative join retrieves workload alongside the calendar instance and the instructor's party record:

  • Faculty load analysis — joining IGS_PS_FAC_WL to HZ_PARTIES on PERSON_ID to obtain party naming and classification details for each workload row.
  • Calendar-scoped workload queries — joining IGS_PS_FAC_WL to IGS_CA_INST_ALL on CAL_TYPE and CI_SEQUENCE_NUMBER to roll up expected workload by calendar type and sequence.
  • Assignment and override reconciliation — driving from IGS_PS_FAC_WL to IGS_PS_FAC_ASG_TASK and IGS_PS_FAC_OVR_WL on FAC_WL_ID to compare standard expected workload against task-level assignments and approved overrides.
  • Standard WHO-based audit extracts — filtering on CREATION_DATE or LAST_UPDATE_DATE and the corresponding user columns for data-lineage reporting.

Because the table is documented as obsolete and not implemented in the reference database, these queries should be treated as migration or historical-archive patterns rather than supported production SQL in 12.1.1 or 12.2.2.

Related Objects

  • IGS_CA_INST_ALL — referenced via CAL_TYPE and CI_SEQUENCE_NUMBER; the authoritative calendar instance definition.
  • HZ_PARTIES — referenced via PERSON_ID; the TCA party record representing the faculty member.
  • IGS_PS_FAC_ASG_TASK — references IGS_PS_FAC_WL through FAC_WL_ID; stores the task-level workload assignments derived from the workload record.
  • IGS_PS_FAC_OVR_WL — references IGS_PS_FAC_WL through FAC_WL_ID; stores workload overrides applied against the base workload.
  • IGS_PS_FAC_WL_PK and IGS_PS_FAC_WL_UK / IGS_PS_FAC_WL_U1 / IGS_PS_FAC_WL_U2 — the primary and unique index definitions governing row identity and natural-key enforcement.