CData Python Connector for ADP

Build 23.0.8839

TeamTimeCardsPeriodTotals

View the Team Time Cards period totals aggregate.

Table Specific Information

Select

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

  • ManagerOID supports the '=' comparison.

SELECT * FROM TeamTimeCardsPeriodTotals WHERE ManagerOID = 'G3349PZGBADQY8H7'

Columns

Name Type References Description
AssociateOID String

Workers.AssociateOID

WorkerID String
TimeCardID String
payCodecodeValue String
RateBaseMultiplierValue String
RateAmountValue Double
RateCurrencyCode String
TimeDuration String
ManagerOID String

Workers.AssociateOID

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
periodCodeValue String Supported values: current, next, previous, etc.
TimePeriodStartDate String

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