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

          michelle.parker Michelle Parker (Inactive) created issue -
          darryn.carter darryn.carter made changes -
          Field Original Value New Value
          BA’s Darryn Carter [ 14205 ]
          Raywill Raymond Williams (Inactive) made changes -
          Assignee Raymond Williams [ raywill ]
          Raywill Raymond Williams (Inactive) made changes -
          Assignee Raymond Williams [ raywill ]
          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.
          darryn.carter darryn.carter made changes -
          Environment Production [ 10005 ]
          Issue Type Task [ 3 ] Support Activity [ 10301 ]
          Key CT-936 WT-8148
          Project WORKTERRA-CT [ 10800 ] WORKTERRA [ 10000 ]
          Status To Do [ 10000 ] Open [ 1 ]
          Support Task Type Data Correction [ 11203 ]
          Workflow CT: Task Management Workflow [ 31556 ] WT_Support [ 31599 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107)
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Mandar Kulkarni [ mandark ]
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Remaining Estimate 3h [ 10800 ]
          Original Estimate 3h [ 10800 ]
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) logged work - 02/Feb/17 10:18 AM
          • Time Spent:
            0.5h
             

            Discussion and customization check

          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Remaining Estimate 3h [ 10800 ] 2.5h [ 9000 ]
          Time Spent 0.5h [ 1800 ]
          Worklog Id 22615 [ 22615 ]
          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
          sumeet.kolge Sumeet.Kolge (Inactive) made changes -
          Assignee Mandar Kulkarni [ mandark ] Jyoti Mayne [ jyoti.mayne ]
          sumeet.kolge Sumeet.Kolge (Inactive) logged work - 02/Feb/17 12:06 PM
          • Time Spent:
            3.15h
             

            Analysed and discussed with teams and shared my findings

          sumeet.kolge Sumeet.Kolge (Inactive) made changes -
          Attachment sa utility.PNG [ 38906 ]
          sumeet.kolge Sumeet.Kolge (Inactive) made changes -
          Remaining Estimate 2.5h [ 9000 ] 0h [ 0 ]
          Time Spent 0.5h [ 1800 ] 3.65h [ 13140 ]
          Worklog Id 22630 [ 22630 ]
          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
          jyoti.mayne Jyoti Mayne made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          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
          jyoti.mayne Jyoti Mayne made changes -
          Assignee Jyoti Mayne [ jyoti.mayne ] Umesh Kadam [ umesh.kadam ]
          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?
          michelle.parker Michelle Parker (Inactive) made changes -
          Assignee Umesh Kadam [ umesh.kadam ] Jyoti Mayne [ jyoti.mayne ]
          jyoti.mayne Jyoti Mayne made changes -
          Assignee Jyoti Mayne [ jyoti.mayne ] Umesh Kadam [ umesh.kadam ]
          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
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Assignee Umesh Kadam [ umesh.kadam ] Sheetal Bodhale [ sheetal.bodhale ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Time Spent 3.65h [ 13140 ] 6.65h [ 23940 ]
          Worklog Id 26863 [ 26863 ]
          jyoti.mayne Jyoti Mayne logged work - 23/Feb/17 03:37 PM
          • Time Spent:
            0.75h
             

            scenario and scanning discussion with Umesh and 3C's review

          umesh.kadam Umesh Kadam (Inactive) logged work - 23/Feb/17 05:30 PM - edited
          • Time Spent:
            3.5h
             

            Analysis
            Discussion with Jyoti
            Employee data scan for other affected employees
            Data Correction
            Shared details with Michelle and EDI team for further action items

          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
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Time Spent 6.65h [ 23940 ] 6.8h [ 24480 ]
          Worklog Id 27283 [ 27283 ]
          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
          jyoti.mayne Jyoti Mayne logged work - 24/Feb/17 03:21 PM
          • Time Spent:
            10m
             

            scenario discussion with Sheetal

          jyoti.mayne Jyoti Mayne made changes -
          Time Spent 6.8h [ 24480 ] 6h 58m [ 25080 ]
          Worklog Id 27341 [ 27341 ]
          jyoti.mayne Jyoti Mayne made changes -
          Time Spent 6h 58m [ 25080 ] 7h 43m [ 27780 ]
          Worklog Id 27349 [ 27349 ]
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 25/Feb/17 01:23 AM
          • Time Spent:
            0.15h
             

            internal discussion with jyoti

          umesh.kadam Umesh Kadam (Inactive) made changes -
          Time Spent 7h 43m [ 27780 ] 8h 13m [ 29580 ]
          Worklog Id 26863 [ 26863 ]
          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
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Assignee Sheetal Bodhale [ sheetal.bodhale ] Suraj Sokasane [ suraj.sokasane ]
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Time Spent 8h 13m [ 29580 ] 10h 43m [ 38580 ]
          Worklog Id 27565 [ 27565 ]
          suraj.sokasane Suraj Sokasane (Inactive) logged work - 27/Feb/17 12:43 PM - edited
          • Time Spent:
            4h
             

            Analysis and debugging. Discussion with Sheetal.

          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
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Time Spent 10h 43m [ 38580 ] 11h 13m [ 40380 ]
          Worklog Id 27617 [ 27617 ]
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Time Spent 11h 13m [ 40380 ] 11h 43m [ 42180 ]
          Worklog Id 27631 [ 27631 ]
          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.
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 28/Feb/17 12:13 AM
          • Time Spent:
            2.5h
             
            <No comment>
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 28/Feb/17 01:15 AM
          • Time Spent:
            0.5h
             

            corrected the data

          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 28/Feb/17 01:32 AM
          • Time Spent:
            0.5h
             

            analysis

          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Time Spent 11h 43m [ 42180 ] 15h 43m [ 56580 ]
          Worklog Id 28073 [ 28073 ]
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Worklog Id 28073 [ 28073 ]
          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 .
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Assignee Suraj Sokasane [ suraj.sokasane ] Debbie Kulling [ dkulling ]
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Open [ 1 ] Resolved [ 5 ]
          satyap Satya made changes -
          Environment_New Production [ 18442 ]
          Transition Time In Source Status Execution Times
          darryn.carter made transition -
          To Do Open
          21h 7m 1
          Jyoti Mayne made transition -
          Open In Progress
          13d 14h 26m 1
          Suraj Sokasane (Inactive) made transition -
          In Progress Open
          14d 3h 21m 1
          Suraj Sokasane (Inactive) made transition -
          Open Resolved
          15s 1

            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