Power BI Connector for Workday

Build 25.0.9454

WorkerTimeBlocks

Retrieves individual worker time blocks, detailing specific periods of reported work hours or absences.

Workday Resource Information

Retrieves a worker time block with the specified ID.

Secured by: Process: Time Block REST APIs

Scope: Time Tracking

Columns

Name Type Description
Id [KEY] String Unique identifier for the reported time block instance.
AllocationPool_Descriptor String The display name of the instance
AllocationPool_Href String A link to the allocation pool instance.
AllocationPool_Id String Workday ID of the allocation pool.
Appropriation_Descriptor String The display name of the instance
Appropriation_Href String A link to the appropriation instance.
Appropriation_Id String Workday ID of the appropriation.
BusinessUnit_Descriptor String The display name of the instance
BusinessUnit_Href String A link to the business unit instance.
BusinessUnit_Id String Workday ID of the business unit.
CalendarDate Datetime The date for which the time block is reported.
Comment String The comment associated with the reported time block.
CostCenter_Descriptor String The display name of the instance
CostCenter_Href String A link to the cost center instance.
CostCenter_Id String Workday ID of the cost center.
Currency_Descriptor String The display name of the instance
Currency_Href String A link to the currency instance.
Currency_Id String Workday ID of the currency.
CustomOrganization01_Descriptor String The display name of the instance
CustomOrganization01_Href String A link to the first custom organization instance.
CustomOrganization01_Id String Workday ID of the first custom organization.
CustomOrganization02_Descriptor String The display name of the instance
CustomOrganization02_Href String A link to the second custom organization instance.
CustomOrganization02_Id String Workday ID of the second custom organization.
CustomOrganization03_Descriptor String The display name of the instance
CustomOrganization03_Href String A link to the third custom organization instance.
CustomOrganization03_Id String Workday ID of the third custom organization.
CustomOrganization04_Descriptor String The display name of the instance
CustomOrganization04_Href String A link to the fourth custom organization instance.
CustomOrganization04_Id String Workday ID of the fourth custom organization.
CustomOrganization05_Descriptor String The display name of the instance
CustomOrganization05_Href String A link to the fifth custom organization instance.
CustomOrganization05_Id String Workday ID of the fifth custom organization.
CustomOrganization06_Descriptor String The display name of the instance
CustomOrganization06_Href String A link to the sixth custom organization instance.
CustomOrganization06_Id String Workday ID of the sixth custom organization.
CustomOrganization07_Descriptor String The display name of the instance
CustomOrganization07_Href String A link to the seventh custom organization instance.
CustomOrganization07_Id String Workday ID of the seventh custom organization.
CustomOrganization08_Descriptor String The display name of the instance
CustomOrganization08_Href String A link to the eighth custom organization instance.
CustomOrganization08_Id String Workday ID of the eighth custom organization.
CustomOrganization09_Descriptor String The display name of the instance
CustomOrganization09_Href String A link to the ninth custom organization instance.
CustomOrganization09_Id String Workday ID of the ninth custom organization.
CustomOrganization10_Descriptor String The display name of the instance
CustomOrganization10_Href String A link to the tenth custom organization instance.
CustomOrganization10_Id String Workday ID of the tenth custom organization.
CustomWorktag01_Descriptor String The display name of the instance
CustomWorktag01_Href String A link to the first custom worktag instance.
CustomWorktag01_Id String Workday ID of the first custom worktag.
CustomWorktag02_Descriptor String The display name of the instance
CustomWorktag02_Href String A link to the second custom worktag instance.
CustomWorktag02_Id String Workday ID of the second custom worktag.
CustomWorktag03_Descriptor String The display name of the instance
CustomWorktag03_Href String A link to the third custom worktag instance.
CustomWorktag03_Id String Workday ID of the third custom worktag.
CustomWorktag04_Descriptor String The display name of the instance
CustomWorktag04_Href String A link to the fourth custom worktag instance.
CustomWorktag04_Id String Workday ID of the fourth custom worktag.
CustomWorktag05_Descriptor String The display name of the instance
CustomWorktag05_Href String A link to the fifth custom worktag instance.
CustomWorktag05_Id String Workday ID of the fifth custom worktag.
CustomWorktag06_Descriptor String The display name of the instance
CustomWorktag06_Href String A link to the sixth custom worktag instance.
CustomWorktag06_Id String Workday ID of the sixth custom worktag.
CustomWorktag07_Descriptor String The display name of the instance
CustomWorktag07_Href String A link to the seventh custom worktag instance.
CustomWorktag07_Id String Workday ID of the seventh custom worktag.
CustomWorktag08_Descriptor String The display name of the instance
CustomWorktag08_Href String A link to the eighth custom worktag instance.
CustomWorktag08_Id String Workday ID of the eighth custom worktag.
CustomWorktag09_Descriptor String The display name of the instance
CustomWorktag09_Href String A link to the ninth custom worktag instance.
CustomWorktag09_Id String Workday ID of the ninth custom worktag.
CustomWorktag10_Descriptor String The display name of the instance
CustomWorktag10_Href String A link to the tenth custom worktag instance.
CustomWorktag10_Id String Workday ID of the tenth custom worktag.
CustomWorktag11_Descriptor String The display name of the instance
CustomWorktag11_Href String A link to the eleventh custom worktag instance.
CustomWorktag11_Id String Workday ID of the eleventh custom worktag.
CustomWorktag12_Descriptor String The display name of the instance
CustomWorktag12_Href String A link to the twelfth custom worktag instance.
CustomWorktag12_Id String Workday ID of the twelfth custom worktag.
CustomWorktag13_Descriptor String The display name of the instance
CustomWorktag13_Href String A link to the thirteenth custom worktag instance.
CustomWorktag13_Id String Workday ID of the thirteenth custom worktag.
CustomWorktag14_Descriptor String The display name of the instance
CustomWorktag14_Href String A link to the fourteenth custom worktag instance.
CustomWorktag14_Id String Workday ID of the fourteenth custom worktag.
CustomWorktag15_Descriptor String The display name of the instance
CustomWorktag15_Href String A link to the fifteenth custom worktag instance.
CustomWorktag15_Id String Workday ID of the fifteenth custom worktag.
Descriptor String The display name of the instance
DoNotBill Bool Indicates if this reported time block is non-billable.
Fund_Descriptor String The display name of the instance
Fund_Href String A link to the fund instance.
Fund_Id String Workday ID of the fund.
Gift_Descriptor String The display name of the instance
Gift_Href String A link to the gift instance.
Gift_Id String Workday ID of the gift.
Grant_Descriptor String The display name of the instance
Grant_Href String A link to the grant instance.
Grant_Id String Workday ID of the grant.
InTime Datetime The clock-in time for this reported time block.
InTimeZone_Descriptor String The display name of the instance
InTimeZone_Href String A link to the time zone instance.
InTimeZone_Id String Workday ID of the time zone.
JobProfile_Descriptor String The display name of the instance
JobProfile_Href String A link to the job profile instance.
JobProfile_Id String Workday ID of the job profile.
Location_Descriptor String The display name of the instance
Location_Href String A link to the location instance.
Location_Id String Workday ID of the location.
OutReason_Descriptor String The display name of the instance
OutReason_Href String A URL link to the instance of the out reason record in Workday, enabling direct navigation to its details.
OutReason_Id String A unique identifier for the out reason, used to reference this instance programmatically.
OutTime Datetime The exact timestamp when the worker clocked out, recorded for payroll and attendance tracking.
OutTimeZone_Descriptor String The display name of the instance
OutTimeZone_Href String A URL link to the time zone instance associated with the out time.
OutTimeZone_Id String A unique identifier for the time zone associated with the out time.
OverrideRate Decimal A manually overridden pay rate applicable to this reported time block, if different from the default rate.
Position_Descriptor String The display name of the instance
Position_Href String A URL link to the instance of the worker's position in Workday.
Position_Id String A unique identifier for the position, used for reference in Workday transactions.
Program_Descriptor String The display name of the instance
Program_Href String A URL link to the Workday instance of the program.
Program_Id String A unique identifier for the program, used for reference in system queries.
ProjectPlanPhase_Descriptor String The display name of the instance
ProjectPlanPhase_Href String A URL link to the Workday instance of the project plan phase.
ProjectPlanPhase_Id String A unique identifier for the project plan phase.
ProjectPlanTask_Descriptor String The display name of the instance
ProjectPlanTask_Href String A URL link to the Workday instance of the project plan task.
ProjectPlanTask_Id String A unique identifier for the project plan task.
ProjectRole_Descriptor String The display name of the instance
ProjectRole_Href String A URL link to the Workday instance of the project role.
ProjectRole_Id String A unique identifier for the project role.
Project_Descriptor String The display name of the instance
Project_Href String A URL link to the Workday instance of the project.
Project_Id String A unique identifier for the project.
Region_Descriptor String The display name of the instance
Region_Href String A URL link to the Workday instance of the region.
Region_Id String A unique identifier for the region.
ReportedQuantity Decimal The number of hours or units entered for a reported time block, used for payroll and resource tracking.
Status_Descriptor String The display name of the instance
Status_Href String A URL link to the Workday instance of the status.
Status_Id String A unique identifier for the time block status.
TimeEntryCode_Descriptor String The display name of the instance
TimeEntryCode_Href String A URL link to the Workday instance of the time entry code.
TimeEntryCode_Id String A unique identifier for the time entry code.
Unit_Descriptor String The display name of the instance
Unit_Href String A URL link to the Workday instance of the unit.
Unit_Id String A unique identifier for the unit.
Worker_Descriptor String The display name of the instance
Worker_Href String A URL link to the Workday instance of the worker.
Worker_Id String A unique identifier for the worker.
FromDate_Prompt Date The start date of the time block date range filter, formatted as yyyy-mm-dd, used for querying records.
Phase_Prompt String The Workday ID of the project plan phase associated with the time block, used for filtering results.
ProjectPlanTask_Prompt String The Workday ID of the project plan task associated with the time block, used for filtering results.
Project_Prompt String The Workday ID of the project associated with the time block, used for filtering results.
Status_Prompt String The Workday ID of the approval status of the worker's time block, used to filter records. Valid IDs include: 'Approved', 'Pending', 'Denied'.
ToDate_Prompt Date The end date of the time block date range filter, formatted as yyyy-mm-dd, used for querying records.
Worker_Prompt String The Workday ID of the worker associated with the time block, specifying which worker’s records to retrieve.

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