Scheduled Extract Report - Payrolls

Overview

When Payrolls is selected in Requested Data, the report will return the information on individual pays outlined in the table below.

Field Name	Data Type	Information
Payroll_PID	Integer (Unsigned)	The primary key for a payroll/pay run
Payroll_GroupID	String	Any pay that share a Payroll_GroupID will be grouped together in transactions
Timesheet_TSID	Integer (Unsigned)	The ID of the timesheet linked to the payroll, if any
ExpenseReport_ERID	Integer (Unsigned)	The ID of the Expense Report linked to the pay, if any
ExpenseCategory_CID	Integer (Unsigned)	The ID of the Expense Category linked to the pay, if any
Date	Date	The date applied to the pay when it is calculated
PayDate	Date	The date on which the pay was paid
Type	String	The type assigned to the payroll, For example: Pay (Expense), Pay (Timesheet), Tax, Recoverable Deduction, Lump Sum Payment
Type_ID	Integer (Unsigned)	The related ID of the item in the Type column
Units	Decimal	The number of units in the pay
PayRate	Decimal	The pay rate in the pay
Amount	Decimal	The amount in the pay
Status	String	The status of the pay
Employee_MID	Integer (Unsigned)	The employee ID of the employee in the pay
Job_UID	Integer (Unsigned)	The job ID for the job included in the pay Not all pays are associated with a job, though they will always belong to an employee
HasBeenEdited	Boolean (Yes/No)	Whether or not the pay has been manually edited at any point
LeaveManagementType_ LM_type_id	Integer	The ID of the leave type to which this Payroll belongs If = 0 then this Payroll entity does not denote leave taken; if < 0 then this Payroll entity denotes subtraction of base hours for retroactive leave applications
LeaveMultiplier	Decimal	The rate at which the pay is multiplied for leave purposes
PayRun_payrun_id	Integer (Unsigned)	The Pay Run ID associated with the pay, if any
Notes	String	Any additional notes that have been included on the pay