ODBC Driver for Workday

Build 25.0.9434

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 Description of the allocation pool associated with the reported time.
AllocationPool_Href String A link to the allocation pool instance.
AllocationPool_Id String Workday ID of the allocation pool.
Appropriation_Descriptor String Description of the appropriation tied to this time block.
Appropriation_Href String A link to the appropriation instance.
Appropriation_Id String Workday ID of the appropriation.
BusinessUnit_Descriptor String Description of the business unit linked to the reported time.
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 Description of the cost center assigned to this time block.
CostCenter_Href String A link to the cost center instance.
CostCenter_Id String Workday ID of the cost center.
Currency_Descriptor String Currency used in transactions related to this time block.
Currency_Href String A link to the currency instance.
Currency_Id String Workday ID of the currency.
CustomOrganization01_Descriptor String Description of the first custom organization.
CustomOrganization01_Href String A link to the first custom organization instance.
CustomOrganization01_Id String Workday ID of the first custom organization.
CustomOrganization02_Descriptor String Description of the second custom organization.
CustomOrganization02_Href String A link to the second custom organization instance.
CustomOrganization02_Id String Workday ID of the second custom organization.
CustomOrganization03_Descriptor String Description of the third custom organization.
CustomOrganization03_Href String A link to the third custom organization instance.
CustomOrganization03_Id String Workday ID of the third custom organization.
CustomOrganization04_Descriptor String Description of the fourth custom organization.
CustomOrganization04_Href String A link to the fourth custom organization instance.
CustomOrganization04_Id String Workday ID of the fourth custom organization.
CustomOrganization05_Descriptor String Description of the fifth custom organization.
CustomOrganization05_Href String A link to the fifth custom organization instance.
CustomOrganization05_Id String Workday ID of the fifth custom organization.
CustomOrganization06_Descriptor String Description of the sixth custom organization.
CustomOrganization06_Href String A link to the sixth custom organization instance.
CustomOrganization06_Id String Workday ID of the sixth custom organization.
CustomOrganization07_Descriptor String Description of the seventh custom organization.
CustomOrganization07_Href String A link to the seventh custom organization instance.
CustomOrganization07_Id String Workday ID of the seventh custom organization.
CustomOrganization08_Descriptor String Description of the eighth custom organization.
CustomOrganization08_Href String A link to the eighth custom organization instance.
CustomOrganization08_Id String Workday ID of the eighth custom organization.
CustomOrganization09_Descriptor String Description of the ninth custom organization.
CustomOrganization09_Href String A link to the ninth custom organization instance.
CustomOrganization09_Id String Workday ID of the ninth custom organization.
CustomOrganization10_Descriptor String Description of the tenth custom organization.
CustomOrganization10_Href String A link to the tenth custom organization instance.
CustomOrganization10_Id String Workday ID of the tenth custom organization.
CustomWorktag01_Descriptor String Description of the first custom worktag.
CustomWorktag01_Href String A link to the first custom worktag instance.
CustomWorktag01_Id String Workday ID of the first custom worktag.
CustomWorktag02_Descriptor String Description of the second custom worktag.
CustomWorktag02_Href String A link to the second custom worktag instance.
CustomWorktag02_Id String Workday ID of the second custom worktag.
CustomWorktag03_Descriptor String Description of the third custom worktag.
CustomWorktag03_Href String A link to the third custom worktag instance.
CustomWorktag03_Id String Workday ID of the third custom worktag.
CustomWorktag04_Descriptor String Description of the fourth custom worktag.
CustomWorktag04_Href String A link to the fourth custom worktag instance.
CustomWorktag04_Id String Workday ID of the fourth custom worktag.
CustomWorktag05_Descriptor String Description of the fifth custom worktag.
CustomWorktag05_Href String A link to the fifth custom worktag instance.
CustomWorktag05_Id String Workday ID of the fifth custom worktag.
CustomWorktag06_Descriptor String Description of the sixth custom worktag.
CustomWorktag06_Href String A link to the sixth custom worktag instance.
CustomWorktag06_Id String Workday ID of the sixth custom worktag.
CustomWorktag07_Descriptor String Description of the seventh custom worktag.
CustomWorktag07_Href String A link to the seventh custom worktag instance.
CustomWorktag07_Id String Workday ID of the seventh custom worktag.
CustomWorktag08_Descriptor String Description of the eighth custom worktag.
CustomWorktag08_Href String A link to the eighth custom worktag instance.
CustomWorktag08_Id String Workday ID of the eighth custom worktag.
CustomWorktag09_Descriptor String Description of the ninth custom worktag.
CustomWorktag09_Href String A link to the ninth custom worktag instance.
CustomWorktag09_Id String Workday ID of the ninth custom worktag.
CustomWorktag10_Descriptor String Description of the tenth custom worktag.
CustomWorktag10_Href String A link to the tenth custom worktag instance.
CustomWorktag10_Id String Workday ID of the tenth custom worktag.
CustomWorktag11_Descriptor String Description of the eleventh custom worktag.
CustomWorktag11_Href String A link to the eleventh custom worktag instance.
CustomWorktag11_Id String Workday ID of the eleventh custom worktag.
CustomWorktag12_Descriptor String Description of the twelfth custom worktag.
CustomWorktag12_Href String A link to the twelfth custom worktag instance.
CustomWorktag12_Id String Workday ID of the twelfth custom worktag.
CustomWorktag13_Descriptor String Description of the thirteenth custom worktag.
CustomWorktag13_Href String A link to the thirteenth custom worktag instance.
CustomWorktag13_Id String Workday ID of the thirteenth custom worktag.
CustomWorktag14_Descriptor String Description of the fourteenth custom worktag.
CustomWorktag14_Href String A link to the fourteenth custom worktag instance.
CustomWorktag14_Id String Workday ID of the fourteenth custom worktag.
CustomWorktag15_Descriptor String Description of the fifteenth custom worktag.
CustomWorktag15_Href String A link to the fifteenth custom worktag instance.
CustomWorktag15_Id String Workday ID of the fifteenth custom worktag.
Descriptor String A human-readable preview of the instance, providing a brief description or summary to aid in identification and context within reports or UI displays.
DoNotBill Bool Indicates if this reported time block is non-billable.
Fund_Descriptor String Description of the fund associated with this time block.
Fund_Href String A link to the fund instance.
Fund_Id String Workday ID of the fund.
Gift_Descriptor String Description of the gift associated with this time block.
Gift_Href String A link to the gift instance.
Gift_Id String Workday ID of the gift.
Grant_Descriptor String Description of the grant associated with this time block.
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 Description of the time zone for clock-in.
InTimeZone_Href String A link to the time zone instance.
InTimeZone_Id String Workday ID of the time zone.
JobProfile_Descriptor String Description of the job profile associated with this time block.
JobProfile_Href String A link to the job profile instance.
JobProfile_Id String Workday ID of the job profile.
Location_Descriptor String Description of the location linked to this time block.
Location_Href String A link to the location instance.
Location_Id String Workday ID of the location.
OutReason_Descriptor String A human-readable description of the reason why a worker clocked out, providing context for reporting and analysis.
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 A human-readable description of the time zone in which the out time was recorded.
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 A human-readable description of the worker's position at the time of the reported event.
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 A description of the program associated with the reported time block, used for financial and project tracking.
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 A human-readable description of the phase within a project plan to which the time block is linked.
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 A human-readable description of the project task associated with the time block.
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 A description of the worker’s role within the project, providing insight into their assigned duties.
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 A human-readable description of the project associated with the reported time block.
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 A human-readable description of the region associated with the reported time block, useful for geographic tracking.
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 A description of the status of the reported time block, such as 'Approved' or 'Pending Approval'.
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 A description of the time entry code applied to this reported time block, indicating the type of work performed.
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 A human-readable description of the unit of time (for example, hours, days) used for the reported time block.
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 A human-readable description of the worker associated with the reported time block, typically their name.
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.9434