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

County of Del Norte 1095c Corrections

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Support Task Type:
      ACA Historical Data Load
    • Reported by:
      Support
    • Company:
      County of Del Norte
    • Module:
      BenAdmin

      Description

      Please see the list of final corrections for County of Del Norte. Password to be sent in separate email.

        Attachments

        1. ACA Dev fix spreadsheet v2 A - 6.23 Final.xlsx
          35 kB
        2. ACA Dev fix spreadsheet v2 C (1).xlsx
          70 kB
        3. ACA Dev fix spreadsheet v2 J.xlsx
          117 kB
        4. ACA Dev fix spreadsheet v2 Z.xlsx
          23 kB
        5. Copy of Missing 1095 Retiree Demographics.xls
          31 kB
        6. Del Norte 1095c ACA Dev fix spreadsheet v1.xlsx
          25 kB
        7. DelNorte-VerifiedEmployees.txt
          1 kB
        8. image001.jpg
          image001.jpg
          1.0 kB
        9. image001.jpg
          image001.jpg
          1.0 kB
        10. image002.jpg
          image002.jpg
          1 kB
        11. image002.jpg
          image002.jpg
          1 kB
        12. image003.png
          image003.png
          1 kB
        13. image004.png
          image004.png
          5 kB
        14. image005.jpg
          image005.jpg
          64 kB
        15. image006.jpg
          image006.jpg
          2 kB
        16. image007.jpg
          image007.jpg
          2 kB
        17. image007.png
          image007.png
          5 kB
        18. image008.jpg
          image008.jpg
          64 kB
        19. image009.png
          image009.png
          0.6 kB
        20. image014.gif
          image014.gif
          0.2 kB
        21. image017.png
          image017.png
          1 kB
        22. image018.jpg
          image018.jpg
          1 kB
        23. image019.jpg
          image019.jpg
          2 kB
        24. image020.jpg
          image020.jpg
          2 kB
        25. image021.png
          image021.png
          0.6 kB

          Activity

          cfinocchio Chris Finocchio (Inactive) created issue -
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Nandkumar Prabhakar Karlekar
          Jennifer Melgoza

          Please see attached spreadsheet for final Del Norte 1095c corrections. Please let me know if you have any questions.

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Nandkumar Prabhakar Karlekar Jennifer Melgoza Please see attached spreadsheet for final Del Norte 1095c corrections. Please let me know if you have any questions.
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Field Original Value New Value
          Assignee Nandkumar [ satyap ] Ramya Tantry [ ramya.tantry ]
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Chris Finocchio
          Nandkumar Prabhakar Karlekar
          Jennifer Melgoza

          Due to other tasks could not look into this.We will analyze this tomorrow and update you soon

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Chris Finocchio Nandkumar Prabhakar Karlekar Jennifer Melgoza Due to other tasks could not look into this.We will analyze this tomorrow and update you soon
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Nandkumar Prabhakar Karlekar
          Jennifer Melgoza

          Nandu,

          Thanks for the update.

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Nandkumar Prabhakar Karlekar Jennifer Melgoza Nandu, Thanks for the update.
          Hide
          jphi Jennifer Melgoza added a comment -

          Nandkumar Prabhakar Karlekar hi all, Chris Finocchio do we have an update on this case? Ramya Tantry deadline is quickly approaching.

          Show
          jphi Jennifer Melgoza added a comment - Nandkumar Prabhakar Karlekar hi all, Chris Finocchio do we have an update on this case? Ramya Tantry deadline is quickly approaching.
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment - - edited

          Jennifer Melgoza
          Chris Finocchio

          FYI Nandkumar Prabhakar Karlekar,Sachin Hingole

          The requested corrections have been done.
          Please refer latest run dated "6/8/2016 1:59:12 AM".

          Note : The requested corrections of Part 3 for EE Sullenger, Gary L mentions that EE is covered for Nov only and spouse is covered for Dec only. However,if EE is not covered for that month,his dependent will not be marked for that month.
          Please review this EE's part 3 and let us know if any correction is need.Currently for this EE,only EE is shown as covered for Nov month.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - - edited Jennifer Melgoza Chris Finocchio FYI Nandkumar Prabhakar Karlekar , Sachin Hingole The requested corrections have been done. Please refer latest run dated "6/8/2016 1:59:12 AM". Note : The requested corrections of Part 3 for EE Sullenger, Gary L mentions that EE is covered for Nov only and spouse is covered for Dec only. However,if EE is not covered for that month,his dependent will not be marked for that month. Please review this EE's part 3 and let us know if any correction is need.Currently for this EE,only EE is shown as covered for Nov month.
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Chris Finocchio [ cfinocchio ]
          Resolution Done [ 10000 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Nandkumar Prabhakar Karlekar
          Jennifer Melgoza

          Please see attached client corrections for the County of Del Norte.

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Nandkumar Prabhakar Karlekar Jennifer Melgoza Please see attached client corrections for the County of Del Norte.
          cfinocchio Chris Finocchio (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Corrections for Del Norte are spread over 3 attached spreadsheets.

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Corrections for Del Norte are spread over 3 attached spreadsheets.
          cfinocchio Chris Finocchio (Inactive) made changes -
          Assignee Chris Finocchio [ cfinocchio ] Nandkumar [ satyap ]
          cfinocchio Chris Finocchio (Inactive) made changes -
          cfinocchio Chris Finocchio (Inactive) made changes -
          Attachment ACA Dev fix spreadsheet v2 J.xlsx [ 20115 ]
          cfinocchio Chris Finocchio (Inactive) made changes -
          Attachment ACA Dev fix spreadsheet v2 Z.xlsx [ 20116 ]
          cfinocchio Chris Finocchio (Inactive) made changes -
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Password remains the same. 4th spreadsheet - is a retiree who needs to be added into WT.

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Password remains the same. 4th spreadsheet - is a retiree who needs to be added into WT.
          Hide
          jphi Jennifer Melgoza added a comment -

          Nandkumar Prabhakar Karlekar Chris Finocchio Following up on the 3 spreadsheets .

          2 for aca corrects which need to be loaded 1 for the employee which will need to be loaded.

          Please let me know if you need to ask questions as you know the client has had many issues - so they are hoping ALL corrections will be loaded this time please help check to ensure the corrects are all loaded along with the new retiree on the 3rd spreadsheet.

          Show
          jphi Jennifer Melgoza added a comment - Nandkumar Prabhakar Karlekar Chris Finocchio Following up on the 3 spreadsheets . 2 for aca corrects which need to be loaded 1 for the employee which will need to be loaded. Please let me know if you need to ask questions as you know the client has had many issues - so they are hoping ALL corrections will be loaded this time please help check to ensure the corrects are all loaded along with the new retiree on the 3rd spreadsheet.
          jphi Jennifer Melgoza made changes -
          Priority Medium [ 3 ] Highest [ 1 ]
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Sachin Hingole

          Please verify the corrections with latest run.

          The excel named "Copy of Missing 1095C Retiree Dempgraphics" gives an error while opening.

          I haven't fount these employees in company db.
          Katherine Hernandez
          JANET TURNER
          NATHAN PERRANDO

          Please query them to provide these EE's data and Excel sheet.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Sachin Hingole Please verify the corrections with latest run. The excel named "Copy of Missing 1095C Retiree Dempgraphics" gives an error while opening. I haven't fount these employees in company db. Katherine Hernandez JANET TURNER NATHAN PERRANDO Please query them to provide these EE's data and Excel sheet.
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Nandkumar [ satyap ] Sachin Hingole [ sachin.hingole ]
          Hide
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          Chris Finocchio Jennifer Leugers Shubhankar Joshi

          Can you please provide password for Copy of Missing 1095 Retiree Demographics.xls excel, as provided password (ACA****) is not working.

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - Chris Finocchio Jennifer Leugers Shubhankar Joshi Can you please provide password for Copy of Missing 1095 Retiree Demographics.xls excel, as provided password (ACA****) is not working.
          Hide
          jphi Jennifer Melgoza added a comment -

          Sachin Hingole Please note for Copy of Missing 1095 Retiree Demographics.xls you are using incorrect password. Please look for email with password provided originally to Nandu.

          Thanks,

          Show
          jphi Jennifer Melgoza added a comment - Sachin Hingole Please note for Copy of Missing 1095 Retiree Demographics.xls you are using incorrect password. Please look for email with password provided originally to Nandu. Thanks,
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Attachment DelNorte-VerifiedEmployees.txt [ 20403 ]
          Hide
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          Jennifer Melgoza Jennifer Leugers Nandkumar Prabhakar Karlekar shyam sharma Ramya Tantry

          Hi Chris Finocchio,

          We have verified employees from attached DelNorte-VerifiedEmployees.txt file.
          1095C PDF of employee has data as shown on excel. please refer latest run for these changes (Run Date - 6/22/2016 2:19:41 AM)

          NOTE - Marjorie Miller employee from "Copy of Missing 1095 Retiree Demographics.xls" excel already added in workterra. Also this employee PDF is available in latest run (Run Date - 6/22/2016 2:19:41 AM)

          Thanks,
          Sachin Hingole

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - Jennifer Melgoza Jennifer Leugers Nandkumar Prabhakar Karlekar shyam sharma Ramya Tantry Hi Chris Finocchio , We have verified employees from attached DelNorte-VerifiedEmployees.txt file. 1095C PDF of employee has data as shown on excel. please refer latest run for these changes (Run Date - 6/22/2016 2:19:41 AM) NOTE - Marjorie Miller employee from "Copy of Missing 1095 Retiree Demographics.xls" excel already added in workterra. Also this employee PDF is available in latest run (Run Date - 6/22/2016 2:19:41 AM) Thanks, Sachin Hingole
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee Sachin Hingole [ sachin.hingole ] Chris Finocchio [ cfinocchio ]
          Resolution Done [ 10000 ]
          Status Reopened [ 4 ] Resolved [ 5 ]
          Hide
          jphi Jennifer Melgoza added a comment -

          Hi Chris - when will you be able to be complete with QC the forms?

          Show
          jphi Jennifer Melgoza added a comment - Hi Chris - when will you be able to be complete with QC the forms?
          jphi Jennifer Melgoza made changes -
          Resolution Done [ 10000 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          I completed the review. I found 1 issue – Nathan Perrando is showing coverage for all 12 months in part III – should be April-Dec

          Chris Finocchio | Senior Analyst, WORKTERRA
          Employee Benefit Specialists, Inc.
          PO Box 11657, Pleasanton, CA 94588
          PH: 925-621-5258| FAX: 925-460-3920 | chris.finocchio@ebsbenefits.com<chris.finocchio@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
          cfinocchio Chris Finocchio (Inactive) added a comment - I completed the review. I found 1 issue – Nathan Perrando is showing coverage for all 12 months in part III – should be April-Dec Chris Finocchio | Senior Analyst, WORKTERRA Employee Benefit Specialists, Inc. PO Box 11657, Pleasanton, CA 94588 PH: 925-621-5258| FAX: 925-460-3920 | chris.finocchio@ebsbenefits.com< chris.finocchio@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 >
          cfinocchio Chris Finocchio (Inactive) made changes -
          Attachment image001.jpg [ 20418 ]
          Attachment image002.jpg [ 20419 ]
          Attachment image003.png [ 20420 ]
          Attachment image004.png [ 20421 ]
          Attachment image005.jpg [ 20422 ]
          Attachment image006.jpg [ 20423 ]
          Attachment image007.jpg [ 20424 ]
          Attachment image009.png [ 20425 ]
          Hide
          jphi Jennifer Melgoza added a comment -

          Hi Chris,

          Can you fix this form? Then Jen said we can send it.

          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@01D1CC91.DEE79C20]<http://twitter.com/#!/workterra> [cid:image002.jpg@01D1CC91.DEE79C20] <http://www.linkedin.com/company/workterra> [cid:image017.png@01D1CC91.DF17FAF0] <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 - Hi Chris, Can you fix this form? Then Jen said we can send it. 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@01D1CC91.DEE79C20] < http://twitter.com/#!/workterra > [cid:image002.jpg@01D1CC91.DEE79C20] < http://www.linkedin.com/company/workterra > [cid:image017.png@01D1CC91.DF17FAF0] < 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 [ 20427 ]
          Attachment image002.jpg [ 20428 ]
          Attachment image007.png [ 20429 ]
          Attachment image008.jpg [ 20430 ]
          Attachment image014.gif [ 20431 ]
          Attachment image017.png [ 20432 ]
          Attachment image018.jpg [ 20433 ]
          Attachment image019.jpg [ 20434 ]
          Attachment image020.jpg [ 20435 ]
          Attachment image021.png [ 20436 ]
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Chris Finocchio,Jennifer Melgoza

          The codes were wrong of EE Nathan Perrando because the SSN given in the sheet was different then the one present in the system.
          We have corrected the codes of this EE. Please verify with latest run.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Chris Finocchio , Jennifer Melgoza The codes were wrong of EE Nathan Perrando because the SSN given in the sheet was different then the one present in the system. We have corrected the codes of this EE. Please verify with latest run.
          jphi Jennifer Melgoza made changes -
          Hide
          jphi Jennifer Melgoza added a comment - - edited

          Sachin Hingole Nandkumar Prabhakar Karlekar

          Hello All,
          We have just loaded the final corrections. Chris can provide further information if needed, but these will need to be corrected per the sheet - some of which were not originally corrected per the sheet the client provided on 6/17 - please ensure to look at the sheet and correct if there are questions let us know. Please quality check the sheet once completed and we will do the same.
          we will send the password next in email to sachin and nadu.
          FILE - ACA Dev fix spreadsheet v2 A - 6.23 Final

          Show
          jphi Jennifer Melgoza added a comment - - edited Sachin Hingole Nandkumar Prabhakar Karlekar Hello All, We have just loaded the final corrections. Chris can provide further information if needed, but these will need to be corrected per the sheet - some of which were not originally corrected per the sheet the client provided on 6/17 - please ensure to look at the sheet and correct if there are questions let us know. Please quality check the sheet once completed and we will do the same. we will send the password next in email to sachin and nadu. FILE - ACA Dev fix spreadsheet v2 A - 6.23 Final
          jphi Jennifer Melgoza made changes -
          Assignee Chris Finocchio [ cfinocchio ] Nandkumar [ satyap ]
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Sachin Hingole

          FYI Nandkumar Prabhakar Karlekar

          The requested corrections are done.
          Please download latest run and verify.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Sachin Hingole FYI Nandkumar Prabhakar Karlekar The requested corrections are done. Please download latest run and verify.
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Nandkumar [ satyap ] Sachin Hingole [ sachin.hingole ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Reopened [ 4 ] In Progress [ 3 ]
          Hide
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          Jennifer Leugers Nandkumar Prabhakar Karlekar Rakesh Roy Ramya Tantry shyam sharma

          Hi Jennifer Melgoza,

          We have done the 1095C corrections on Del Norte.
          Please refer the latest run (run date -6/24/2016 3:42:03 AM) for 1095C corrections.

          We have verified below employee and their details on PDF are as per excel.
          Kevin Baxter
          Jennifer Williamson
          JANET TURNER
          Gary Sullenger
          Lisa Specchio-Wolfe
          Nathan Perrando
          JoAnn Davis
          Joel Campbell-Blair

          Thanks,
          Sachin Hingole

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - Jennifer Leugers Nandkumar Prabhakar Karlekar Rakesh Roy Ramya Tantry shyam sharma Hi Jennifer Melgoza , We have done the 1095C corrections on Del Norte. Please refer the latest run (run date -6/24/2016 3:42:03 AM) for 1095C corrections. We have verified below employee and their details on PDF are as per excel. Kevin Baxter Jennifer Williamson JANET TURNER Gary Sullenger Lisa Specchio-Wolfe Nathan Perrando JoAnn Davis Joel Campbell-Blair Thanks, Sachin Hingole
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee Sachin Hingole [ sachin.hingole ] Jennifer Philp [ jphi ]
          Resolution Done [ 10000 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          jphi Jennifer Melgoza made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times
          Ramya Tantry (Inactive) made transition -
          Open In Progress
          4d 6h 34m 1
          Sachin Hingole (Inactive) made transition -
          Reopen Resolved
          4d 12h 17m 1
          Jennifer Melgoza made transition -
          Resolved Reopen
          9d 20h 39m 2
          Sachin Hingole (Inactive) made transition -
          Reopen In Progress
          1d 15h 37m 1
          Sachin Hingole (Inactive) made transition -
          In Progress Resolved
          4h 23m 2
          Jennifer Melgoza made transition -
          Resolved Closed
          38d 4h 33m 1

            People

            Assignee:
            jphi Jennifer Melgoza
            Reporter:
            cfinocchio Chris Finocchio (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: