Workforce Budgeting tables

Data is saved to the Workforce Budgeting tables using up to nine decimal places.

This table lists the type of data imported and the fact table in which it is stored:

Data type Fact table name
Action assignment WF_Action_Base

WF_Notes

Action definition WFA_Action_Definitions

WFA_Action_Values

WFA_Action_Values_Keys

WFA_Action_X_Attributes

WFA_Views

WFA_Views_X_Actions

WFA_View_X_Views

WF_Notes

Allocation WF_Allocations

WF_Allocations_X_Members

Attribute definition WFA_Attributes
Attribute value WFA_Attribute_Values
Distributions WF_Position_X_Distribution

WF_Distribution_Percents

Employee WF_Employees

WF_Notes

Global settings WFA_Global_Settings

WFA_Cycle_Settings

SYS_PARAMS

Position definition WFA_Position_Definitions

WF_Notes

Position assignment WF_Positions

WF_Notes

Spread method WFA_Spread _Methods

WFA_Spread_Weights

Step and grade WFA_Step_Grade

WFA_Step_Grade_Grade

WFA_Step_Grade_Rate

WF_Notes