Power BI Connector for Workday

Build 25.0.9454

TimeClockEvents

Retrieves a collection of time clock entries for a worker within a specified date range, capturing punch-in/out details and timestamps.

Workday Resource Information

Retrieves a collection of time clock events. You can filter by the time clock events by worker and date range.

Secured by: Process: Time Clock Event REST API's

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.

WorkerTimeAttestations_Aggregate


[{
  descriptor: Text /* The display name of the instance */
  id: Text /* Id of the instance */
  order: Text /* The order of the worker time attestation. */
}]

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier for the instance (Workday ID).

AllocationPool_Descriptor String False

The display name of the instance

AllocationPool_Href String False

A URL link to the allocation pool instance in Workday.

AllocationPool_Id String False

The Workday ID associated with the allocation pool.

Appropriation_Descriptor String False

The display name of the instance

Appropriation_Href String False

A URL link to the appropriation instance in Workday.

Appropriation_Id String False

The Workday ID for the appropriation.

BusinessUnit_Descriptor String False

The display name of the instance

BusinessUnit_Href String False

A URL link to the business unit instance in Workday.

BusinessUnit_Id String False

The Workday ID for the business unit.

Comment String False

A free-text comment associated with the time clock event, used for additional notes or explanations.

CostCenter_Descriptor String False

The display name of the instance

CostCenter_Href String False

A URL link to the cost center instance in Workday.

CostCenter_Id String False

The Workday ID for the cost center.

Currency_Descriptor String False

The display name of the instance

Currency_Href String False

A URL link to the currency instance in Workday.

Currency_Id String False

The Workday ID for the currency.

CustomOrganization01_Descriptor String False

The display name of the instance

CustomOrganization01_Href String False

A URL link to the custom organization level 1 instance in Workday.

CustomOrganization01_Id String False

The Workday ID for custom organization level 1.

CustomOrganization02_Descriptor String False

The display name of the instance

CustomOrganization02_Href String False

A URL link to the custom organization level 2 instance in Workday.

CustomOrganization02_Id String False

The Workday ID for custom organization level 2.

CustomOrganization03_Descriptor String False

The display name of the instance

CustomOrganization03_Href String False

A URL link to the custom organization level 3 instance in Workday.

CustomOrganization03_Id String False

The Workday ID for custom organization level 3.

CustomOrganization04_Descriptor String False

The display name of the instance

CustomOrganization04_Href String False

A URL link to the custom organization level 4 instance in Workday.

CustomOrganization04_Id String False

The Workday ID for custom organization level 4.

CustomOrganization05_Descriptor String False

The display name of the instance

CustomOrganization05_Href String False

A URL link to the custom organization level 5 instance in Workday.

CustomOrganization05_Id String False

The Workday ID for custom organization level 5.

CustomOrganization06_Descriptor String False

The display name of the instance

CustomOrganization06_Href String False

A URL link to the custom organization level 6 instance in Workday.

CustomOrganization06_Id String False

The Workday ID for custom organization level 6.

CustomOrganization07_Descriptor String False

The display name of the instance

CustomOrganization07_Href String False

A URL link to the custom organization level 7 instance in Workday.

CustomOrganization07_Id String False

The Workday ID for custom organization level 7.

CustomOrganization08_Descriptor String False

The display name of the instance

CustomOrganization08_Href String False

A URL link to the custom organization level 8 instance in Workday.

CustomOrganization08_Id String False

The Workday ID for custom organization level 8.

CustomOrganization09_Descriptor String False

The display name of the instance

CustomOrganization09_Href String False

A URL link to the custom organization level 9 instance in Workday.

CustomOrganization09_Id String False

The Workday ID for custom organization level 9.

CustomOrganization10_Descriptor String False

The display name of the instance

CustomOrganization10_Href String False

A URL link to the custom organization level 10 instance in Workday.

CustomOrganization10_Id String False

The Workday ID for custom organization level 10.

CustomWorktag01_Descriptor String False

The display name of the instance

CustomWorktag01_Href String False

A URL link to the first custom worktag instance in Workday.

CustomWorktag01_Id String False

The Workday ID for the first custom worktag.

CustomWorktag02_Descriptor String False

The display name of the instance

CustomWorktag02_Href String False

A URL link to the second custom worktag instance in Workday.

CustomWorktag02_Id String False

The Workday ID for the second custom worktag.

CustomWorktag03_Descriptor String False

The display name of the instance

CustomWorktag03_Href String False

A URL link to the third custom worktag instance in Workday.

CustomWorktag03_Id String False

The Workday ID for the third custom worktag.

CustomWorktag04_Descriptor String False

The display name of the instance

CustomWorktag04_Href String False

A URL link to the fourth custom worktag instance in Workday.

CustomWorktag04_Id String False

The Workday ID for the fourth custom worktag.

CustomWorktag05_Descriptor String False

The display name of the instance

CustomWorktag05_Href String False

A URL link to the fifth custom worktag instance in Workday.

CustomWorktag05_Id String False

The Workday ID for the fifth custom worktag.

CustomWorktag06_Descriptor String False

The display name of the instance

CustomWorktag06_Href String False

A URL link to the sixth custom worktag instance in Workday.

CustomWorktag06_Id String False

The Workday ID for the sixth custom worktag.

CustomWorktag07_Descriptor String False

The display name of the instance

CustomWorktag07_Href String False

