Mail Copy From FTP- Mail.pdf

Hi Alex Nguyen,

Can you please provide password for same again.

Thanks,
Smita

FYI Nandkumar Prabhakar Karlekar,Revansiddha Gaur,Sachin Hingole,Revansiddha Gaur

Hi Alex Nguyen,

We are working on same. We will update you on same.

Thanks,
Smita

FYI Nandkumar Prabhakar Karlekar,Revansiddha Gaur,Kumar Chhajed,Sachin Hingole

Hi Alex Nguyen,

We are working on the same. We will give you the file on or before 6th April.

Thanks,
Revan

Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar

Hi Alex Nguyen,

We have uploaded corrected full files for the month of January 2017 on EBS FTP.
Details about uploaded files are as follows.

URL: https://ftpsecure.ebsbenefits.com
Path: /users/workterraaca/BSG ACA/Metso ADP File/04062017
Zip Folders: Jan.zip

Please let us know if you need any additional information.

Note: Below mentioned employees are not on file as they are enrolled in optout plan and are not eligible for any ACA plans.
Raup Brian
Kemler Mary
Malcolm Bonnie

We have removed them manually from file. Please let us know, if we schedule this file then employees will be on file.So please confirm will it be ok or not.

We will provide change file for same by tomorrow i.e April 07, 2017 [EOD].

Thanks,
Smita

FYI Nandkumar Prabhakar Karlekar,Sachin Hingole,Kumar Chhajed,Revansiddha Gaur

Hi Alex Nguyen,

We have uploaded the Jan 2017 ACA Active Employees on FTP.

Ftp URL : /users/workterraaca/BSG ACA/Metso ADP File/04072017/Jan-2017-Active-Employe

We verified at dev side by exporting the files from hspl copy. QA will test the file on tomorrow.

Please let us know your feedback on the same till tomorrow if anything discrepancy.

Once your approval we will give you the files from Main Production Company.

Thanks & Regards,
Revan

Debbie Kulling

Nandkumar Prabhakar Karlekar Smita Pawar Sachin Hingole

Thank you Revansiddha Gaur. I have forwarded it to client for auditing and will report back if any discrepancies or issues found on the file.

Hi Alex Nguyen,

Please confirm on below point which is mentioned in the above comments of Smita.

Note: Below mentioned employees are not on file as they are enrolled in optout plan and are not eligible for any ACA plans.
Raup Brian
Kemler Mary
Malcolm Bonnie

We have removed them manually from file. Please let us know, if we schedule this file then employees will be on file.So please confirm will it be ok or not.
Thanks,
Revan

Smita Pawar Nandkumar Prabhakar Karlekar

Hi Alex Nguyen

We have uploaded Active and Non employee [Full & change] files for Jan, Feb and Mar 2017 from HSPL copy.
Multi employer full file for Jan 2017.

FTP details for Uploaded files are as follows.

URL:https://ftpsecure.ebsbenefits.com
Path:/users/workterraaca/BSG ACA/Metso ADP File/04092017
Folder names:Jan.zip, Feb.zip, Mar.zip

Please let us know feed back for same.

Note: Below mentioned employees are not on file as they are enrolled in opt out plan and are not eligible for any ACA plans.
Raup Brian
Kemler Mary
Malcolm Bonnie

We have removed them manually from file. Please let us know, if we schedule this file then employees will be on file.So please confirm will it be ok or not.

Similarly as discussed previously Multi employer file have only full file no change files for subsequent months.

Thanks,
Smita

FYI Nandkumar Prabhakar Karlekar, Revansiddha Gaur,Sachin Hingole,Kumar Chhajed

Hi Smita Pawar and Revansiddha Gaur,

The client hasn't responded yet regarding the mention employees, but I just sent them another email as a reminder. The Jan, Feb, and Mar 2017 files have been forwarded to them. I'll let you know once I receive their feedbacks.

Thank you,

Alex

Hi Smita Pawar and Revansiddha Gaur,

The client asked why it was determined that the three employees are not going on the ACA file. There's a discrepancy. I have stored their comments in the file "04102017_client_comments.zip" and uploaded to the following for you to review prior to the call:

URL:https://ftpsecure.ebsbenefits.com
Path:/users/workterraaca/BSG ACA/Metso ADP File

Amit Thorve said he's going to be contacting developers soon to setup a call upon client's request to go over the ACA files.

Thank you,

Alex

Hi Alex Nguyen,

Question:
The client asked why it was determined that the three employees are not going on the ACA file. There's a discrepancy.

Harbinger Comment:
Eligibility will be checked for Aca marked plans for complete month but for below none of employees are eligible for any aca plans for complete month and Medical Opt Out is not marked as ACA Plan except it benefit type is medical.So in this scenario eligibility element which are mandatory populates with blank which is not expected.
So we manually removed these employee complete element set (EEID,OFFR,ELIG,COVG).

To get an idea for these employees we have re uploaded latest folder with name Jan1.zip

Path: /users/workterraaca/BSG ACA/Metso ADP File/04092017
Folder name: Jan1.zip

Note: This folder contains Active employee's file for Jan Month which you can refer.

Thanks,
Smita

FYI Nandkumar Prabhakar Karlekar,Revansiddha Gaur,Kumar Chhajed,Sachin Hingole

Hi Alex Nguyen,

MOM:

Action points depending on Call 12th April 2017.

Harbinger action points
1.Need to send the list of employees which enrolled 2017 opt out medical plan and are losing the eligiblity in mid of JAN month.
2.Need to do Customization for coverage tier for Waive subtemplate 'Single' as S.

EBS action points
1.Reverification of template customization.
2.Feed back for Non Employee & Multiemployer files.

Thanks,
Revan

FYI Nandkumar Prabhakar Karlekar, Sachin Hingole,Debbie Kulling, Smita Pawar,Abhay Patil

Please find the client mail communication for eligibility loss approval. Eligibility Loss Correction Approval Email.pdf .

Thanks & Regards,
Revan

Smita Pawar Mahendra Mungase Sachin Hingole Nandkumar Prabhakar Karlekar

Hi Alex Nguyen,

We have uploaded the Active employees Full file for Jan Month and Change files for Feb & Mar month as per new changes.We have exported these files from Metso for Hspl copy.

Details of uploaded files are as follows.

URL:https://ftpsecure.ebsbenefits.com
Path:/users/workterraaca/BSG ACA/Metso ADP File/04172017
Folder name:Jan Feb Mar.zip

Note: There is no change in Non Employee and Multiemployer files so we are not uploading it again.

Thanks,
Smita

FYI Nandkumar Prabhakar Karlekar, Sachin Hingole, Kumar Chhajed,Revansiddha Gaur

Hi Smita Pawar,

The only file I see posted in /users/workterraaca/BSG ACA/Metso ADP File/04172017 is called Zhone files from Jan to Mar.zip. I downloaded the files and these members are from Zhone.

Can you repost the latest files for Metso?

Thank you,

Alex

Hi Smita Pawar,

We have finished auditing the file, and they were sent over to the client for final audit. We came across 1 issue on the [COVG] row. The "Reason for Waiver Description " was coming out as a blank on the file for records with Reason Code 06. Can you data transform or update the configuration on the back end to pass value "Unknown" for those waived records?

Thank you,

Alex

Hi Alex Nguyen,

Details of newly uploaded active employees files are as follows.

URL:https://ftpsecure.ebsbenefits.com
Path:/users/workterraaca/BSG ACA/Metso ADP File/04192017
Zip folder: Delivary 19 April 2017.zip

Please let us know, if you need any additional information.

Thanks,
Smita

FYI Nandkumar Prabhakar Karlekar,Rakesh Roy,Revansiddha Gaur

Thank you Smita Pawar for the quick turnaround. I do see the updated data transform now on the new files provided. Once client is done with the audit and approved everything, I will take the files you provided and send them off to the carrier.

Alex

Hi Alex Nguyen,

Amit Thorve

Jan 2017-Active,NonEmployee,MultiEmployer those shared files through mail yesterday that are also uploaded on FTP.
Please find the details.

URL: https://ftpsecure.ebsbenefits.com
Path: /users/workterraaca/BSG ACA/Metso ADP File/04212017/Jan 2017-Active-NonEE-MultiEmployer-MainCompany

Password will be the same for uploaded on ftp files which shared yesterdays mail for these files.

Thanks,
Revan

Smita Pawar Mahendra Mungase Sachin Hingole Nandkumar Prabhakar Karlekar

Hi Alex Nguyen Amit Thorve

Please find updates on files

Today (21/April/2017)-Sharing the files...

Active Employee Change File -
Feb,March

NonEmployee File-
Full - Jan
Change - Feb,March

Please download file fron FTP on below path

URL: https://ftpsecure.ebsbenefits.com
Path: /users/workterraaca/BSG ACA/Metso ADP File/04212017/Jan_Active_NonEmployee_17

