Tableau Connector for Workday

Build 20.0.7740

Projects

Wrapper Element that includes Project Instance and Data

Columns

Name Type References Description
Project_Reference_WID String Contains a unique identifier for an instance of an object.
Project_Reference_Project_ID String Contains a unique identifier for an instance of an object.
Project_Reference_Workday_Project_ID String Contains a unique identifier for an instance of an object.
Workday_Project_ID String Reference ID for the Project
Locked_in_Workday Bool Set to True to disable editing of the Project inside the Workday application. Project, Project Task and Project Pools can only be updated from the web service.
Project_Hierarchy_Reference_WID String Contains a unique identifier for an instance of an object.
Project_Hierarchy_Reference_Project_Hierarchy_ID String Contains a unique identifier for an instance of an object.
Optional_Project_Hierarchy_Reference String Optional project hierarchies.
Project_Event_Status_Reference String READ ONLY: Project event status (Approved, Canceled, Denied or In Progress)
Associated_Templates_from_Project_Template_Reference_WID String Contains a unique identifier for an instance of an object.
Associated_Templates_from_Project_Template_Reference_Project_Template_ID String Contains a unique identifier for an instance of an object.
Customer_Contract_Template_Reference_WID String Contains a unique identifier for an instance of an object.
Customer_Contract_Template_Reference_Customer_Contract_Template_ID String Contains a unique identifier for an instance of an object.
Project_Name String Free form text field for a meaningful Project Name
Worktag_Only Bool Boolean to indicate if project is used as a worktag only and not a complete workday project instance
Inactive Bool Indicates the Project is inactive. A project may also be inactivated by a project hierarchy as indicated by the 'Inactivated By Hierarchy Reference'. In which case, the project is considered Inactive even though this Boolean returns False. Changes to an inactive project are ignored. Reactivating a project can only be done on the project if it was explicitly marked 'Inactive' or by reactivating the hierarchy that made the project inactive.
Project_State_Reference_WID String Contains a unique identifier for an instance of an object.
Project_State_Reference_Project_State_ID String Contains a unique identifier for an instance of an object.
Project_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Project_Status_Reference_Project_Status_ID String Contains a unique identifier for an instance of an object.
Include_Project_ID_in_Name Bool Boolean value indicating if the Project ID will be included in the display of the Project Name.
Project_Owner_Reference_WID String Contains a unique identifier for an instance of an object.
Project_Owner_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Project_Owner_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Start_Date Date Project Start Date
End_Date Date Project End Date
Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.
Resource_Plan_Reference_WID String Contains a unique identifier for an instance of an object.
Resource_Plan_Reference_Project_Resource_Plan_ID String Contains a unique identifier for an instance of an object.
Billable Bool Boolean indicating whether the Project is billable or non-billable. Defaults to non-billable.
Capital Bool Boolean indicating whether the Project is capital or non-capital. Defaults to non-capital.
Description String Free form text field for a meaningful Project Description
Overall_Percent_Complete Decimal Percent in decimal format, ex: enter 1 for 100%, .5 for 50%, etc
Probability Decimal Percent in decimal format, ex: enter 1 for 100%, .5 for 50%, etc
Risk_Level_Reference_WID String Contains a unique identifier for an instance of an object.
Risk_Level_Reference_Risk_Level_ID String Contains a unique identifier for an instance of an object.
Priority_Reference_WID String Contains a unique identifier for an instance of an object.
Priority_Reference_Work_Priority_ID String Contains a unique identifier for an instance of an object.
Importance_Rating_Reference_WID String Contains a unique identifier for an instance of an object.
Importance_Rating_Reference_Importance_Rating_ID String Contains a unique identifier for an instance of an object.
Success_Rating_Reference_WID String Contains a unique identifier for an instance of an object.
Success_Rating_Reference_Success_Rating_ID String Contains a unique identifier for an instance of an object.
Company_Reference_WID String Contains a unique identifier for an instance of an object.
Company_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Company_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Customer_Reference_WID String Contains a unique identifier for an instance of an object.
Customer_Reference_Customer_ID String Contains a unique identifier for an instance of an object.
Customer_Reference_Customer_Reference_ID String Contains a unique identifier for an instance of an object.
Project_Group_Reference String Reference to an existing Project Group that the project belongs.
External_Project_Reference_Name String Free form text field to provide Project Reference description. This is not a Workday reference instance.
Initiative_Reference_WID String Contains a unique identifier for an instance of an object.
Initiative_Reference_Initiative_Reference_ID String Contains a unique identifier for an instance of an object.
Estimated_Budget Decimal The estimated project budget amount in the currency context identified for the project.
Estimated_Revenue Decimal The estimated revenue amount in the currency context identified for the project.
Realized_Revenue Decimal The realized revenue amount in the currency context identified for the project.
Balancing_Worktag_Reference_WID String Contains a unique identifier for an instance of an object.
Balancing_Worktag_Reference_Business_Unit_ID String Contains a unique identifier for an instance of an object.
Balancing_Worktag_Reference_Cost_Center_Reference_ID String Contains a unique identifier for an instance of an object.
Balancing_Worktag_Reference_Custom_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Balancing_Worktag_Reference_Fund_ID String Contains a unique identifier for an instance of an object.
Balancing_Worktag_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Balancing_Worktag_Reference_Region_Reference_ID String Contains a unique identifier for an instance of an object.
Optional_Balancing_Worktag_Reference String Reference to Existing Optional Balancing Worktag.
Project_Dependencies_Reference String The list of projects defined as dependencies to this project.
Project_Prerequisite_For_Reference String READ ONLY: The list of projects defined as prerequisites to this project.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7740