Welcome to the Deputy Analytics Data Dictionary. This resource is designed for System Administrators and users who build custom reports in Analytics+.

Here, you'll find an outline of the available data points in Deputy Analytics datasets, plus additional notes to help you select the right data for your custom reports.

Deputy Analytics Datasets (S - Z)

Below is a list of all Analytics Datasets (S -Z), in alphabetical order. Click any dataset title to view the data points it includes.

Tip: Looking for a specific data point? Use your browser’s search function by pressing Ctrl + F (PC) or Cmd + F (Mac).

Shift audit
Shifts
Shifts & timesheets
Shifts, timesheets & sales
Tasks
Timesheet audit
Timesheet geolocation audit
Timesheet geolocation map
Timesheet pay
Timesheets
Training modules
Training records

Go to → [ Data Dictionary Overview ] [ Glossary of Terms ] [ Datasets (A - R) ] [ Datasets S - Z ]

Shift audit

Column Name in Analytics	Notes
Shift ID
Modified field
Modified date
Modified by ID
Modified by session data	Technical session details captured when this record was modified.
Shift cost
Shift comment
Shift created date
Shift created by ID
Shift warnings	Shows any issues or rule conflicts detected for this planned shift.
Employee ID
Shift modified date
Shift group ID	Internal ID that identifies the group this shift belongs to, if grouped.
Shift confirmed by ID
Shift total time
Shift confirmation date
Shift template ID
Shift swap approved by ID
Shift confirmation comment
Shift area ID
Timesheet ID
Shift warning override comment
Shift date
Shift total mealbreak time
Shift is open
Shift is published	Indicates whether the shift has been published to the assigned employee.
Shift is approval required	Indicates whether this open shift requires manager approval when employees apply.
Employee mealbreak in minutes
Shift location ID
Shift work type	Shows the type of work assigned to this shift, such as standard or special.
Shift area payroll export name	Area name formatted to match your payroll system configuration.
Shift area name
Shift parent area ID
Shift location code
Shift location name
Shift location company number	Shows the company number recorded for the shift location.
Shift location parent ID
Shift location business number	Shows the business number recorded for the shift location.
Shift location payroll export code	The code used to map this location to your payroll system.
Shift area status	Shows the current shift area status: Active or Inactive.
Shift location status	Shows the current shift location status: Active or Archived.
Shift area name with location code
Employee access level ID	Internal ID that identifies the employee’s access level or role.
Employee primary location ID
Employee contact details ID
Employee created date
Employee created by ID
Employee user ID
Employee last modified date
Employee job position
Employee last name
Employee first name
Employee job application ID	Links the employee to their original job application in Deputy Hire.
Employee preferred name
Employee main address ID
Employee onboarding ID
Employee stress profile ID	Internal ID that identifies the stress profile applied to this employee.
Employee hire date
Employee archived date
Employee access level name	Shows the employee’s access level or role in the system.
Employee primary location code
Employee primary location name
Employee primary location company number	Shows the company number recorded for the employee’s primary location.
Employee primary location parent ID	Internal ID that identifies the parent location for the employee’s primary location.
Employee primary location business number	Shows the business number recorded for the employee’s primary location.
Employee primary location payroll export code	The code used to map the primary location to your payroll system.
Employee contact email
Employee stress profile name	Shows the name of the stress profile applied to this employee.
Employee stress profile max hours per day	Shows the maximum hours the employee can work in a single day under the stress profile.
Employee stress profile max days per period	Shows the maximum number of days the employee can work in the stress profile period.
Employee stress profile max hours per shift	Shows the maximum hours allowed for a single shift under the stress profile.
Employee stress profile max hours per period	Shows the maximum hours the employee can work in the stress profile period.
Employee stress profile gap hours between shifts	Shows the minimum required rest time between the employee’s shifts under their stress profile.
Employee status	Shows the current employee status: Active or Archived.
Employee gender
Employee pronouns
Employee full name
Employee contact mobile
Employee date of birth
Employee main address
Employee active payroll IDs	Lists the payroll IDs currently active for this employee.
Employee main address state
Employee main address country
Employee custom fields	Shows values stored in the employee’s custom fields.
Shift employee location status	Shows the current employee location status: Active or Archived.
Shift end time
Shift start time
Shift custom fields	Shows values stored in the shift’s custom fields.
Shift location timezone
Employee primary location timezone
Timesheet cost
Timesheet created date
Timesheet created by ID
Leave request ID
Timesheet last modified date
Timesheet group ID
Timesheet leave type ID	Internal ID that identifies the leave type linked to this timesheet.
Timesheet paid record ID	Internal ID that identifies the batch record that groups timesheets marked as paid.
Timesheet total time
Pay period ID	Internal ID that identifies the pay period schedule linked to this contract.
Timesheet time approved by ID
Timesheet employee comment
Employee history ID	Internal ID that identifies the employee’s history record used on timesheets.
Timesheet area ID
Pay detail ID
Timesheet last paid status change date	Shows when the timesheet was last changed to paid or unpaid.
Timesheet last accrued date	Shows when the leave accrual linked to this timesheet was last updated.
Timesheet date
Timesheet total mealbreak time
Timesheet is leave
Timesheet submitted in real time	Indicates whether the timesheet was clocked rather than manually submitted after the shift.
Timesheet rounded	Indicates whether times on this timesheet were adjusted by rounding rules.
Timesheet auto processed	Indicates whether the timesheet was automatically processed based on location settings.
Timesheet auto time approved	Indicates whether times were automatically approved based on location settings.
Timesheet auto pay approved	Indicates whether pay was automatically approved based on location settings.
Timesheet mealbreak in minutes
Timesheet employee location status	Shows the current timesheet employee location status: Active or Archived.
Employee pay detail created date
Employee pay detail created by id
Employee pay rate id	Internal ID that identifies the pay rate or employment term for this employee.
Employee pay detail last modified date
Employee pay centre id	Internal ID that identifies the pay centre linked to this employee’s agreement.
Employee pay calendar id
Employee pay period id	Internal ID that identifies the pay period associated with this contract.
Employee payroll id	Internal ID that identifies this employee in your payroll system.
Employee employee id
Employee salary pay rule id	Internal ID that identifies the salary pay rule used for this employee.
Employee classification id
Employee pay rate name
Employee pay rate created date
Employee pay rate created by id
Employee pay rate last modified date
Employee pay rate employment type id	Internal ID that identifies the employment type linked to this pay rate.
Standard hours
Employee pay period name
Employee pay period length id	Internal ID that identifies the pay period frequency, such as weekly or monthly.
Employee pay period created date
Employee pay period created by id
Employee pay period last modified date
Employee pay period start date
Employee salary pay rule name	Shows the name of the salary pay rule applied to this employee.
Employee annual salary
Employee salary pay rule export code	The code used to map the salary pay rule to your payroll system.
Employee pay calendar name
Employee pay calendar payment frequency
Employee pay calendar business number
Employee pay calendar created by id
Employee pay calendar created date
Employee pay calendar last modified date
Employee pay calendar start date
Employee pay calendar payment date
Employee regular rate name	Shows the name of the employee’s regular pay rate.
Employee regular rate export code	The code used to map the employee’s regular rate to your payroll system.
Employee pay rate regular rate	Shows the base pay rate used for this employee’s regular hours.
Employee pay detail locations	Lists the locations covered by this employee’s pay agreement.
Employee pay rate employment type	Shows the employment type linked to this pay rate, such as full‑time.
Employee pay period length name	Shows the frequency of the pay period, such as weekly or monthly.
Employee pay detail status
Employee salary pay rule is exported	Indicates whether the salary pay rule is sent to payroll.
Employee regular rate is exported	Indicates whether the employee’s regular rate is sent to payroll.
Employee area regular rate
Timesheet area payroll export name	Area name formatted to match your payroll system configuration.
Timesheet area name
Timesheet parent area ID
Timesheet area status	Shows the current timesheet area status: Active or Inactive.
Area is deleted
Location is deleted
Timesheet area name with location code	Shows the area name combined with its location code.
Timesheet leave policy name
Timesheet leave policy type
Timesheet leave policy unit	Shows whether the leave is tracked in hours or days.
Timesheet leave policy accrual reset period	Shows how often leave accrual for this policy is reset.
Timesheet leave policy description	Short description of the leave policy applied to this timesheet.
Timesheet leave policy export type	Shows how this leave policy is exported to your payroll system.
Timesheet leave policy reset value	Shows the balance value applied when this leave policy resets.
Timesheet leave policy reset schedule	Shows when this leave policy balance is scheduled to reset.
Timesheet leave policy export code	The code used to map this leave policy to your payroll system.
Timesheet leave policy is visible	Indicates whether this leave policy is visible to employees.
Timesheet leave policy is paid	Indicates whether this leave policy results in paid or unpaid leave.
Timesheet leave policy rolls over	Indicates whether unused leave carries over to the next year.
Leave pay approver full name
Leave time approver full name
Leave creator full name
Timesheet paid record created date
Timesheet paid record created by ID
Timesheet paid date
Timesheet photo taken	Indicates whether a photo was captured with this timesheet.
Timesheet end time
Timesheet start time
Timesheet issue ID
Timesheet issue type
Timesheet leave request end time
Timesheet leave request start time
Timesheet custom fields	Shows values stored in the timesheet’s custom fields.
Timesheet location timezone
Employee location timezone
Time approver full name
Time creator full name
Timesheet location ID
Timesheet location code
Timesheet location name
Timesheet location company number	Shows the company number recorded for this timesheet’s location.
Timesheet location parent ID
Timesheet location business number	Shows the business number recorded for this timesheet’s location.
Timesheet location payroll export code	The code used to map this location to your payroll system.
Timesheet location status	Shows the current timesheet location status: Active or Archived.
Timesheet status	Shows the current timesheet status: Upcoming, On shift, Absent, Late, Pending, Time approved, Pay approved, Discarded, Exported, or Paid.
Shift swap status	Shows the current shift swap status: Not required, Swap sent, Swap received, Swap sent and received, Pending approval, Approved, Cancelled, or Declined.
Shift confirmation status	Shows the current shift confirmation status: Not required, Requires confirmation, Confirmed, or Declined.
Modified by name
Modified by email
Old value
New value
Roster is deleted