We have found blank for oldplandesignidentifier information for the 8 plans. in resultant we were getting the medical plan code as blank under ELIG element
So we have set the oldplandesignidentifier for those plans of our own. Please find the excel file (DevSetOldPlanDesignIdentifier.xls) for the same for your reference which we have sent oldplandesignidentifier.

By setting oldplandesignidentifier, we are regenerated Jan full file.

Discrepancy -Employee name - Kenneth Hogue SSN - XXXXX2102 - Dependent SSN exported blank on file but it is mandatory under DEPC element.
We did analysis and found WT system it's dependent SSN is blank.

Multi Employer Change File:
Feb- No records found
Mar- No records found

======================================

Yesterday's status - 04/20/2017

File Status of Metso..

20/April/2017 Night- Shared Files
Jan 2017- Active,NonEmployee,MultiEmployer (full file)

Pending Files for next day (21/April/2017):
Active-Feb,March (Change)
NonEmployee-Feb,March(Change)
MultiEmployer-Feb,March(Change)

Thanks

CC- Nandkumar Prabhakar Karlekar Rakesh Roy Smita Pawar Sachin Hingole Revansiddha Gaur

Hi Mahendra Mungase,

I'll download and set them to the side for now. We're still checking with ADP about the multi-employer file, because there seems to be some confusion with union records. We're waiting on ADP and client to confirm where to put those union members on, before we have client do another audit. That's the only concern we have at the moment and want to make sure everything is correct. We might need a new file later if client expect the unions to be on a different file. I'll let you know after we get confirmation from client/ADP.

Thank you,

Alex

Hi Mahendra Mungase Smita Pawar Nandkumar Prabhakar Karlekar Revansiddha Gaur,

Amit had talked to the client and ADP. We're no longer sending the multi-employer file, because it has been confirmed that the unions class are covered under their employer and not through a union. We will only be sending the employee and non-employee ACA files going forward. Please update to include the unions on the files, then post them for us to do another audit.

Thanks!

Alex

Hi Alex Nguyen,

We have changed customization for unions class under active employees for multi-employer file.
PFA updated Active & Non Employees file for Jan, Feb, Mar 2017.
Details of uploaded files are as follows

URL:https://ftpsecure.ebsbenefits.com
Path:/users/workterraaca/BSG ACA/Metso ADP File/04282017
Folder:Active_Employee.zip
Non_Employee.zip

Note: We have just re sending old Non employees file without any change [Uploaded on 04/21/2017].
Let us know if you need any additional information.

Thanks,
Smita

FYI Nandkumar Prabhakar Karlekar,Revansiddha Gaur,Sachin Hingole,Mahendra Mungase,Rakesh Roy

Thank you Smita Pawar. I have forwarded them to the client for audting.

Alex

Hi Smita Pawar,

Can you provide us the latest Feb, March, and April change files?

Thank you,

Alex

Hi Alex Nguyen,

We are working on same.
We will provide you files on 05/03/2017.

Thanks,
Smita

FYI Nandkumar Prabhakar Karlekar, Sachin Hingole,Revansiddha Gaur

Hi Smita Pawar,

Will you be able to put a rush on providing the files? It's a good time to provide them the changes files, while they're still working on the audit. I can send them out today once you have them ready.

Thanks,

Alex

Hi @Alex,

We have uploaded change files of Active, Non Employee for month of Feb, Mar, Apr 2017 & Jan month's Full file for Active, Non Employee file .
Below mentioned are details of uploaded files.

URL:https://ftpsecure.ebsbenefits.com
Path:/users/workterraaca/BSG ACA/Metso ADP File/05032017
Folder:Final delivery.zip

Thanks,
Smita

FYI Alex Nguyen,Amit Thorve,Nandkumar Prabhakar Karlekar,Revansiddha Gaur,Sachin Hingole

Thank you Smita Pawar,

I have forwarded them to our client for auditing.

Alex

Hi @Nandkumar and Smita Pawar,

Our client completed the audit of Feb change files and their comments/feedbacks were provided. They were questioning about full file and change file. Because in the future the files will be sending to carrier monthly, the spec recommended full file for monthly and changes file as weekly. The carrier, ADP, only picks up the file Monthly, so shouldn't they be full file or will this cause issues with data coming over? I have attached the file spec again for review.

I have also uploaded the clients comments/feedbacks to following. There are some discrepancies. For example, an EE was on the Jan 2017 Employee file, but lost medical coverage in 3/31/17 and same term date. According to the spec, they suppose to capture this EE new event on the March change file, but it didn't roll over. You can find other discrepancies on the file:

URL: https://ftpsecure.ebsbenefits.com
Path: /users/workterraaca/BSG ACA/Metso ADP File/
File: Feb 2017_Client Comments_ 5112017.docx

Thank you,

Alex

Hi Alex Nguyen,

We uploaded document of Harbinger comments on below mentioned path.

URL: https://ftpsecure.ebsbenefits.com
Path:/users/workterraaca/BSG ACA/Metso ADP File
Document Name:Feb 2017_Client Comments_ 5112017_Harbinger.docx

Let us know if know any additional information.

Thanks,
Smita

FYI Nandkumar Prabhakar Karlekar,Sachin Hingole

Hi Smita Pawar,

I have forwarded Harbinger responses to our client and waiting for them to agree before sending their Feb file to the carrier.

Thank you,

Alex

Good afternoon Smita Pawar and Nandkumar Prabhakar Karlekar,

BSG is providing following responses regarding previous records reported by Shannon and the Jan full and Feb change file. They feel that the data are still not passing correctly:

We have concerns on the response provided by the WT Dev team on the Employees reported by Sharon. Those employees were not sent in the January full file with a term date (which column 12 for the COVG record…and the column is blank).

Please see the attached 2 documents for more details. The document with the name BSG Response has my comments added to the WT Development team’s response. And the other document shows the employee records from the January Full File to support my comments.

Please review and let me know if there are any questions.

Thanks,
Tamkeen Siddiqui
Web / Database Developer

Their comments are uploaded to the following:

URL: https://ftpsecure.ebsbenefits.com
Path: /users/workterraaca/BSG ACA/Metso ADP File/
File: Metso2017ACAFiles_BSGResponse.zip

Can you also explain more on why a full file can't be run each month? Below was one of your comments, but some of us and the client are a bit confused. Will it be possible to send a full file each month reflecting any possible qualifying event changes for the same record? On the template settings, it is currently sending 'latest record only'. Should the run date and settings on the template be looked at further to see if adjustment is needed for a full file to work?

Solution: As per the client request if we are exporting full files for all month these employees will on all month files as per the Enrollment/Waive date range with latest demographic data. Currently system will export latest demographic records

Sorry, we've been going back and forth trying to figure this all out, but I do appreciate all your responses.

Thank you,

Alex

Hi Alex Nguyen ,

1st Issue

[Tamkeen – 05/15/2017] There is no coverage end date (Column 12) sent in the Jan Full File for this employee. There is only the datetimestamp of 03/31/2017 08:51:58.000000 PM. Only the dependents are terminated with 3/31/2017 date.

Harbinger: we have analyzed and fixed this problem and tested the file and verified termination date is coming properly.
Coverage end date is mapped with Enrollment Termination date field but added the incorrect rule engine for this field and because of this termination date is not coming properly.

Coverage end date was blank for below mentioned employees currently on our test files. Now these employees are exporting with proper enrollment termination date.
Arie Lee
Henry Bell
Premetz-Thiede Marta
Fratangeli Benedict
Dagnese Bryan
Brousseau Justin
Maze Tony

2nd issue.

Below employees are not coming on the file

1.Albert LaPrade
2.Dudley Fedric
3.Sean McCue
4.Grover Philip

The status of these employees has changed from Retiree to Deceased.
These employees are neither enrolled nor waived. As discussed with Amit, we haven't inserted waive entries for such employees. Hence these employees will not be on file.

Note : - For Non Employee template, we are not considering waive employees.

Query.
*1.All the reported bugs with their pattern has been fixed from our side, Please let us know if any more checks need to be perform.
2. Till now we were delivering Jan month's full file & next months change files. Please let us know if any changes are required in the delivery of file type and Frequency.*
3.We are waiting for the reply of above question and then we will deliver the ACA files.

Thanks

FYI Amit Thorve, Nandkumar Prabhakar Karlekar,Sachin Hingole,Rakesh Roy,Revansiddha Gaur

Hi Nandkumar Prabhakar Karlekar and Smita Pawar,

ADP ran the January active employee file through their validation tool and detected many records with errors because of the 2016 dates on them. They are expecting to see 2017 coverage start date on the file. Below was ADP responses regarding the full file versus changes file:

For the benefitsimport file… should we start sending it as .txt extension instead of xml?
[Camak, James (ES)] Sure, that would be fine. I thought it was an XML and sent it to validate as that and, of course, it failed. So I then saw it was a text file and started from there. We can convert the files from there.
The file was built using the pipe delimited format. The way the files should be sending to you is January as a full file (initial load) and any months after are changes. Will this be okay? Will you be able to explain the differences between a full file and changes file? Can full files be accepted each month?
[Camak, James (ES)] The initial file for January comes, and then you can send a full file with changes each month. That is the preferred method.
The first file would have the Open Enrollments; the following files would have that but also any new changes and sort of build a history.

