WFMStandard package

Abstracted model of the overall database that is presented in namespaces. Each namespace provides out-of-the-box relationships as defined by the schema. Most of the core standard and premium reports are developed using this package.

This topic describes the main categories in the WFMStandard package and lists the query subjects in each category.

See Query subjects.

Actual Results

Contains the historical data (for example, POS data), which is imported into the system and used by the forecast generation process. Includes these query subjects:

  • Actual Results
  • Forecast Driver
  • Location
  • Store
  • Team
  • Team (with optional Sub Teams)

Attendance Control

Tracks the events and violations of employee attendance. Includes these query subjects:

  • Department
  • Docket
  • Employee
  • Event Definition
  • Event Log p
  • Event Violation Log
  • Job
  • Project
  • Team
  • Team (with optional Sub Teams)
  • Violation Definition
  • Violation Log p
  • Work
  • Work Team

Auditing

Contains employee worked and scheduled override data.

Note: The Parsed Override Token query subject returns data from the WBI_OVERRIDE_VALUE table, which is a staging table that is populated by a pre-processing task.

This category includes these query subjects:

  • Employee
  • Employee History
  • Override
  • Override Base Token
  • Override Base Type
  • Override Type
  • Override Value
  • Parsed Override Token
  • Team
  • Team (with optional Sub Teams)
  • User

Availability

Contains the data from the availability management module, as extracted, transformed, and loaded by the Make Availability Reportable Job Scheduler task. Includes these query subjects:

  • Availability
  • Employee
  • Location
  • Store
  • Team
  • Team (with optional Sub Teams)

Employee Balances

Contains the balance information for employees. Includes these query subjects:

  • Balance
  • Balance Transactions
  • Balance Type
  • Duration Format
  • Employee

Employee Information

Contains employee information, including default labor settings and UDF data definitions.

Note: For performance purposes, you should avoid retrieving data from both the UDF Data folder and the Default Labor folder within the same tabular model.

This category includes these query subjects:

  • Application
  • Calc Group
  • Currency
  • Currency (User Locale)
  • Currency Conversion
  • Currency Conversion Group
  • Employee
  • Employee Badge
  • Employee Job
  • Employee Skill
  • Employment Type
  • Employee Work Type
  • Group
  • Location
  • Pay Group
  • Shift Pattern
  • Store
  • Team
  • Team (with optional Sub Teams)
  • User

The Default Labor subcategory includes these query subjects:

  • Department
  • Docket Activities
  • Employee Default Labor
  • Job
  • Project
  • Docket

The UDF Data subcategory includes these query subjects:

  • Employee UDF Data

Historical Payroll Cost

Contains the historical payroll cost data that is imported into the system. Includes these query subjects:

  • Employee
  • Historical Payroll Cost
  • Location
  • Store
  • Team
  • Team (with optional Sub Teams)

Leave Management Policies

Contains the policies, entitlements, and details for employees. Includes these query subjects:

  • Employee
  • Entitlement
  • Entitlement Details
  • Policy

Overtime Equalization

Contains the offers, responses, and employee points that are managed by the Overtime Equalization module. Includes these query subjects:

  • Employee
  • OTE Employee Points
  • OTE Group
  • OTE Offers
  • OTE Responses

RTSS

Contains the processes, rules, and violations that the Real Time Self Scheduler module logs. Includes these query subjects:

  • Employee
  • RTSS Process
  • RTSS Process Status
  • RTSS Rule
  • RTSS Rule Enforcement Level
  • RTSS Rule Error Log
  • Team

Scheduling

Contains information about schedule shift details, generated schedules, score and cost, schedule compliance configuration, shift and shift pattern definitions, violations, and output of the forecast generation process. In addition, contains data that is added to the system regarding location property data, workload definitions, planned workload, planned volume, and budgeted payroll cost. In addition, contains information regarding staffing interval requirements for stores and departments that are associated to schedules.

