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

RCF - SDRMA/GSRMA > Coverage Tier Level Not Populating Correctly on Blue Shield 834 5010

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Cannot Reproduce
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Production
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Support
    • Item State:
      Development - In Progress
    • Issue Importance:
      Must Have
    • Sprint:
      Bugs-Must Fix- Pilot July2016

      Description

      Vinayak Kulkarni @rohan Vijayendra Shinde Cindy Wibbing

      Hi Vinayak,

      Blue Shield reported 6 SSNs that are displaying incorrect coverage tier level code on the 834 5010. I checked the data transformation on all templates/sub templates and cannot see any anomalies there.

      Group Template affected: Blue Shield FACETS 834 5010 SDRMA GSRMA

      I attached a password protected spreadsheet with the SSNs. Sent password to you, rohan and vijayendra.

      Thanks,
      Chris

        Attachments

          Issue Links

            Activity

            Chris.ellenberger Chris Ellenberger created issue -
            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Chris,

            We have corrected coverage tiers from back-end, see attached list for affected people, Thanks.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Chris, We have corrected coverage tiers from back-end, see attached list for affected people, Thanks.
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Field Original Value New Value
            Attachment SDRMA_GSRMA_CoverageTierCorrection.xls [ 17053 ]
            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - SDRMA_GSRMA_CoverageTierCorrection.xls
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Chris Ellenberger [ chris.ellenberger ]
            Resolution Done [ 10000 ]
            Status Open [ 1 ] Resolved [ 5 ]
            Chris.ellenberger Chris Ellenberger made changes -
            Attachment screenshot-1.png [ 17842 ]
            Hide
            Chris.ellenberger Chris Ellenberger added a comment -

            Vinayak Kulkarni

            Hello,

            One more person is being reported having the incorrect coverage tier level.

            SDRMA - Adah McArtor

            This seems to be a very recent enrollment that may have been entered after the previous corrections.

            Can we please determine the root cause of this so it does not happen again?

            Thanks,
            Chris

            Show
            Chris.ellenberger Chris Ellenberger added a comment - Vinayak Kulkarni Hello, One more person is being reported having the incorrect coverage tier level. SDRMA - Adah McArtor This seems to be a very recent enrollment that may have been entered after the previous corrections. Can we please determine the root cause of this so it does not happen again? Thanks, Chris
            Chris.ellenberger Chris Ellenberger made changes -
            Resolution Done [ 10000 ]
            Status Resolved [ 5 ] Reopened [ 4 ]
            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Yes Chris, this has entered after last correction so I am passing this to enrollment team to get root cause & possible fix.

            Amnesh Goel
            Can you look into this, I have corrected this one on SDRMA but this is happening frequently and affecting files.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Yes Chris, this has entered after last correction so I am passing this to enrollment team to get root cause & possible fix. Amnesh Goel Can you look into this, I have corrected this one on SDRMA but this is happening frequently and affecting files.
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Assignee Chris Ellenberger [ chris.ellenberger ] Amnesh Goel [ amnesh.goel ]
            Hide
            amnesh.goel Amnesh Goel (Inactive) added a comment -

            Hi Chris Ellenberger and Vinayak Kulkarni,

            Do we have any idea how this is getting happen? means some sort of steps to understand the flow of this problem?

            Rakesh Roy Hrishikesh Deshpande Deepali Tidke @ I'd need your help on this. Please help to understand and repro this ticket.

            Jyoti Mayne marking to you in case you have any idea over here.

            Thanks,
            Amnesh Goel

            Show
            amnesh.goel Amnesh Goel (Inactive) added a comment - Hi Chris Ellenberger and Vinayak Kulkarni , Do we have any idea how this is getting happen? means some sort of steps to understand the flow of this problem? Rakesh Roy Hrishikesh Deshpande Deepali Tidke @ I'd need your help on this. Please help to understand and repro this ticket. Jyoti Mayne marking to you in case you have any idea over here. Thanks, Amnesh Goel
            amnesh.goel Amnesh Goel (Inactive) made changes -
            Assignee Amnesh Goel [ amnesh.goel ] Rakesh Roy [ rakeshr ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Rakesh Roy [ rakeshr ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Amnesh,

            Nothing specific happened, its simple enrollment added with QE and with wrong HealthTierID.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Amnesh, Nothing specific happened, its simple enrollment added with QE and with wrong HealthTierID.
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            Amnesh Goel We have tried to reproduced this issue but it is not reproducing.

            Employee can enrolled into any plan with any specific coverage tier and same is exporting on file. I dont find scenario to enter Null Coverage Tier Level.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Amnesh Goel We have tried to reproduced this issue but it is not reproducing. Employee can enrolled into any plan with any specific coverage tier and same is exporting on file. I dont find scenario to enter Null Coverage Tier Level.
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Amnesh Goel [ amnesh.goel ]
            Hide
            jyoti.mayne Jyoti Mayne added a comment -

            Hi All,

            We are trying to repro this at Dev side.

            Thanks,
            Jyoti M

            Show
            jyoti.mayne Jyoti Mayne added a comment - Hi All, We are trying to repro this at Dev side. Thanks, Jyoti M
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Amnesh Goel [ amnesh.goel ] Abhijeet Khandagale [ abhijeet.khandagale ]
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Abhijeet Khandagale [ abhijeet.khandagale ] Neelam Yangal [ neelam.yangal ]
            satyap Satya made changes -
            Summary SDRMA/GSRMA > Coverage Tier Level Not Populating Correctly on Blue Shield 834 5010 RCF- SDRMA/GSRMA > Coverage Tier Level Not Populating Correctly on Blue Shield 834 5010
            satyap Satya made changes -
            Summary RCF- SDRMA/GSRMA > Coverage Tier Level Not Populating Correctly on Blue Shield 834 5010 RCF - SDRMA/GSRMA > Coverage Tier Level Not Populating Correctly on Blue Shield 834 5010
            Chris.ellenberger Chris Ellenberger made changes -
            Resolution Cannot Reproduce [ 5 ]
            Status Reopened [ 4 ] Closed [ 6 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Resolution Cannot Reproduce [ 5 ]
            Status Closed [ 6 ] Reopened [ 4 ]
            amruta.lohiya Amruta Lohiya made changes -
            Assignee Neelam Yangal [ neelam.yangal ] Amruta Lohiya [ amruta.baheti ]
            Status Reopened [ 4 ] In Progress [ 3 ]
            vijays Vijay Siddha (Inactive) made changes -
            Issue Type Support Activity [ 10301 ] Bug [ 1 ]
            Status In Progress [ 3 ] In Development [ 10007 ]
            Support Task Type Data Correction [ 11203 ]
            Workflow WT_Support [ 16153 ] WT_Defects [ 18659 ]
            vijays Vijay Siddha (Inactive) made changes -
            Component/s BenAdmin [ 10000 ]
            vijays Vijay Siddha (Inactive) made changes -
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107)
            satyap Satya made changes -
            Item State Parent values: Development(10200)
            satyap Satya made changes -
            Summary RCF - SDRMA/GSRMA > Coverage Tier Level Not Populating Correctly on Blue Shield 834 5010 RCF- SDRMA/GSRMA > Coverage Tier Level Not Populating Correctly on Blue Shield 834 5010
            vijays Vijay Siddha (Inactive) made changes -
            Summary RCF- SDRMA/GSRMA > Coverage Tier Level Not Populating Correctly on Blue Shield 834 5010 RCF - SDRMA/GSRMA > Coverage Tier Level Not Populating Correctly on Blue Shield 834 5010
            satyap Satya made changes -
            Issue Importance Must Have [ 11800 ]
            satyap Satya made changes -
            Sprint Bugs-Must Fix- Pilot July2016 [ 16 ]
            satyap Satya made changes -
            Rank Ranked higher
            vijays Vijay Siddha (Inactive) made changes -
            Item State Parent values: Development(10200) Parent values: Development(10200)Level 1 values: In Progress(10206)
            amruta.lohiya Amruta Lohiya made changes -
            Assignee Amruta Lohiya [ amruta.baheti ] Neelam Yangal [ neelam.yangal ]
            Hide
            Chris.ellenberger Chris Ellenberger added a comment -

            Hrishikesh Deshpande Amnesh Goel Jyoti Mayne

            Hello,

            Blue Shield reported another incorrect coverage tier level.

            Bartels*Jeremy*J

            Showing "EMP" as the tier level but should be "ESP" as his spouse is enrolled.

            Please correct this ASAP. Really need to get to the bottom of why this is still occuring...

            Thanks,
            Chris

            Show
            Chris.ellenberger Chris Ellenberger added a comment - Hrishikesh Deshpande Amnesh Goel Jyoti Mayne Hello, Blue Shield reported another incorrect coverage tier level. Bartels*Jeremy*J Showing "EMP" as the tier level but should be "ESP" as his spouse is enrolled. Please correct this ASAP. Really need to get to the bottom of why this is still occuring... Thanks, Chris
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Assignee Neelam Yangal [ neelam.yangal ] Umesh Kadam [ umesh.kadam ]
            Hide
            umesh.kadam Umesh Kadam (Inactive) added a comment -

            Hi Chris Ellenberger,

            We have corrected data for 'Bartels Jeremy'.

            This issue was not reproducing at our end. So to find the root cause, we added logs in code and deployed on 06/28/2016 but this issue reoccurred for 'Bartels Jeremy' on 6/21/2016. To avoid this issue in future, we are working on highest priority to resolve it.

            Thanks and Regards,
            :: Umesh Kadam

            CC: Amruta Lohiya, Neelam Yangal

            Show
            umesh.kadam Umesh Kadam (Inactive) added a comment - Hi Chris Ellenberger , We have corrected data for 'Bartels Jeremy'. This issue was not reproducing at our end. So to find the root cause, we added logs in code and deployed on 06/28/2016 but this issue reoccurred for 'Bartels Jeremy' on 6/21/2016. To avoid this issue in future, we are working on highest priority to resolve it. Thanks and Regards, :: Umesh Kadam CC: Amruta Lohiya , Neelam Yangal
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Assignee Umesh Kadam [ umesh.kadam ] Neelam Yangal [ neelam.yangal ]
            Hide
            neelam.yangal Neelam Yangal (Inactive) added a comment -

            Samir
            As per our discussion, need audit and correction team for this.

            Show
            neelam.yangal Neelam Yangal (Inactive) added a comment - Samir As per our discussion, need audit and correction team for this.
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Assignee Neelam Yangal [ neelam.yangal ] Samir [ samir ]
            Hide
            Chris.ellenberger Chris Ellenberger added a comment -

            Samir Neelam Yangal Umesh Kadam Amruta Lohiya

            Hello,

            Update on this please?

            Thanks,
            Chris

            Show
            Chris.ellenberger Chris Ellenberger added a comment - Samir Neelam Yangal Umesh Kadam Amruta Lohiya Hello, Update on this please? Thanks, Chris
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Link This issue relates to WT-4762 [ WT-4762 ]
            Chris.ellenberger Chris Ellenberger made changes -
            QA Chris Ellenberger [ chris.ellenberger ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Severity Medium [ 13102 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Samir [ samir ] Jyoti Mayne [ jyoti.mayne ]
            jyoti.mayne Jyoti Mayne made changes -
            Link This issue relates to WT-6927 [ WT-6927 ]
            Hide
            Chris.ellenberger Chris Ellenberger added a comment -

            Hello,

            Can we please close this ticket? Has been open with no activity since July 2016.

            Thanks,
            Chris

            Show
            Chris.ellenberger Chris Ellenberger added a comment - Hello, Can we please close this ticket? Has been open with no activity since July 2016. Thanks, Chris
            Hide
            Chris.ellenberger Chris Ellenberger added a comment -

            Hello,

            Followed up several times on this ticket. SDRMA is no longer a client of WorkTerra. Please determine if there is a need to continue or if the root cause of this issue has been resolved through another ticket.

            Thanks,
            Chris

            cc Abhay Patil Cindy Wibbing

            Show
            Chris.ellenberger Chris Ellenberger added a comment - Hello, Followed up several times on this ticket. SDRMA is no longer a client of WorkTerra. Please determine if there is a need to continue or if the root cause of this issue has been resolved through another ticket. Thanks, Chris cc Abhay Patil Cindy Wibbing
            Chris.ellenberger Chris Ellenberger made changes -
            EDI Analyst 1 Chris Ellenberger [ chris.ellenberger ]
            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Satya Jaideep Vinchurkar Please look into this.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Satya Jaideep Vinchurkar Please look into this.
            Hide
            satyap Satya added a comment -

            Hi Chris Ellenberger,

            We have kept this ticket open since the same issue have been reported by other clients as well. Example: WT-9722.
            This is not getting reproduced in normal scenario, however keeping this open will help us fix the root cause.

            No action required from your side, will update our findings in this JIRA ticket.

            Regards,
            Satya Prakash

            Cc: Jyoti Mayne Vijay Siddha Rakesh Roy Vinayak Kulkarni Jaideep Vinchurkar

            Show
            satyap Satya added a comment - Hi Chris Ellenberger , We have kept this ticket open since the same issue have been reported by other clients as well. Example: WT-9722 . This is not getting reproduced in normal scenario, however keeping this open will help us fix the root cause. No action required from your side, will update our findings in this JIRA ticket. Regards, Satya Prakash Cc: Jyoti Mayne Vijay Siddha Rakesh Roy Vinayak Kulkarni Jaideep Vinchurkar
            amruta.lohiya Amruta Lohiya made changes -
            Assignee Jyoti Mayne [ jyoti.mayne ] Vinanti Yadav [ vinanti.yadav ]
            Hide
            vinanti.yadav Vinanti Yadav (Inactive) added a comment -

            Hi All,

            This RCF is from last year and we tried in different ways, with different browser. But it was non reproducible. We put log files as well, but due to performance, we removed that code. Today (26th July) we got this year corrupted data. So I will start this RCF after my current task WT-10204 .

            Thanks & Regards,
            Vinanti R. Yadav

            CC :Amruta Lohiya, Satya, Vijay Siddha

            Show
            vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hi All, This RCF is from last year and we tried in different ways, with different browser. But it was non reproducible. We put log files as well, but due to performance, we removed that code. Today (26th July) we got this year corrupted data. So I will start this RCF after my current task WT-10204 . Thanks & Regards, Vinanti R. Yadav CC : Amruta Lohiya , Satya , Vijay Siddha
            vinanti.yadav Vinanti Yadav (Inactive) logged work - 31/Jul/17 11:58 AM
            • Time Spent:
              4h
               

              Analysis.

            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Remaining Estimate 24h [ 86400 ]
            Original Estimate 24h [ 86400 ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Remaining Estimate 24h [ 86400 ] 20h [ 72000 ]
            Time Spent 4h [ 14400 ]
            Worklog Id 68282 [ 68282 ]
            vinanti.yadav Vinanti Yadav (Inactive) logged work - 01/Aug/17 08:45 AM
            • Time Spent:
              2h
               

              Analysis.

            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Remaining Estimate 20h [ 72000 ] 18h [ 64800 ]
            Time Spent 4h [ 14400 ] 6h [ 21600 ]
            Worklog Id 68901 [ 68901 ]
            vinanti.yadav Vinanti Yadav (Inactive) logged work - 02/Aug/17 06:24 PM
            • Time Spent:
              4.5h
               

              Analysis.

            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Remaining Estimate 18h [ 64800 ] 13.5h [ 48600 ]
            Time Spent 6h [ 21600 ] 10.5h [ 37800 ]
            Worklog Id 69122 [ 69122 ]
            Hide
            abhay.patil Abhay Patil (Inactive) added a comment -

            I am removing EDI analyst from this ticket as this is purely in the development mode.

            Show
            abhay.patil Abhay Patil (Inactive) added a comment - I am removing EDI analyst from this ticket as this is purely in the development mode.
            abhay.patil Abhay Patil (Inactive) made changes -
            EDI Analyst 1 Chris Ellenberger [ chris.ellenberger ]
            QA Chris Ellenberger [ chris.ellenberger ]
            amruta.lohiya Amruta Lohiya made changes -
            Assignee Vinanti Yadav [ vinanti.yadav ] Amruta Lohiya [ amruta.baheti ]
            Hide
            amruta.lohiya Amruta Lohiya added a comment -

            Rakesh Roy
            Not able to reach the actual root cause. So assigning it to QA if they can help.

            Show
            amruta.lohiya Amruta Lohiya added a comment - Rakesh Roy Not able to reach the actual root cause. So assigning it to QA if they can help.
            amruta.lohiya Amruta Lohiya made changes -
            Assignee Amruta Lohiya [ amruta.baheti ] Rakesh Roy [ rakeshr ]
            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Hrishikesh Deshpande Prasad Pise
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Rakesh Roy [ rakeshr ] Rashmita Dudhe [ rashmita.dudhe ]
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            Rashmita Dudhe As discussed please update max by Sep 20. Earliest updated would be appreciated.

            Hrishikesh DeshpandeSatyaAmruta Lohiya

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Rashmita Dudhe As discussed please update max by Sep 20. Earliest updated would be appreciated. Hrishikesh Deshpande Satya Amruta Lohiya
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 19/Sep/17 08:48 AM
            • Time Spent:
              4h
               
              <No comment>
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified above issue but it is not getting reproduced.
            As per reported employee view history tried below scenarios

            1]Import employee data
            2]Import spouse Information
            3]Done election import on Superior Vision Exam & Materials Plan with EE+SP Tier
            4]Done election In OE period on same plan
            5]Cross verified through Database it showing Correct Healthtier id for both enrollment
            6] the Same scenario is done by UI using OE with the retro date current date and future date
            7]again Cross verified through Database it showing Correct Healthtier id for both enrollment

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified above issue but it is not getting reproduced. As per reported employee view history tried below scenarios 1]Import employee data 2]Import spouse Information 3]Done election import on Superior Vision Exam & Materials Plan with EE+SP Tier 4]Done election In OE period on same plan 5]Cross verified through Database it showing Correct Healthtier id for both enrollment 6] the Same scenario is done by UI using OE with the retro date current date and future date 7]again Cross verified through Database it showing Correct Healthtier id for both enrollment Thanks, Rashmita
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Remaining Estimate 13.5h [ 48600 ] 9.5h [ 34200 ]
            Time Spent 10.5h [ 37800 ] 14.5h [ 52200 ]
            Worklog Id 79609 [ 79609 ]
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi Chris Ellenberger,

            We have tried at our end but this is not getting reproduced.
            You can close this Jira now.

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Chris Ellenberger , We have tried at our end but this is not getting reproduced. You can close this Jira now. Thanks, Rashmita
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Resolution Cannot Reproduce [ 5 ]
            Status In Development [ 10007 ] Rejected [ 10004 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Assignee Rashmita Dudhe [ rashmita.dudhe ] Chris Ellenberger [ chris.ellenberger ]
            Chris.ellenberger Chris Ellenberger made changes -
            Status Rejected [ 10004 ] Closed [ 6 ]
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            Thanks Chris Ellenberger for closing this .

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Thanks Chris Ellenberger for closing this .
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            Transition Time In Source Status Execution Times
            Vinayak Kulkarni (Inactive) made transition -
            Open Resolved
            1h 40m 1
            Chris Ellenberger made transition -
            Resolved Reopen
            11d 22h 9m 1
            Chris Ellenberger made transition -
            Reopen Closed
            20d 23h 29m 1
            Rakesh Roy (Inactive) made transition -
            Closed Reopen
            7d 14h 25m 1
            Amruta Lohiya made transition -
            Reopen In Progress
            8d 23h 3m 1
            Vijay Siddha (Inactive) made transition -
            In Progress In Development
            2h 17m 1
            Rashmita Dudhe (Inactive) made transition -
            In Development Rejected
            451d 19h 31m 1
            Chris Ellenberger made transition -
            Rejected Closed
            6h 44m 1

              People

              Assignee:
              Chris.ellenberger Chris Ellenberger
              Reporter:
              Chris.ellenberger Chris Ellenberger
              Votes:
              0 Vote for this issue
              Watchers:
              11 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 24h
                  24h
                  Remaining:
                  Time Spent - 14.5h Remaining Estimate - 9.5h
                  9.5h
                  Logged:
                  Time Spent - 14.5h Remaining Estimate - 9.5h
                  14.5h