So the Jan file may have an employee’s Open Enrollment with an EE only plan.
But the employee then gets married in Feb and now has another Offer with plans and a new selected coverage for an EE + Spouse plan (and with the new dependent information following below).
Then in December the EE selects EE + Family Coverage with the spouse and child listed as two dependents listed this time.
The file in a sense would append the new Offers and Selected coverages.

Again, generally we have full files with all of the employees on it.
Now you could keep all the history on it (making a full historical file over time)
or simply continue a full file (with all the participants included) but where you include where they were at the start of the month but then also add the changes.
In the first cast—the full historical file—you would have all the people, all their Offers, all their plans, and their selected coverages and their dependent lists for each coverage and containing the whole year.
In the second case—a full file with changes—you would have all the people, what offer and plans and selected coverage (and dependents) they had at the beginning of the month and then add any new offers (with plans, selected coverage and dependents) that ended the month.
The first is a cummalative history.
The latter is a month by month full file that includes changes.
The third type of file—a changes only file—is a much rarer file that comes weekly and lists only the new coverages. This is rare, but with it there is a first month file and then weekly changes only files where the only ones in the files from then on are those who have changes. I do not recommend this.

I know that is somewhat confusing. Remember a full file has all the participants. We are looking for coverages and their transitions. A full historical file would perhaps be for the full year and has all the events, while a full file each month would not have to go back to the very beginning of the year. It would simply have what the participants had at the beginning of the month (whether that was a coverage they selected at the first of the year or a coverage they selected just the month before) and then what they have now made changes on.

I hope that helps.

Thanks,
James

I have also uploaded the file results to the site with ADP detail responses regarding the January 2017 files:

URL: https://ftpsecure.ebsbenefits.com
Path: /users/workterraaca/BSG ACA/Metso ADP File/
Employee File: Jan2017 Benefit Imports Results.zip
Non Employee File: Jan2017 Non Employee Results.zip

Please don't deliver a new file yet after fix. I'm still waiting on client to answer your question.

Thank you,

Alex

Hi Alex Nguyen,

Hi Alex,

Please find the comments for each your points in the attached file Metso employee file.docx and we are also working on NON EE file.

We will be delivered you the files by testing on or before Friday.

Meanwhile if you find any other discrepancy at your end please let us know. So that we can send you the final file on or before Friday.

Note: We will send full files for the all months (Employee and NonEE). Please confirm about this.

Password is sending you in the email.

Thanks,
Revan

Nandkumar Prabhakar Karlekar Sachin Hingole Smita Pawar Mahendra Mungase

Hi Alex Nguyen,

We have uploaded Active Employee full file for Jan 2017 with extension as .txt & Non Employees file for Jan, Feb, Mar, Apr 2017for review.
We have verified all fixed issues mentioned in document 'Metso employee file.docx'.

Details of uploaded files are as follows.

URL: https://ftpsecure.ebsbenefits.com
Path:/users/workterraaca/BSG ACA/Metso ADP File/05192017
Folder: Delivery on May19 2017.zip

Sending password in seperate mail.
We will deliver Active employees full files for the month of Feb, Mar,April 2017 on 22 May 2017[EOD].

Thanks
FYI Nandkumar Prabhakar Karlekar,Sachin Hingole,Revansiddha GaurRakesh Roy

Hi Alex Nguyen,

As we were facing problem while uploading Active employee's files on FTP, we have send files in separate mail.

Thanks,

FYI Nandkumar Prabhakar Karlekar,Amit Thorve,Sachin Hingole,Revansiddha Gaur,Rakesh Roy

Hi Smita Pawar,

The full files appear to be exporting the data correctly. I no longer see any 2016 coverage dates on the file and this should clear up a lot of the errors found on the ADP report. I do see you made the update, so MEC is now flagged as 'Y' for the low cost plans. Arie L. is now coming across the Jan, Feb, and March files but dropped from May file as expected. Her employment/coverage of ACA was terminated in 3/31 and this term date is reflecting on all files.

I read through previous discrepancies, errors, and responses. I have checked them against the new full files, but so far couldn't find any further issues with it. You covered all the points and gave explanation for each. There's this other "FT/PT status" that was reported by client for issue #4. I wasn't sure if you already applied the fix, or do you need client to confirm? Below was the issue and your response:

#4 Finally please confirms that the logic will pull across anyone that drops from FT status to PT status and is no longer eligible for coverage?

Solution: To implement this requirement we need to apply this field’s eligibility on all selected plans for this template.

If you need client to confirm, we can bring this up to them tomorrow during the conference call. I know I forwarded this response to client a week ago, but I never heard their feedback on issue #4.

Thank you,

Alex

Hi Alex Nguyen ,

We have uploaded latest employee full file for Option 2 as 'With latest Termination on file'.
Details of uploaded files are as follows.

URL: https://ftpsecure.ebsbenefits.com
Path:/users/workterraaca/BSG ACA/Metso ADP File/06132017
Zip folder name:ActiveEmployee.zip

Sending password in next email.

Thanks,
Smita

FYI Amit Thorve,Nandkumar Prabhakar Karlekar,Sachin Hingole,Revansiddha Gaur,Yogesh Chaudhari,Prashant SamalYogita Bhadane,Rakesh Roy

Alex Nguyen Please review this file today and send it to James today only before noon PST. Please ask James to provide his feedback by tomorrow so we can send him final file by Thursday PST.

CC-Abhay Patil, Cindy Wibbing

Hi Smita Pawar and Amit Thorve,

I have done a quick review and forwarded the file to James to validate. I will review the DTS, then provide feedback by tomorrow.

Thank you,

Alex

Hi Alex Nguyen,

PFA uploaded Active Employee & Non employeee's full files.
Details of uploaded files are as follows.

URL: https://ftpsecure.ebsbenefits.com
Path:/users/workterraaca/BSG ACA/Metso ADP File/06192017
Zip folder name:Delivery.zip

Thanks,
Smita

FYI Amit Thorve,Nandkumar Prabhakar Karlekar,Sachin Hingole,Yogesh Chaudhari,Revansiddha Gaur,Prashant Samal,Yogita Bhadane,Rakesh Roy

Thank you @Smita. I will forward to James to validate before having another meeting with ADP.

Alex

Hi Smita Pawar,

ADP had validated the last file on 6/19/17. They listed errors for updating, but there was a record on the employee file causing everything to fail. They would like the 1 record to move to non employee file. ADP is holding onto the 6/19/17 ACA files and is ready to load them, but waiting for our approval. We're waiting on Amit Thorve to see what he would like to do with the files. I have uploaded the results from ADP for you to review and update, so future files don't have the same issue.

The results can be found in the following location:

Details of uploaded files are as follows.
URL: https://ftpsecure.ebsbenefits.com
Path:/users/workterraaca/BSG ACA/Metso ADP File/06192017
File name: Results.docx

Please review James and Tamkeen comments. They found a special character on the file that needs to be removed. ADP manually removed the 1 record and special characters in order for it to pass validation in their system. They feel the files they currently have are ready to load, but at this point we don't know if Amit is okay with this, or should we wait for a new full file and change file. Please discuss with Amit first before providing new files.

Thank you,

Alex

Hi Alex Nguyen,

PFA uploaded Active Employee & Non employeee's full files for review.
Details of uploaded files are as follows.

URL:https://ftpsecure.ebsbenefits.com
Path: /users/workterraaca/BSG ACA/Metso ADP File/06222017
Zip folder name: 22Jun2017.zip

Thanks,
Smita

FYI Amit Thorve,Nandkumar Prabhakar Karlekar,Sachin Hingole,Rakesh Roy,Revansiddha Gaur,Prashant Samal,Yogita Bhadane

Hi Alex Nguyen,
Please find our analysis for today's feedback received from client

Client Comment:
Amit,
I see that there are few additional events (offers) for some employees in this new file when compared to the previous one. Most of these new events looks like are terminations (Employee Data Change). But I'm curious because most of those termination events have the event date back in March, April and May. So, I'm surprised that those didn't get picked up in the last file sent to James.

However, I found that the record for Ashley Stricker is missing from the new file. (Given below is her record from previous file. And for some reason, even in the previous file, she was only eligible for PPO80, please make sure its correct).

*Harbinger comment: *
PFA screen capture

----------------------------------------------------------------------------------------------------------------------------
PFA uploaded corrected Active Employee's full file for review on June 23 2017.
As discussed with Amit, please send this file to ADP.

Details of uploaded files are as follows.

URL:https://ftpsecure.ebsbenefits.com
Path: /users/workterraaca/BSG ACA/Metso ADP File/06232017
Zip folder name: 23 Jun 2017.zip

Thanks,
Smita

Amit Thorve,Nandkumar Prabhakar Karlekar,Rakesh Roy,Revansiddha Gaur,Yogesh Chaudhari,Sachin Hingole,Smita Pawar