This category includes these query subjects:

  • Activity
  • Availability
  • Compliance Group Rules
  • Compliance Violations
  • Department
  • Docket
  • Employee
  • Employee Schedule Settings
  • Forecast Driver
  • Forecasts
  • Hour Type
  • Job
  • Job Rate
  • Location
  • Location Properties
  • Location Property Workload
  • Project
  • Schedule
  • Schedule Budget
  • Schedule Cost
  • Schedule Cost Detail
  • Shift
  • Shift Group
  • Shift Pattern
  • Skill
  • Staffing Definition
  • Staffing Requirement (SO)
  • Store
  • Team
  • Team (with optional Sub Teams)
  • Team Schedule Periods
  • Time Code
  • Volume Workload

Scheduling MVS > Call List

Contains Relief Call List information, including call list member employees and teams that can access the call lists. Includes these query subjects:

  • Associated Parent Job
  • Call List
  • Call List Employees
  • Call List Teams
  • Employee
  • Job
  • Shift Type
  • Team

Scheduling MVS > Production Plans

Contains production plans. Includes these query subjects:

  • Production Plan
  • Production Plan Status
  • Production Plan Shift
  • Machine
  • Product

Scheduling MVS > Rotations

Contains master rotations, one-time schedule templates, and one-time schedule information, including labor metrics, shift patterns, employee assignments, and compliance violations related to the master rotation rows.

This category includes these query subjects:

  • Row Shift
  • Rotation
  • Rotation Row
  • Rotation Team
  • Rotation Type
  • Rotation Row Status
  • Rotation Version

The Rotation Public Tasks subcategory includes these query subjects:

  • Rotation Public Task
  • User
  • Actual User

The Rotation Row Assignments subcategory includes these query subjects:

  • Rotation Row Assignment
  • Activity
  • Employee

The Rotation Row Conflicts subcategory includes these query subjects:

  • Rotation Row Conflict
  • Activity
  • Employee

The Row Labor Metrics subcategory includes these query subjects:

  • Associated Parent Job
  • Calc Group
  • Compliance Group
  • Department
  • Docket
  • Job
  • Project
  • Row Labor Metric

Scheduling MVS > Schedule Templates

Contains staffing requirement template and shift template information.

This category includes these query subjects:

  • Parent Staffing Requirement Template
  • Schedule Template
  • Team
  • Template Schedule
  • Template Type
  • Workload Type

The Production Template subcategory includes these query subjects:

  • Machine
  • Product
  • Production Machine Template

The Shift Requirement Template subcategory includes these query subjects:

  • Associated Parent Job
  • Day Part
  • Job
  • Shift Requirement Skills
  • Shift Requirements
  • Shifts
  • Skills

The Staffing Requirement Template subcategory includes these query subjects:

  • Associated Parent Job
  • Day Part
  • Job
  • Skills
  • Staffing Requirement Day
  • Staffing Requirement Skill
  • Staffing Requirement Skill Day
  • Staffing Requirements

Scheduling MVS > Scheduled Shifts

Contains all scheduled shift information in MVS, including assigned shifts, unassigned shifts, booked-off shifts, and relief shifts. For relief shifts, all call log information is included. Information related to unassigned shifts that have been offered via Mobile Shift Offer is also included.

This category includes these query subjects:

  • Leave Reason
  • Relief Block
  • Relief Block Employee
  • Shift Detail Activity
  • Shift Detail Department
  • Shift Detail Docket
  • Shift Detail Job
  • Shift Detail Associated Parent Job
  • Shift Detail
  • Shift Detail Layer Type
  • Shift Detail Project
  • Shift Link
  • Shift Status
  • Shift Status Color
  • Shift Summary
  • Shift Summary Comment
  • Shift Summary Employee
  • Shift Summary Employee Team
  • Shift Summary Shift Link
  • Shift Summary Shift Skills
  • Shift Summary Skill
  • Shift Team
  • Shift Team (with optional Sub Teams)
  • Shift Type
  • Team Schedule Periods

The Scheduled Detail subcategory includes these query subjects:

  • Associated Parent Job
  • Employee Scheduled Detail
  • Employee Scheduled Detail Job
  • Employee Scheduled Detail Activity

The Call Logs subcategory includes these query subjects:

  • Call Log
  • Reason
  • Employee
  • Actual User
  • User

