Description
Reconciles TBHs with actual new hires.
Formula
FIX ([Scenario], [Version], [Department]) DATACOPY [SrcEmployee] TO [DestEmployee]; ENDFIX FIX ([Scenario], [Version], [Department], [DestEmployee], [Year], @LEVMBRS("Period", 0), "Local", "HSP_InputValue") "Start Month" ( IF ("Cal TP-Index" == "BegBalance"->"Start Month") "Action" = 1; "BegBalance"->"Start Month" = #MISSING; ENDIF "Grade" = "BegBalance"->"Grade"; "FTE" = "BegBalance"->"FTE"; "Position" = "BegBalance"->"Position"; "Tax Region" = "BegBalance"->"Tax Region"; "Employee Type" = "BegBalance"->"Employee Type"; "Pay Type" = "BegBalance"->"Pay Type"; "Salary Basis" = "BegBalance"->"Salary Basis"; "Salary Rate" = "BegBalance"->"Target Rate" + "BegBalance"->"Market Adjustment"; IF ("Salary Basis" == 2) "Hours per week" = "BegBalance"->"Hours per week"; ENDIF ); CALC DIM ("Account"); ENDFIX FIX ([Scenario], [Version], [Department]) CLEARDATA [SrcEmployee]; CALC DIM ("Account"); ENDFIX