ODBC Driver for Workday

Build 24.0.9062

TimeClockEvents

Retrieves a collection of time clock events for a worker for a date range.

Workday Resource Information

Retrieves a time clock event with the specified ID.

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

Scope: Time Tracking

Columns

Name Type ReadOnly Description
Id [KEY] String False

Id of the instance

AllocationPool_Descriptor String False

Supported for: SELECT. A description of the instance

AllocationPool_Href String False

Supported for: SELECT. A link to the instance

AllocationPool_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

Appropriation_Descriptor String False

Supported for: SELECT. A description of the instance

Appropriation_Href String False

Supported for: SELECT. A link to the instance

Appropriation_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

BusinessUnit_Descriptor String False

Supported for: SELECT. A description of the instance

BusinessUnit_Href String False

Supported for: SELECT. A link to the instance

BusinessUnit_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

Comment String False

Supported for: SELECT, INSERT, UPDATE. The comment associated with the time clock event.

CostCenter_Descriptor String False

Supported for: SELECT. A description of the instance

CostCenter_Href String False

Supported for: SELECT. A link to the instance

CostCenter_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

Currency_Descriptor String False

Supported for: SELECT. A description of the instance

Currency_Href String False

Supported for: SELECT. A link to the instance

Currency_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomOrganization01_Descriptor String False

Supported for: SELECT. A description of the instance

CustomOrganization01_Href String False

Supported for: SELECT. A link to the instance

CustomOrganization01_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomOrganization02_Descriptor String False

Supported for: SELECT. A description of the instance

CustomOrganization02_Href String False

Supported for: SELECT. A link to the instance

CustomOrganization02_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomOrganization03_Descriptor String False

Supported for: SELECT. A description of the instance

CustomOrganization03_Href String False

Supported for: SELECT. A link to the instance

CustomOrganization03_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomOrganization04_Descriptor String False

Supported for: SELECT. A description of the instance

CustomOrganization04_Href String False

Supported for: SELECT. A link to the instance

CustomOrganization04_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomOrganization05_Descriptor String False

Supported for: SELECT. A description of the instance

CustomOrganization05_Href String False

Supported for: SELECT. A link to the instance

CustomOrganization05_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomOrganization06_Descriptor String False

Supported for: SELECT. A description of the instance

CustomOrganization06_Href String False

Supported for: SELECT. A link to the instance

CustomOrganization06_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomOrganization07_Descriptor String False

Supported for: SELECT. A description of the instance

CustomOrganization07_Href String False

Supported for: SELECT. A link to the instance

CustomOrganization07_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomOrganization08_Descriptor String False

Supported for: SELECT. A description of the instance

CustomOrganization08_Href String False

Supported for: SELECT. A link to the instance

CustomOrganization08_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomOrganization09_Descriptor String False

Supported for: SELECT. A description of the instance

CustomOrganization09_Href String False

Supported for: SELECT. A link to the instance

CustomOrganization09_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomOrganization10_Descriptor String False

Supported for: SELECT. A description of the instance

CustomOrganization10_Href String False

Supported for: SELECT. A link to the instance

CustomOrganization10_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomWorktag01_Descriptor String False

Supported for: SELECT. A description of the instance

CustomWorktag01_Href String False

Supported for: SELECT. A link to the instance

CustomWorktag01_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomWorktag02_Descriptor String False

Supported for: SELECT. A description of the instance

CustomWorktag02_Href String False

Supported for: SELECT. A link to the instance

CustomWorktag02_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomWorktag03_Descriptor String False

Supported for: SELECT. A description of the instance

CustomWorktag03_Href String False

Supported for: SELECT. A link to the instance

CustomWorktag03_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomWorktag04_Descriptor String False

Supported for: SELECT. A description of the instance

CustomWorktag04_Href String False

Supported for: SELECT. A link to the instance

CustomWorktag04_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomWorktag05_Descriptor String False

Supported for: SELECT. A description of the instance

CustomWorktag05_Href String False

Supported for: SELECT. A link to the instance

CustomWorktag05_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomWorktag06_Descriptor String False

Supported for: SELECT. A description of the instance

CustomWorktag06_Href String False

Supported for: SELECT. A link to the instance

CustomWorktag06_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomWorktag07_Descriptor String False

Supported for: SELECT. A description of the instance

CustomWorktag07_Href String False

Supported for: SELECT. A link to the instance

CustomWorktag07_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomWorktag08_Descriptor String False

Supported for: SELECT. A description of the instance

CustomWorktag08_Href String False

