Tableau Connector for Workday

Build 20.0.7740

BudgetTemplates

You must use the spreadsheet key to coordinate the header information throughout the tabs of the spreadsheet. Keep the same spreadsheet key for each row as you add information in the subsequent tabs. The spreadsheet key is also required to coordinate multiple child rows that roll up to the same parent row.

Columns

Name Type References Description
Plan_Template_ID String Plan Template ID
Company_Reference String Company Reference
Plan_Structure_Reference_WID String Contains a unique identifier for an instance of an object.
Plan_Structure_Reference_Budget_Structure_ID String Contains a unique identifier for an instance of an object.
Is_Inactive Bool Inactivates the plan to remove the plan from all prompts and disable all associated related actions.
Organization_As_Of_Date_Reference Date Determines which organizations are available to select in your Top Plan Hierarchy.
Top_Plan_Hierarchy_Reference_WID String Contains a unique identifier for an instance of an object.
Top_Plan_Hierarchy_Reference_Cost_Center_Reference_ID String Contains a unique identifier for an instance of an object.
Top_Plan_Hierarchy_Reference_Custom_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Top_Plan_Hierarchy_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Include_All_Organizations_Under_Top_Plan_Hierarchy_Reference Bool Makes all organizations within the top plan hierarchy plannable organizations.
Organizations_Reference String You can limit your plan to specific organizations within the top plan hierarchy that you selected.
Roll_Up_Subordinate_Reference Bool Enables the plan for all subordinate organizations within the top plan hierarchy. Use only when Supervisory Organization is the organizing dimension.
Statistic_Type_Reference String Determines whether you plan by Headcount, FTE, or Cost of Workforce.
Entry_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Entry_Type_Reference_Budget_Type_ID String Contains a unique identifier for an instance of an object.
Award_Reference_WID String Contains a unique identifier for an instance of an object.
Award_Reference_Award_Proposal_ID String Contains a unique identifier for an instance of an object.
Award_Reference_Award_Reference_ID String Contains a unique identifier for an instance of an object.
Award_Reference_Custom_Budget_ID String Contains a unique identifier for an instance of an object.
Award_Reference_Project_Budget_ID String Contains a unique identifier for an instance of an object.
Plan_Name String Plan name for Financial, Headcount, or Project plan types.
Default_Reporting_Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Default_Reporting_Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Default_Reporting_Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.
Enable_Multicurrency_Reference Bool Allows plan lines in currencies other than the company base currency.
Currency_Rate_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Currency_Rate_Type_Reference_Currency_Rate_Type_ID String Contains a unique identifier for an instance of an object.
Currency_Rate_Type_For_Budget_Spend_Reference_WID String Contains a unique identifier for an instance of an object.
Currency_Rate_Type_For_Budget_Spend_Reference_Currency_Rate_Type_ID String Contains a unique identifier for an instance of an object.
Default_Balanced_Amendment_Reference Bool Sets the default value when creating amendments for this plan or budget.
Enable_For_Allocations_Reference Bool Enable the plan or budget as a source or target when creating allocations.
Validate_Expense_Account_Amendments_Reference String Validate if budget amendments on expense accounts are less than current spend.
Budget_Data String You must use the row ID to coordinate the data that spreads across multiple rows in the spreadsheet. A change in the value of the ID indicates that a new child object will be created under the same parent object.
Linked_Virtual_Children_Budgets_Reference String Plan Template Reference for virtual children (Financial and Position only).
Currency_Rate_Type_For_Budget_Reference_WID String Contains a unique identifier for an instance of an object.
Currency_Rate_Type_For_Budget_Reference_Currency_Rate_Type_ID String Contains a unique identifier for an instance of an object.
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.
Plan_Calculation_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Plan_Calculation_Type_Reference_Plan_Calculation_Type_Detail_for_Project_ID String Contains a unique identifier for an instance of an object.

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