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

COSR - Billing Adjustment Issue

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Stage
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Report
    • Reported by:
      Client
    • Company:
      City of Santa Rosa
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 32-Bugs

      Description

      Please see the issue below. I have attached the pre bill and the steps they followed. Please correct the billing table

      The Active Anthem rates are Self Insured. Two of the component’s rates needed to be changed back to 5/1 (when BCC took over the group). I went into the system and successfully adjusted the rates for all Active Anthem plans. I ran the August Invoice to make sure all adjustments (May – July) would be accounted for. While reviewing the July Adjustments I noticed that if an individual had a future term date in the system (ie: the group went into the system 6/20 and put in a termination date of 7/7 for an EE) the system correctly credited the EE but never re-billed the Medical rate for July. This affected 4 Employees:

      Debra Bagley

      Harry Cheng

      Judy Maral

      Mitchell Moore

        Attachments

          Issue Links

            Activity

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 30/Jun/17 12:54 PM
            • Time Spent:
              7h
               

              Analysis, data audit

            prasanna Prasanna Karlekar (Inactive) logged work - 30/Jun/17 06:00 PM
            • Time Spent:
              0.75h
               

              Issue go through and discussion

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 03/Jul/17 12:05 PM
            • Time Spent:
              6.5h
               

              Data analysis, code changes, data verification on stage, unit testing

            prasanna Prasanna Karlekar (Inactive) logged work - 03/Jul/17 10:00 PM
            • Time Spent:
              1h
               

              Discussion on fix to be done and Invoice verification

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 05/Jul/17 12:15 PM
            • Time Spent:
              3h
               

              Code changes, Unit Testing

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 06/Jul/17 12:19 PM
            • Time Spent:
              7h
               

              Data verification for issue mentioned by Debbie on stage and production,
              script changes in production COSR,
              verification of data,
              Jira update,
              code changes,
              discussion with Prasanna,
              unit testing

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

              Reported issue discussion
              Review of reply to be done

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 07/Jul/17 12:25 PM
            • Time Spent:
              7h
               

              Code changes, discussion with Prasanna, Test Cases preparation, Unit Testing

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

              Scenario discussion

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 10/Jul/17 12:57 PM
            • Time Spent:
              7h
               

              Coding, discussion, unit testing

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 11/Jul/17 01:05 PM
            • Time Spent:
              8h
               

              Coding, discussion, unit testing

            prasanna Prasanna Karlekar (Inactive) logged work - 11/Jul/17 06:30 PM
            • Time Spent:
              0.5h
               

              Analysis and scenario discussion in prorated scenario

            prasanna Prasanna Karlekar (Inactive) logged work - 14/Jul/17 09:00 PM
            • Time Spent:
              1.5h
               

              Code Review

            prasanna Prasanna Karlekar (Inactive) logged work - 17/Jul/17 11:30 PM
            • Time Spent:
              1h
               

              Review and discussion on scenarios verified

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 19/Jul/17 10:24 AM
            • Time Spent:
              6h
               

              Testing on LB

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 26/Jul/17 11:19 AM
            • Time Spent:
              4h
               

              Testing of retro term scenarios

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 27/Jul/17 07:12 AM
            • Time Spent:
              2h
               

              Testing on Stage

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 01/Aug/17 10:20 AM
            • Time Spent:
              3.5h
               

              Testing on Production

              People

              Assignee:
              dkulling Debbie Kulling
              Reporter:
              dkulling Debbie Kulling
              Developer:
              Jyoti Agrawal (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Dev Due Date:
                Pre-Prod Due Date:
                Production Due Date:

                  Time Tracking

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