Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-12914

Jefferson County’s enrollment report is not displaying the proper cost per pay schedule

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Production
    • Bug Type:
      UI
    • Bug Severity:
      Critical
    • Level:
      Partner
    • Module:
      BenAdmin
    • Reported by:
      White Label
    • Company:
      Jefferson County
    • Item State:
      Development - In Analysis

      Description

      I was re-auditing Jefferson County’s life rates and found that the REPORTS are not calculating the EE cost correctly. When you go on the employee record itself the EE or ER Cost calculation are correct as the Basic Life, Basic AD&D, Vol Life, Vol AD&D and LTD rates are all on a 24 pay period pay schedule. However the reports are calculating incorrectly on a 26 pay period schedule.

      FYI, all the actual rates are correct I have checked them all, just the per pay period amounts are off on the Standard REPORTS. Again, the employee records of ee cost in the site are right, the reports are wrong.

      For example, Ashley Ainsworth's basic life life coverage of $40000 has a rate of $0.10. On the employee record this line of coverage has a rate of $2.00, which is correct. However, on the Enrollment Reports in Standard Reports the rate is $1.85, which is incorrect.

      *RIGHT-->Employee Record is calculating like this....
      40000 coverage/1000 rate divisor*rate of 0.10*12/24 pay periods = $2.00

      WRONG-->Enrollment Report is calculating like this.....
      40000 coverage/1000 rate divisor*rate of 0.10*12/26 pay periods = $1.85*

      I have screenshotted some examples below for your reference.

      Jackie SivignyDebbie KullingJennifer JohnsonRobyn Adkison

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Ryan.Sapp Ryan Sapp (Inactive)
              Reporter:
              Ryan.Sapp Ryan Sapp (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 0.75h
                  0.75h