Thank Smita Pawar. I'm reviewing it right now then will provide to Tamkeen at BSG to approve before having ADP load it.

Alex

Hi Alex Nguyen,

Please find attached change files for Active & Non employee.
Details of uploaded files are as follows.

URL: https://ftpsecure.ebsbenefits.com
Path:/users/workterraaca/BSG ACA/Metso ADP File/06292017
Zip folder: Change file Jun 29 2017.zip

Thanks,

FYI Nandkumar Prabhakar Karlekar,Sachin Hingole,Amit Thorve,Revansiddha Gaur,Yogesh Chaudhari,Rakesh Roy

Mail received from Alex.
---------------------------------------------------------------------------------------------------------------------------------------
Hello James,

I would also like to add that back in 6/2/17 you also provided explanation of sending term coverages. Below was your message:

Revising the terminations. This is something that was often missed quite a bit last year and we had to fix these in edits to the 1095-C form.
The Offer (with a Offer Event Reason and Event Date) has plans and these plans show the “eligible” plans.An offer with no plans (but with an Event Reason and Event Date) would close the previous open Offer and demonstrate a Loss of Eligibility.

This Offer is listing the eligible plans, and listing none, signifies that the person is not eligible for any plans.A termination can be done/passed in a couple of ways. Simply giving/adding a “coverage end date” in the previous coverage.Or by sending a Selected Coverage with no plan information but with an Event Reason, Event Date, Coverage End Date and Transaction Date.

The related issue with these at times is that there is a difference between simply terminating coverage—and when an active employee simply decides to end coverage on a specific date (perhaps to take coverage elsewhere) but is still eligible (and here the client needs to prove they are still offering coverage for this eligibility—and an employee being terminated from employment and thereby loosing eligibility (loss of eligibility) and also having coverage terminated (and for which time after the client is not obligated to show that they are offering coverage because the person is not eligible.

For James Carroll, his employment terminated causing loss of coverage and was the reason that last event was sent without the ELIG segments and would make sense he’s no longer eligible for any plans. It’s showing the selected coverage, start date, and end date for this as expected for the previous plan he was in. We’re all confused now with the latest feedback. The 4/14 event date reflects the date the employment is terminated. Shouldn’t this be reported because it is an event showing loss of coverage? I did a quick checked on a few others from the 143, and they are also terminated employees. We’re still on spec version 3.0 and looking at its spec it indicated not to send plans for loss eligibility. Do you need a new full file from us or is there something you can do in your system to clear up the 143 errors for them to load through using same file from last week?

Hi Alex Nguyen,

We are waiting for complete feedback from Metso for Active employee's full file.
We have kept Change file task for Active & Non employee files on hold.

Thanks
FYI

Nandkumar Prabhakar Karlekar, Sachin Hingole,Amit Thorve,Rakesh Roy,Revansiddha Gaur,Yogesh Chaudhari

Hi Smita Pawar and Nandkumar Prabhakar Karlekar,

ADP is requesting for a new full file for employee and non employee files. On the employee file, all termination coverage records will need to pass only the following elements..... EventReason, EventDate, and CoverageEndDate on the COVG segment. Please see Amit's sample from the attachment Sample_Event.txt for the 3rd qualifying event. This was an employee whose employment was terminated causing loss of eligibility. We have many of this on the previous full file affecting 143 participants and passing too much detail on the COVG segment causing file to fail. Somehow it passed ADP validation, but failed after it tried to load. This is the only outstanding issue as of today that was reported.

We'll have to put the change files on hold until this full file is loaded all the way through without anymore errors. Let me know if you need additional info.

Sample_Event.txt

Thank you,

Alex

Hi Alex Nguyen,

We have uploaded Employees full file after changes and Non employee file also.
We are also testing files at our end.
Details of uploaded files are as follows.

URL:https://ftpsecure.ebsbenefits.com
Path:/users/workterraaca/BSG ACA/Metso ADP File/07062017
Folder name: 07062017.zip

Thanks,
Smita

FYI Amit Thorve,Sachin Hingole,Nandkumar Prabhakar Karlekar,Rakesh Roy,Revansiddha Gaur,Yogesh Chaudhari

Hi Alex Nguyen

We will send you both the file tomorrow after complete verification of data, Please review at your end and let us know any corrections are needed.

Note : Please do not send this file to ADP.

Amit Thorve

Thank you Nandkumar Prabhakar Karlekar and Smita Pawar. I will let you know if any further corrections needed for the new file and will not send to ADP until you give the okay.

Alex

Hi Nandkumar Prabhakar Karlekar and Smita Pawar. The number of OFFR and COVG segments are matching up, but I notice some changes on this new 7/6/17 employee file. I remember the previous 6/23/17 file had transaction date of 10/15/16 for many of the open enrollment events on the OFFR segment. This new file seems to have reverted them back to 1/1/17, so I want to point this out in case you need to change it back to 10/15/16.

ADP only needed us to update OFFR and COVG related to 'Employee Data Change' events, because these are employees who terminated employment causing loss of eligibility. They are coming out correctly now showing only the required data. Another concern is the coverage term date for James Butler family. He was a deceased on 6/5/17, but coverage term date is now 6/5/17 on the new file. The previous file coverage date was reflecting end of month 6/30/17. I assume the new file is correct, because it matches the company's termination rule for deceased (Termination Date Rule=Date of Termination).

Those were the noticeable changes on the file. Let me know if you have any questions.

Thank you,

Alex

Hi Alex Nguyen,

We have uploaded Active & Non employees incremental full file till date.
Details of uploaded files are as follows

URL:https://ftpsecure.ebsbenefits.com
Path:/users/workterraaca/BSG ACA/Metso ADP File/07112017
Folder name:07112017.zip

Note: Updated latest data for these active employees 'Ziegler Scott B.' , 'Cramer Mark R.' is reflecting on current file.

Thanks,

FYI Amit Thorve,Sachin Hingole,Rakesh Roy,Nandkumar Prabhakar Karlekar,Revansiddha Gaur,Yogesh Chaudhari

Alex Nguyen Please check this file thoroughly with respect to the last good file sent to James (the one with 143 bad records).
Do not send the file to Tamkeen without checking thoroughly.

CC-Abhay Patil, Cindy Wibbing

Thank you Amit Thorve and Smita Pawar. I will look through them thoroughly today to compare with the 6/23/17 file. Will report back any issues, but if it's fine I will forward to Tamkeen.

Alex

Hi Smita Pawar and Nandkumar Prabhakar Karlekar,

ADP is in the process of loading the full file. They had to manipulate the file a bit and was able to get it to passed validation. Once they confirm the full file loads through successfully, I will let you know. Things they expect to be fixed on the ongoing change files:

1) include transaction date on the COVG segments for any loss coverages (Employee Data Change). Although they said they only required EventReason, EventDate, and CoverageEndDate.....they now asking to also include transaction date.

2) make sure dependent Olivia Gladstone’s (dependent of Keith Gladstone) middle initial is 'I' instead of 'A'.

That's what was found on the full file and manipulated by ADP for validation to pass. There's no need for a new full file. Just things to keep in mind for the ongoing change files.

Thank you,

Alex

Hi Alex Nguyen,

We have uploaded change file of Active employees for review.
Detail of uploaded file is as follows.

URL:https://ftpsecure.ebsbenefits.com
Path:/users/workterraaca/BSG ACA/Metso ADP File/07202017
File name:EF0597B9DB0007C9_Metsoshare_BenefitsImport_20170719_205632.txt

Let us know if you need any additional details.

Note: Non employee change file is still in testing. We will send it for review after Harbinger testing gets completed

Thanks,
Smita
FYI Amit Thorve,Sachin Hingole,Nandkumar Prabhakar Karlekar,Rakesh Roy,Revansiddha Gaur,Yogesh Chaudhari

Alex Nguyen

Hi Alex,

We have uploaded change file of Non employees for review.
Detail of uploaded file is as follows.
URL:https://ftpsecure.ebsbenefits.com
Path:/users/workterraaca/BSG ACA/Metso ADP File/07212017
File name:EF0597B9DB0007C9_Metsoshare_NonEE_20170721_130407

Let us know if you need any additional details.

Thanks,
Yogita

FYI Amit Thorve Nandkumar Prabhakar Karlekar Smita Pawar Revansiddha Gaur Yogesh Chaudhari Sachin Hingole

Hi Alex Nguyen,

Please let us know a feedback on the change file and full file.

Thanks,
Revan

FYI Nandkumar Prabhakar Karlekar Amit Thorve Smita Pawar Yogesh Chaudhari Sachin Hingole

Hi Revansiddha Gaur,

I haven't heard back from ADP relating to the full file. I last asked them if they were ready for the change file, but they haven't responded yet. I just left James and Tim a voice message today asking them to confirm. I will send them another email.

Thank you,

Alex

Hi Alex Nguyen,

Let us know, feedback for sent files if you received any.

Thanks,
Smita