Return to top ^

Shifts

Column Name in Analytics	Notes
Shift ID
Shift note
Shift created date
Shift created by ID
Shift cost
Shift warnings	Shows any issues or rule conflicts detected for this planned shift.
Employee ID
Shift modified date
Shift group ID	Internal ID that identifies the group this shift belongs to, if grouped.
Shift confirmed by ID
Shift total time
Shift confirmation date
Shift template ID
Shift swap approved by ID
Shift confirmation comment
Shift area ID
Timesheet ID

Shift date
Shift is open
Shift is published	Indicates whether the shift has been published to the assigned employee.
Shift is approval required	Indicates whether this open shift requires manager approval when employees apply.
Shift total mealbreak time
Shift location ID
Shift area payroll export name	Area name formatted to match your payroll system configuration.
Shift area name
Shift parent area ID
Shift location code
Shift location name
Shift location company number	Shows the company number recorded for the shift location.
Shift location parent ID
Shift location business number	Shows the business number recorded for the shift location.
Shift location payroll export code	The code used to map this location to your payroll system.
Shift location hierarchy	Shows where this location sits in your business location hierarchy.
Shift area status	Shows the current shift area status: Active or Inactive.
Area is deleted
Shift location status	Shows the current shift location status: Active or Archived.
Location is deleted
Shift area name with location code
Employee access level ID	Internal ID that identifies the employee’s access level or role.
Employee primary location ID
Employee contact details ID
Employee created date
Employee created by ID
Employee user ID
Employee last modified date
Employee job position
Employee last name
Employee first name
Employee job application ID	Links the employee to their original job application in Deputy Hire.
Employee preferred name
Employee main address ID
Employee onboarding ID
Employee stress profile ID	Internal ID that identifies the stress profile applied to this employee.
Employee hire date
Employee archived date
Employee access level name	Shows the employee’s access level or role in the system.
Employee primary location code
Employee primary location name
Employee primary location company number	Shows the company number recorded for the employee’s primary location.
Employee primary location parent ID	Internal ID that identifies the parent location for the employee’s primary location.
Employee primary location business number	Shows the business number recorded for the employee’s primary location.
Employee primary location payroll export code	The code used to map the primary location to your payroll system.
Employee contact email
Employee stress profile name	Shows the name of the stress profile applied to this employee.
Employee stress profile max hours per day	Shows the maximum hours the employee can work in a single day under the stress profile.
Employee stress profile max days per period	Shows the maximum number of days the employee can work in the stress profile period.
Employee stress profile max hours per shift	Shows the maximum hours allowed for a single shift under the stress profile.
Employee stress profile max hours per period	Shows the maximum hours the employee can work in the stress profile period.
Employee stress profile gap hours between shifts	Shows the minimum required rest time between the employee’s shifts under their stress profile.
Employee address city
Employee address po box
Employee address street 1
Employee address street 2
Employee address unit no
Employee address postcode
Employee address suite no
Employee address street no
Employee status	Shows the current employee status: Active or Archived.
Employee gender
Employee pronouns
Employee full name
Employee contact mobile
Employee date of birth
Employee main address
Employee active payroll IDs	Lists the payroll IDs currently active for this employee.
Employee main address state
Employee main address country
Employee custom fields	Shows values stored in the employee’s custom fields.
Shift end time
Shift start time
Shift custom fields	Shows values stored in the shift’s custom fields.
Shift location timezone
Employee primary location timezone
Timesheet cost
Timesheet created date
Timesheet created by ID
Leave request ID
Timesheet last modified date
Timesheet group ID
Timesheet leave type ID	Internal ID that identifies the leave type linked to this timesheet.
Timesheet paid record ID	Internal ID that identifies the batch record that groups timesheets marked as paid.
Timesheet total time
Pay period ID	Internal ID that identifies the pay period schedule linked to this contract.
Timesheet time approved by ID
Timesheet employee comment
Employee history ID	Internal ID that identifies the employee’s history record used on timesheets.
Timesheet area ID
Pay detail ID
Timesheet last paid status change date	Shows when the timesheet was last changed to paid or unpaid.
Timesheet last accrued date	Shows when the leave accrual linked to this timesheet was last updated.
Timesheet date
Timesheet is leave
Timesheet submitted in real time	Indicates whether the timesheet was clocked rather than manually submitted after the shift.
Timesheet rounded	Indicates whether times on this timesheet were adjusted by rounding rules.
Timesheet auto processed	Indicates whether the timesheet was automatically processed based on location settings.
Timesheet auto time approved	Indicates whether times were automatically approved based on location settings.
Timesheet auto pay approved	Indicates whether pay was automatically approved based on location settings.
Timesheet total mealbreak time
Employee pay detail created date
Employee pay detail created by id
Employee pay rate id	Internal ID that identifies the pay rate or employment term for this employee.
Employee pay detail last modified date
Employee pay centre id	Internal ID that identifies the pay centre linked to this employee’s agreement.
Employee pay calendar id
Employee pay period id	Internal ID that identifies the pay period associated with this contract.
Employee payroll id	Internal ID that identifies this employee in your payroll system.
Employee salary pay rule id	Internal ID that identifies the salary pay rule used for this employee.
Employee classification id
Employee pay rate name
Employee pay rate created date
Employee pay rate created by id
Employee pay rate last modified date
Employee pay rate employment type id	Internal ID that identifies the employment type linked to this pay rate.
Employee standard hours
Employee pay period name
Employee pay period length id	Internal ID that identifies the pay period frequency, such as weekly or monthly.
Employee pay period created date
Employee pay period created by id
Employee pay period last modified date
Employee pay period start date
Employee salary pay rule name	Shows the name of the salary pay rule applied to this employee.
Employee annual salary
Employee salary pay rule export code	The code used to map the salary pay rule to your payroll system.
Employee pay calendar name
Employee pay calendar payment frequency
Employee pay calendar business number
Employee pay calendar created by id
Employee pay calendar created date
Employee pay calendar last modified date
Employee pay calendar start date
Employee pay calendar payment date
Employee regular rate name	Shows the name of the employee’s regular pay rate.
Employee regular rate export code	The code used to map the employee’s regular rate to your payroll system.
Employee pay rate regular rate	Shows the base pay rate used for this employee’s regular hours.
Employee pay detail locations	Lists the locations covered by this employee’s pay agreement.
Employee pay rate employment type	Shows the employment type linked to this pay rate, such as full‑time.
Employee pay period length name	Shows the frequency of the pay period, such as weekly or monthly.
Employee pay detail status
Employee salary pay rule is exported	Indicates whether the salary pay rule is sent to payroll.
Employee regular rate is exported	Indicates whether the employee’s regular rate is sent to payroll.
Employee area regular rate
Timesheet area payroll export name	Area name formatted to match your payroll system configuration.
Timesheet area name
Timesheet parent area ID
Timesheet area status	Shows the current timesheet area status: Active or Inactive.
Timesheet area name with location code	Shows the area name combined with its location code.
Timesheet leave policy name
Timesheet leave policy type
Timesheet leave policy unit	Shows whether the leave is tracked in hours or days.
Timesheet leave policy accrual reset period	Shows how often leave accrual for this policy is reset.
Timesheet leave policy description	Short description of the leave policy applied to this timesheet.
Timesheet leave policy export type	Shows how this leave policy is exported to your payroll system.
Timesheet leave policy reset value	Shows the balance value applied when this leave policy resets.
Timesheet leave policy reset schedule	Shows when this leave policy balance is scheduled to reset.
Timesheet leave policy export code	The code used to map this leave policy to your payroll system.
Timesheet leave policy is visible	Indicates whether this leave policy is visible to employees.
Timesheet leave policy is paid	Indicates whether this leave policy results in paid or unpaid leave.
Timesheet leave policy rolls over	Indicates whether unused leave carries over to the next year.
Timesheet paid record created date
Timesheet paid record created by ID
Timesheet paid date
Timesheet photo taken	Indicates whether a photo was captured with this timesheet.
Timesheet end time
Timesheet start time
Timesheet issue ID
Timesheet issue type
Timesheet leave request end time
Timesheet leave request start time
Timesheet custom fields	Shows values stored in the timesheet’s custom fields.
Timesheet location timezone
Employee location timezone
Timesheet location ID
Timesheet location code
Timesheet location name
Timesheet location company number	Shows the company number recorded for this timesheet’s location.
Timesheet location parent ID
Timesheet location business number	Shows the business number recorded for this timesheet’s location.
Timesheet location payroll export code	The code used to map this location to your payroll system.
Timesheet location status	Shows the current timesheet location status: Active or Archived.
Timesheet status	Shows the current timesheet status: Upcoming, On shift, Absent, Late, Pending, Time approved, Pay approved, Discarded, Exported, or Paid.
Shift swap status	Shows the current shift swap status: Not required, Swap sent, Swap received, Swap sent and received, Pending approval, Approved, Cancelled, or Declined.
Shift confirmation status	Shows the current shift confirmation status: Not required, Requires confirmation, Confirmed, or Declined.
Shift is empty
Timesheet total rest break time	Shows total rest break time recorded on this timesheet, in minutes.
Timesheet meal break times	Meal breaks taken at specific start and end times.
Timesheet meal break durations	Meal breaks added as a duration only, without specific start and end times.
Timesheet rest break times	Rest breaks recorded with specific start and end times.
Timesheet rest break durations	Rest breaks recorded as a duration only, without specific start and end times.
Shift total rest break time	Shows the total planned rest break time for the shift in minutes.
Shift meal break times	Meal breaks scheduled at specific start and end times.
Shift meal break durations	Meal breaks scheduled as a duration only, without specific start and end times.
Shift rest break times	Rest breaks scheduled at specific start and end times.
Shift rest break durations	Rest breaks scheduled as a duration only, without specific start and end times.
Timesheet pay period start date
Timesheet pay period end date

