Extracting Data Through WFM Reports

SuitePeople Workforce Management (WFM) lets you extract different reports for your own purpose and records. To extract data, select from the seven report types and generate the report.

Maximum Report Duration

For most report types, you can generate reports for up to two months at a time.

Depending on the report, you may need to generate multiple reports if you need to export data for more than two months.

Refer to the following table for details and instructions for each report.

Shifts Reports

Refer to the table for reports about employee shifts. For more information, see Shifts Reports.

Report	Available Metrics	Help Topic with Instructions
Print Ready	Daily by Day Daily Master Daily Actual Timesheet Report Staff Report Timesheet Report Multi Unit Staff Report Master Report Actual Report	Print Ready
Hours	ID First name Last name Payroll ID Age Location Job Date Condition Rate Minimum hours top up Blended OT Leave metrics Total hours Total costs Phone Mobile Email Address metrics	Hours
Hours and Times	Various metrics based on the two report types: Actual Shifts Scheduled Shifts	Hours and Times
Approved Hours, Times And Stats	ID First Name Last Name Date Start Time Finish Time Hours Location Job Shift Metric Tips	Approved Hours, Times, and Stats
Variance (Tardy+)	Various metrics based on the four report types: Tardy Company time fraud Employee time fraud Custom (Advanced)	Variance (Tardy+)
Timesheet	Various metrics based on two report types: Hours summary Punch events	Timesheet
Overtime Checks	Available metrics are: Name Date Current employment Location name Job name Shift Times Employment Status Wage Agreement/ Classification Consecutive Day Count Shift Length Hours on day Average hours/week Clear break between shifts Allows for filtering and flagging based on: Consecutive Days Worked Hours on day worked Average weekly hours Clear break between days Time since last shift	Overtime Checks
Percent Approved	Location ID Location Name Week Start % Approved % Accepted Unapproved Approved Approvable Disputed Accepted Unaccepted Unapproved Staff Disputed Staff Unaccepted Staff	Percent Approved
Weekday Split	ID Staff member % Weekday Scheduled % Weekday Approved % Weekend Scheduled % Weekend Approved % Sat Scheduled % Sat Approved % Sun Scheduled % Sun Approved Hours Weekday Scheduled Hours Weekday Approved Hours Sat Scheduled Hours Sat Approved Hours Sun Scheduled Hours Sun Approved Hours Total Scheduled Hours Total Approved	Weekday Split
Allowances	ID First name Last name Export status	Allowances
Employee Payroll Query	Location Date Start time Finish time Length Status	Employee Payroll Query
Day Worked Frequency	Person ID First name Last name Employment status Wage type Calculation type Primary location name Weekday Total days Total hours Average day hours Start date Date of birth Classification ID Classification name Age Rate	Day Worked Frequency
Zero Hours	ID First name Last name Primary location Access group name Employment period start Employment period finish	Zero Hours
DST Ambiguous Shifts	If it is identified that there are shifts that occur over the 2-hour window, these shifts are considered ambiguous and will be available to download in a report that includes: Name Location Job Start Time Finish Time	DST Ambiguous Shifts
Punch Breaks	First name Preferred name Last name ID Employment status Date Start Finish Paid breaks Unpaid breaks Staff said they took paid break	Punch Breaks

Report

Available Metrics

Help Topic with Instructions

Print Ready

Daily by Day
Daily Master
Daily
Actual Timesheet Report
Staff Report
Timesheet Report
Multi Unit Staff Report
Master Report
Actual Report

Print Ready

Hours

ID
First name
Last name
Payroll ID
Age
Location
Job
Date
Condition
Rate
Minimum hours top up
Blended OT
Leave metrics
Total hours
Total costs
Phone
Mobile
Email
Address metrics

Hours

Hours and Times

Various metrics based on the two report types:

Actual Shifts
Scheduled Shifts

Hours and Times

Approved Hours, Times And Stats

ID
First Name
Last Name
Date
Start Time
Finish Time
Hours
Location
Job
Shift Metric
Tips

Approved Hours, Times, and Stats

Variance (Tardy+)

Various metrics based on the four report types:

Tardy
Company time fraud
Employee time fraud
Custom (Advanced)

Variance (Tardy+)

Timesheet

Various metrics based on two report types:

Hours summary
Punch events

Timesheet

Overtime Checks

Available metrics are:

Name
Date
Current employment
Location name
Job name
Shift Times
Employment Status
Wage Agreement/ Classification
Consecutive Day Count
Shift Length
Hours on day
Average hours/week
Clear break between shifts

Allows for filtering and flagging based on:

Consecutive Days Worked
Hours on day worked
Average weekly hours
Clear break between days
Time since last shift

Overtime Checks

Percent Approved

Location ID
Location Name
Week Start
% Approved
% Accepted
Unapproved
Approved
Approvable
Disputed
Accepted
Unaccepted
Unapproved Staff
Disputed Staff
Unaccepted Staff

