Variable | Description |
client_name_in |
The name of the clock where this employee clocked in, if it exists |
client_name_out |
The name of the clock where the employee clocked out if it exists |
clock_in_note |
The clock in note provided |
clock_out_note |
The clock out note |
code_name |
The code associated with the event, such as "standardtime" or "overtime" |
payrollEventType |
The type of event such as "Standardtime" or "Overtime" |
customer_name |
The name of any customer associated with a job |
duration |
The duration of the payroll event in seconds |
empNum |
The employee's alternate number |
eventLogID |
The unique database ID of the clock event pair |
isHourly |
1 if the employee is hourly, 0 if they are not |
job_altNum |
The alternate number on the job worked |
job_category |
The name of the category on the job worked |
job_code |
The code of the job worked |
job_ctrlNum |
The control number of the job worked |
job_glNum |
The G.L. number of the job worked |
job_longname |
The full name of the job worked |
job_rate |
The billing rate associated with the job worked |
job_shortname |
The shortened display name of the job worked |
job_subCode |
The subcode of the job worked |
job_overrideHourlyRate |
The overriding hourly rate of the job worked |
job_overrideDifferential |
The hourly differential of the job worked |
job_overrideMultiplier |
The rate multiplier of the job worked |
occurs |
A unix timestamp that marks the beginning of this payroll event |
orgUnit |
The name of the employee's Organizational Unit |
pay_per_hour |
The total pay per hour for the event including differentials and overtime |
payRate |
The hourly rate for the event including differentials but no overtime |
reg_hourly_rate |
The employee's normal hourly rate |
base_rate |
The FLSA weekly base hourly rate |
SSN |
The employee's social security number |
lastFirstMid |
The employee's name in Last First Middle format. |
firstMidLast |
The employee's name in First Middle Last format |
userName |
The employee's name in whatever format was selected in the QuickBooks preset |
payroll_type_name |
The name of the employee's payroll type |
usersID |
The unique database ID of the employee |