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