Reconcile TBH

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