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

            dkulling Debbie Kulling created issue -
            rakeshr Rakesh Roy (Inactive) made changes -
            Field Original Value New Value
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Report(10109)
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Vijay Siddha [ vijays ] Prasanna Karlekar [ prasanna ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Jyoti Agrawal [ jyoti.agrawal ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 7h [ 25200 ]
            Worklog Id 60325 [ 60325 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 7h [ 25200 ] 7.75h [ 27900 ]
            Worklog Id 60425 [ 60425 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Attachment EnrollmentReport.PNG [ 54303 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Code Reviewed By Prasanna Karlekar [ 11907 ]
            Dev Due Date 12/Jul/2017
            Developer Jyoti Agrawal [ jyoti.agrawal ]
            Original Estimate 0h [ 0 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 32-Bugs [ 76 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206)
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 7.75h [ 27900 ] 14.25h [ 51300 ]
            Worklog Id 61586 [ 61586 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 14.25h [ 51300 ] 17.25h [ 62100 ]
            Worklog Id 61603 [ 61603 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 17.25h [ 62100 ] 24.25h [ 87300 ]
            Worklog Id 61610 [ 61610 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 24.25h [ 87300 ] 31.25h [ 112500 ]
            Worklog Id 61616 [ 61616 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 31.25h [ 112500 ] 38.25h [ 137700 ]
            Worklog Id 62075 [ 62075 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 38.25h [ 137700 ] 46.25h [ 166500 ]
            Worklog Id 62427 [ 62427 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Sachin Hingole [ sachin.hingole ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Meghana Joshi [ meghana.kulkarni ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Meghana Joshi [ meghana.kulkarni ] Venkatesh Pujari [ venkatesh.pujari ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 46.25h [ 166500 ] 52.25h [ 188100 ]
            Worklog Id 64611 [ 64611 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 52.25h [ 188100 ] 53.25h [ 191700 ]
            Worklog Id 65409 [ 65409 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 53.25h [ 191700 ] 54h [ 194400 ]
            Worklog Id 65448 [ 65448 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 54h [ 194400 ] 55h [ 198000 ]
            Worklog Id 65459 [ 65459 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 55h [ 198000 ] 56h [ 201600 ]
            Worklog Id 65895 [ 65895 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Production Due Date 01/Aug/2017
            Stage Due Date 26/Jul/17 [ 2017-07-26 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 56h [ 201600 ] 60h [ 216000 ]
            Worklog Id 66535 [ 66535 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 60h [ 216000 ] 62h [ 223200 ]
            Worklog Id 66853 [ 66853 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 62h [ 223200 ] 62.5h [ 225000 ]
            Worklog Id 67992 [ 67992 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 62.5h [ 225000 ] 64h [ 230400 ]
            Worklog Id 68022 [ 68022 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 64h [ 230400 ] 67.5h [ 243000 ]
            Worklog Id 68619 [ 68619 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Debbie Kulling [ dkulling ]
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Type Functional [ 15402 ]
            Dev Due Date 12/Jul/2017 12/Jul/2017
            Production Due Date 01/Aug/2017 01/Aug/2017
            Stage Due Date 26/Jul/17 [ 2017-07-26 ] 26/Jul/17 [ 2017-07-26 ]
            satyap Satya made changes -
            Environment_New Stage [ 18443 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Link This issue is cloned by WT-12298 [ WT-12298 ]
            dkulling Debbie Kulling made changes -
            Resolution Done [ 10000 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Company COSB [ 18412 ]
            Root Cause Bug [ 18430 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Company COSB [ 18412 ] City of Santa Rosa [ 10444 ]

              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