Percent Approved

Weekday Split

ID
Staff member
% Weekday Scheduled
% Weekday Approved
% Weekend Scheduled
% Weekend Approved
% Sat Scheduled
% Sat Approved
% Sun Scheduled
% Sun Approved
Hours Weekday Scheduled
Hours Weekday Approved
Hours Sat Scheduled
Hours Sat Approved
Hours Sun Scheduled
Hours Sun Approved
Hours Total Scheduled
Hours Total Approved

Weekday Split

Allowances

ID
First name
Last name
Export status

Allowances

Employee Payroll Query

Location
Date
Start time
Finish time
Length
Status

Employee Payroll Query

Day Worked Frequency

Person ID
First name
Last name
Employment status
Wage type
Calculation type
Primary location name
Weekday
Total days
Total hours
Average day hours
Start date
Date of birth
Classification ID
Classification name
Age
Rate

Day Worked Frequency

Zero Hours

ID
First name
Last name
Primary location
Access group name
Employment period start
Employment period finish

Zero Hours

DST Ambiguous Shifts

If it is identified that there are shifts that occur over the 2-hour window, these shifts are considered ambiguous and will be available to download in a report that includes:

Name
Location
Job
Start Time
Finish Time

DST Ambiguous Shifts

Punch Breaks

First name
Preferred name
Last name
ID
Employment status
Date
Start
Finish
Paid breaks
Unpaid breaks
Staff said they took paid break

Punch Breaks

Employee Reports

Refer to the table for reports about employee metrics. For more information, see Employee Reports.

Report	Available Metrics	Help Topic with Instructions
All	ID First name Last name Preferred name Email Mobile Phone Dob Gender Street Postcode Suburb State Country Username Group Timesheet pin Primary location Employment date Termination date Wage calculation Employment status Payroll ID	All
Terminated	WFM ID Employee Start Finish Primary location Termination reason Updated by	Terminated
Wage Changes	Staff ID First name Last name Change type Age Date Base rate Wage type Classification name Termination date	Wage Changes
Birthdays	First name Last name Date of birth Age on birthday Primary location	Birthdays
Missing Details	Employee Primary location Personal details	Missing Details
Average Ages	First name Last name Date of birth Age State Job Location	Average Ages
Monthly Turnover	Location ID Location Name Metric Percentage Short Employment Percentage Terminated Total Short Employment	Monthly Turnover
Leave/Time-Off	Person Leave type Location Start and finish times Hours Reason	Leave/Time-Off
Work Permits	Content generated using the template provided by the Victorian State Government	Work Permits

Report

Available Metrics

Help Topic with Instructions

All

ID
First name
Last name
Preferred name
Email
Mobile
Phone
Dob
Gender
Street
Postcode
Suburb
State
Country
Username
Group
Timesheet pin
Primary location
Employment date
Termination date
Wage calculation
Employment status
Payroll ID

All

Terminated

WFM ID
Employee
Start
Finish
Primary location
Termination reason
Updated by

Terminated

Wage Changes

Staff ID
First name
Last name
Change type
Age
Date
Base rate
Wage type
Classification name
Termination date

Wage Changes

Birthdays

First name
Last name
Date of birth
Age on birthday
Primary location

Birthdays

Missing Details

Employee
Primary location
Personal details

Missing Details

Average Ages

First name
Last name
Date of birth
Age
State
Job
Location

Average Ages

Monthly Turnover

Location ID
Location Name
Metric
Percentage
Short Employment Percentage
Terminated
Total
Short Employment

Monthly Turnover

Leave/Time-Off

Person
Leave type
Location
Start and finish times
Hours
Reason

Leave/Time-Off

Work Permits

Content generated using the template provided by the Victorian State Government

Work Permits

Location Reports

Refer to the table for reports about location-specific metrics. For more information, see Location Reports.

Report	Available Metrics	Help Topic with Instructions
Location	Scheduled shifts Actual shifts Wages Hours Average hourly cost Labor cost % Sales Sales per man hour Units Productivity	Variance
Forecasting Analysis	Location Day Stats type (sales or units) Forecast Actual Mean Absolute Percentage Error (MAPE) Symmetric Mean Absolute Percentage Error (SMAPE)	Forecasting Analysis
Percent Hours Per Location	ID Person name Week	Percent Hours Per Location

Report

Available Metrics

Help Topic with Instructions

Location

Scheduled shifts
Actual shifts
Wages
Hours
Average hourly cost
Labor cost %
Sales
Sales per man hour
Units
Productivity

Variance

Forecasting Analysis

Location
Day
Stats type (sales or units)
Forecast
Actual
Mean Absolute Percentage Error (MAPE)
Symmetric Mean Absolute Percentage Error (SMAPE)

Forecasting Analysis

Percent Hours Per Location

ID
Person name
Week

Percent Hours Per Location

General Notices