Tableau Connector for Workday

Build 25.0.9434

AdHocProjectTimeTransactions

Records ad hoc project-time transactions. This table allows tracking of manually entered work hours for project-based assignments, workforce planning, payroll processing, and cost allocation.

Workday Resource Information

Retrieves all ad hoc project time transactions. You can filter the transactions by project or project hierarchy.

Secured by: Manage: Ad Hoc Project Costing, Process: Project Billing - Ad Hoc Project Transactions

Scope: Project Billing, Projects

Columns

Name Type ReadOnly Description
Id [KEY] String False

The unique identifier (Id) for the ad hoc project time transaction instance. This Id ensures that each time entry is distinctly tracked and managed within the system.

BillingStatus_Descriptor String False

A human-readable summary of the billing status for the ad hoc project time transaction. This summary provides context on whether the transaction is billable, non-billable, or pending.

BillingStatus_Href String False

A direct link to the billing status instance associated with this ad hoc project time transaction. This link provides programmatic access to retrieve detailed billing information.

BillingStatus_Id String False

The unique Id for the billing status associated with this ad hoc project time transaction. This Id ensures accurate classification of the transaction's billing state.

Descriptor String False

A human-readable summary of the ad hoc project time transaction instance. This summary provides quick reference details about the transaction.

Hours Decimal False

The total number of hours logged for the ad hoc project time transaction. This value represents the time spent on a project that is recorded outside standard time-tracking workflows.

Href String False

A direct link to the ad hoc project time transaction instance. This link provides programmatic access to retrieve detailed information about the transaction.

IncludeCost Bool False

Indicates whether costs are calculated for the ad hoc project time transaction. A value of 'true' ensures that labor costs are included in financial reporting.

Memo String False

The memo or description entered for the ad hoc project time transaction. This value provides additional context about the purpose or details of the recorded time.

ProjectRole_Descriptor String False

A human-readable summary of the project role associated with the ad hoc project time transaction. This summary provides insight into the worker's role within the project.

ProjectRole_Href String False

A direct link to the project role instance associated with this ad hoc project time transaction. This link provides programmatic access to retrieve role-specific details.

ProjectRole_Id String False

The unique Id for the project role linked to this ad hoc project time transaction. This Id ensures that roles are correctly associated with recorded time.

Project_Descriptor String False

A human-readable summary of the project associated with the ad hoc project time transaction. This summary provides context about the project to which the time entry applies.

Project_Href String False

A direct link to the project instance associated with this ad hoc project time transaction. This link provides programmatic access to retrieve detailed project information.

Project_Id String False

The unique Id for the project linked to this ad hoc project time transaction. This Id ensures that recorded time is accurately associated with the correct project.

RateToBill_Currency String False

The currency type for the actual rate at which the ad hoc project time transaction is billed. This value specifies the currency in which billing occurs.

RateToBill_Value Decimal False

The actual rate at which the ad hoc project time transaction is billed. This value represents the financial charge applied per hour worked on the project.

StandardCostRate_Currency String False

The currency type for the hourly standard cost rate applied to the ad hoc project time transaction. This value specifies the cost calculation currency.

StandardCostRate_Value Decimal False

The hourly standard cost rate for hours logged on the ad hoc project time transaction. This value represents the baseline cost applied to the recorded time.

Task_Descriptor String False

A human-readable summary of the task associated with the ad hoc project time transaction. This summary provides context about the specific task to which the recorded time applies.

Task_Href String False

A direct link to the task instance associated with this ad hoc project time transaction. This link provides programmatic access to retrieve task-specific details.

Task_Id String False

The unique Id for the task linked to this ad hoc project time transaction. This Id ensures that recorded time is accurately assigned to the correct task.

TransactionDate Datetime False

The date of the ad hoc project time transaction, formatted as YYYY-MM-DD. This date indicates when the time entry was recorded.

Worker_Descriptor String False

A human-readable summary of the worker associated with the ad hoc project time transaction. This summary provides context about the individual who logged the time.

Worker_Href String False

A direct link to the worker instance associated with this ad hoc project time transaction. This link provides programmatic access to retrieve worker details.

Worker_Id String False

The unique Id for the worker linked to this ad hoc project time transaction. This Id ensures that time entries are accurately attributed to the correct individual.

ProjectOrProjectHierarchy_Prompt String False

The unique Id or reference Id of a project or project hierarchy. This value can be retrieved using GET /projects and ensures accurate project selection for time tracking.

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