The Deputy Analytics reports are built on datasets. When building custom reports you use these same datasets as the building blocks of the report to add elements such as tables and graphs.
This article gives a brief overview of the kind of data contained in each dataset.
- Where do I find the Deputy datasets?
-
Deputy datasets
- Current number of employees
- Employee audit (Analytics+ only)
- Employees
- HR Employee audit (HR only)
- HR hire (HR only)
- HR employee documents (HR only)
- HR onboarding (HR only)
- Journals
- Leave balance summary
- Leave requests
- Leave timesheets
- Shift audit (Analytics+ only)
- Shifts
- Shift, timesheets & sales
- Tasks
- Timesheet audit (Analytics+ only)
- Timesheet geolocation audit (Analytics+ only)
- Timesheet geolocation map
- Timesheets
- Training modules
- Training records
- How do I find out exactly what data is in each column in each dataset?
Where do I find the Deputy dataset I need?
When you add a data element to a customised report you will need to select a data source for the data.
From the elements toolbar at the bottom of the screen, select from:
- Table/ Pivot table OR
- one of the charts
If you know the name of the dataset you are looking for, type it in the search field and hit enter.
Alternatively, to see all available datasets, click on Tables and Datasets > Workspaces > Deputy Datasets.
All available Datasets will be listed. Those that appear disabled will require either an Analytics+ add-on subscription or a Deputy HR add-on subscription.
The sections below in this help article outline the data contained in each dataset. You can also preview the dataset to see exactly what columns of data are contained in each dataset.
Deputy Datasets
Current number of employees
| What do the single rows of data represent? | Your business in Deputy |
| What do the columns of data represent? | The total number of employed employees in your business |
| Deputy reports that use this dataset as a source: |
Employee audit (Analytics+ users only)
| What do the single rows of data represent? | A single audit log change related to the aspects of the employee profile |
| What do the columns of data represent? |
Data related to the team member profile information and the user modifying the profile |
| Deputy reports that use this dataset as a source: |
Employees
| What do the single rows of data represent? | A single team member in the business |
| What do the columns of data represent? |
Data related to the team member including their:
|
| Deputy reports that use this dataset as a source: |
HR Employee Audit (HR only)
| What do the single rows of data represent? | A single audit log change related to the aspects of the employee profile |
| What do the columns of data represent? |
Data related to the team member profile information and the user modifying the profile |
| Deputy reports that use this dataset as a source: |
HR hire (HR only)
| What do the single rows of data represent? | A single hire candidate's application |
| What do the columns of data represent? | Data related to a hire candidate, along with:
|
| Deputy reports that use this dataset as a source: |
|
HR employee documents (HR only)
| What do the single rows of data represent? | A single team member's document |
| What do the columns of data represent? | Data related to a team member's document, along with:
|
| Deputy reports that use this dataset as a source: |
|
HR onboarding (HR only)
| What do the single rows of data represent? | A single onboard |
| What do the columns of data represent? | Data related to a team member onboarding, along with:
|
| Deputy reports that use this dataset as a source: |
|
Journals
| What do the single rows of data represent? | A single journal entry |
| What do the columns of data represent? | Data related to a journal entry, along with:
|
| Deputy reports that use this dataset as a source: |
Leave balance summary
| What do the single rows of data represent? | The leave balance and upcoming leave for each team member, aggregated per leave type in hours and days |
| What do the columns of data represent? |
Data related to a team member's leave policy, along with their:
|
| Deputy reports that use this dataset as a source: |
Leave requests
| What do the single rows of data represent? | A single component of a Leave requests (ie. Pay Lines such as a half day of Sick leave and half day of Annual Leave) from a leave request and its corresponding Leave Timesheet |
| What do the columns of data represent? |
Data related to the leave request, along with:
|
| Deputy reports that use this dataset as a source: |
Leave timesheets
| What do the single rows of data represent? | A single leave timesheet for a team member |
| What do the columns of data represent? |
Data related to the leave timesheet, along with:
|
| Deputy reports that use this dataset as a source: |
Locations & areas
| What do the single rows of data represent? | A single area in Deputy |
| What do the columns of data represent? | Data related to areas, along with:
|
| Deputy reports that use this dataset as a source: |
None |
Pay details
| What do the single rows of data represent? | A single pay detail for a team member. A team member may have more than one pay detail. |
| What do the columns of data represent? | Data related to a team member's pay details, along with:
|
| Deputy reports that use this dataset as a source: |
None |
Shift audit (Analytics+ users only)
| What do the single rows of data represent? | A single audit log change in relation to a shift |
| What do the columns of data represent? |
Data related to the shift and the user modifying the shift, along with:
|
| Deputy reports that use this dataset as a source: |
Shifts
| What do the single rows of data represent? | A single shift in Deputy |
| What do the columns of data represent? | Data related to the shift, along with:
|
| Deputy reports that use this dataset as a source: |
Shift, timesheets & sales
| What do the single rows of data represent? | The hours & costs related to shifts & timesheets alongside sales data, aggregated to a daily level. |
| What do the columns of data represent? | Data related to shifts, timesheets, sales and costs |
| Deputy reports that use this dataset as a source: |
Tasks
| What do the single rows of data represent? | A single task |
| What do the columns of data represent? | Data related to individual tasks and group tasks along with task completion actions |
| Deputy reports that use this dataset as a source: |
Timesheet audit (Analytics+ users only)
| What do the single rows of data represent? | A single audit log change in relation to a timesheet |
| What do the columns of data represent? |
Data related to the timesheet and the user modifying the shift, along with:
|
| Deputy reports that use this dataset as a source: |
Timesheet geolocation audit (Analytics+ users only)
| What do the single rows of data represent? |
A single event at either:
|
| What do the columns of data represent? |
Data related to the team member, timesheet and geolocation information, along with:
|
| Deputy reports that use this dataset as a source: |
Timesheet geolocation map
| What do the single rows of data represent? |
A single event at either:
|
| What do the columns of data represent? | Geolocation details of Locations, Areas, Timesheets |
| Deputy reports that use this dataset as a source: |
Timesheets
| What do the single rows of data represent? | A single timesheet in Deputy |
| What do the columns of data represent? | Data related to the timesheet, along with:
|
| Deputy reports that use this dataset as a source: |
Training modules
| What do the single rows of data represent? | A single training module in a business |
| What do the columns of data represent? | Data related to training modules and the areas they are assigned to |
| Deputy reports that use this dataset as a source: |
Training records
| What do the single rows of data represent? | A single training record that a team member has completed, including expiry information. |
| What do the columns of data represent? | Data related to training modules, training records and team member information |
| Deputy reports that use this dataset as a source: |
How do I find out exactly what data is in each column in each dataset?
Some of the datasets have so many columns that it would be unwieldy to list them all in this article. The easiest way to find a list of the data in each column in a data set is to open a blank custom report.
1. From the left-hand side menu click the + icon.
2. Give your report a name, click on Blank template and click Create report.
3. Add a data element such as a Table.
When selecting the source for the table you will be presented with the list of datasets, and you can click Preview to view the data in each dataset.