Return to top ^

Shifts & timesheets

Column Name in Analytics	Notes
Timesheet ID
Shift ID
Employee ID
Timesheet cost
Timesheet date
Timesheet total time
Timesheet created date
Timesheet last modified date
Timesheet created by ID
Timesheet area ID
Employee history ID	Internal ID that identifies the employee’s history record used on timesheets.
Timesheet is leave
Timesheet submitted in real time	Indicates whether the timesheet was clocked rather than manually submitted after the shift.
Timesheet rounded	Indicates whether times on this timesheet were adjusted by rounding rules.
Timesheet auto processed	Indicates whether the timesheet was automatically processed based on location settings.
Timesheet auto time approved	Indicates whether times were automatically approved based on location settings.
Timesheet auto pay approved	Indicates whether pay was automatically approved based on location settings.
Timesheet total mealbreak time
Timesheet total rest break time	Shows total rest break time recorded on this timesheet, in minutes.
Timesheet employee comment
Timesheet manager comment
Leave request ID
Timesheet group ID
Timesheet leave type ID	Internal ID that identifies the leave type linked to this timesheet.
Timesheet paid record ID	Internal ID that identifies the batch record that groups timesheets marked as paid.
Pay period ID	Internal ID that identifies the pay period schedule linked to this contract.
Timesheet time approved by ID
Pay detail ID
Timesheet last paid status change date	Shows when the timesheet was last changed to paid or unpaid.
Timesheet last accrued date	Shows when the leave accrual linked to this timesheet was last updated.
Timesheet meal break times	Meal breaks taken at specific start and end times.
Timesheet rest break times	Rest breaks recorded with specific start and end times.
Timesheet meal break durations	Meal breaks added as a duration only, without specific start and end times.
Timesheet rest break durations	Rest breaks recorded as a duration only, without specific start and end times.
Employee access level ID	Internal ID that identifies the employee’s access level or role.
Employee primary location ID
Employee contact details ID
Employee created date
Employee created by ID
Employee user ID
Employee last modified date
Employee job position
Employee last name
Employee first name
Employee job application ID	Links the employee to their original job application in Deputy Hire.
Employee preferred name
Employee main address ID
Employee onboarding ID
Employee stress profile ID	Internal ID that identifies the stress profile applied to this employee.
Employee hire date
Employee archived date
Employee access level name	Shows the employee’s access level or role in the system.
Employee primary location code
Employee primary location name
Employee primary location company number	Shows the company number recorded for the employee’s primary location.
Employee primary location parent ID	Internal ID that identifies the parent location for the employee’s primary location.
Employee primary location business number	Shows the business number recorded for the employee’s primary location.
Employee primary location payroll export code	The code used to map the primary location to your payroll system.
Employee contact email
Employee contact mobile
Employee stress profile name	Shows the name of the stress profile applied to this employee.
Employee stress profile max hours per day	Shows the maximum hours the employee can work in a single day under the stress profile.
Employee stress profile max days per period	Shows the maximum number of days the employee can work in the stress profile period.
Employee stress profile max hours per shift	Shows the maximum hours allowed for a single shift under the stress profile.
Employee stress profile max hours per period	Shows the maximum hours the employee can work in the stress profile period.
Employee stress profile gap hours between shifts	Shows the minimum required rest time between the employee’s shifts under their stress profile.
Employee status	Shows the current employee status: Active or Archived.
Employee gender
Employee pronouns
Employee full name
Employee date of birth
Employee main address
Employee active payroll IDs	Lists the payroll IDs currently active for this employee.
Employee main address state
Employee main address country
Employee custom fields	Shows values stored in the employee’s custom fields.
Employee location status
Employee address city
Employee address po box
Employee address street 1
Employee address street 2
Employee address unit no
Employee address postcode
Employee address suite no
Employee address street no
Employee emergency contact phone number
Employee emergency contact name
Timesheet location ID
Timesheet area payroll export name	Area name formatted to match your payroll system configuration.
Timesheet area name
Timesheet area name with location code	Shows the area name combined with its location code.
Timesheet parent area ID
Timesheet location code
Timesheet location name
Timesheet location company number	Shows the company number recorded for this timesheet’s location.
Timesheet location parent ID
Timesheet location business number	Shows the business number recorded for this timesheet’s location.
Timesheet location payroll export code	The code used to map this location to your payroll system.
Timesheet area status	Shows the current timesheet area status: Active or Inactive.
Timesheet location status	Shows the current timesheet location status: Active or Archived.
Timesheet location hierarchy	Shows where this location sits in your business location hierarchy.
Shift cost
Shift is open
Shift comment
Shift created date
Shift created by ID
Shift warnings	Shows any issues or rule conflicts detected for this planned shift.
Shift modified date
Shift group ID	Internal ID that identifies the group this shift belongs to, if grouped.
Shift is published	Indicates whether the shift has been published to the assigned employee.
Shift confirmed by ID
Shift total time
Shift swap status	Shows the current shift swap status: Not required, Swap sent, Swap received, Swap sent and received, Pending approval, Approved, Cancelled, or Declined.
Shift confirmation date
Shift confirmation status	Shows the current shift confirmation status: Not required, Requires confirmation, Confirmed, or Declined.
Shift template ID
Shift swap approved by ID
Shift confirmation comment
Shift area ID
Shift is approval required	Indicates whether this open shift requires manager approval when employees apply.
Shift warning override comment
Shift date
Shift total mealbreak time
Shift total rest break time	Shows the total planned rest break time for the shift in minutes.
Shift meal break times	Meal breaks scheduled at specific start and end times.
Shift rest break times	Rest breaks scheduled at specific start and end times.
Shift meal break durations	Meal breaks scheduled as a duration only, without specific start and end times.
Shift rest break durations	Rest breaks scheduled as a duration only, without specific start and end times.
Shift location ID
Shift area payroll export name	Area name formatted to match your payroll system configuration.
Shift area name
Shift area name with location code
Shift parent area ID
Shift location code
Shift location name
Shift location company number	Shows the company number recorded for the shift location.
Shift location parent ID
Shift location business number	Shows the business number recorded for the shift location.
Shift location payroll export code	The code used to map this location to your payroll system.
Shift area status	Shows the current shift area status: Active or Inactive.
Shift location status	Shows the current shift location status: Active or Archived.
Shift end time
Shift start time
Shift custom fields	Shows values stored in the shift’s custom fields.
Shift is empty
Timesheet status	Shows the current timesheet status: Upcoming, On shift, Absent, Late, Pending, Time approved, Pay approved, Discarded, Exported, or Paid.

Return to top ^

Shifts, timesheets & sales

Column Name in Analytics	Notes
Date
Area ID
Area name
Area status
Location ID
Location code
Location name
Location status	Shows the current location status: Active or Archived.
Assigned to ID
Assigned to name
Employee status	Shows the current employee status: Active or Archived.
Shift is open
Shift is empty
Shift is open or empty
Is leave
Schedule on-cost percent	Shows the on-cost percentage applied to scheduled labour costs.
Sales per employee
Sales per area
Timesheet total time
Timesheet cost
Timesheet cost including on-cost	Total timesheet labour cost including an on-cost percent set in location settings for things like superannuation or insurance.
Timesheet total mealbreak time
Scheduled total time
Scheduled cost
Scheduled cost including on-cost	Total scheduled labour cost including on-costs like superannuation or insurance.
Salary cost
Salary cost including on-cost	Salary cost including on-costs like superannuation, taxes, or insurance.
Shift total mealbreak time
Employee primary pay rate employment type	Shows the employment type linked to the employee’s primary pay rate.

