Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-5842

City of Walnut Creek - 2017/2018 Rate Issues

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Bug Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UI Refresh
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin
    • Reported by:
      White Label
    • Company:
      City of Walnut Creek
    • Item State:
      Stage QA - Ready for Production

      Description

      Hi,

      Per BCC:

      We are experiencing issues with the Medical rates for City of Walnut Creek. It appears that even though the 2017 rates are end dated 12/31/17, they are still being assigned to some of the enrollees for 2018.

      This came to light because we had to correct the 2018 rates that were in the system. The rates have been updated, but when we went to Extend and Recalc the rates, we noticed there were two entries for some of the Employees.

      EXAMPLE: A. Mitcalf - She has been enrolled in the BlueShield HMO plan since 1/1/2017. On her Confirmation Statement the system is adding together the rates from 2017 and 2018. This is also apparent in the SA Toolbox. When we went to extend and recalculate her rate, the toolbox shows that she has two entries for 1/1/18 – 12/31/18. One is the rate for 2017, the other is the rate for 2018.

      This is happening sporadically on all Medical plans (BlueShield HMO, BlueShield HDHP, Kaiser HMO, Kaiser HDHP).

      Could you please have development correct this issue?

      We have not extended and recalculated the rates for all Medical plans yet as we need to have this resolved prior to doing so.

      Thank you,
      Kira Hamilton
      Debbie Kulling

        Attachments

          Activity

          Kira.Hamilton Kira Hamilton (Inactive) created issue -
          jyoti.mayne Jyoti Mayne made changes -
          Field Original Value New Value
          Assignee Satya [ ID10004 ] Jyoti Mayne [ jyoti.mayne ]
          rohit.shete Rohit Shete (Inactive) made changes -
          Assignee Jyoti Mayne [ jyoti.mayne ] Rohit Shete [ rohit.shete ]
          rohit.shete Rohit Shete (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          rohit.shete Rohit Shete (Inactive) made changes -
          Developer Rohit Shete [ rohit.shete ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 0.5h [ 1800 ]
          Worklog Id 100914 [ 100914 ]
          rohit.shete Rohit Shete (Inactive) made changes -
          rohit.shete Rohit Shete (Inactive) made changes -
          Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
          rohit.shete Rohit Shete (Inactive) made changes -
          Assignee Rohit Shete [ rohit.shete ] Kira Hamilton [ kira.hamilton ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Time Spent 0.5h [ 1800 ] 3.5h [ 12600 ]
          Worklog Id 100931 [ 100931 ]
          rohit.shete Rohit Shete (Inactive) made changes -
          Attachment RateCustomization.png [ 72064 ]
          jyoti.mayne Jyoti Mayne made changes -
          Time Spent 3.5h [ 12600 ] 3.75h [ 13500 ]
          Worklog Id 101768 [ 101768 ]
          jyoti.mayne Jyoti Mayne made changes -
          Time Spent 3.75h [ 13500 ] 4h [ 14400 ]
          Worklog Id 101769 [ 101769 ]
          rohit.shete Rohit Shete (Inactive) made changes -
          Time Spent 4h [ 14400 ] 5h [ 18000 ]
          Worklog Id 102315 [ 102315 ]
          rohit.shete Rohit Shete (Inactive) made changes -
          Time Spent 5h [ 18000 ] 10h [ 36000 ]
          Worklog Id 102318 [ 102318 ]
          rohit.shete Rohit Shete (Inactive) made changes -
          Time Spent 10h [ 36000 ] 12h [ 43200 ]
          Worklog Id 102333 [ 102333 ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Issue Type Support Activity [ 10301 ] Bug [ 1 ]
          Key WT-13101 NF-5842
          Project WORKTERRA [ 10000 ] New Features 2017 [ 11000 ]
          Status Waiting for Customer Input [ 10500 ] Open [ 1 ]
          Support Task Type Data Correction [ 11203 ]
          Workflow WT_Support [ 61756 ] WT_Defects [ 62870 ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Assignee Kira Hamilton [ kira.hamilton ] Jyoti Mayne [ jyoti.mayne ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Time Spent 12h [ 43200 ] 14h [ 50400 ]
          Worklog Id 102782 [ 102782 ]
          rohan.khandave Rohan J Khandave (Inactive) made changes -
          Assignee Jyoti Mayne [ jyoti.mayne ] Harshawardhan Phalake [ harshawardhan ]
          harshawardhan Harshawardhan Phalake (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          harshawardhan Harshawardhan Phalake (Inactive) made changes -
          Stage Due Date 3/Feb/18 [ 2018-02-03 ]
          Original Estimate 0h [ 0 ]
          harshawardhan Harshawardhan Phalake (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208)
          harshawardhan Harshawardhan Phalake (Inactive) made changes -
          Code Reviewed By Rohan Khandave [ 11903 ]
          harshawardhan Harshawardhan Phalake (Inactive) made changes -
          Time Spent 14h [ 50400 ] 22h [ 79200 ]
          Worklog Id 103157 [ 103157 ]
          harshawardhan Harshawardhan Phalake (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)
          harshawardhan Harshawardhan Phalake (Inactive) made changes -
          Assignee Harshawardhan Phalake [ harshawardhan ] Sachin Hingole [ sachin.hingole ]
          harshawardhan Harshawardhan Phalake (Inactive) made changes -
          Time Spent 22h [ 79200 ] 24h [ 86400 ]
          Worklog Id 103472 [ 103472 ]
          harshawardhan Harshawardhan Phalake (Inactive) made changes -
          Time Spent 24h [ 86400 ] 25h [ 90000 ]
          Worklog Id 103472 [ 103472 ]
          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)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee Sachin Hingole [ sachin.hingole ] Rashmita Dudhe [ rashmita.dudhe ]
          rashmita.dudhe Rashmita Dudhe (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)
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Attachment NF-5842_Scenarios.xls [ 73011 ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Time Spent 25h [ 90000 ] 29h [ 104400 ]
          Worklog Id 103719 [ 103719 ]
          jyoti.mayne Jyoti Mayne made changes -
          Time Spent 29h [ 104400 ] 29.25h [ 105300 ]
          Worklog Id 103728 [ 103728 ]
          rashmita.dudhe Rashmita Dudhe (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)
          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)
          rashmita.dudhe Rashmita Dudhe (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)
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Time Spent 29.25h [ 105300 ] 31.25h [ 112500 ]
          Worklog Id 103989 [ 103989 ]
          rashmita.dudhe Rashmita Dudhe (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)
          nidhi.kaul Nidhi Kaul (Inactive) made changes -
          Component/s UI Refresh [ 10902 ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Status Stage Testing [ 10201 ] In Production Testing [ 10202 ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Time Spent 31.25h [ 112500 ] 34.25h [ 123300 ]
          Worklog Id 111142 [ 111142 ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Resolution Bug Fixed [ 10402 ]
          Status In Production Testing [ 10202 ] Production Complete [ 10028 ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]

            People

            Assignee:
            rashmita.dudhe Rashmita Dudhe (Inactive)
            Reporter:
            Kira.Hamilton Kira Hamilton (Inactive)
            Account Executive:
            Debbie Kulling
            Developer:
            Rohit Shete (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Pre-Prod Due Date:

                Time Tracking

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