JDBC Driver for ADP

Build 22.0.8462

TimeCards

View the worker Time Cards.

Table Specific Information

Select

The driver will use the ADP API to process WHERE clause conditions built with the following column and operator. The AssociateOID is required to make a request and the rest of the filter is executed client side within the driver.

  • AssociateOID supports the '=' comparison.

SELECT * FROM TimeCards WHERE AssociateOID = 'G3349PZGBADQY8H7'

Columns

Name Type References Description
AssociateOID String

Workers.AssociateOID

WorkerID String
TimeCardID String
PersonLegalName String
PersonLegalFamilyName1 String
PersonLegalFormattedName String
ProcessingStatusCodeValue String
ProcessingStatusCodeShortName String
periodCodeValue String Supported values: current, next, previous, etc.
periodCodeShortName String
periodCodeLongName String
TimePeriodStartDate Date
TimePeriodEndDate Date
TimePeriodPeriodStatus String
PositionID String
ExceptionCounts String
PeriodTotals String
DailyTotals String
TotalPeriodTimeDuration String
HomeLaborAllocations String
Actions String

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462