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

City of Bellevue- System Calculating Wrong Rate

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Support Task Type:
      Data Correction
    • Environment:
      Production
    • Reported by:
      Client
    • Company:
      City of Bellevue
    • Module:
      BenAdmin - Enrollment

      Description

      The system is calculating the smoker rate for spouse at $3.66. Should be $1.86 for $20,000 for age 36 spouse smoker.

      Employee Name: A. Kinney

        Attachments

          Activity

          Hide
          darryn.carter darryn.carter added a comment -

          Hello Development Team

          Rates are calculating for plan (Additional Spouse/ Domestic Partner Life non smoker) with both non smoker and smoker rates.

          when testing the smoker election to YES rate is 1.86, however when selecting the non smoker affidavit the rate is 3.66 including the 1.80 non and 1.86 smoker.

          1.80 + 1.86= 3.66

          please assist.

          Show
          darryn.carter darryn.carter added a comment - Hello Development Team Rates are calculating for plan (Additional Spouse/ Domestic Partner Life non smoker) with both non smoker and smoker rates. when testing the smoker election to YES rate is 1.86, however when selecting the non smoker affidavit the rate is 3.66 including the 1.80 non and 1.86 smoker. 1.80 + 1.86= 3.66 please assist.
          Hide
          sumeet.kolge Sumeet.Kolge (Inactive) added a comment - - edited

          Hello Jyoti,

          We have tested Additional Spouse/ Domestic Partner Life plan(rates,demographics,age,enrolment history etc) here are the following observations:-

          1. Even if the "Coleman McKinney" dependent changed to tobacco user "Yes" "No" and initiated QE >> Enrol it >> selecting tobacco user Y/N ( the rate remains the same 3.66 only for this employee the rate does not change)
          2. In SA Utility the rates are showing correct but after re-calculating it it does not reflect in EE >> enrolment summary.(Please check the screenshot)
          3.We tried the same scenarios for the other employees:-

          • Ford Richmond
          • Cross Julie

          Tried different scenarios like initiate QE, changing dependent to tobacco user >>Yes/No
          (for smoker / non smoker rates are calculating accordingly for this employees).

          I kindly request you to please look into this issue. Thank you!

          ----------------------------------------------------------------------------------
          CC: Mandar Kulkarni, Vijay Siddha

          Show
          sumeet.kolge Sumeet.Kolge (Inactive) added a comment - - edited Hello Jyoti, We have tested Additional Spouse/ Domestic Partner Life plan(rates,demographics,age,enrolment history etc) here are the following observations:- 1. Even if the " Coleman McKinney " dependent changed to tobacco user " Yes " " No " and initiated QE >> Enrol it >> selecting tobacco user Y/N ( the rate remains the same 3.66 only for this employee the rate does not change) 2. In SA Utility the rates are showing correct but after re-calculating it it does not reflect in EE >> enrolment summary .(Please check the screenshot) 3.We tried the same scenarios for the other employees:- Ford Richmond Cross Julie Tried different scenarios like initiate QE, changing dependent to tobacco user >>Yes/No (for smoker / non smoker rates are calculating accordingly for this employees). I kindly request you to please look into this issue. Thank you! ---------------------------------------------------------------------------------- CC: Mandar Kulkarni , Vijay Siddha
          Hide
          dkulling Debbie Kulling added a comment -

          We need an update on this

          Show
          dkulling Debbie Kulling added a comment - We need an update on this
          Hide
          dkulling Debbie Kulling added a comment -

          Where are we with the research on this. I need an update

          Show
          dkulling Debbie Kulling added a comment - Where are we with the research on this. I need an update
          Hide
          jyoti.mayne Jyoti Mayne added a comment -

          Hi Debbie Kulling,

          We are working on this and will share updates by tomorrow 2/15 IST.

          Cc: Satya, Jaideep Vinchurkar

          Show
          jyoti.mayne Jyoti Mayne added a comment - Hi Debbie Kulling , We are working on this and will share updates by tomorrow 2/15 IST. Cc: Satya , Jaideep Vinchurkar
          Hide
          jyoti.mayne Jyoti Mayne added a comment -

          Hi Debbie Kulling,

          Due to UND WT-8282 and WT-7785 priority issues, we couldn't work on this. We will update you once analysis is completed.

          Cc: Satya, Jaideep Vinchurkar

          Show
          jyoti.mayne Jyoti Mayne added a comment - Hi Debbie Kulling , Due to UND WT-8282 and WT-7785 priority issues, we couldn't work on this. We will update you once analysis is completed. Cc: Satya , Jaideep Vinchurkar
          Hide
          michelle.parker Michelle Parker (Inactive) added a comment -

          Is there an update for this issue?

          Show
          michelle.parker Michelle Parker (Inactive) added a comment - Is there an update for this issue?
          Hide
          umesh.kadam Umesh Kadam (Inactive) added a comment -

          Hi Michelle Parker,

          Please find 3 Cs below,

          Concern The system is calculating the smoker rate for spouse at $3.66. Should be $1.86 for $20,000 for age 36 spouse smoker. Employee Name: A. Kinney
          Cause While updating smoker affidavit data related details, system added two records for 'Does your spouse or your domestic partner use tobacco product' with different effective dates. Hence employee was eligible for both the rates (i.e. smoker and non-smoker)
          Correction We have corrected rates for employee to her latest tobacco affidavit status.

          NOTE: We have also scanned others employees having same issue. We found two more employees; named Brenda Johnson and Jon Warren, and corrected their rates too and now employee have correct rate.

          Sheetal Bodhale, could you please check this at your end that why there are two entries of 'Does your spouse or your domestic partner use tobacco product' present for same employee?

          Thanks and Regards,
          :: Umesh Kadam

          CC : Satya, Swapnil Pandhare, Jyoti Mayne

          Show
          umesh.kadam Umesh Kadam (Inactive) added a comment - Hi Michelle Parker , Please find 3 Cs below, Concern The system is calculating the smoker rate for spouse at $3.66. Should be $1.86 for $20,000 for age 36 spouse smoker. Employee Name: A. Kinney Cause While updating smoker affidavit data related details, system added two records for 'Does your spouse or your domestic partner use tobacco product' with different effective dates. Hence employee was eligible for both the rates (i.e. smoker and non-smoker) Correction We have corrected rates for employee to her latest tobacco affidavit status. NOTE: We have also scanned others employees having same issue. We found two more employees; named Brenda Johnson and Jon Warren , and corrected their rates too and now employee have correct rate. Sheetal Bodhale , could you please check this at your end that why there are two entries of 'Does your spouse or your domestic partner use tobacco product' present for same employee? Thanks and Regards, :: Umesh Kadam CC : Satya , Swapnil Pandhare , Jyoti Mayne
          Hide
          dkulling Debbie Kulling added a comment -

          I have a call with the client on Monday and need to provide a root cause

          Show
          dkulling Debbie Kulling added a comment - I have a call with the client on Monday and need to provide a root cause
          Hide
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

          Hi Debbie Kulling,

          We are working on it.We will update you on this till Monday EOD.

          CC:Satya

          Thanks,
          Sheetal Bodhale

          Show
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Hi Debbie Kulling , We are working on it.We will update you on this till Monday EOD. CC: Satya Thanks, Sheetal Bodhale
          Hide
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

          Hi @suraj,

          We have verified data from back end for mentioned employee.Data for 'Does your spouse or your domestic partner use tobacco product' field is inserted through general mode irrespective of page id on which field is present.

          That is causing issue while calculating rates .Can you please look into this today as client is having call today?

          CC:SatyaJaideep VinchurkarUmesh KadamJyoti Mayne
          Thanks,
          Sheetal Bodhale

          Show
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Hi @suraj, We have verified data from back end for mentioned employee.Data for 'Does your spouse or your domestic partner use tobacco product' field is inserted through general mode irrespective of page id on which field is present. That is causing issue while calculating rates .Can you please look into this today as client is having call today? CC: Satya Jaideep Vinchurkar Umesh Kadam Jyoti Mayne Thanks, Sheetal Bodhale
          Hide
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

          Hi Debbie Kulling,

          We have corrected the affected employees data.

          Suraj Sokasane:Please share the root cause for the same.

          CC:Satya

          Thanks,
          Sheetal Bodhale

          Show
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Hi Debbie Kulling , We have corrected the affected employees data. Suraj Sokasane :Please share the root cause for the same. CC: Satya Thanks, Sheetal Bodhale
          Hide
          suraj.sokasane Suraj Sokasane (Inactive) added a comment -

          Hi Debbie Kulling,

          As per our primary analysis, the issue occurred during the correction under WT-5153.
          We are investigating more on this and let you know the final root cause tomorrow EOD.

          Show
          suraj.sokasane Suraj Sokasane (Inactive) added a comment - Hi Debbie Kulling , As per our primary analysis, the issue occurred during the correction under WT-5153 . We are investigating more on this and let you know the final root cause tomorrow EOD.
          Hide
          suraj.sokasane Suraj Sokasane (Inactive) added a comment -

          Hi Debbie Kulling

          As per comment above, this occurred due to correction under WT-5153.

          Show
          suraj.sokasane Suraj Sokasane (Inactive) added a comment - Hi Debbie Kulling As per comment above, this occurred due to correction under WT-5153 .

            People

            Assignee:
            dkulling Debbie Kulling
            Reporter:
            michelle.parker Michelle Parker (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 3h Original Estimate - 3h
                3h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 15h 43m
                15h 43m