FYI Nandkumar Prabhakar Karlekar,Sachin Hingole,Revansiddha Gaur,Amit Thorve,Yogesh Chaudhari

Hi Smita Pawar,

Please find the Active Employee Change File for 01012017 to 08042017 for verification.

File : Change_Active_01012017_08042017_ForQAVerification.zip

Note : Password sent in mail.

Thanks,
Revan

Nandkumar Prabhakar Karlekar Yogesh Chaudhari

Hi Smita Pawar,

Please find the Non-EE Employees Change File for 01012017 to 08042017 for verification and delivery.

File : Change_NONEE_01012017_08042017_ForQAVerification.zip

Note : Same password of Active File.

Thanks,
Revan

Nandkumar Prabhakar Karlekar Yogesh Chaudhari

Hi Alex Nguyen,

We have uploaded change files of metso for active and non employee.
Details of uploaded files are as follows.

URL:https://ftpsecure.ebsbenefits.com
Path:/users/workterraaca/BSG ACA/Metso ADP File/08042017
Zip folder:Change file.zip

Thanks

FYI Amit Thorve, Nandkumar Prabhakar Karlekar,Sachin Hingole,Revansiddha Gaur,Yogesh Chaudhari,Rakesh Roy

Hi Smita Pawar,

We are still waiting on ADP to provide us detail results for the full file. They recently installed a patch on their server, rerun the calculation, and found 20 outstanding employees with the issue. Once they provide the results, we will let you know who goes on the changes file.

They were suppose to provide the results yesterday, but it never happened so hopefully there's something today for us to work with.

Thank you,

Alex

Hi Smita Pawar,

Daniel Hayes Gaffney and his family had active coverage from 1/1/17-3/31/17 then COBRA from 4/1/17-5/31/17. I do see them appear correctly on the non employee changes file. The active employee file only has 1 event (employee data change) with the termination, but we're missing his 1st event related to open enrollment and will likely error in ADP system. We need to also include his open enrollment event with transaction date 11/11/16, plans offered, family coverage effective 1/1/17, and list of his dependents tied to the active coverage.

That was the only thing I notice missing from the file. Recently he had errors and corrections done on his account in WT. Can you update the changes file for Daniel Gaffney's record? Let me know if you have any question about this before updating. Other than that everything else appears fine such as the number of OFFR/COVG are matching up for other records on the file.

Thank you,

Alex

Hi Smita Pawar,

Please find the corrected file (Daniel|Hayes|Gaffney) to verify & delivery which we have done manually.

Attachment : Corrected_Daniel_Hayes_Gaffney_Change_Active_01012017_08042017_ForQAVerification.zip

Thanks,
Revan

Nandkumar Prabhakar Karlekar Yogesh Chaudhari

Hi Smita Pawar,

In above file for the corrected employees coverage cost is blank Please update it by checking on UI.

Thanks,
Revan
Nandkumar Prabhakar Karlekar Yogesh Chaudhari

Hi Alex Nguyen,

We have uploaded Active and non employees change files.
In Active employees change file we have manually corrected record for Daniel Hayes Gaffney.
Similarly we have uploaded same change file for non employee which was given on 08/04/2017.

Details of uploaded files are as follows.

URL:https://ftpsecure.ebsbenefits.com
Path:/users/workterraaca/BSG ACA/Metso ADP File/08082017
Zip folder:Change Files.zip

Thanks,

FYI Nandkumar Prabhakar Karlekar,Smita PawarSachin HingoleRevansiddha Gaur,Yogesh Chaudhari

Feedback on Full File
Mail From Amit Thorve
Mail - Metso_Mail_15Aug.pdf
Mail Attachment - Metso_Missing_Offers_08152017.zip

Hi Alex Nguyen,

Please find our comments as below...

Highlighted in yellow in excel file employee's issue causes..

Employee: (322253) Hector Fernando
Concern: Why not offers.
Cause : This employee belongs to Class1(Benefit Program) - "MNO - MNO Benefit Program" which is not selected on any ACA Plans.

Employee: (533287) Samuel
Concern: Why not Offers.
Cause : This employee is new hire on dated 5th June 2017 and enrollments are done after full file sent which is reflected on our shared change file.Hence this employee details are not reflected on the full file.

Employee: (318884) Gregg Tolliver
Concern: Why not offers.
Cause: This employee is already rolled out on the file as waive.

Employee: Jeff L Hamilton
Concern: During my review I have found an issue with how multiple events are being passed.
That is called out on the report. I’ve added a screenshot below of the second offers that are overwriting the open enrollment events for these employees.
Please let me know if you have any questions or concerns.
[EE has a second offer on the file with no plans listed. This second offer also has the 1/1/17 coverage start date. This is eliminating the first offer.]

Cause : This employee is terminated on 30th April 2017 and as per our earlier communication, in case of terminated employee,has been decided to show on the file as additional offer +with no plans listed+covg in this structure. June15TerminatedEmployeesExpectedCoverageTransactionSampleMail.pdf

Needed Information: So Please let us know what is expected in OFFR segment for CoverageStartDate (Terminated Transaction Segments) ?

Some randomly employee verified details..

Employee: (297477) Jonathan C Allen
Concern: Was FT from January. Why no offer of benefits prior to July?
Cause: Agree that emploee type was FT but his Benefit Program was 'M41-Minerals No Benefit' i.e. class1 prior to July & this class1 is not selected on the ACA plans.Hence he didn't get any offers prior to July.

Employee: (272029) Lisa B. Ballard
Concern: Why,?ADP shows this EE as ACA FT.
Cause: This employee belongs to "A41-Automation No Benefits" class1. This class1 benefit program is not selected on any ACA Plans.Hence he is not eligible for any ACA plans.

Thanks,
Revan

Amit Thorve Nandkumar Prabhakar Karlekar Yogesh Chaudhari Smita Pawar Sachin Hingole

Thank you Revansiddha Gaur for your feedbacks. I will forward to ADP.

Alex

Hi Alex Nguyen,

Any feedback please for above our comments shared before 2 days?

Thanks,
Revan

Amit Thorve Yogesh Chaudhari Nandkumar Prabhakar Karlekar Smita Pawar Kumar Chhajed

Hello Revansiddha Gaur,

This is regarding the 7/12/17 Full file. For those records with *Employee Data Change" event related to loss of eligibility, ADP would like for the coverage start date on the OFFR segment to match the event date. Below was their response:

The formatting is as expected, however the coverage start date should match the event date that you are passing. Using the coverage start date of 01/01/2017 tells our system that the loss of coverage began 01/01/2017.

I will review the others and meet with the team at Metso for their insight. Let me know if you have additional questions.

I haven't heard anything back from Tim at ADP yet, but I will check with him to see if he receives any feedback from the client.

As for the 8/4/17 changes files, Tamkeen at BSG has some concerns with records that wasn't flowing over correctly. Please add "Comprehensive Medical Plan - Retiree-medical-Highmark to the non employee template. You can review her full feedback/comments from 20170804 Changes file_ BSG Comments.docx. It's uploaded to our SFTP server located in /workterraaca/BSG ACA/Metso ADP File/08182017. I already responded to BSG, but also need your input so we can be on the same page in case they have further questions.

Thank you,

Alex

Hi Alex Nguyen,

We have updated manually the coverage start date with event date in OFFR segment for loss of eligibility records by referring the same Active Full file.

Please find the files on below ftp details.

SFtp Path: /workterraaca/BSG ACA/Metso ADP File/07122017
File Name: 08212017.zip

Thanks,
Revan

Amit Thorve Yogesh Chaudhari Nandkumar Prabhakar Karlekar Smita Pawar Sachin Hingole Kumar Chhajed

Hi Alex Nguyen,

Our review is in progress on change file and we will share you on tomorrow EOD.

Thanks,
Revan

Yogesh Chaudhari Nandkumar Prabhakar Karlekar Smita Pawar Sachin Hingole Kumar Chhajed

Hi Alex Nguyen,

We have uploaded the file with our comments on SFTP for change file.

SFTP path: /workterraaca/BSG ACA/Metso ADP File/08182017
File Name: Harbinger Comments on 20170804 Changes file_ BSG Comments.docx

If needed future enrollments, we need approval to change the customization of Future=Yes in case of change files only.

We are selecting the Medical Plan - Retiree-medical-Highmark on NON EE template as it was previously not present.

Thanks,
Revan

Amit Thorve Nandkumar Prabhakar Karlekar Yogesh Chaudhari Smita Pawar Sachin Hingole Kumar Chhajed

Hi All,

Subject : FW: Metso 07/12/2017 Full file and terms
Received mail : FW Metso 07 12 2017 Full file and terms.pdf
Action Points :

• New Change file after last full file.
• Full file datetimestamp
• Change file datetimestamp
• Outside date range affected records report

Thanks,
Revan

Amit ThorveYogesh Chaudhari Nandkumar Prabhakar Karlekar Kumar Chhajed Smita Pawar Sachin Hingole

Hi Smita Pawar,

