WorkerTimeBlocksCalculatedTimeDetails
Reads /calculatedTimeDetails entries from the WorkerTimeBlocks table.
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.
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 | Id of the instance |
WorkerTimeBlocks_Id [KEY] | String | The Workday ID of the WorkerTimeBlocks that contains this. |
CalculatedDate | Datetime | Supported for: SELECT. The calculated date for a time block. |
CalculatedInTimeZone_Descriptor | String | Supported for: SELECT. A description of the instance |
CalculatedInTimeZone_Href | String | Supported for: SELECT. A link to the instance |
CalculatedInTimeZone_Id | String | Supported for: SELECT. wid / id / reference id |
CalculatedOutTimeZone_Descriptor | String | Supported for: SELECT. A description of the instance |
CalculatedOutTimeZone_Href | String | Supported for: SELECT. A link to the instance |
CalculatedOutTimeZone_Id | String | Supported for: SELECT. wid / id / reference id |
CalculatedQuantity | Decimal | Supported for: SELECT. The calculated hours or units for a time block. |
CalculationTags_Aggregate | String | Supported for: SELECT. A JSON aggregate. Calculation Tags generated by Time Calculations. Blank if not a Calculated Time Block. |
CalendarDate | Datetime | Supported for: SELECT. The calendar date for a time block. |
Currency_Descriptor | String | Supported for: SELECT. A description of the instance |
Currency_Href | String | Supported for: SELECT. A link to the instance |
Currency_Id | String | Supported for: SELECT. wid / id / reference id |
OverrideRate | Decimal | Supported for: SELECT. The calculated override rate for a time block. |
ShiftDate | Datetime | Supported for: SELECT. The shift date for a time block. |
FromDate_Prompt | Date | The start date of the time block date range, using the yyyy-mm-dd format. |
Phase_Prompt | String | Accepts multiple inputs. The Workday ID of the project plan phase for the time block. |
ProjectPlanTask_Prompt | String | Accepts multiple inputs. The Workday ID of the project plan task for the time block. |
Project_Prompt | String | Accepts multiple inputs. The Workday ID of the project for the time block. |
Status_Prompt | String | Accepts multiple inputs. The Workday ID of the approval status of the worker time block. Valid IDs are: |
ToDate_Prompt | Date | The end date of the time block date range, using the yyyy-mm-dd format. |
Worker_Prompt | String | Accepts multiple inputs. The Workday ID of the worker for the time block. Specify workers that the user has permission to access. |