Return to top ^

Tasks

Column Name in Analytics	Notes
Task ID
Task type	Shows the task type, such as checklist, recurring, or information-only.
Task times completed	Shows how many times this task has been completed.
Task comment
Task created date
Task duration	Shows how long the task is expected to take to complete.
Task group ID
Task last modified date
Task name
Task area ID
Task sort order
Task created by ID
Task assigned to ID
Task completed by ID
Task date
Task due date
Task location ID
Task area payroll export name	Area name formatted to match your payroll system configuration.
Task area name
Task parent area ID
Task location code
Task location name
Task location company number	Shows the company number recorded for the task’s location.
Task location parent ID
Task location business number	Shows the business number recorded for the task’s location.
Task location payroll export code	The code used to map this task location to your payroll system.
Task created by primary location ID
Task created by first name
Task created by last name
Task created by preferred name
Task created by access level name	Shows the access level of the person who created the task.
Task created by primary location code
Task created by primary location name
Task created by status	Shows the current task creator's status: Active or Archived.
Task created by full name
Task created by custom fields	Shows values from the creator’s custom fields.
Task completed by primary location ID
Task completed by first name
Task completed by last name
Task completed by preferred name
Task completed by access level	Shows the access level of the person who completed the task.
Task completed by primary location code
Task completed by primary location name
Task completed by status	Shows the task completing employee's status: Active or Archived.
Task completed by full name
Task completed by custom fields	Shows values from the completing employee’s custom fields.
Task assigned to primary location ID
Task assigned to first name
Task assigned to last name
Task assigned to preferred name
Task assigned to access level	Shows the access level of the person the task is assigned to.
Task assigned to status	Shows the task assignee status: Active or Archived.
Task assigned to full name
Task assigned to custom fields	Shows values from the assignee’s custom fields.
Task roll over if not completed	Indicates whether the task will roll over to the next day if unfinished.
Task area status	Shows the current task area status: Active or Inactive.
Task location status	Shows the current task location status: Active or Archived.
Task completed date
Task available after	Shows the earliest time when this task can be completed.

Return to top ^

Timesheet audit

Column Name in Analytics	Notes
Timesheet ID
Modified field
Modified date
Modified by ID
Modified by session data	Technical session details captured when this record was modified.
Timesheet cost
Shift ID
Timesheet created date
Timesheet created by ID
Employee ID
Leave request ID
Timesheet last modified date
Timesheet group ID
Timesheet leave type ID	Internal ID that identifies the leave type linked to this timesheet.
Timesheet total time
Pay period ID	Internal ID that identifies the pay period schedule linked to this contract.
Timesheet time approved by ID
Timesheet employee comment
Employee history ID	Internal ID that identifies the employee’s history record used on timesheets.
Timesheet area ID
Pay detail ID
Timesheet last paid status change date	Shows when the timesheet was last changed to paid or unpaid.
Timesheet last accrued date	Shows when the leave accrual linked to this timesheet was last updated.
Timesheet date
Timesheet total mealbreak time
Timesheet is leave
Timesheet submitted in real time	Indicates whether the timesheet was clocked rather than manually submitted after the shift.
Timesheet rounded	Indicates whether times on this timesheet were adjusted by rounding rules.
Timesheet auto processed	Indicates whether the timesheet was automatically processed based on location settings.
Timesheet auto time approved	Indicates whether times were automatically approved based on location settings.
Timesheet auto pay approved	Indicates whether pay was automatically approved based on location settings.
Employee access level ID	Internal ID that identifies the employee’s access level or role.
Employee primary location ID
Employee contact details ID
Employee created date
Employee created by ID
Employee user ID
Employee last modified date
Employee job position
Employee last name
Employee first name
Employee job application ID	Links the employee to their original job application in Deputy Hire.
Employee preferred name
Employee main address ID
Employee onboarding ID
Employee stress profile ID	Internal ID that identifies the stress profile applied to this employee.
Employee hire date
Employee archived date
Employee access level name	Shows the employee’s access level or role in the system.
Employee primary location code
Employee primary location name
Employee primary location company number	Shows the company number recorded for the employee’s primary location.
Employee primary location parent ID	Internal ID that identifies the parent location for the employee’s primary location.
Employee primary location business number	Shows the business number recorded for the employee’s primary location.
Employee primary location payroll export code	The code used to map the primary location to your payroll system.
Employee contact email
Employee contact phone
Employee stress profile name	Shows the name of the stress profile applied to this employee.
Employee stress profile max hours per day	Shows the maximum hours the employee can work in a single day under the stress profile.
Employee stress profile max days per period	Shows the maximum number of days the employee can work in the stress profile period.
Employee stress profile max hours per shift	Shows the maximum hours allowed for a single shift under the stress profile.
Employee stress profile max hours per period	Shows the maximum hours the employee can work in the stress profile period.
Employee stress profile gap hours between shifts	Shows the minimum required rest time between the employee’s shifts under their stress profile.
Employee status	Shows the current employee status: Active or Archived.
Employee gender
Employee pronouns
Employee full name
Employee contact mobile
Employee date of birth
Employee main address
Employee active payroll IDs	Lists the payroll IDs currently active for this employee.
Employee main address state
Employee main address country
Employee custom fields	Shows values stored in the employee’s custom fields.
Employee email
Employee location status
Employee pay detail created date
Employee pay detail created by id
Employee pay rate id	Internal ID that identifies the pay rate or employment term for this employee.
Employee pay detail last modified date
Employee pay centre id	Internal ID that identifies the pay centre linked to this employee’s agreement.
Employee pay calendar id
Employee pay period id	Internal ID that identifies the pay period associated with this contract.
Employee payroll id	Internal ID that identifies this employee in your payroll system.
Employee employee id
Employee salary pay rule id	Internal ID that identifies the salary pay rule used for this employee.
Employee classification id
Employee pay rate name
Employee pay rate created date
Employee pay rate created by id
Employee pay rate last modified date
Employee pay rate employment type id	Internal ID that identifies the employment type linked to this pay rate.
Employee Standard hours
Employee pay period name
Employee pay period length id	Internal ID that identifies the pay period frequency, such as weekly or monthly.
Employee pay period created date
Employee pay period created by id
Employee pay period last modified date
Employee pay period start date
Employee salary pay rule name	Shows the name of the salary pay rule applied to this employee.
Employee annual salary
Employee salary pay rule export code	The code used to map the salary pay rule to your payroll system.
Employee pay calendar name
Employee pay calendar payment frequency
Employee pay calendar business number
Employee pay calendar created by id
Employee pay calendar created date
Employee pay calendar last modified date
Employee pay calendar start date
Employee pay calendar payment date
Employee regular rate name	Shows the name of the employee’s regular pay rate.
Employee regular rate export code	The code used to map the employee’s regular rate to your payroll system.
Employee pay rate regular rate	Shows the base pay rate used for this employee’s regular hours.
Employee pay detail locations	Lists the locations covered by this employee’s pay agreement.
Employee pay rate employment type	Shows the employment type linked to this pay rate, such as full‑time.
Employee pay period length name	Shows the frequency of the pay period, such as weekly or monthly.
Employee pay detail status
Employee salary pay rule is exported	Indicates whether the salary pay rule is sent to payroll.
Employee regular rate is exported	Indicates whether the employee’s regular rate is sent to payroll.
Employee area regular rate
Timesheet area payroll export name	Area name formatted to match your payroll system configuration.
Timesheet area name
Timesheet area status	Shows the current timesheet area status: Active or Inactive.
Area is deleted
Location is deleted
Timesheet pay line leave policy name
Timesheet pay line leave policy type
Timesheet pay line leave policy unit	Shows whether this pay-line leave is tracked in hours or days.
Timesheet pay line leave policy accrual reset period	Shows how often leave accrual is reset for this pay line.
Timesheet pay line leave policy description	Description of the leave condition used for this pay line.
Timesheet pay line leave policy export type	Shows how this pay-line leave type is exported to your payroll system.
Timesheet pay line leave policy reset value	Shows the balance value applied when this pay-line leave policy resets.
Timesheet pay line leave policy reset schedule	Shows when this pay-line leave balance is scheduled to reset.
Timesheet pay line leave policy export code	The code used to map this pay-line leave type to your payroll system.
Timesheet pay line leave policy is visible	Indicates whether this pay-line leave policy is visible to employees.
Timesheet pay line leave policy is paid	Indicates whether this pay-line leave is paid or unpaid.
Timesheet pay line leave policy rolls over	Indicates whether unused leave from this pay-line carries over to the next year.
Leave request total days
Leave request comment
Leave request location ID
Leave request creation date
Leave request created by ID
Leave request employee ID
Leave request last modified date
Leave request leave policy ID
Leave request total hours
Leave request pay approved by ID
Leave request time approved by ID
Leave request approval comment
Leave request employee history ID
Leave request start date
Leave request end time
Leave request is all day
Leave request pay approver full name
Leave request time approver full name
Leave request creator full name
Timesheet paid record created date
Timesheet paid record created by ID
Timesheet paid date
Timesheet photo taken	Indicates whether a photo was captured with this timesheet.
Timesheet end time
Timesheet start time
Timesheet issue ID
Timesheet issue type
Timesheet leave request end time
Timesheet leave request start time
Timesheet custom fields	Shows values stored in the timesheet’s custom fields.
Timesheet approver full name
Timesheet creator full name
Timesheet location ID
Timesheet location code
Timesheet location name
Timesheet location company number	Shows the company number recorded for this timesheet’s location.
Timesheet location parent ID
Timesheet location business number	Shows the business number recorded for this timesheet’s location.
Timesheet location payroll export code	The code used to map this location to your payroll system.
Timesheet location status	Shows the current timesheet location status: Active or Archived.
Shift cost
Shift comment
Shift created date
Shift created by ID
Shift warnings	Shows any issues or rule conflicts detected for this planned shift.
Shift employee ID
Shift modified date
Shift group ID	Internal ID that identifies the group this shift belongs to, if grouped.
Shift confirmed by ID
Shift total time
Shift swap status	Shows the current shift swap status: Not required, Swap sent, Swap received, Swap sent and received, Pending approval, Approved, Cancelled, or Declined.
Shift confirmation date
Shift confirmation status	Shows the current shift confirmation status: Not required, Requires confirmation, Confirmed, or Declined.
Shift template ID
Shift swap approved by ID
Shift confirmation comment
Shift area ID
Shift warning override comment
Shift date
Shift total mealbreak time
Shift is open
Shift is published	Indicates whether the shift has been published to the assigned employee.
Shift is approval required	Indicates whether this open shift requires manager approval when employees apply.
Shift location ID
Shift area payroll export name	Area name formatted to match your payroll system configuration.
Shift area name
Shift parent area ID
Shift location code
Shift location name
Shift location company number	Shows the company number recorded for the shift location.
Shift location parent ID
Shift location business number	Shows the business number recorded for the shift location.
Shift location payroll export code	The code used to map this location to your payroll system.
Shift area status	Shows the current shift area status: Active or Inactive.
Shift location status	Shows the current shift location status: Active or Archived.
Shift area name with location code
Shift end time
Shift start time
Shift custom fields	Shows values stored in the shift’s custom fields.
Timesheet location timezone
Employee primary location timezone
Timesheet status	Shows the current timesheet status: Upcoming, On shift, Absent, Late, Pending, Time approved, Pay approved, Discarded, Exported, or Paid.
Modified by name
Modified by email
Old value
New value
Timesheet is deleted
Timesheet pay period start date
Timesheet pay period end date