Please find the attachment file for Active-Change file verification. Active_Change_01012017_08242017ForQaVerification.zip

Thanks,
Revan
Yogesh Chaudhari Nandkumar Prabhakar Karlekar

Hi Alex Nguyen,

Please find the change file details as below shared on FTP.

Folder sftp Path: /users/workterraaca/BSG ACA/Metso ADP File/08242017
File Name:
Active-Active-ChangeFile_01012017_08242017.zip
Non EE-NonEE-ChangeFile_01012017_08242017.zip
Contains: Change file & Outside date range affected records Report in excel with comments

Manually merged offer,covg elements for loss of eligibility (Active Change File).

Full File Datetime Stamp: 07/10/2017 10:29 PM PST
Change File Datetime Stamp: 08/23/2017 10:53 PM PST
Date Range: 01/01/2017 to 08/24/2017
Note: one employee analysis is pending which is mentioned in the excel file.Once analysis is done will let you know.

Thanks,
Revan
Amit Thorve Yogesh Chaudhari Nandkumar Prabhakar Karlekar Smita Pawar Sachin Hingole

Thank you Revansiddha Gaur for the updated files. I will review them to make sure the outstanding issues are cleared before providing to client and ADP for processing. We're still waiting for ADP explanation of the discrepancies in case there's still bugs in their system.

Alex

Hi Alex Nguyen,

With reference to
We analyazed this employee that why this employee is rolled out on the change file when both on full and change files having the same content which is not expected on the change file as it is already on full file.

Due to changes in enrollment after the full file.Hence the employee has been captured on the change file.

This employee Alycia's enrollment has been terminated (07/31/2017) after the full file and futher the employee is not eligible for any medical benefit plans from july onwards but termination date is not reflected on the change file because employee is in active mode.

Thanks,
Revan
Amit Thorve Yogesh Chaudhari Nandkumar Prabhakar Karlekar Smita Pawar

Hi Amit Thorve

As per our todays discussion, coveragestartdate=event date is required in offer element for only 11 employees out of 32 employee list from "Metso_Missing_Offers_08152017.xlsx" sheet1 tab for those loss of eligibility segments.

SFTP PATH: /users/workterraaca/BSG ACA/Metso ADP File/08282017

File Name:
Active-Active-ChangeFile_01012017_08242017.zip
Non EE-NonEE-ChangeFile_01012017_08242017.zip
Contains: Change file & Outside date range affected records Report in excel with comments
Those 11 employees has been merged in our latest change file using full file by modifying expected changes as coverage start date= event date.

Full File Datetime Stamp: 07/10/2017 10:29 PM PST
Full File Date Range: 01/01/2017 to 07/11/2017

Change File Datetime Stamp: 08/23/2017 10:53 PM PST
Change File Date Range: 01/01/2017 to 08/24/2017

Alex Nguyen Please discard previous change files which is shared on https://workterra.atlassian.net/browse/WT-8973?focusedCommentId=132987&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-132987

Note : Manually merged offer,covg elements for loss of eligibility (Active Change File).

Thanks,
Revan

Yogesh Chaudhari Nandkumar Prabhakar Karlekar Smita Pawar Sachin Hingole

Hello Revansiddha Gaur,

I have already checked against previous discrepancies and included my comments along side your comments on the "Metso_Missing_Offers_08152017.xlsx" and the "ChangeFile OutsideDateRange Report". All the term records reported by ADP are now showing start date matching event date. Number of OFFR segments matches COVG.

I need some clarification regarding the date range of the changes files you provided, before I advise BSG to run the add/change/term report correctly for comparison. My concern is the date range of 1/1/17 - 8/24/17 might confuse BSG. The active file only has 70 employees. When running report using date range provided, there were over 1000 unique employees (excluded cobra/retirees). This doesn't seem right, but after running report using something like 7/11/17 - 8/23/17 it came close to the number of employees on the active changes file.

Isn't the changes file date range is after the full files? The full files (7/10/2017 10:29 PM PST) already loaded into ADP system, but rejected 30+ records that were on the discrepancies report we reviewed. I thought it may be a typo, but can you confirm that the changes files are actually from 7/11/17 12:00am pst to 8/23/17 11:59pm pst or is it 7/10/2017 10:30PM pst to 8/24/17 12:00am pst? Knowing the detail range will help us determine which dates to use for running the add/change/term report.

Thank you,

Alex

Hi Alex Nguyen,

To capture the any retro changes in enrollment on change file, we always use fiscal year start date i.e. 01/01/2017. So that any changes took place before/after full file it will be reflected on the change file and only if that changes are not reported on any file.

Thanks,
Revan

Amit Thorve Nandkumar Prabhakar Karlekar Yogesh Chaudhari Smita Pawar

Hi Amit Thorve,

As per our discussion in call (08/28/2017) , Please confirm whether should we process change file again today or wait for feedback for the previous files?

Thanks,
Revan

Nandkumar Prabhakar Karlekar Yogesh Chaudhari Smita Pawar

Revansiddha Gaur Do not send any new files today.

Hi All,

Email Subject: FW: Metso ADP ACA Update
Email: ACA Change Update Email 6 Sep 2017.pdf
Comments:
Both the Active and Non-EE files looks good with the exception of 2 employee changes that I thought were missing in the files. Out of the 2 employees, 1 should have been included in the Non-EE file and another in the Active file.
Action Points:
Analysis for 2 Employees are not captured on change file.
Tyler Erhard on Active File, Teena Jones on Non EE file

Thanks,
Revan
Amit Thorve Nandkumar Prabhakar Karlekar Yogesh Chaudhari Smita Pawar Sachin Hingole Ramya Tantry Kumar Chhajed

Hi Alex Nguyen,

Please find the comments as below for 2 employees are not captured on the change file (08/23/2017 10:53 PM PST).
Tyler Erhard (Active File)
CAUSE: The employee enrollment was pending in approval status & now its changed on 09/05/2017 i.e. after last change file. So this employee will be captured on new change file.

History-

Teena Jones (Non EE File)
CAUSE: Employee is retro terminated on 12/31/2016 which is before year of current fiscal year start date and it will not fall in our date ranges rather we can capture only active enrollments in case of enrollments are before fiscal year start date. This is system limitation.Such terminated enrollments you can eliminate manually at your end.

Thanks,
Revan
Amit Thorve Nandkumar Prabhakar Karlekar Yogesh Chaudhari Smita Pawar Sachin Hingole Ramya Tantry Kumar Chhajed

Thank you Revansiddha Gaur for the detail. I'll let Metso know of this reason, so they know what to look out for during their audit. I'm still waiting on ADP response regarding "loss eligibility' events. I'll let you know when a new change file is needed, but at this time we're working through some discrepancies with them.

Alex

Hi Revansiddha Gaur,

I have talked to James at ADP. Regarding the active employee file, please update the coverage start date to match the event date for all Employee Data Change events relate to loss eligibility on the OFFR segment. As long as the coverage start date is different than the start date of first event Open Enrollment, we should be fine. If we choose not to send the coverage start date for those Employee Data Change events, ADP can default it to the event date.

As for retired employee, Teena Jones, ADP asked to send her on the none employee change file as follow in order to void her from 2017 ACA:

EEID|xxxxxxxx3|R|Teena||Jones|xxxxxxxx3|xxxxxxxx3|
ADDR|xxxxxxxx3||||2xxxx xxxxxx Ct.||Exxxx|FL|3xxxx||US
OFFR|xxxxxxxx3|01/07/1953|Employee Data Change|01/01/2017|10/15/2016 08:46:23.950000 AM|
COVG|xxxxxxxx3|676|HIGHMARK PPO 80 RETIREE||||01/01/2017|12/31/2016||||01/25/2017 09:25:58.000000 AM|

You can find her actual data on the 7/12/17 non employee full file. The x's you can replace with her actual data. Please provide time stamp of the change files and date range along with any records outside of date range on separate document. BSG will need for auditing purposes. Let me know if you need additional info from me.

Thank you,

Alex

Hi Alex Nguyen,

Ok. We will further process the change files as per above feedback that coverage start will be matched with event date in case of loss of eligibility offer record.

Thanks,
Revan
Amit Thorve Nandkumar Prabhakar Karlekar Yogesh Chaudhari Smita Pawar Sachin Hingole

Thank you Revansiddha Gaur.

CC: Van Nguyen

Hi Alex Nguyen,

Please let us know any feedback for the shared files & next change file process date.

Thanks,
Revan

CC: Amit Thorve, Nandkumar Prabhakar Karlekar, Yogesh Chaudhari, Smita Pawar

Email Subject: Not AV Scanned: [WARNING - ENCRYPTED ATTACHMENT NOT VIRUS SCANNED] METSO ADP Feedback for Change Files
Metso feedback : 09192017MetsoFeedbackOnChangeFiles_Active_NonEE.pdf
Feedback details...

