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

Voluntary STD Rate not calculating correctly on payroll file

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Environment:
      Production
    • Module:
      Exchange
    • Reported by:
      Client
    • Company:
      Five Guys
    • Item State:
      Production Complete - Closed

      Description

      Not sure why this rate is not calculating correctly. See attached employees impacted.
      Client is on WT Exchange platform.

      Thanks,
      Alita Henderson
      Lorena.Nava@ebsbenefits.com

        Attachments

        1. Exchange Data Correction.png
          Exchange Data Correction.png
          157 kB
        2. Exchange Data Correction.png
          Exchange Data Correction.png
          157 kB
        3. image-2017-03-08-09-23-36-253.png
          image-2017-03-08-09-23-36-253.png
          64 kB
        4. Matwale McKenzie_ViewHistory.png
          Matwale McKenzie_ViewHistory.png
          173 kB
        5. screenshot-1.png
          screenshot-1.png
          63 kB
        6. screenshot-2.png
          screenshot-2.png
          62 kB
        7. screenshot-3.png
          screenshot-3.png
          24 kB
        8. When GI Applied.png
          When GI Applied.png
          47 kB

          Activity

          Hide
          alitahen Alita Henderson (Inactive) added a comment -

          Reassigning this ticket Dev Team.

          Show
          alitahen Alita Henderson (Inactive) added a comment - Reassigning this ticket Dev Team.
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Please check this.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Please check this.
          Hide
          rakesh.shahane Rakesh Shahane (Inactive) added a comment -

          Hi Alita Henderson,
          We have checked for the Employee Matwale McKenzie whose enrollment went to PendingEOI as attached and found that approved coverage amount as "-1" in the system which should be "0" in case of pending EOI, because of that rate gets recalculated incorrectly on amount "-1" and "-0.02" cost populated on file.
          Same scenario happened with other mentioned employee.

          Now the employee got new enrollment for Voluntary Short Term Disability with proper cost, so on next file records will populate with proper cost.

          Enrollment team will look into this and update.
          Jyoti Mayne-As discussed please update.

          CC-Ganesh Sadawarte, Vinayak Kulkarni

          Show
          rakesh.shahane Rakesh Shahane (Inactive) added a comment - Hi Alita Henderson , We have checked for the Employee Matwale McKenzie whose enrollment went to PendingEOI as attached and found that approved coverage amount as "-1" in the system which should be "0" in case of pending EOI, because of that rate gets recalculated incorrectly on amount "-1" and "-0.02" cost populated on file. Same scenario happened with other mentioned employee. Now the employee got new enrollment for Voluntary Short Term Disability with proper cost, so on next file records will populate with proper cost. Enrollment team will look into this and update. Jyoti Mayne -As discussed please update. CC- Ganesh Sadawarte , Vinayak Kulkarni
          Hide
          vinanti.yadav Vinanti Yadav (Inactive) added a comment -

          Hello Alita Henderson,

          Please find below 3C's :

          Concern :Employee gets approved coverage amount as -1.

          Cause : When employee is log in into system and completing its work flow, after clicking View Recommended Plans Employee gets enrollment with coverage amount as -1. Due to this it get rates in minus amount.

          Correction : we are working on code fix. we will update you once code fix is done.

          Thanks & Regards,
          Vinanti

          CC : Jyoti Mayne

          Show
          vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hello Alita Henderson , Please find below 3C's : Concern :Employee gets approved coverage amount as -1. Cause : When employee is log in into system and completing its work flow, after clicking View Recommended Plans Employee gets enrollment with coverage amount as -1. Due to this it get rates in minus amount. Correction : we are working on code fix. we will update you once code fix is done. Thanks & Regards, Vinanti CC : Jyoti Mayne
          Hide
          alitahen Alita Henderson (Inactive) added a comment -

          Hello Vinanti,

          Have updated the minimum Coverage from $1 to "0" on both Voluntary Short Term Disability plans. See screen print from Plan Design Name : FGO Shift Managers Voluntary Short Term Disability-Voluntary STD-CIGNA and screen print from Plan Design Name : Voluntary Short Term Disability-Voluntary STD-CIGNA

          Please advise if these changes impact your code fix.

          Thanks.
          Alita

          Show
          alitahen Alita Henderson (Inactive) added a comment - Hello Vinanti, Have updated the minimum Coverage from $1 to "0" on both Voluntary Short Term Disability plans. See screen print from Plan Design Name : FGO Shift Managers Voluntary Short Term Disability-Voluntary STD-CIGNA and screen print from Plan Design Name : Voluntary Short Term Disability-Voluntary STD-CIGNA Please advise if these changes impact your code fix. Thanks. Alita
          Hide
          vinanti.yadav Vinanti Yadav (Inactive) added a comment -

          Hi Alita Henderson,

          Please refer below 3C's :

          Concern: Employee is getting $-1 approved coverage amount with new hire mode and election pended for EOI, even though Guarantee Issue amount is not set for new hire mode

          Cause: If GI is not set for new hire mode, system internally considering -1 as GI value and therefore approved coverage amount is getting set as -1 and election pended for EOI.
          Due to this -1 approved coverage amount, rate value is coming in minus.

          Correction: We have fixed code for this scenario and will update you once it is deployed on stage and production.

          Note: We have scanned all enrollment and found following employees who got -1 approved coverage amount, election pended for EOI and rate in minus amount.

          First Name Last Name Plan Name Approved Coverage Amount Applied Coverage Amount
          Kevin Garden Voluntary Long Term Disability -1 5000
          Sherry McKee Voluntary Long Term Disability -1 1382.16
          Sherry McKee Voluntary Short Term Disability -1 318.96

          Please provide your approval on this correction. We will remove pending EOI and set Applied and Approved coverage amount same and calculate their rates.

          There no impact of update in minimum Coverage from $1 to "0" on this code.

          Cc: Jyoti Mayne

          Show
          vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hi Alita Henderson , Please refer below 3C's : Concern: Employee is getting $-1 approved coverage amount with new hire mode and election pended for EOI, even though Guarantee Issue amount is not set for new hire mode Cause: If GI is not set for new hire mode, system internally considering -1 as GI value and therefore approved coverage amount is getting set as -1 and election pended for EOI. Due to this -1 approved coverage amount, rate value is coming in minus. Correction: We have fixed code for this scenario and will update you once it is deployed on stage and production. Note: We have scanned all enrollment and found following employees who got -1 approved coverage amount, election pended for EOI and rate in minus amount. First Name Last Name Plan Name Approved Coverage Amount Applied Coverage Amount Kevin Garden Voluntary Long Term Disability -1 5000 Sherry McKee Voluntary Long Term Disability -1 1382.16 Sherry McKee Voluntary Short Term Disability -1 318.96 Please provide your approval on this correction. We will remove pending EOI and set Applied and Approved coverage amount same and calculate their rates. There no impact of update in minimum Coverage from $1 to "0" on this code. Cc: Jyoti Mayne
          Hide
          alankar.chavan Alankar Chavan (Inactive) added a comment -

          We have tested this on Wt Stage - Five Guys for Exchange - this is working well

          • when GI applied to a plan - system shows a right applied and approved coverage on the enrollment screens (not -1)
          • when NO GI is applied - system allows employee to enroll with any available coverage amounts available without sending the election request to PENDING EOI
          • above scenarios are tested with Exchange - New Hire | Qualifying Event and Open Enrollment modes
          • we reproduced the issue first on stage (as the fix is not available there yet to understand the exact steps to test this fix on WT STAGE)

          While doing the impact testing - we found below 2 issues (probably not resulting from this fix - but we need to look at them as well)

          WT-8882
          WT-8883

          This is ready for Stage now

          CC - Prasad Pise Rakesh Roy Vinanti Yadav Jyoti Mayne

          Show
          alankar.chavan Alankar Chavan (Inactive) added a comment - We have tested this on Wt Stage - Five Guys for Exchange - this is working well when GI applied to a plan - system shows a right applied and approved coverage on the enrollment screens (not -1) when NO GI is applied - system allows employee to enroll with any available coverage amounts available without sending the election request to PENDING EOI above scenarios are tested with Exchange - New Hire | Qualifying Event and Open Enrollment modes we reproduced the issue first on stage (as the fix is not available there yet to understand the exact steps to test this fix on WT STAGE) While doing the impact testing - we found below 2 issues (probably not resulting from this fix - but we need to look at them as well) WT-8882 WT-8883 This is ready for Stage now CC - Prasad Pise Rakesh Roy Vinanti Yadav Jyoti Mayne
          Hide
          alankar.chavan Alankar Chavan (Inactive) added a comment -

          Show
          alankar.chavan Alankar Chavan (Inactive) added a comment -
          Hide
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment -

          Please proceed with the necessary corrections. Thanks.

          Show
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment - Please proceed with the necessary corrections. Thanks.
          Hide
          alankar.chavan Alankar Chavan (Inactive) added a comment -

          Hello Jyoti Mayne,

          Can you please go ahead with the necessary corrections ? Once done, please let us know the details. We will test the same.

          Also with the normal patch procedure, this fix will be getting tested on Stage as well as Production - once deployed on the respective environments .

          CC - Prasad Pise Rakesh Roy Vinanti Yadav

          Show
          alankar.chavan Alankar Chavan (Inactive) added a comment - Hello Jyoti Mayne , Can you please go ahead with the necessary corrections ? Once done, please let us know the details. We will test the same. Also with the normal patch procedure, this fix will be getting tested on Stage as well as Production - once deployed on the respective environments . CC - Prasad Pise Rakesh Roy Vinanti Yadav
          Hide
          vinanti.yadav Vinanti Yadav (Inactive) added a comment -

          Hi Lorena.Nava@ebsbenefits.com,

          Correction for above mentioned employee's is done on production.

          Thanks & Regards,
          Vinanti R. Yadav

          CC - Alita Henderson, Jyoti Mayne, Alankar Chavan

          Show
          vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hi Lorena.Nava@ebsbenefits.com , Correction for above mentioned employee's is done on production. Thanks & Regards, Vinanti R. Yadav CC - Alita Henderson , Jyoti Mayne , Alankar Chavan
          Hide
          alankar.chavan Alankar Chavan (Inactive) added a comment -

          Above mentioned scenarios are tested on Stage - working well

          Ready for Production

          CC - Prasad Pise Rakesh Roy

          Show
          alankar.chavan Alankar Chavan (Inactive) added a comment - Above mentioned scenarios are tested on Stage - working well Ready for Production CC - Prasad Pise Rakesh Roy
          Hide
          alankar.chavan Alankar Chavan (Inactive) added a comment -

          The fix is available on Production
          Because of the other prioritized items - we have not started testing this yet.
          We will take the fix to test soon and update the status.

          Show
          alankar.chavan Alankar Chavan (Inactive) added a comment - The fix is available on Production Because of the other prioritized items - we have not started testing this yet. We will take the fix to test soon and update the status.
          Hide
          alankar.chavan Alankar Chavan (Inactive) added a comment -

          Hello Lorena.Nava@ebsbenefits.com,

          The fix is deployed and tested on production (scenarios tested are mentioned in above comments)
          Respective data correction is also done and tested for Kelvin Garden and Sherry McKee

          Please review at your end and if everything working as per your expectations - you may clse this JIRA

          CC - Rakesh Roy Prasad Pise Jyoti Mayne Vinanti Yadav

          Show
          alankar.chavan Alankar Chavan (Inactive) added a comment - Hello Lorena.Nava@ebsbenefits.com , The fix is deployed and tested on production (scenarios tested are mentioned in above comments) Respective data correction is also done and tested for Kelvin Garden and Sherry McKee Please review at your end and if everything working as per your expectations - you may clse this JIRA CC - Rakesh Roy Prasad Pise Jyoti Mayne Vinanti Yadav
          Hide
          darryn.carter darryn.carter added a comment -

          Hello Dev

          Alankar Chavan please review Justin Lawless record for Voluntary Short Term Disability

          Show
          darryn.carter darryn.carter added a comment - Hello Dev Alankar Chavan please review Justin Lawless record for Voluntary Short Term Disability
          Hide
          alankar.chavan Alankar Chavan (Inactive) added a comment -

          Hello Vinanti Yadav,

          Please look at Justin Lawless's enrollment record for Voluntary Short Term Disability

          The same issue seems to be with this employee as that of Kelvin Garden and Sherry McKee.

          Can you correct his data ?

          Along with this, can you also scan over the company to find out all employee facing the same problem ? We can correct their data collectively.

          Please update the details / queries to client needed for data correction.

          CC - Prasad Pise Rakesh Roy Jyoti Mayne

          Show
          alankar.chavan Alankar Chavan (Inactive) added a comment - Hello Vinanti Yadav , Please look at Justin Lawless's enrollment record for Voluntary Short Term Disability The same issue seems to be with this employee as that of Kelvin Garden and Sherry McKee. Can you correct his data ? Along with this, can you also scan over the company to find out all employee facing the same problem ? We can correct their data collectively. Please update the details / queries to client needed for data correction. CC - Prasad Pise Rakesh Roy Jyoti Mayne
          Hide
          alitahen Alita Henderson (Inactive) added a comment -

          Attached the latest client inquiry on this issue, as of 4/4/2017.

          Please advise on status of resolution for this item.
          Thank you.
          Alita Henderson
          Lorena.Nava@ebsbenefits.com

          Show
          alitahen Alita Henderson (Inactive) added a comment - Attached the latest client inquiry on this issue, as of 4/4/2017. Please advise on status of resolution for this item. Thank you. Alita Henderson Lorena.Nava@ebsbenefits.com
          Hide
          vinanti.yadav Vinanti Yadav (Inactive) added a comment -

          Hello Alita Henderson,

          Please find below details:

          Code fix for this issue was deployed on 3/23/2017 on production.

          But for EE 'Justin Lawless' enrollment was done on 3/20/2017.

          We have scanned all employees and found only reported employee having this issue and corrected his enrollment and rate data.

          Thanks & Regards,
          Vinanti R. Yadav

          CC : darryn.carter, Jyoti Mayne, Alankar Chavan

          Show
          vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hello Alita Henderson , Please find below details: Code fix for this issue was deployed on 3/23/2017 on production. But for EE 'Justin Lawless' enrollment was done on 3/20/2017. We have scanned all employees and found only reported employee having this issue and corrected his enrollment and rate data. Thanks & Regards, Vinanti R. Yadav CC : darryn.carter , Jyoti Mayne , Alankar Chavan

            People

            Assignee:
            alitahen Alita Henderson (Inactive)
            Reporter:
            alitahen Alita Henderson (Inactive)
            Developer:
            Vinanti Yadav (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Dev Due Date:
              Code Review Date:

                Time Tracking

                Estimated:
                Original Estimate - 40h Original Estimate - 40h
                40h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 40.54h
                40.54h