Supported for: SELECT. A link to the instance

CustomWorktag08_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomWorktag09_Descriptor String False

Supported for: SELECT. A description of the instance

CustomWorktag09_Href String False

Supported for: SELECT. A link to the instance

CustomWorktag09_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomWorktag10_Descriptor String False

Supported for: SELECT. A description of the instance

CustomWorktag10_Href String False

Supported for: SELECT. A link to the instance

CustomWorktag10_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomWorktag11_Descriptor String False

Supported for: SELECT. A description of the instance

CustomWorktag11_Href String False

Supported for: SELECT. A link to the instance

CustomWorktag11_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomWorktag12_Descriptor String False

Supported for: SELECT. A description of the instance

CustomWorktag12_Href String False

Supported for: SELECT. A link to the instance

CustomWorktag12_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomWorktag13_Descriptor String False

Supported for: SELECT. A description of the instance

CustomWorktag13_Href String False

Supported for: SELECT. A link to the instance

CustomWorktag13_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomWorktag14_Descriptor String False

Supported for: SELECT. A description of the instance

CustomWorktag14_Href String False

Supported for: SELECT. A link to the instance

CustomWorktag14_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

CustomWorktag15_Descriptor String False

Supported for: SELECT. A description of the instance

CustomWorktag15_Href String False

Supported for: SELECT. A link to the instance

CustomWorktag15_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

DateTime Datetime False

Supported for: SELECT, INSERT, UPDATE. The date time for a time clock event.

Descriptor String False

Supported for: SELECT, INSERT, UPDATE. A preview of the instance

EventType_Descriptor String False

Supported for: SELECT. A description of the instance

EventType_Href String False

Supported for: SELECT. A link to the instance

EventType_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

Fund_Descriptor String False

Supported for: SELECT. A description of the instance

Fund_Href String False

Supported for: SELECT. A link to the instance

Fund_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

Gift_Descriptor String False

Supported for: SELECT. A description of the instance

Gift_Href String False

Supported for: SELECT. A link to the instance

Gift_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

Grant_Descriptor String False

Supported for: SELECT. A description of the instance

Grant_Href String False

Supported for: SELECT. A link to the instance

Grant_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

Href String False

Supported for: SELECT, INSERT, UPDATE. A link to the instance

JobProfile_Descriptor String False

Supported for: SELECT. A description of the instance

JobProfile_Href String False

Supported for: SELECT. A link to the instance

JobProfile_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

Location_Descriptor String False

Supported for: SELECT. A description of the instance

Location_Href String False

Supported for: SELECT. A link to the instance

Location_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

OverrideRate Decimal False

Supported for: SELECT, INSERT, UPDATE. The override rate for a time clock event.

Position_Descriptor String False

Supported for: SELECT. A description of the instance

Position_Href String False

Supported for: SELECT. A link to the instance

Position_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

Program_Descriptor String False

Supported for: SELECT. A description of the instance

Program_Href String False

Supported for: SELECT. A link to the instance

Program_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

ProjectPlanTask_Descriptor String False

Supported for: SELECT. A description of the instance

ProjectPlanTask_Href String False

Supported for: SELECT. A link to the instance

ProjectPlanTask_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

Project_Descriptor String False

Supported for: SELECT. A description of the instance

Project_Href String False

Supported for: SELECT. A link to the instance

Project_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

ReferenceID String False

Supported for: SELECT, INSERT, UPDATE. The Reference ID to use for lookups within our Workday Web Services.

Region_Descriptor String False

Supported for: SELECT. A description of the instance

Region_Href String False

Supported for: SELECT. A link to the instance

Region_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

TimeEntryCode_Descriptor String False

Supported for: SELECT. A description of the instance

TimeEntryCode_Href String False

Supported for: SELECT. A link to the instance

TimeEntryCode_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

TimeZone_Descriptor String False

Supported for: SELECT. A description of the instance

TimeZone_Href String False

Supported for: SELECT. A link to the instance

TimeZone_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

Worker_Descriptor String False

Supported for: SELECT. A description of the instance

Worker_Href String False

Supported for: SELECT. A link to the instance

Worker_Id String False

Supported for: SELECT, INSERT, UPDATE. wid / id / reference id

FromDate_Prompt Date False

The start date of the time event using the yyyy-mm-dd format.

ToDate_Prompt Date False

The end date of the time event using the yyyy-mm-dd format.

Worker_Prompt String False

Accepts multiple inputs. The Workday ID of the worker for the time block or clock event. You can specify multiple worker query parameters.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062