/
Calculating rate per cycle values from Employee Deductions

Calculating rate per cycle values from Employee Deductions



Description of Issue

Client wants to report on rate per cycle values in deduction monthly premiums



Context
  • All versions of Munis

  • SSRS reports

  • Crystal reports

  • SaaS, Tyler-hosted clients

  • OnPrem, Self-hosted clients

  • Employee Deductions



Cause

The view database column overlay shows rate per cycle as derived.



Resolution

Rate per Cycle = (pr_ins_premium.pm_emp_rate or pr_ins_premium.pm_emplr_rate  x 12) / 52



Additional Information