Hi Jennifer Leugers

Please verify ACA Customization(ACA plan, Is Plan Minimum Value, MEC ) on this company and please make changes on this screen if necessary,so that the report can be re-run with latest customization.

CC: Nandkumar Prabhakar Karlekar,Sachin Hingole

Customization confirmed; please run 2016 1095C for El Camino

Hi Jennifer Leugers

We have run " 2016 1095C for El Camino" report. Please refer latest run for verification.

Note: Plans that are not marked as Minimum value will reflect the 1F code on 1095C report.

CC: Nandkumar Prabhakar Karlekar,Sachin Hingole

Hi all - I can't get the Excel file to download. Each time, the attached is what I receive.

Hi Jennifer Leugers

This excel file cannot be downloaded because of following issue:
Number of rows exceeds the maximum possible rows per sheet in this format; Rows Requested: 70535, Max Rows: 65536

As the rows are exceeding excel sheets's limit,it gives page not found error.
I have extracted the data from backend and mailing you the excel sheet.

CC:Nandkumar Prabhakar Karlekar,Sachin Hingole

Customization updated to not select a value for the conditional offer; please re-run all reports. Please also send Excel file via email as you did prior. Please CC Cathleen Harrington on that file and the password as I will be out of the office Monday and Tuesday. Thanks!
Cathleen Harrington

Hi Jennifer Leugers

We have re-run the report " 2016 1095C for El Camino". Please refer latest run for verification.

I am sending you the analysis report excel sheet via email.

CC: Cathleen Harrington

Hello,

Due to the zip file size we are unable to load to the FTP site. Can you separate the file into three 1k records per file?

thanks

Hi lisa davison,

Can you please try the same at your end.
If not possible,can you please take Dave's approval for such type of task so that we can create bandwidth for such support task..

CC Nandkumar Prabhakar Karlekar,Sachin Hingole

All - not sure why we need Dave's approval on this; the file is simply getting corrupted when we try to open it. We need the forms broken down in smaller batches or need the forms individually loaded somewhere so that we can zip them into smaller files for the client.

Hi Jennifer Leugers,

We did not get any corrupt file message when we downloaded zip file from site and tried to open it.
Corrupt file message may occur if there is any issue with network bandwidth.

The reason we asked for Dave's approval is because for most of the companies, we furnish around 3000 pdf's in single report.So if such type is issues occur, we need to create bandwidth on our end to handle such support task and in earlier comment exact nature of issue was not mentioned.

We have uploaded El Camino PDF's on EBS FTP.
Below are the details:

URL - https://ftpsecure.ebsbenefits.com/thinclient/Transfer.aspx
Folder Path - /users/workterraaca/Windstream/12012016
ACA files - El_Camino_1.zip,El_Camino_2.zip,El_Camino_3.zip.

Hi all - why are we using 1G on clients who are not self-insured? Per the IRS instructions - "and who enrolled in self-insured coverage for one or more months of the calendar year".

Hi Jennifer Leugers,

1G is displayed because those employees are enrolled in self insured plan called "Medimpact".
Medimpact plan under Medimpact benefit type is marked as ACA plan and is self insured plan. This plan is also selected on 1095C report customization.
Refer screenshot:

CC: Nandkumar Prabhakar Karlekar,Sachin Hingole,Smita Pawar

Hello Ramya,

Can you look into the system configuration for El Camino Hospital due to the following issues.

I ran out an enrollment report and compared it to the ACA analytic spreadsheet and found for the 1E_2B folks we have an active enrollments in WT for 2016. Perry Aganad and Robert Almeida being examples. For Perry Aganad- His status went from PT to FT effective 1/27/2016. The 1095 for the month of Jan/ Feb shows 2B. I would think the code for Feb should be 2D the 1095 is showing 2B for Feb and EE became eligible for benefits 03/2016.

Also, the client reported the below issues as well:

We also noticed that some employees coded 1E have a line 16 code of 2B and that should not be the case because if they are 1E that means coverage was offered therefore we need to specify if they elected coverage or waived. Please advise what code you would like 2B changed to? the system is reading them as a part-time so pulling the 2B. It should either be 2C (enrolled) or 2G (waived). If there is no election for them in the system it should be 2G.

Also some with 1E have a blank on line 16 and we need to have some type of code for line 16. An example of that is Ronan Acot.

Again – we just need to know what codes you would like for us to use on line 16? They are showing a blank as they do not satisfy the safe harbor (FPL) and since they are not enrolled, the safe harbor code of 2G would normally go there. If they are not enrolled it should be a 2G and not left blank.

Anyone with code 1H should have line 16 code 2A, 2D or 2B. Can you confirm to see if that can be pulled from the system or do we need to tell EBS what the code is for the blanks?

Hi Smita Pawar,

Please look into this and advise.

CC: Nandkumar Prabhakar Karlekar,Sachin Hingole

Hi lisa davison,

We are working on this. We will update you on this till Feb 13 2017.

Thanks,
Smita

FYI Nandkumar Prabhakar Karlekar,Sachin Hingole,Ramya Tantry,Kumar Chhajed,Mahendra Mungase,Mahendra Mungase

Hi lisa davison,

Can you look into the system configuration for El Camino Hospital due to the following issues.
I ran out an enrollment report and compared it to the ACA analytic spreadsheet and found for the 1E_2B folks we have an active enrollments in WT for 2016. Perry Aganad and Robert Almeida being examples. For Perry Aganad- His status went from PT to FT effective 1/27/2016. The 1095 for the month of Jan/ Feb shows 2B. I would think the code for Feb should be 2D the 1095 is showing 2B for Feb and EE became eligible for benefits 03/2016.