Return to top ^

Timesheet geolocation audit

Column Name in Analytics	Notes
Geolocation ID
Action
Timesheet ID
Accuracy
Latitude
Longitude
Timesheet cost
Shift ID
Timesheet created date
Timesheet created by ID
Employee ID
Leave request ID
Timesheet last modified date
Timesheet group ID
Timesheet leave type ID	Internal ID that identifies the leave type linked to this timesheet.
Timesheet total time
Pay period ID	Internal ID that identifies the pay period schedule linked to this contract.
Timesheet time approved by ID
Timesheet employee comment
Employee history ID	Internal ID that identifies the employee’s history record used on timesheets.
Timesheet area ID
Pay detail ID
Timesheet last paid status change date	Shows when the timesheet was last changed to paid or unpaid.
Timesheet last accrued date	Shows when the leave accrual linked to this timesheet was last updated.
Timesheet date
Timesheet total mealbreak time
Timesheet is leave
Timesheet submitted in real time	Indicates whether the timesheet was clocked rather than manually submitted after the shift.
Timesheet rounded	Indicates whether times on this timesheet were adjusted by rounding rules.
Timesheet auto processed	Indicates whether the timesheet was automatically processed based on location settings.
Timesheet auto time approved	Indicates whether times were automatically approved based on location settings.
Employee access level ID	Internal ID that identifies the employee’s access level or role.
Employee primary location ID
Employee contact details ID
Employee created date
Employee created by ID
Employee user ID
Employee last modified date
Employee job position
Employee last name
Employee first name
Employee job application ID	Links the employee to their original job application in Deputy Hire.
Employee preferred name
Employee main address ID
Employee onboarding ID
Employee stress profile ID	Internal ID that identifies the stress profile applied to this employee.
Employee hire date
Employee archived date
Employee access level name	Shows the employee’s access level or role in the system.
Employee primary location code
Employee primary location name
Employee primary location company number	Shows the company number recorded for the employee’s primary location.
Employee primary location parent ID	Internal ID that identifies the parent location for the employee’s primary location.
Employee primary location business number	Shows the business number recorded for the employee’s primary location.
Employee primary location payroll export code	The code used to map the primary location to your payroll system.
Employee contact email
Employee contact phone
Employee stress profile name	Shows the name of the stress profile applied to this employee.
Employee stress profile max hours per day	Shows the maximum hours the employee can work in a single day under the stress profile.
Employee stress profile max days per period	Shows the maximum number of days the employee can work in the stress profile period.
Employee stress profile max hours per shift	Shows the maximum hours allowed for a single shift under the stress profile.
Employee stress profile max hours per period	Shows the maximum hours the employee can work in the stress profile period.
Employee stress profile gap hours between shifts	Shows the minimum required rest time between the employee’s shifts under their stress profile.
Employee status	Shows the current employee status: Active or Archived.
Employee gender
Employee pronouns
Employee full name
Employee contact mobile
Employee date of birth
Employee main address
Employee active payroll IDs	Lists the payroll IDs currently active for this employee.
Employee main address state
Employee main address country
Employee custom fields	Shows values stored in the employee’s custom fields.
Employee pay detail created date
Employee pay detail created by id
Employee pay rate id	Internal ID that identifies the pay rate or employment term for this employee.
Employee pay detail last modified date
Employee pay centre id	Internal ID that identifies the pay centre linked to this employee’s agreement.
Employee pay calendar id
Employee pay period id	Internal ID that identifies the pay period associated with this contract.
Employee payroll id	Internal ID that identifies this employee in your payroll system.
Employee employee id
Employee salary pay rule id	Internal ID that identifies the salary pay rule used for this employee.
Employee classification id
Employee pay rate name
Employee pay rate created date
Employee pay rate created by id
Employee pay rate last modified date
Employee pay rate employment type id	Internal ID that identifies the employment type linked to this pay rate.
Employee Standard hours
Employee pay period name
Employee pay period length id	Internal ID that identifies the pay period frequency, such as weekly or monthly.
Employee pay period created date
Employee pay period created by id
Employee pay period last modified date
Employee pay period start date
Employee salary pay rule name	Shows the name of the salary pay rule applied to this employee.
Employee annual salary
Employee salary pay rule export code	The code used to map the salary pay rule to your payroll system.
Employee pay calendar name
Employee pay calendar payment frequency
Employee pay calendar business number
Employee pay calendar created by id
Employee pay calendar created date
Employee pay calendar last modified date
Employee pay calendar start date
Employee pay calendar payment date
Employee regular rate name	Shows the name of the employee’s regular pay rate.
Employee regular rate export code	The code used to map the employee’s regular rate to your payroll system.
Employee pay rate regular rate	Shows the base pay rate used for this employee’s regular hours.
Employee pay detail locations	Lists the locations covered by this employee’s pay agreement.
Employee pay rate employment type	Shows the employment type linked to this pay rate, such as full‑time.
Employee pay period length name	Shows the frequency of the pay period, such as weekly or monthly.
Employee pay detail status
Employee salary pay rule is exported	Indicates whether the salary pay rule is sent to payroll.
Employee regular rate is exported	Indicates whether the employee’s regular rate is sent to payroll.
Employee area regular rate
Timesheet area payroll export name	Area name formatted to match your payroll system configuration.
Timesheet area name
Timesheet parent area ID
Timesheet area status	Shows the current timesheet area status: Active or Inactive.
Timesheet area name with location code	Shows the area name combined with its location code.
Timesheet pay line leave policy name
Timesheet pay line leave policy type
Timesheet pay line leave policy unit	Shows whether this pay-line leave is tracked in hours or days.
Timesheet pay line leave policy accrual reset period	Shows how often leave accrual is reset for this pay line.
Timesheet pay line leave policy description	Description of the leave condition used for this pay line.
Timesheet pay line leave policy export type	Shows how this pay-line leave type is exported to your payroll system.
Timesheet pay line leave policy reset value	Shows the balance value applied when this pay-line leave policy resets.
Timesheet pay line leave policy reset schedule	Shows when this pay-line leave balance is scheduled to reset.
Timesheet pay line leave policy export code	The code used to map this pay-line leave type to your payroll system.
Timesheet pay line leave policy is visible	Indicates whether this pay-line leave policy is visible to employees.
Timesheet pay line leave policy is paid	Indicates whether this pay-line leave is paid or unpaid.
Timesheet pay line leave policy rolls over	Indicates whether unused leave from this pay-line carries over to the next year.
Leave request total days
Leave request comment
Leave request location ID
Leave request creation date
Leave request created by ID
Leave request employee ID
Leave request last modified date
Leave request leave policy ID
Leave request total hours
Leave request pay approved by ID
Leave request time approved by ID
Leave request approval comment
Leave request employee history ID
Leave request start date
Leave request end time
Leave request is all day
Timesheet paid record created date
Timesheet photo taken	Indicates whether a photo was captured with this timesheet.
Timesheet end time
Timesheet start time
Timesheet issue ID
Timesheet issue type
Timesheet leave request end time
Timesheet leave request start time
Timesheet custom fields	Shows values stored in the timesheet’s custom fields.
Timesheet location timezone
Employee primary location timezone
Timesheet location ID
Timesheet location code
Timesheet location name
Timesheet location company number	Shows the company number recorded for this timesheet’s location.
Timesheet location parent ID
Timesheet location business number	Shows the business number recorded for this timesheet’s location.
Timesheet location payroll export code	The code used to map this location to your payroll system.
Timesheet location status	Shows the current timesheet location status: Active or Archived.
Shift cost
Shift comment
Shift created date
Shift created by ID
Shift warnings	Shows any issues or rule conflicts detected for this planned shift.
Shift employee ID
Shift modified date
Shift group ID	Internal ID that identifies the group this shift belongs to, if grouped.
Shift confirmed by ID
Shift total time
Shift swap status	Shows the current shift swap status: Not required, Swap sent, Swap received, Swap sent and received, Pending approval, Approved, Cancelled, or Declined.
Shift confirmation date
Shift confirmation status	Shows the current shift confirmation status: Not required, Requires confirmation, Confirmed, or Declined.
Shift template ID
Shift swap approved by ID
Shift confirmation comment
Shift area ID
Shift warning override comment
Shift date
Shift total mealbreak time
Shift is open
Shift is published	Indicates whether the shift has been published to the assigned employee.
Shift is approval required	Indicates whether this open shift requires manager approval when employees apply.
Shift location ID
Shift area payroll export name	Area name formatted to match your payroll system configuration.
Shift area name
Shift parent area ID
Shift location code
Shift location name
Shift location company number	Shows the company number recorded for the shift location.
Shift location parent ID
Shift location business number	Shows the business number recorded for the shift location.
Shift location payroll export code	The code used to map this location to your payroll system.
Shift area status	Shows the current shift area status: Active or Inactive.
Area is deleted
Shift location status	Shows the current shift location status: Active or Archived.
Location is deleted
Shift area name with location code
Shift end time
Shift start time
Shift custom fields	Shows values stored in the shift’s custom fields.
Timesheet status	Shows the current timesheet status: Upcoming, On shift, Absent, Late, Pending, Time approved, Pay approved, Discarded, Exported, or Paid.
Area latitude
Area longitude
Location latitude
Location longitude
Geolocation type
Timesheet pay period start date
Timesheet pay period end date

