Add TBH Salary

Description

Adds salaried employees to the selected department.

Formula

SET CREATENONMISSINGBLK ON;

VAR numTBH = [NumTBH];
VAR validTBH = 0;
FIX(@CHILDREN("New Employees"), [Scenario], [Version],  [Department], [Year], "Local", "HSP_InputValue")
	FIX(@LEVMBRS("Period", 0))
	"Start Month" 
	(
		IF (@ISMBR("BegBalance"))
			validTBH = 0;
			IF (numTBH > 0 AND @MAXS(SKIPMISSING, @CHILDREN("Employee Properties")) == #MISSING )
				"Start Month" = [StartMonth]->"Cal TP-Index";
				"Health Plan" = [HealthPlan];
				numTBH = numTBH - 1;
				validTBH = 1;
			ENDIF
		ENDIF
		IF (validTBH == 1)			
			"Grade" = [Grade];
			IF ([MarketAdjustment] != 0)
				"Market Adjustment"= [MarketAdjustment]; 
			ENDIF
			"FTE" = [FTE];
			"Position" = [Position];

			"Tax Region" = [TaxRegion];
			"Employee Type" = [EmployeeType];
			"Salary Basis" = 1;
			"Pay Type" = [PayTypeExempt];
		ENDIF
	)
	ENDFIX
	CALC DIM ("Account");
	FIX(@LEVMBRS("Period", 0))
		"Salary Rate" = "Target Rate" + "Market Adjustment";
	ENDFIX
     	CALC DIM ("Account");
ENDFIX