Perry Aganad:
This employee is not enrolled in Jan/Feb for medical plan so 2B is coming. And this employee Type on demographic is set to PT.

Robert Almeida:
This employee need to pay $805 cheapest employee only tier cost and the annual salary of this employee is “83512” so populating the Safe harbor code 9.66% of employee monthly salary is greater than the 805.*
Also, the client reported the below issues as well:
We also noticed that some employees coded 1E have a line 16 code of 2B and that should not be the case because if they are 1E that means coverage was offered therefore we need to specify if they elected coverage or waived. Please advise what code you would like 2B changed to? the system is reading them as a part-time so pulling the 2B. It should either be 2C (enrolled) or 2G (waived). If there is no election for them in the system it should be 2G.

If the employee type on demographic is set to PART time and not enrolled in any ACA Plan then system will mark that employee for the month 2B. If employee is offered coverage 1E on line 14 but not satisfying safe harbor then system will write line 16 as blank.
If you want to force the codes on 1095c then please use the Code correction feature for the same.
Ex above 2 emloyees.
Also some with 1E have a blank on line 16 and we need to have some type of code for line 16. An example of that is Ronan Acot.

Ronan Acot : This employee is part time and not enrolled in any medical plan.
Again – we just need to know what codes you would like for us to use on line 16? They are showing a blank as they do not satisfy the safe harbor (FPL) and since they are not enrolled, the safe harbor code of 2G would normally go there. If they are not enrolled it should be a 2G and not left blank.
*
If you want to force the codes on 1095c then please use the Code correction feature for the same.
Anyone with code 1H should have line 16 code 2A, 2D or 2B. Can you confirm to see if that can be pulled from the system or do we need to tell EBS what the code is for the blanks?*

*EX: Balwinder Chand employee is getting 1H and blank [line 16 ] because there is no offer of coverage and as per IRS this is correct.
If you want to force the codes on 1095c then please use the Code correction feature for the same
*

Hello Ramya,

Can you advise why we are using the Part-Time indicator on the ACA analytic spreadsheet for ECH as we don't load hours. The client requested that we update the spreadsheet to reflect the correct status in column R- For example, for Diana Barile is listed as Part-time and should be full time. Please run out a corrected file by tomorrow to reflect status that indicated on the demographic for all employees.

Ramya Tantry

HI all - could you please take this on priority tonight? Thanks!
Nandkumar Prabhakar Karlekar

Smita Pawar,

Can please advise on below query.

CC:Nandkumar Prabhakar Karlekar,Kumar Chhajed

Hi [~jennifer.leugers,

We have already completed this , please refer the latest run "2/13/2017 1:12:21 AM.".
We identified this is a requirement of this client and proactively we have completed this task.
I have verified example employee " Diana Barile " and in latest run she is reflecting as Full Time.

All - I'm getting a server error when trying to upload the changes for ECH.

I'm sending the files to Nandu / Sachin and the password is ECHACA_5934

Hi Jennifer Leugers,

Part II correction file -

XXX58470 - Employee SSN doesn't exist in the workterra system.

All other employees provided were imported successfully for Part II file.

Part III Correction file issues found were -

1) The Employee SSN and the Member SSN / DOB doesn't match.
For example -
Employee SSN = XXXX97511 and its given Spouse SSN i.e Member SSN = XXXX55142 which doesn't match.

Also if you are providing Correction for Employee then its Member SSN and Employee SSN must be same
Ex -
Employee SSN - 123456789
MemberType - EE
Member SSN - 123456789

2) Some of the Employee SSN are blank, it is mandatory to provide employee SSN.

Due to above issues, we were unable to import Part III Correction file.
Please provide correct Part III Correction file, so that we can import it and run then 1095C on the main company

Note - We tested this on HSPL company.

CC Nandkumar Prabhakar Karlekar Ramya Tantry Smita Pawar Revansiddha Gaur

Hi all - the Part II file can go ahead and be loaded into our Production site. We don't need Part III to be loaded for now. I attempted to load the Part II again today and was unsuccessful. So far we haven't been able to import any bulk correction files. Are we doing something wrong?

Hi Jennifer Leugers,

We have imported the Part II correction file and re-run the 1095C. Please refer latest run (2/22/2017 9:56:09 PM)

The reason why you were unable to import the correction file is -

Part II Correction File -
1) The file must be in the format same as attached file Sample File -Part II.xls

Part III Correction File -

1) The file must be in the format same as attached file Sample File -Part III.xls
2) There was discrepany from our side that if the Correction is for Employee then its Member type in Template is set to Employee it should not be EE. Same for Spouse and child it should not be SP & CH, it should be Spouse and chlid
We have updated the Specification template

Note - Before importing the files it will be good if you verfiy this -

1. Navigate to Template Management >> Import
2. Select the template which you are importing
3. Navigate to Data Transformation tab and select sub-template
4. You will see Fields ex - Part 2 EIN,
5. Click on Map field and make sure that EIN value which you are importing is same as the Map Data Column.
   For ex - If Map data for one EIN is 123456789 then value of EIN in file must be 123456789, either it will go into bad file.
   Same in-case of Part 3 Member Type Refer

Let us know if you have any query on this.

CC Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar

Hello,
Feel free to reopen in case any further action required on this. Thank you.