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

          rohit.shete Rohit Shete (Inactive) logged work - 17/Jan/18 01:14 PM
          • Time Spent:
            1h
             
            • Company Restore
            • initial Analysis
            • data audit
            • Comment add
          jyoti.mayne Jyoti Mayne logged work - 18/Jan/18 08:47 AM
          • Time Spent:
            0.25h
             

            discussion

          rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 18/Jan/18 12:34 PM
          • Time Spent:
            3h
             
            <No comment>
          rohit.shete Rohit Shete (Inactive) logged work - 18/Jan/18 01:15 PM
          • Time Spent:
            5h
             
            • Impacted Data analysis
            • Script Creation
            • Execution on hspl
            • Verify on hspl
            • Rate Recal
            • correction on main
            • verify
            • and comment add
          umesh.kadam Umesh Kadam (Inactive) logged work - 18/Jan/18 05:30 PM
          • Time Spent:
            0.5h
             

            Analysis and discussion with Rohit S.
            Data correction and verification on LIVE copy

          jyoti.mayne Jyoti Mayne logged work - 19/Jan/18 08:47 AM
          • Time Spent:
            0.25h
             

            discussion

          rohit.shete Rohit Shete (Inactive) logged work - 19/Jan/18 01:25 PM
          • Time Spent:
            2h
             
            • Issue Reproduce
            • Data analysis
            • Impact analysis
            • check customization
            • Comment add
          rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 01/Feb/18 07:12 AM
          • Time Spent:
            2h
             

            Cross verification

          jyoti.mayne Jyoti Mayne logged work - 01/Feb/18 12:51 PM
          • Time Spent:
            0.25h
             

            discussion with Harsh

          harshawardhan Harshawardhan Phalake (Inactive) logged work - 01/Feb/18 02:50 PM
          • Time Spent:
            8h
             

            Analysis coding and Testing and check other pages for the similar issue.

          harshawardhan Harshawardhan Phalake (Inactive) logged work - 05/Feb/18 03:24 PM - edited
          • Time Spent:
            3h
             

            Code check in and testing

          rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 07/Feb/18 12:33 PM
          • Time Spent:
            4h
             

            Scenario writing and testing

          rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 09/Feb/18 10:13 AM
          • Time Spent:
            2h
             

            pre-prod testing

          rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 02/Apr/18 11:59 PM
          • Time Spent:
            3h
             

            production testing

            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