Hi,

We have rerun '1095C for Foothill'.
Please refer latest run '1/19/2018 10:33:52 AM' to download.

Note: Creating separate ticket for different EIN.

Thanks,
Smita

Hi Jennifer Leugers,

There were 27 socials that were attached. Out of those
1)19 Employees are already present under the CVHP Report
2)6 Employees are terminated effective 2016 year and they do not have any enrollment hence they cannot be furnished under the report for year 2017.
3)2 Employees are added under the Foothill Rule by adding additional criteria.
Please refer latest of 1095C for Foothill Report.

Hi Jennifer Leugers

We have rerun report after code correction.
Please refer below mentioned latest run to download report.

1095C for Foothill----Run date 2/6/2018 4:20:13 AM

Thanks!!!

Hi all - I made corrections through the UI. Please apply corrections and re-run forms. Thanks!

Hi Jennifer Leugers,

We have rerun '1095C for Foothill' report on production by setting flag 'Apply Correction' to 'Yes'.
Please refer latest run '2/8/2018 10:21:00 PM' to download the report.

Verified employees from run are as follows

1.MISTIE COURTNEY BRO MONROY
2.MATTHEW JOHN CHRISTENSEN

Thanks!!

Hi Jennifer Leugers,

We have re-run '1095C for Foothill' report with Apply User Correction set to Yes after code correction import.
Please refer latest run '2/16/2018 12:01:48 AM' to download reports.

Tested scenarios are as follows.
1.Valid codes are reflecting of file.
2.MEC indicator is marked as 'YES' for all 12 months.
3.Tested sample employees are as follows.
1.ERMELINDA OLAGUE CUEVAS
2.MATTHEW JOHN CHRISTENSEN
3.FRANCES MENDOZA

Thanks!

Trying to run the 1094C for Foothill for 2016 and nothing is showing under the Authoritative Transmittal when I select Yes.

Hi Jennifer Leugers,

CONCERN: Trying to run the 1094C for Foothill for 2016 and nothing is showing under the Authoritative Transmittal when I select Yes.
CAUSE: Selected Transmittal for : 1095C for 2016 Foothill associated to this report Eligibility Rule (Foothill Presbyterian Hospital) is not found in EIN Classes Mapping for an EIN.

We are assuming that this report is created by mistake for 2016 year as execution is going on for 2017 year. Hence, we have created 1094 C report for 2017 year named 2017 1094C for Foothill & run date-2/21/2018 10:59:00 PM.

Thanks,
Revan

No this was not an error - they still need the 2016 filed.

Hi Jennifer Leugers

Let us know, if there is any action point from our side.

Thanks!!

Hi all - I tried to submit the 2016 file but it got rejected; I've added the error file in WT. Could you please review?

Please let me know,is there needed any input from developer end?

Thanks,
Revan

CC- Ramya Tantry, Nandkumar Prabhakar Karlekar,Sachin Hingole

Hi Jennifer,

We have analysed that, in 'FOOTHILL IRS SUBMISSION' software ids which were got used is for tax year 2017 hence this submission got rejected. For CVHP- Foothill, we have changed the software ids for Tax year 2016 and Rerun the submission by creating new IRS submission.

Currently we have reverted 2016 software id from ACA parameters screen and updated 2017 software id.
Please refer IRS Submission 'FOOTHILL IRS SUBMISSION Corrected'. Let us know if you need any additional information.

Thanks!

Hi Smita - I just resubmitted and the file is still rejecting. I've attached it herein.

Hi Revansiddha Gaur,

We can not do this change from UI so could you please look into same.

Thanks!

Hi Nidhi Kaul,

As we have received the request to process the prior year i.e. for 2016's 1094-95 xml file generation but current system doesn't have the feature of handling or generating the xml files for the prior year. So, we have to make manual code changes to process the same. As per the IRS guidelines, please refer attached screenshot for more information ,
These 2016ProcessXSLTAndSchema_ConfigKeys.zip files need to be uploaded on server to furnish this request.

Once we generate the xml files, those changes will be reverted back to the original state.

Please provide an approval for the same.

Thanks,
Revan

