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

County of Sutter-Invoice Adjustment Errors

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Report
    • Reported by:
      Client
    • Company:
      County of Sutter
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 38 - Bugs

      Description

      Hello,

      Per the client: County of Sutter has notified BCC they are having an issue with the billing adjustments on their August invoice (please see attached).
       
      We have looked into the issue with Harminder Dosanjh:
      1.       Beginning May 1, 2017 when BCC begins administration of COSR, Employee is enrolled in the Anthem PPO 500 plan as Employee + 1 Child (Rate $1,463.00)
      2.       On June 20, 2017 QE Add Newborn occurs, takes the Anthem PPO 500 plan enrollment to Employee + 2 Children (Rate $2,072.00)
      3.       Billing rule is Free In/Pay Out and is built in the Billing Period Policies on the General Plan Design page as follows:
      a.       Billing Period Adds = Premiums Waived After the Cut-Off Day; Day of Billing Period = 1
      b.      Billing Period Changes/Terminations = Bill for Entire Month; Day of Billing Period = 0
      4.       The August invoice incorrectly credits the June premium.
      5.       The August invoice does correctly credit and bill the July adjustments
      6.       The August invoice does correctly bill for the month of August

             Kenya Olivas is having the exact same issue as Harminder Dosanjh
      a.        EE has been effective since 5/1/17 on the Anthem PPO 1000 plan with EE + SP + 2+ Children on the plan (Rate $1,698.00)
      b.      On 6/23/17 QE Add Newborn was initiated for a baby born 5/24/17.  This has no effect on the enrollment level as the EE already has 2+ Children on the plan
      c.       Billing rule is Free In/Pay Out and is built in the Billing Period Policies on the General Plan Design page as follows:
        i.      Billing Period Adds = Premiums Waived After the Cut-Off Day; Day of Billing Period = 1
          ii.      Billing Period Changes/Terminations = Bill for Entire Month; Day of Billing Period = 0
      d.      The August invoice incorrectly credits the May premium
      e.      The August invoice does correctly credit and bill the June and July adjustments
      f.        The August invoice does correctly bill for the month of August

       
      Could you please have your development team look into this ASAP, the group is extremely unhappy with their invoices.

      Thank you,
      Kira
      Debbie Kulling

        Attachments

          Issue Links

            Activity

            prasanna Prasanna Karlekar (Inactive) logged work - 23/Sep/17 09:00 PM
            • Time Spent:
              5h
               

              Issue analysis
              Data scan
              JIRA update
              Email Communication

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 25/Sep/17 01:14 PM
            • Time Spent:
              5h
               

              Jira go through, analysis, discussion, issue repro, code fix

            prasanna Prasanna Karlekar (Inactive) logged work - 25/Sep/17 09:00 PM
            • Time Spent:
              0.75h
               

              Discussion on issue repro
              Root cause
              Fix to be done

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 26/Sep/17 01:12 PM
            • Time Spent:
              7h
               

              Unit Testing

            prasanna Prasanna Karlekar (Inactive) logged work - 26/Sep/17 10:30 PM
            • Time Spent:
              0.5h
               

              Discussion on changes done

            prasanna Prasanna Karlekar (Inactive) logged work - 27/Sep/17 01:00 AM
            • Time Spent:
              0.25h
               

              Data scan script

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 27/Sep/17 01:06 PM
            • Time Spent:
              4h
               

              Unit Testing, code fixing

            prasanna Prasanna Karlekar (Inactive) logged work - 27/Sep/17 07:30 PM
            • Time Spent:
              1h
               

              Code review
              Script to scan Data for affected elections - In Progress

            prasanna Prasanna Karlekar (Inactive) logged work - 28/Sep/17 09:00 PM
            • Time Spent:
              2.5h
               

              Data scanning script
              Data scan for list of employees affected
              JIRA update

            amita.sangani Amita Sangani (Inactive) logged work - 29/Sep/17 12:39 PM
            • Time Spent:
              1h
               
              <No comment>
            prasanna Prasanna Karlekar (Inactive) logged work - 03/Oct/17 09:30 PM
            • Time Spent:
              3.5h
               

              Analysis of impact on Billing Report for data correction done
              Data correction
              Invoice verification after correction
              JIRA update

            amita.sangani Amita Sangani (Inactive) logged work - 04/Oct/17 12:45 PM
            • Time Spent:
              3.3h
               

              Internal discussion with Jyoti and Sachin
              Understand ticket
              Tested 1 scenario
              Create employee, Customise OE period, Raise QE
              not able to generate invoice properly on For QA Matt company on LB environment

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 05/Oct/17 07:04 PM
            • Time Spent:
              2h
               

              Understanding issue

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 06/Oct/17 09:24 PM
            • Time Spent:
              1h
               

              Testing on LB

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 09/Oct/17 10:20 AM
            • Time Spent:
              2h
               

              Testing on LB

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 09/Oct/17 01:23 PM
            • Time Spent:
              2h
               

              Scenario verification along with Venaktesh

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 10/Oct/17 02:38 PM
            • Time Spent:
              1h
               

              Testing on Stage

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 12/Oct/17 12:57 PM
            • Time Spent:
              0.5h
               

              Testing on Stage

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 14/Oct/17 10:58 AM
            • Time Spent:
              1h
               

              Testing on Production

              People

              Assignee:
              Kira.Hamilton Kira Hamilton (Inactive)
              Reporter:
              Kira.Hamilton Kira Hamilton (Inactive)
              Account Executive:
              Debbie Kulling
              Developer:
              Jyoti Agrawal (Inactive)
              QA:
              Amita Sangani (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 43.3h
                  43.3h