I did receive and begin to validate the two files:
• EF0597B9DB0007C9_Metsoshare_BenefitsImport_20170824_141400.txt
• EF0597B9DB0007C9_Metsoshare_NonEE_20170824_184124.txt
The NonEE file passed and should load 29 participants.

However, the BenefitsImport text file failed to convert to XML.

The first problem was a Duplicate Offer in lines 6 & 29
OFFR|*****1335|06/14/1971|Employee Data Change|01/01/2017|01/01/2017|01/01/2017|12/31/2017|07/24/2017 10:24:12.237000 AM
OFFR|*****1335|06/14/1971|Employee Data Change|04/01/2017|01/01/2017|01/01/2017|12/31/2017|07/24/2017 10:24:12.237000 AM
The duplicate Offer Identifier (06/14/1971) confuses them, there are two different Offers with the same offer identifier. The first instance would get all the plans but the second instance would have no plans. Now you may say this is fine since the second “Employee Data Change” with Offer Identifier”06/14/1971” is really a loss of eligibility offer (offer with no plans). It would perhaps work if the person only had two offers with the same OfferID and the second Coverage was always a termination. But if the participant had multiple coverages, it would fail.

There is also an issue raised by the missing “TransactionDate” of the following lines, which appear to be terminations:
Invalid TransDate: COVG|*****4418|Employee Data Change|04/30/2017||||||||03/31/2017||||||||
Invalid TransDate: COVG|*****4811|Employee Data Change|02/28/2017||||||||02/28/2017||||||||
Invalid TransDate: COVG|*****8127|Employee Data Change|06/30/2017||||||||06/30/2017||||||||
Invalid TransDate: COVG|*****0189|Employee Data Change|03/31/2017||||||||03/31/2017||||||||
Invalid TransDate: COVG|*****8055|Employee Data Change|03/31/2017||||||||03/31/2017||||||||
Invalid TransDate: COVG|*****9825|Employee Data Change|03/31/2017||||||||03/31/2017||||||||
Invalid TransDate: COVG|*****2515|Employee Data Change|03/31/2017||||||||03/31/2017||||||||
Invalid TransDate: COVG|*****7934|Employee Data Change|04/30/2017||||||||04/30/2017||||||||
Invalid TransDate: COVG|*****7822|Employee Data Change|02/24/2017||||||||02/28/2017||||||||
Invalid TransDate: COVG|*****4384|Employee Data Change|03/31/2017||||||||03/31/2017||||||||
Invalid TransDate: COVG|*****1653|Employee Data Change|06/01/2017||||||||03/31/2017||||||||

For the Termination of coverage (whatever you call it) we need the Event Reason (“Employee Data Change”), Event Date, “Coverage End Date”, and “TransactionDate” (the date and time stamp in field 19 that you have left blank). The other examples you had given us seemed to have this populated. I’m not sure why it is missing here. Can you correct this?

Let me know if you have any questions about this.

I do suggest you may want to use a more distinguishing OfferID, maybe some concatenation of the person and an event or date. That would make them more unique, which is the purpose of an identifier.

Hi Alex Nguyen,

Please find the attachment file for Active Employee by fillup missing transaction date
and duplicate offer identifier issue correction for reported one employee.

3cs
Concern: Duplicate Offer Identifier-Daniel|Hayes|Gaffney
Cause: Due to manual changes
Correction: Corrected manually offer identifier as unique

Concern: For 11 Employees (loss of eligibility) transaction date missing
Cause: We merged into change file 11 employees from previous file. In this previous file transaction date wasn't considered for the loss of eligibility employees. Later we receive the feedback to consider the transaction date for LoE
but we missed to consider transaction date in our merging.
Correction: Manually set transaction date in the same file.

Ftp Folder Path: /users/workterraaca/BSG ACA/Metso ADP File/09192017/Active Employee Change File
File Name: EF0597B9DB0007C9_Metsoshare_BenefitsImport_20170824_141400.txt

Thanks,
Revan

CC: Amit Thorve, Nandkumar Prabhakar Karlekar, Yogesh Chaudhari, Smita Pawar, Sachin Hingole

Thank you Revansiddha Gaur,

We have uploaded it to ADP and now waiting for the results.

Alex

Hi Revansiddha Gaur,

ADP has successfully loaded the last files you provided. They are now ready for another change files. If the next files are successful with the load, we will discuss with ADP about scheduling the file to go weekly.

Thank you,

Alex

Great news Alex Nguyen.

Revansiddha Gaur, Yogesh Chaudhari, Smita Pawar Can we provide another change file today? From last file sent date till today.

Hello Amit Thorve

We will provide change files by tomorrow EOD.

Thanks,

Yogesh Chaudhari
Alex NguyenNandkumar Prabhakar KarlekarRevansiddha GaurSmita Pawar

Hi Alex Nguyen,

Please find the Metso changes files on ftp..

SFTP PATH: /users/workterraaca/BSG ACA/Metso ADP File/10052017
File Name:
Active-EF0597B9DB0007C9_Metsoshare_BenefitsImport_20171005_114851__.txt (Employee Count-81)
Non EE-EF0597B9DB0007C9_Metsoshare_NonEE_20171005_141735.txt (Employee Count-12)

Change File Datetime Stamp: 10/04/2017 07:45 AM PST
Change File Date Range: 01/01/2017 to 10/05/2017

Thanks,
Revan

Amit Thorve, Nandkumar Prabhakar Karlekar, Yogesh Chaudhari, Smita Pawar,Sachin Hingole

Hi Revansiddha Gaur,

ADP is reporting extra pipe at end of COVG line causing record errors and file to fail. They are asking for extra pipe to be remove. The extra pipe is found after the coverage identifier element. Also there are missing waive code and waive reason description for waive records. Results were provided below and I have also uploaded the report 20171004_ADP Results.zip by ADP to /users/workterraaca/BSG ACA/Metso ADP File/ for a better overview of the employees with the errors:

There are eighteen (18) employees who have no Offer of an EEOnly Plan: Looks like these are supposed to be “loss of eligibility” offers. If so, they should be good.

However there are five (5) employees who have a selected coverage with no coverage start date, and there should be one unless this is a termination of coverage, but it appears that at least one of the persons (Jeehye Law) has this as a Waiver of coverage and not a termination of coverage. It appears to be the case in a few waivers of coverage.

Finally there are a few people (9 or so) who seem to be waiving (have flag “Y” for waive) but do not have the Waiver Reason Code and Waiver Reason Description (06 / “unknown”).
These need to be fixed.

Below are two examples with extra pipe at the end:

COVG|xxxxxxxxx|Employee Data Change|09/15/2017||||||||09/30/2017|||||||09/15/2017 08:57:13.000000 PM||
COVG|xxxxxxxxx|New Hire Enrollment|08/14/2017||||||||||||Y|06|Unknown|08/21/2017 08:36:16.000000 AM||

Below are example of missing waiver code and waiver reason:

COVG|xxxxxxxxx|New Hire Enrollment|08/28/2017|||S|Single|||09/01/2017|||||Y|||09/11/2017 11:31:20.193000 AM|09/01/2017

COVG|xxxxxxxxx|New Hire Enrollment|09/20/2017|||S|Single|||10/01/2017|||||Y|||09/21/2017 01:36:46.840000 PM|10/01/2017

Let me know if you need additional info from me.

Thank you,

Alex

Hi Alex Nguyen,

Please find the corrected only Active File for below reasons..

1. (18) employees: Confirmed that those employees are from Loss of Eligibility criteria.
2. five (5) employees: Now populated coverage start date.
3. few people (9 or so): Now populated the details with "06|Unkown" as expected for waived="Y"
4. extra pipe at the end: Now extra pipes are removed from covg segment.

Corrected File;
Path on FTP : /users/workterraaca/BSG ACA/Metso ADP File/10052017/CorrectedOnlyActiveFile_10102017

File Name:
Active-EF0597B9DB0007C9_Metsoshare_BenefitsImport_20171005_114851__.txt (Employee Count-81)

Change File Datetime Stamp: 10/04/2017 07:45 AM PST
Change File Date Range: 01/01/2017 to 10/05/2017

Note: Corrected in the same file.

Thanks,
Revan

CC: Amit Thorve, Nandkumar Prabhakar Karlekar, Yogesh Chaudhari, Smita Pawar, Sachin Hingole

Thanks you Revansiddha Gaur,

New file was downloaded and forwarded to ADP for further review.

Alex

Hello Revansiddha Gaur,

ADP has confirmed the last change files were good and loaded successfully. They are ready to start receiving the weekly change files (employees and non employees). Please make sure recent and previous issues reported no longer show up on future files. They confirmed we can send the files weekly on Fridays at 5:00am pst. Once ADP receives the file, they would set them to the side and automatically loads them on 2nd Tuesday of each month in the order of the dates. Below was their response:

I am good with moving toward automation.

Thanks again!
Tim Fuller FPC, CHRS| Account Manager
ADP Health Care Reform
844.237.2221 ext 8172013 tollfree
AVS.Tim.Fuller@adp.com –Reply to all

Alex,

