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. |