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