Tim you chime in as well, but that schedule sounds fine.
We will only load the files—unless we manually request a load—automatically on the second Tuesday of the month.
At that time—having received the files and placed them in the staging area—all files would load in order on that date.
Of course, if there were a need or desire to have them loaded sooner, that could be done.

But please wait for Tim’s confirmation as well.

Thanks,

James Camak
Product Support III
AVS - Health Care Reform
706-731-2319

Let me know if you need additional info from me. File naming convention remains same as what we have now. I uploaded the SFTP info again just in case you need it and is stored in the following:

Path on FTP: /users/workterraaca/BSG ACA/Metso ADP File
File Name: Metso ADP SFTP.docx

Thank you,

Alex

Yogesh Chaudhari As per our conversation today please send next change file to Alex tomorrow (Thursday).

Alex Nguyen Please load this change file after your review on ADP Server on Friday PST and inform Tim and James regarding the same. Also tell them that they will receive ongoing change file every Friday starting from this week.
Also check with Tim or James if there are any discrepancies for last 2 change only files.

Yogesh Chaudhari Please send change only ACA file to Alex every Friday going forward.

CC-Revansiddha Gaur

Sounds good Amit Thorve. I will review tomorrow ACA files then post to ADP server on Friday for loading. I was under the impression the last change files were loaded, but they only put in a request on 10/16 to load and we were advised the file looks good. After that they said they were ready for automation or receive file weekly. From today email, they mention the last active employee file loaded was from June and Non EE loaded was from July. According to their process, they set files to the side (staging area) and load on 2nd Tuesday of each month. But can be loaded right away if we request them to.

From the email today from James, they had to put in another request for the load. We should get results from them hopefully today or tomorrow.

Thanks,

Alex

Hi Alex Nguyen,

Please find the change files for Active & Non EE on ftp..

Ftp Path: /users/workterraaca/BSG ACA/Metso ADP File/10262017
Change File Date Time Stamp: 10/25/2017 08:33 PM PST
Change File Date Range: 01/01/2017 to 10/26/2017

Thanks,
Revan

CC- Amit Thorve, Nandkumar Prabhakar Karlekar, Yogesh Chaudhari, Smita Pawar, Yogita Bhadane, Sachin Hingole

Thanks Revansiddha Gaur, I will review the files later today.

Alex

Good morning Revansiddha Gaur,

ADP confirmed the data all look good on the recent change files. There is a minor problem with the file naming convention for the benefitsimport file. The non employee file name is fine. There was a double underscores for file EF0597B9DB0007C9_Metsoshare_BenefitsImport_20171026_200620__.txt

ADP said to make sure future files don't have this double underscores in order for the automation to work. They had to remove it manually for the files to load. Future files should look like this without the double underscores EF0597B9DB0007C9_Metsoshare_BenefitsImport_20171026_200620.txt.

I have already informed them that we will start scheduling the file to run weekly Fridays at 5:00am pst starting on 11/3/17. Please let me know once files are scheduled.

Thank you,

Alex

Hi Alex Nguyen,

We are processing the file delivery manually on tomorrow (Thursday).

Thanks,
Revan

CC- Amit Thorve, Nandkumar Prabhakar Karlekar, Yogesh Chaudhari, Smita Pawar, Sachin Hingole

Hi Alex Nguyen,

Please find the change files for Active on ftp..

Ftp Path: /users/workterraaca/BSG ACA/Metso ADP File/11022017
Change File Date Time Stamp: 11/01/2017 09:15 PM PST
Change File Date Range: 01/01/2017 to 11/02/2017

Non EE: Zero records found.

Thanks,
Revan
CC-Amit Thorve, Nandkumar Prabhakar Karlekar, Yogesh Chaudhari, Smita Pawar, Sachin Hingole

Hi Revansiddha Gaur,

Can you also provide me the non employee aca file? I only received the active employee file.

Thanks,

Alex

Hi Alex,

None of the employees found for Non EE file for this week.

Thanks,
Revan

Thank you Revansiddha Gaur. I have done the quick audit and file was posted to ADP server.

Alex

Hi Alex Nguyen,

Please find the change files for Active and Non EE.

Files: 9Nov_Metso_Weekly_Change_File_Active_NonEE.zip
Change File Date Time Stamp: 11/08/2017 09:27 PM PST
Change File Date Range: 01/01/2017 to 11/09/2017

Note: Due to ftp is not able to login, giving an error of Network timeout, sending those files in the JIRA. Once ftp is able to access, same files will be uploaded on ftp & will share you the path.

Password mailed.

Thanks,
Revan
CC- Amit Thorve, Nandkumar Prabhakar Karlekar, Yogesh Chaudhari, Smita Pawar, Sachin Hingole

Hi Alex Nguyen

Yesterday's same files are uploaded on FTP..

FTP Path: /users/workterraaca/BSG ACA/Metso ADP File/11092017

Thanks,
Revan
CC- Amit Thorve, Nandkumar Prabhakar Karlekar, Yogesh Chaudhari, Smita Pawar, Sachin Hingole

Thank you Revansiddha Gaur for providing the change files. I have finished auditing and will post them to ADP server.

Alex

Hi Smita Pawar,

Reference: https://workterra.atlassian.net/browse/WT-8973?focusedCommentId=148260&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-148260

As per comment mentioned, please change the customization to prevent "__" (double underscore) on main production company.

Thanks,
Revan

CC- Yogesh Chaudhari, Nandkumar Prabhakar Karlekar, Sachin Hingole, Rakesh Roy

Hi Alex Nguyen

Please find the change files for Active

Ftp Path: /users/workterraaca/BSG ACA/Metso ADP File/11162017
Change File Date Time Stamp: 11/15/2017 08:35 PM PST
Change File Date Range: 01/01/2017 to 11/16/2017

No change records found for Non Employee File.

Thanks,
Revan

CC- Amit Thorve,Nandkumar Prabhakar Karlekar, Yogesh Chaudhari, Smita Pawar, Sachin Hingole

Thank you Revansiddha Gaur. I am doing a quick audit on it now and before posting.

Alex

Hi Alex Nguyen,

Please find the change files for Active
Ftp Path: /users/workterraaca/BSG ACA/Metso ADP File/11232017
Change File Date Time Stamp: 11/22/2017 08:05 PM PST
Change File Date Range: 01/01/2017 to 11/23/2017
No change records found for Non Employee File.

Thanks,
Revan

CC- Amit Thorve,Nandkumar Prabhakar Karlekar, Yogesh Chaudhari, Smita Pawar, Sachin Hingole

Hi Revansiddha Gaur,

File has been reviewed and uploaded to ADP SFTP server successfully. I also stored the connectivity log and file in shared drive as proof of success.

Y:\1.CLIENT\BSG\Metso\5. EDI\Structure_Specs\ADP - ACA\Production Files\Nov 24 2017

Thank you,

Alex

Hi Alex Nguyen ,

Please find the change file for Employee on the below mentioned path
FTP Path /users/workterraaca/BSG ACA/Metso ADP File/11302017
Change File Date Range - 01/01/2017 to 30/11/2017

No Change records found for Non Employee File

Thanks ,
Kanchan Jalgonkar

CC-Amit Thorve Nandkumar Prabhakar Karlekar Yogesh Chaudhari Smita Pawar Sachin Hingole Prajakta Belhe

Hi Alex Nguyen,

Please note that above generated files from directly production company as we have deployed Metso related change requests.

Thanks,
Revan
CC- Amit Thorve, Nandkumar Prabhakar Karlekar, Yogesh Chaudhari, Smita Pawar, Sachin Hingole, Prajakta Belhe

Thank you Revansiddha Gaur. I already did a quick audit and posted the 11/30 file to ADP server. They will sweep up the file and set to the side before loading on 2nd Tuesday of this month (12/12/17).

Thank you,

Alex

Hi Alex Nguyen ,

We have exported the file for Employee and Non- Employee from main company . Testing is in progress at our end , if you want you can refer the latest file from view exported files .
We will provide the file by tomorrow.

Environment - Production

Thanks,
Kanchan Jalgaonkar.

CC-Prajakta Belhe Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar Revansiddha Gaur Amit Thorve Yogesh Chaudhari

Hi Alex Nguyen,

You can post the latest file from view exported files to ADP server.

Thanks,
Prajakta

CC-Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar Revansiddha Gaur Amit Thorve Yogesh Chaudhari

Hi Alex Nguyen,

As discussed with Amit, Can you please further process the files on weekly basis for "Metso ADP - ACA Employee", "Metso ADP - ACA Non Employee"?
Steps:
1. Select the target Template.
2. From & To Date should be blank.
3. Export.

Thanks,
Revan
CC- Amit Thorve, Nandkumar Prabhakar Karlekar, Smita Pawar, Sachin Hingole.

Thank you Prajakta Belhe and Revansiddha Gaur. I have posted today's file to ADP and informed them that we will stop sending files after 12/29/17. I will pull the files weekly according to your 3 steps. Thank you for all the support with the ACA files.

Alex