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

Five Guys: Pending EOI approved amounts not updated in exchange platform

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Support Task Type:
      Data Correction
    • Reported by:
      Client
    • Company:
      Five Guys
    • Module:
      BenAdmin - Enrollment

      Description

      Client believes that the EOI ‘approved coverage amounts’ were not all updated in exchange from the benadmin platform. There are 677 pending EOI. Please advise on this urgent request. Thanks.

        Attachments

        1. image001.jpg
          image001.jpg
          1.0 kB
        2. image002.jpg
          image002.jpg
          1 kB
        3. image003.png
          image003.png
          1 kB
        4. image004.png
          image004.png
          5 kB
        5. image005.jpg
          image005.jpg
          64 kB
        6. image006.jpg
          image006.jpg
          2 kB
        7. image007.jpg
          image007.jpg
          3 kB
        8. image009.png
          image009.png
          0.6 kB
        9. Pending EOI List Five Guys.zip
          423 kB
        10. Pending EOI List Five Guys 1.17.1729542_3971.xls
          7.83 MB

          Activity

          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) created issue -
          Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) made changes -
          Field Original Value New Value
          Environment Production [ 10005 ]
          Issue Type Task [ 3 ] Support Activity [ 10301 ]
          Key CT-796 WT-7750
          Project WORKTERRA-CT [ 10800 ] WORKTERRA [ 10000 ]
          Status To Do [ 10000 ] Open [ 1 ]
          Support Task Type Data Correction [ 11203 ]
          Workflow CT: Task Management Workflow [ 30519 ] WT_Support [ 30534 ]
          Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) made changes -
          Assignee Vijay Siddha [ vijays ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Assignee Vijay Siddha [ vijays ] Avnish Yadav [ avnish.yadav ]
          avnish.yadav Avnish Yadav (Inactive) logged work - 16/Jan/17 10:03 AM
          • Time Spent:
            8h
             
            <No comment>
          Hide
          avnish.yadav Avnish Yadav (Inactive) added a comment -

          Hi Lorena.Nava@ebsbenefits.com,

          Due to other priority task we are unable to work on this.

          Thanks,
          Avnish Y

          Show
          avnish.yadav Avnish Yadav (Inactive) added a comment - Hi Lorena.Nava@ebsbenefits.com , Due to other priority task we are unable to work on this. Thanks, Avnish Y
          Hide
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment -

          Hi Traci: Please see message from Avnish. Does this mean they will do anything or it just means it's not priority? Thanks.

          Show
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment - Hi Traci: Please see message from Avnish. Does this mean they will do anything or it just means it's not priority? Thanks.
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) made changes -
          Assignee Avnish Yadav [ avnish.yadav ] Traci Simpson [ traci.simpson@ebsbenefits.com ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Assignee Traci Simpson [ traci.simpson@ebsbenefits.com ] Avnish Yadav [ avnish.yadav ]
          Status Open [ 1 ] In Progress [ 3 ]
          avnish.yadav Avnish Yadav (Inactive) logged work - 17/Jan/17 10:04 AM
          • Time Spent:
            8h
             
            <No comment>
          Hide
          avnish.yadav Avnish Yadav (Inactive) added a comment -

          Hi Lorena.Nava@ebsbenefits.com,

          We moved Five Guys from Benadmin to Exchange on '27 Oct 2016' It is long period and we do not have any database back up of this date, So did not compare data from Benadmin to Exchange. We have also requested to Virzon to provide database backup of '27 Oct 2016' and it will take 4 to 5 working days.

          Could please provide list of 677 employees,so that we can start correction of these impacted employees.

          Thanks,
          Avnish Y

          CC-Jyoti Mayne,Satya,Vijay Siddha

          Show
          avnish.yadav Avnish Yadav (Inactive) added a comment - Hi Lorena.Nava@ebsbenefits.com , We moved Five Guys from Benadmin to Exchange on '27 Oct 2016' It is long period and we do not have any database back up of this date, So did not compare data from Benadmin to Exchange. We have also requested to Virzon to provide database backup of '27 Oct 2016' and it will take 4 to 5 working days. Could please provide list of 677 employees,so that we can start correction of these impacted employees. Thanks, Avnish Y CC- Jyoti Mayne , Satya , Vijay Siddha
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Assignee Avnish Yadav [ avnish.yadav ] Lorena Nava [ lorena.nava@ebsbenefits.com ]
          Hide
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment -

          Please see attached pending EOI report as of today. I pulled up all EOI pending. Thanks. Pending EOI List Five Guys 1.17.1729542_3971.xls

          Show
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment - Please see attached pending EOI report as of today. I pulled up all EOI pending. Thanks. Pending EOI List Five Guys 1.17.1729542_3971.xls
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Assignee Lorena Nava [ lorena.nava@ebsbenefits.com ] Avnish Yadav [ avnish.yadav ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Attachment Pending EOI List Five Guys.xls [ 37710 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Attachment Pending EOI List Five Guys.xls [ 37710 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Attachment Pending EOI List Five Guys.zip [ 37713 ]
          Hide
          avnish.yadav Avnish Yadav (Inactive) added a comment -

          Hi Lorena.Nava@ebsbenefits.com,

          We have verified given report and found that records are not correct on this report and also effective date of employee is not correct, for this report issue, we have created WT-7867 jira ticket and assign this to report team.

          We attached new report for EOI pending, so could you please verify this report and let us know in case EOI pending data is correct or not on report. Attached file is password protected.

          Thanks,
          Avnish Y

          CC- Jyoti Mayne,Satya

          Show
          avnish.yadav Avnish Yadav (Inactive) added a comment - Hi Lorena.Nava@ebsbenefits.com , We have verified given report and found that records are not correct on this report and also effective date of employee is not correct, for this report issue, we have created WT-7867 jira ticket and assign this to report team. We attached new report for EOI pending, so could you please verify this report and let us know in case EOI pending data is correct or not on report. Attached file is password protected. Thanks, Avnish Y CC- Jyoti Mayne , Satya
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Assignee Avnish Yadav [ avnish.yadav ] Lorena Nava [ lorena.nava@ebsbenefits.com ]
          Hide
          jennifer.leugers Jennifer Leugers added a comment - - edited

          All - none of us are certain what you want us to do. What we need done is to verify all of the pending EOIs from Five Guys 2016 as of now for the 2016 elections are showing correctly in Five Guys client in Exchange for STD, LTD and the Voluntary Life plans. This needs to be reviewed and done tonight. This has been escalated to the Broker and our Upper Management so we cannot have any exceptions to this being done tonight.

          Samir
          Satya
          Amruta Lohiya

          Show
          jennifer.leugers Jennifer Leugers added a comment - - edited All - none of us are certain what you want us to do. What we need done is to verify all of the pending EOIs from Five Guys 2016 as of now for the 2016 elections are showing correctly in Five Guys client in Exchange for STD, LTD and the Voluntary Life plans. This needs to be reviewed and done tonight. This has been escalated to the Broker and our Upper Management so we cannot have any exceptions to this being done tonight. Samir Satya Amruta Lohiya
          jennifer.leugers Jennifer Leugers made changes -
          Assignee Lorena Nava [ lorena.nava@ebsbenefits.com ] Avnish Yadav [ avnish.yadav ]
          Hide
          avnish.yadav Avnish Yadav (Inactive) added a comment -

          Hi Jennifer Leugers,

          We asked Lorena.Nava@ebsbenefits.com to provide list of 677 employees those are impacted by this and she provided report "Pending EOI List Five Guys 1.17.1729542_3971" it contain around 14,139 records and we reviewed this report and found record on report are not correct because it is showing employee effective date '01/01/2016' but his/her effective date is '01/01/2017'.

          Is client referring "Pending EOI List Five Guys 1.17.1729542_3971" to validate pending EIOs from Benadmin to Exchange, if yes then it is wrong because this report does not has proper records. If Not please provide list of employee that client is referring to validate data, so we can investigate more on this and find root cause of this issue.

          We have also fetched new report from backend with valid data, please use this report to validate pending EIOs and As per our understanding when we moved Five Guys company from Benadmin to Exchange platform, at that time we moved complete data to Exchange platform.

          Note:- Meanwhile we have also requested to Virzon to provide database backup of '27 Oct 2016' when we moved Five Guys from Benadmin to Exchange and it will take 4 to 5 working days. We are doing this to confirm Enrollment data was moved properly from Benadmin to Exchange.

          Lorena.Nava@ebsbenefits.com we tried call you on your cell, regrading all five guys issue. Could you please send a mail when you will come online, so we can discuss all Five Guys issues.

          Thanks,
          Avnish Y

          CC- Jyoti Mayne,Satya,Samir

          Show
          avnish.yadav Avnish Yadav (Inactive) added a comment - Hi Jennifer Leugers , We asked Lorena.Nava@ebsbenefits.com to provide list of 677 employees those are impacted by this and she provided report " Pending EOI List Five Guys 1.17.1729542_3971 " it contain around 14,139 records and we reviewed this report and found record on report are not correct because it is showing employee effective date '01/01/2016' but his/her effective date is '01/01/2017'. Is client referring "Pending EOI List Five Guys 1.17.1729542_3971" to validate pending EIOs from Benadmin to Exchange, if yes then it is wrong because this report does not has proper records. If Not please provide list of employee that client is referring to validate data, so we can investigate more on this and find root cause of this issue. We have also fetched new report from backend with valid data, please use this report to validate pending EIOs and As per our understanding when we moved Five Guys company from Benadmin to Exchange platform, at that time we moved complete data to Exchange platform. Note:- Meanwhile we have also requested to Virzon to provide database backup of '27 Oct 2016' when we moved Five Guys from Benadmin to Exchange and it will take 4 to 5 working days. We are doing this to confirm Enrollment data was moved properly from Benadmin to Exchange. Lorena.Nava@ebsbenefits.com we tried call you on your cell, regrading all five guys issue. Could you please send a mail when you will come online, so we can discuss all Five Guys issues. Thanks, Avnish Y CC- Jyoti Mayne , Satya , Samir
          Hide
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment -

          Please call me asap at 909-215-8056. Thank you!

          Show
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment - Please call me asap at 909-215-8056. Thank you!
          Hide
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment -

          Hi Avnish: Please call me 909-215-8056. Thank you!

          Lorena Nava | Client Services Manager
          Employee Benefit Specialists, Inc.
          PO Box 11657, Pleasanton, CA 94588
          PH: 888-327-2770 | Mobile: 909-215-8056
          FAX: 925-460-3920 | lorena.nava@ebsbenefits.com<lorena.nava@ebsbenefits.com>
          [Description: Description: Description: Description: Description: twitter]<http://twitter.com/#!/workterra> [Description: Description: Description: Description: Description: linkedin-tiny-square2] <http://www.linkedin.com/company/workterra> [Description: Description: Description: cid:image003.png@01CD3F49.3D5BC7C0] <http://www.facebook.com/workterra>

          Show
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment - Hi Avnish: Please call me 909-215-8056. Thank you! Lorena Nava | Client Services Manager Employee Benefit Specialists, Inc. PO Box 11657, Pleasanton, CA 94588 PH: 888-327-2770 | Mobile: 909-215-8056 FAX: 925-460-3920 | lorena.nava@ebsbenefits.com< lorena.nava@ebsbenefits.com > [Description: Description: Description: Description: Description: twitter] < http://twitter.com/#!/workterra > [Description: Description: Description: Description: Description: linkedin-tiny-square2] < http://www.linkedin.com/company/workterra > [Description: Description: Description: cid:image003.png@01CD3F49.3D5BC7C0] < http://www.facebook.com/workterra >
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) made changes -
          Attachment image001.jpg [ 37821 ]
          Attachment image002.jpg [ 37822 ]
          Attachment image003.png [ 37823 ]
          Attachment image004.png [ 37824 ]
          Attachment image005.jpg [ 37825 ]
          Attachment image006.jpg [ 37826 ]
          Attachment image007.jpg [ 37827 ]
          Attachment image009.png [ 37828 ]
          Hide
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment -

          Hi Avnish: I left you an email and also replied to this JIRA ticket. The client did not provide a list but rather instructed us to review the pending que since there are many people setting in pending.

          Show
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment - Hi Avnish: I left you an email and also replied to this JIRA ticket. The client did not provide a list but rather instructed us to review the pending que since there are many people setting in pending.
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
          Hide
          avnish.yadav Avnish Yadav (Inactive) added a comment -

          Hi Lorena.Nava@ebsbenefits.com,

          As per our discussion in call we are waiting for list of 677 employees that are not moved from Benadmin to Exchange platform. Once we received this list Today (01/20/2017 IST), we will corrected these impacted employees before Monday morning(01/23/2017) PST.

          Thanks,
          Avnish Y

          CC-Jyoti Mayne,Rakesh Roy,Vijay Siddha,Satya

          Show
          avnish.yadav Avnish Yadav (Inactive) added a comment - Hi Lorena.Nava@ebsbenefits.com , As per our discussion in call we are waiting for list of 677 employees that are not moved from Benadmin to Exchange platform. Once we received this list Today (01/20/2017 IST), we will corrected these impacted employees before Monday morning(01/23/2017) PST. Thanks, Avnish Y CC- Jyoti Mayne , Rakesh Roy , Vijay Siddha , Satya
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Assignee Avnish Yadav [ avnish.yadav ] Lorena Nava [ lorena.nava@ebsbenefits.com ]
          Hide
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment -

          Traci:
          Regarding JIRA ticket WORKTERRA WT-7750 for Five Guys. Five Guys: Pending EOI approved amounts not updated in exchange platform. They said there were too many records in the file I sent them. Dev confirmed they are not able to proceed with this ticket because they need a report that shows the pending EOI approved amounts/records that need to be fixed in Five Guys 2017 site. Could I ask for your help to forward this report to Avnish? He said upon receipt of this report it will take one day to fix. Thanks.

          Show
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment - Traci: Regarding JIRA ticket WORKTERRA WT-7750 for Five Guys. Five Guys: Pending EOI approved amounts not updated in exchange platform. They said there were too many records in the file I sent them. Dev confirmed they are not able to proceed with this ticket because they need a report that shows the pending EOI approved amounts/records that need to be fixed in Five Guys 2017 site. Could I ask for your help to forward this report to Avnish? He said upon receipt of this report it will take one day to fix. Thanks.
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) made changes -
          Assignee Lorena Nava [ lorena.nava@ebsbenefits.com ] Traci Simpson [ traci.simpson@ebsbenefits.com ]
          Hide
          Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) added a comment -

          Hello Lorena.Nava@ebsbenefits.com

          Per Jennifer Johnson email, she will assist with this.

          Regards

          Show
          Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) added a comment - Hello Lorena.Nava@ebsbenefits.com Per Jennifer Johnson email, she will assist with this. Regards
          Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) made changes -
          Assignee Traci Simpson [ traci.simpson@ebsbenefits.com ] Jennifer Fernandes [ jjsassy99 ]
          satyap Satya made changes -
          Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107)
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Remaining Estimate 24h [ 86400 ]
          Original Estimate 24h [ 86400 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Remaining Estimate 24h [ 86400 ] 16h [ 57600 ]
          Time Spent 8h [ 28800 ]
          Worklog Id 21914 [ 21914 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Remaining Estimate 16h [ 57600 ] 8h [ 28800 ]
          Time Spent 8h [ 28800 ] 16h [ 57600 ]
          Worklog Id 21915 [ 21915 ]
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment -

          Lorena.Nava@ebsbenefits.com Is this pending?

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Lorena.Nava@ebsbenefits.com Is this pending?
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment -
          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Lorena.Nava@ebsbenefits.com Still pending?
          Hide
          jjsassy99 Jennifer Johnson (Inactive) added a comment -

          This is no longer an issue.

          Jenni

          Show
          jjsassy99 Jennifer Johnson (Inactive) added a comment - This is no longer an issue. Jenni
          jjsassy99 Jennifer Johnson (Inactive) made changes -
          Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
          Hide
          jjsassy99 Jennifer Johnson (Inactive) added a comment -

          No action needed.

          Show
          jjsassy99 Jennifer Johnson (Inactive) added a comment - No action needed.
          jjsassy99 Jennifer Johnson (Inactive) made changes -
          Resolution Unresolved [ 10200 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Resolution Unresolved [ 10200 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Reopened [ 4 ] Resolved [ 5 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times
          Traci Simpson (Inactive) made transition -
          To Do Open
          5h 7m 1
          Avnish Yadav (Inactive) made transition -
          Open In Progress
          4d 6h 22m 1
          Avnish Yadav (Inactive) made transition -
          In Progress Waiting for Customer Input
          18h 26m 3
          Jennifer Johnson (Inactive) made transition -
          Waiting for Customer Input In Progress
          71d 15h 43m 3
          Jennifer Johnson (Inactive) made transition -
          In Progress Closed
          12s 1
          Rakesh Roy (Inactive) made transition -
          Closed Reopen
          9h 56m 1
          Rakesh Roy (Inactive) made transition -
          Reopen Resolved
          13s 1
          Rakesh Roy (Inactive) made transition -
          Resolved Closed
          4s 1

            People

            Assignee:
            jjsassy99 Jennifer Johnson (Inactive)
            Reporter:
            lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 24h
                24h
                Remaining:
                Time Spent - 16h Remaining Estimate - 8h
                8h
                Logged:
                Time Spent - 16h Remaining Estimate - 8h
                16h