2017 ACA 1095 C is ready to run. Thanks!

We have run "2017 ACA 1095 C" 1095C report, find attached check list IRS 1095-C_CityOfSanMarcos_Checklist.xls for more details.
Please refer latest run of "2017 ACA 1095 C" report for verification.

note : Measurement and stability set but does not cover entier year

Hi all - client has approved their forms; please re-run their final. Thanks!

Hi Jennifer Leugers,

This group has been run. Please download latest run for the below report(s) for verification.

Thanks,
Revan
----------------------------------------------------------------------------------------
CC-Ramya Tantry, Kumar Chhajed, Smita Pawar, Sachin Hingole, Nandkumar Prabhakar Karlekar, Gaurav Sodani

HI all - I'm attaching a file that needs to be loaded for the COBRA / Retirees and then their forms re-run. Password is the standard convention. Please let me know if you have any questions. Thanks!

Hi Jennifer Leugers,

We are totally confused what type of file you are going to provide, correction or employee load?

If you would like to load the employees into the system, then the concern dept i.e. EDI team will look into this
else we will work on correction.

Please send the attachment. We don't find attachment either in the JIRA or email.

Thanks,
Revan

CC- Ramya Tantry, Nandkumar Prabhakar Karlekar,Amit Thorve

Hi Jennifer Leugers,

Further to the analysis of scenario that we asked you in LHP-Bay County Jira(WT-12503) about 1K, we scanned all production companies which have condition of cost less than FPL cost,line 14 code is 1A and minimum cost plan is conditional offer.
This is one of the affected companies and we have re-run the report.
Please refer to the latest run for verification.
We have compared the run with previous run and only change in the report is the change from 1A to 1K.

CC: Nandkumar Prabhakar Karlekar,Revansiddha Gaur,Smita Pawar

Hi all - we need to get the attached file loaded; I cannot have our EDI team do it as I believe it is loaded to a back end table since the COBRA plans are not built out (nor tracked in the system). This is a load just for ACA purposes. Please assist.

Hi Amit Thorve,

We have received the historical data load for ACA. So can we have a discussion on this?

Thanks,
Revan
CC- Nandkumar Prabhakar Karlekar, Smita Pawar, Sachin Hingole, Ramya Tantry

Hi Jennifer Leugers,

We have analyzed the employee file given and found out that out of total 41 employees, 11 are already present in the system.
Out of those 11,1095C's for 9 employees have been generated in latest run.For 2 employees,PDF's were not generated as they are retired employees with no active elections for year 2017.
Please find the employee list in the attached excel sheet. EmployeeList_CityofSanMarcos.xls. Password is the standard convention.
For these 11 employees it would be referable if their correction codes are provided ,instead of making changes to existing employee data through ACA data load.
Please provide correction codes for these 11 employees.

We are in process of loading the remaining 30 employees data into HSPL copy of this company.After all verification,we will load the data into main company.
We will provide you the reports by Friday(02/09/2018).

CC:Nandkumar Prabhakar Karlekar,Smita Pawar,Revansiddha Gaur

Hi Jennifer Leugers,

We have found some incomplete data in excel sheet to load historical data. Please provide the details for below..

• Employee Information: In this tab,Not present class1 as 'Retiree' for the Employee Class1.
• Benefit Plan: In this tab,This "Plan Design Dependent coverage" field is mandatory which is null currently.
• 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.

Thanks,
Revan
CC: Amit Thorve,Nandkumar Prabhakar Karlekar, Ramya Tantry, Smita Pawar, Sachin Hingole

Hi Jennifer Leugers,

We needed inputs on below as well to accomplish the historical data load.

Reference to: Excel sheet tab-Benefit Election

• 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.
• Mentioned employees accepted plans are not sync with dependent.Please let us know the correct plan.

Thanks,
Revan

CC-Amit Thorve, Nandkumar Prabhakar Karlekar, Ramya Tantry, Smita Pawar, Sachin Hingole, Satya

Hi Jennifer Leugers,

Gentle Reminder

We are waiting for your reply concerning to the above comments.

Thanks,
Revan

CC-Amit Thorve, Nandkumar Prabhakar Karlekar, Satya

Hi all - I have the responses and am compiling right now. Please wait and perform these changes today before you leave so I can send to the client when I get into the office in a couple of hours. Thanks!

Samir FYI

Ramya Tantry Smita Pawar Nandkumar Prabhakar Karlekar - FYI.

Regards,
Satya Prakash

Cc: Prashant Samal

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