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

        1. EmployeeCorrectionList(WT-13001).xls
          11 kB
          Rohit Shete
        2. NF-5842_Scenarios.xls
          9 kB
          Rashmita Dudhe
        3. RateCustomization.png
          104 kB
          Rohit Shete

          Activity

          Hide
          rohan.khandave Rohan J Khandave (Inactive) added a comment -

          Please check.

          Show
          rohan.khandave Rohan J Khandave (Inactive) added a comment - Please check.
          Hide
          harshawardhan Harshawardhan Phalake (Inactive) added a comment -

          Hi Sachin Hingole,

          Please test the issue once deployed on code-map, We have fixed the data table related issue.
          Now if rates are in use then it will not be able to delete from system

          Thanks,
          Harshawardhan.
          CC: Rohan J Khandave

          Show
          harshawardhan Harshawardhan Phalake (Inactive) added a comment - Hi Sachin Hingole , Please test the issue once deployed on code-map, We have fixed the data table related issue. Now if rates are in use then it will not be able to delete from system Thanks, Harshawardhan. CC: Rohan J Khandave
          Hide
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

          Verified on code map
          all attached scenarios it working fine

          Show
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on code map all attached scenarios it working fine
          Hide
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

          Verified on pre prod
          all attached scenarios it working fine

          Show
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on pre prod all attached scenarios it working fine
          Hide
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

          Verified on prod
          all attached scenarios it working fine

          Show
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on prod all attached scenarios it working fine

            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