-
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
Please see the list of final corrections for County of Del Norte. Password to be sent in separate email.
- ACA Dev fix spreadsheet v2 A - 6.23 Final.xlsx
- 35 kB
- Jennifer Melgoza
- ACA Dev fix spreadsheet v2 C (1).xlsx
- 70 kB
- Chris Finocchio
- ACA Dev fix spreadsheet v2 J.xlsx
- 117 kB
- Chris Finocchio
- ACA Dev fix spreadsheet v2 Z.xlsx
- 23 kB
- Chris Finocchio
- Copy of Missing 1095 Retiree Demographics.xls
- 31 kB
- Chris Finocchio
- Del Norte 1095c ACA Dev fix spreadsheet v1.xlsx
- 25 kB
- Chris Finocchio
- DelNorte-VerifiedEmployees.txt
- 1 kB
- Sachin Hingole
- image001.jpg
- 1.0 kB
- Jennifer Melgoza
- image001.jpg
- 1.0 kB
- Chris Finocchio
- image002.jpg
- 1 kB
- Jennifer Melgoza
- image002.jpg
- 1 kB
- Chris Finocchio
- image003.png
- 1 kB
- Chris Finocchio
- image004.png
- 5 kB
- Chris Finocchio
- image005.jpg
- 64 kB
- Chris Finocchio
- image006.jpg
- 2 kB
- Chris Finocchio
- image007.jpg
- 2 kB
- Chris Finocchio
- image007.png
- 5 kB
- Jennifer Melgoza
- image008.jpg
- 64 kB
- Jennifer Melgoza
- image009.png
- 0.6 kB
- Chris Finocchio
- image014.gif
- 0.2 kB
- Jennifer Melgoza
- image017.png
- 1 kB
- Jennifer Melgoza
- image018.jpg
- 1 kB
- Jennifer Melgoza
- image019.jpg
- 2 kB
- Jennifer Melgoza
- image020.jpg
- 2 kB
- Jennifer Melgoza
- image021.png
- 0.6 kB
- Jennifer Melgoza
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
Nandkumar Prabhakar Karlekar hi all, Chris Finocchio do we have an update on this case? Ramya Tantry deadline is quickly approaching.
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.
Nandkumar Prabhakar Karlekar
Jennifer Melgoza
Please see attached client corrections for the County of Del Norte.
Corrections for Del Norte are spread over 3 attached spreadsheets.
Password remains the same. 4th spreadsheet - is a retiree who needs to be added into WT.
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.
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.
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.
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,
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
Hi Chris - when will you be able to be complete with QC the forms?
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>
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>
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.
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
FYI Nandkumar Prabhakar Karlekar
The requested corrections are done.
Please download latest run and verify.
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
Nandkumar Prabhakar Karlekar
Jennifer Melgoza
Please see attached spreadsheet for final Del Norte 1095c corrections. Please let me know if you have any questions.