Suggestions on implementing global salary review plan budgets

Summary:

Suggestions on implementing global merit increase plan budgets

Content (required):

The annual salary review plan is currently run for ~100 countries, each country having a specific budget structure. For example, country A follows a budget structure of Department, Location and Cost center, which means for each combination of these three values, there will be a unique budget value. Further to this, the budget value varies with business unit for each country.

Our current solution is as follows:

1. We have a UDT which stores the the budget structure for each country, for example, Dept_Loc_CC.
2. We have a second UDT which stores the budget values as column instances for each combination of the budget structure (D1_L1_CC1, D2_L2_CC2) as rows of UDT and the business unit (BU1, BU2) as the columns of the UDT.