Return to top ^

Timesheet geolocation map

Column Name in Analytics	Notes
Geolocation ID
Timesheet ID
Timesheet date
Area ID
Area name
Area status
Location ID
Location name
Location status	Shows the current location status: Active or Archived.
Employee ID
Employee full name
Employee preferred name
Employee status	Shows the current employee status: Active or Archived.
Geolocation type
Geolocation longitude
Geolocation latitude
Created time

Return to top ^

Timesheet pay

Column Name in Analytics	Notes
Timesheet pay return ID
Timesheet pay return cost	The dollar amount paid for this approved timesheet pay line.
Timesheet pay return quantity	Shows the number of units used to calculate pay, usually hours worked.
Timesheet pay return created date
Timesheet pay return created by ID
Timesheet pay return modified by ID
Timesheet pay return pay rule ID
Timesheet ID
Timesheet pay return overridden	Indicates whether this timesheet pay result was manually overridden.
Timesheet pay return override comment	Shows any comment entered when overriding this timesheet pay result.
Timesheet cost
Shift ID
Timesheet created date
Timesheet created by ID
Employee ID
Leave request ID
Timesheet last modified date
Timesheet group ID
Timesheet leave type ID	Internal ID that identifies the leave type linked to this timesheet.
Timesheet paid record ID	Internal ID that identifies the batch record that groups timesheets marked as paid.
Timesheet total time
Pay period ID	Internal ID that identifies the pay period schedule linked to this contract.
Timesheet time approved by ID
Timesheet employee comment
Employee history ID	Internal ID that identifies the employee’s history record used on timesheets.
Timesheet area ID
Pay detail ID
Timesheet last paid status change date	Shows when the timesheet was last changed to paid or unpaid.
Timesheet last accrued date	Shows when the leave accrual linked to this timesheet was last updated.
Timesheet date
Timesheet is leave
Timesheet submitted in real time	Indicates whether the timesheet was clocked rather than manually submitted after the shift.
Timesheet rounded	Indicates whether times on this timesheet were adjusted by rounding rules.
Timesheet auto processed	Indicates whether the timesheet was automatically processed based on location settings.
Timesheet auto time approved	Indicates whether times were automatically approved based on location settings.
Timesheet auto pay approved	Indicates whether pay was automatically approved based on location settings.
Timesheet total mealbreak time
Employee access level ID	Internal ID that identifies the employee’s access level or role.
Employee primary location ID
Employee contact details ID
Employee created date
Employee created by ID
Employee user ID
Employee last modified date
Employee job position
Employee last name
Employee first name
Employee job application ID	Links the employee to their original job application in Deputy Hire.
Employee preferred name
Employee main address ID
Employee onboarding ID
Employee stress profile ID	Internal ID that identifies the stress profile applied to this employee.
Employee hire date
Employee archived date
Employee access level name	Shows the employee’s access level or role in the system.
Employee primary location code
Employee primary location company number	Shows the company number recorded for the employee’s primary location.
Employee primary location parent ID	Internal ID that identifies the parent location for the employee’s primary location.
Employee primary location business number	Shows the business number recorded for the employee’s primary location.
Employee primary location payroll export code	The code used to map the primary location to your payroll system.
Employee status	Shows the current employee status: Active or Archived.
Employee gender
Employee pronouns
Employee date of birth
Employee main address
Employee active payroll IDs	Lists the payroll IDs currently active for this employee.
Employee main address state
Employee main address country
Employee custom fields	Shows values stored in the employee’s custom fields.
Employee pay detail created date
Employee pay detail created by id
Employee pay rate id	Internal ID that identifies the pay rate or employment term for this employee.
Employee pay detail last modified date
Employee pay centre id	Internal ID that identifies the pay centre linked to this employee’s agreement.
Employee pay calendar id
Employee pay period id	Internal ID that identifies the pay period associated with this contract.
Employee payroll id	Internal ID that identifies this employee in your payroll system.
Employee salary pay rule id	Internal ID that identifies the salary pay rule used for this employee.
Employee classification id
Employee pay rate name
Employee pay rate created date
Employee pay rate created by id
Employee pay rate last modified date
Employee pay rate employment type id	Internal ID that identifies the employment type linked to this pay rate.
Employee standard hours
Employee pay period name
Employee pay period length id	Internal ID that identifies the pay period frequency, such as weekly or monthly.
Employee pay period created date
Employee pay period created by id
Employee pay period last modified date
Employee pay period start date
Employee salary pay rule name	Shows the name of the salary pay rule applied to this employee.
Employee annual salary
Employee salary pay rule export code	The code used to map the salary pay rule to your payroll system.
Employee pay calendar name
Employee pay calendar payment frequency
Employee pay calendar business number
Employee pay calendar created by id
Employee pay calendar created date
Employee pay calendar last modified date
Employee pay calendar start date
Employee pay calendar payment date
Employee pay centre name	Shows the name of the pay centre for this employee’s agreement.
Employee regular rate name	Shows the name of the employee’s regular pay rate.
Employee regular rate export code	The code used to map the employee’s regular rate to your payroll system.
Employee pay rate regular rate	Shows the base pay rate used for this employee’s regular hours.
Employee pay detail locations	Lists the locations covered by this employee’s pay agreement.
Employee pay rate employment type	Shows the employment type linked to this pay rate, such as full‑time.
Employee pay period length name	Shows the frequency of the pay period, such as weekly or monthly.
Employee pay detail status
Employee salary pay rule is exported	Indicates whether the salary pay rule is sent to payroll.
Employee regular rate is exported	Indicates whether the employee’s regular rate is sent to payroll.
Employee area regular rate
Timesheet area payroll export name	Area name formatted to match your payroll system configuration.
Timesheet area name
Timesheet parent area ID
Timesheet location hierarchy	Shows where this location sits in your business location hierarchy.
Timesheet area status	Shows the current timesheet area status: Active or Inactive.
Area is deleted
Location is deleted
Timesheet area name with location code	Shows the area name combined with its location code.
Timesheet pay line leave policy name
Timesheet pay line leave policy type
Timesheet pay line leave policy unit	Shows whether this pay-line leave is tracked in hours or days.
Timesheet pay line leave policy accrual reset period	Shows how often leave accrual is reset for this pay line.
Timesheet pay line leave policy description	Description of the leave condition used for this pay line.
Timesheet pay line leave policy export type	Shows how this pay-line leave type is exported to your payroll system.
Timesheet pay line leave policy reset value	Shows the balance value applied when this pay-line leave policy resets.
Timesheet pay line leave policy reset schedule	Shows when this pay-line leave balance is scheduled to reset.
Timesheet pay line leave policy export code	The code used to map this pay-line leave type to your payroll system.
Timesheet pay line leave policy is visible	Indicates whether this pay-line leave policy is visible to employees.
Timesheet pay line leave policy is paid	Indicates whether this pay-line leave is paid or unpaid.
Timesheet pay line leave policy rolls over	Indicates whether unused leave from this pay-line carries over to the next year.
Timesheet paid record created date
Timesheet paid record created by ID
Timesheet paid date
Timesheet photo taken	Indicates whether a photo was captured with this timesheet.
Timesheet end time
Timesheet start time
Timesheet issue ID
Timesheet issue type
Timesheet custom fields	Shows values stored in the timesheet’s custom fields.
Timesheet location timezone
Employee primary location timezone
Timesheet time approved by full name
Timesheet created by full name
Timesheet location ID
Timesheet location code
Timesheet location name
Timesheet location company number	Shows the company number recorded for this timesheet’s location.
Timesheet location parent ID
Timesheet location business number	Shows the business number recorded for this timesheet’s location.
Timesheet location payroll export code	The code used to map this location to your payroll system.
Timesheet location status	Shows the current timesheet location status: Active or Archived.
Shift cost
Shift comment
Shift created date
Shift created by ID
Shift warnings	Shows any issues or rule conflicts detected for this planned shift.
Shift modified date
Shift group ID	Internal ID that identifies the group this shift belongs to, if grouped.
Shift confirmed by ID
Shift total time
Shift swap status	Shows the current shift swap status: Not required, Swap sent, Swap received, Swap sent and received, Pending approval, Approved, Cancelled, or Declined.
Shift confirmation date
Shift confirmation status	Shows the current shift confirmation status: Not required, Requires confirmation, Confirmed, or Declined.
Shift template ID
Shift swap approved by ID
Shift confirmation comment
Shift area ID
Shift warning override comment
Shift date
Shift is open
Shift is published	Indicates whether the shift has been published to the assigned employee.
Shift is approval required	Indicates whether this open shift requires manager approval when employees apply.
Shift total mealbreak time
Shift location ID
Shift area payroll export name	Area name formatted to match your payroll system configuration.
Shift parent area ID
Shift location code
Shift location company number	Shows the company number recorded for the shift location.
Shift location parent ID
Shift location business number	Shows the business number recorded for the shift location.
Shift location payroll export code	The code used to map this location to your payroll system.
Shift area status	Shows the current shift area status: Active or Inactive.
Shift location status	Shows the current shift location status: Active or Archived.
Shift end time
Shift start time
Shift custom fields	Shows values stored in the shift’s custom fields.
Pay rate tag	Shows tags used to group or filter this pay rate.
Pay rate name
Pay rate unit value	Shows the value paid per unit when remuneration is unit-based.
Pay rate hourly rate
Pay rate is exported	Indicates whether this pay rate is sent to your payroll system.
Pay rate remuneration by	Shows how remuneration is applied, such as base rate or loadings.
Pay rate multiplier value	Shows the multiplier value applied to the base pay rate.
Pay rate export code	The code used to map this pay rate to your payroll system.
Pay rate remuneration type	Shows whether this pay rate is hourly or unit-based.
Pay rate multiplier base rate	Shows the base rate this multiplier is calculated from.
Pay rate type	Shows the type of pay condition, such as base, overtime, or allowance.
Timesheet pay period start date
Timesheet pay period end date

