ODBC Driver for Workday

Build 24.0.9060

WorkersTimeTotals

Retrieves a summary of reported hours for a worker over a period.

Workday Resource Information

Retrieves a summary of reported hours for a worker over a period. The period contains the specified date or, if not specified, it contains today's date.

Secured by: Process: Time Block REST APIs, Process: Time Clock Event REST API's

Scope: Time Tracking

Aggregate Fields

The driver represents the following fields as aggregates containing JSON text. Each of them conforms to their respective schema. Fields marked with an asterisk are required and must be included if their parent object is.

This information is derived from the Workday REST API specification which does not explicitly list all business rules and validations that apply to each object. More fields may be required than what is listed here.

Totals_Aggregate


[{
  label: Text /* Contains the label for this total calculation. */
  quantity: Numeric /* Contains the calculated sum for this total. */
  totalNumber: Numeric /* Contains the ordered number of this total calculation. */
}]

Columns

Name Type Description
Workers_Id [KEY] String The Workday ID of the Workers that owns this.
CertifyText String Supported for: SELECT. Contains legal text the user must agree to in order to certify hours worked.
PeriodLabel String Supported for: SELECT. Contains the summary of the date range and total reported hours of a period.
SubmitText String Supported for: SELECT. Contains legal text the user must agree to in order to submit hours for review.
Totals_Aggregate String Supported for: SELECT. A JSON aggregate. List of all Totals defined in Time Entry Template
PeriodDate_Prompt Date Contains the specified date used to match to a period containing the date. The default is today's date.
IncludeTerminatedWorkers_Prompt Bool Only used when a Workers_Id filter is not provided. Include terminated workers in the output
Search_Prompt String Only used when a Workers_Id filter is not provided. Searches workers by name or worker ID. The search is case-insensitive. You can include space-delimited search strings for an OR search.

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