Scheduled Extract Report - Employees Entities

Overview

When Employees is selected in Requested Data, the report will return the following details:

Field Name	Data Type	Information
Employee_MID	Integer (Unsigned)	The Employee ID
Employee_id	String	The ID the employee would use to log in (eg firstname.lastname)
PayType	String	The pay type assigned to the employee (eg PAYG, Subcontractor)
IsLocked	Boolean (Yes/No)	Whether or not the employee is currently restricted from logging in
PayrollEntity-Company ManagementCompany_CM_CID	Integer (Unsigned)	The foreign key of the payroll entity (a CompanyManagementCompany entity) to which this employee belongs
NameLast	String	The last name of the employee
NameFirst	String	The first name of the employee
NameMiddle	String	The middle name of the employee
TFN	String	The tax file number belonging to the employee
Email	String	The primary contact email address of the employee
PaySlipEmail	String	The email address at which the employee wishes to receive their payslip. If empty, the primary contact email is used
IsEmailOptedOut	Boolean (Yes/No)	Whether or not an employee is opted out of receiving system email
DateOfBirth	Date	The date of birth of the employee
AddressStreet	String	The street address of the employee
AddressTown	String	The city/town/suburb of the employee
AddressState	String	The state and country of the employee
AddressPostCode	String	The postcode of the employee
IsPayrollReady	Boolean (Yes/No)	Whether or not the employee is marked as Payroll Ready
EmploymentStartDate	Date	The date the employee originally started working
PermissionGroup	String	The name of the employee permission group
EngagementType	String	The engagement type of the employee (Casual, Part Time, Full Time)
BankAccountName	String	The name of the bank account as defined in the employee profile
BackAccountNumber	String	The bank account number as defined in the employee profile Even though it is a number, it is a String data type so leading zeroes are not dropped where they apply
BankAccountBSB	String	The bank account BSB as defined in the employee profile Even though it is a number, it is a String data type so leading zeroes are not dropped where they apply
RemoteID	String	The remote ID used to access this employee through the API
CreationDateTimeUTC	Date/Time (UTC)	The date and time the employee was created in universal time