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

          Activity

          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.
          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.
          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.
          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.
          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.
          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.
          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.
          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,
          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
          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?
          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 >
          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 >
          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.
          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
          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.
          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

            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: