Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-8076

Prime_Healthcare: Equifax ACA Reports

    Details

    • 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

      Description

      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

        Attachments

        1. 2017_Prime_EIN_LIST.zip
          10 kB
        2. 2017 PRIME FEIN NUMBERS.docx
          57 kB
        3. 309 Employees Analysis Feedback.xls
          134 kB
        4. 309 Employees Analysis Feedback (1)-UPDATED.xls
          153 kB
        5. ACA 8076_EEs missing from January FIle.docx
          13 kB
        6. ACA 8076_Missing_January File_HB_Updated.xls
          11 kB
        7. ACA 8076 Missing from January File.docx
          13 kB
        8. Analysis_Dev_UPDATED_Prime 6.30_for Development.xls
          42 kB
        9. Analysis_Dev_UPDATED_Prime 6.30.zip
          11 kB
        10. Analysis_Dev_UPDATED_Prime 6.xls
          43 kB
        11. Analysis_Providence_Medical_Center_with password.xls
          35 kB
        12. Analysis_Proviedence_Medical_Center.zip
          4 kB
        13. Clean Up 6-2017.xlsx
          13 kB
        14. Copy of Book1 (3).xlsx
          68 kB
        15. Copy of Dec2016_EMP_with password.xls
          6.48 MB
        16. Copy of IRS check off with password.xlsx
          28 kB
        17. Copy of List of EINs to include or exclude for Year 2017 Prime Files (003)_UPDATED with password.xlsx
          19 kB
        18. Copy of workterra compliance_2016.xlsx
          60 kB
        19. Coshocton_ACA_Customization.jpg
          Coshocton_ACA_Customization.jpg
          221 kB
        20. Delete ACA Report_7.13.xls
          5.39 MB
        21. Delete ACA Report_7.13.xls
          5.39 MB
        22. Dev_D. Fleury emails 6.21.2017 with password.xlsx
          37 kB
        23. Dev_UPDATED Report from Prime 6.30.xlsx
          27 kB
        24. EIN_List_Dependent_Count.xls
          11 kB
        25. EIN_List_Employee_Count.xls
          12 kB
        26. Employee_List_Saint_Marys_Medical_OptOut.zip
          37 kB
        27. EmployeeList_Demographic_Classwise_EIN_Different.zip
          20 kB
        28. EmployeePresentInMultipleCompany.xlsx
          4.77 MB
        29. HB_UPDATED_ACA 8076_EEs missing from January FIle.doc
          19 kB
        30. IRS_EveryDayCoverage.jpg
          IRS_EveryDayCoverage.jpg
          295 kB
        31. JIRA - WT-8076 with password.docx
          174 kB
        32. KMC_Neither_Enrolled_Nor_Waived_List.zip
          6 kB
        33. Latest_Analysis_Of_309_Employees_Feedback.zip
          112 kB
        34. List of EINs to include or exclude for Year 2017 Prime Files.xlsx
          15 kB
        35. Prime_COBRA_Plan_List.xls
          9 kB
        36. Prime_Duplicate_Active_Employee_List.zip
          16 kB
        37. Prime analysis KMC HMC.zip
          7 kB
        38. Prime Checklist QA_Sep 25 2017.xls
          16 kB
        39. Prime plan list 2017.xlsx
          61 kB
        40. RE KMC ACA REPORTING FOR 2017.msg
          308 kB
        41. Reno Tahoe Anesthesia JIRA screenshot with password.docx
          61 kB
        42. Revised_Prime_Duplicate_Active_Employee_List.zip
          22 kB
        43. Saint_Marys_Medical_OptOut_08.30_with password.xls
          39 kB
        44. screenshot-1.png
          screenshot-1.png
          20 kB
        45. screenshot-2.png
          screenshot-2.png
          11 kB
        46. screenshot-3.png
          screenshot-3.png
          12 kB
        47. Terminated employees.msg
          137 kB
        48. Updated_Analysis_Providence_Medical_Center_with password.zip
          5 kB
        49. UPDATED_Prime_Duplicate_Active_Employee_List.zip
          19 kB
        50. WT-8076 Screenshots.docx
          607 kB

          Issue Links

            Activity

            smita.pawar Smita Pawar (Inactive) logged work - 12/Apr/16 03:58 AM - edited
            • Time Spent:
              1h
               

              Analysis
              Internal discussion

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 04/Feb/17 06:38 AM
            • Time Spent:
              3h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 06/Feb/17 10:00 PM
            • Time Spent:
              7.5h
               

              File verification & delivery to qa

            mahendra.mungase Mahendra Mungase (Inactive) logged work - 07/Feb/17 06:16 AM
            • Time Spent:
              4h
               

              Plan 2017 verification

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 07/Feb/17 09:58 AM
            • Time Spent:
              0.5h
               

              Discussion with nandu and revan

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 07/Feb/17 12:41 PM
            • Time Spent:
              0.5h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 07/Feb/17 10:00 PM
            • Time Spent:
              1h
               

              Internal Discussion,EIN wise Record Count list out.

            mahendra.mungase Mahendra Mungase (Inactive) logged work - 08/Feb/17 06:17 AM
            • Time Spent:
              7.5h
               

              2017 Plan verification on multiple company

            smita.pawar Smita Pawar (Inactive) logged work - 08/Feb/17 01:30 PM
            • Time Spent:
              7.5h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 08/Feb/17 10:00 PM
            • Time Spent:
              8.5h
               

              309 Employees Analysis & Reply

            mahendra.mungase Mahendra Mungase (Inactive) logged work - 09/Feb/17 06:22 AM
            • Time Spent:
              2h
               

              Discussion on Jan 2017 prime file

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 09/Feb/17 06:44 AM
            • Time Spent:
              7h
               
              <No comment>
            smita.pawar Smita Pawar (Inactive) logged work - 09/Feb/17 01:41 PM - edited
            • Time Spent:
              4h 25m
               

              Prime file testing

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 09/Feb/17 10:00 PM
            • Time Spent:
              4h
               

              Analysis of 7 employees & feedback

            mahendra.mungase Mahendra Mungase (Inactive) logged work - 10/Feb/17 06:28 AM
            • Time Spent:
              6.5h
               

              Analysis on 309 employee data

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 10/Feb/17 06:45 AM
            • Time Spent:
              7h
               
              <No comment>
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 11/Feb/17 01:38 AM
            • Time Spent:
              8h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 13/Feb/17 10:00 PM
            • Time Spent:
              10.5h
               

              File generation for Landmark for 4 months.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 14/Feb/17 01:42 AM
            • Time Spent:
              10h
               
              <No comment>
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 14/Feb/17 07:19 AM
            • Time Spent:
              2h
               

              309 employee analysis

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 24/Feb/17 10:00 PM - edited
            • Time Spent:
              7h
               

              Analysis, discussion & reply.

            smita.pawar Smita Pawar (Inactive) logged work - 27/Feb/17 11:37 AM
            • Time Spent:
              0.5h
               

              Internal discussion

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 03/Mar/17 01:16 AM
            • Time Spent:
              3h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 06/Mar/17 10:00 PM
            • Time Spent:
              7h
               

              File procesing Jan-2017

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 07/Mar/17 01:38 AM
            • Time Spent:
              6h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 07/Mar/17 10:00 PM
            • Time Spent:
              7h
               

              File Process.

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 08/Mar/17 10:00 PM - edited
            • Time Spent:
              7.5h
               

              File Verification & Discrepancy details posted on JIRA for client feedback.

            mahendra.mungase Mahendra Mungase (Inactive) logged work - 09/Mar/17 01:56 PM
            • Time Spent:
              3h
               

              Jan 17 file testing

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 09/Mar/17 10:00 PM
            • Time Spent:
              10.75h
               

              Jan & feb file process.

            smita.pawar Smita Pawar (Inactive) logged work - 10/Mar/17 01:52 PM
            • Time Spent:
              3h
               

              1.Jira updates
              2.File upload
              3.Jan file testing

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 10/Mar/17 10:00 PM
            • Time Spent:
              5.5h
               

              Files-Feb Change File generation & verification.

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 23/Mar/17 09:00 PM
            • Time Spent:
              20m
               

              Jira reply.

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 24/Mar/17 09:00 PM - edited
            • Time Spent:
              0.5h
               

              REPLY.

            smita.pawar Smita Pawar (Inactive) logged work - 01/Apr/17 06:18 AM
            • Time Spent:
              7h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 11/Apr/17 09:00 PM
            • Time Spent:
              7h
               

              Analysis of the points.

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 12/Apr/17 09:00 PM
            • Time Spent:
              8h
               

              Documentation.

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 14/Apr/17 09:00 PM
            • Time Spent:
              6h
               

              Call Document Preparation.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 19/Apr/17 12:46 AM
            • Time Spent:
              2h
               
              <No comment>
            smita.pawar Smita Pawar (Inactive) logged work - 19/Apr/17 03:43 AM
            • Time Spent:
              3h
               

              Analysis
              Discussion with Revan
              Call preparation
              EIN verificationwith Check list

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 19/Apr/17 09:00 PM
            • Time Spent:
              2h
               

              internal discussion,jira reply updates.

            smita.pawar Smita Pawar (Inactive) logged work - 27/Apr/17 10:56 AM
            • Time Spent:
              5h
               

              Ana;lysis
              Customization checking
              Template verification
              Issue locking
              Internal discussion

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 11/May/17 12:58 AM - edited
            • Time Spent:
              1.5h
               
              <No comment>
            smita.pawar Smita Pawar (Inactive) logged work - 22/May/17 02:06 PM
            • Time Spent:
              1h
               

              Analysis
              Internal discussion

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 22/May/17 09:00 PM
            • Time Spent:
              4.5h
               

              Working on client comments implementation.

            smita.pawar Smita Pawar (Inactive) logged work - 23/May/17 11:29 AM
            • Time Spent:
              5h
               

              Checklist preparation for prime automation

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 23/May/17 09:00 PM
            • Time Spent:
              5.5h
               

              Data audit.

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 24/May/17 09:00 PM
            • Time Spent:
              1h
               

              Data audit.

            smita.pawar Smita Pawar (Inactive) logged work - 03/Jun/17 04:36 AM
            • Time Spent:
              3h
               

              Customization & general export testing to fetch the file

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 06/Jun/17 11:37 AM
            • 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

            Prashant.samal Prashant Samal (Inactive) logged work - 06/Jun/17 02:00 PM
            • Time Spent:
              4h
               

              Prime Healthcare ACA Files Testing the Cases provided by QA Team- 4 hr

            yogita.bhadane Yogita Bhadane (Inactive) logged work - 06/Jun/17 05:08 PM
            • Time Spent:
              5.5h
               

              Testing prime files of local environment.

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 06/Jun/17 09:00 PM
            • Time Spent:
              16h
               

              Call with EBS for prime queries.
              File generation using automation.

            smita.pawar Smita Pawar (Inactive) logged work - 07/Jun/17 04:46 AM
            • Time Spent:
              8h
               

              Task allocation
              Internal discussion
              File Testing
              Checklist review

            Prashant.samal Prashant Samal (Inactive) logged work - 07/Jun/17 09:00 AM
            • 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

            smita.pawar Smita Pawar (Inactive) logged work - 07/Jun/17 01:49 PM
            • Time Spent:
              8h
               

              File testing
              Checklist review
              Internal discussion
              Analysis

            yogita.bhadane Yogita Bhadane (Inactive) logged work - 07/Jun/17 05:09 PM
            • Time Spent:
              8h
               

              Testing prime files exported from production.

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 07/Jun/17 05:27 PM - edited
            • Time Spent:
              6h
               

              Testing ACA Prime files January

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 08/Jun/17 12:48 AM
            • Time Spent:
              8h
               
              <No comment>
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 08/Jun/17 05:14 AM
            • Time Spent:
              9h
               

              Exported the full file for Jan -2017 and also created script to get change file

            Prashant.samal Prashant Samal (Inactive) logged work - 08/Jun/17 09:08 AM
            • Time Spent:
              7h
               

              PrimeHealth Care ACA Files - 7 hr

              January - Full files

            yogita.bhadane Yogita Bhadane (Inactive) logged work - 08/Jun/17 05:10 PM
            • Time Spent:
              2h
               

              Testing prime files exported from production.

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 08/Jun/17 05:26 PM
            • Time Spent:
              7h
               

              Testing ACA Prime Full files January

            smita.pawar Smita Pawar (Inactive) logged work - 09/Jun/17 04:57 AM
            • Time Spent:
              3h
               

              Jan file testing - Employee & Dependent
              Jan file Delivery to client
              Testing of Feb file Active employee

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 09/Jun/17 05:11 AM
            • Time Spent:
              8h
               

              Exported change for Feb-2017 and unit test records from the Feb file

            yogita.bhadane Yogita Bhadane (Inactive) logged work - 09/Jun/17 07:34 AM
            • Time Spent:
              7h
               

              Testing feb file as per checklist provided.

            Prashant.samal Prashant Samal (Inactive) logged work - 09/Jun/17 09:08 AM
            • 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

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 09/Jun/17 03:43 PM
            • Time Spent:
              8h
               

              Export change files of Prime for March,April and May 2017

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 09/Jun/17 05:17 PM
            • Time Spent:
              7h
               

              Testing PrimeACA files for Feb

              testing the Checklist provided

              sampling

              discussion with Prashant

            smita.pawar Smita Pawar (Inactive) logged work - 10/Jun/17 05:00 AM
            • Time Spent:
              4h
               

              Change file testing

            yogita.bhadane Yogita Bhadane (Inactive) logged work - 12/Jun/17 07:35 AM
            • Time Spent:
              7h
               

              Testing april and may file as per checklist provided.

            Prashant.samal Prashant Samal (Inactive) logged work - 12/Jun/17 09:00 AM
            • 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 observed

              Confirming all the files and uploading on ftp site and sending updates to Amber Love Jones

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 12/Jun/17 03:28 PM
            • Time Spent:
              8h
               

              Analysis of employees provided by client and share detail analysis with client

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 12/Jun/17 05:19 PM
            • Time Spent:
              6h
               

              Testing ACA files for April and May

              testing the checklist
              sampling
              discussion with prashant

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 13/Jun/17 03:23 PM
            • Time Spent:
              4h
               

              Analysis of Prime files and send reply to client

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 15/Jun/17 12:53 AM
            • Time Spent:
              6h
               
              <No comment>
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 15/Jun/17 12:53 PM
            • Time Spent:
              6h
               
              <No comment>
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 15/Jun/17 03:22 PM
            • Time Spent:
              8h
               

              Analysis of 20 employees provided by client and reply to them

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 16/Jun/17 02:01 PM
            • Time Spent:
              7h
               

              Analysis of Prime 20 employees provided

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 21/Jun/17 11:20 PM
            • Time Spent:
              2h
               
              <No comment>
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 22/Jun/17 02:10 PM
            • Time Spent:
              8h
               

              Analysis of Employees those are missing from file.
              Provide duplicate active employee list
              Call with onshore team

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 22/Jun/17 11:06 PM
            • Time Spent:
              2h
               
              <No comment>
            smita.pawar Smita Pawar (Inactive) logged work - 27/Jun/17 12:58 PM
            • Time Spent:
              6h
               

              Analysis

            smita.pawar Smita Pawar (Inactive) logged work - 28/Jun/17 08:42 AM
            • Time Spent:
              3h
               

              Task discussion
              Meeting
              KT
              Client reply
              Review

            yogita.bhadane Yogita Bhadane (Inactive) logged work - 28/Jun/17 04:35 PM
            • Time Spent:
              6h
               

              Discussion with smita.
              Analysis of duplicated employees enrollments and eligibility on KMC and HMC.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 28/Jun/17 11:05 PM
            • Time Spent:
              2h
               
              <No comment>
            smita.pawar Smita Pawar (Inactive) logged work - 03/Jul/17 12:14 PM
            • Time Spent:
              5h
               

              File testing

            yogita.bhadane Yogita Bhadane (Inactive) logged work - 03/Jul/17 04:25 PM
            • Time Spent:
              1h
               

              As discussed with revan verified prime aca template for specific facility for checking performance issue.

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 04/Jul/17 05:22 AM - edited
            • Time Spent:
              8h
               

              Did analysis of HMC,CHMC employees

            smita.pawar Smita Pawar (Inactive) logged work - 04/Jul/17 12:27 PM
            • Time Spent:
              5h
               

              Full file testing for Feb

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 05/Jul/17 05:21 AM
            • Time Spent:
              8h
               

              Did the analysis of CHMC 52 employees and send detail report to client

            smita.pawar Smita Pawar (Inactive) logged work - 06/Jul/17 04:40 AM
            • Time Spent:
              1.5h
               

              Employee analysis and reply

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 06/Jul/17 05:20 AM - edited
            • Time Spent:
              7h
               

              Analysis of Coshocton 72 employees and provide detail report to client

            smita.pawar Smita Pawar (Inactive) logged work - 06/Jul/17 10:44 AM
            • Time Spent:
              1h
               

              Analysis of Client email

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 06/Jul/17 01:32 PM
            • Time Spent:
              8h
               

              Analysis of Providence Medical center employee and send to client

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 08/Jul/17 06:17 AM
            • Time Spent:
              8h
               

              Worked on the issue reported by client and provide feedback on the queries.

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 10/Jul/17 11:14 AM
            • Time Spent:
              8h
               

              Analysis of prime employees and send some of the examples to client for review.

            yogita.bhadane Yogita Bhadane (Inactive) logged work - 10/Jul/17 05:03 PM - edited
            • Time Spent:
              6h
               

              Prime ACA automation.
              Exported file and tested according to checklist.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 11/Jul/17 08:00 AM
            • Time Spent:
              4h
               
              <No comment>
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 11/Jul/17 05:06 PM
            • Time Spent:
              3.5h
               

              Tested prime file according to checklist.

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 12/Jul/17 08:00 AM
            • Time Spent:
              2h
               
              <No comment>
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 19/Jul/17 01:21 PM
            • Time Spent:
              2h
               

              Analysis of PMC comments provided by client

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 20/Jul/17 08:00 AM
            • Time Spent:
              2h
               
              <No comment>
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 25/Jul/17 08:00 AM
            • Time Spent:
              2h
               
              <No comment>
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 09/Aug/17 02:48 PM
            • Time Spent:
              1.5h
               

              Share analysis with client for providence medical center

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 18/Aug/17 01:37 PM
            • Time Spent:
              2h
               

              Provide employee list those are enrolled in medical and opt out plan

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 18/Aug/17 09:00 PM
            • Time Spent:
              0.5h
               

              Discussion on cost query.

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 31/Aug/17 10:10 AM
            • Time Spent:
              2.5h
               

              Analysis of 70 employee and send feedback to client

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 15/Sep/17 01:15 PM
            • Time Spent:
              3h
               

              call and analysis

            smita.pawar Smita Pawar (Inactive) logged work - 20/Sep/17 01:49 PM
            • Time Spent:
              3h
               

              Analysis of client mail
              Call with Amit

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 20/Sep/17 07:02 PM
            • 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

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 21/Sep/17 09:00 PM
            • Time Spent:
              8h
               

              Waive list out.

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 22/Sep/17 05:00 AM
            • 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.

            smita.pawar Smita Pawar (Inactive) logged work - 22/Sep/17 05:06 AM
            • Time Spent:
              1h
               

              Call with Amit & EBS team members

            smita.pawar Smita Pawar (Inactive) logged work - 22/Sep/17 11:28 AM - edited
            • Time Spent:
              5h
               

              Verification Duplicate employee list
              Neither enrolled nor waive employees
              Internal discussion

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 22/Sep/17 01:24 PM
            • Time Spent:
              3h
               

              call and call prepration

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 22/Sep/17 09:00 PM
            • Time Spent:
              8h
               

              Waive list out.

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 23/Sep/17 06:56 AM
            • Time Spent:
              8h
               

              Provide revised duplicate active employee list to client.
              Process neither waive nor enrolled data for Eastliverpoll and Coshocton using existing scripts.

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 23/Sep/17 09:00 PM
            • Time Spent:
              8h
               

              Waive list out.

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 24/Sep/17 06:55 AM
            • Time Spent:
              8h
               

              Export neither waive nor enrolled employee data for
              1. KMC
              2. PMC
              3. Hosiptality
              and working on CHMC

            smita.pawar Smita Pawar (Inactive) logged work - 25/Sep/17 01:44 PM
            • Time Spent:
              6h
               

              Internal discussion
              Meeting with Amit
              Data Verification
              Documentation

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 25/Sep/17 09:00 PM
            • Time Spent:
              11h
               

              Neither Enroll Nor Waive List out & internal discussion.

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 26/Sep/17 06:46 AM - edited
            • 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.

            smita.pawar Smita Pawar (Inactive) logged work - 26/Sep/17 11:19 AM
            • Time Spent:
              4h
               

              Data verification
              Client call

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 26/Sep/17 03:11 PM
            • 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.

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 26/Sep/17 09:00 PM
            • Time Spent:
              9h
               

              Neither enroll nor waive list out & client call.

            smita.pawar Smita Pawar (Inactive) logged work - 27/Sep/17 11:14 AM - edited
            • Time Spent:
              4h
               

              Prime employee verification

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 27/Sep/17 09:00 PM
            • Time Spent:
              6h
               

              Waive list out for Prime Healthcare in progress..

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 28/Sep/17 06:03 AM
            • Time Spent:
              8h
               

              Worked on the Prime neither waive nor enrolled files for Prime

            smita.pawar Smita Pawar (Inactive) logged work - 28/Sep/17 01:03 PM
            • Time Spent:
              4.5h
               

              data verification of CHMC, PMC,Hospitality & EHMC

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 28/Sep/17 09:00 PM
            • Time Spent:
              7h
               

              Waive list out -Prime Health Care.

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 29/Sep/17 06:04 AM
            • Time Spent:
              8h
               

              Worked toe export neither waive nor enrolled reports for Alvarado Hospital.

            smita.pawar Smita Pawar (Inactive) logged work - 29/Sep/17 01:52 PM
            • Time Spent:
              5.5h
               

              Data verification for CHMC, EHMC, AH, GGH

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 29/Sep/17 01:55 PM
            • Time Spent:
              8h
               

              Worked on the Prime neither waive nor enrolled file for Prime Healthcare

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 29/Sep/17 09:00 PM
            • Time Spent:
              8h
               

              Waive list out-Prime Healthcare.

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 03/Oct/17 01:03 PM
            • Time Spent:
              8h
               

              Neither Waive Nor Enrolled list for Prime facilities

            smita.pawar Smita Pawar (Inactive) logged work - 03/Oct/17 01:38 PM
            • Time Spent:
              5h
               

              Data verification for HMC, MHIN & Prime Healthcare
              Internal discussion

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 03/Oct/17 09:00 PM
            • Time Spent:
              8h
               

              Waive list out for HMC,MHIN

            smita.pawar Smita Pawar (Inactive) logged work - 04/Oct/17 10:58 AM - edited
            • Time Spent:
              5.5h
               

              Neither enrolled nor waive testing
              Internal discussion

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 05/Oct/17 12:58 AM
            • Time Spent:
              8h
               

              Neither Enrolled Nor Waived list for Prime facility Coshocton and EastLiverPool

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 11/Oct/17 01:07 PM
            • Time Spent:
              3h
               

              Compare Prime EIN provided by client for 2017 with System EIN

              People

              Assignee:
              alov Amber Love-Jones (Inactive)
              Reporter:
              alov Amber Love-Jones (Inactive)
              Account Executive:
              Amber Love-Jones (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              11 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 166h Original Estimate - 166h
                  166h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 769h
                  769h