Results for “hxt_work_shifts_fmv”

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

Overview

APPS.HXT_WORK_SHIFTS_FMV is a VALID Oracle E-Business Suite view belonging to the HXT (Time and Labor) product family. It is a "FMV" (Flexfield / Foreign-key Mapped View) style view that presents a denormalized, reporting-friendly projection of the HXT_WORK_SHIFTS table, joined to HR_LOOKUPS to translate the stored day-of-week lookup code into its human-readable meaning. The view resides in the APPS schema and is referenced in both Oracle EBS 12.1.1 and 12.2.2 environments, where it is typically consumed by Time and Labor setup, shift-differential, and shift-premium reporting or integration routines rather than by base application data entry forms.

The view's primary purpose is to expose shift-definition attributes — including shift identifier, work-pattern identifier, day of week, sequence, early-start and late-stop tolerances, and the key shift-related foreign keys OFF_SHIFT_PREM_ID and SHIFT_DIFF_OVRRD_ID — in a single queryable object. Because the day-of-week code is resolved to its lookup meaning inline, external reporting and interfaces can present shift schedules without re-implementing lookup joins.

Underlying Base Objects

The documented referenced base objects for the view are HR_LOOKUPS (VIEW), HXT_WORK_SHIFTS (SYNONYM), and HR_API (PACKAGE). The view text confirms the core join:

• HXT_WORK_SHIFTS HWS — the driving table supplying shift definition rows (aliased HWS).
• HR_LOOKUPS HRL — joined on HRL.LOOKUP_TYPE = 'HXT_DAY_OF_WEEK', HRL.LOOKUP_CODE = HWS.WEEK_DAY, and HRL.APPLICATION_ID = 808, resolving the day-of-week code to its MEANING.
• HR_API package — referenced for lookup/translation support.

Because the view joins HR_LOOKUPS with a fixed lookup type and application ID (808, the Time and Labor application), rows whose WEEK_DAY value lacks a matching lookup entry will be excluded by the inner join.

Key Columns

• ROW_ID — the HXT_WORK_SHIFTS ROWID, used as the surrogate row identifier.
• SHT_ID — shift identifier; the primary key of the underlying shift definition.
• TWS_ID — the associated work-shift / time-work schedule identifier linking the shift to a work pattern.
• WEEK_DAY — stored day-of-week lookup code (matched to HXT_DAY_OF_WEEK).
• MEANING — the translated, displayable day-of-week value from HR_LOOKUPS.
• SEQ_NO — sequence number ordering the shift within the schedule.
• EARLY_START / LATE_STOP — tolerance values for early clock-in and late clock-out.
• OFF_SHIFT_PREM_ID — foreign key to the off-shift premium definition applied to the shift; this is the column most directly associated with the user's search term.
• SHIFT_DIFF_OVRRD_ID — foreign key to a shift differential override record.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

The view is commonly queried to report shift schedules with resolved day names and to locate shifts tied to a specific off-shift premium or shift-differential override. A typical query follows:

SELECT hws.sht_id, hws.tws_id, hws.meaning, hws.seq_no, hws.off_shift_prem_id, hws.shift_diff_ovrrd_id FROM apps.hxt_work_shifts_fmv hws WHERE hws.off_shift_prem_id = :prem_id;

Because OFF_SHIFT_PREM_ID is exposed directly, the view is useful for reconciling premium eligibility against shift definitions, validating that every applicable shift references the correct premium, and feeding interfaces that must resolve day-of-week labels for timecard evaluation. When querying for the off-shift premium, callers should note the inner join to HR_LOOKUPS and ensure the lookup row exists for the shift's WEEK_DAY.