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 |
|
Budget & actuals
Column Name in Analytics |
Notes |
Date |
|
Area ID |
|
Area name |
|
Area status |
|
Location ID |
|
Location code |
|
Location name |
|
Location status |
|
Location hierarchy |
Shows where this location sits in your business location heirarchy. |
Is leave |
|
Schedule on-cost percent |
Shows the on-cost percentage applied to scheduled labour costs. |
Actual sales |
|
Budgeted hours |
|
Budgeted cost |
|
Actual required staff |
|
Actual hours |
|
Actual cost |
|
Actual costs including on-cost |
|
Scheduled hours |
|
Scheduled cost |
|
Scheduled cost including on-cost |
Total scheduled labour cost including on-costs like superannuation or insurance. |
Actual salary cost |
|
Actual salary cost including on-cost |
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 |