Power BI Connector for Workday

Build 25.0.9454

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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.9454