Fact tables
Data is saved to the Workforce Budgeting tables using up to nine decimal places. When the data is written to the financial tables, precision follows CPM's precedence:
- Line precision.
- Unit local currency precision.
- Sys_Params precision if no other precision available.
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 |
| Action definition | WFA_Action_Definitions
WFA_Action_Values_Keys WFA_Action_Values 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 NONSTRUCTURE_PARAMS |
| Mappings | WFA_Mappings WFA_Mapping_X_Attributes |
| Position definition | WFA_Position_Definitions WF_Notes |
| Default actions for position definition | WFA_Position_Def_X_Actions |
| Position assignment | WF_Positions |
| Spread method | WFA_Spread _Methods |
| Step and grade | WFA_Step_Grade
WFA_Step_Grade_Grade WFA_Step_Grade_Rate |