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

RCF - CAISO Issues with Reports

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Production
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Client

      Description

      Jennifer Johnson

      Client ran enrollment report 1/1/2017 - 12/31/2017

      EE7563 showed EE only
      but her confirmation statement shows that she added her child to coverage last November during OE for 2016 and he has remained continuously covered. I double checked the history in the employee’s Enrollment History Report.The client is expecting the coverage tier to show EE + CH.

      Is there another date range they are supposed to run? They are trying to ensure they finish their data scrub today but they think the reports are inaccurate.

        Attachments

        1. 2017 - Report.png
          2017 - Report.png
          164 kB
        2. image001.jpg
          image001.jpg
          1.0 kB
        3. image002.jpg
          image002.jpg
          1 kB
        4. image003.png
          image003.png
          1 kB
        5. image004.jpg
          image004.jpg
          1 kB
        6. image005.png
          image005.png
          5 kB
        7. image006.jpg
          image006.jpg
          64 kB
        8. image007.jpg
          image007.jpg
          2 kB
        9. image008.jpg
          image008.jpg
          2 kB
        10. image010.png
          image010.png
          0.7 kB
        11. screenshot-1.png
          screenshot-1.png
          21 kB
        12. screenshot-2.png
          screenshot-2.png
          18 kB
        13. WrongHealthTierIDCorrectionCompanyList.xls
          55 kB
        14. WT-6927_CoverageTierLabel.png
          WT-6927_CoverageTierLabel.png
          18 kB
        15. WT-6927.png
          WT-6927.png
          12 kB

          Issue Links

            Activity

            jphi Jennifer Melgoza created issue -
            janine.calendo Janine Calendo (Inactive) made changes -
            Field Original Value New Value
            Assignee janine.calendo [ janine.calendo ]
            janine.calendo Janine Calendo (Inactive) made changes -
            Attachment screenshot-1.png [ 34557 ]
            janine.calendo Janine Calendo (Inactive) made changes -
            Attachment screenshot-2.png [ 34558 ]
            Hide
            janine.calendo Janine Calendo (Inactive) added a comment -


            JP, I viewed the EE and I see them enrolled. View these screen shots for future dates 1/01/17 - 12/31/17 Janine

            Show
            janine.calendo Janine Calendo (Inactive) added a comment - JP, I viewed the EE and I see them enrolled. View these screen shots for future dates 1/01/17 - 12/31/17 Janine
            Hide
            jphi Jennifer Melgoza added a comment -

            Janie,
            I see them enrolled in WT but what about the enrollment report?

            Jennifer Philp | Account Executive, WORKTERRA
            Employee Benefit Specialists, Inc.
            PO Box 11657, Pleasanton, CA 94588
            PH: 925-218-3532 | FAX: 925-460-3920 | jennifer.philp@ebsbenefits.com<jennifer.philp@ebsbenefits.com>
            [cid:image001.jpg@01D24FC9.BA2DA4E0]<http://twitter.com/#!/workterra> [cid:image002.jpg@01D24FC9.BA2DA4E0] <http://www.linkedin.com/company/workterra> [cid:image003.png@01D24FC9.BA2DA4E0] <http://www.facebook.com/workterra> [Description: Description: Description: http://chemtool.com/uploaded/six%20sigma%20logo.jpg] <http://en.wikipedia.org/wiki/Six_Sigma>

            Show
            jphi Jennifer Melgoza added a comment - Janie, I see them enrolled in WT but what about the enrollment report? Jennifer Philp | Account Executive, WORKTERRA Employee Benefit Specialists, Inc. PO Box 11657, Pleasanton, CA 94588 PH: 925-218-3532 | FAX: 925-460-3920 | jennifer.philp@ebsbenefits.com< jennifer.philp@ebsbenefits.com > [cid:image001.jpg@01D24FC9.BA2DA4E0] < http://twitter.com/#!/workterra > [cid:image002.jpg@01D24FC9.BA2DA4E0] < http://www.linkedin.com/company/workterra > [cid:image003.png@01D24FC9.BA2DA4E0] < http://www.facebook.com/workterra > [Description: Description: Description: http://chemtool.com/uploaded/six%20sigma%20logo.jpg] < http://en.wikipedia.org/wiki/Six_Sigma >
            jphi Jennifer Melgoza made changes -
            Attachment image001.jpg [ 34559 ]
            Attachment image002.jpg [ 34560 ]
            Attachment image003.png [ 34561 ]
            Attachment image004.jpg [ 34562 ]
            Attachment image005.png [ 34563 ]
            Attachment image006.jpg [ 34564 ]
            Attachment image007.jpg [ 34565 ]
            Attachment image008.jpg [ 34566 ]
            Attachment image010.png [ 34567 ]
            janine.calendo Janine Calendo (Inactive) made changes -
            Assignee janine.calendo [ janine.calendo ] Jennifer Philp [ jphi ]
            Hide
            jphi Jennifer Melgoza added a comment -

            I see, can you tell me how you ran the report?

            Show
            jphi Jennifer Melgoza added a comment - I see, can you tell me how you ran the report?
            Hide
            janine.calendo Janine Calendo (Inactive) added a comment -

            Have the client view the 2017 Report saved

            Show
            janine.calendo Janine Calendo (Inactive) added a comment - Have the client view the 2017 Report saved
            janine.calendo Janine Calendo (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status To Do [ 10000 ] Done [ 10001 ]
            jphi Jennifer Melgoza made changes -
            Resolution Done [ 10000 ]
            Status Done [ 10001 ] To Do [ 10000 ]
            satyap Satya made changes -
            Environment Production [ 10005 ]
            Issue Type Task [ 3 ] Support Activity [ 10301 ]
            Key CT-559 WT-6927
            Project WORKTERRA-CT [ 10800 ] WORKTERRA [ 10000 ]
            Status To Do [ 10000 ] Open [ 1 ]
            Support Task Type Query Resolution [ 11205 ]
            Workflow CT: Task Management Workflow [ 28309 ] WT_Support [ 28345 ]
            satyap Satya made changes -
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Report(10109)
            Hide
            satyap Satya added a comment -

            Hi Prasanna,

            Employee "Victoria Merk" i having EE+CH tier enrollment in Dental & Vision however it is shown as 'EE' tier only at Report '2017'. We need to check this on priority.

            They are verifying it for carrier file which is due tomorrow 12/07.

            Regards,
            Satya Prakash

            Cc: Hrishikesh Deshpande Vijay Siddha Samir

            Show
            satyap Satya added a comment - Hi Prasanna, Employee "Victoria Merk" i having EE+CH tier enrollment in Dental & Vision however it is shown as 'EE' tier only at Report '2017'. We need to check this on priority. They are verifying it for carrier file which is due tomorrow 12/07. Regards, Satya Prakash Cc: Hrishikesh Deshpande Vijay Siddha Samir
            satyap Satya made changes -
            Assignee Jennifer Philp [ jphi ] Prasanna Karlekar [ prasanna ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            amruta.lohiya Amruta Lohiya logged work - 07/Dec/16 09:22 AM - edited
            • Time Spent:
              3h
               
              <No comment>
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Prasanna Karlekar [ prasanna ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Attachment WT-6927.png [ 34616 ]
            prasanna Prasanna Karlekar (Inactive) logged work - 07/Dec/16 02:39 PM
            • Time Spent:
              1h
               

              Issue verification and update

            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Satya,

            Record for employee "Victoria Merk" is proper on standard enrollment report.
            We ran Standard Enrollment report with date range of 1/1/2017 - 12/31/2017 for Medical, Dental and Vision benefit types.
            Employee "Victoria Merk" is coming with tier EE+CH.
            Please refer:

            Please let us know, if anything more needs to be checked for.

            cc: Hrishikesh Deshpande, Vijay Siddha, Samir

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Satya , Record for employee "Victoria Merk" is proper on standard enrollment report. We ran Standard Enrollment report with date range of 1/1/2017 - 12/31/2017 for Medical, Dental and Vision benefit types. Employee "Victoria Merk" is coming with tier EE+CH. Please refer: Please let us know, if anything more needs to be checked for. cc: Hrishikesh Deshpande , Vijay Siddha , Samir
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 1h [ 3600 ]
            Worklog Id 12028 [ 12028 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Satya [ ID10004 ]
            satyap Satya made changes -
            Attachment 2017 - Report.png [ 34621 ]
            satyap Satya made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            Hide
            satyap Satya added a comment -

            Hi Prasanna,

            I had discussed this with Jennifer Melgoza and she informed that report named '2017' still shows EE only tier for vision:

            Can we check this?

            Regards,
            Satya Prakash

            Show
            satyap Satya added a comment - Hi Prasanna, I had discussed this with Jennifer Melgoza and she informed that report named '2017' still shows EE only tier for vision: Can we check this? Regards, Satya Prakash
            satyap Satya made changes -
            Assignee Satya [ ID10004 ] Prasanna Karlekar [ prasanna ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Attachment WT-6927_CoverageTierLabel.png [ 34622 ]
            prasanna Prasanna Karlekar (Inactive) logged work - 07/Dec/16 03:49 PM
            • Time Spent:
              0.5h
               

              Root cause analysis and update for Coverage Tier Label issue.

            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Satya,

            Did check for report "2017".
            Yes there is issue with coverage tier labels.

            Following are the 3C's:
            Concern:
            Incorrect coverage tier label is appear on Enrollment report.

            Cause:
            Report is showing Coverage Tier Label as per the HealthTierID in database.
            For this election there is incorrect Health Tier ID in enrollment table.
            Did pull report "2017" by adding field for Coverages and can see discrepancy.
            Please refer below screen shot:

            Correction:
            Data correction will be required where HealthTierIDs are not as per coverage.
            Please assign this ticket accordingly.

            cc: Samir, Hrishikesh Deshpande, Vijay Siddha

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Satya , Did check for report "2017". Yes there is issue with coverage tier labels. Following are the 3C's: Concern: Incorrect coverage tier label is appear on Enrollment report. Cause: Report is showing Coverage Tier Label as per the HealthTierID in database. For this election there is incorrect Health Tier ID in enrollment table. Did pull report "2017" by adding field for Coverages and can see discrepancy. Please refer below screen shot: Correction: Data correction will be required where HealthTierIDs are not as per coverage. Please assign this ticket accordingly. cc: Samir , Hrishikesh Deshpande , Vijay Siddha
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 1h [ 3600 ] 1.5h [ 5400 ]
            Worklog Id 12042 [ 12042 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Satya [ ID10004 ]
            Hide
            jphi Jennifer Melgoza added a comment - - edited

            Prasanna Karlekar is this something that needs to be changed on the back end? This is occurring on reports and on EDI/ carrier files.

            Show
            jphi Jennifer Melgoza added a comment - - edited Prasanna Karlekar is this something that needs to be changed on the back end? This is occurring on reports and on EDI/ carrier files.
            Hide
            satyap Satya added a comment -

            Hi Amruta,

            Can we get HealthtierID corrections done for CAISO. Their payroll file is about to run today.

            Regards,
            Satya Prakash

            Cc: Samir Avnish Yadav

            Show
            satyap Satya added a comment - Hi Amruta, Can we get HealthtierID corrections done for CAISO. Their payroll file is about to run today. Regards, Satya Prakash Cc: Samir Avnish Yadav
            satyap Satya made changes -
            Assignee Satya [ ID10004 ] Amruta Lohiya [ amruta.baheti ]
            Hide
            amruta.lohiya Amruta Lohiya added a comment - - edited

            Jennifer Melgoza
            We have corrected health tier of "Victoria Merk" and "Yanni Chen" employees elections. Please confirm

            CC: Samir,Vijay Siddha

            Show
            amruta.lohiya Amruta Lohiya added a comment - - edited Jennifer Melgoza We have corrected health tier of "Victoria Merk" and "Yanni Chen" employees elections. Please confirm CC: Samir , Vijay Siddha
            amruta.lohiya Amruta Lohiya made changes -
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Resolved [ 5 ]
            amruta.lohiya Amruta Lohiya made changes -
            Assignee Amruta Lohiya [ amruta.baheti ] Jennifer Philp [ jphi ]
            Hide
            jphi Jennifer Melgoza added a comment -

            Hi Amruta Lohiya the client needs a full audit they mention this is not just a vision issue and these are not the only employee

            Show
            jphi Jennifer Melgoza added a comment - Hi Amruta Lohiya the client needs a full audit they mention this is not just a vision issue and these are not the only employee
            jphi Jennifer Melgoza made changes -
            Resolution Fixed [ 1 ]
            Status Resolved [ 5 ] Reopened [ 4 ]
            Show
            jphi Jennifer Melgoza added a comment - Lorena.Nava@ebsbenefits.com Jennifer Leugers
            Hide
            jphi Jennifer Melgoza added a comment -

            Amruta Lohiya Client will need 3 C's please

            Show
            jphi Jennifer Melgoza added a comment - Amruta Lohiya Client will need 3 C's please
            jphi Jennifer Melgoza made changes -
            Assignee Jennifer Philp [ jphi ] Amruta Lohiya [ amruta.baheti ]
            Hide
            amruta.lohiya Amruta Lohiya added a comment -

            Jennifer Melgoza
            Concern: Incorrect coverage tier label is appear on Enrollment report.

            Cause: We are in progress to replicate this issue by trying in different browsers and for different scenarios.

            Correction: We have scan this company and found these two affected employees with coverage and Health tier member count miss match. We have corrected their records.

            Avnish will scan for wrong coverage tier where health tier member count is same but instead spouse, DP or vice versa got inserted and will update you in JIRA WT - 6941.

            CC: Samir, Vijay Siddha

            Show
            amruta.lohiya Amruta Lohiya added a comment - Jennifer Melgoza Concern : Incorrect coverage tier label is appear on Enrollment report. Cause : We are in progress to replicate this issue by trying in different browsers and for different scenarios. Correction : We have scan this company and found these two affected employees with coverage and Health tier member count miss match. We have corrected their records. Avnish will scan for wrong coverage tier where health tier member count is same but instead spouse, DP or vice versa got inserted and will update you in JIRA WT - 6941. CC: Samir , Vijay Siddha
            amruta.lohiya Amruta Lohiya made changes -
            Assignee Amruta Lohiya [ amruta.baheti ] Neelam Yangal [ neelam.yangal ]
            Hide
            jphi Jennifer Melgoza added a comment -

            Amruta Lohiya Neelam Yangal there were three – so we need to scan this carrier and further carriers that have tiers thoroughly Please provide an ETA - client is waiting for an ETA.

            Show
            jphi Jennifer Melgoza added a comment - Amruta Lohiya Neelam Yangal there were three – so we need to scan this carrier and further carriers that have tiers thoroughly Please provide an ETA - client is waiting for an ETA.
            Hide
            amruta.lohiya Amruta Lohiya added a comment -

            Jennifer Melgoza
            3rd employee will cover in WT - 6941 scan.

            Neelam Yangal
            Please look into root cause of this issue.

            Show
            amruta.lohiya Amruta Lohiya added a comment - Jennifer Melgoza 3rd employee will cover in WT - 6941 scan. Neelam Yangal Please look into root cause of this issue.
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Status Reopened [ 4 ] In Progress [ 3 ]
            Hide
            neelam.yangal Neelam Yangal (Inactive) added a comment -

            Hi Amruta Lohiya,

            CC: Samir

            I tried to reproduce this issue on hspl copy on production for the same affected employee.
            But I am not able to reproduce this issue from OE tunnel, Employee Login, Admin Login.

            As below are some observation while analyzing this issue.
            1) Recently health tier id went wrong from enrollment mode ID = 13 (Import enrollment) you can refer Blue Diamond company(BDG) on production. (We can take import team help on this)
            2)Some are the old enrollments are carry forward, which already had health tier id wrong.
            but this issue is not reproducing now.
            3) We need to correct the existing corrupted data from all company. so that if again issue comes we can focus our analysis further to particular scenario.

            Please let me know more inputs on this.

            Thanks,
            Neelam

            Show
            neelam.yangal Neelam Yangal (Inactive) added a comment - Hi Amruta Lohiya , CC: Samir I tried to reproduce this issue on hspl copy on production for the same affected employee. But I am not able to reproduce this issue from OE tunnel, Employee Login, Admin Login. As below are some observation while analyzing this issue. 1) Recently health tier id went wrong from enrollment mode ID = 13 (Import enrollment) you can refer Blue Diamond company(BDG) on production. (We can take import team help on this) 2)Some are the old enrollments are carry forward, which already had health tier id wrong. but this issue is not reproducing now. 3) We need to correct the existing corrupted data from all company. so that if again issue comes we can focus our analysis further to particular scenario. Please let me know more inputs on this. Thanks, Neelam
            neelam.yangal Neelam Yangal (Inactive) logged work - 08/Dec/16 02:53 PM
            • Time Spent:
              6h
               
              <No comment>
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Original Estimate 6h [ 21600 ]
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Time Spent 1.5h [ 5400 ] 7.5h [ 27000 ]
            Worklog Id 12188 [ 12188 ]
            neelam.yangal Neelam Yangal (Inactive) logged work - 09/Dec/16 03:14 PM
            • Time Spent:
              8h
               
              <No comment>
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Original Estimate 6h [ 21600 ] 14h [ 50400 ]
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Time Spent 7.5h [ 27000 ] 15.5h [ 55800 ]
            Worklog Id 12388 [ 12388 ]
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Hide
            neelam.yangal Neelam Yangal (Inactive) added a comment -

            Hi Amruta Lohiya,

            Please find attached sheet for today's data correction status.
            WrongHealthTierIDCorrectionCompanyList.xls

            Thanks,
            Neelam

            Show
            neelam.yangal Neelam Yangal (Inactive) added a comment - Hi Amruta Lohiya , Please find attached sheet for today's data correction status. WrongHealthTierIDCorrectionCompanyList.xls Thanks, Neelam
            neelam.yangal Neelam Yangal (Inactive) logged work - 13/Dec/16 02:50 PM
            • Time Spent:
              4.5h
               
              <No comment>
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Original Estimate 14h [ 50400 ] 18.5h [ 66600 ]
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Time Spent 15.5h [ 55800 ] 20h [ 72000 ]
            Worklog Id 12814 [ 12814 ]
            amruta.lohiya Amruta Lohiya made changes -
            Time Spent 20h [ 72000 ] 23h [ 82800 ]
            Worklog Id 13902 [ 13902 ]
            amruta.lohiya Amruta Lohiya made changes -
            Worklog Id 13902 [ 13902 ]
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -
            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Neelam Yangal Is this open? Jyoti Mayne Satya
            Hide
            neelam.yangal Neelam Yangal (Inactive) added a comment -

            CC: Satya, Jyoti Mayne

            Rakesh Roy: Yes this is open, This is very long data correction and did not got time to do further data correction.

            Show
            neelam.yangal Neelam Yangal (Inactive) added a comment - CC: Satya , Jyoti Mayne Rakesh Roy : Yes this is open, This is very long data correction and did not got time to do further data correction.
            Hide
            neelam.yangal Neelam Yangal (Inactive) added a comment -

            CC: Satya

            Show
            neelam.yangal Neelam Yangal (Inactive) added a comment - CC: Satya
            neelam.yangal Neelam Yangal (Inactive) made changes -
            Assignee Neelam Yangal [ neelam.yangal ] Jyoti Mayne [ jyoti.mayne ]
            jyoti.mayne Jyoti Mayne made changes -
            Summary CAISO Issues with Reports RCF - CAISO Issues with Reports
            jyoti.mayne Jyoti Mayne made changes -
            Module Parent values: BenAdmin(10100)Level 1 values: Report(10109) Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107)
            jyoti.mayne Jyoti Mayne made changes -
            Issue Type Support Activity [ 10301 ] Bug [ 1 ]
            Status In Progress [ 3 ] Open [ 1 ]
            Support Task Type Query Resolution [ 11205 ]
            Workflow WT_Support [ 28345 ] WT_Defects [ 31820 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Severity Complex [ 13103 ]
            jyoti.mayne Jyoti Mayne made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            Hide
            jyoti.mayne Jyoti Mayne added a comment -

            duplicate of WT-2288

            Show
            jyoti.mayne Jyoti Mayne added a comment - duplicate of WT-2288
            jyoti.mayne Jyoti Mayne made changes -
            Resolution Duplicate [ 3 ]
            Status In Development [ 10007 ] Rejected [ 10004 ]
            jyoti.mayne Jyoti Mayne made changes -
            Link This issue relates to WT-2288 [ WT-2288 ]
            admin01 admin made changes -
            Status Rejected [ 10004 ] Closed [ 6 ]
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            Transition Time In Source Status Execution Times
            Janine Calendo (Inactive) made transition -
            To Do Done
            3h 23m 1
            Jennifer Melgoza made transition -
            Done To Do
            1h 6m 1
            Satya made transition -
            To Do Open
            2m 27s 1
            Satya made transition -
            Open In Progress
            16h 2m 1
            Amruta Lohiya made transition -
            In Progress Resolved
            3h 59m 1
            Jennifer Melgoza made transition -
            Resolved Reopen
            9m 10s 1
            Neelam Yangal (Inactive) made transition -
            Reopen In Progress
            18h 58m 1
            Jyoti Mayne made transition -
            In Progress Open
            55d 18h 23m 1
            Jyoti Mayne made transition -
            Open In Development
            62d 22h 45m 1
            Jyoti Mayne made transition -
            In Development Rejected
            17s 1
            admin made transition -
            Rejected Closed
            91d 2h 56m 1

              People

              Assignee:
              jyoti.mayne Jyoti Mayne
              Reporter:
              jphi Jennifer Melgoza
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 18.5h Original Estimate - 18.5h
                  18.5h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 23h
                  23h