Employee Information: In this tab, Not present class1 as 'Retiree' for the Employee Class1. If you can’t use RETIREES than use GENERAL EMPLOYEES
Benefit Plan: In this tab, This "Plan Design Dependent coverage" field is mandatory which is null currently. Use EDS for both
Offered Benefit: In this tab, Offers are ending on the same day when they are started means Employee Eligibility Offer Start Date =Employee Eligibility Offer end date. This field is allowed to be BLANK on the template, so I removed the values
There is not provided a data for the mandatory column-"Enrollment Member Type ID". So we are assuming value as Employee for the blanks. We need your confirmation for this. Yes, this is true, the blank relationships are EMPLOYEE’s. I have updated that in the attached workbook.
Mentioned employees accepted plans are not sync with dependent. Please let us know the correct plan. I have updated the spouse coverages to match the employee.

File with updates is attached.

Hi Jennifer Leugers,

This is historical load which is not possible in couple of hours.
It would require minimum of 3 days to complete this. The responses provided need to be analyzed and verified on HSPL copy of this company.After all verification,load is done on Main company.

CC:Nandkumar Prabhakar Karlekar,Revansiddha Gaur,Smita Pawar,Samir,Satya

All this is crazy - I don't have three days. The client needs to get these out the door by the IRS deadlines which is fast approaching. All we did was clean up the data per your questions. This shouldn't take an additional three days to analyze.

Hi Jennifer Leugers,

We are done with ACA historical data load.
As communicated earlier,11 employees were already present in the system.So we have not imported those employees.We have import rest 30 employees and all provided data.
We have re-run the report. Please refer latest run for verification.
All 41 employees are present in the latest run. As most of the employees are retired employees with benefits in 2017,1G code is populated.

Please find this excel sheet for codes of all 41 employees. EmployeeLoad_Codes.xls
In-case you want to correct any codes, it can be done through import or manual correction as DEV cannot do any further changes to employee data.Please re-run the report after correction,if applicable.

Please find attached comparison report.Run 1 is the previous run and Run 2 is the latest.
CityOfSanMarcos_CodeComparison.xls

Password to both the files is as per the conventions set.

CC:Nandkumar Prabhakar Karlekar,Smita Pawar,Venkatesh Pujari,Satya,Samir,Rakesh Roy,Revansiddha Gaur