A URL link to the seventh custom worktag instance in Workday.

CustomWorktag07_Id String False

The Workday ID for the seventh custom worktag.

CustomWorktag08_Descriptor String False

The display name of the instance

CustomWorktag08_Href String False

A URL link to the eighth custom worktag instance in Workday.

CustomWorktag08_Id String False

The Workday ID for the eighth custom worktag.

CustomWorktag09_Descriptor String False

The display name of the instance

CustomWorktag09_Href String False

A URL link to the ninth custom worktag instance in Workday.

CustomWorktag09_Id String False

The Workday ID for the ninth custom worktag.

CustomWorktag10_Descriptor String False

The display name of the instance

CustomWorktag10_Href String False

A URL link to the tenth custom worktag instance in Workday.

CustomWorktag10_Id String False

The Workday ID for the tenth custom worktag.

CustomWorktag11_Descriptor String False

The display name of the instance

CustomWorktag11_Href String False

A URL link to the eleventh custom worktag instance in Workday.

CustomWorktag11_Id String False

The Workday ID for the eleventh custom worktag.

CustomWorktag12_Descriptor String False

The display name of the instance

CustomWorktag12_Href String False

A URL link to the twelfth custom worktag instance in Workday.

CustomWorktag12_Id String False

The Workday ID for the twelfth custom worktag.

CustomWorktag13_Descriptor String False

The display name of the instance

CustomWorktag13_Href String False

A URL link to the thirteenth custom worktag instance in Workday.

CustomWorktag13_Id String False

The Workday ID for the thirteenth custom worktag.

CustomWorktag14_Descriptor String False

The display name of the instance

CustomWorktag14_Href String False

A URL link to the fourteenth custom worktag instance in Workday.

CustomWorktag14_Id String False

The Workday ID for the fourteenth custom worktag.

CustomWorktag15_Descriptor String False

The display name of the instance

CustomWorktag15_Href String False

A URL link to the fifteenth custom worktag instance in Workday.

CustomWorktag15_Id String False

The Workday ID for the fifteenth custom worktag.

DateTime Datetime False

The date and time of the event. The dateTime uses the ISO 8601 format: yyyy-mm-ddThh:mm:ss.sss

Descriptor String False

The display name of the instance

EventType_Descriptor String False

The display name of the instance

EventType_Href String False

A URL link to the event type instance in Workday.

EventType_Id String False

The Workday ID for the event type.

Fund_Descriptor String False

The display name of the instance

Fund_Href String False

A URL link to the fund instance in Workday.

Fund_Id String False

The Workday ID for the fund instance.

Gift_Descriptor String False

The display name of the instance

Gift_Href String False

A URL link to the gift instance in Workday.

Gift_Id String False

The Workday ID for the gift instance.

Grant_Descriptor String False

The display name of the instance

Grant_Href String False

A URL link to the grant instance in Workday.

Grant_Id String False

The Workday ID for the grant instance.

Href String False

A URL link to the specific instance in Workday.

JobProfile_Descriptor String False

The display name of the instance

JobProfile_Href String False

A URL link to the job profile instance in Workday.

JobProfile_Id String False

The Workday ID for the job profile.

Location_Descriptor String False

The display name of the instance

Location_Href String False

A URL link to the location instance in Workday.

Location_Id String False

The Workday ID for the location instance.

OverrideRate Decimal False

The override rate applied to a time clock event, used for special pay rates.

Position_Descriptor String False

The display name of the instance

Position_Href String False

A URL link to the position instance in Workday.

Position_Id String False

The Workday ID for the position instance.

Program_Descriptor String False

The display name of the instance

Program_Href String False

A URL link to the program instance in Workday.

Program_Id String False

The Workday ID for the program instance.

ProjectPlanTask_Descriptor String False

The display name of the instance

ProjectPlanTask_Href String False

A URL link to the project plan task instance in Workday.

ProjectPlanTask_Id String False

The Workday ID for the project plan task instance.

Project_Descriptor String False

The display name of the instance

Project_Href String False

A URL link to the project instance in Workday.

Project_Id String False

The Workday ID for the project instance.

ReferenceID String False

The reference ID used for Workday Web Services lookups.

Region_Descriptor String False

The display name of the instance

Region_Href String False

A URL link to the region instance in Workday.

Region_Id String False

The Workday ID for the region instance.

TimeEntryCode_Descriptor String False

The display name of the instance

TimeEntryCode_Href String False

A URL link to the time entry code instance in Workday.

TimeEntryCode_Id String False

The Workday ID for the time entry code instance.

TimeZone_Descriptor String False

The display name of the instance

TimeZone_Href String False

A URL link to the time zone instance in Workday.

TimeZone_Id String False

The Workday ID for the time zone instance.

WorkerTimeAttestations_Aggregate String False

The worker time attestations for the time clock event. To create a worker time attestation, use the POST /workerTimeAttestation operation, which returns the ID of the time attestation.

Worker_Descriptor String False

The display name of the instance

Worker_Href String False

A URL link to the worker instance in Workday.

Worker_Id String False

The Workday ID for the worker instance.

FromDate_Prompt Date False

Filters the time events starting from the specified date (yyyy-mm-dd format).

ToDate_Prompt Date False

Filters the time events ending on or before the specified date (yyyy-mm-dd format).

Worker_Prompt String False

Filters time blocks or clock events for a specific worker by Workday ID. Multiple worker parameters can be specified.

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