JDBC Driver for Paylocity

Build 23.0.8839

Input_TimeEntry

To create the csv content for the CreatePayEntryImportBatch.TimeEntry using this as a TEMP Table. When the connection to Paylocity is closed, all tables names started with Input are cleared.

Columns

Name Type ReadOnly References Description
EmployeeId String False

Id of the Employee

Det String False

Identifies the type of record being imported. Use E for earning, D for deduction, or A for accrual balances.

DetCode String False

The earning or benefit code. This must be a code currently defined for the company.

Hours Double False

The number of hours worked by the employee or the used accrual hours.

Amount Integer False

The dollar amount to pay the employee or the available accrual hours. If an amount is entered, any information entered in the hours, rate, and rateCode fields will be ignored.

TempRate String False

The employee's pay rate. If no rate is entered, the system will use the employee's base rate.

RateCode String False

The company defined rate code used for paying the employee. If a rate code is entered, the system will ignore the value in the rate field.

CostCenter1 String False

Use this field to enter an override value for the first level cost center charged by the employee.

CostCenter2 String False

Use this field to enter an override value for the second level cost center charged by the employee.

CostCenter3 String False

Use this field to enter an override value for the third level cost center charged by the employee. If entering a value for CC3, also enter values for CC1 and CC2.

JobCode String False

This field is used to enter an override company defined job code to be charged by the employee.

Shift String False

This field is used to enter an override company defined shift code to be charged by the employee.

BeginDate String False

Begin Date associated with this line item.

EndDate String False

End Date associated with this line item.

WorkersCompCode String False

The company defined workers comp code for the work performed by the employee.

TCode1 String False

Not used unless directed by service bureau (State override). When used the state override entered must be different than the employees home tax code setup otherwise this will result in blank check data.

TCode2 String False

Not used unless directed by service bureau (Local 1 override). When used the state override entered must be different than the employees home tax code setup otherwise this will result in blank check data.

TCode3 String False

Not used unless directed by service bureau (Local 2 override). When used the state override entered must be different than the employees home tax code setup otherwise this will result in blank check data.

TCode4 String False

Not used unless directed by service bureau (Do not use).

Sequence String False

Use this field to indicate multiple checks.

CheckType String False

Use this field to indicate an override Check Type.

CheckNumber String False

Use this field to indicate an override check Number. It is only valid when Check Type is 'Manual'. Check number for regular checks is assigned during processing.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839