Tableau Connector for Workday

Build 25.0.9434

WorkerTimeBlocksCalculatedTimeDetails

Fetches detailed calculations applied to worker time blocks, including adjustments for overtime, breaks, and pay rate variations.

Workday Resource Information

Retrieves a worker time block with the specified ID.

Secured by: Process: Time Block REST APIs

Scope: Time Tracking

Aggregate Fields

The connector 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. Fields marked with a hyphen are read-only and must not be included when calling stored procedures or when performing an INSERT or UPDATE.

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.

CalculationTags_Aggregate


[{
  descriptor: Text /* A preview of the instance */
  id: Text /* Id of the instance */
}]

Columns

Name Type Description
Id [KEY] String A unique identifier for the time block instance, used for system reference and reporting.
WorkerTimeBlocks_Id [KEY] String The Workday ID of the parent WorkerTimeBlocks instance that contains this time block, linking the time block to its worker.
CalculatedDate Datetime The system-calculated date for a time block, based on business rules such as shift start times and adjustments.
CalculatedInTimeZone_Descriptor String A human-readable description of the time zone where the in-time for the time block was calculated.
CalculatedInTimeZone_Href String A URL link to the Workday instance of the in-time time zone.
CalculatedInTimeZone_Id String A unique identifier for the in-time time zone associated with the calculated time block.
CalculatedOutTimeZone_Descriptor String A human-readable description of the time zone where the out-time for the time block was calculated.
CalculatedOutTimeZone_Href String A URL link to the Workday instance of the out-time time zone.
CalculatedOutTimeZone_Id String A unique identifier for the out-time time zone associated with the calculated time block.
CalculatedQuantity Decimal The system-generated number of hours or units worked within the time block, accounting for break periods and rounding rules.
CalculationTags_Aggregate String A collection of calculation tags applied to the time block, typically generated by time calculation rules in Workday. This is blank if the time block is not a calculated entry.
CalendarDate Datetime The actual date associated with the time block entry, often used for payroll processing and compliance tracking.
Currency_Descriptor String A human-readable description of the currency used for calculations related to this time block, if applicable.
Currency_Href String A URL link to the Workday instance of the currency used in this time block.
Currency_Id String A unique identifier for the currency associated with this time block.
OverrideRate Decimal The manually entered or system-calculated override rate applied to this time block, different from the worker’s standard rate.
ShiftDate Datetime The date the worker's shift started for this time block, used for scheduling and payroll reconciliation.
FromDate_Prompt Date The start date of the time block date range filter, formatted as yyyy-mm-dd, used for querying records within a specific period.
Phase_Prompt String The Workday ID of the project plan phase associated with the time block, used for filtering project-related time blocks.
ProjectPlanTask_Prompt String The Workday ID of the specific project plan task linked to the time block, helping track hours worked on tasks.
Project_Prompt String The Workday ID of the project associated with the time block, used for tracking work performed on specific projects.
Status_Prompt String The Workday ID of the approval status of the worker's time block, used to filter records. Valid IDs include statuses such as 'Approved', 'Pending', 'Denied'.
ToDate_Prompt Date The end date of the time block date range filter, formatted as yyyy-mm-dd, used to retrieve records within a specific period.
Worker_Prompt String The Workday ID of the worker associated with the time block, used for filtering records by individual worker.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434