Return to top ^

Timesheets

Column Name in Analytics	Notes
Timesheet ID
Timesheet cost
Shift ID
Timesheet created date
Timesheet created by ID
Employee ID
Leave request ID
Timesheet last modified date
Timesheet group ID
Timesheet leave type ID	Internal ID that identifies the leave type linked to this timesheet.
Timesheet paid record ID	Internal ID that identifies the batch record that groups timesheets marked as paid.
Timesheet total time
Pay period ID	Internal ID that identifies the pay period schedule linked to this contract.
Timesheet time approved by ID
Timesheet employee comment
Employee history ID	Internal ID that identifies the employee’s history record used on timesheets.
Timesheet area ID
Pay detail ID
Timesheet last paid status change date	Shows when the timesheet was last changed to paid or unpaid.
Timesheet last accrued date	Shows when the leave accrual linked to this timesheet was last updated.
Timesheet date
Timesheet is leave
Timesheet submitted in real time	Indicates whether the timesheet was clocked rather than manually submitted after the shift.
Timesheet rounded	Indicates whether times on this timesheet were adjusted by rounding rules.
Timesheet auto processed	Indicates whether the timesheet was automatically processed based on location settings.
Timesheet auto time approved	Indicates whether times were automatically approved based on location settings.
Timesheet auto pay approved	Indicates whether pay was automatically approved based on location settings.
Timesheet total mealbreak time
Employee access level ID	Internal ID that identifies the employee’s access level or role.
Employee primary location ID
Employee contact details ID
Employee created date
Employee created by ID
Employee user ID
Employee last modified date
Employee job position
Employee last name
Employee first name
Employee job application ID	Links the employee to their original job application in Deputy Hire.
Employee preferred name
Employee main address ID
Employee onboarding ID
Employee stress profile ID	Internal ID that identifies the stress profile applied to this employee.
Employee hire date
Employee archived date
Employee access level name	Shows the employee’s access level or role in the system.
Employee primary location code
Employee primary location name
Employee primary location company number	Shows the company number recorded for the employee’s primary location.
Employee primary location parent ID	Internal ID that identifies the parent location for the employee’s primary location.
Employee primary location business number	Shows the business number recorded for the employee’s primary location.
Employee primary location payroll export code	The code used to map the primary location to your payroll system.
Employee contact email
Employee contact phone
Employee stress profile name	Shows the name of the stress profile applied to this employee.
Employee stress profile max hours per day	Shows the maximum hours the employee can work in a single day under the stress profile.
Employee stress profile max days per period	Shows the maximum number of days the employee can work in the stress profile period.
Employee stress profile max hours per shift	Shows the maximum hours allowed for a single shift under the stress profile.
Employee stress profile max hours per period	Shows the maximum hours the employee can work in the stress profile period.
Employee stress profile gap hours between shifts	Shows the minimum required rest time between the employee’s shifts under their stress profile.
Employee status	Shows the current employee status: Active or Archived.
Employee gender
Employee pronouns
Employee full name
Employee contact mobile
Employee date of birth
Employee main address
Employee active payroll IDs	Lists the payroll IDs currently active for this employee.
Employee main address state
Employee main address country
Employee custom fields	Shows values stored in the employee’s custom fields.
Employee pay detail created date
Employee pay detail created by id
Employee pay rate id	Internal ID that identifies the pay rate or employment term for this employee.
Employee pay detail last modified date
Employee pay centre id	Internal ID that identifies the pay centre linked to this employee’s agreement.
Employee pay calendar id
Employee pay period id	Internal ID that identifies the pay period associated with this contract.
Employee payroll id	Internal ID that identifies this employee in your payroll system.
Employee salary pay rule id	Internal ID that identifies the salary pay rule used for this employee.
Employee classification id
Employee pay rate name
Employee pay rate created date
Employee pay rate created by id
Employee pay rate last modified date
Employee pay rate employment type id	Internal ID that identifies the employment type linked to this pay rate.
Employee standard hours
Employee pay period name
Employee pay period length id	Internal ID that identifies the pay period frequency, such as weekly or monthly.
Employee pay period created date
Employee pay period created by id
Employee pay period last modified date
Employee pay period start date
Employee salary pay rule name	Shows the name of the salary pay rule applied to this employee.
Employee annual salary
Employee salary pay rule export code	The code used to map the salary pay rule to your payroll system.
Employee pay calendar name
Employee pay calendar payment frequency
Employee pay calendar business number
Employee pay calendar created by id
Employee pay calendar created date
Employee pay calendar last modified date
Employee pay calendar start date
Employee pay calendar payment date
Employee regular rate name	Shows the name of the employee’s regular pay rate.
Employee regular rate export code	The code used to map the employee’s regular rate to your payroll system.
Employee pay rate regular rate	Shows the base pay rate used for this employee’s regular hours.
Employee pay detail locations	Lists the locations covered by this employee’s pay agreement.
Employee pay rate employment type	Shows the employment type linked to this pay rate, such as full‑time.
Employee pay period length name	Shows the frequency of the pay period, such as weekly or monthly.
Employee pay detail status
Employee salary pay rule is exported	Indicates whether the salary pay rule is sent to payroll.
Employee regular rate is exported	Indicates whether the employee’s regular rate is sent to payroll.
Employee area regular rate
Timesheet area payroll export name	Area name formatted to match your payroll system configuration.
Timesheet area name
Timesheet parent area ID
Timesheet location hierarchy	Shows where this location sits in your business location hierarchy.
Timesheet area status	Shows the current timesheet area status: Active or Inactive.
Area is deleted
Location is deleted
Timesheet area name with location code	Shows the area name combined with its location code.
Timesheet pay line leave policy name
Timesheet pay line leave policy type
Timesheet pay line leave policy unit	Shows whether this pay-line leave is tracked in hours or days.
Timesheet pay line leave policy accrual reset period	Shows how often leave accrual is reset for this pay line.
Timesheet pay line leave policy description	Description of the leave condition used for this pay line.
Timesheet pay line leave policy export type	Shows how this pay-line leave type is exported to your payroll system.
Timesheet pay line leave policy reset value	Shows the balance value applied when this pay-line leave policy resets.
Timesheet pay line leave policy reset schedule	Shows when this pay-line leave balance is scheduled to reset.
Timesheet pay line leave policy export code	The code used to map this pay-line leave type to your payroll system.
Timesheet pay line leave policy is visible	Indicates whether this pay-line leave policy is visible to employees.
Timesheet pay line leave policy is paid	Indicates whether this pay-line leave is paid or unpaid.
Timesheet pay line leave policy rolls over	Indicates whether unused leave from this pay-line carries over to the next year.
Leave request total days
Leave request comment
Leave request location ID
Leave request creation date
Leave request created by ID
Leave request last modified date
Leave request leave policy ID
Leave request total hours
Leave request pay approved by ID
Leave request time approved by ID
Leave request approval comment
Leave request employee history ID
Leave request start date
Leave request end time
Leave request is all day
Leave request pay approved by full name
Leave request time approved by full name
Leave request created by full name
Timesheet paid record created date
Timesheet paid record created by ID
Timesheet paid date
Timesheet photo taken	Indicates whether a photo was captured with this timesheet.
Timesheet end time
Timesheet start time
Timesheet issue ID
Timesheet issue type
Timesheet leave request end time
Timesheet leave request start time
Timesheet custom fields	Shows values stored in the timesheet’s custom fields.
Timesheet location timezone
Employee primary location timezone
Timesheet time approved by full name
Timesheet created by full name
Timesheet location ID
Timesheet location code
Timesheet location name
Timesheet location company number	Shows the company number recorded for this timesheet’s location.
Timesheet location parent ID
Timesheet location business number	Shows the business number recorded for this timesheet’s location.
Timesheet location payroll export code	The code used to map this location to your payroll system.
Timesheet location status	Shows the current timesheet location status: Active or Archived.
Employee emergency contact phone number
Employee emergency contact name
Shift cost
Shift comment
Shift created date
Shift created by ID
Shift warnings	Shows any issues or rule conflicts detected for this planned shift.
Shift modified date
Shift group ID	Internal ID that identifies the group this shift belongs to, if grouped.
Shift confirmed by ID
Shift total time
Shift swap status	Shows the current shift swap status: Not required, Swap sent, Swap received, Swap sent and received, Pending approval, Approved, Cancelled, or Declined.
Shift confirmation date
Shift confirmation status	Shows the current shift confirmation status: Not required, Requires confirmation, Confirmed, or Declined.
Shift template ID
Shift swap approved by ID
Shift confirmation comment
Shift area ID
Shift date
Shift is open
Shift is published	Indicates whether the shift has been published to the assigned employee.
Shift is approval required	Indicates whether this open shift requires manager approval when employees apply.
Shift total mealbreak time
Shift location ID
Shift area payroll export name	Area name formatted to match your payroll system configuration.
Shift area name
Shift parent area ID
Shift location code
Shift location name
Shift location company number	Shows the company number recorded for the shift location.
Shift location parent ID
Shift location business number	Shows the business number recorded for the shift location.
Shift location payroll export code	The code used to map this location to your payroll system.
Shift area status	Shows the current shift area status: Active or Inactive.
Shift location status	Shows the current shift location status: Active or Archived.
Shift area name with location code
Shift end time
Shift start time
Shift custom fields	Shows values stored in the shift’s custom fields.
Timesheet status	Shows the current timesheet status: Upcoming, On shift, Absent, Late, Pending, Time approved, Pay approved, Discarded, Exported, or Paid.
Timesheet total rest break time	Shows total rest break time recorded on this timesheet, in minutes.
Timesheet meal break times	Meal breaks taken at specific start and end times.
Timesheet meal break durations	Meal breaks added as a duration only, without specific start and end times.
Timesheet rest break times	Rest breaks recorded with specific start and end times.
Timesheet rest break durations	Rest breaks recorded as a duration only, without specific start and end times.
Shift total rest break time	Shows the total planned rest break time for the shift in minutes.
Shift meal break times	Meal breaks scheduled at specific start and end times.
Shift meal break durations	Meal breaks scheduled as a duration only, without specific start and end times.
Shift rest break times	Rest breaks scheduled at specific start and end times.
Shift rest break durations	Rest breaks scheduled as a duration only, without specific start and end times.
Timesheet pay period start date
Timesheet pay period end date
Timesheet clocked start time	Shows the time an employee clocked in for their shift. If empty, it means the employee did not perform the "clock in" action.
Timesheet clocked end time	Shows the time an employee clocked out for their shift. If empty, it means the employee did not perform the "clock out" action.
Timesheet clocked total mealbreak time	Shows the total meal break time an employee clocked in and out for. If empty, it means the employee did not perform the "clock in" and/or "clock out" actions for their meal breaks.
Timesheet clocked total time	Shows the total time from when an employee clocked in to when they clocked out. If empty, it means the employee did not perform the "clock in" and/or "clock out" action.

