| Note: From October 1st, 2025, we introduced new plans that better reflect how our customers use Deputy: Lite, Core, and Pro. If you're an existing customer, look out for an email with all the details you’ll need. Learn more about the new plans and what this change means for you. |
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 (A - R)
Below is a list of all Analytics Datasets (A - R), 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).
Go to → [ Data Dictionary Overview ] [ Glossary of Terms ] [ Datasets (A - R) ] [ Datasets S - Z ]
Current number of employees
Column Name in Analytics |
Notes |
Current Employed Employees |
|
Employee audit
Column Name in Analytics |
Notes |
Modified type |
Shows the type of change made, such as create, update, or delete. |
Employee ID |
|
Modified field |
|
Modified date |
|
Modified by ID |
|
Modified by session data |
Technical session details captured when this record was modified. |
Modified by name |
|
Modified by email |
|
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. |
Old value |
|
New value |
|
Employee is deleted |
|
Employees
Column Name in Analytics |
Notes |
Employee created date |
|
Employee created by ID |
|
Employee last modified date |
|
Employee job application ID |
Links the employee to their original job application in Deputy Hire. |
Employee onboarding ID |
|
Employee primary location name |
|
Employee primary location company number |
Shows the company number recorded for the employee’s primary location. |
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. |
Employe 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 primary location hierarchy |
Shows where the primary location sits in the company location hierarchy. |
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 contact email |
|
Employee regular working hours effective date |
Shows the date the current regular working hours arrangement starts from. |
Employee regular working hours work period length |
Shows the length of the work period used for regular hours. |
Employee regular working hours total hours per period |
Shows the total regular working hours in each pay period. |
Employee regular working hours days worked per period |
Shows how many days the employee regularly works in each pay period. |
Last timesheet date |
|
Next shift date |
|
Employee primary pay rate employment type |
Shows the employment type linked to the employee’s primary pay rate. |
Return to top ^
HR company document acknowledgements
| Column Name in Analytics | Notes |
Document link ID |
|
Document ID |
|
Document recipient ID |
|
Document title |
|
Document type |
Shows the main document type used for categorisation. |
Document sharer ID |
|
Document shared date |
Shows the date the document was shared with employees. |
Document acknowledged date |
Shows the date the employee acknowledged receiving the document. |
Document acknowledgement status |
Shows the current acknowledgement status for this document. |
Recipient last name |
|
Recipient first name |
|
Recipient preferred name |
|
Sharer last name |
|
Sharer first name |
|
Sharer preferred name |
Return to top ^
HR company documents
| Column Name in Analytics | Notes |
Document ID |
|
Document title |
|
Document type |
Shows the main document type used for categorisation. |
Document status |
Shows the current status of the document. |
Document acknowledgement required |
Indicates whether employees are required to acknowledge this document. |
Document acknowledgements received |
The number of employees who have acknowledged this document. |
Document acknowledgements outstanding |
The number of employees who still need to acknowledge this document. |
Document shared with location IDs |
Lists the IDs of locations the document is shared with. |
Document shared with location names |
Lists the names of locations the document is shared with. |
Document shared with role IDs |
Lists the IDs of roles the document is shared with. |
Document shared with role names |
Lists the names of roles the document is shared with. |
Document upload date |
|
Document uploaded by ID |
|
Document modified date |
|
Document modified by ID |
|
Uploader access level name |
Shows the access level of the person who uploaded this file or record. |
Uploader last name |
|
Uploader first name |
|
Uploader preferred name |
|
Uploader primary location ID |
|
Uploader primary location name |
|
Uploader primary location code |
|
Modifier access level name |
Shows the access level of the person who made this change. |
Modifier last name |
|
Modifier first name |
|
Modifier preferred name |
|
Modifier primary location ID |
|
Modifier primary location name |
|
Modifier primary location code |
HR employee payroll details AU
Column Name in Analytics |
Notes |
Employee ID |
|
Bank details ID |
|
Bank account holder name |
|
Bank account number |
|
Bank BSB |
|
Bank details approval status |
|
Bank details approved by ID |
|
Bank details last updated by ID |
|
Bank details version |
|
Bank details approved date |
|
Bank details created date |
|
Bank details updated date |
|
Tax declaration ID |
|
Tax file number status |
Shows whether a valid tax file number has been provided. |
Tax file number |
|
Tax file employment type |
|
Tax file residency status |
Shows the employee’s tax residency status: Australian resident, Foreign resident, Working holiday maker, or Residency type unknown. |
Tax file tax free threshold active |
Indicates whether the tax-free threshold has been claimed. |
Tax file loan active |
Indicates whether a study or tax-related loan is active. |
Tax file number reason |
Explains why a tax file number has not been provided. |
Tax file country of origin |
|
Tax file approval status |
Shows the employee's tax details approval status: Approved, Pending, Rejected, or Unknown. |
Tax file approved by ID |
|
Tax file last updated by ID |
|
Tax file version |
|
Tax file details approved date |
|
Tax file details created date |
|
Tax file details updated date |
|
Superannuation ID |
|
Superannuation eligibility |
Indicates whether the employee is eligible to receive superannuation contributions. |
Superannuation fund type |
Shows the type of super fund, such as APRA-regulated or SMSF. |
Superannuation USI |
|
Superannuation member number |
|
SMSF status |
Indicates whether the employee uses a self-managed super fund (SMSF). |
SMSF BSB |
|
SMSF account number |
|
SMSF ESA |
|
SMSF bank account name |
|
SMSF ABN |
|
Superannuation approval status |
Shows the current superannuation approval status: Approved, Pending, Rejected, or Unknown. |
Superannuation approved by ID |
|
Superannuation last updated by ID |
|
Superannuation version |
|
Superannuation approved date |
|
Superannuation created date |
|
Superannuation updated date |
|
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 hire date |
|
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 archived date |
|
Employee reason for leaving |
|
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. |
Employee contact email |
HR employee documents
Column Name in Analytics |
Notes |
Document ID |
|
Document type |
Shows the main document type used for categorisation. |
Document name |
Shows the title of the document in the system. |
Document status |
Shows the current status of the document. |
Requested date |
The date the document was requested. |
Actioned date |
The date the document was submitted, or updated. |
Expiry date |
Indicates when the document will no longer be valid. |
Template ID |
|
Document file size |
Shows the size of the uploaded document (e.g., 20MB). |
Document file type |
Shows the format of the file (e.g., image, PDF). |
Uploader ID |
|
Request ID |
|
Employee ID |
|
Document sub type |
Shows the document subtype used for internal categorisation. |
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 |
The employee's position title. |
Employee last name |
|
Employee first name |
|
Employee job application ID |
Links the employee to their original job application in Deputy Hire. |
Employee preferred name |
Shows how the employee's name appears under the 'Preferred name' field. |
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. |
Username |
|
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 contact email |
|
Uploader primary location ID |
|
Uploader last name |
|
Uploader first name |
|
Uploader preferred name |
|
Uploader access level name |
Shows the access level of the person who uploaded this file or record. |
Uploader primary location code |
|
Uploader primary location name |
|
Uploader full name |
HR hire
Column Name in Analytics |
Notes |
Candidate application ID |
|
Job ID |
|
Candidate first name |
|
Candidate last name |
|
Candidate email |
|
Candidate mobile phone |
|
Candidate address |
|
Candidate application submitted date |
|
Candidate application last modified date |
|
Candidate application last modified by ID |
|
Job title |
|
Job location ID |
|
Job location name |
|
Job description |
|
Job created date |
|
Job created by ID |
|
Job last modified date |
|
Job last modified by ID |
|
Job creator last name |
|
Job creator first name |
|
Job creator preferred name |
|
Job creator access level name |
|
Job creator primary location code |
|
Job creator primary location name |
|
Job creator full name |
|
Job last modifier last name |
|
Job last modifier first name |
|
Job last modifier preferred name |
|
Job last modifier access level name |
|
Job last modifier primary location code |
|
Job last modifier primary location name |
|
Job last modifier full name |
|
Candidate application last modifier last name |
|
Candidate application last modifier first name |
|
Candidate application last modifier preferred name |
|
Candidate application last modifier access level name |
Shows the access level of the person who last updated the application. |
Candidate application last modifier primary location code |
|
Candidate application last modifier primary location name |
|
Candidate application last modifier full name |
|
Job board name |
|
Candidate application status |
|
Job employment type |
|
Job status |
HR kudos
Column Name in Analytics |
Notes |
Kudos ID |
|
Kudos source |
Shows where the Kudos was sent from: Chat, Slack or HR. |
Kudos message |
|
Kudos given |
|
Kudos date |
|
Kudos modified date |
|
Kudos author ID |
|
Kudos author access level ID |
|
Kudos author primary location ID |
|
Kudos author contact details ID |
|
Kudos author created date |
|
Kudos author created by ID |
|
Kudos author user ID |
|
Kudos author last modified date |
|
Kudos author job position |
|
Kudos author last name |
|
Kudos author first name |
|
Kudos author job application ID |
|
Kudos author hire date |
|
Kudos author preferred name |
|
Kudos author main address ID |
|
Kudos author onboarding ID |
|
Kudos author stress profile ID |
Internal ID that identifies the stress profile applied to the Kudos author. |
Kudos author archived date |
|
Kudos author access level name |
|
Kudos author primary location code |
|
Kudos author primary location name |
|
Kudos author primary location company number |
|
Kudos author primary location parent ID |
|
Kudos author primary location business number |
|
Kudos author primary location payroll export code |
|
Kudos author stress profile name |
Shows the name of the stress profile applied to the Kudos author. |
Kudos author stress profile max hours per day |
Shows the maximum hours the author can work in a single day under the stress profile. |
Kudos author stress profile max days per period |
Shows the maximum number of days the author can work in the stress profile period. |
Kudos author stress profile max hours per shift |
Shows the maximum hours allowed for a single shift under the author’s stress profile. |
Kudos author stress profile max hours per period |
Shows the maximum hours the author can work in the stress profile period. |
Kudos author stress profile gap hours between shifts |
Shows the minimum required rest time between shifts in the author’s stress profile. |
Kudos author address city |
|
Kudos author address po box |
|
Kudos author address street 1 |
|
Kudos author address street 2 |
|
Kudos author address unit no |
|
Kudos author address postcode |
|
Kudos author address suite no |
|
Kudos author address street no |
|
Kudos author emergency contact phone number |
|
Kudos author emergency contact name |
|
Kudos author UUID |
Internal ID used to link the Kudos author across systems. |
Kudos author status |
|
Kudos author gender |
|
Kudos author pronouns |
|
Kudos author full name |
|
Kudos author contact mobile |
|
Kudos author date of birth |
|
Kudos author main address |
|
Kudos author active payroll IDs |
|
Kudos author main address state |
|
Kudos author main address country |
|
Kudos author custom fields |
|
Kudos author contact email |
|
Kudos recipient ID |
|
Kudos recipient access level ID |
|
Kudos recipient primary location ID |
|
Kudos recipient contact details ID |
|
Kudos recipient created date |
|
Kudos recipient created by ID |
|
Kudos recipient user ID |
|
Kudos recipient last modified date |
|
Kudos recipient job position |
|
Kudos recipient last name |
|
Kudos recipient first name |
|
Kudos recipient job application ID |
|
Kudos recipient hire date |
|
Kudos recipient preferred name |
|
Kudos recipient main address ID |
|
Kudos recipient onboarding ID |
|
Kudos recipient stress profile ID |
Internal ID that identifies the stress profile applied to the Kudos recipient. |
Kudos recipient archived date |
|
Kudos recipient access level name |
|
Kudos recipient primary location code |
|
Kudos recipient primary location name |
|
Kudos recipient primary location company number |
Shows the company number recorded for the recipient’s primary location. |
Kudos recipient primary location parent ID |
Internal ID that identifies the parent location for the recipient’s primary location. |
Kudos recipient primary location business number |
Shows the business number recorded for the recipient’s primary location. |
Kudos recipient primary location payroll export code |
The code used to map the recipient’s primary location to your payroll system. |
Kudos recipient stress profile name |
Shows the name of the stress profile applied to the Kudos recipient. |
Kudos recipient stress profile max hours per day |
Shows the maximum hours the recipient can work in a single day under the stress profile. |
Kudos recipient stress profile max days per period |
Shows the maximum number of days the recipient can work in the stress profile period. |
Kudos recipient stress profile max hours per shift |
Shows the maximum hours allowed for a single shift under the recipient’s stress profile. |
Kudos recipient stress profile max hours per period |
Shows the maximum hours the recipient can work in the stress profile period. |
Kudos recipient stress profile gap hours between shifts |
Shows the minimum required rest time between shifts in the recipient’s stress profile. |
Kudos recipient address city |
|
Kudos recipient address po box |
|
Kudos recipient address street 1 |
|
Kudos recipient address street 2 |
|
Kudos recipient address unit no |
|
Kudos recipient address postcode |
|
Kudos recipient address suite no |
|
Kudos recipient address street no |
|
Kudos recipient emergency contact phone number |
|
Kudos recipient emergency contact name |
|
Kudos recipient UUID |
Internal ID used to link the Kudos recipient across systems. |
Kudos recipient status |
Shows the current kudos recipient status: Active or Archived. |
Kudos recipient gender |
|
Kudos recipient pronouns |
|
Kudos recipient full name |
|
Kudos recipient contact mobile |
|
Kudos recipient date of birth |
|
Kudos recipient main address |
|
Kudos recipient active payroll IDs |
|
Kudos recipient main address state |
|
Kudos recipient main address country |
|
Kudos recipient custom fields |
|
Kudos recipient contact email |
HR onboarding
Column Name in Analytics |
Notes |
Tenant name |
|
Employee ID |
|
Onboarding employee first name |
|
Onboarding employee last name |
|
Onboarding employee email |
|
Onboarding employee mobile |
|
Onboarding employee mobile country code |
|
Onboarding employee country code |
|
Onboarding employee locale |
Shows the language and region settings used for the employee’s onboarding. |
Onboarding employee preferred name |
|
Onboarding ID |
|
Onboarding status |
|
Onboarding manager ID |
|
Onboarding location ID |
|
Onboarding business number |
|
Onboarding employment start date |
|
Onboarding start date |
|
Onboarding last updated date |
|
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. |
Username |
|
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 contact email |
|
Onboarding manager primary location ID |
|
Onboarding manager last name |
|
Onboarding manager first name |
|
Onboarding manager preferred name |
|
Onboarding manager access level name |
Shows the access level of the manager overseeing this onboarding. |
Onboarding manager primary location code |
|
Onboarding manager primary location name |
|
Onboarding manager full name |
Journals
Column Name in Analytics |
Notes |
Journal ID |
|
Journal comment |
|
Journal created date |
|
Journal created by ID |
|
Journal last modified date |
|
Employee ID |
|
Journal date |
|
Journal category ID |
|
Journal Group |
|
Journal category created date |
|
Journal category created by ID |
|
Journal category last modified date |
|
Journal category sort order |
|
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 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 primary location status |
|
Journal creator full name |
|
Journal category name |
Leave balance summary
Column Name in Analytics |
Notes |
Employee ID |
|
Employee full name |
|
Employee preferred name |
|
Employee first name |
|
Employee last name |
|
Employee status |
Shows the current employee status: Active or Archived. |
Employee primary location ID |
|
Employee primary location code |
|
Employee primary location name |
|
Leave policy ID |
|
Leave policy name |
|
Upcoming leave (hours) |
Shows the employee’s upcoming approved leave in hours. |
Upcoming leave (days) |
Shows the employee’s upcoming approved leave in days. |
Leave balance (days) |
|
Leave balance (hours) |
|
Standard hours type |
|
Standard hours |
|
Leave policy unit |
|
Employee primary pay rate employment type |
Shows the employment type linked to the employee’s primary pay rate. |
Leave requests
Column Name in Analytics |
Notes |
Leave request ID |
|
Leave request total days |
|
Leave request comment |
|
Leave request creation date |
|
Leave request created by ID |
|
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 date |
|
Leave request pay line ID |
|
Leave request pay line cost |
|
Leave request pay line total hours |
|
Leave request pay line comment |
|
Leave request pay line created date |
|
Leave request pay line created by ID |
|
Leave request pay line modified date |
|
Leave request pay line leave policy ID |
|
Leave request pay line timesheet ID |
|
Leave request pay line employee agreement ID |
Internal ID that identifies the employment agreement linked to this leave pay line. |
Leave request pay line date |
|
Leave request pay line start time |
|
Leave request pay line end 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 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. |
Leave request pay approved by full name |
|
Leave request created by full name |
|
Leave request time approved by full name |
|
Leave request pay line created by full name |
|
Leave request leave policy type |
Shows the leave policy group or type used for reporting. |
Leave request leave policy accrual reset period |
Shows how often leave accrual for this policy is reset. |
Leave request leave policy description |
Short description of the leave policy used for this request. |
Leave request leave policy export type |
Shows how this leave policy is exported to your payroll system. |
Leave request leave policy reset value |
Shows the leave balance value applied when this policy resets. |
Leave request leave policy reset schedule |
Shows when this leave policy balance is scheduled to reset. |
Leave request leave policy export code |
The code used to map this leave policy to your payroll system. |
Leave request pay line leave policy type |
Shows the leave policy group or type used for this pay line. |
Leave request pay line leave policy accrual reset period |
Shows how often leave accrual for this policy is reset. |
Leave request pay line leave policy description |
|
Leave request pay line leave policy export type |
Shows how this leave type is exported to your payroll system. |
Leave request pay line leave policy reset value |
Shows the balance value applied when this leave policy resets. |
Leave request pay line leave policy reset schedule |
Shows when this leave policy balance is scheduled to reset for this line. |
Leave request pay line leave policy export code |
The code used to map this leave type to your payroll system. |
Employee pay detail ID |
|
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 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 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 salary pay rule is exported |
Indicates whether the salary pay rule is sent to payroll. |
Employee area regular rate |
|
Timesheet ID |
|
Timesheet cost |
|
Shift ID |
|
Timesheet created date |
|
Timesheet created by 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 |
|
Timesheet pay period ID |
|
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 |
|
Timesheet pay detail ID |
Internal ID that identifies the pay agreement applied to this timesheet. |
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 pay approved |
Indicates whether pay was automatically approved based on location settings. |
Timesheet auto time approved |
Indicates whether times were automatically approved based on location settings. |
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 |
|
Timesheet area payroll export name |
Area name formatted to match your payroll system configuration. |
Timesheet area name |
|
Timesheet parent area ID |
|
Timesheet area name with location code |
Shows the area name combined with its location code. |
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 id |
|
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. |
Area is deleted |
|
Location is deleted |
|
Timesheet status |
Shows the current timesheet status: Upcoming, On shift, Absent, Late, Pending, Time approved, Pay approved, Discarded, Exported, or Paid. |
Leave request status |
|
Leave request end time |
|
Leave request start time |
|
Standard hours type |
|
Standard hours |
|
Leave request leave policy unit |
Shows the unit used for this leave policy, such as hours or days. |
Leave request pay line leave policy name |
|
Leave request leave policy name |
|
Timesheet leave policy name |
|
Leave request is all day |
|
Leave request leave policy is visible |
|
Leave request leave policy is paid |
Internal ID that identifies whether this leave request will be paid or unpaid. |
Leave request leave policy rolls over |
Indicates whether unused leave from this policy carries over to the next year. |
Leave request pay line leave policy is visible |
|
Leave request pay line leave policy is paid |
|
Leave request pay line leave policy rolls over |
Indicates whether unused leave from this policy carries over to the next year. |
Leave request pay line start date |
|
Leave request pay line end date |
|
Timesheet pay period start date |
|
Timesheet pay period end date |
Leave 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 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 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 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 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. |
Employee primary location timezone |
|
Timesheet time approved by full name |
|
Timesheet created by full 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 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. |
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 location timezone |
|
Leave request leave policy unit |
Shows the unit used for this leave policy, such as hours or days. |
Timesheet pay period start date |
|
Timesheet pay period end date |
Locations & areas
Column Name in Analytics |
Notes |
Area ID |
|
Area colour |
|
Location ID |
|
Area created date |
|
Area created by ID |
|
Area last modified date |
|
Area work type |
Shows the type of work linked to this area (for example, sleepover). |
Area schedule sort order |
Shows the custom order used to display this area on schedules. |
Area payroll export code |
The code used to map this area to your payroll system. |
Area name |
|
Area parent ID |
|
Location code |
|
Location created date |
|
Location created by ID |
|
Location last modified date |
|
Location name |
|
Location company number |
|
Location parent ID |
|
Location business number |
|
Location payroll export code |
The code used to map this location to your payroll system. |
Area address city |
|
Area address po box |
|
Area address street 1 |
|
Area address street 2 |
|
Area address unit no |
|
Area address postcode |
|
Area address suite no |
|
Area address street no |
|
Location address city |
|
Location address po box |
|
Location address street 1 |
|
Location address street 2 |
|
Location address unit no |
|
Location address postcode |
|
Location address suite no |
|
Location address street no |
|
Area status |
|
Area is deleted |
|
Location status |
Shows the current location status: Active or Archived. |
Location is deleted |
|
Area shown on schedule |
Indicates whether this area is visible on the schedule (Enterprise only). |
Area has address |
|
Area address |
|
Location address |
Pay details
Column Name in Analytics |
Notes |
Pay detail ID |
|
Pay detail created date |
|
Pay detail created by ID |
|
Pay rate ID |
|
Pay detail last modified date |
|
Pay centre ID |
Internal ID that identifies the pay centre used for this group of employees. |
Pay calendar ID |
|
Pay period ID |
Internal ID that identifies the pay period schedule linked to this contract. |
Payroll ID |
Internal ID that identifies this employee or contract in your payroll system. |
Employee ID |
|
Salary pay rule ID |
Internal ID that identifies the salary pay rule applied to this employee’s contract. |
Classification ID |
|
Pay rate name |
|
Pay rate created date |
|
Pay rate created by ID |
|
Pay rate last modified date |
|
Pay rate employment type ID |
Internal ID that identifies the employment type linked to this pay rate. |
Standard hours |
|
Pay period name |
|
Pay period length ID |
Internal ID that identifies the pay period frequency, such as weekly or fortnightly. |
Pay period created date |
|
Pay period created by ID |
|
Pay period last modified date |
|
Pay period start date |
|
Salary pay rule name |
|
Annual salary |
|
Salary pay rule export code |
The code used to map this salary pay rule to your payroll system. |
Pay calendar name |
|
Pay calendar payment frequency |
|
Pay calendar business number |
|
Pay calendar created by ID |
|
Pay calendar created date |
|
Pay calendar last modified date |
|
Pay calendar start date |
|
Pay calendar payment date |
|
Pay centre name |
|
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 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. |
Pay rate regular rate |
Shows the employee’s regular base pay rate for this condition. |
Pay detail locations |
Lists the locations covered by this employee’s pay agreement. |
Pay rate employment type |
Shows the employment type this pay rate applies to, such as full-time. |
Pay period length name |
Shows the pay period frequency name, such as weekly or monthly. |
Pay detail status |
Shows the current employee pay agreement status: Active or Archived. |
Salary pay rule is exported |
Indicates whether this salary pay rule is sent to your payroll system. |
Area regular rate |
|
Pay calendar status |