-
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
-
-
- Time Spent:
- 2.5h
-
Analysis
File exporting
Updating Jira
Email communication
-
- Time Spent:
- 1.5h
-
Go through the comments & files.
-
- Time Spent:
- 3h
-
Analysis
Internal discussion
Draft
Jira updates
-
- Time Spent:
- 8h
-
Analysis with hspl copy.
-
- Time Spent:
- 1h
-
Working on BSG's feedback issues.
-
- Time Spent:
- 7h
-
Discussion with Amit
File Testing from hspl copy.
-
- Time Spent:
- 2h
-
Discussion with Amit.
Scenario testing for Jan full file.
-
- Time Spent:
- 7.5h
-
Internal discussion with Amit
Waive employee testing.
-
- Time Spent:
- 8.25h
-
Analysis
Internal discussion
Testing Draft
Call with Amit
Jira updates
-
- Time Spent:
- 4.5h
-
Discussion,Correction the entries.
-
- Time Spent:
- 5h
- <No comment>
-
- Time Spent:
- 7h
-
Testing metso files from production
-
- Time Spent:
- 2.5h
-
Replied to mail by analysis the points.
-
- Time Spent:
- 6h
-
Call preparation
File testing
-
- Time Spent:
- 4h
-
- Client Call
- Document verfication of client issue reported.
-
- Time Spent:
- 2h
-
Eligibility Loss Fix for 3 employees & KT to Mahendra for testing.
-
- 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:
- 2h
-
Internal discussion for waiver reason code 06 description blank, Review files after uploading.
-
- Time Spent:
- 6h
- <No comment>
-
- Time Spent:
- 2h
-
call with amit
-
- Time Spent:
- 7h
-
File testing for Jan,Feb and March
-
- Time Spent:
- 6h
- <No comment>
-
- 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:
- 5h
-
File downloading
Customization verification
File testing
Internal discussion
Jira updates
Draft
-
- Time Spent:
- 6h
-
Metso File verification & call
-
- Time Spent:
- 1.5h
-
File changes
Email communication
Draft preparation
Jira update
-
- Time Spent:
- 5h
- <No comment>
-
- Time Spent:
- 8h
- <No comment>
-
- Time Spent:
- 7h
- <No comment>
-
- Time Spent:
- 5h
- <No comment>
-
- Time Spent:
- 6h
-
Worked on client points & reply.
-
- Time Spent:
- 7h
- <No comment>
-
- Time Spent:
- 7h
- <No comment>
-
- Time Spent:
- 6.25h
-
Email communication.
Jira updates
Customization
File verification
-
- Time Spent:
- 5.5h
-
Metso files verification.
-
- Time Spent:
- 6h
- <No comment>
-
- Time Spent:
- 7.5h
-
Email communication
Full File testing
Task allocation
Internal discussion
Jira updates
File uploading
-
- Time Spent:
- 7h
- <No comment>
-
- Time Spent:
- 4h
-
ACA Metso - Employee Full Files testing - 4 hr
-
- Time Spent:
- 7h
-
Check list preparation
Task distribution
File testing
Sending files to client
-
- Time Spent:
- 6h
- <No comment>
-
- Time Spent:
- 1h
-
Internal discussion with Amit
-
- Time Spent:
- 6h
- <No comment>
-
- Time Spent:
- 1h
-
Internal discussion with Amit
-
- 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:
- 8h
-
internal discussion
File testing
Customization
Email communication
-
- 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:
- 6h
-
Metso ACA testing - Employee file
-
- Time Spent:
- 4h
-
Non-employee file testing
-
- Time Spent:
- 8h 10m
-
Testing and file delivery
-
- 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
-
- 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:
- 7.5h
-
active employee file testing.
Discussion with Amit
Customization changes on main company.
-
- Time Spent:
- 5h
-
Customization changes
Customization verification
Internal discussion
Cost verification for few employees
-
- 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:
- 4h
-
Non Employee File testing
-
- Time Spent:
- 7h
-
File testing
Task distribution
Internal discussion
Change file testing scenario discussion
-
- Time Spent:
- 5.5h
-
working on metso files.
-
- Time Spent:
- 9h
-
Call with Amit.
Internal discussion
File testing Employee
Issue analysis
Change file scenarios
Issue list preparation
-
- 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:
- 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:
- 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>
-
- Time Spent:
- 5h
-
Terminated employees file testing for Metso
-
- Time Spent:
- 8h
- <No comment>
-
- 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.
-
- Time Spent:
- 3h
-
Changes suggest by client for terminated employee.
Call with Amit
-
- Time Spent:
- 10h
- <No comment>
-
- 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:
- 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
-
- Time Spent:
- 7h
-
File testing
Manual changes
Internal discussion
Task distribution
-
- Time Spent:
- 7h
-
Discussion with revan.
Merging files with terminated records.
Tested merged file.
-
- 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:
- 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:
- 7h
-
Medical opt-out records certain fields value setting blank implementation for the client said requirement.
-
- Time Spent:
- 8h
- <No comment>
-
- Time Spent:
- 4.5h
-
File delivery with option 2 i.e latest election termination on file
-
- Time Spent:
- 6h
-
Discussion with smita.
Merged employees file with termination of records.
Testing of merged file.
-
- 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:
- 7.5h
-
File testing
Fie delivery
Internal discussion
Task allocation and coordination
-
- Time Spent:
- 7h
-
Metso files post processing automation.
-
- Time Spent:
- 4h
- <No comment>
-
- 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.
-
- Time Spent:
- 4h
- <No comment>
-
- 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:
- 5h
-
1.Internal discussion
2.File delivery
3.File testing
4.Client call
-
- Time Spent:
- 8h
-
Analysis of zero coverage cost issue
-
- Time Spent:
- 1.5h
-
Changed employee name on file.
Tested necessary checks on file.
-
- Time Spent:
- 4h
- <No comment>
-
- Time Spent:
- 8h
-
Change scenarion testing..
-
- Time Spent:
- 3.5h
-
Internal discussion.
Change file setup.
-
- Time Spent:
- 2h
-
File testing
Jira updates
Delivery
-
- Time Spent:
- 8h
-
Metso change file delivery.
-
- Time Spent:
- 4h
- <No comment>
-
- Time Spent:
- 7.5h
-
Metso file exported of change files.
Scenario testing.
-
- Time Spent:
- 6h
- <No comment>
-
- Time Spent:
- 6h
-
Employee & Non employee file testing
Delivery
Task distribution & allocation
-
- Time Spent:
- 1h
-
merging of employee records
testing of merged records
-
- 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.
-
- 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:
- 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
-
- Time Spent:
- 4h
-
Analysis
Internal discussion
Reply to amit
-
- Time Spent:
- 1h
-
File merging with terminated records COVG and OFFER rows.
-
- Time Spent:
- 8h
-
Exported files for Metso from 1st Jan 2017 to 11 July 2017
-
- Time Spent:
- 3h
-
File testing
Comparison testing
Jira updates
Client reply
File delivery
-
- Time Spent:
- 4h
-
Internal discussion
Draft & reply to client
Manual changes in file
Uploading file to FTP
-
- 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.
-
- 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:
- 1h
-
Meeting with Amit and Nandu to discuss about file.
-
- Time Spent:
- 6h
-
Change file generation & analysis as per new requirement.
-
- Time Spent:
- 2h
-
file review and pur comments replay to client
-
- Time Spent:
- 6h
-
Analysis and discussion with Revan and Nandu to export change file for active employee
Export change file Active employee
-
- 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:
- 6h
-
1.Change file testing for Employee & Non employee files
-
- 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
-
- 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:
- 3.5h
-
Analysis and discussion with Revan to avoid duplicate event in Metso file.
Analysis of populating zero cost on file.
-
- Time Spent:
- 3.5h
-
Duplicate event analysis & testing ,
-
- Time Spent:
- 8h
-
Analysis of employee coverage populating with zero cost and completed this.
-
- Time Spent:
- 1.5h
-
Analysis of client feed back
Client reply
-
- Time Spent:
- 6h
-
Change file scenario testing & Internal discussion for identified issue like duplicate events & solutions.
-
- Time Spent:
- 2h
-
Completed analysis of employee coverage populating with zero cost and completed this
-
- Time Spent:
- 2h
-
Duplicate event implementation unit testing.
-
- Time Spent:
- 2h
-
Discussion with smita.
Tested changed file of metso.
-
- Time Spent:
- 3.5h
-
Work on the Metso change file for analysis.
-
- Time Spent:
- 4h
-
Testing
Draft
Internal discussion
-
- Time Spent:
- 8h
-
Metso change file delivery 01012017 to 08042017[Active & NonEE].
-
- Time Spent:
- 2h
-
File testing
Analysis
Jira updates
-
- Time Spent:
- 1h
-
Discussion with revan about metso file changes
-
- Time Spent:
- 4.5h
-
Analysis & discussion & deliver the file.
-
- Time Spent:
- 1h
-
Intenal communication
Verification
Analysis
-
- Time Spent:
- 8h
-
Metso reply on feedback.
-
- Time Spent:
- 8h
-
Received feedback on full file & change file shared our feedback.
-
- Time Spent:
- 6h
-
Analysis of employee queries reported by the client
Discussion with team about queries reported by client.
-
- Time Spent:
- 5.5h
-
Provided updated change file to Metso.
-
- Time Spent:
- 10h
-
Metso change File delivery-Active & Non EE.
-
- Time Spent:
- 3h
-
Internal discussion
Testing
Analysis
-
- Time Spent:
- 1.75h
-
Call with Amit
Internal discussion
Analysis
-
- Time Spent:
- 5.5h
-
Worked on Metso file to analysis 11 employee whose CoverageStartDate = Event Date.
-
- 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.
-
- Time Spent:
- 20m
-
Internal discussion & jira reply.
-
- Time Spent:
- 3.5h
-
Discussion with Revan about loss of eligibility scenarios.
-
- Time Spent:
- 1h
-
Analysis and discussion with Revan about issues reported by client
-
- Time Spent:
- 5h
-
Analysis on client comments & reply.
-
- Time Spent:
- 2h
-
Analysis of multiple offer records on Metso fIle.
-
- Time Spent:
- 1.5h
-
Jira Feedback checked & Internal discussion with Amit.
-
- Time Spent:
- 8h
-
Internal discussion with Amit & file correction & delivery.
-
- Time Spent:
- 2h
-
Testing of Active employee file of Metso
-
- Time Spent:
- 3h
-
Non employee
Active employee file testing
-
- Time Spent:
- 8h
-
Metso change file delivery.
-
- Time Spent:
- 7h
-
Making the correction in Metso Active Employee file and provide to client
-
- Time Spent:
- 6h
-
Corrected the change file ,testing & delivery.
-
- Time Spent:
- 11h
-
Weekly change file delivery.
-
- Time Spent:
- 8h
-
Unit Testing, Discussion with Revan, Analysis of waive employee issue.
-
- Time Spent:
- 2h
-
Metso change file testing.
-
- Time Spent:
- 1h
-
Internal discussion
Client mails go through
Status updates
-
- Time Spent:
- 8h
-
Change file delivery by verifying.
-
- Time Spent:
- 4.5h
-
Analysis and verification of change employee for Metso change file.
-
- Time Spent:
- 4h
-
Weekly file testing for employee & non employee
-
- Time Spent:
- 6h
-
Metso change file delivery.
-
- Time Spent:
- 1.5h
-
Write Script to get change employee list and analysed and discussion for the employee on change file.
-
- Time Spent:
- 4h
-
Metso weekly file delivery.
-
- Time Spent:
- 1.25h
-
Discussion
Task allocation
verification
-
- Time Spent:
- 3h
-
Create script to insert into view exported file log, which we exported manually
-
- Time Spent:
- 4h
-
Employee and non employee files testing
-
- Time Spent:
- 0.5h
-
Internal discussion on file delivery.