-
Type:
Support Activity
-
Status: Resolved
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: ACA
-
Labels:None
-
Support Task Type:Configuration
-
Environment:Production
-
Reported by:Support
-
Company:Prime Healthcare - Southern Regional
-
Module:ACA
-
Issue Importance:Must Have
Currently we have a file export for Prime (Space) for the EQUIFAX ACA items.
We now have a file export for Prime (no space) Healthcare as well, which includes the following facilities:
Suburban (2/1/2016)
Lake Huron (effective 1/1/16)
Garden City HGC
Garden City PMG
Providence Medical Center
Providence Place
Saint John Hospital
United Home Health Services
Please provide 2017 files going forward, scheduled for the 10th of each month.
Thank you!
Amber
-
- Time Spent:
- 1h
-
Analysis
Internal discussion
Field | Original Value | New Value |
---|---|---|
Component/s | ACA [ 10004 ] |
Module | Parent values: BenAdmin(10100) | Parent values: ACA(10104) |
-
- Time Spent:
- 3h
- <No comment>
-
- Time Spent:
- 7.5h
-
File verification & delivery to qa
Attachment | Copy of Book1 (3).xlsx [ 39173 ] |
Assignee | Yogesh Chaudhari [ yogesh.chaudhari ] | Rakesh Roy [ rakeshr ] |
Assignee | Rakesh Roy [ rakeshr ] | Smita Pawar [ smita.pawar ] |
Remaining Estimate | 166h [ 597600 ] | |
Original Estimate | 166h [ 597600 ] |
Remaining Estimate | 166h [ 597600 ] | 158.5h [ 570600 ] |
Time Spent | 7.5h [ 27000 ] | |
Worklog Id | 23430 [ 23430 ] |
Attachment | Prime plan list 2017.xlsx [ 39186 ] |
-
- Time Spent:
- 0.5h
-
Discussion with nandu and revan
Status | Open [ 1 ] | Waiting for Customer Input [ 10500 ] |
Assignee | Smita Pawar [ smita.pawar ] | Amber Love-Jones [ alov ] |
Remaining Estimate | 158.5h [ 570600 ] | 158h [ 568800 ] |
Time Spent | 7.5h [ 27000 ] | 8h [ 28800 ] |
Worklog Id | 23496 [ 23496 ] |
Attachment | EIN_List_Employee_Count.xls [ 39213 ] |
Attachment | EIN_List_Dependent_Count.xls [ 39214 ] |
-
- Time Spent:
- 1h
-
Internal Discussion,EIN wise Record Count list out.
Assignee | Amber Love-Jones [ alov ] | Mahendra Mungase [ mahendra.mungase ] |
Assignee | Mahendra Mungase [ mahendra.mungase ] | Smita Pawar [ smita.pawar ] |
Remaining Estimate | 158h [ 568800 ] | 157h [ 565200 ] |
Time Spent | 8h [ 28800 ] | 9h [ 32400 ] |
Worklog Id | 23624 [ 23624 ] |
-
- Time Spent:
- 7.5h
-
2017 Plan verification on multiple company
Attachment | 309 Employees Analysis Feedback.xls [ 39313 ] |
Attachment | Copy of workterra compliance_2016.xlsx [ 39335 ] |
-
- Time Spent:
- 8.5h
-
309 Employees Analysis & Reply
Attachment | 309 Employees Analysis Feedback (1)-UPDATED.xls [ 39361 ] |
Assignee | Smita Pawar [ smita.pawar ] | Mahendra Mungase [ mahendra.mungase ] |
Assignee | Mahendra Mungase [ mahendra.mungase ] | Smita Pawar [ smita.pawar ] |
Remaining Estimate | 157h [ 565200 ] | 148.5h [ 534600 ] |
Time Spent | 9h [ 32400 ] | 17.5h [ 63000 ] |
Worklog Id | 23840 [ 23840 ] |
Assignee | Smita Pawar [ smita.pawar ] | Revansiddha Gaur [ revansiddha.gaur ] |
-
- Time Spent:
- 2h
-
Discussion on Jan 2017 prime file
-
- Time Spent:
- 7h
- <No comment>
Remaining Estimate | 148.5h [ 534600 ] | 148h [ 532800 ] |
Time Spent | 17.5h [ 63000 ] | 18h [ 64800 ] |
Worklog Id | 24016 [ 24016 ] |
-
- Time Spent:
- 4h 25m
-
Prime file testing
Attachment | Latest_Analysis_Of_309_Employees_Feedback.zip [ 39426 ] |
Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
-
- Time Spent:
- 4h
-
Analysis of 7 employees & feedback
Remaining Estimate | 148h [ 532800 ] | 144h [ 518400 ] |
Time Spent | 18h [ 64800 ] | 22h [ 79200 ] |
Worklog Id | 24222 [ 24222 ] |
Remaining Estimate | 144h [ 518400 ] | 136.5h [ 491400 ] |
Time Spent | 22h [ 79200 ] | 29.5h [ 106200 ] |
Worklog Id | 24223 [ 24223 ] |
Remaining Estimate | 136.5h [ 491400 ] | 134.5h [ 484200 ] |
Time Spent | 29.5h [ 106200 ] | 31.5h [ 113400 ] |
Worklog Id | 24231 [ 24231 ] |
-
- Time Spent:
- 6.5h
-
Analysis on 309 employee data
Remaining Estimate | 134.5h [ 484200 ] | 128h [ 460800 ] |
Time Spent | 31.5h [ 113400 ] | 38h [ 136800 ] |
Worklog Id | 24245 [ 24245 ] |
Remaining Estimate | 128h [ 460800 ] | 125h [ 450000 ] |
Time Spent | 38h [ 136800 ] | 41h [ 147600 ] |
Worklog Id | 24251 [ 24251 ] |
Remaining Estimate | 125h [ 450000 ] | 118h [ 424800 ] |
Time Spent | 41h [ 147600 ] | 48h [ 172800 ] |
Worklog Id | 24254 [ 24254 ] |
-
- Time Spent:
- 7h
- <No comment>
Remaining Estimate | 118h [ 424800 ] | 111h [ 399600 ] |
Time Spent | 48h [ 172800 ] | 55h [ 198000 ] |
Worklog Id | 24255 [ 24255 ] |
-
- Time Spent:
- 8h
- <No comment>
Remaining Estimate | 111h [ 399600 ] | 107h [ 385200 ] |
Time Spent | 55h [ 198000 ] | 59h [ 212400 ] |
Worklog Id | 24492 [ 24492 ] |
Remaining Estimate | 107h [ 385200 ] | 99.5h [ 358200 ] |
Time Spent | 59h [ 212400 ] | 66.5h [ 239400 ] |
Worklog Id | 24643 [ 24643 ] |
Remaining Estimate | 99.5h [ 358200 ] | 95h 5m [ 342300 ] |
Time Spent | 66.5h [ 239400 ] | 70h 55m [ 255300 ] |
Worklog Id | 24647 [ 24647 ] |
Worklog Id | 24647 [ 24647 ] |
-
- Time Spent:
- 10.5h
-
File generation for Landmark for 4 months.
-
- Time Spent:
- 10h
- <No comment>
Remaining Estimate | 95h 5m [ 342300 ] | 84h 35m [ 304500 ] |
Time Spent | 70h 55m [ 255300 ] | 81h 25m [ 293100 ] |
Worklog Id | 24725 [ 24725 ] |
Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Amber Love-Jones [ alov ] |
Remaining Estimate | 84h 35m [ 304500 ] | 82h 35m [ 297300 ] |
Time Spent | 81h 25m [ 293100 ] | 83h 25m [ 300300 ] |
Worklog Id | 25063 [ 25063 ] |
Remaining Estimate | 82h 35m [ 297300 ] | 74h 35m [ 268500 ] |
Time Spent | 83h 25m [ 300300 ] | 91h 25m [ 329100 ] |
Worklog Id | 25090 [ 25090 ] |
Remaining Estimate | 74h 35m [ 268500 ] | 64h 35m [ 232500 ] |
Time Spent | 91h 25m [ 329100 ] | 101h 25m [ 365100 ] |
Worklog Id | 25093 [ 25093 ] |
Attachment | Copy of IRS check off with password.xlsx [ 40654 ] |
Assignee | Amber Love-Jones [ alov ] | Smita Pawar [ smita.pawar ] |
Assignee | Smita Pawar [ smita.pawar ] | Revansiddha Gaur [ revansiddha.gaur ] |
Attachment | List of EINs to include or exclude for Year 2017 Prime Files.xlsx [ 40722 ] |
Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Amber Love-Jones [ alov ] |
Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
Remaining Estimate | 64h 35m [ 232500 ] | 58h 5m [ 209100 ] |
Time Spent | 101h 25m [ 365100 ] | 107h 55m [ 388500 ] |
Worklog Id | 27239 [ 27239 ] |
Remaining Estimate | 58h 5m [ 209100 ] | 57h 35m [ 207300 ] |
Time Spent | 107h 55m [ 388500 ] | 108h 25m [ 390300 ] |
Worklog Id | 27239 [ 27239 ] |
-
- Time Spent:
- 7h
-
Analysis, discussion & reply.
Attachment | Copy of Dec2016_EMP_with password.xls [ 40745 ] |
Assignee | Amber Love-Jones [ alov ] | Revansiddha Gaur [ revansiddha.gaur ] |
Remaining Estimate | 57h 35m [ 207300 ] | 57h 5m [ 205500 ] |
Time Spent | 108h 25m [ 390300 ] | 108h 55m [ 392100 ] |
Worklog Id | 28025 [ 28025 ] |
-
- Time Spent:
- 3h
- <No comment>
Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
Remaining Estimate | 57h 5m [ 205500 ] | 54h 5m [ 194700 ] |
Time Spent | 108h 55m [ 392100 ] | 111h 55m [ 402900 ] |
Worklog Id | 29127 [ 29127 ] |
Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Amber Love-Jones [ alov ] |
Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
Attachment | screenshot-1.png [ 41511 ] |
Assignee | Amber Love-Jones [ alov ] | Revansiddha Gaur [ revansiddha.gaur ] |
-
- Time Spent:
- 6h
- <No comment>
Remaining Estimate | 54h 5m [ 194700 ] | 47h 5m [ 169500 ] |
Time Spent | 111h 55m [ 402900 ] | 118h 55m [ 428100 ] |
Worklog Id | 29333 [ 29333 ] |
Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
Remaining Estimate | 47h 5m [ 169500 ] | 40h 5m [ 144300 ] |
Time Spent | 118h 55m [ 428100 ] | 125h 55m [ 453300 ] |
Worklog Id | 29589 [ 29589 ] |
Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Amber Love-Jones [ alov ] |
Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
-
- Time Spent:
- 7.5h
-
File Verification & Discrepancy details posted on JIRA for client feedback.
Assignee | Amber Love-Jones [ alov ] | Revansiddha Gaur [ revansiddha.gaur ] |
Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
Remaining Estimate | 40h 5m [ 144300 ] | 32h 35m [ 117300 ] |
Time Spent | 125h 55m [ 453300 ] | 133h 25m [ 480300 ] |
Worklog Id | 29859 [ 29859 ] |
Worklog Id | 29859 [ 29859 ] |
Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Amber Love-Jones [ alov ] |
Comment |
[ Hi [~alov] We have uploaded Prime Files for Jan 2017 on FTP. URL: https://ftpsecure.ebsbenefits.com Path:/users/workterraaca/Prime/Prime_facility_03092017 Please review the files and let us know your feed back on same. Once Jan 17 file will pass , we will share next file. CC- [~sachin.hingole] [~nandkumar] [~revansiddha.gaur] [~smita.pawar] [~kumar.chhajed] Thanks ] |
-
- Time Spent:
- 10.75h
-
Jan & feb file process.
Remaining Estimate | 32h 35m [ 117300 ] | 21h 50m [ 78600 ] |
Time Spent | 133h 25m [ 480300 ] | 144h 10m [ 519000 ] |
Worklog Id | 30141 [ 30141 ] |
Assignee | Amber Love-Jones [ alov ] | Revansiddha Gaur [ revansiddha.gaur ] |
Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Smita Pawar [ smita.pawar ] |
Remaining Estimate | 21h 50m [ 78600 ] | 16h 20m [ 58800 ] |
Time Spent | 144h 10m [ 519000 ] | 149h 40m [ 538800 ] |
Worklog Id | 30312 [ 30312 ] |
-
- Time Spent:
- 3h
-
1.Jira updates
2.File upload
3.Jan file testing
Remaining Estimate | 16h 20m [ 58800 ] | 13h 20m [ 48000 ] |
Time Spent | 149h 40m [ 538800 ] | 152h 40m [ 549600 ] |
Worklog Id | 30361 [ 30361 ] |
Remaining Estimate | 13h 20m [ 48000 ] | 10h 20m [ 37200 ] |
Time Spent | 152h 40m [ 549600 ] | 155h 40m [ 560400 ] |
Worklog Id | 30372 [ 30372 ] |
-
- Time Spent:
- 5.5h
-
Files-Feb Change File generation & verification.
Remaining Estimate | 10h 20m [ 37200 ] | 4h 20m [ 15600 ] |
Time Spent | 155h 40m [ 560400 ] | 161h 40m [ 582000 ] |
Worklog Id | 31680 [ 31680 ] |
Assignee | Smita Pawar [ smita.pawar ] | Revansiddha Gaur [ revansiddha.gaur ] |
Remaining Estimate | 4h 20m [ 15600 ] | 4h [ 14400 ] |
Time Spent | 161h 40m [ 582000 ] | 162h [ 583200 ] |
Worklog Id | 33410 [ 33410 ] |
Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Amber Love-Jones [ alov ] |
Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
Remaining Estimate | 4h [ 14400 ] | 3.5h [ 12600 ] |
Time Spent | 162h [ 583200 ] | 162.5h [ 585000 ] |
Worklog Id | 33639 [ 33639 ] |
Worklog Id | 33639 [ 33639 ] |
Attachment | screenshot-2.png [ 43303 ] |
Assignee | Amber Love-Jones [ alov ] | Jennifer Fernandes [ jjsassy99 ] |
Remaining Estimate | 3.5h [ 12600 ] | 0h [ 0 ] |
Time Spent | 162.5h [ 585000 ] | 169.5h [ 610200 ] |
Worklog Id | 35426 [ 35426 ] |
Assignee | Jennifer Fernandes [ jjsassy99 ] | Smita Pawar [ smita.pawar ] |
Assignee | Smita Pawar [ smita.pawar ] | Revansiddha Gaur [ revansiddha.gaur ] |
Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Amber Love-Jones [ alov ] |
Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
Time Spent | 169.5h [ 610200 ] | 176.5h [ 635400 ] |
Worklog Id | 37584 [ 37584 ] |
Time Spent | 176.5h [ 635400 ] | 184.5h [ 664200 ] |
Worklog Id | 37934 [ 37934 ] |
Assignee | Amber Love-Jones [ alov ] | Revansiddha Gaur [ revansiddha.gaur ] |
-
- Time Spent:
- 6h
-
Call Document Preparation.
Time Spent | 184.5h [ 664200 ] | 190.5h [ 685800 ] |
Worklog Id | 38533 [ 38533 ] |
-
- Time Spent:
- 2h
- <No comment>
-
- Time Spent:
- 3h
-
Analysis
Discussion with Revan
Call preparation
EIN verificationwith Check list
-
- Time Spent:
- 2h
-
internal discussion,jira reply updates.
Time Spent | 190.5h [ 685800 ] | 192.5h [ 693000 ] |
Worklog Id | 39534 [ 39534 ] |
-
- Time Spent:
- 5h
-
Ana;lysis
Customization checking
Template verification
Issue locking
Internal discussion
Time Spent | 192.5h [ 693000 ] | 194.5h [ 700200 ] |
Worklog Id | 41657 [ 41657 ] |
Time Spent | 194.5h [ 700200 ] | 199.5h [ 718200 ] |
Worklog Id | 42209 [ 42209 ] |
Time Spent | 199.5h [ 718200 ] | 202.5h [ 729000 ] |
Worklog Id | 42619 [ 42619 ] |
Time Spent | 202.5h [ 729000 ] | 203.5h [ 732600 ] |
Worklog Id | 42623 [ 42623 ] |
Worklog Id | 42623 [ 42623 ] |
Attachment | WT-8076 Screenshots.docx [ 47486 ] |
Time Spent | 203.5h [ 732600 ] | 205h [ 738000 ] |
Worklog Id | 44279 [ 44279 ] |
Worklog Id | 44279 [ 44279 ] |
-
- Time Spent:
- 1.5h
- <No comment>
Attachment | JIRA - WT-8076 with password.docx [ 47677 ] |
Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Amber Love-Jones [ alov ] |
Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
Time Spent | 205h [ 738000 ] | 206h [ 741600 ] |
Worklog Id | 47791 [ 47791 ] |
-
- Time Spent:
- 4.5h
-
Working on client comments implementation.
Time Spent | 206h [ 741600 ] | 210.5h [ 757800 ] |
Worklog Id | 47800 [ 47800 ] |
-
- Time Spent:
- 5h
-
Checklist preparation for prime automation
Time Spent | 210.5h [ 757800 ] | 216h [ 777600 ] |
Worklog Id | 48152 [ 48152 ] |
Attachment | Reno Tahoe Anesthesia JIRA screenshot with password.docx [ 48978 ] |
Assignee | Amber Love-Jones [ alov ] | Revansiddha Gaur [ revansiddha.gaur ] |
Attachment | EmployeePresentInMultipleCompany.xlsx [ 49176 ] |
Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Amber Love-Jones [ alov ] |
Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
Time Spent | 216h [ 777600 ] | 217h [ 781200 ] |
Worklog Id | 48567 [ 48567 ] |
Time Spent | 217h [ 781200 ] | 222h [ 799200 ] |
Worklog Id | 48788 [ 48788 ] |
Assignee | Amber Love-Jones [ alov ] | Revansiddha Gaur [ revansiddha.gaur ] |
Company | Prime Healthcare [ 10517 ] | Prime Healthcare - Southern Regional [ 10607 ] |
-
- Time Spent:
- 3h
-
Customization & general export testing to fetch the file
-
- Time Spent:
- 11h
-
Worked to export Prime full file for Jan.
Compare manual and file from the export feature.
Worked to export file on local machine
-
- Time Spent:
- 4h
-
Prime Healthcare ACA Files Testing the Cases provided by QA Team- 4 hr
-
- Time Spent:
- 5.5h
-
Testing prime files of local environment.
-
- Time Spent:
- 16h
-
Call with EBS for prime queries.
File generation using automation.
-
- Time Spent:
- 8h
-
Task allocation
Internal discussion
File Testing
Checklist review
Time Spent | 222h [ 799200 ] | 226h [ 813600 ] |
Worklog Id | 52760 [ 52760 ] |
Time Spent | 226h [ 813600 ] | 242h [ 871200 ] |
Worklog Id | 52768 [ 52768 ] |
-
- Time Spent:
- 6.5h
-
Discussion and overview of the Test Cases with Smita and Nandakumar - 40 min
Prime HealthCare ACA Files Testing - January Full files testing started- 6 hr
-
- Time Spent:
- 8h
-
File testing
Checklist review
Internal discussion
Analysis
Time Spent | 242h [ 871200 ] | 250h [ 900000 ] |
Worklog Id | 53020 [ 53020 ] |
-
- Time Spent:
- 8h
-
Testing prime files exported from production.
-
- Time Spent:
- 6h
-
Testing ACA Prime files January
-
- Time Spent:
- 8h
- <No comment>
Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
-
- Time Spent:
- 9h
-
Exported the full file for Jan -2017 and also created script to get change file
Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Yogesh Chaudhari [ yogesh.chaudhari ] |
-
- Time Spent:
- 7h
-
PrimeHealth Care ACA Files - 7 hr
January - Full files
-
- Time Spent:
- 2h
-
Testing prime files exported from production.
-
- Time Spent:
- 7h
-
Testing ACA Prime Full files January
-
- Time Spent:
- 3h
-
Jan file testing - Employee & Dependent
Jan file Delivery to client
Testing of Feb file Active employee
Time Spent | 250h [ 900000 ] | 255.5h [ 919800 ] |
Worklog Id | 53496 [ 53496 ] |
Time Spent | 255.5h [ 919800 ] | 263.5h [ 948600 ] |
Worklog Id | 53497 [ 53497 ] |
-
- Time Spent:
- 8h
-
Exported change for Feb-2017 and unit test records from the Feb file
Time Spent | 263.5h [ 948600 ] | 265.5h [ 955800 ] |
Worklog Id | 53498 [ 53498 ] |
Time Spent | 265.5h [ 955800 ] | 273.5h [ 984600 ] |
Worklog Id | 53500 [ 53500 ] |
Time Spent | 273.5h [ 984600 ] | 282.5h [ 1017000 ] |
Worklog Id | 53501 [ 53501 ] |
-
- Time Spent:
- 7h
-
Testing feb file as per checklist provided.
-
- Time Spent:
- 7h
-
PrimeHealth Care ACA Files - 7 hr
Feb files
Reporting Descrepancies observed with Nandakumar
Yogesh
Finding records
Performing 46 QA Checks provided by QA Team
Discussion of some issues observed
Time Spent | 282.5h [ 1017000 ] | 293.5h [ 1056600 ] |
Worklog Id | 53689 [ 53689 ] |
-
- Time Spent:
- 8h
-
Export change files of Prime for March,April and May 2017
-
- Time Spent:
- 7h
-
Testing PrimeACA files for Feb
testing the Checklist provided
sampling
discussion with Prashant
-
- Time Spent:
- 7h
-
Testing april and may file as per checklist provided.
-
- Time Spent:
- 7h
-
PrimeHealth Care ACA Files - 7 hr
April May Files files
Reporting Descrepancies observed with Nandakumar
Yogesh
Finding records
Performing 46 QA Checks provided by QA Team
Discussion of some issues observedConfirming all the files and uploading on ftp site and sending updates to Amber Love Jones
-
- Time Spent:
- 8h
-
Analysis of employees provided by client and share detail analysis with client
-
- Time Spent:
- 6h
-
Testing ACA files for April and May
testing the checklist
sampling
discussion with prashant
Time Spent | 293.5h [ 1056600 ] | 300.5h [ 1081800 ] |
Worklog Id | 54293 [ 54293 ] |
Time Spent | 300.5h [ 1081800 ] | 307.5h [ 1107000 ] |
Worklog Id | 54294 [ 54294 ] |
Time Spent | 307.5h [ 1107000 ] | 314.5h [ 1132200 ] |
Worklog Id | 54295 [ 54295 ] |
Time Spent | 314.5h [ 1132200 ] | 321h [ 1155600 ] |
Worklog Id | 54307 [ 54307 ] |
Time Spent | 321h [ 1155600 ] | 328h [ 1180800 ] |
Worklog Id | 54308 [ 54308 ] |
Time Spent | 328h [ 1180800 ] | 334h [ 1202400 ] |
Worklog Id | 54310 [ 54310 ] |
Time Spent | 334h [ 1202400 ] | 341h [ 1227600 ] |
Worklog Id | 54319 [ 54319 ] |
Time Spent | 341h [ 1227600 ] | 347h [ 1249200 ] |
Worklog Id | 54321 [ 54321 ] |
Worklog Id | 54321 [ 54321 ] |
Time Spent | 347h [ 1249200 ] | 355h [ 1278000 ] |
Worklog Id | 54359 [ 54359 ] |
Time Spent | 355h [ 1278000 ] | 362h [ 1303200 ] |
Worklog Id | 54408 [ 54408 ] |
Time Spent | 362h [ 1303200 ] | 369h [ 1328400 ] |
Worklog Id | 54409 [ 54409 ] |
Attachment | Prime_Duplicate_Active_Employee_List.zip [ 51852 ] |
Attachment | IRS_EveryDayCoverage.jpg [ 51853 ] |
-
- Time Spent:
- 4h
-
Analysis of Prime files and send reply to client
-
- Time Spent:
- 6h
- <No comment>
-
- Time Spent:
- 6h
- <No comment>
-
- Time Spent:
- 8h
-
Analysis of 20 employees provided by client and reply to them
Attachment | ACA 8076 Missing from January File.docx [ 52290 ] |
Attachment | ACA 8076_Missing_January File_HB_Updated.xls [ 52366 ] |
-
- Time Spent:
- 7h
-
Analysis of Prime 20 employees provided
Time Spent | 369h [ 1328400 ] | 375h [ 1350000 ] |
Worklog Id | 57049 [ 57049 ] |
Time Spent | 375h [ 1350000 ] | 381h [ 1371600 ] |
Worklog Id | 57050 [ 57050 ] |
Time Spent | 381h [ 1371600 ] | 388h [ 1396800 ] |
Worklog Id | 57264 [ 57264 ] |
Attachment | ACA 8076_EEs missing from January FIle.docx [ 53006 ] |
-
- Time Spent:
- 2h
- <No comment>
Attachment | UPDATED_Prime_Duplicate_Active_Employee_List.zip [ 53072 ] |
Attachment | HB_UPDATED_ACA 8076_EEs missing from January FIle.doc [ 53144 ] |
-
- Time Spent:
- 8h
-
Analysis of Employees those are missing from file.
Provide duplicate active employee list
Call with onshore team
Time Spent | 388h [ 1396800 ] | 396h [ 1425600 ] |
Worklog Id | 57659 [ 57659 ] |
Time Spent | 396h [ 1425600 ] | 400h [ 1440000 ] |
Worklog Id | 57668 [ 57668 ] |
Time Spent | 400h [ 1440000 ] | 408h [ 1468800 ] |
Worklog Id | 57670 [ 57670 ] |
Time Spent | 408h [ 1468800 ] | 416h [ 1497600 ] |
Worklog Id | 57676 [ 57676 ] |
-
- Time Spent:
- 2h
- <No comment>
Time Spent | 416h [ 1497600 ] | 424h [ 1526400 ] |
Worklog Id | 58033 [ 58033 ] |
Attachment | RE KMC ACA REPORTING FOR 2017.msg [ 53371 ] |
Attachment | Terminated employees.msg [ 53372 ] |
Attachment | Clean Up 6-2017.xlsx [ 53374 ] |
Time Spent | 424h [ 1526400 ] | 430h [ 1548000 ] |
Worklog Id | 58300 [ 58300 ] |
Time Spent | 430h [ 1548000 ] | 433h [ 1558800 ] |
Worklog Id | 58417 [ 58417 ] |
Time Spent | 433h [ 1558800 ] | 441h [ 1587600 ] |
Worklog Id | 58424 [ 58424 ] |
Time Spent | 441h [ 1587600 ] | 444h [ 1598400 ] |
Worklog Id | 58429 [ 58429 ] |
Time Spent | 444h [ 1598400 ] | 448h [ 1612800 ] |
Worklog Id | 58430 [ 58430 ] |
-
- Time Spent:
- 3h
-
Task discussion
Meeting
KT
Client reply
Review
Time Spent | 448h [ 1612800 ] | 450h [ 1620000 ] |
Worklog Id | 58699 [ 58699 ] |
Time Spent | 450h [ 1620000 ] | 452h [ 1627200 ] |
Worklog Id | 58700 [ 58700 ] |
Time Spent | 452h [ 1627200 ] | 454h [ 1634400 ] |
Worklog Id | 58721 [ 58721 ] |
Attachment | Prime analysis KMC HMC .xls [ 53662 ] |
Attachment | Prime analysis KMC HMC.zip [ 53663 ] |
Attachment | Prime analysis KMC HMC.zip [ 53663 ] |
Attachment | Prime analysis KMC HMC .xls [ 53662 ] |
Attachment | Prime analysis KMC HMC.zip [ 53664 ] |
-
- Time Spent:
- 6h
-
Discussion with smita.
Analysis of duplicated employees enrollments and eligibility on KMC and HMC.
-
- Time Spent:
- 2h
- <No comment>
Time Spent | 454h [ 1634400 ] | 460h [ 1656000 ] |
Worklog Id | 59001 [ 59001 ] |
Attachment | Dev_D. Fleury emails 6.21.2017 with password.xlsx [ 53693 ] |
Time Spent | 460h [ 1656000 ] | 463h [ 1666800 ] |
Worklog Id | 59157 [ 59157 ] |
Attachment | Dev_UPDATED Report from Prime 6.30.xlsx [ 53899 ] |
-
- Time Spent:
- 1h
-
As discussed with revan verified prime aca template for specific facility for checking performance issue.
-
- Time Spent:
- 8h
-
Did analysis of HMC,CHMC employees
-
- Time Spent:
- 8h
-
Did the analysis of CHMC 52 employees and send detail report to client
Attachment | Coshocton_ACA_Customization.jpg [ 54208 ] |
Attachment | Analysis_Dev_UPDATED_Prime 6.30.zip [ 54210 ] |
-
- Time Spent:
- 1.5h
-
Employee analysis and reply
Time Spent | 463h [ 1666800 ] | 464.5h [ 1672200 ] |
Worklog Id | 60992 [ 60992 ] |
Time Spent | 464.5h [ 1672200 ] | 468.5h [ 1686600 ] |
Worklog Id | 60993 [ 60993 ] |
-
- Time Spent:
- 7h
-
Analysis of Coshocton 72 employees and provide detail report to client
Time Spent | 468.5h [ 1686600 ] | 476.5h [ 1715400 ] |
Worklog Id | 61025 [ 61025 ] |
Time Spent | 476.5h [ 1715400 ] | 484.5h [ 1744200 ] |
Worklog Id | 61026 [ 61026 ] |
Time Spent | 484.5h [ 1744200 ] | 492.5h [ 1773000 ] |
Worklog Id | 61027 [ 61027 ] |
Worklog Id | 61027 [ 61027 ] |
Remaining Estimate | 0h [ 0 ] | 1h [ 3600 ] |
Time Spent | 492.5h [ 1773000 ] | 491.5h [ 1769400 ] |
Worklog Id | 61025 [ 61025 ] |
-
- Time Spent:
- 8h
-
Analysis of Providence Medical center employee and send to client
Attachment | Analysis_Proviedence_Medical_Center.zip [ 54396 ] |
Attachment | screenshot-3.png [ 54412 ] |
-
- Time Spent:
- 8h
-
Worked on the issue reported by client and provide feedback on the queries.
-
- Time Spent:
- 8h
-
Analysis of prime employees and send some of the examples to client for review.
-
- Time Spent:
- 6h
-
Prime ACA automation.
Exported file and tested according to checklist.
Attachment | Analysis_Dev_UPDATED_Prime 6.30_for Development.xls [ 54805 ] |
Attachment | Analysis_Dev_UPDATED_Prime 6.xls [ 54806 ] |
-
- Time Spent:
- 4h
- <No comment>
-
- Time Spent:
- 3.5h
-
Tested prime file according to checklist.
-
- Time Spent:
- 2h
- <No comment>
Remaining Estimate | 1h [ 3600 ] | 0h [ 0 ] |
Time Spent | 491.5h [ 1769400 ] | 499.5h [ 1798200 ] |
Worklog Id | 62647 [ 62647 ] |
Time Spent | 499.5h [ 1798200 ] | 500.5h [ 1801800 ] |
Worklog Id | 62812 [ 62812 ] |
Time Spent | 500.5h [ 1801800 ] | 506.5h [ 1823400 ] |
Worklog Id | 62853 [ 62853 ] |
Worklog Id | 62853 [ 62853 ] |
Time Spent | 506.5h [ 1823400 ] | 510h [ 1836000 ] |
Worklog Id | 62858 [ 62858 ] |
Attachment | Delete ACA Report_7.13.xls [ 55377 ] |
Attachment | Delete ACA Report_7.13.xls [ 55378 ] |
Time Spent | 510h [ 1836000 ] | 518h [ 1864800 ] |
Worklog Id | 63831 [ 63831 ] |
Time Spent | 518h [ 1864800 ] | 526h [ 1893600 ] |
Worklog Id | 64346 [ 64346 ] |
Attachment | Analysis_Providence_Medical_Center_with password.xls [ 55887 ] |
-
- Time Spent:
- 2h
-
Analysis of PMC comments provided by client
Time Spent | 526h [ 1893600 ] | 530h [ 1908000 ] |
Worklog Id | 64816 [ 64816 ] |
Time Spent | 530h [ 1908000 ] | 532h [ 1915200 ] |
Worklog Id | 64835 [ 64835 ] |
Time Spent | 532h [ 1915200 ] | 534h [ 1922400 ] |
Worklog Id | 64864 [ 64864 ] |
-
- Time Spent:
- 2h
- <No comment>
-
- Time Spent:
- 2h
- <No comment>
Time Spent | 534h [ 1922400 ] | 536h [ 1929600 ] |
Worklog Id | 66240 [ 66240 ] |
Time Spent | 536h [ 1929600 ] | 541h [ 1947600 ] |
Worklog Id | 66561 [ 66561 ] |
Time Spent | 541h [ 1947600 ] | 546h [ 1965600 ] |
Worklog Id | 66572 [ 66572 ] |
Remaining Estimate | 0h [ 0 ] | 4h [ 14400 ] |
Time Spent | 546h [ 1965600 ] | 542h [ 1951200 ] |
Worklog Id | 60993 [ 60993 ] | |
Worklog Time Spent | 4h [ 14400 ] |
Remaining Estimate | 4h [ 14400 ] | 3h [ 10800 ] |
Time Spent | 542h [ 1951200 ] | 543h [ 1954800 ] |
Worklog Id | 67047 [ 67047 ] |
Remaining Estimate | 3h [ 10800 ] | 1h [ 3600 ] |
Time Spent | 543h [ 1954800 ] | 545h [ 1962000 ] |
Worklog Id | 67509 [ 67509 ] |
Attachment | Updated_Analysis_Providence_Medical_Center_with password.zip [ 58149 ] |
-
- Time Spent:
- 1.5h
-
Share analysis with client for providence medical center
Remaining Estimate | 1h [ 3600 ] | 0h [ 0 ] |
Time Spent | 545h [ 1962000 ] | 546.5h [ 1967400 ] |
Worklog Id | 70601 [ 70601 ] |
Attachment | Employee_List_Saint_Marys_Medical_OptOut.zip [ 59044 ] |
-
- Time Spent:
- 2h
-
Provide employee list those are enrolled in medical and opt out plan
Time Spent | 546.5h [ 1967400 ] | 548.5h [ 1974600 ] |
Worklog Id | 72747 [ 72747 ] |
-
- Time Spent:
- 0.5h
-
Discussion on cost query.
Time Spent | 548.5h [ 1974600 ] | 549h [ 1976400 ] |
Worklog Id | 72970 [ 72970 ] |
Attachment | Saint_Marys_Medical_OptOut_08.30_with password.xls [ 60254 ] |
-
- Time Spent:
- 2.5h
-
Analysis of 70 employee and send feedback to client
Time Spent | 549h [ 1976400 ] | 551.5h [ 1985400 ] |
Worklog Id | 76007 [ 76007 ] |
-
- Time Spent:
- 3h
-
call and analysis
-
- Time Spent:
- 3h
-
Analysis of client mail
Call with Amit
Time Spent | 551.5h [ 1985400 ] | 554.5h [ 1996200 ] |
Worklog Id | 80012 [ 80012 ] |
-
- Time Spent:
- 8h
-
Analysis of Prime issue escalated by client.
Analysis of all the communication in Jira with client for Prime files.
Meeting with amit about Prime ACA files.
Worked on the scripts which will return employee those are enrolled but not eligible in system
Attachment | KMC_Neither_Enrolled_Nor_Waived_List.zip [ 62325 ] |
-
- Time Spent:
- 9h
-
Write script which returns list of employee those are enrolled in system but not eligible for any medical plan.
Call with client.
-
- Time Spent:
- 1h
-
Call with Amit & EBS team members
Time Spent | 554.5h [ 1996200 ] | 555.5h [ 1999800 ] |
Worklog Id | 80373 [ 80373 ] |
Attachment | Revised_Prime_Duplicate_Active_Employee_List.zip [ 62420 ] |
-
- Time Spent:
- 5h
-
Verification Duplicate employee list
Neither enrolled nor waive employees
Internal discussion
-
- Time Spent:
- 3h
-
call and call prepration
-
- Time Spent:
- 8h
-
Provide revised duplicate active employee list to client.
Process neither waive nor enrolled data for Eastliverpoll and Coshocton using existing scripts.
-
- Time Spent:
- 8h
-
Export neither waive nor enrolled employee data for
1. KMC
2. PMC
3. Hosiptality
and working on CHMC
-
- Time Spent:
- 6h
-
Internal discussion
Meeting with Amit
Data Verification
Documentation
Time Spent | 555.5h [ 1999800 ] | 561.5h [ 2021400 ] |
Worklog Id | 81160 [ 81160 ] |
Attachment | Prime Checklist QA_Sep 25 2017.xls [ 62599 ] |
-
- Time Spent:
- 11h
-
Neither Enroll Nor Waive List out & internal discussion.
-
- Time Spent:
- 10h
-
Worked on scripts to neither waive nor enrolled employee.
Meeting with Amit and Team.
Write verification script for neither enroll nor waive records.
Worked to export and verify neither enroll nor waive.
-
- Time Spent:
- 4h
-
Data verification
Client call
Time Spent | 561.5h [ 2021400 ] | 565.5h [ 2035800 ] |
Worklog Id | 81418 [ 81418 ] |
Attachment | EmployeeList_Demographic_Classwise_EIN_Different.zip [ 62731 ] |
Time Spent | 565.5h [ 2035800 ] | 569.5h [ 2050200 ] |
Worklog Id | 81450 [ 81450 ] |
Time Spent | 569.5h [ 2050200 ] | 570.5h [ 2053800 ] |
Worklog Id | 81450 [ 81450 ] |
Time Spent | 570.5h [ 2053800 ] | 573.5h [ 2064600 ] |
Worklog Id | 81702 [ 81702 ] |
Time Spent | 573.5h [ 2064600 ] | 576.5h [ 2075400 ] |
Worklog Id | 81721 [ 81721 ] |
-
- Time Spent:
- 9h
-
Worked to get list of Employee whose EIN is different in Demographic and as per its class1.
Worked on the prime neither waive nor enrolled list
Call with client.
Time Spent | 576.5h [ 2075400 ] | 585.5h [ 2107800 ] |
Worklog Id | 81763 [ 81763 ] |
Attachment | 2017 PRIME FEIN NUMBERS.docx [ 62762 ] |
-
- Time Spent:
- 9h
-
Neither enroll nor waive list out & client call.
Time Spent | 585.5h [ 2107800 ] | 594.5h [ 2140200 ] |
Worklog Id | 81837 [ 81837 ] |
Time Spent | 594.5h [ 2140200 ] | 605.5h [ 2179800 ] |
Worklog Id | 81838 [ 81838 ] |
Time Spent | 605.5h [ 2179800 ] | 615.5h [ 2215800 ] |
Worklog Id | 81839 [ 81839 ] |
Worklog Id | 81839 [ 81839 ] |
Time Spent | 615.5h [ 2215800 ] | 623.5h [ 2244600 ] |
Worklog Id | 81840 [ 81840 ] |
Time Spent | 623.5h [ 2244600 ] | 631.5h [ 2273400 ] |
Worklog Id | 81841 [ 81841 ] |
Time Spent | 631.5h [ 2273400 ] | 640.5h [ 2305800 ] |
Worklog Id | 81842 [ 81842 ] |
Time Spent | 640.5h [ 2305800 ] | 648.5h [ 2334600 ] |
Worklog Id | 81844 [ 81844 ] |
-
- Time Spent:
- 4h
-
Prime employee verification
-
- Time Spent:
- 6h
-
Waive list out for Prime Healthcare in progress..
Time Spent | 648.5h [ 2334600 ] | 654.5h [ 2356200 ] |
Worklog Id | 82100 [ 82100 ] |
-
- Time Spent:
- 8h
-
Worked on the Prime neither waive nor enrolled files for Prime
-
- Time Spent:
- 4.5h
-
data verification of CHMC, PMC,Hospitality & EHMC
Time Spent | 654.5h [ 2356200 ] | 659h [ 2372400 ] |
Worklog Id | 82306 [ 82306 ] |
Attachment | Prime_COBRA_Plan_List.xls [ 62985 ] |
-
- Time Spent:
- 7h
-
Waive list out -Prime Health Care.
-
- Time Spent:
- 8h
-
Worked toe export neither waive nor enrolled reports for Alvarado Hospital.
Time Spent | 659h [ 2372400 ] | 667h [ 2401200 ] |
Worklog Id | 82503 [ 82503 ] |
Time Spent | 667h [ 2401200 ] | 675h [ 2430000 ] |
Worklog Id | 82504 [ 82504 ] |
Time Spent | 675h [ 2430000 ] | 679.25h [ 2445300 ] |
Worklog Id | 82687 [ 82687 ] |
Remaining Estimate | 0h [ 0 ] | 0.25h [ 900 ] |
Time Spent | 679.25h [ 2445300 ] | 679h [ 2444400 ] |
Worklog Id | 82687 [ 82687 ] |
Remaining Estimate | 0.25h [ 900 ] | 0h [ 0 ] |
Time Spent | 679h [ 2444400 ] | 687h [ 2473200 ] |
Worklog Id | 82811 [ 82811 ] |
Time Spent | 687h [ 2473200 ] | 695h [ 2502000 ] |
Worklog Id | 82814 [ 82814 ] |
Time Spent | 695h [ 2502000 ] | 703h [ 2530800 ] |
Worklog Id | 82815 [ 82815 ] |
Time Spent | 703h [ 2530800 ] | 710h [ 2556000 ] |
Worklog Id | 82821 [ 82821 ] |
Time Spent | 710h [ 2556000 ] | 718h [ 2584800 ] |
Worklog Id | 82822 [ 82822 ] |
-
- Time Spent:
- 5.5h
-
Data verification for CHMC, EHMC, AH, GGH
Time Spent | 718h [ 2584800 ] | 723.5h [ 2604600 ] |
Worklog Id | 82868 [ 82868 ] |
-
- Time Spent:
- 8h
-
Worked on the Prime neither waive nor enrolled file for Prime Healthcare
Time Spent | 723.5h [ 2604600 ] | 731.5h [ 2633400 ] |
Worklog Id | 82871 [ 82871 ] |
-
- Time Spent:
- 8h
-
Waive list out-Prime Healthcare.
Time Spent | 731.5h [ 2633400 ] | 739.5h [ 2662200 ] |
Worklog Id | 83000 [ 83000 ] |
-
- Time Spent:
- 8h
-
Neither Waive Nor Enrolled list for Prime facilities
-
- Time Spent:
- 5h
-
Data verification for HMC, MHIN & Prime Healthcare
Internal discussion
Time Spent | 739.5h [ 2662200 ] | 744.5h [ 2680200 ] |
Worklog Id | 83030 [ 83030 ] |
-
- Time Spent:
- 8h
-
Waive list out for HMC,MHIN
-
- Time Spent:
- 5.5h
-
Neither enrolled nor waive testing
Internal discussion
-
- Time Spent:
- 8h
-
Neither Enrolled Nor Waived list for Prime facility Coshocton and EastLiverPool
Attachment | 2017_Prime_EIN_LIST.zip [ 64057 ] |
Time Spent | 744.5h [ 2680200 ] | 752.5h [ 2709000 ] |
Worklog Id | 84282 [ 84282 ] |
Time Spent | 752.5h [ 2709000 ] | 760.5h [ 2737800 ] |
Worklog Id | 84285 [ 84285 ] |
-
- Time Spent:
- 3h
-
Compare Prime EIN provided by client for 2017 with System EIN
Time Spent | 760.5h [ 2737800 ] | 763.5h [ 2748600 ] |
Worklog Id | 84293 [ 84293 ] |
Assignee | Yogesh Chaudhari [ yogesh.chaudhari ] | Amber Love-Jones [ alov ] |
Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
Time Spent | 763.5h [ 2748600 ] | 768.5h [ 2766600 ] |
Worklog Id | 87590 [ 87590 ] |
Time Spent | 768.5h [ 2766600 ] | 769h [ 2768400 ] |
Worklog Id | 87590 [ 87590 ] |
Environment_New | Production [ 18442 ] |
Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
Resolution | Done [ 10000 ] | |
Status | In Progress [ 3 ] | Resolved [ 5 ] |
Transition | Time In Source Status | Execution Times |
---|
|
10d 11h 52m | 1 |
|
170d 12h 34m | 8 |
|
105d 1h 42m | 9 |
|
18s | 1 |
Hello Rakesh Roy,
Mr. Rhodes indicated that he would reach out to DEV directly; however, I did want to list the client note below from a 1/31/2017 email for documentation purposes:
The IRS benefit plan should be sent to us with the new 2017 plans prior to the first file being sent as of today we have not received and last year we never received from you at all?
Also we are experiencing many issues in ACA compliance with the reporting that is sent over from Workterra. We need one change to happen on the January 2017 file
that is due on February 10th,2017 for both the Employee and the Dependent file.
On the Employee file Column I “ Benefits Effective date” should be all employees for the month of January 2017. On all other months we should see only the changes made with that month
So on March 10th, 2017 when you send us the February 2017 file the only thing that should be on that file are any changes that happened between the January file and the February file. As of
today the file you are sending has all data for all months every month and when it is sent to the IRS it creates duplicate which in turn create a problem with our ACA reporting.
We have the same issue for the employee dependent file on Column F with the exact same scenario.
Please advise on what it will take to get the programmer to correct this,
Thank you.