CC-Satya, Samir, Nandkumar Prabhakar Karlekar, Ramya Tantry, Rakesh Roy, Prashant Samal

This is on hold as discussed.

Jennifer Reed Abhay Patil Nandkumar Prabhakar Karlekar Satya

Nandkumar Prabhakar Karlekar Rakesh Roy
Jennifer Leugers has asked whether we can take this up after the regular ACA for 2017 are taken care of.
It will be good to have a rough time estimate and risk, if any, in doing "replacing file on server, and reverting back later" steps.

Hi Jennifer Leugers,

We have done complete analysis and found needed code changes in below mentioned files.
1. Business Logic Code Changes
2. Mixture of Schema Changes needed (2016+2017)
3. Compatible XSLT changes - Form Data File(2016), Manifest XSLT (2017)
4. Config files.

By considering above changes & considering risk, instead of deploying the changes on live server, we can generate the XML files on local environment by taking the production main company db locally and upload the XML files on ftp server to submit the files on IRS portal. Those generated files will be valid since validated against IRS provided schema files but we can't assure that those files may be submitted successfully or rejected on IRS portal.

If any correction is need to be done in case of rejected or accepted with error, it can be done only with local code environment for 2016 XML files.

If you approve to process those 2016 XML file generation by taking the production db locally, we needed three days to deliver the XML files.

Thanks,
Revan

CC- Abhay Patil, Jennifer Reed, Satya, Rakesh Roy, Nandkumar Prabhakar Karlekar,Ramya Tantry

Hi all - thank you very much for finding this solution. I think it will work fine so please proceed.

Hi Jennifer Leugers,

We have uploaded the Prior Year i.e. 2016 xml files on FTP Path- /users/workterraaca/_Tax Year 2017/CVHP.

Please submit those files on IRS portal and let us know the Acknowledgement Status once transmitted.

Thanks,
Revan

CC: Abhay Patil, Nandkumar Prabhakar Karlekar, Satya

Hi Jennifer Leugers,

Can you please confirm the Acknowledgement Status for 2016 xml file submission?

Thanks,
Revan

CC- Abhay Patil, Nandkumar Prabhakar Karlekar, Satya

Hi all - I was out of the office most of the last week but tried to submit today and still receiving an error. Please see below -

1 error has occurred. See below for more information. If the problem continues, please contact us.

[TPE1106] The manifest file does not match our current schema. In particular, our system has detected a potential issue with the following element(s): irs:ChecksumAugmentationNum. Please review the published schemas located here, correct any issues, and try again.

Hi Jennifer Leugers,

We have uploaded the Prior Year i.e. 2016 xml files on FTP Path- /users/workterraaca/_Tax Year 2017/CVHP/21March2018.

As per irs reported error, we resolved an error by changing the logic of generation "checksumAugmentationNum" locally.

Please note that we can't assure that those files may be submitted successfully or rejected on IRS portal.

Thanks,
Revan

CC- Satya, Abhay Patil, Nandkumar Prabhakar Karlekar, Smita Pawar, Sachin Hingole

Please let us know once you received Acknowledgement status and screenshot in case of any error occurred.

Thanks,
Revan

Hi all - the file was Accepted with Errors by the IRS.  I'm attached the ACK file in hopes you can load it and let us know the errors.  Thanks!

Hi Jennifer Leugers,

Good to know that our efforts are fruitful to generate prior year xml file,finally.

Provided Acknowledgement File says that 23 employees demographic information are not matching with IRS database in short TIN VALIDATION ERROR.

Please find the Error Analysis Report uploaded on Ftp Path-/users/workterraaca/_Tax Year 2017/CVHP/21March2018/27March2018.

Information present in excel sheet as below-

Sheet Name-"ACA IRS Error Analysis Report" - 23 employees details to sync in WT system with IRS database

Sheet Name-"ACA 1095C Discrepancy Report" - Out of 23 employees, 1 employees First Name is more that 20 character in length.

Sheet Name-"ACA TIN validation error report" - While correcting 23 employees details to sync with IRS database those 23 employee's spouse and dependent information also need to be updated.

Thanks,

Revan

CC- Abhay Patil, Satya, Nandkumar Prabhakar Karlekar

Closing this ticket