The Shift Offers subcategory includes these query subjects:

  • Shift Offer
  • Shift Offer Shift Summary
  • Shift Offer Employee Shift
  • Actual User
  • User

Scheduling MVS > Shift Definition

Contains information about shift definitions in MVS. Includes these query subjects:

  • Activity
  • Shift
  • Shift Activity
  • Shift Day Part
  • Shift Label Color
  • Shift Property
  • Shift Team
  • Shift Team (with optional Sub Teams)
  • Shift Type
  • Teams with Inherited Shifts

Scheduling MVS > Shift Preferences

Contains information about employees' shift preferences, by team, shift type, and day part. Audit history on employee shift preference updates is also included.

The Shift Preference subcategory includes these query subjects:

  • Day of Week
  • Day Part
  • Employee
  • Shift Preference Detail
  • Shift Preference Input Type
  • Shift Preference Summary
  • Shift Preference Type
  • Shift Type
  • Team
  • User (Actual Approver)
  • User (Actual Submitter)
  • User (Approver)
  • User (Submitter)

The Shift Preference History subcategory includes these query subjects:

  • Day of Week
  • Day Part
  • Employee
  • Shift Preference Detail (History)
  • Shift Preference Input Type
  • Shift Preference Summary (History)
  • Shift Preference Type
  • Shift Type
  • Team
  • User (Actual Approver)
  • User (Actual Submitter)
  • User (Approver)
  • User (Submitter)

Scheduling MVS > Team Schedule Period

Contains information about each team's schedule period definition. Includes these query subjects:

  • Schedule Period Definition
  • Team
  • Team (with optional Sub Teams)
  • Team Schedule Period

Scheduling MVS > Workload

Contains each team's workload information stored in minutes, by job and day part. Census information imported from Infor Care Workload is also included in this namespace.

The Workload Requirement subcategory includes these query subjects:

  • Day Part
  • Team
  • Workload Census

The Workload Census subcategory includes these query subjects:

  • Associated Parent Job
  • Day Part
  • Job
  • Team
  • Workload Requirement
  • Workload Source

The Budgeted Hours Per Patient Day subcategory includes these query subjects:

  • Budgeted HPPD
  • Team

Time and Attendance

This category includes these query subjects:

  • Approval State
  • Approval Status
  • Bad Reason
  • Calc Group
  • Currency
  • Currency (User Locale)
  • Currency Conversion Group
  • Currency Conversion (Work Day)
  • Currency Conversion (Work Adjustments)
  • Department
  • Docket
  • Docket Activities
  • Employee
  • Employee Approval
  • Employee Approval Error
  • Employee Schedule
  • Facility
  • Hour Type
  • Job
  • Location
  • Pay Group
  • Project
  • Shift
  • Shift Pattern
  • Shift Pattern Shifts
  • Store
  • Team
  • Team (with optional Sub Teams)
  • Time Code
  • Time Code Controllable
  • Time Code Uncontrollable
  • Work
  • Work Adjustments
  • Work Adjustments (Retro)
  • Work Day
  • Work Day with Clock Data
  • Work Team

Work

All time tracking information, including retroactively adjusted data, work summary data accompanied with processed clock punches, and employee time approval records. Includes these query subjects:

  • Approval State
  • Approval Status
  • Bad Reason
  • Calc Group
  • Currency
  • Currency (User Locale)
  • Currency Conversion Group
  • Currency Conversion (Work Day)
  • Currency Conversion (Work Adjustments)
  • Department
  • Docket
  • Docket Activities
  • Employee
  • Employee Approval
  • Employee Approval Error
  • Employee Schedule
  • Facility
  • Hour Type
  • Job
  • Location
  • Pay Group
  • Project
  • Scheduled Shift
  • Shift
  • Shift Pattern
  • Shift Pattern Shifts
  • Store
  • Team
  • Team (with optional Sub Teams)
  • Time Code
  • Time Code Controllable
  • Time Code Uncontrollable
  • Work
  • Work Adjustments
  • Work Adjustments (Retro)
  • Work Day
  • Work Day with Clock Data

Report Helper Objects

See Report helper objects.