-
Type:
Support Activity
-
Status: Closed
-
Priority:
High
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Support Task Type:ACA Data Audit
-
Environment:Production
-
Reported by:Support
-
Company:Metso Benefits
-
Module:ACA
-
Issue Importance:Must Have
-
Severity:Simple
12/30/17 - There's no changes for non employee file. Only file with records is the active employee file. File was sent successfully:
14:05:32 Status: Connecting to sdgcl.adp.com...
14:05:34 Status: Connected to sdgcl.adp.com
14:05:34 Status: Starting upload of C:\Users\angu\Desktop\EF0597B9DB0007C9_Metsoshare_BenefitsImport_20171230_135805.txt
14:05:34 Status: File transfer successful, transferred 2,428 bytes in 1 second
14:05:35 Status: Retrieving directory listing of "/home/METS3psftpHC/INBOUND"...
14:05:35 Status: Listing directory /home/METS3psftpHC/INBOUND
14:05:35 Status: Directory listing of "/home/METS3psftpHC/INBOUND" successful
Closing JIRA as this is the last ACA file of the year.
12/29/17 - Last ACA change files will send tonight. ADP is aware the file will be coming and is the last they will receive for 2017.
Hello Smita Pawar,
New ticket being opened for issue related to previous ticket # EDI-1042. I couldn't reopen the original ticket, so I'm opening a new one to report some records not coming over on the Jan 2017 ACA files. The client has completed the audit, but found a lot of missing records. Looking at some of the dependents in WT, I did saw them enrolled in HIGHMARK PPO 90-Medical-Highmark but wasn't on the file. I have uploaded client's audit file Metso ACA file audit.xlsx and their comments Audit of January 2017 Metso ACA file.msg to the EBS ftp server located in /workterraaca/BSG ACA/Metso ADP/ .
I've checked the template Metso ADP - ACA Employee but it does show the plan selected along with their classes. Can you review the audit file and client comments, and also take another look at the settings on the three templates?
Metso ADP - ACA Employee
Metso ADP - ACA Non Employee
Metso ADP - ACA Multiemployer
I've tried deleting march run dates from template *Metso ADP - ACA Employee and exported again to see if the records would show up on the file, but they didn't. Those run dates have been added back in the way it was.
Thank you,
Alex
Carrier contact:
James Camak
Product Support III
AVS - Health Care Reform
706-731-2319
Tim Fuller FPC, CHRS| Account Manager
ADP Health Care Reform
844.237.2221 ext 8172013 tollfree
Tim.Fuller@adp.com
HCRaccountmanager37@adp.com
- relates to
-
WT-11177 ACA: Metso | For Loss of Eligibility employees coverage start should be match with event date in offr segement
-
- Closed
-
| Field | Original Value | New Value |
|---|---|---|
| Description |
Hello [~smita.pawar], New ticket being opened for issue related to previous ticket # EDI-1042. I couldn't reopen the original ticket, so I'm opening a new one to report some records not coming over on the Jan 2017 ACA files. The client has completed the audit, but found a lot of missing records. Looking at some of the dependents in WT, I did saw them enrolled in *HIGHMARK PPO 90-Medical-Highmark* but wasn't on the file. I have uploaded client's audit file *Metso ACA file audit.xlsx* and their comments *Audit of January 2017 Metso ACA file.msg* to the EBS ftp server located in /workterraaca/BSG ACA/Metso ADP/ . I've checked the template *Metso ADP - ACA Employee* but it does show the plan selected along with their classes. Can you review the audit file client I uploaded and take another look at the settings on the three templates? *Metso ADP - ACA Employee Metso ADP - ACA Non Employee Metso ADP - ACA Multiemployer* I've tried deleting march run dates from template **Metso ADP - ACA Employee* and exported again to see if the records would show up on the file, but they didn't. I already added those run dates back in the way it was. Thank you, Alex |
Hello [~smita.pawar], New ticket being opened for issue related to previous ticket # EDI-1042. I couldn't reopen the original ticket, so I'm opening a new one to report some records not coming over on the Jan 2017 ACA files. The client has completed the audit, but found a lot of missing records. Looking at some of the dependents in WT, I did saw them enrolled in *HIGHMARK PPO 90-Medical-Highmark* but wasn't on the file. I have uploaded client's audit file *Metso ACA file audit.xlsx* and their comments *Audit of January 2017 Metso ACA file.msg* to the EBS ftp server located in /workterraaca/BSG ACA/Metso ADP/ . I've checked the template *Metso ADP - ACA Employee* but it does show the plan selected along with their classes. Can you review the audit file and client comments, and also take another look at the settings on the three templates? *Metso ADP - ACA Employee* *Metso ADP - ACA Non Employee* *Metso ADP - ACA Multiemployer* I've tried deleting march run dates from template **Metso ADP - ACA Employee* and exported again to see if the records would show up on the file, but they didn't. Those run dates have been added back in the way it was. Thank you, Alex |
| Module | Parent values: BenAdmin(10100)Level 1 values: Export(10110) | Parent values: ACA(10104) |
| Attachment | Mail.pdf [ 43229 ] |
Hi Alex Nguyen,
Can you please provide password for same again.
Thanks,
Smita
FYI Nandkumar Prabhakar Karlekar,Revansiddha Gaur,Sachin Hingole,Revansiddha Gaur
Smita Pawar (Inactive)
added a comment - Hi Alex Nguyen ,
Can you please provide password for same again.
Thanks,
Smita
FYI Nandkumar Prabhakar Karlekar , Revansiddha Gaur , Sachin Hingole , Revansiddha Gaur Smita Pawar (Inactive)
logged work - 27/Mar/17 01:45 PM -
- Time Spent:
- 2.5h
-
Analysis
File exporting
Updating Jira
Email communication
Smita Pawar (Inactive)
made changes -
| Remaining Estimate | 24h [ 86400 ] | |
| Original Estimate | 24h [ 86400 ] |
Smita Pawar (Inactive)
made changes -
| Remaining Estimate | 24h [ 86400 ] | 21.5h [ 77400 ] |
| Time Spent | 2.5h [ 9000 ] | |
| Worklog Id | 34021 [ 34021 ] |
-
- Time Spent:
- 1.5h
-
Go through the comments & files.
| Remaining Estimate | 21.5h [ 77400 ] | 20h [ 72000 ] |
| Time Spent | 2.5h [ 9000 ] | 4h [ 14400 ] |
| Worklog Id | 34185 [ 34185 ] |
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
Smita Pawar (Inactive)
added a comment - 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 Smita Pawar (Inactive)
made changes -
| Assignee | Smita Pawar [ smita.pawar ] | Revansiddha Gaur [ revansiddha.gaur ] |
Smita Pawar (Inactive)
logged work - 29/Mar/17 01:44 PM -
- Time Spent:
- 3h
-
Analysis
Internal discussion
Draft
Jira updates
Smita Pawar (Inactive)
made changes -
| Remaining Estimate | 20h [ 72000 ] | 17h [ 61200 ] |
| Time Spent | 4h [ 14400 ] | 7h [ 25200 ] |
| Worklog Id | 34446 [ 34446 ] |
| Remaining Estimate | 17h [ 61200 ] | 16h [ 57600 ] |
| Time Spent | 7h [ 25200 ] | 8h [ 28800 ] |
| Worklog Id | 34904 [ 34904 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
Hi Alex Nguyen,
We are working on the same. We will give you the file on or before 6th April.
Thanks,
Revan
-
- Time Spent:
- 8h
-
Analysis with hspl copy.
| Remaining Estimate | 16h [ 57600 ] | 8h [ 28800 ] |
| Time Spent | 8h [ 28800 ] | 16h [ 57600 ] |
| Worklog Id | 35673 [ 35673 ] |
| Link | This issue relates to EDI-1042 [ EDI-1042 ] |
-
- Time Spent:
- 1h
-
Working on BSG's feedback issues.
| Remaining Estimate | 8h [ 28800 ] | 7h [ 25200 ] |
| Time Spent | 16h [ 57600 ] | 17h [ 61200 ] |
| Worklog Id | 35873 [ 35873 ] |
-
- Time Spent:
- 7h
-
Discussion with Amit
File Testing from hspl copy.
| Remaining Estimate | 7h [ 25200 ] | 0h [ 0 ] |
| Time Spent | 17h [ 61200 ] | 24h [ 86400 ] |
| Worklog Id | 36073 [ 36073 ] |
-
- Time Spent:
- 2h
-
Discussion with Amit.
Scenario testing for Jan full file.
Smita Pawar (Inactive)
made changes -
| Time Spent | 24h [ 86400 ] | 25h [ 90000 ] |
| Worklog Id | 36078 [ 36078 ] |
-
- Time Spent:
- 7.5h
-
Internal discussion with Amit
Waive employee testing.
| Time Spent | 25h [ 90000 ] | 32.5h [ 117000 ] |
| Worklog Id | 36394 [ 36394 ] |
| Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Smita Pawar [ smita.pawar ] |
Smita Pawar (Inactive)
logged work - 06/Apr/17 02:26 PM -
- Time Spent:
- 8.25h
-
Analysis
Internal discussion
Testing Draft
Call with Amit
Jira updates
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
Smita Pawar (Inactive)
added a comment - 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 Smita Pawar (Inactive)
made changes -
| Time Spent | 32.5h [ 117000 ] | 40.75h [ 146700 ] |
| Worklog Id | 36679 [ 36679 ] |
-
- Time Spent:
- 4.5h
-
Discussion,Correction the entries.
| Time Spent | 40.75h [ 146700 ] | 45.25h [ 162900 ] |
| Worklog Id | 36722 [ 36722 ] |
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
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.
-
- Time Spent:
- 5h
- <No comment>
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 (Inactive)
logged work - 09/Apr/17 10:41 AM -
- Time Spent:
- 7h
-
Testing metso files from production
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
Smita Pawar (Inactive)
added a comment - - edited 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 Smita Pawar (Inactive)
made changes -
| Time Spent | 45.25h [ 162900 ] | 53.25h [ 191700 ] |
| Worklog Id | 37002 [ 37002 ] |
Smita Pawar (Inactive)
made changes -
| Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
Smita Pawar (Inactive)
made changes -
| Assignee | Smita Pawar [ smita.pawar ] | Alex Nguyen [ alexn ] |
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
| Time Spent | 53.25h [ 191700 ] | 60.25h [ 216900 ] |
| Worklog Id | 37030 [ 37030 ] |
| Time Spent | 60.25h [ 216900 ] | 71.25h [ 256500 ] |
| Worklog Id | 37037 [ 37037 ] |
| Time Spent | 71.25h [ 256500 ] | 76.25h [ 274500 ] |
| Worklog Id | 37038 [ 37038 ] |
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
| Assignee | Alex Nguyen [ alexn ] | Smita Pawar [ smita.pawar ] |
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
Smita Pawar (Inactive)
added a comment - - edited 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 Smita Pawar (Inactive)
made changes -
| Assignee | Smita Pawar [ smita.pawar ] | Alex Nguyen [ alexn ] |
| Time Spent | 76.25h [ 274500 ] | 78.75h [ 283500 ] |
| Worklog Id | 37585 [ 37585 ] |
-
- Time Spent:
- 2.5h
-
Replied to mail by analysis the points.
Smita Pawar (Inactive)
logged work - 12/Apr/17 03:56 AM -
- Time Spent:
- 6h
-
Call preparation
File testing
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
-
- Time Spent:
- 4h
-
- Client Call
- Document verfication of client issue reported.
| Time Spent | 78.75h [ 283500 ] | 82.75h [ 297900 ] |
| Worklog Id | 37931 [ 37931 ] |
-
- Time Spent:
- 2h
-
Eligibility Loss Fix for 3 employees & KT to Mahendra for testing.
| Time Spent | 82.75h [ 297900 ] | 84.75h [ 305100 ] |
| Worklog Id | 38127 [ 38127 ] |
| Attachment | Eligibility Loss Correction Approval Email.pdf [ 45466 ] |
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
-
- Time Spent:
- 6h
-
Internal discussion,new requirement code change,file testing,K.T. to QA.
-
- Time Spent:
- 6h
-
File testing for Jan , Feb and March
| Time Spent | 84.75h [ 305100 ] | 90.75h [ 326700 ] |
| Worklog Id | 38534 [ 38534 ] |
| Time Spent | 90.75h [ 326700 ] | 95.75h [ 344700 ] |
| Worklog Id | 38637 [ 38637 ] |
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
Smita Pawar (Inactive)
added a comment - - edited 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 | Attachment | aca.png [ 45624 ] |
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
| Assignee | Alex Nguyen [ alexn ] | Smita Pawar [ smita.pawar ] |
| Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
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
| Time Spent | 95.75h [ 344700 ] | 97.75h [ 351900 ] |
| Worklog Id | 39170 [ 39170 ] |
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
Smita Pawar (Inactive)
added a comment - 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 Smita Pawar (Inactive)
made changes -
| Assignee | Smita Pawar [ smita.pawar ] | Alex Nguyen [ alexn ] |
-
- Time Spent:
- 2h
-
Internal discussion for waiver reason code 06 description blank, Review files after uploading.
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
-
- Time Spent:
- 6h
- <No comment>
| Time Spent | 97.75h [ 351900 ] | 99.75h [ 359100 ] |
| Worklog Id | 39535 [ 39535 ] |
-
- Time Spent:
- 2h
-
call with amit
| Time Spent | 99.75h [ 359100 ] | 101.75h [ 366300 ] |
| Worklog Id | 39757 [ 39757 ] |
| Time Spent | 101.75h [ 366300 ] | 105.75h [ 380700 ] |
| Worklog Id | 39758 [ 39758 ] |
Hi Alex Nguyen,
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
| Time Spent | 105.75h [ 380700 ] | 111.75h [ 402300 ] |
| Worklog Id | 39787 [ 39787 ] |
-
- Time Spent:
- 7h
-
File testing for Jan,Feb and March
-
- Time Spent:
- 6h
- <No comment>
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
-
- Time Spent:
- 4h
-
late night-file delivery Jan months from main company-Active,NonEE,MultiEmployer.
-
- Time Spent:
- 11h
-
Metso Changes files Delivery.
Active,NonEE,MultiEmployer- Feb,March.
| Time Spent | 111.75h [ 402300 ] | 122.75h [ 441900 ] |
| Worklog Id | 40257 [ 40257 ] |
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
| Time Spent | 122.75h [ 441900 ] | 128.75h [ 463500 ] |
| Worklog Id | 41716 [ 41716 ] |
| Time Spent | 128.75h [ 463500 ] | 134.75h [ 485100 ] |
| Worklog Id | 41835 [ 41835 ] |
| Time Spent | 134.75h [ 485100 ] | 136.75h [ 492300 ] |
| Worklog Id | 41836 [ 41836 ] |
| Time Spent | 136.75h [ 492300 ] | 142.75h [ 513900 ] |
| Worklog Id | 41837 [ 41837 ] |
| Time Spent | 142.75h [ 513900 ] | 149.75h [ 539100 ] |
| Worklog Id | 41914 [ 41914 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 149.75h [ 539100 ] | 156.75h [ 564300 ] |
| Worklog Id | 42161 [ 42161 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 156.75h [ 564300 ] | 160.75h [ 578700 ] |
| Worklog Id | 42225 [ 42225 ] |
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
Smita Pawar (Inactive)
added a comment - 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 Smita Pawar (Inactive)
logged work - 28/Apr/17 02:37 PM -
- Time Spent:
- 5h
-
File downloading
Customization verification
File testing
Internal discussion
Jira updates
Draft
Smita Pawar (Inactive)
made changes -
| Time Spent | 160.75h [ 578700 ] | 165.75h [ 596700 ] |
| Worklog Id | 42487 [ 42487 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 165.75h [ 596700 ] | 166.75h [ 600300 ] |
| Worklog Id | 36078 [ 36078 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 166.75h [ 600300 ] | 167.75h [ 603900 ] |
| Worklog Id | 42225 [ 42225 ] |
Thank you Smita Pawar. I have forwarded them to the client for audting.
Alex
-
- Time Spent:
- 6h
-
Metso File verification & call
Smita Pawar (Inactive)
made changes -
| Time Spent | 167.75h [ 603900 ] | 173.75h [ 625500 ] |
| Worklog Id | 42616 [ 42616 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 173.75h [ 625500 ] | 177.75h [ 639900 ] |
| Worklog Id | 42618 [ 42618 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 177.75h [ 639900 ] | 183.75h [ 661500 ] |
| Worklog Id | 42622 [ 42622 ] |
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
Smita Pawar (Inactive)
added a comment - 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
Smita Pawar (Inactive)
added a comment - - edited 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
Smita Pawar (Inactive)
logged work - 03/May/17 02:02 PM -
- Time Spent:
- 1.5h
-
File changes
Email communication
Draft preparation
Jira update
Smita Pawar (Inactive)
made changes -
| Time Spent | 183.75h [ 661500 ] | 185.25h [ 666900 ] |
| Worklog Id | 42978 [ 42978 ] |
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
| Attachment | ADP-Health-Compliance-Benefits-Import-Pipe-Delimited-3.0.pdf [ 47799 ] | |
| Attachment | ADP-Health-Compliance-Non-Employee-Import-3.0.pdf [ 47800 ] |
-
- Time Spent:
- 5h
- <No comment>
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
Smita Pawar (Inactive)
added a comment - 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 Smita Pawar (Inactive)
made changes -
| Time Spent | 185.25h [ 666900 ] | 191.25h [ 688500 ] |
| Worklog Id | 45313 [ 45313 ] |
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
-
- Time Spent:
- 8h
- <No comment>
| Time Spent | 191.25h [ 688500 ] | 192.25h [ 692100 ] |
| Worklog Id | 45542 [ 45542 ] |
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
Smita Pawar (Inactive)
added a comment - - edited 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
| Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
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
-
- Time Spent:
- 7h
- <No comment>
-
- Time Spent:
- 5h
- <No comment>
| Time Spent | 192.25h [ 692100 ] | 199.25h [ 717300 ] |
| Worklog Id | 46471 [ 46471 ] |
| Attachment | Metso employee file.docx [ 48448 ] |
| Time Spent | 199.25h [ 717300 ] | 204.25h [ 735300 ] |
| Worklog Id | 46475 [ 46475 ] |
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
-
- Time Spent:
- 6h
-
Worked on client points & reply.
-
- Time Spent:
- 7h
- <No comment>
-
- Time Spent:
- 7h
- <No comment>
| Time Spent | 204.25h [ 735300 ] | 210.25h [ 756900 ] |
| Worklog Id | 46586 [ 46586 ] |
Smita Pawar (Inactive)
logged work - 18/May/17 01:31 PM -
- Time Spent:
- 6.25h
-
Email communication.
Jira updates
Customization
File verification
Smita Pawar (Inactive)
made changes -
| Time Spent | 210.25h [ 756900 ] | 216.5h [ 779400 ] |
| Worklog Id | 46790 [ 46790 ] |
-
- Time Spent:
- 5.5h
-
Metso files verification.
-
- Time Spent:
- 6h
- <No comment>
| Time Spent | 216.5h [ 779400 ] | 223.5h [ 804600 ] |
| Worklog Id | 46941 [ 46941 ] |
| Time Spent | 223.5h [ 804600 ] | 231h [ 831600 ] |
| Worklog Id | 46951 [ 46951 ] |
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
Smita Pawar (Inactive)
added a comment - 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 Gaur Rakesh Roy -
- Time Spent:
- 7.5h
-
Email communication
Full File testing
Task allocation
Internal discussion
Jira updates
File uploading
Smita Pawar (Inactive)
made changes -
| Time Spent | 231h [ 831600 ] | 238h [ 856800 ] |
| Worklog Id | 47283 [ 47283 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 238h [ 856800 ] | 238.5h [ 858600 ] |
| Worklog Id | 47283 [ 47283 ] |
-
- Time Spent:
- 7h
- <No comment>
| Time Spent | 238.5h [ 858600 ] | 244h [ 878400 ] |
| Worklog Id | 47435 [ 47435 ] |
-
- Time Spent:
- 4h
-
ACA Metso - Employee Full Files testing - 4 hr
| Time Spent | 244h [ 878400 ] | 248h [ 892800 ] |
| Worklog Id | 47671 [ 47671 ] |
Smita Pawar (Inactive)
logged work - 22/May/17 02:04 PM -
- Time Spent:
- 7h
-
Check list preparation
Task distribution
File testing
Sending files to client
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
Smita Pawar (Inactive)
added a comment - 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 Smita Pawar (Inactive)
made changes -
| Time Spent | 248h [ 892800 ] | 255h [ 918000 ] |
| Worklog Id | 47790 [ 47790 ] |
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
-
- Time Spent:
- 6h
- <No comment>
| Time Spent | 255h [ 918000 ] | 259h [ 932400 ] |
| Worklog Id | 47872 [ 47872 ] |
| Time Spent | 259h [ 932400 ] | 260h [ 936000 ] |
| Worklog Id | 47886 [ 47886 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 260h [ 936000 ] | 261h [ 939600 ] |
| Worklog Id | 47887 [ 47887 ] |
-
- Time Spent:
- 1h
-
Internal discussion with Amit
-
- Time Spent:
- 6h
- <No comment>
| Time Spent | 261h [ 939600 ] | 262.5h [ 945000 ] |
| Worklog Id | 48153 [ 48153 ] |
Smita Pawar (Inactive)
logged work - 24/May/17 06:41 AM -
- Time Spent:
- 1h
-
Internal discussion with Amit
| Time Spent | 262.5h [ 945000 ] | 266.5h [ 959400 ] |
| Worklog Id | 48384 [ 48384 ] |
| Time Spent | 266.5h [ 959400 ] | 268.5h [ 966600 ] |
| Worklog Id | 48398 [ 48398 ] |
-
- Time Spent:
- 5h
-
ACA Employee and Non employee Jan - May files merging
Testing
Discussion with Revan and Yogita
-
- Time Spent:
- 5h
-
ACA Employee and Non employee Jan - May files merging
Testing.
-
- Time Spent:
- 8h
-
Meeting with Amit.
Working on client requirement.
-
- Time Spent:
- 6h
- <No comment>
| Time Spent | 268.5h [ 966600 ] | 276.5h [ 995400 ] |
| Worklog Id | 48566 [ 48566 ] |
| Time Spent | 276.5h [ 995400 ] | 282.5h [ 1017000 ] |
| Worklog Id | 48717 [ 48717 ] |
| Time Spent | 282.5h [ 1017000 ] | 288.5h [ 1038600 ] |
| Worklog Id | 48718 [ 48718 ] |
| Time Spent | 288.5h [ 1038600 ] | 294.5h [ 1060200 ] |
| Worklog Id | 48720 [ 48720 ] |
| Time Spent | 294.5h [ 1060200 ] | 300.5h [ 1081800 ] |
| Worklog Id | 48721 [ 48721 ] |
| Time Spent | 300.5h [ 1081800 ] | 307.5h [ 1107000 ] |
| Worklog Id | 48723 [ 48723 ] |
| Time Spent | 307.5h [ 1107000 ] | 313.5h [ 1128600 ] |
| Worklog Id | 48725 [ 48725 ] |
| Time Spent | 313.5h [ 1128600 ] | 320.5h [ 1153800 ] |
| Worklog Id | 48726 [ 48726 ] |
| Time Spent | 320.5h [ 1153800 ] | 327.5h [ 1179000 ] |
| Worklog Id | 48729 [ 48729 ] |
| Time Spent | 327.5h [ 1179000 ] | 332.5h [ 1197000 ] |
| Worklog Id | 48890 [ 48890 ] |
Smita Pawar (Inactive)
logged work - 25/May/17 02:59 PM -
- Time Spent:
- 8h
-
internal discussion
File testing
Customization
Email communication
Smita Pawar (Inactive)
made changes -
| Time Spent | 332.5h [ 1197000 ] | 340.5h [ 1225800 ] |
| Worklog Id | 48998 [ 48998 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 340.5h [ 1225800 ] | 348.5h [ 1254600 ] |
| Worklog Id | 49002 [ 49002 ] |
-
- Time Spent:
- 15h
-
Metso as per new requirement , implementation for 5 months files,testing, file delivery.
-
- Time Spent:
- 6h
- <No comment>
-
- Time Spent:
- 6h
- <No comment>
| Time Spent | 348.5h [ 1254600 ] | 363.5h [ 1308600 ] |
| Worklog Id | 49030 [ 49030 ] |
| Time Spent | 363.5h [ 1308600 ] | 368.5h [ 1326600 ] |
| Worklog Id | 49031 [ 49031 ] |
| Time Spent | 368.5h [ 1326600 ] | 369.5h [ 1330200 ] |
| Worklog Id | 49037 [ 49037 ] |
| Time Spent | 369.5h [ 1330200 ] | 374.5h [ 1348200 ] |
| Worklog Id | 49046 [ 49046 ] |
| Time Spent | 374.5h [ 1348200 ] | 377.5h [ 1359000 ] |
| Worklog Id | 49049 [ 49049 ] |
| Time Spent | 377.5h [ 1359000 ] | 385.5h [ 1387800 ] |
| Worklog Id | 49050 [ 49050 ] |
| Time Spent | 385.5h [ 1387800 ] | 391.5h [ 1409400 ] |
| Worklog Id | 49059 [ 49059 ] |
| Time Spent | 391.5h [ 1409400 ] | 393.5h [ 1416600 ] |
| Worklog Id | 49069 [ 49069 ] |
-
- Time Spent:
- 6h
-
Metso ACA testing - Employee file
-
- Time Spent:
- 4h
-
Non-employee file testing
Smita Pawar (Inactive)
logged work - 26/May/17 01:51 PM -
- Time Spent:
- 8h 10m
-
Testing and file delivery
Smita Pawar (Inactive)
made changes -
| Time Spent | 393.5h [ 1416600 ] | 401h 40m [ 1446000 ] |
| Worklog Id | 49447 [ 49447 ] |
-
- Time Spent:
- 7.5h
-
Testing metso employee file.
-
- Time Spent:
- 4h
-
Non EE file generation & testing.
-
- Time Spent:
- 5h
- <No comment>
-
- Time Spent:
- 2h
-
Metso non employeefile customization checking
Kanchan Jalgaonkar (Inactive)
logged work - 29/May/17 11:57 AM -
- Time Spent:
- 2.5h
-
Metso employee file testing
-
- Time Spent:
- 5h
-
Non-employee file testing
-
- Time Spent:
- 5h
-
Employee file testing - eligibility and coverage records verification
-
- Time Spent:
- 2.5h
-
Metso employee file testing.
-
- Time Spent:
- 8h
-
Working on Metso new requirement
Internal discussion with Amit.
-
- Time Spent:
- 8h
- <No comment>
| Time Spent | 401h 40m [ 1446000 ] | 405h 40m [ 1460400 ] |
| Worklog Id | 50012 [ 50012 ] |
| Time Spent | 405h 40m [ 1460400 ] | 413h 40m [ 1489200 ] |
| Worklog Id | 50020 [ 50020 ] |
Smita Pawar (Inactive)
logged work - 30/May/17 05:19 AM -
- Time Spent:
- 7.5h
-
active employee file testing.
Discussion with Amit
Customization changes on main company.
Smita Pawar (Inactive)
made changes -
| Time Spent | 413h 40m [ 1489200 ] | 421h 10m [ 1516200 ] |
| Worklog Id | 50027 [ 50027 ] |
| Time Spent | 421h 10m [ 1516200 ] | 428h 40m [ 1543200 ] |
| Worklog Id | 50028 [ 50028 ] |
| Time Spent | 428h 40m [ 1543200 ] | 431h 10m [ 1552200 ] |
| Worklog Id | 50029 [ 50029 ] |
| Time Spent | 431h 10m [ 1552200 ] | 436h 10m [ 1570200 ] |
| Worklog Id | 50210 [ 50210 ] |
| Time Spent | 436h 10m [ 1570200 ] | 444h 10m [ 1599000 ] |
| Worklog Id | 50212 [ 50212 ] |
| Time Spent | 444h 10m [ 1599000 ] | 448h 10m [ 1613400 ] |
| Worklog Id | 50214 [ 50214 ] |
| Time Spent | 448h 10m [ 1613400 ] | 455h 10m [ 1638600 ] |
| Worklog Id | 50330 [ 50330 ] |
| Remaining Estimate | 0h [ 0 ] | 1h [ 3600 ] |
| Time Spent | 455h 10m [ 1638600 ] | 454h 10m [ 1635000 ] |
| Worklog Id | 50330 [ 50330 ] |
Smita Pawar (Inactive)
made changes -
| Remaining Estimate | 1h [ 3600 ] | 0h [ 0 ] |
| Time Spent | 454h 10m [ 1635000 ] | 456h 10m [ 1642200 ] |
| Worklog Id | 50341 [ 50341 ] |
Kanchan Jalgaonkar (Inactive)
made changes -
| Time Spent | 456h 10m [ 1642200 ] | 458h 40m [ 1651200 ] |
| Worklog Id | 50394 [ 50394 ] |
| Time Spent | 458h 40m [ 1651200 ] | 462h 40m [ 1665600 ] |
| Worklog Id | 50409 [ 50409 ] |
| Time Spent | 462h 40m [ 1665600 ] | 467h 40m [ 1683600 ] |
| Worklog Id | 50410 [ 50410 ] |
| Time Spent | 467h 40m [ 1683600 ] | 472h 40m [ 1701600 ] |
| Worklog Id | 50476 [ 50476 ] |
Smita Pawar (Inactive)
logged work - 30/May/17 02:28 PM -
- Time Spent:
- 5h
-
Customization changes
Customization verification
Internal discussion
Cost verification for few employees
Smita Pawar (Inactive)
made changes -
| Time Spent | 472h 40m [ 1701600 ] | 477h 40m [ 1719600 ] |
| Worklog Id | 50657 [ 50657 ] |
-
- Time Spent:
- 1.5h
-
Discussion with Nandu and Revan and Code analysis
-
- Time Spent:
- 16.5h
-
Working on metso files
(05/30/2017 10.00am to 05/31/2017 3.30 am)
-
- Time Spent:
- 4h
- <No comment>
| Time Spent | 477h 40m [ 1719600 ] | 479h 10m [ 1725000 ] |
| Worklog Id | 50680 [ 50680 ] |
| Time Spent | 479h 10m [ 1725000 ] | 495h 40m [ 1784400 ] |
| Worklog Id | 50785 [ 50785 ] |
-
- Time Spent:
- 4h
-
Non Employee File testing
| Time Spent | 495h 40m [ 1784400 ] | 499h 40m [ 1798800 ] |
| Worklog Id | 51080 [ 51080 ] |
Smita Pawar (Inactive)
logged work - 31/May/17 11:06 AM -
- Time Spent:
- 7h
-
File testing
Task distribution
Internal discussion
Change file testing scenario discussion
Smita Pawar (Inactive)
made changes -
| Time Spent | 499h 40m [ 1798800 ] | 506h 40m [ 1824000 ] |
| Worklog Id | 51094 [ 51094 ] |
-
- Time Spent:
- 5.5h
-
working on metso files.
| Time Spent | 506h 40m [ 1824000 ] | 512h 10m [ 1843800 ] |
| Worklog Id | 51487 [ 51487 ] |
| Time Spent | 512h 10m [ 1843800 ] | 517h 10m [ 1861800 ] |
| Worklog Id | 51503 [ 51503 ] |
Smita Pawar (Inactive)
logged work - 01/Jun/17 02:51 PM -
- Time Spent:
- 9h
-
Call with Amit.
Internal discussion
File testing Employee
Issue analysis
Change file scenarios
Issue list preparation
Smita Pawar (Inactive)
made changes -
| Time Spent | 517h 10m [ 1861800 ] | 526h 10m [ 1894200 ] |
| Worklog Id | 51765 [ 51765 ] |
-
- Time Spent:
- 7h
-
Metso ACA employee files testing
discussion with Smita, Revan, Nandkumar
-
- Time Spent:
- 17h
-
Call with Amit
Metso file delivery as per new requirement
(06/01/2017 10:00 am to 06/02/2017 4.00 am)
-
- Time Spent:
- 8h
- <No comment>
| Time Spent | 526h 10m [ 1894200 ] | 543h 10m [ 1955400 ] |
| Worklog Id | 51803 [ 51803 ] |
Smita Pawar (Inactive)
logged work - 02/Jun/17 01:22 PM -
- Time Spent:
- 5h
-
Change file scenario
Internal discussion
-
- Time Spent:
- 7h
-
Metso ACA employee files testing
discussion with Smita, Revan, Nandkumar
-
- Time Spent:
- 15h
-
06/02/2017 10.00 am to 06/03/2017 02.00 am
File delivery - metso files as per new requirement.
-
- Time Spent:
- 8h
- <No comment>
| Time Spent | 543h 10m [ 1955400 ] | 558h 10m [ 2009400 ] |
| Worklog Id | 52104 [ 52104 ] |
-
- Time Spent:
- 6.5h
-
Testing metso ACA file : Terminated employees records with multiple COVG rows.
-
- Time Spent:
- 7h
-
Metso ACA employee files testing
discussion with Smita, Revan, Nandkumar
-
- Time Spent:
- 10.5h
-
Metso files delivery.
-
- Time Spent:
- 8h
- <No comment>
Smita Pawar (Inactive)
logged work - 06/Jun/17 04:42 AM -
- Time Spent:
- 5h
-
Terminated employees file testing for Metso
| Time Spent | 558h 10m [ 2009400 ] | 568h 40m [ 2047200 ] |
| Worklog Id | 52425 [ 52425 ] |
-
- Time Spent:
- 8h
- <No comment>
| Time Spent | 568h 40m [ 2047200 ] | 575h 10m [ 2070600 ] |
| Worklog Id | 52728 [ 52728 ] |
| Time Spent | 575h 10m [ 2070600 ] | 576h 10m [ 2074200 ] |
| Worklog Id | 53331 [ 53331 ] |
-
- Time Spent:
- 1h
-
DB backup from production and attached to local servers.
-
- Time Spent:
- 2h
-
Discussion with smita.
Created data transformation document.
-
- Time Spent:
- 7.5h
-
Code Impact testing.
Call with Amit for metso queries.
Review Change file scenarion options,
Metso file testing on subtemplate customization changes for waive reason.
Smita Pawar (Inactive)
logged work - 09/Jun/17 04:51 AM -
- Time Spent:
- 3h
-
Changes suggest by client for terminated employee.
Call with Amit
| Time Spent | 576h 10m [ 2074200 ] | 578h 10m [ 2081400 ] |
| Worklog Id | 53499 [ 53499 ] |
| Time Spent | 578h 10m [ 2081400 ] | 585h 40m [ 2108400 ] |
| Worklog Id | 53506 [ 53506 ] |
-
- Time Spent:
- 10h
- <No comment>
Smita Pawar (Inactive)
logged work - 10/Jun/17 05:02 AM -
- Time Spent:
- 2.5h
-
DTS changes production
Jira updates
Email communication
-
- Time Spent:
- 4h
- <No comment>
-
- Time Spent:
- 4h
- <No comment>
-
- Time Spent:
- 8h
-
Discussion with Amit,
File generation as per new suggested option no-2 methodology.
-
- Time Spent:
- 8h
- <No comment>
| Time Spent | 585h 40m [ 2108400 ] | 593h 40m [ 2137200 ] |
| Worklog Id | 54352 [ 54352 ] |
| Time Spent | 593h 40m [ 2137200 ] | 601h 40m [ 2166000 ] |
| Worklog Id | 54353 [ 54353 ] |
| Time Spent | 601h 40m [ 2166000 ] | 609h 40m [ 2194800 ] |
| Worklog Id | 54356 [ 54356 ] |
| Time Spent | 609h 40m [ 2194800 ] | 617h 40m [ 2223600 ] |
| Worklog Id | 54358 [ 54358 ] |
| Time Spent | 617h 40m [ 2223600 ] | 627h 40m [ 2259600 ] |
| Worklog Id | 54360 [ 54360 ] |
| Time Spent | 627h 40m [ 2259600 ] | 635h 40m [ 2288400 ] |
| Worklog Id | 54361 [ 54361 ] |
| Time Spent | 635h 40m [ 2288400 ] | 638h 40m [ 2299200 ] |
| Worklog Id | 54363 [ 54363 ] |
| Time Spent | 638h 40m [ 2299200 ] | 645h 40m [ 2324400 ] |
| Worklog Id | 54364 [ 54364 ] |
| Time Spent | 645h 40m [ 2324400 ] | 652h 40m [ 2349600 ] |
| Worklog Id | 54365 [ 54365 ] |
| Time Spent | 652h 40m [ 2349600 ] | 659h 40m [ 2374800 ] |
| Worklog Id | 54367 [ 54367 ] |
| Time Spent | 659h 40m [ 2374800 ] | 667h 40m [ 2403600 ] |
| Worklog Id | 54375 [ 54375 ] |
-
- Time Spent:
- 3h
-
ACA Files
Records data adding from files provided by revan
Merging the records all from Yogita, Kanchan, Smita and Prashant
-
- Time Spent:
- 4.5h
-
File testing
Re-Testing of the file due to file changed by Revan,
Found issues , discussed with
Internal discussionw with Revan for Observed issue missing Elig Records and Some events
Task distribution and collection
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
Smita Pawar (Inactive)
added a comment - - edited 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 Samal Yogita 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.
Smita Pawar (Inactive)
logged work - 13/Jun/17 01:34 PM -
- Time Spent:
- 7h
-
File testing
Manual changes
Internal discussion
Task distribution
Smita Pawar (Inactive)
made changes -
| Time Spent | 667h 40m [ 2403600 ] | 674h 40m [ 2428800 ] |
| Worklog Id | 54687 [ 54687 ] |
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
-
- Time Spent:
- 7h
-
Discussion with revan.
Merging files with terminated records.
Tested merged file.
Kanchan Jalgaonkar (Inactive)
logged work - 13/Jun/17 05:26 PM -
- Time Spent:
- 7h
-
ACA file testing
discussion with Yogita
testing for Check points , checking events , checking structure of files
-
- Time Spent:
- 8h
-
File Delivery & testing.
-
- Time Spent:
- 3h
- <No comment>
| Time Spent | 674h 40m [ 2428800 ] | 682h 40m [ 2457600 ] |
| Worklog Id | 54807 [ 54807 ] |
| Time Spent | 682h 40m [ 2457600 ] | 685h 40m [ 2468400 ] |
| Worklog Id | 55051 [ 55051 ] |
| Worklog Id | 55051 [ 55051 ] |
| Time Spent | 685h 40m [ 2468400 ] | 690h 10m [ 2484600 ] |
| Worklog Id | 55052 [ 55052 ] |
| Description |
Hello [~smita.pawar], New ticket being opened for issue related to previous ticket # EDI-1042. I couldn't reopen the original ticket, so I'm opening a new one to report some records not coming over on the Jan 2017 ACA files. The client has completed the audit, but found a lot of missing records. Looking at some of the dependents in WT, I did saw them enrolled in *HIGHMARK PPO 90-Medical-Highmark* but wasn't on the file. I have uploaded client's audit file *Metso ACA file audit.xlsx* and their comments *Audit of January 2017 Metso ACA file.msg* to the EBS ftp server located in /workterraaca/BSG ACA/Metso ADP/ . I've checked the template *Metso ADP - ACA Employee* but it does show the plan selected along with their classes. Can you review the audit file and client comments, and also take another look at the settings on the three templates? *Metso ADP - ACA Employee* *Metso ADP - ACA Non Employee* *Metso ADP - ACA Multiemployer* I've tried deleting march run dates from template **Metso ADP - ACA Employee* and exported again to see if the records would show up on the file, but they didn't. Those run dates have been added back in the way it was. Thank you, Alex |
Hello [~smita.pawar], New ticket being opened for issue related to previous ticket # EDI-1042. I couldn't reopen the original ticket, so I'm opening a new one to report some records not coming over on the Jan 2017 ACA files. The client has completed the audit, but found a lot of missing records. Looking at some of the dependents in WT, I did saw them enrolled in *HIGHMARK PPO 90-Medical-Highmark* but wasn't on the file. I have uploaded client's audit file *Metso ACA file audit.xlsx* and their comments *Audit of January 2017 Metso ACA file.msg* to the EBS ftp server located in /workterraaca/BSG ACA/Metso ADP/ . I've checked the template *Metso ADP - ACA Employee* but it does show the plan selected along with their classes. Can you review the audit file and client comments, and also take another look at the settings on the three templates? *Metso ADP - ACA Employee* *Metso ADP - ACA Non Employee* *Metso ADP - ACA Multiemployer* I've tried deleting march run dates from template **Metso ADP - ACA Employee* and exported again to see if the records would show up on the file, but they didn't. Those run dates have been added back in the way it was. Thank you, Alex *Carrier contact:* James Camak Product Support III AVS - Health Care Reform 706-731-2319 |
-
- Time Spent:
- 5h
-
Test scenario automation & review.
-
- Time Spent:
- 4h
-
Changed DTS on company according to document given by smita.
-
- Time Spent:
- 6h
-
Call with Amit,
Internal discussion on client provided comments.
As per suggestion by client- Sequence of offer logic implementation.
| Time Spent | 690h 10m [ 2484600 ] | 697h 10m [ 2509800 ] |
| Worklog Id | 55626 [ 55626 ] |
| Time Spent | 697h 10m [ 2509800 ] | 702h 10m [ 2527800 ] |
| Worklog Id | 55630 [ 55630 ] |
| Time Spent | 702h 10m [ 2527800 ] | 708h 10m [ 2549400 ] |
| Worklog Id | 55631 [ 55631 ] |
| Time Spent | 708h 10m [ 2549400 ] | 712h 10m [ 2563800 ] |
| Worklog Id | 55632 [ 55632 ] |
Kanchan Jalgaonkar (Inactive)
made changes -
| Time Spent | 712h 10m [ 2563800 ] | 719h 10m [ 2589000 ] |
| Worklog Id | 55671 [ 55671 ] |
| Time Spent | 719h 10m [ 2589000 ] | 726h 10m [ 2614200 ] |
| Worklog Id | 55923 [ 55923 ] |
-
- Time Spent:
- 7h
-
Medical opt-out records certain fields value setting blank implementation for the client said requirement.
-
- Time Spent:
- 8h
- <No comment>
Smita Pawar (Inactive)
logged work - 17/Jun/17 05:16 AM -
- Time Spent:
- 4.5h
-
File delivery with option 2 i.e latest election termination on file
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
Smita Pawar (Inactive)
added a comment - 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
-
- Time Spent:
- 6h
-
Discussion with smita.
Merged employees file with termination of records.
Testing of merged file.
Kanchan Jalgaonkar (Inactive)
logged work - 19/Jun/17 05:10 PM -
- Time Spent:
- 2h
-
Metso ACA files merging
discussion with Yogita
-
- Time Spent:
- 8h
-
Metso files processed-till 19.June.2017.
-
- Time Spent:
- 4h
- <No comment>
| Time Spent | 726h 10m [ 2614200 ] | 734h 10m [ 2643000 ] |
| Worklog Id | 56452 [ 56452 ] |
Kanchan Jalgaonkar (Inactive)
made changes -
| Time Spent | 734h 10m [ 2643000 ] | 736h 10m [ 2650200 ] |
| Worklog Id | 56460 [ 56460 ] |
Smita Pawar (Inactive)
logged work - 20/Jun/17 05:25 AM -
- Time Spent:
- 7.5h
-
File testing
Fie delivery
Internal discussion
Task allocation and coordination
Smita Pawar (Inactive)
made changes -
| Time Spent | 736h 10m [ 2650200 ] | 743h 40m [ 2677200 ] |
| Worklog Id | 56470 [ 56470 ] |
-
- Time Spent:
- 7h
-
Metso files post processing automation.
-
- Time Spent:
- 4h
- <No comment>
| Time Spent | 743h 40m [ 2677200 ] | 751h 40m [ 2706000 ] |
| Worklog Id | 57047 [ 57047 ] |
| Time Spent | 751h 40m [ 2706000 ] | 755h 40m [ 2720400 ] |
| Worklog Id | 57066 [ 57066 ] |
| Time Spent | 755h 40m [ 2720400 ] | 759h 40m [ 2734800 ] |
| Worklog Id | 57068 [ 57068 ] |
| Time Spent | 759h 40m [ 2734800 ] | 766h 40m [ 2760000 ] |
| Worklog Id | 57100 [ 57100 ] |
Yogesh Chaudhari (Inactive)
logged work - 21/Jun/17 02:12 PM -
- Time Spent:
- 5h
-
Analysis of coverage has Zero cost,
Discussion with Revan about issue
-
- Time Spent:
- 8.5h
-
- Missing Tiers of EE+SP for HDHP 90 plan for some employees.
Analysis & resolved. - For all terminated employees transaction was reflecting of future date i.e. 06/30/2017
Debug,Analysis, find out the cause & corrected.
- Missing Tiers of EE+SP for HDHP 90 plan for some employees.
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
-
- Time Spent:
- 4h
- <No comment>
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
Smita Pawar (Inactive)
added a comment - 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 -
- Time Spent:
- 1.5h
-
Changed DTS for some employees on employee file.
Testing done for same.
-
- Time Spent:
- 1h
-
Call with BSG (from home)
-
- Time Spent:
- 9.5h
-
Metso file delivery.
-
- Time Spent:
- 3h
- <No comment>
| Time Spent | 766h 40m [ 2760000 ] | 772h 40m [ 2781600 ] |
| Worklog Id | 57699 [ 57699 ] |
| Time Spent | 772h 40m [ 2781600 ] | 774h 10m [ 2787000 ] |
| Worklog Id | 57700 [ 57700 ] |
Smita Pawar (Inactive)
logged work - 23/Jun/17 06:31 AM -
- Time Spent:
- 5h
-
1.Internal discussion
2.File delivery
3.File testing
4.Client call
Smita Pawar (Inactive)
made changes -
| Time Spent | 774h 10m [ 2787000 ] | 779h 10m [ 2805000 ] |
| Worklog Id | 57764 [ 57764 ] |
Smita Pawar (Inactive)
made changes -
| Attachment | Terminated Employees.JPG [ 53349 ] |
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
Smita Pawar (Inactive)
added a comment - - edited 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 Yogesh Chaudhari (Inactive)
logged work - 23/Jun/17 02:13 PM -
- Time Spent:
- 8h
-
Analysis of zero coverage cost issue
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 779h 10m [ 2805000 ] | 784h 10m [ 2823000 ] |
| Worklog Id | 58035 [ 58035 ] |
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 784h 10m [ 2823000 ] | 792h 10m [ 2851800 ] |
| Worklog Id | 58036 [ 58036 ] |
Thank Smita Pawar. I'm reviewing it right now then will provide to Tamkeen at BSG to approve before having ADP load it.
Alex
-
- Time Spent:
- 1.5h
-
Changed employee name on file.
Tested necessary checks on file.
Hi Smita Pawar,
I just got off the phone with James at ADP. So far he said the file looks really good because it was able to auto convert to xml and passed through prevalidation. The low cost, attestation, Employees, OFFR/COVG, and DEPI counts are appearing correctly. He will provide results in 2 days after the employee file loads into production. Please disregard my previous message regarding the new non employee file. Found out the surviving spouse, Diana Butler, hasn't enrolled in COBRA yet. ADP said she can go on the file later whenever she is enrolled in COBRA. We won't need a new non employee file at this time. ADP will take the one from 6/19/17 for loading.
Thank you,
Alex
-
- Time Spent:
- 4h
- <No comment>
| Time Spent | 792h 10m [ 2851800 ] | 793h 10m [ 2855400 ] |
| Worklog Id | 58140 [ 58140 ] |
| Time Spent | 793h 10m [ 2855400 ] | 802h 40m [ 2889600 ] |
| Worklog Id | 58141 [ 58141 ] |
| Worklog Id | 58141 [ 58141 ] |
| Time Spent | 802h 40m [ 2889600 ] | 811h 10m [ 2920200 ] |
| Worklog Id | 58144 [ 58144 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 811h 10m [ 2920200 ] | 816h 10m [ 2938200 ] |
| Worklog Id | 58327 [ 58327 ] |
-
- Time Spent:
- 8h
-
Change scenarion testing..
Smita Pawar (Inactive)
made changes -
| Time Spent | 816h 10m [ 2938200 ] | 821h 10m [ 2956200 ] |
| Worklog Id | 58421 [ 58421 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 821h 10m [ 2956200 ] | 824h 10m [ 2967000 ] |
| Worklog Id | 58425 [ 58425 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 824h 10m [ 2967000 ] | 826h 40m [ 2976000 ] |
| Worklog Id | 58431 [ 58431 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 826h 40m [ 2976000 ] | 831h 10m [ 2992200 ] |
| Worklog Id | 58439 [ 58439 ] |
| Time Spent | 831h 10m [ 2992200 ] | 839h 10m [ 3021000 ] |
| Worklog Id | 58452 [ 58452 ] |
| Time Spent | 839h 10m [ 3021000 ] | 843h 10m [ 3035400 ] |
| Worklog Id | 58712 [ 58712 ] |
| Time Spent | 843h 10m [ 3035400 ] | 847h 10m [ 3049800 ] |
| Worklog Id | 58713 [ 58713 ] |
| Time Spent | 847h 10m [ 3049800 ] | 851h 10m [ 3064200 ] |
| Worklog Id | 58716 [ 58716 ] |
| Time Spent | 851h 10m [ 3064200 ] | 854h 10m [ 3075000 ] |
| Worklog Id | 58723 [ 58723 ] |
| Time Spent | 854h 10m [ 3075000 ] | 857h 10m [ 3085800 ] |
| Worklog Id | 58734 [ 58734 ] |
| Time Spent | 857h 10m [ 3085800 ] | 858h 10m [ 3089400 ] |
| Worklog Id | 58734 [ 58734 ] |
| Time Spent | 858h 10m [ 3089400 ] | 861h 40m [ 3102000 ] |
| Worklog Id | 58785 [ 58785 ] |
-
- Time Spent:
- 3.5h
-
Internal discussion.
Change file setup.
| Time Spent | 861h 40m [ 3102000 ] | 863h 10m [ 3107400 ] |
| Worklog Id | 59004 [ 59004 ] |
| Time Spent | 863h 10m [ 3107400 ] | 871h 10m [ 3136200 ] |
| Worklog Id | 59458 [ 59458 ] |
Smita Pawar (Inactive)
logged work - 29/Jun/17 02:11 PM -
- Time Spent:
- 2h
-
File testing
Jira updates
Delivery
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
Smita Pawar (Inactive)
added a comment - - edited 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 Smita Pawar (Inactive)
made changes -
| Time Spent | 871h 10m [ 3136200 ] | 873h 10m [ 3143400 ] |
| Worklog Id | 59511 [ 59511 ] |
-
- Time Spent:
- 8h
-
Metso change file delivery.
-
- Time Spent:
- 4h
- <No comment>
| Time Spent | 873h 10m [ 3143400 ] | 877h 10m [ 3157800 ] |
| Worklog Id | 59830 [ 59830 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 877h 10m [ 3157800 ] | 883h 10m [ 3179400 ] |
| Worklog Id | 59882 [ 59882 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 883h 10m [ 3179400 ] | 887h 10m [ 3193800 ] |
| Worklog Id | 59975 [ 59975 ] |
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?
Smita Pawar (Inactive)
added a comment - 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
Smita Pawar (Inactive)
added a comment - - edited 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
| Time Spent | 887h 10m [ 3193800 ] | 894h 40m [ 3220800 ] |
| Worklog Id | 60318 [ 60318 ] |
Smita Pawar (Inactive)
made changes -
| Remaining Estimate | 0h [ 0 ] | 1h [ 3600 ] |
| Time Spent | 894h 40m [ 3220800 ] | 893h 40m [ 3217200 ] |
| Worklog Id | 59882 [ 59882 ] |
-
- Time Spent:
- 7.5h
-
Metso file exported of change files.
Scenario testing.
-
- Time Spent:
- 6h
- <No comment>
| Attachment | Sample_Event.txt [ 54238 ] |
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.
Thank you,
Alex
Smita Pawar (Inactive)
logged work - 06/Jul/17 10:46 AM -
- Time Spent:
- 6h
-
Employee & Non employee file testing
Delivery
Task distribution & allocation
Kanchan Jalgaonkar (Inactive)
logged work - 06/Jul/17 12:38 PM -
- Time Spent:
- 1h
-
merging of employee records
testing of merged records
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
Smita Pawar (Inactive)
added a comment - 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 | Remaining Estimate | 1h [ 3600 ] | 0h [ 0 ] |
| Time Spent | 893h 40m [ 3217200 ] | 901h 10m [ 3244200 ] |
| Worklog Id | 61232 [ 61232 ] |
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.
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
-
- Time Spent:
- 4.5h
-
Verified 7 employees cost by initiating qualifying event and made changes on file.
Merging file with terminated employees.
Final merging of file of all terminated records for COVG row.
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
-
- Time Spent:
- 7.5h
-
Metso file delivery as per new changes required for terminated employees record.
-
- Time Spent:
- 6h
-
File merging
Manual changes
Testing & uploading files to FTP
Client query resolutions
| Time Spent | 901h 10m [ 3244200 ] | 908h 40m [ 3271200 ] |
| Worklog Id | 61721 [ 61721 ] |
-
- Time Spent:
- 3.5h
-
Made required correction on final merged file.
Testing of merged file.
-
- Time Spent:
- 7.5h
-
File Delivery & Testing for change file scenario.
-
- Time Spent:
- 4h
-
New file sent
Smita Pawar (Inactive)
logged work - 10/Jul/17 01:56 PM -
- Time Spent:
- 4h
-
Analysis
Internal discussion
Reply to amit
Smita Pawar (Inactive)
made changes -
| Time Spent | 908h 40m [ 3271200 ] | 912h 40m [ 3285600 ] |
| Worklog Id | 62109 [ 62109 ] |
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
Smita Pawar (Inactive)
added a comment - 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.
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
-
- Time Spent:
- 1h
-
File merging with terminated records COVG and OFFER rows.
| Time Spent | 912h 40m [ 3285600 ] | 921h 40m [ 3318000 ] |
| Worklog Id | 62535 [ 62535 ] |
Yogesh Chaudhari (Inactive)
logged work - 12/Jul/17 06:02 AM -
- Time Spent:
- 8h
-
Exported files for Metso from 1st Jan 2017 to 11 July 2017
| Time Spent | 921h 40m [ 3318000 ] | 927h 40m [ 3339600 ] |
| Worklog Id | 62550 [ 62550 ] |
| Worklog Id | 62550 [ 62550 ] |
| Worklog Id | 62550 [ 62550 ] |
Smita Pawar (Inactive)
logged work - 12/Jul/17 06:16 AM -
- Time Spent:
- 3h
-
File testing
Comparison testing
Jira updates
Client reply
File delivery
Smita Pawar (Inactive)
made changes -
| Time Spent | 927h 40m [ 3339600 ] | 930h 40m [ 3350400 ] |
| Worklog Id | 62561 [ 62561 ] |
Kanchan Jalgaonkar (Inactive)
made changes -
| Time Spent | 930h 40m [ 3350400 ] | 931h 40m [ 3354000 ] |
| Worklog Id | 62674 [ 62674 ] |
Smita Pawar (Inactive)
logged work - 12/Jul/17 01:21 PM -
- Time Spent:
- 4h
-
Internal discussion
Draft & reply to client
Manual changes in file
Uploading file to FTP
Smita Pawar (Inactive)
made changes -
| Time Spent | 931h 40m [ 3354000 ] | 935h 40m [ 3368400 ] |
| Worklog Id | 62724 [ 62724 ] |
| Time Spent | 935h 40m [ 3368400 ] | 940h 10m [ 3384600 ] |
| Worklog Id | 62845 [ 62845 ] |
| Time Spent | 940h 10m [ 3384600 ] | 943h 40m [ 3397200 ] |
| Worklog Id | 62848 [ 62848 ] |
| Time Spent | 943h 40m [ 3397200 ] | 944h 40m [ 3400800 ] |
| Worklog Id | 62859 [ 62859 ] |
Yogesh Chaudhari (Inactive)
logged work - 13/Jul/17 06:06 AM -
- Time Spent:
- 5.5h
-
Verify the all employee,dependents whose middle name is 'I'
Meeting with Nandu to discuss about Metso client reported issue.
Verify all the users whose has different event on file other than expected.
-
- Time Spent:
- 8h
-
Internal discussion.
Metso change file testing.
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
| Time Spent | 944h 40m [ 3400800 ] | 952h 40m [ 3429600 ] |
| Worklog Id | 63780 [ 63780 ] |
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 952h 40m [ 3429600 ] | 960h 40m [ 3458400 ] |
| Worklog Id | 63822 [ 63822 ] |
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 960h 40m [ 3458400 ] | 966h 10m [ 3478200 ] |
| Worklog Id | 63823 [ 63823 ] |
-
- Time Spent:
- 2h
-
Discussion and verification od scenario
-
- Time Spent:
- 8h
-
Change scenario testing.
-
- Time Spent:
- 2h
- <No comment>
-
- Time Spent:
- 1h
-
Discussion on change file
| Time Spent | 966h 10m [ 3478200 ] | 967h 10m [ 3481800 ] |
| Worklog Id | 64255 [ 64255 ] |
| Time Spent | 967h 10m [ 3481800 ] | 975h 10m [ 3510600 ] |
| Worklog Id | 64256 [ 64256 ] |
Yogesh Chaudhari (Inactive)
logged work - 18/Jul/17 01:30 PM -
- Time Spent:
- 1h
-
Meeting with Amit and Nandu to discuss about file.
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 975h 10m [ 3510600 ] | 976h 10m [ 3514200 ] |
| Worklog Id | 64345 [ 64345 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 976h 10m [ 3514200 ] | 977h 10m [ 3517800 ] |
| Worklog Id | 64350 [ 64350 ] |
-
- Time Spent:
- 6h
-
Change file generation & analysis as per new requirement.
-
- Time Spent:
- 2h
-
file review and pur comments replay to client
Yogesh Chaudhari (Inactive)
logged work - 19/Jul/17 01:25 PM -
- Time Spent:
- 6h
-
Analysis and discussion with Revan and Nandu to export change file for active employee
Export change file Active employee
Smita Pawar (Inactive)
logged work - 19/Jul/17 01:52 PM -
- Time Spent:
- 6h
-
1.Change file testing
2.Test scenario preparation
3.Client mail reply & analysis
4.Email communication
5.Internal communication
-
- Time Spent:
- 8h
-
Active Change File Unit Testing to deliver.
| Time Spent | 977h 10m [ 3517800 ] | 981h 10m [ 3532200 ] |
| Worklog Id | 64815 [ 64815 ] |
| Worklog Id | 64815 [ 64815 ] |
| Time Spent | 981h 10m [ 3532200 ] | 983h 10m [ 3539400 ] |
| Worklog Id | 64859 [ 64859 ] |
| Worklog Id | 64859 [ 64859 ] |
| Time Spent | 983h 10m [ 3539400 ] | 985h 10m [ 3546600 ] |
| Worklog Id | 64860 [ 64860 ] |
| Time Spent | 985h 10m [ 3546600 ] | 987h 10m [ 3553800 ] |
| Worklog Id | 64861 [ 64861 ] |
| Worklog Id | 64861 [ 64861 ] |
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
Smita Pawar (Inactive)
added a comment - 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
Smita Pawar (Inactive)
logged work - 20/Jul/17 01:24 PM -
- Time Spent:
- 6h
-
1.Change file testing for Employee & Non employee files
Smita Pawar (Inactive)
made changes -
| Time Spent | 987h 10m [ 3553800 ] | 993h 10m [ 3575400 ] |
| Worklog Id | 65111 [ 65111 ] |
Yogesh Chaudhari (Inactive)
logged work - 20/Jul/17 01:27 PM -
- Time Spent:
- 8h
-
Export change file again and analysis of expected employees.
Done the analysis which employee should populate on file.
-
- Time Spent:
- 8h
-
Active Employee Change File Delivered by testing & issue resolved on findings.
NON EE file generated & analysis ,testing the file.
-
- Time Spent:
- 1.5h
-
Change file testing
Smita Pawar (Inactive)
made changes -
| Time Spent | 993h 10m [ 3575400 ] | 994h 10m [ 3579000 ] |
| Worklog Id | 65209 [ 65209 ] |
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
| Time Spent | 994h 10m [ 3579000 ] | 1,000h 10m [ 3600600 ] |
| Worklog Id | 65311 [ 65311 ] |
| Time Spent | 1,000h 10m [ 3600600 ] | 1,008h 10m [ 3629400 ] |
| Worklog Id | 65313 [ 65313 ] |
| Time Spent | 1,008h 10m [ 3629400 ] | 1,016h 10m [ 3658200 ] |
| Worklog Id | 65314 [ 65314 ] |
| Worklog Id | 65314 [ 65314 ] |
| Time Spent | 1,016h 10m [ 3658200 ] | 1,024h 10m [ 3687000 ] |
| Worklog Id | 65316 [ 65316 ] |
-
- Time Spent:
- 1.5h
-
Metso ACA Non employee change file testing and delivery.
-
- Time Spent:
- 8h
-
NON EE file delivered by testing & issue resolved by finding.
Internal discussion for automation of new requirement.
| Time Spent | 1,024h 10m [ 3687000 ] | 1,025h 40m [ 3692400 ] |
| Worklog Id | 65428 [ 65428 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,025h 40m [ 3692400 ] | 1,026h 10m [ 3694200 ] |
| Worklog Id | 65209 [ 65209 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,026h 10m [ 3694200 ] | 1,032h 10m [ 3715800 ] |
| Worklog Id | 65573 [ 65573 ] |
Smita Pawar (Inactive)
made changes -
| Remaining Estimate | 0h [ 0 ] | 6h [ 21600 ] |
| Time Spent | 1,032h 10m [ 3715800 ] | 1,026h 10m [ 3694200 ] |
| Worklog Id | 65573 [ 65573 ] | |
| Worklog Time Spent | 6h [ 21600 ] |
-
- Time Spent:
- 3.5h
-
Analysis and discussion with Revan to avoid duplicate event in Metso file.
Analysis of populating zero cost on file.
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
| Description |
Hello [~smita.pawar], New ticket being opened for issue related to previous ticket # EDI-1042. I couldn't reopen the original ticket, so I'm opening a new one to report some records not coming over on the Jan 2017 ACA files. The client has completed the audit, but found a lot of missing records. Looking at some of the dependents in WT, I did saw them enrolled in *HIGHMARK PPO 90-Medical-Highmark* but wasn't on the file. I have uploaded client's audit file *Metso ACA file audit.xlsx* and their comments *Audit of January 2017 Metso ACA file.msg* to the EBS ftp server located in /workterraaca/BSG ACA/Metso ADP/ . I've checked the template *Metso ADP - ACA Employee* but it does show the plan selected along with their classes. Can you review the audit file and client comments, and also take another look at the settings on the three templates? *Metso ADP - ACA Employee* *Metso ADP - ACA Non Employee* *Metso ADP - ACA Multiemployer* I've tried deleting march run dates from template **Metso ADP - ACA Employee* and exported again to see if the records would show up on the file, but they didn't. Those run dates have been added back in the way it was. Thank you, Alex *Carrier contact:* James Camak Product Support III AVS - Health Care Reform 706-731-2319 |
Hello [~smita.pawar], New ticket being opened for issue related to previous ticket # EDI-1042. I couldn't reopen the original ticket, so I'm opening a new one to report some records not coming over on the Jan 2017 ACA files. The client has completed the audit, but found a lot of missing records. Looking at some of the dependents in WT, I did saw them enrolled in *HIGHMARK PPO 90-Medical-Highmark* but wasn't on the file. I have uploaded client's audit file *Metso ACA file audit.xlsx* and their comments *Audit of January 2017 Metso ACA file.msg* to the EBS ftp server located in /workterraaca/BSG ACA/Metso ADP/ . I've checked the template *Metso ADP - ACA Employee* but it does show the plan selected along with their classes. Can you review the audit file and client comments, and also take another look at the settings on the three templates? *Metso ADP - ACA Employee* *Metso ADP - ACA Non Employee* *Metso ADP - ACA Multiemployer* I've tried deleting march run dates from template **Metso ADP - ACA Employee* and exported again to see if the records would show up on the file, but they didn't. Those run dates have been added back in the way it was. Thank you, Alex *Carrier contact:* James Camak Product Support III AVS - Health Care Reform 706-731-2319 Tim Fuller FPC, CHRS| Account Manager ADP Health Care Reform 844.237.2221 ext 8172013 tollfree Tim.Fuller@adp.com HCRaccountmanager37@adp.com |
-
- Time Spent:
- 3.5h
-
Duplicate event analysis & testing ,
Yogesh Chaudhari (Inactive)
made changes -
| Remaining Estimate | 6h [ 21600 ] | 4h [ 14400 ] |
| Time Spent | 1,026h 10m [ 3694200 ] | 1,028h 10m [ 3701400 ] |
| Worklog Id | 66235 [ 66235 ] |
Yogesh Chaudhari (Inactive)
logged work - 25/Jul/17 01:14 PM -
- Time Spent:
- 8h
-
Analysis of employee coverage populating with zero cost and completed this.
Yogesh Chaudhari (Inactive)
made changes -
| Remaining Estimate | 4h [ 14400 ] | 2.5h [ 9000 ] |
| Time Spent | 1,028h 10m [ 3701400 ] | 1,029h 40m [ 3706800 ] |
| Worklog Id | 66235 [ 66235 ] |
Yogesh Chaudhari (Inactive)
made changes -
| Remaining Estimate | 2.5h [ 9000 ] | 0h [ 0 ] |
| Time Spent | 1,029h 40m [ 3706800 ] | 1,037h 40m [ 3735600 ] |
| Worklog Id | 66236 [ 66236 ] |
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 1,037h 40m [ 3735600 ] | 1,043h 40m [ 3757200 ] |
| Worklog Id | 66243 [ 66243 ] |
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 1,043h 40m [ 3757200 ] | 1,051h 40m [ 3786000 ] |
| Worklog Id | 66247 [ 66247 ] |
Smita Pawar (Inactive)
logged work - 25/Jul/17 01:42 PM -
- Time Spent:
- 1.5h
-
Analysis of client feed back
Client reply
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,051h 40m [ 3786000 ] | 1,053h 10m [ 3791400 ] |
| Worklog Id | 66259 [ 66259 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,053h 10m [ 3791400 ] | 1,059h 10m [ 3813000 ] |
| Worklog Id | 66275 [ 66275 ] |
-
- Time Spent:
- 6h
-
Change file scenario testing & Internal discussion for identified issue like duplicate events & solutions.
Yogesh Chaudhari (Inactive)
logged work - 26/Jul/17 09:27 AM -
- Time Spent:
- 2h
-
Completed analysis of employee coverage populating with zero cost and completed this
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
Smita Pawar (Inactive)
added a comment - - edited 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 -
- Time Spent:
- 2h
-
Duplicate event implementation unit testing.
| Time Spent | 1,059h 10m [ 3813000 ] | 1,065h 10m [ 3834600 ] |
| Worklog Id | 66773 [ 66773 ] |
| Time Spent | 1,065h 10m [ 3834600 ] | 1,068h 40m [ 3847200 ] |
| Worklog Id | 66780 [ 66780 ] |
| Time Spent | 1,068h 40m [ 3847200 ] | 1,070h 40m [ 3854400 ] |
| Worklog Id | 66783 [ 66783 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,070h 40m [ 3854400 ] | 1,076h 40m [ 3876000 ] |
| Worklog Id | 67048 [ 67048 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,076h 40m [ 3876000 ] | 1,078h 40m [ 3883200 ] |
| Worklog Id | 67052 [ 67052 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,078h 40m [ 3883200 ] | 1,082h 40m [ 3897600 ] |
| Worklog Id | 67052 [ 67052 ] |
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 1,082h 40m [ 3897600 ] | 1,084h 40m [ 3904800 ] |
| Worklog Id | 67615 [ 67615 ] |
| Attachment | Change_Active_01012017_08042017_ForQAVerification.zip [ 57620 ] |
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
| Attachment | Change_NONEE_01012017_08042017_ForQAVerification.zip [ 57633 ] |
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
| Time Spent | 1,084h 40m [ 3904800 ] | 1,092h 40m [ 3933600 ] |
| Worklog Id | 69481 [ 69481 ] |
-
- Time Spent:
- 2h
-
Discussion with smita.
Tested changed file of metso.
-
- Time Spent:
- 3.5h
-
Work on the Metso change file for analysis.
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 1,092h 40m [ 3933600 ] | 1,095h 40m [ 3944400 ] |
| Worklog Id | 69596 [ 69596 ] |
Smita Pawar (Inactive)
logged work - 04/Aug/17 01:47 PM -
- Time Spent:
- 4h
-
Testing
Draft
Internal discussion
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
Smita Pawar (Inactive)
added a comment - 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
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,095h 40m [ 3944400 ] | 1,099h 40m [ 3958800 ] |
| Worklog Id | 69597 [ 69597 ] |
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
-
- Time Spent:
- 8h
-
Metso change file delivery 01012017 to 08042017[Active & NonEE].
| Time Spent | 1,099h 40m [ 3958800 ] | 1,101h 40m [ 3966000 ] |
| Worklog Id | 69732 [ 69732 ] |
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
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 1,101h 40m [ 3966000 ] | 1,102h 10m [ 3967800 ] |
| Worklog Id | 69596 [ 69596 ] |
| Attachment | Corrected_Daniel_Hayes_Gaffney_Change_Active_01012017_08042017_ForQAVerification.zip [ 57937 ] |
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
| Assignee | Alex Nguyen [ alexn ] | Revansiddha Gaur [ revansiddha.gaur ] |
| Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
| Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Smita Pawar [ smita.pawar ] |
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
Smita Pawar (Inactive)
logged work - 08/Aug/17 01:38 PM -
- Time Spent:
- 2h
-
File testing
Analysis
Jira updates
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
Smita Pawar (Inactive)
added a comment - 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 Pawar Sachin Hingole Revansiddha Gaur , Yogesh Chaudhari Smita Pawar (Inactive)
made changes -
| Time Spent | 1,102h 10m [ 3967800 ] | 1,104h 10m [ 3975000 ] |
| Worklog Id | 70176 [ 70176 ] |
-
- Time Spent:
- 1h
-
Discussion with revan about metso file changes
-
- Time Spent:
- 4.5h
-
Analysis & discussion & deliver the file.
| Time Spent | 1,104h 10m [ 3975000 ] | 1,108h 40m [ 3991200 ] |
| Worklog Id | 70291 [ 70291 ] |
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 1,108h 40m [ 3991200 ] | 1,109h 40m [ 3994800 ] |
| Worklog Id | 70603 [ 70603 ] |
Yogesh Chaudhari (Inactive)
made changes -
| Worklog Id | 70603 [ 70603 ] |
| Attachment | Metso_Mail_15Aug.pdf [ 58660 ] |
| Attachment | Metso_Missing_Offers_08152017.zip [ 58662 ] |
Feedback on Full File
Mail From Amit Thorve
Mail - Metso_Mail_15Aug.pdf
Mail Attachment - Metso_Missing_Offers_08152017.zip
| Assignee | Smita Pawar [ smita.pawar ] | Revansiddha Gaur [ revansiddha.gaur ] |
Smita Pawar (Inactive)
logged work - 16/Aug/17 12:31 PM -
- Time Spent:
- 1h
-
Intenal communication
Verification
Analysis
| Attachment | June15TerminatedEmployeesExpectedCoverageTransactionSampleMail.pdf [ 58750 ] |
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
| Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Alex Nguyen [ alexn ] |
| Time Spent | 1,109h 40m [ 3994800 ] | 1,117h 40m [ 4023600 ] |
| Worklog Id | 71760 [ 71760 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,117h 40m [ 4023600 ] | 1,118h 40m [ 4027200 ] |
| Worklog Id | 71764 [ 71764 ] |
Thank you Revansiddha Gaur for your feedbacks. I will forward to ADP.
Alex
-
- Time Spent:
- 8h
-
Metso reply on feedback.
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
-
- Time Spent:
- 8h
-
Received feedback on full file & change file shared our feedback.
Yogesh Chaudhari (Inactive)
logged work - 22/Aug/17 06:00 AM -
- Time Spent:
- 6h
-
Analysis of employee queries reported by the client
Discussion with team about queries reported by client.
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 1,118h 40m [ 4027200 ] | 1,124h 40m [ 4048800 ] |
| Worklog Id | 73210 [ 73210 ] |
| Assignee | Alex Nguyen [ alexn ] | Revansiddha Gaur [ revansiddha.gaur ] |
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
| Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Alex Nguyen [ alexn ] |
| Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
| Time Spent | 1,124h 40m [ 4048800 ] | 1,132h 40m [ 4077600 ] |
| Worklog Id | 73271 [ 73271 ] |
| Attachment | FW Metso 07 12 2017 Full file and terms.pdf [ 59704 ] |
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
| Attachment | Active_Change_01012017_08242017ForQaVerification.zip [ 59744 ] |
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
| Attachment | Active_Change_01012017_08242017ForQaVerification.zip [ 59744 ] |
| Attachment | Active_Change_01012017_08242017ForQaVerification.zip [ 59746 ] |
Yogesh Chaudhari (Inactive)
logged work - 24/Aug/17 03:22 PM -
- Time Spent:
- 5.5h
-
Provided updated change file to Metso.
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
| Time Spent | 1,132h 40m [ 4077600 ] | 1,142h 40m [ 4113600 ] |
| Worklog Id | 74189 [ 74189 ] |
-
- Time Spent:
- 10h
-
Metso change File delivery-Active & Non EE.
Smita Pawar (Inactive)
logged work - 25/Aug/17 06:04 AM -
- Time Spent:
- 3h
-
Internal discussion
Testing
Analysis
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
| Time Spent | 1,142h 40m [ 4113600 ] | 1,143h 25m [ 4116300 ] |
| Worklog Id | 74278 [ 74278 ] |
| Attachment | Alycia_Szykowny.png [ 59851 ] |
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
| Time Spent | 1,143h 25m [ 4116300 ] | 1,146h 55m [ 4128900 ] |
| Worklog Id | 74366 [ 74366 ] |
-
- Time Spent:
- 1.75h
-
Call with Amit
Internal discussion
Analysis
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,146h 55m [ 4128900 ] | 1,148h 25m [ 4134300 ] |
| Worklog Id | 74520 [ 74520 ] |
Yogesh Chaudhari (Inactive)
logged work - 28/Aug/17 03:18 PM -
- Time Spent:
- 5.5h
-
Worked on Metso file to analysis 11 employee whose CoverageStartDate = Event Date.
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 1,148h 25m [ 4134300 ] | 1,153h 55m [ 4154100 ] |
| Worklog Id | 74550 [ 74550 ] |
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
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 1,153h 55m [ 4154100 ] | 1,159h 25m [ 4173900 ] |
| Worklog Id | 74553 [ 74553 ] |
| Time Spent | 1,159h 25m [ 4173900 ] | 1,166h 25m [ 4199100 ] |
| Worklog Id | 74556 [ 74556 ] |
-
- Time Spent:
- 3.5h
-
Analysis for one of employee rolled out the change file.
-
- Time Spent:
- 7h
-
Call with Amit,
11 employees correction with change files delivery.
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
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,166h 25m [ 4199100 ] | 1,166h 40m [ 4200000 ] |
| Worklog Id | 74520 [ 74520 ] |
-
- Time Spent:
- 20m
-
Internal discussion & jira reply.
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,166h 40m [ 4200000 ] | 1,169h 40m [ 4210800 ] |
| Worklog Id | 75688 [ 75688 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,169h 40m [ 4210800 ] | 1,170h 10m [ 4212600 ] |
| Worklog Id | 75693 [ 75693 ] |
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
| Time Spent | 1,170h 10m [ 4212600 ] | 1,170.5h [ 4213800 ] |
| Worklog Id | 75701 [ 75701 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,170.5h [ 4213800 ] | 1,172.5h [ 4221000 ] |
| Worklog Id | 75794 [ 75794 ] |
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
Revansiddha Gaur Do not send any new files today.
Yogesh Chaudhari (Inactive)
logged work - 01/Sep/17 12:02 PM -
- Time Spent:
- 3.5h
-
Discussion with Revan about loss of eligibility scenarios.
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 1,172.5h [ 4221000 ] | 1,176h [ 4233600 ] |
| Worklog Id | 76649 [ 76649 ] |
| Attachment | ACA Change Update Email 6 Sep 2017.pdf [ 60819 ] |
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
| Attachment | WT_8973_Tyler_Erhard.png [ 60823 ] |
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
Yogesh Chaudhari (Inactive)
logged work - 06/Sep/17 01:13 PM -
- Time Spent:
- 1h
-
Analysis and discussion with Revan about issues reported by client
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 1,176h [ 4233600 ] | 1,177h [ 4237200 ] |
| Worklog Id | 77116 [ 77116 ] |
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
-
- Time Spent:
- 5h
-
Analysis on client comments & reply.
| Time Spent | 1,177h [ 4237200 ] | 1,182h [ 4255200 ] |
| Worklog Id | 77265 [ 77265 ] |
-
- Time Spent:
- 2h
-
Analysis of multiple offer records on Metso fIle.
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
| Time Spent | 1,182h [ 4255200 ] | 1,183.5h [ 4260600 ] |
| Worklog Id | 77969 [ 77969 ] |
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
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 1,183.5h [ 4260600 ] | 1,185.5h [ 4267800 ] |
| Worklog Id | 78079 [ 78079 ] |
Yogesh Chaudhari (Inactive)
made changes -
| Worklog Id | 78079 [ 78079 ] |
-
- Time Spent:
- 1.5h
-
Jira Feedback checked & Internal discussion with Amit.
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
| Attachment | 09192017MetsoFeedbackOnChangeFiles_Active_NonEE.pdf [ 61814 ] |
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.
| Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
| Assignee | Alex Nguyen [ alexn ] | Revansiddha Gaur [ revansiddha.gaur ] |
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
| Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Alex Nguyen [ alexn ] |
| Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
| Time Spent | 1,185.5h [ 4267800 ] | 1,193.5h [ 4296600 ] |
| Worklog Id | 79803 [ 79803 ] |
-
- Time Spent:
- 8h
-
Internal discussion with Amit & file correction & delivery.
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
Yogesh Chaudhari (Inactive)
added a comment - - edited Hello Amit Thorve
We will provide change files by tomorrow EOD.
Thanks,
Yogesh Chaudhari
Alex Nguyen Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar | Assignee | Alex Nguyen [ alexn ] | Revansiddha Gaur [ revansiddha.gaur ] |
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
| Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
| Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Alex Nguyen [ alexn ] |
| Time Spent | 1,193.5h [ 4296600 ] | 1,201.5h [ 4325400 ] |
| Worklog Id | 83392 [ 83392 ] |
Yogesh Chaudhari (Inactive)
logged work - 05/Oct/17 01:06 PM -
- Time Spent:
- 2h
-
Testing of Active employee file of Metso
Smita Pawar (Inactive)
logged work - 05/Oct/17 01:26 PM -
- Time Spent:
- 3h
-
Non employee
Active employee file testing
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,201.5h [ 4325400 ] | 1,204.5h [ 4336200 ] |
| Worklog Id | 83435 [ 83435 ] |
-
- Time Spent:
- 8h
-
Metso change file delivery.
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
Yogesh Chaudhari (Inactive)
logged work - 10/Oct/17 01:04 PM -
- Time Spent:
- 7h
-
Making the correction in Metso Active Employee file and provide to client
| Assignee | Alex Nguyen [ alexn ] | Revansiddha Gaur [ revansiddha.gaur ] |
| Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
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
| Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Alex Nguyen [ alexn ] |
| Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
| Time Spent | 1,204.5h [ 4336200 ] | 1,210.5h [ 4357800 ] |
| Worklog Id | 84229 [ 84229 ] |
-
- Time Spent:
- 6h
-
Corrected the change file ,testing & delivery.
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 1,210.5h [ 4357800 ] | 1,217.5h [ 4383000 ] |
| Worklog Id | 84289 [ 84289 ] |
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 1,217.5h [ 4383000 ] | 1,219.5h [ 4390200 ] |
| Worklog Id | 84291 [ 84291 ] |
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.
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
| Time Spent | 1,219.5h [ 4390200 ] | 1,230.5h [ 4429800 ] |
| Worklog Id | 86799 [ 86799 ] |
Thanks Revansiddha Gaur, I will review the files later today.
Alex
-
- Time Spent:
- 11h
-
Weekly change file delivery.
Yogesh Chaudhari (Inactive)
logged work - 26/Oct/17 11:49 PM -
- Time Spent:
- 8h
-
Unit Testing, Discussion with Revan, Analysis of waive employee issue.
-
- Time Spent:
- 2h
-
Metso change file testing.
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 1,230.5h [ 4429800 ] | 1,238.5h [ 4458600 ] |
| Worklog Id | 86983 [ 86983 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,238.5h [ 4458600 ] | 1,242.5h [ 4473000 ] |
| Worklog Id | 87300 [ 87300 ] |
| Time Spent | 1,242.5h [ 4473000 ] | 1,244.5h [ 4480200 ] |
| Worklog Id | 87427 [ 87427 ] |
Smita Pawar (Inactive)
logged work - 30/Oct/17 01:09 PM -
- Time Spent:
- 1h
-
Internal discussion
Client mails go through
Status updates
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
| Assignee | Alex Nguyen [ alexn ] | Revansiddha Gaur [ revansiddha.gaur ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,244.5h [ 4480200 ] | 1,245.5h [ 4483800 ] |
| Worklog Id | 88339 [ 88339 ] |
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
| Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
| Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Alex Nguyen [ alexn ] |
| Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
| Time Spent | 1,245.5h [ 4483800 ] | 1,253.5h [ 4512600 ] |
| Worklog Id | 88793 [ 88793 ] |
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 1,253.5h [ 4512600 ] | 1,258h [ 4528800 ] |
| Worklog Id | 88808 [ 88808 ] |
-
- Time Spent:
- 8h
-
Change file delivery by verifying.
Yogesh Chaudhari (Inactive)
logged work - 03/Nov/17 12:14 AM -
- Time Spent:
- 4.5h
-
Analysis and verification of change employee for Metso change file.
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
| Environment_New | Production [ 18442 ] |
Smita Pawar (Inactive)
logged work - 09/Nov/17 12:39 PM -
- Time Spent:
- 4h
-
Weekly file testing for employee & non employee
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,258h [ 4528800 ] | 1,262h [ 4543200 ] |
| Worklog Id | 89903 [ 89903 ] |
| Assignee | Alex Nguyen [ alexn ] | Revansiddha Gaur [ revansiddha.gaur ] |
| Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
| Attachment | 9Nov_Metso_Weekly_Change_File_Active_NonEE.zip [ 67313 ] |
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
| Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Alex Nguyen [ alexn ] |
| Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
| Time Spent | 1,262h [ 4543200 ] | 1,268h [ 4564800 ] |
| Worklog Id | 89926 [ 89926 ] |
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 1,268h [ 4564800 ] | 1,269.5h [ 4570200 ] |
| Worklog Id | 89954 [ 89954 ] |
-
- Time Spent:
- 6h
-
Metso change file delivery.
| Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
| Resolution | Done [ 10000 ] | |
| Status | In Progress [ 3 ] | Resolved [ 5 ] |
Yogesh Chaudhari (Inactive)
logged work - 10/Nov/17 01:55 AM -
- Time Spent:
- 1.5h
-
Write Script to get change employee list and analysed and discussion for the employee on change file.
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,
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
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,269.5h [ 4570200 ] | 1,272.5h [ 4581000 ] |
| Worklog Id | 91190 [ 91190 ] |
-
- Time Spent:
- 4h
-
Metso weekly file delivery.
| Time Spent | 1,272.5h [ 4581000 ] | 1,276.5h [ 4595400 ] |
| Worklog Id | 91359 [ 91359 ] |
Thank you Revansiddha Gaur. I am doing a quick audit on it now and before posting.
Alex
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,276.5h [ 4595400 ] | 1,281.5h [ 4613400 ] |
| Worklog Id | 91813 [ 91813 ] |
Smita Pawar (Inactive)
made changes -
| Worklog Id | 91813 [ 91813 ] |
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
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,281.5h [ 4613400 ] | 1,285.5h [ 4627800 ] |
| Worklog Id | 92396 [ 92396 ] |
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
Kanchan Jalgaonkar (Inactive)
added a comment - 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
Smita Pawar (Inactive)
logged work - 30/Nov/17 01:19 PM -
- Time Spent:
- 1.25h
-
Discussion
Task allocation
verification
Smita Pawar (Inactive)
made changes -
| Time Spent | 1,285.5h [ 4627800 ] | 1,286.75h [ 4632300 ] |
| Worklog Id | 94069 [ 94069 ] |
Yogesh Chaudhari (Inactive)
logged work - 01/Dec/17 06:18 AM -
- Time Spent:
- 3h
-
Create script to insert into view exported file log, which we exported manually
Yogesh Chaudhari (Inactive)
made changes -
| Time Spent | 1,286.75h [ 4632300 ] | 1,289.75h [ 4643100 ] |
| Worklog Id | 94192 [ 94192 ] |
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
Kanchan Jalgaonkar (Inactive)
added a comment - - edited 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 Smita Pawar (Inactive)
made changes -
| Time Spent | 1,289.75h [ 4643100 ] | 1,290h 5m [ 4644300 ] |
| Worklog Id | 95132 [ 95132 ] |
-
- Time Spent:
- 4h
-
Employee and non employee files testing
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.
| Time Spent | 1,290h 5m [ 4644300 ] | 1,290h 35m [ 4646100 ] |
| Worklog Id | 95368 [ 95368 ] |
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
-
- Time Spent:
- 0.5h
-
Internal discussion on file delivery.
| Time Spent | 1,290h 35m [ 4646100 ] | 1,294h 35m [ 4660500 ] |
| Worklog Id | 98579 [ 98579 ] |
| Description |
Hello [~smita.pawar], New ticket being opened for issue related to previous ticket # EDI-1042. I couldn't reopen the original ticket, so I'm opening a new one to report some records not coming over on the Jan 2017 ACA files. The client has completed the audit, but found a lot of missing records. Looking at some of the dependents in WT, I did saw them enrolled in *HIGHMARK PPO 90-Medical-Highmark* but wasn't on the file. I have uploaded client's audit file *Metso ACA file audit.xlsx* and their comments *Audit of January 2017 Metso ACA file.msg* to the EBS ftp server located in /workterraaca/BSG ACA/Metso ADP/ . I've checked the template *Metso ADP - ACA Employee* but it does show the plan selected along with their classes. Can you review the audit file and client comments, and also take another look at the settings on the three templates? *Metso ADP - ACA Employee* *Metso ADP - ACA Non Employee* *Metso ADP - ACA Multiemployer* I've tried deleting march run dates from template **Metso ADP - ACA Employee* and exported again to see if the records would show up on the file, but they didn't. Those run dates have been added back in the way it was. Thank you, Alex *Carrier contact:* James Camak Product Support III AVS - Health Care Reform 706-731-2319 Tim Fuller FPC, CHRS| Account Manager ADP Health Care Reform 844.237.2221 ext 8172013 tollfree Tim.Fuller@adp.com HCRaccountmanager37@adp.com |
12/29/17 - Last ACA change files will send tonight. ADP is aware the file will be coming and is the last they will receive for 2017. Hello [~smita.pawar], New ticket being opened for issue related to previous ticket # EDI-1042. I couldn't reopen the original ticket, so I'm opening a new one to report some records not coming over on the Jan 2017 ACA files. The client has completed the audit, but found a lot of missing records. Looking at some of the dependents in WT, I did saw them enrolled in *HIGHMARK PPO 90-Medical-Highmark* but wasn't on the file. I have uploaded client's audit file *Metso ACA file audit.xlsx* and their comments *Audit of January 2017 Metso ACA file.msg* to the EBS ftp server located in /workterraaca/BSG ACA/Metso ADP/ . I've checked the template *Metso ADP - ACA Employee* but it does show the plan selected along with their classes. Can you review the audit file and client comments, and also take another look at the settings on the three templates? *Metso ADP - ACA Employee* *Metso ADP - ACA Non Employee* *Metso ADP - ACA Multiemployer* I've tried deleting march run dates from template **Metso ADP - ACA Employee* and exported again to see if the records would show up on the file, but they didn't. Those run dates have been added back in the way it was. Thank you, Alex *Carrier contact:* James Camak Product Support III AVS - Health Care Reform 706-731-2319 Tim Fuller FPC, CHRS| Account Manager ADP Health Care Reform 844.237.2221 ext 8172013 tollfree Tim.Fuller@adp.com HCRaccountmanager37@adp.com |
| Description |
12/29/17 - Last ACA change files will send tonight. ADP is aware the file will be coming and is the last they will receive for 2017. Hello [~smita.pawar], New ticket being opened for issue related to previous ticket # EDI-1042. I couldn't reopen the original ticket, so I'm opening a new one to report some records not coming over on the Jan 2017 ACA files. The client has completed the audit, but found a lot of missing records. Looking at some of the dependents in WT, I did saw them enrolled in *HIGHMARK PPO 90-Medical-Highmark* but wasn't on the file. I have uploaded client's audit file *Metso ACA file audit.xlsx* and their comments *Audit of January 2017 Metso ACA file.msg* to the EBS ftp server located in /workterraaca/BSG ACA/Metso ADP/ . I've checked the template *Metso ADP - ACA Employee* but it does show the plan selected along with their classes. Can you review the audit file and client comments, and also take another look at the settings on the three templates? *Metso ADP - ACA Employee* *Metso ADP - ACA Non Employee* *Metso ADP - ACA Multiemployer* I've tried deleting march run dates from template **Metso ADP - ACA Employee* and exported again to see if the records would show up on the file, but they didn't. Those run dates have been added back in the way it was. Thank you, Alex *Carrier contact:* James Camak Product Support III AVS - Health Care Reform 706-731-2319 Tim Fuller FPC, CHRS| Account Manager ADP Health Care Reform 844.237.2221 ext 8172013 tollfree Tim.Fuller@adp.com HCRaccountmanager37@adp.com |
12/30/17 - There's no changes for non employee file. Only file with records is the active employee file. File was sent successfully: 14:05:32 Status: Connecting to sdgcl.adp.com... 14:05:34 Status: Connected to sdgcl.adp.com 14:05:34 Status: Starting upload of C:\Users\angu\Desktop\EF0597B9DB0007C9_Metsoshare_BenefitsImport_20171230_135805.txt 14:05:34 Status: File transfer successful, transferred 2,428 bytes in 1 second 14:05:35 Status: Retrieving directory listing of "/home/METS3psftpHC/INBOUND"... 14:05:35 Status: Listing directory /home/METS3psftpHC/INBOUND 14:05:35 Status: Directory listing of "/home/METS3psftpHC/INBOUND" successful Closing JIRA as this is the last ACA file of the year. 12/29/17 - Last ACA change files will send tonight. ADP is aware the file will be coming and is the last they will receive for 2017. Hello [~smita.pawar], New ticket being opened for issue related to previous ticket # EDI-1042. I couldn't reopen the original ticket, so I'm opening a new one to report some records not coming over on the Jan 2017 ACA files. The client has completed the audit, but found a lot of missing records. Looking at some of the dependents in WT, I did saw them enrolled in *HIGHMARK PPO 90-Medical-Highmark* but wasn't on the file. I have uploaded client's audit file *Metso ACA file audit.xlsx* and their comments *Audit of January 2017 Metso ACA file.msg* to the EBS ftp server located in /workterraaca/BSG ACA/Metso ADP/ . I've checked the template *Metso ADP - ACA Employee* but it does show the plan selected along with their classes. Can you review the audit file and client comments, and also take another look at the settings on the three templates? *Metso ADP - ACA Employee* *Metso ADP - ACA Non Employee* *Metso ADP - ACA Multiemployer* I've tried deleting march run dates from template **Metso ADP - ACA Employee* and exported again to see if the records would show up on the file, but they didn't. Those run dates have been added back in the way it was. Thank you, Alex *Carrier contact:* James Camak Product Support III AVS - Health Care Reform 706-731-2319 Tim Fuller FPC, CHRS| Account Manager ADP Health Care Reform 844.237.2221 ext 8172013 tollfree Tim.Fuller@adp.com HCRaccountmanager37@adp.com |
| Status | Resolved [ 5 ] | Closed [ 6 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
6d 15h 7m | 1 |
|
50d 22h 43m | 8 |
|
172d 12h 10m | 8 |
|
9s | 1 |
|
50d 21h 30m | 1 |
Mail Copy From FTP- Mail.pdf