Return to top ^

Training modules

Column Name in Analytics	Notes
Training assignment ID
Training assignment type
Training assignment area
Training module ID
Training module cost
Training module name
Training module comment
Training module created date
Training module created by ID
Training module last modified date
Training module provider
Training module provider address
Training module required completion time
Training module renewal period	Shows how often this training needs to be renewed.
Training module location ID
Training module work type	Shows the type of work linked to this training's assigned area, such as sleepover or non-worked.
Training module area payroll export name	Area name formatted to match your payroll system configuration.
Training module area name
Training module parent area ID
Training module location code
Training module location name
Training module location company number	Shows the company number recorded for this training location.
Training module location parent ID	Internal ID that identifies the parent location for this training location.
Training module location business number	Shows the business number recorded for this training location.
Training module location payroll export code	The code used to map this training location to your payroll system.
Training module creator ID
Training module created by preferred name
Training module area status	Shows the training's assigned area status: Active or Inactive.
Training module location status	Shows the training's location status: Active or Archived.

Return to top ^

Training records

Column Name in Analytics	Notes
Training record ID
Training record type ID
Training record comment
Training record created date
Training record created by ID
Training record employee ID
Training record last modified date
Training module ID
Training module cost
Training module name
Training module comment
Training module created date
Training module created by ID
Training module last modified date
Training module provider
Training module provider address
Training module required completion time
Training module renewal period	Shows how often this training needs to be renewed.
Employee ID
Employee access level ID	Internal ID that identifies the employee’s access level or role.
Employee primary location ID
Employee contact details ID
Employee created date
Employee created by ID
Employee user ID
Employee last modified date
Employee job position
Employee last name
Employee first name
Employee job application ID	Links the employee to their original job application in Deputy Hire.
Employee preferred name
Employee main address ID
Employee onboarding ID
Employee stress profile ID	Internal ID that identifies the stress profile applied to this employee.
Employee hire date
Employee archived date
Employee access level name	Shows the employee’s access level or role in the system.
Employee primary location code
Employee primary location name
Employee primary location company number	Shows the company number recorded for the employee’s primary location.
Employee primary location parent ID	Internal ID that identifies the parent location for the employee’s primary location.
Employee primary location business number	Shows the business number recorded for the employee’s primary location.
Employee primary location payroll export code	The code used to map the primary location to your payroll system.
Employee stress profile name	Shows the name of the stress profile applied to this employee.
Employee stress profile max hours per day	Shows the maximum hours the employee can work in a single day under the stress profile.
Employee stress profile max days per period	Shows the maximum number of days the employee can work in the stress profile period.
Employee stress profile max hours per shift	Shows the maximum hours allowed for a single shift under the stress profile.
Employee stress profile max hours per period	Shows the maximum hours the employee can work in the stress profile period.
Employee stress profile gap hours between shifts	Shows the minimum required rest time between the employee’s shifts under their stress profile.
Employee address city
Employee address po box
Employee address street 1
Employee address street 2
Employee address unit no
Employee address postcode
Employee address suite no
Employee address street no
Employee emergency contact phone number
Employee emergency contact name
Employee UUID	Internal ID used to link this employee across systems.
Employee status	Shows the current employee status: Active or Archived.
Employee gender
Employee pronouns
Employee full name
Employee contact mobile
Employee date of birth
Employee main address
Employee active payroll IDs	Lists the payroll IDs currently active for this employee.
Employee main address state
Employee main address country
Employee custom fields	Shows values stored in the employee’s custom fields.
Training record created by last name
Training record created by first name
Training record created by preferred name
Training record created by full name
Training record expiry date
Training record training date
Training record status	Shows the current team member's training record status: Active or Inactive.

Return to top ^

Deputy Analytics Datasets (S - Z)

Shift audit

Shifts

Shifts & timesheets

Shifts, timesheets & sales

Tasks

Timesheet audit

Timesheet geolocation audit

Timesheet geolocation map

Timesheet pay

Timesheets

Training modules

Training records

Related articles