Results for “weftsu_factor”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS.IGS_PS_UNT_INLV_HIST_ALL is a transactional history table within the Oracle E-Business Suite Student System (IGS) product family. It records the chronological evolution of a unit's internal program level, capturing the attribute values that applied during each valid time window for a given unit internal course level code. In Oracle EBS 12.1.1 and 12.2.2, this table supports date-tracked (temporal) reporting and audit requirements, enabling institutions to reconstruct the state of a unit's internal program level as of any past date rather than only its current configuration.

The object is documented with the status VALID and is owned by the IGS schema. Its role is essentially historical/satellite in nature: it preserves multiple time-delimited versions of descriptive and factor attributes keyed to a business identifier. The metadata classifies the structure heuristically as standalone within a Data Vault modeling view, meaning the mined foreign-key structure did not expose strict parent-child dependencies. In practice this suggests the table may be modeled as a satellite-like history store attached to the current unit internal level entity, though the documented Data Vault classification should be treated as a modeling suggestion rather than a physical constraint.

Key Information Stored

The table contains 13 documented columns in the 12.1.1 physical schema. The most significant are summarized below.

• UNIT_INT_COURSE_LEVEL_CD – The business identifier for the unit internal course level; part of the primary key and of the unique business-key index.
• HIST_START_DT – Effective start date of the historical record; the second component of the primary key.
• HIST_END_DT – Effective end date delimiting the validity window.
• HIST_WHO – Actor or process responsible for the historical change.
• DESCRIPTION – Descriptive text associated with the level record.
• WEFTSU_FACTOR – Weighted equivalent full-time student unit factor applying during the window.
• CLOSED_IND – Indicator of whether the level was closed during the historical period.
• ORG_ID – Operating unit / organization context for multi-org data.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS WHO columns providing audit lineage.

The surrogate/primary key is IGS_PS_UNT_INLV_HIST_PK, defined over (UNIT_INT_COURSE_LEVEL_CD, HIST_START_DT). A unique index, IGS_PS_UNT_INLV_HIST_ALL_U1, covers the same two columns and therefore represents the business-key candidate. Note that because the primary key is a composite business key rather than a generated numeric surrogate, uniqueness is enforced directly on the business and date attributes.

Common Use Cases and Queries

Typical scenarios include point-in-time reconstruction of unit internal program levels, audit reporting on who changed a level and when, and inclusion of historical WEFTSU factors in student load calculations for prior terms. A common query pattern filters by level code and a date of interest:

• Retrieve the version effective on a specific date: SELECT * FROM igs.igs_ps_unt_inlv_hist_all WHERE unit_int_course_level_cd = :cd AND :dt BETWEEN hist_start_dt AND NVL(hist_end_dt, :dt);
• Enumerate the full change history for a level: SELECT * FROM igs.igs_ps_unt_inlv_hist_all WHERE unit_int_course_level_cd = :cd ORDER BY hist_start_dt;
• Audit recent maintenance: filter on last_update_date and last_updated_by to trace changes made within a period.
• Extract WEFTSU factors as of a census date for load reporting.

Related Objects

The metadata reports the table as standalone, with no mined foreign-key parents or children. Nonetheless, it is logically associated with the current-level master entity via the shared business key. The most significant related objects are:

• IGS_PS_UNT_INLV_ALL – Current unit internal program level rows; join on UNIT_INT_COURSE_LEVEL_CD.
• IGS_PS_UNIT_INTLV – Underlying unit internal level definition.
• IGS_PS_UNT_INLV_HIST_ALL_U1 – Unique index enforcing the business key.
• IGS_PS_UNT_INLV_HIST_PK – Primary key constraint on the level code and start date.
• Student load and WEFTSU calculation views that resolve the effective factor by date.