Example: Custom Calculated Health Care Rate
You want to adjust full-time worker and employee premiums based on the worker’s full-time equivalent. Workers who have less than 100% FTE have a certain amount deducted from the employer cost and added to the worker cost. In the
Rate Bands
tab of the Create Health Care Rate
task, follow these steps to create a custom calculation:- In theEmployee Pre-Tax Calculated Amountfield, select .Name the calculationBase Premium. SelectBenefitsin theCategoryfield. Enter200as the value. SelectOK.
- In theEmployee Pre-Tax Calculated Amountfield, select .Name the calculationBase Premium FTE. SelectBenefitsin theCategoryfield. Enter these values, then selectOK:1st OperandRelational Operator2nd OperandBase Premium (your constant value calculation)Multiply byFull Time Equivalent (Workday-delivered IVC)
- In theEmployee Pre-Tax Calculated Amountfield, select .Name the calculationEmployer Contribution. SelectBenefitsin theCategoryfield. Enter50as the value. SelectOK.
- In theEmployee Pre-Tax Calculated Amountfield, select .Name the calculationFTE Prorated Premium. SelectBenefitsin theCategoryfield. Enter these values, then selectOK:1st OperandRelational Operator2nd OperandBase Premium FTE (your previous arithmetic calculation)SubtractEmployer Contribution (your previous constant value calculation)
- SelectOK.
Your custom calculated health care rate is available to be assigned to a health care plan. If a worker enrolled in that plan has their FTE change, Workday adjusts both the worker’s cost and the employer’s rate.