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

            alov Amber Love-Jones (Inactive) created issue -
            rakeshr Rakesh Roy (Inactive) made changes -
            Field Original Value New Value
            Component/s ACA [ 10004 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Module Parent values: BenAdmin(10100) Parent values: ACA(10104)
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            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.

            Show
            alov Amber Love-Jones (Inactive) added a comment - 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.
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 04/Feb/17 06:38 AM
            • Time Spent:
              3h
               
              <No comment>
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Link This issue relates to WT-663 [ WT-663 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 06/Feb/17 10:00 PM
            • Time Spent:
              7.5h
               

              File verification & delivery to qa

            alov Amber Love-Jones (Inactive) made changes -
            Attachment Copy of Book1 (3).xlsx [ 39173 ]
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Rakesh Roy,

            Prime sent the following message today with attachment (password will be sent separately):

            I have attached a report of employees that are showing as a compliance risk through our third party ACA vendor Equifax. There are 309 employees that are active in the Workterra system but are not coming over on the IRS Employee file. What this means is that Prime will be at risk for penalties and fines so we need to understand why these employees are not being reported by Workterra?

            Please advise at your earliest convenience.

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Rakesh Roy , Prime sent the following message today with attachment (password will be sent separately): I have attached a report of employees that are showing as a compliance risk through our third party ACA vendor Equifax. There are 309 employees that are active in the Workterra system but are not coming over on the IRS Employee file. What this means is that Prime will be at risk for penalties and fines so we need to understand why these employees are not being reported by Workterra? Please advise at your earliest convenience.
            alov Amber Love-Jones (Inactive) made changes -
            Assignee Yogesh Chaudhari [ yogesh.chaudhari ] Rakesh Roy [ rakeshr ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Rakesh Roy [ rakeshr ] Smita Pawar [ smita.pawar ]
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 07/Feb/17 06:16 AM
            • Time Spent:
              4h
               

              Plan 2017 verification

            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 166h [ 597600 ]
            Original Estimate 166h [ 597600 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 166h [ 597600 ] 158.5h [ 570600 ]
            Time Spent 7.5h [ 27000 ]
            Worklog Id 23430 [ 23430 ]
            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Amber Love-Jones Password not received. FY! Rakesh Roy , Sachin Hingole , Nandkumar Prabhakar Karlekar , Mahendra Mungase
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Attachment Prime plan list 2017.xlsx [ 39186 ]
            Hide
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            Hi Mahendra Mungase

            Please verify the attached prime plan list 2017.
            This report consider the class1, class2 and "Nicotine Product" only for cost distribution.

            *Note *: this report is not considering the Apply Full time rate " additional flag.

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi Mahendra Mungase Please verify the attached prime plan list 2017. This report consider the class1, class2 and "Nicotine Product" only for cost distribution. *Note *: this report is not considering the Apply Full time rate " additional flag.
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 07/Feb/17 09:58 AM
            • Time Spent:
              0.5h
               

              Discussion with nandu and revan

            rakeshr Rakesh Roy (Inactive) made changes -
            Status Open [ 1 ] Waiting for Customer Input [ 10500 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Amber Love-Jones [ alov ]
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 07/Feb/17 12:41 PM
            • Time Spent:
              0.5h
               
              <No comment>
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Remaining Estimate 158.5h [ 570600 ] 158h [ 568800 ]
            Time Spent 7.5h [ 27000 ] 8h [ 28800 ]
            Worklog Id 23496 [ 23496 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Link This issue relates to WT-8255 [ WT-8255 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Link This issue relates to WT-8254 [ WT-8254 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Link This issue relates to WT-8297 [ WT-8297 ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Link This issue relates to WT-8297 [ WT-8297 ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Attachment EIN_List_Employee_Count.xls [ 39213 ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Attachment EIN_List_Dependent_Count.xls [ 39214 ]
            Hide
            mahendra.mungase Mahendra Mungase (Inactive) added a comment -

            Hi Amber Love-Jones

            We have attached FEIN list which will come on 2017 prime files. Please review the FEIN , let us know if you want to add and remove FEIN.

            FEIN with Employee count on JAN 17 file - EIN_List_Employee_Count.xls

            FEIN With Dependent count on JAN 17 file - EIN_List_Dependent_Count.xls .

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

            Thanks.

            Show
            mahendra.mungase Mahendra Mungase (Inactive) added a comment - Hi Amber Love-Jones We have attached FEIN list which will come on 2017 prime files. Please review the FEIN , let us know if you want to add and remove FEIN. FEIN with Employee count on JAN 17 file - EIN_List_Employee_Count.xls FEIN With Dependent count on JAN 17 file - EIN_List_Dependent_Count.xls . CC - Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar Debbie Kulling Rakesh Roy Revansiddha Gaur Thanks.
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 07/Feb/17 10:00 PM
            • Time Spent:
              1h
               

              Internal Discussion,EIN wise Record Count list out.

            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Mahendra Mungase,

            I spoke with Prime today and they have added more information to the message I sent yesterday. The attached report I sent yesterday is a list of 309 employees that are active in Workterra but are not coming over on the IRS Employee file and not showing on the 1095-C forms for 2016.

            Please review for 2016 and advise a.s.a.p. why these employees are not being reported by Workterra?

            Thank you!

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Mahendra Mungase , I spoke with Prime today and they have added more information to the message I sent yesterday. The attached report I sent yesterday is a list of 309 employees that are active in Workterra but are not coming over on the IRS Employee file and not showing on the 1095-C forms for 2016 . Please review for 2016 and advise a.s.a.p. why these employees are not being reported by Workterra? Thank you!
            alov Amber Love-Jones (Inactive) made changes -
            Assignee Amber Love-Jones [ alov ] Mahendra Mungase [ mahendra.mungase ]
            Hide
            mahendra.mungase Mahendra Mungase (Inactive) added a comment -

            Can you please look into this point.

            CC- Sachin Hingole

            Show
            mahendra.mungase Mahendra Mungase (Inactive) added a comment - Can you please look into this point. CC- Sachin Hingole
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Assignee Mahendra Mungase [ mahendra.mungase ] Smita Pawar [ smita.pawar ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 158h [ 568800 ] 157h [ 565200 ]
            Time Spent 8h [ 28800 ] 9h [ 32400 ]
            Worklog Id 23624 [ 23624 ]
            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) made changes -
            Link This issue relates to WT-8349 [ WT-8349 ]
            smita.pawar Smita Pawar (Inactive) logged work - 08/Feb/17 01:30 PM
            • Time Spent:
              7.5h
               
              <No comment>
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            We are currently working on JAN 2017 File.
            We will update testing status on 10 Jan 2017 [EOD]

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We are currently working on JAN 2017 File. We will update testing status on 10 Jan 2017 [EOD]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Amber Love-Jones,

            CONCERN : 309 Employees not reflected on Dec 2016 file.
            CAUSE : In attached excel file has been provided inline comment in 'Harbinger Comment' column for each employee.

            309 Employees Analysis Feedback.xls

            No Of Employee - 309
            Double Employees- -2
            -----------------------------------
            Remains Employees - 307
            Blank EmpID - 1
            -----------------------------------
            Need to Analysed Emps - 306+1 (Blank Emp ID)
            Not Present Emp Records - 225/307 ( In Excel highlighted by Orange Color )
            Terminated Employees - 23 ( In Excel highlighted by Yellow Color )
            Not Enrolled For ACA Plans - 53 ( In Excel highlighted by Blue Color )
            Should Come one File Emps - 5 ( In Excel highlighted by Blue Color )
            Note : We are working on these 5 employees analysis & for Blank EmpID Employee .

            Regards,
            Revan

            Mahendra Mungase Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Amber Love-Jones , CONCERN : 309 Employees not reflected on Dec 2016 file. CAUSE : In attached excel file has been provided inline comment in 'Harbinger Comment' column for each employee. 309 Employees Analysis Feedback.xls No Of Employee - 309 Double Employees- -2 ----------------------------------- Remains Employees - 307 Blank EmpID - 1 ----------------------------------- Need to Analysed Emps - 306+1 (Blank Emp ID) Not Present Emp Records - 225/307 ( In Excel highlighted by Orange Color ) Terminated Employees - 23 ( In Excel highlighted by Yellow Color ) Not Enrolled For ACA Plans - 53 ( In Excel highlighted by Blue Color ) Should Come one File Emps - 5 ( In Excel highlighted by Blue Color ) Note : We are working on these 5 employees analysis & for Blank EmpID Employee . Regards, Revan Mahendra Mungase Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Thank you Mahendra Mungase. I will advise if there are additional comments from Prime by end of day today.

            Show
            alov Amber Love-Jones (Inactive) added a comment - Thank you Mahendra Mungase . I will advise if there are additional comments from Prime by end of day today.
            Hide
            alov Amber Love-Jones (Inactive) added a comment - - edited

            Hello Mahendra Mungase,

            Prime sent another report this morning, titled "workterra compliance_2016.xlsx. Password will be emailed to you.

            The list shows employees that are missing from 2016. Prime can see them in WorkTerra, but the employees never came over to Prime in an IRS file. Please review and update immediately

            Thank you.

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - - edited Hello Mahendra Mungase , Prime sent another report this morning, titled "workterra compliance_2016.xlsx. Password will be emailed to you. The list shows employees that are missing from 2016. Prime can see them in WorkTerra, but the employees never came over to Prime in an IRS file. Please review and update immediately Thank you. Amber
            alov Amber Love-Jones (Inactive) made changes -
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 08/Feb/17 10:00 PM
            • Time Spent:
              8.5h
               

              309 Employees Analysis & Reply

            alov Amber Love-Jones (Inactive) made changes -
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Prime reviewed report titled "309 Employees Analysis Feedback." It was discovered that many employees highlighted in orange listed as not in WorkTerra are in WorkTerra. I went through every employee highlighted in orange and listed the location where they work or worked in 2016. Many are with Landmark, which was a Prime_Healthcare facility until 5/1/2016. Others are Prime breakout employees and I have listed them on the last column of the attached report.

            Please find attached "309 Employees Analysis Feedback_Updated" attached. Password will be emailed to Mahendra Mungase. These need to be updated immediately so that I can advise Prime that they are fixed as of tomorrow, 2/9/2017.

            Thank you.

            Show
            alov Amber Love-Jones (Inactive) added a comment - Prime reviewed report titled "309 Employees Analysis Feedback." It was discovered that many employees highlighted in orange listed as not in WorkTerra are in WorkTerra. I went through every employee highlighted in orange and listed the location where they work or worked in 2016. Many are with Landmark, which was a Prime_Healthcare facility until 5/1/2016. Others are Prime breakout employees and I have listed them on the last column of the attached report. Please find attached "309 Employees Analysis Feedback_Updated" attached. Password will be emailed to Mahendra Mungase . These need to be updated immediately so that I can advise Prime that they are fixed as of tomorrow, 2/9/2017. Thank you.
            alov Amber Love-Jones (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Mahendra Mungase [ mahendra.mungase ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Assignee Mahendra Mungase [ mahendra.mungase ] Smita Pawar [ smita.pawar ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 157h [ 565200 ] 148.5h [ 534600 ]
            Time Spent 9h [ 32400 ] 17.5h [ 63000 ]
            Worklog Id 23840 [ 23840 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Revansiddha Gaur [ revansiddha.gaur ]
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Amber Love-Jones,

            We are working on 309 Employees Issue.

            Regards,
            Revan

            Smita Pawar Mahendra Mungase Sachin Hingole Nandkumar Prabhakar Karlekar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Amber Love-Jones , We are working on 309 Employees Issue. Regards, Revan Smita Pawar Mahendra Mungase Sachin Hingole Nandkumar Prabhakar Karlekar
            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>
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Mahendra Mungase,

            As we discussed with you, Please look into above comments.

            Regards,
            Revan

            Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Mahendra Mungase , As we discussed with you, Please look into above comments. Regards, Revan Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Remaining Estimate 148.5h [ 534600 ] 148h [ 532800 ]
            Time Spent 17.5h [ 63000 ] 18h [ 64800 ]
            Worklog Id 24016 [ 24016 ]
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment - - edited

            Hi Amber Love-Jones,

            We have uploaded Prime Files for Jan 2017 on FTP.

            URL: https://ftpsecure.ebsbenefits.com
            Path:/users/workterraaca/Prime/Prime_facility_02092017

            File names:1. Jan2017_EMP - 02092017.zip
            2. Jan2017_DEP - 02092017.zip

            Let us know your feed back for same.

            Thanks,
            Smita

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

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - - edited Hi Amber Love-Jones , We have uploaded Prime Files for Jan 2017 on FTP. URL: https://ftpsecure.ebsbenefits.com Path:/users/workterraaca/Prime/Prime_facility_02092017 File names:1. Jan2017_EMP - 02092017.zip 2. Jan2017_DEP - 02092017.zip Let us know your feed back for same. Thanks, Smita FYI Sachin Hingole , Nandkumar Prabhakar Karlekar , Revansiddha Gaur , Mahendra Mungase
            smita.pawar Smita Pawar (Inactive) logged work - 09/Feb/17 01:41 PM - edited
            • Time Spent:
              4h 25m
               

              Prime file testing

            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Hide
            mahendra.mungase Mahendra Mungase (Inactive) added a comment -

            Hi Amber Love-Jones

            Today we have done the analysis on shared ”309 Employees Analysis Feedback_Updated ” sheet and added Harbinger comments against each employee.

            File Name - Latest_Analysis_Of_309_Employees_Feedback.zip

            Password in next mail.

            Below is high level analysis for 309 employee's.

            Sr.No Employee Count Reason
            1 177 Not found in system
            2 109 Requested to remove “461175423 LANDMARK MEDICAL
            CENTER LMC” facility from file.As Prime also receiving the same
            data from Lawson
            3 23 Details comments provided under “Harbinger Comments” column
            *Total 309*

            Please let me know for any query.
            Thanks,

            Mahendra

            Show
            mahendra.mungase Mahendra Mungase (Inactive) added a comment - Hi Amber Love-Jones Today we have done the analysis on shared ”309 Employees Analysis Feedback_Updated ” sheet and added Harbinger comments against each employee. File Name - Latest_Analysis_Of_309_Employees_Feedback.zip Password in next mail. Below is high level analysis for 309 employee's. Sr.No Employee Count Reason 1 177 Not found in system 2 109 Requested to remove “461175423 LANDMARK MEDICAL CENTER LMC” facility from file.As Prime also receiving the same data from Lawson 3 23 Details comments provided under “Harbinger Comments” column *Total 309* Please let me know for any query. Thanks, Mahendra
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Mahendra Mungase,

            I have forwarded the "Latest_Analysis_Of_309_Employees_Feedback" to Prime, and will provide any feedback they have.

            Thank you.

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Mahendra Mungase , I have forwarded the "Latest_Analysis_Of_309_Employees_Feedback" to Prime, and will provide any feedback they have. Thank you.
            alov Amber Love-Jones (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            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) made changes -
            Remaining Estimate 148h [ 532800 ] 144h [ 518400 ]
            Time Spent 18h [ 64800 ] 22h [ 79200 ]
            Worklog Id 24222 [ 24222 ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Remaining Estimate 144h [ 518400 ] 136.5h [ 491400 ]
            Time Spent 22h [ 79200 ] 29.5h [ 106200 ]
            Worklog Id 24223 [ 24223 ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Remaining Estimate 136.5h [ 491400 ] 134.5h [ 484200 ]
            Time Spent 29.5h [ 106200 ] 31.5h [ 113400 ]
            Worklog Id 24231 [ 24231 ]
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 10/Feb/17 06:28 AM
            • Time Spent:
              6.5h
               

              Analysis on 309 employee data

            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Remaining Estimate 134.5h [ 484200 ] 128h [ 460800 ]
            Time Spent 31.5h [ 113400 ] 38h [ 136800 ]
            Worklog Id 24245 [ 24245 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Remaining Estimate 128h [ 460800 ] 125h [ 450000 ]
            Time Spent 38h [ 136800 ] 41h [ 147600 ]
            Worklog Id 24251 [ 24251 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Remaining Estimate 125h [ 450000 ] 118h [ 424800 ]
            Time Spent 41h [ 147600 ] 48h [ 172800 ]
            Worklog Id 24254 [ 24254 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 10/Feb/17 06:45 AM
            • Time Spent:
              7h
               
              <No comment>
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Remaining Estimate 118h [ 424800 ] 111h [ 399600 ]
            Time Spent 48h [ 172800 ] 55h [ 198000 ]
            Worklog Id 24255 [ 24255 ]
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Mahendra Mungase, Nandkumar Prabhakar Karlekar, Revansiddha Gaur,

            Prime made comments on the last items we sent on 2.10.2017. I have added Prime's comments in red

            Below is high level analysis for 309 employee's.
            Sr.No Employee Count Reason
            1 177 Not found in system - Prime will research these today
            2 109 Requested to remove “461175423 LANDMARK MEDICAL
            CENTER LMC” facility from file.As Prime also receiving the same
            data from Lawson - Prime is asking who authorized that the Landmark employees be removed. Prime would like these 109 employees to be be added back into the IRS reporting as they were with WorkTerra through 4/30/2016. Please update and reissue report.

            It is URGENT that the corrections for the 109 employees be made immediately.

            Thank you.

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Mahendra Mungase , Nandkumar Prabhakar Karlekar , Revansiddha Gaur , Prime made comments on the last items we sent on 2.10.2017. I have added Prime's comments in red Below is high level analysis for 309 employee's. Sr.No Employee Count Reason 1 177 Not found in system - Prime will research these today 2 109 Requested to remove “461175423 LANDMARK MEDICAL CENTER LMC” facility from file.As Prime also receiving the same data from Lawson - Prime is asking who authorized that the Landmark employees be removed. Prime would like these 109 employees to be be added back into the IRS reporting as they were with WorkTerra through 4/30/2016. Please update and reissue report. It is URGENT that the corrections for the 109 employees be made immediately. Thank you.
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 11/Feb/17 01:38 AM
            • Time Spent:
              8h
               
              <No comment>
            Hide
            shyam.sharma shyam sharma (Inactive) added a comment -

            Sure, ACA Team will look in to this and this will be done on or before Monday
            Revansiddha Gaur Nandkumar Prabhakar Karlekar : Please look in to this on urgent basis.

            Show
            shyam.sharma shyam sharma (Inactive) added a comment - Sure, ACA Team will look in to this and this will be done on or before Monday Revansiddha Gaur Nandkumar Prabhakar Karlekar : Please look in to this on urgent basis.
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 111h [ 399600 ] 107h [ 385200 ]
            Time Spent 55h [ 198000 ] 59h [ 212400 ]
            Worklog Id 24492 [ 24492 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 107h [ 385200 ] 99.5h [ 358200 ]
            Time Spent 59h [ 212400 ] 66.5h [ 239400 ]
            Worklog Id 24643 [ 24643 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 99.5h [ 358200 ] 95h 5m [ 342300 ]
            Time Spent 66.5h [ 239400 ] 70h 55m [ 255300 ]
            Worklog Id 24647 [ 24647 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Worklog Id 24647 [ 24647 ]
            Hide
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - - edited

            Hi Amber Love-Jones

            We have extracted the data from prime healthcare company for 109 employees for Jan to april month. 105 employees are exported on file. Please find the attached file

            Following 3 employees are not eligible for any ACA Plan
            So these will not come on ACA report.

            1. CATHY A GIGNAC
            2. LISA MILLETTE
            3. GLENN MILLER

            Following one employee is not found in Workterra.
            1. Santana Victor

            Folder name : Prime ACA 109 Emps Files.zip

            *Additional information: *

            We had completely blocked the following EIN so no any employee from these EIN has been exported on the ACA Prime file.

            461175423 LANDMARK MEDICAL CENTER
            461175423 LANDMARK PHYSICIAN OFFICE SERVICES
            461175423 REHAB OF RHODE ISLAND
            472819044 SUBURBAN COMMUNITY HOSPITAL
            474575700 SUBURBAN COMMUNITY MEDICAL GROUP

            Today, We have rerun the prime ACA files for these EIN and we have found 1000+ employees records for these EIN. Can you please audit the additional data and let us know your view on the same because not only 109 but also more than 1000 records are missing for above EIN.

            Folder name : Folder name : Additional dataPrime File_1.zip

            Please let me know if Call is required to discuss this matter.

            AS FTP is not working so we are sending the mail for file delivery please check you mail.

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - - edited Hi Amber Love-Jones We have extracted the data from prime healthcare company for 109 employees for Jan to april month. 105 employees are exported on file. Please find the attached file Following 3 employees are not eligible for any ACA Plan So these will not come on ACA report. 1. CATHY A GIGNAC 2. LISA MILLETTE 3. GLENN MILLER Following one employee is not found in Workterra. 1. Santana Victor Folder name : Prime ACA 109 Emps Files.zip *Additional information: * We had completely blocked the following EIN so no any employee from these EIN has been exported on the ACA Prime file. 461175423 LANDMARK MEDICAL CENTER 461175423 LANDMARK PHYSICIAN OFFICE SERVICES 461175423 REHAB OF RHODE ISLAND 472819044 SUBURBAN COMMUNITY HOSPITAL 474575700 SUBURBAN COMMUNITY MEDICAL GROUP Today, We have rerun the prime ACA files for these EIN and we have found 1000+ employees records for these EIN. Can you please audit the additional data and let us know your view on the same because not only 109 but also more than 1000 records are missing for above EIN. Folder name : Folder name : Additional dataPrime File_1.zip Please let me know if Call is required to discuss this matter. AS FTP is not working so we are sending the mail for file delivery please check you mail.
            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>
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 95h 5m [ 342300 ] 84h 35m [ 304500 ]
            Time Spent 70h 55m [ 255300 ] 81h 25m [ 293100 ]
            Worklog Id 24725 [ 24725 ]
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 14/Feb/17 07:19 AM
            • Time Spent:
              2h
               

              309 employee analysis

            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Amber Love-Jones [ alov ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Remaining Estimate 84h 35m [ 304500 ] 82h 35m [ 297300 ]
            Time Spent 81h 25m [ 293100 ] 83h 25m [ 300300 ]
            Worklog Id 25063 [ 25063 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Remaining Estimate 82h 35m [ 297300 ] 74h 35m [ 268500 ]
            Time Spent 83h 25m [ 300300 ] 91h 25m [ 329100 ]
            Worklog Id 25090 [ 25090 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Remaining Estimate 74h 35m [ 268500 ] 64h 35m [ 232500 ]
            Time Spent 91h 25m [ 329100 ] 101h 25m [ 365100 ]
            Worklog Id 25093 [ 25093 ]
            Hide
            mahendra.mungase Mahendra Mungase (Inactive) added a comment -

            Hi Amber Love-Jones

            Do you have any updates on above comments 13 /Feb/17 by Nandkumar.

            Also do you have any feed back on JAN 17 - file shared by Smita on 09/Feb/17 4:55 AM.

            CC- Sachin Hingole Nandkumar Prabhakar Karlekar Smita Pawar

            Thanks.

            Show
            mahendra.mungase Mahendra Mungase (Inactive) added a comment - Hi Amber Love-Jones Do you have any updates on above comments 13 /Feb/17 by Nandkumar. Also do you have any feed back on JAN 17 - file shared by Smita on 09/Feb/17 4:55 AM. CC- Sachin Hingole Nandkumar Prabhakar Karlekar Smita Pawar Thanks.
            alov Amber Love-Jones (Inactive) made changes -
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Mahendra Mungase,

            Prime reviewed the 2017 January file and have 15 facilities that do not belong on the file and 5 facilities that have no data. The 5 facilities with no data are on the attached spreadsheet, titled Copy of IRS checkoff with password. Password will be sent separately.

            1. We have 15 facilities that came over on Workterra but are now Lawson please remove for Worterra file.
            a. Bio-Med
            b. Garden Grove
            c. Dallas medical center
            d. Southern Regional
            e. United Home health
            f. Garden City medical group
            g. Roxborough
            h. Lower Bucks
            i. Dallas medical group
            j. St. Clares
            k. St. Michaels
            l. Garden City
            m. Lake Huron medical group
            n. BMC
            o. Glendora

            2. Missing the following facilities Completely on January Workterra file:
            a. River valley Physicians - Workterra
            b. Coshocton - Workterra
            c. East Liverpool - Workterra
            d. Ohio Valley Home Health - Workterra
            e. Ohio Valley Home Care – Workterra.

            Also the count for Centinela Hospital looks really low 848 - please confirm if WT is pulling the correct data as from the individual servers?

            Can you please revise and send over a January 2017 file as soon as possible?

            Thank you.

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Mahendra Mungase , Prime reviewed the 2017 January file and have 15 facilities that do not belong on the file and 5 facilities that have no data. The 5 facilities with no data are on the attached spreadsheet, titled Copy of IRS checkoff with password . Password will be sent separately. 1. We have 15 facilities that came over on Workterra but are now Lawson please remove for Worterra file. a. Bio-Med b. Garden Grove c. Dallas medical center d. Southern Regional e. United Home health f. Garden City medical group g. Roxborough h. Lower Bucks i. Dallas medical group j. St. Clares k. St. Michaels l. Garden City m. Lake Huron medical group n. BMC o. Glendora 2. Missing the following facilities Completely on January Workterra file: a. River valley Physicians - Workterra b. Coshocton - Workterra c. East Liverpool - Workterra d. Ohio Valley Home Health - Workterra e. Ohio Valley Home Care – Workterra. Also the count for Centinela Hospital looks really low 848 - please confirm if WT is pulling the correct data as from the individual servers? Can you please revise and send over a January 2017 file as soon as possible? Thank you.
            Hide
            mahendra.mungase Mahendra Mungase (Inactive) added a comment -

            Hi Smita Pawar

            Can you please go through the comments.

            Thanks

            Show
            mahendra.mungase Mahendra Mungase (Inactive) added a comment - Hi Smita Pawar Can you please go through the comments. Thanks
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Assignee Amber Love-Jones [ alov ] Smita Pawar [ smita.pawar ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Revansiddha Gaur [ revansiddha.gaur ]
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited

            As per comments of Amber Love-Jones below are the action points for us...

            • 15 Facilities data need to be removed
            • 5 Facilities data need to be added
            • The count for Centinela Hospital looks really low 848 confirmation.
            • By revising send over a January 2017 file.

            Mahendra Mungase Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited As per comments of Amber Love-Jones below are the action points for us... 15 Facilities data need to be removed 5 Facilities data need to be added The count for Centinela Hospital looks really low 848 confirmation. By revising send over a January 2017 file. Mahendra Mungase Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Amber Love-Jones,

            15 Facilities data need to be removed & 5 Facilities which needs to be added newly
            Please find the attached excel sheet & mark in the column 'Include/Exclude' EINs to consider or not to be considered.So that it will be helpful to process the file with more accuracy in single cycle. In addition to this we have considered 5 Facilities which needs to be added newly in the attached sheet.

            The count for Centinela Hospital looks really low 848 confirmation.
            We have considered Centinela Hospital Facility only & we confirmed again. If we need to consider any other standard population please let us know.

            Attachment
            List of EINs to include or exclude for Year 2017 Prime Files.xlsx

            Note : Password will be sent separately by mail.

            Regards,
            Revan

            Mahendra Mungase Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Amber Love-Jones , 15 Facilities data need to be removed & 5 Facilities which needs to be added newly Please find the attached excel sheet & mark in the column 'Include/Exclude' EINs to consider or not to be considered.So that it will be helpful to process the file with more accuracy in single cycle. In addition to this we have considered 5 Facilities which needs to be added newly in the attached sheet. The count for Centinela Hospital looks really low 848 confirmation. We have considered Centinela Hospital Facility only & we confirmed again. If we need to consider any other standard population please let us know. Attachment List of EINs to include or exclude for Year 2017 Prime Files.xlsx Note : Password will be sent separately by mail. Regards, Revan Mahendra Mungase Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Amber Love-Jones [ alov ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 64h 35m [ 232500 ] 58h 5m [ 209100 ]
            Time Spent 101h 25m [ 365100 ] 107h 55m [ 388500 ]
            Worklog Id 27239 [ 27239 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 58h 5m [ 209100 ] 57h 35m [ 207300 ]
            Time Spent 107h 55m [ 388500 ] 108h 25m [ 390300 ]
            Worklog Id 27239 [ 27239 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 24/Feb/17 10:00 PM - edited
            • Time Spent:
              7h
               

              Analysis, discussion & reply.

            alov Amber Love-Jones (Inactive) made changes -
            Hide
            alov Amber Love-Jones (Inactive) added a comment - - edited

            Hello Revansiddha Gaur,

            Please find Prime's comments from your notes yesterday in red. I made additional comments back to Prime in blue.

            15 Facilities data need to be removed & 5 Facilities which needs to be added newly
            Please find the attached excel sheet. Please populate the 'Include/Exclude' column for EINs to be considered or not to be considered. This will be helpful to process the file with more accuracy in a single cycle. The missing 5 Facilities have been added in the attached sheet. Please add the EIN.

            See attached spread sheet to send over to Development I’m just curious the understanding I have is that the facility notifies you that we will no longer be utilizing your services? As of January the benefits coordinators no longer have access to Workterra so apparently someone took away their rights so why do we still continue to get information on out reporting side?

            We have alerted Development and EDI of the facilities that went to Lawson effective 1/1/2017 so that any reporting is stopped.

            The count for Centinela Hospital looks really low 848 confirmation.
            We have considered Centinela Hospital Facility only & we confirmed the 848 number again. If we need to consider any other standard population please let us know.

            There is a discrepancy of 462 Employees between December 2016 and January 2017 data please analysis and advise

            Development will need to review and provide an answer to your question

            Attachment
            List of EINs to include or exclude for Year 2017 Prime Files.xlsx

            This list that was sent to us has 9 Employer Names that were incorrect on your original file above? Again just out of curiosity how does something like this happen I have concerns that we have incorrect data in your system across the board? Please advise -

            Development has been properly updated regarding the facilities.

            Attached, please find the updated EIN Listing along with the 2016 ACA file where Centinela has approximately 400 more employees than the report you provided. Password will be emailed to Revansiddha Gaur.

            Show
            alov Amber Love-Jones (Inactive) added a comment - - edited Hello Revansiddha Gaur , Please find Prime's comments from your notes yesterday in red . I made additional comments back to Prime in blue . 15 Facilities data need to be removed & 5 Facilities which needs to be added newly Please find the attached excel sheet. Please populate the 'Include/Exclude' column for EINs to be considered or not to be considered. This will be helpful to process the file with more accuracy in a single cycle. The missing 5 Facilities have been added in the attached sheet. Please add the EIN. See attached spread sheet to send over to Development I’m just curious the understanding I have is that the facility notifies you that we will no longer be utilizing your services? As of January the benefits coordinators no longer have access to Workterra so apparently someone took away their rights so why do we still continue to get information on out reporting side? We have alerted Development and EDI of the facilities that went to Lawson effective 1/1/2017 so that any reporting is stopped. The count for Centinela Hospital looks really low 848 confirmation. We have considered Centinela Hospital Facility only & we confirmed the 848 number again. If we need to consider any other standard population please let us know. There is a discrepancy of 462 Employees between December 2016 and January 2017 data please analysis and advise – Development will need to review and provide an answer to your question Attachment List of EINs to include or exclude for Year 2017 Prime Files.xlsx This list that was sent to us has 9 Employer Names that were incorrect on your original file above? Again just out of curiosity how does something like this happen I have concerns that we have incorrect data in your system across the board? Please advise - Development has been properly updated regarding the facilities. Attached, please find the updated EIN Listing along with the 2016 ACA file where Centinela has approximately 400 more employees than the report you provided. Password will be emailed to Revansiddha Gaur .
            alov Amber Love-Jones (Inactive) made changes -
            Assignee Amber Love-Jones [ alov ] Revansiddha Gaur [ revansiddha.gaur ]
            smita.pawar Smita Pawar (Inactive) logged work - 27/Feb/17 11:37 AM
            • Time Spent:
              0.5h
               

              Internal discussion

            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Amber Love-Jones,

            Here we are let you that, We are going to furnish the Jan Full File & Feb Change File till 10 March.

            Regards,
            Revan

            Mahendra MungaseSmita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Amber Love-Jones , Here we are let you that, We are going to furnish the Jan Full File & Feb Change File till 10 March. Regards, Revan Mahendra Mungase Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 57h 35m [ 207300 ] 57h 5m [ 205500 ]
            Time Spent 108h 25m [ 390300 ] 108h 55m [ 392100 ]
            Worklog Id 28025 [ 28025 ]
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hi Revansiddha Gaur,

            I have advised the client that these files will not be available until March 10, 2017. The client may not be happy with the delay, but I will respond back if I hear anything from them.

            Thank you.

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hi Revansiddha Gaur , I have advised the client that these files will not be available until March 10, 2017. The client may not be happy with the delay, but I will respond back if I hear anything from them. Thank you. Amber
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 03/Mar/17 01:16 AM
            • Time Spent:
              3h
               
              <No comment>
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Remaining Estimate 57h 5m [ 205500 ] 54h 5m [ 194700 ]
            Time Spent 108h 55m [ 392100 ] 111h 55m [ 402900 ]
            Worklog Id 29127 [ 29127 ]
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Amber Love-Jones,

            To be included below EINs which are mentioned in the list in excel file- Copy of List of EINs to include or exclude for Year 2017 Prime Files (003)_UPDATED with password.xlsx we couldn't find the names in the class1name i.e. facility class. So we have stuck in the process of files. So here we are requesting you to please create the eligibility rule for below employers & let us know.

            • River valley Physicians (part of East Liverpool)
            • Coshocton 
            • East Liverpool
            • Ohio Valley Home Health (part of East Liverpool)
            • Ohio Valley Home Care (part of East Liverpool)

            Please response asap so that we can furnish the files within deadline.

            Regards,
            Revan

            Smita Pawar Mahendra Mungase Sachin Hingole Nandkumar Prabhakar Karlekar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Amber Love-Jones , To be included below EINs which are mentioned in the list in excel file- Copy of List of EINs to include or exclude for Year 2017 Prime Files (003)_UPDATED with password.xlsx we couldn't find the names in the class1name i.e. facility class. So we have stuck in the process of files. So here we are requesting you to please create the eligibility rule for below employers & let us know. River valley Physicians (part of East Liverpool) Coshocton  East Liverpool Ohio Valley Home Health (part of East Liverpool) Ohio Valley Home Care (part of East Liverpool) Please response asap so that we can furnish the files within deadline. Regards, Revan Smita Pawar Mahendra Mungase Sachin Hingole Nandkumar Prabhakar Karlekar
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Amber Love-Jones [ alov ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 06/Mar/17 10:00 PM
            • Time Spent:
              7h
               

              File procesing Jan-2017

            alov Amber Love-Jones (Inactive) made changes -
            Attachment screenshot-1.png [ 41511 ]
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Revansiddha Gaur,

            Coshocton is a new, separate facility in WorkTerra with all plans effective 1/1/2017.

            Eastliverpool is a new, separate facility in WorkTerra with all plans effective 1/1/2017. The other names listed above are classes within the facility:

            Please advise what you mean when asking to "create the eligibility rule for below employers."

            Thank you.

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Revansiddha Gaur , Coshocton is a new, separate facility in WorkTerra with all plans effective 1/1/2017. Eastliverpool is a new, separate facility in WorkTerra with all plans effective 1/1/2017. The other names listed above are classes within the facility: Please advise what you mean when asking to "create the eligibility rule for below employers." Thank you. Amber
            alov Amber Love-Jones (Inactive) made changes -
            Assignee Amber Love-Jones [ alov ] Revansiddha Gaur [ revansiddha.gaur ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 07/Mar/17 01:38 AM
            • Time Spent:
              6h
               
              <No comment>
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 54h 5m [ 194700 ] 47h 5m [ 169500 ]
            Time Spent 111h 55m [ 402900 ] 118h 55m [ 428100 ]
            Worklog Id 29333 [ 29333 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 07/Mar/17 10:00 PM
            • Time Spent:
              7h
               

              File Process.

            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 47h 5m [ 169500 ] 40h 5m [ 144300 ]
            Time Spent 118h 55m [ 428100 ] 125h 55m [ 453300 ]
            Worklog Id 29589 [ 29589 ]
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited

            Hi Amber Love-Jones,

            We have found 7 employees in two companies by different classes. Please review those employees which are listed below & let us know which companies employees should we refer to process the files?

            Company Name : PrimeHealthcare

            FirstName LastName Class 1 Name
            SANDRA GRISHAM Providence Medical Center
            Debra Bonnett Saint John Hospital
            Christopher Mallon Saint John Hospital
            Elizabeth Simpson Saint John Hospital
            TAMMY DETERDING Saint John Hospital
            Mary Richter Saint John Hospital
            Toni Bond Saint John Hospital

            Company Name : Prime Healthcare

            FirstName LastName Class 1 Name
            SANDRA GRISHAM Providence Medical Center
            Debra Bonnett Providence Medical Center
            Christopher Mallon Providence Medical Center
            Elizabeth Simpson Providence Medical Center
            TAMMY DETERDING Providence Medical Center
            Mary Richter Providence Medical Center
            Toni Bond Providence Medical Center

            Regards,
            Revan

            Smita Pawar Mahendra Mungase Sachin Hingole Nandkumar Prabhakar Karlekar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited Hi Amber Love-Jones , We have found 7 employees in two companies by different classes. Please review those employees which are listed below & let us know which companies employees should we refer to process the files? Company Name : PrimeHealthcare FirstName LastName Class 1 Name SANDRA GRISHAM Providence Medical Center Debra Bonnett Saint John Hospital Christopher Mallon Saint John Hospital Elizabeth Simpson Saint John Hospital TAMMY DETERDING Saint John Hospital Mary Richter Saint John Hospital Toni Bond Saint John Hospital Company Name : Prime Healthcare FirstName LastName Class 1 Name SANDRA GRISHAM Providence Medical Center Debra Bonnett Providence Medical Center Christopher Mallon Providence Medical Center Elizabeth Simpson Providence Medical Center TAMMY DETERDING Providence Medical Center Mary Richter Providence Medical Center Toni Bond Providence Medical Center Regards, Revan Smita Pawar Mahendra Mungase Sachin Hingole Nandkumar Prabhakar Karlekar
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Amber Love-Jones [ alov ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            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.

            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Revansiddha Gaur,

            All of these employees fall under PrimeHealhcare (no space). Please confirm that the reporting will be available by Friday, 3/10 for the client.

            Thank you.

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Revansiddha Gaur , All of these employees fall under PrimeHealhcare (no space). Please confirm that the reporting will be available by Friday, 3/10 for the client. Thank you. Amber
            alov Amber Love-Jones (Inactive) made changes -
            Assignee Amber Love-Jones [ alov ] Revansiddha Gaur [ revansiddha.gaur ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 40h 5m [ 144300 ] 32h 35m [ 117300 ]
            Time Spent 125h 55m [ 453300 ] 133h 25m [ 480300 ]
            Worklog Id 29859 [ 29859 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Worklog Id 29859 [ 29859 ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Amber Love-Jones [ alov ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            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

            ]
            Hide
            mahendra.mungase Mahendra Mungase (Inactive) added a comment -

            Hi Amber Love-Jones

            We will share Jan 17 files on tomorrow EOD.

            Thanks

            Show
            mahendra.mungase Mahendra Mungase (Inactive) added a comment - Hi Amber Love-Jones We will share Jan 17 files on tomorrow EOD. Thanks
            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.

            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Mahendra Mungase,

            I understand that your team will have updated January 2017 and February 2017 files available tomorrow, 3/10/2017. Will the regular monthly file for March also be available tomorrow, 3/10/2017, or will that file be completed on April 10, 2017?

            Thank you!

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Mahendra Mungase , I understand that your team will have updated January 2017 and February 2017 files available tomorrow, 3/10/2017. Will the regular monthly file for March also be available tomorrow, 3/10/2017, or will that file be completed on April 10, 2017? Thank you! Amber
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 32h 35m [ 117300 ] 21h 50m [ 78600 ]
            Time Spent 133h 25m [ 480300 ] 144h 10m [ 519000 ]
            Worklog Id 30141 [ 30141 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Amber Love-Jones [ alov ] Revansiddha Gaur [ revansiddha.gaur ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Smita Pawar [ smita.pawar ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 21h 50m [ 78600 ] 16h 20m [ 58800 ]
            Time Spent 144h 10m [ 519000 ] 149h 40m [ 538800 ]
            Worklog Id 30312 [ 30312 ]
            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

            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Amber Love-Jones,

            We have uploaded prime files for the month of Jan & Feb 2017 on EBS FTP.
            March file will be available on Apr 10, 2017.

            Details about uploaded files are as follows.

            URL:https://ftpsecure.ebsbenefits.com
            Path:/users/workterraaca/Prime/Primefacility03102017
            Zip file name-Jan Feb File
            File names-
            1.Jan2017_EMP_Full.xls
            2.Jan2017_DEP_Full.xls
            3.Feb2017_EMP_Change.xls
            4.Feb2017_DEP_Change.xls

            Let us know, if you need any additional information.

            Note: Testing of Feb 2017- Change files is in progress.
            We will update you testing status for Feb file on Mar 16, 2017

            Thanks,
            Smita

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

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Amber Love-Jones , We have uploaded prime files for the month of Jan & Feb 2017 on EBS FTP. March file will be available on Apr 10, 2017. Details about uploaded files are as follows. URL: https://ftpsecure.ebsbenefits.com Path:/users/workterraaca/Prime/Primefacility03102017 Zip file name-Jan Feb File File names- 1.Jan2017_EMP_Full.xls 2.Jan2017_DEP_Full.xls 3.Feb2017_EMP_Change.xls 4.Feb2017_DEP_Change.xls Let us know, if you need any additional information. Note: Testing of Feb 2017- Change files is in progress. We will update you testing status for Feb file on Mar 16, 2017 Thanks, Smita FYI Nandkumar Prabhakar Karlekar , Sachin Hingole , Revansiddha Gaur , Kumar Chhajed , Mahendra Mungase
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 16h 20m [ 58800 ] 13h 20m [ 48000 ]
            Time Spent 149h 40m [ 538800 ] 152h 40m [ 549600 ]
            Worklog Id 30361 [ 30361 ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Remaining Estimate 13h 20m [ 48000 ] 10h 20m [ 37200 ]
            Time Spent 152h 40m [ 549600 ] 155h 40m [ 560400 ]
            Worklog Id 30372 [ 30372 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 10/Mar/17 10:00 PM
            • Time Spent:
              5.5h
               

              Files-Feb Change File generation & verification.

            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Thank you, Smita Pawar. I will let you know if the client has any additional questions.

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Thank you, Smita Pawar . I will let you know if the client has any additional questions. Amber
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Remaining Estimate 10h 20m [ 37200 ] 4h 20m [ 15600 ]
            Time Spent 155h 40m [ 560400 ] 161h 40m [ 582000 ]
            Worklog Id 31680 [ 31680 ]
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Amber Love-Jones,

            Can you please let us know the feedback for provided files of Jan & Feb?
            Once approved that files we can be able to start the process for March file.

            Regards,
            Revan
            Smita Pawar Nandkumar Prabhakar Karlekar Sachin Hingole

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Amber Love-Jones , Can you please let us know the feedback for provided files of Jan & Feb? Once approved that files we can be able to start the process for March file. Regards, Revan Smita Pawar Nandkumar Prabhakar Karlekar Sachin Hingole
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Revansiddha Gaur,

            The client advised that they are still reviewing the January and February 2017 reports and will have updates later this afternoon. However, they did point out that Southern Regional is still coming across the January and February files. Southern Regional is no longer with WorkTerra as of 12/31/2016. The other Prime_Healthcare facilities that left WorkTerra as well are:

            • Garden Grove (breakout as GGH in WorkTerra)
            • Dallas Medical Center (breakout as DMC in WorkTerra)
            • St. Clares (under Prime_Healthcare in WorkTerra)
            • St. Mary's Passaic (under Prime_Healthcare in WorkTerra)
            • Lower Bucks Union & Non-Union (under Prime_Healthcare in WorkTerra)
            • Roxborough (under Prime_Healthcare in WorkTerra)

            Thank you.

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Revansiddha Gaur , The client advised that they are still reviewing the January and February 2017 reports and will have updates later this afternoon. However, they did point out that Southern Regional is still coming across the January and February files. Southern Regional is no longer with WorkTerra as of 12/31/2016. The other Prime_Healthcare facilities that left WorkTerra as well are: Garden Grove (breakout as GGH in WorkTerra) Dallas Medical Center (breakout as DMC in WorkTerra) St. Clares (under Prime_Healthcare in WorkTerra) St. Mary's Passaic (under Prime_Healthcare in WorkTerra) Lower Bucks Union & Non-Union (under Prime_Healthcare in WorkTerra) Roxborough (under Prime_Healthcare in WorkTerra) Thank you.
            alov Amber Love-Jones (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Revansiddha Gaur [ revansiddha.gaur ]
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Amber Love-Jones,

            We are giving you the Jan,Feb,Mar files before 10th April. Is this OK ? please let us know.

            Regards,
            Revan

            Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Amber Love-Jones , We are giving you the Jan,Feb,Mar files before 10th April. Is this OK ? please let us know. Regards, Revan Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 23/Mar/17 09:00 PM
            • Time Spent:
              20m
               

              Jira reply.

            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Revansiddha Gaur,

            I would prefer to wait until the client has provided feedback on the January and February files we already sent on 3/10/17. I will keep you updated on when I hear back from Prime.

            Thank you,

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Revansiddha Gaur , I would prefer to wait until the client has provided feedback on the January and February files we already sent on 3/10/17. I will keep you updated on when I hear back from Prime. Thank you, Amber
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 4h 20m [ 15600 ] 4h [ 14400 ]
            Time Spent 161h 40m [ 582000 ] 162h [ 583200 ]
            Worklog Id 33410 [ 33410 ]
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Amber Love-Jones,

            Can you please expedite for the feedbacks on the Jan & Feb files? which will help to furnish the files within deadlines.

            Thanks & Regards,
            Revan

            Smita Pawar Nandkumar Prabhakar Karlekar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Amber Love-Jones , Can you please expedite for the feedbacks on the Jan & Feb files? which will help to furnish the files within deadlines. Thanks & Regards, Revan Smita Pawar Nandkumar Prabhakar Karlekar
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Amber Love-Jones [ alov ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 3.5h [ 12600 ]
            Time Spent 162h [ 583200 ] 162.5h [ 585000 ]
            Worklog Id 33639 [ 33639 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Worklog Id 33639 [ 33639 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 24/Mar/17 09:00 PM - edited
            • Time Spent:
              0.5h
               

              REPLY.

            alov Amber Love-Jones (Inactive) made changes -
            Attachment screenshot-2.png [ 43303 ]
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Revansiddha Gaur,

            Prime (the client) has provided some feedback on the reporting provided on 10/Mar/17 5:52 AM. Please see comments below:

            Prime is looking at the January file for Sherman Oaks and below are the following concerns:

            1. There are employees that are on the Workterra system but are not being pulled when you send the file.

            • Example Carlos Canas - He is set up on Workterra as an active employee but he is not on the January file as an Opt out. Screenshot below shows that employee is enrolled in Waive Medical Opt Out Plan effective 1/1/2017:
              This enrollment missing will cause an error Prime has him as an employee client is not offering him medical benefits.

            Client states that they don't believe the files are right as they have over 80 discrepancies on the Sherman Oaks facility alone. Client will try to pull examples in the other Prime facilities for Development to research.

            Client believes that they are still not seeing the opt out credits on the January and February files. Please research and add 2017 Waive Medical Opt Out plans to the files.

            Thank you,

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Revansiddha Gaur , Prime (the client) has provided some feedback on the reporting provided on 10/Mar/17 5:52 AM. Please see comments below: Prime is looking at the January file for Sherman Oaks and below are the following concerns: 1. There are employees that are on the Workterra system but are not being pulled when you send the file. Example Carlos Canas - He is set up on Workterra as an active employee but he is not on the January file as an Opt out. Screenshot below shows that employee is enrolled in Waive Medical Opt Out Plan effective 1/1/2017: This enrollment missing will cause an error Prime has him as an employee client is not offering him medical benefits. Client states that they don't believe the files are right as they have over 80 discrepancies on the Sherman Oaks facility alone. Client will try to pull examples in the other Prime facilities for Development to research. Client believes that they are still not seeing the opt out credits on the January and February files. Please research and add 2017 Waive Medical Opt Out plans to the files. Thank you, Amber
            Hide
            jjsassy99 Jennifer Johnson (Inactive) added a comment -

            All - Please hold off on the above until we have completed the files for WT-8253 - We need the Southern Regional files completed 1st!

            Thanks!

            Jenni

            Show
            jjsassy99 Jennifer Johnson (Inactive) added a comment - All - Please hold off on the above until we have completed the files for WT-8253 - We need the Southern Regional files completed 1st! Thanks! Jenni
            jjsassy99 Jennifer Johnson (Inactive) made changes -
            Assignee Amber Love-Jones [ alov ] Jennifer Fernandes [ jjsassy99 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 3.5h [ 12600 ] 0h [ 0 ]
            Time Spent 162.5h [ 585000 ] 169.5h [ 610200 ]
            Worklog Id 35426 [ 35426 ]
            smita.pawar Smita Pawar (Inactive) logged work - 01/Apr/17 06:18 AM
            • Time Spent:
              7h
               
              <No comment>
            Hide
            alov Amber Love-Jones (Inactive) added a comment - - edited

            Hello Smita Pawar,

            Please commence on processing March 2017 files.

            Client did have an item that they would like Dev to research:
            Saint Marys Reno Anesthesia for 2017 now shows none of the employees on WT's reporting exist in Prime's employee files. Prime is asking why they don't have any records of the actual employees that work under the FEIN 300852838.

            For example Shane Kruitbosch EEID198069 is active on WT under Saint Mary’s Medical Group but Prime hase him working at Saint Marys Reno Anesthesia.
            Karen Willemsen EEID1089 is under Saint Marys Reno Anesthesia FEIN on your report but Prime does not show this employee working for Prime at all. Note: This employee is listed under Summit Surgery Center at Saint Marys Galena, which is no longer with WorkTerra as of 9/30/2016.

            Can you please look at these examples and advise the client what is going on with this FEIN? Prime advises that the 2016 files were fine for this FEIN, so can a comparison be run between 2016 and 2017 to see what changed?

            Thank you.
            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - - edited Hello Smita Pawar , Please commence on processing March 2017 files. Client did have an item that they would like Dev to research: Saint Marys Reno Anesthesia for 2017 now shows none of the employees on WT's reporting exist in Prime's employee files. Prime is asking why they don't have any records of the actual employees that work under the FEIN 300852838. For example Shane Kruitbosch EEID198069 is active on WT under Saint Mary’s Medical Group but Prime hase him working at Saint Marys Reno Anesthesia. Karen Willemsen EEID1089 is under Saint Marys Reno Anesthesia FEIN on your report but Prime does not show this employee working for Prime at all. Note: This employee is listed under Summit Surgery Center at Saint Marys Galena, which is no longer with WorkTerra as of 9/30/2016. Can you please look at these examples and advise the client what is going on with this FEIN? Prime advises that the 2016 files were fine for this FEIN, so can a comparison be run between 2016 and 2017 to see what changed? Thank you. Amber
            alov Amber Love-Jones (Inactive) made changes -
            Assignee Jennifer Fernandes [ jjsassy99 ] Smita Pawar [ smita.pawar ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Revansiddha Gaur [ revansiddha.gaur ]
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited

            Hi Amber Love-Jones,

            Comment Link
            https://workterra.atlassian.net/browse/WT-8076?focusedCommentId=97429&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-97429
            Prime (the client) has provided some feedback on the reporting provided on 10/Mar/17 5:52 AM. Please see comments below:
            Prime is looking at the January file for Sherman Oaks and below are the following concerns:
            1. There are employees that are on the Workterra system but are not being pulled when you send the file.
            Example Carlos Canas - He is set up on Workterra as an active employee but he is not on the January file as an Opt out. Screenshot below shows that employee is enrolled in Waive Medical Opt Out Plan effective 1/1/2017: screenshot-2.png
            This enrollment missing will cause an error Prime has him as an employee client is not offering him medical benefits.
            Client states that they don't believe the files are right as they have over 80 discrepancies on the Sherman Oaks facility alone. Client will try to pull examples in the other Prime facilities for Development to research.
            Client believes that they are still not seeing the opt out credits on the January and February files. Please research and add 2017 Waive Medical Opt Out plans to the files.
            [Harbinger]
            As we process the files who has offer but 'Carlos Canas' employee doesn't have any aca plans offer i.e. Line 14 Code 1H & 'Waive Medical Opt Out ' plan is not marked as ACA Plan.So that the mentioned employee is not expected to be on the file.
            We verified that the employees who has aca plan offers but enrolled in medical opt out plans are already pulled out on the file. and whoever enrolled in 'Waive medical opt out
            plans' that employees 'Plan Code Accepted' has been set as blank as given instruction by you in the jira(https://workterra.atlassian.net/browse/WT-663?focusedCommentId=40270&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-40270).
            We have set blank for containing waive keyword in the 'Plan Code Accepted' . Please let us know do you require as blank for 'Medical Opt Out' plan also.?
            Comment Link-https://workterra.atlassian.net/browse/WT-8076?focusedCommentId=100436&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-100436
            Please commence on processing March 2017 files.
            Client did have an item that they would like Dev to research:
            Saint Marys Reno Anesthesia for 2017 now shows none of the employees on WT's reporting exist in Prime's employee files. Prime is asking why they don't have any records of the actual employees that work under the FEIN 300852838.
            For example
            Shane Kruitbosch EEID198069 is active on WT under Saint Mary’s Medical Group but Prime hase him working at Saint Marys Reno Anesthesia.
            Karen Willemsen EEID1089 is under Saint Marys Reno Anesthesia FEIN on your report but Prime does not show this employee working for Prime at all. Note: This employee is listed under Summit Surgery Center at Saint Marys Galena, which is no longer with WorkTerra as of 9/30/2016.
            Can you please look at these examples and advise the client what is going on with this FEIN? Prime advises that the 2016 files were fine for this FEIN, so can a comparison be run between 2016 and 2017 to see what changed?
            [Harbinger]
            1.Shane Kruitbosch EEID198069-As per current customization the employee is found on file under the ein-455557052 i.e. Saint Marys Medical Group.
            These are two classes with different EIN .And Saint Marys Reno Anesthesia class (Reno Tahoe Anesthesiology) has no employee on Prime space healthcare.
            If you need this employee required under this Saint Marys Reno Anesthesia.
            We need to change the EIN in backend. Please let us know your confirmation to process accordingly.
            2.Karen Willemsen EEID1089- As per current customization the employee is found on file under the ein-300852838 Reno Tahoe Anesthesia- St Mary's
            We are stopping all employees of Summit Surgery Center at Saint Marys Galena

            Can you please provide us the consolidated discrepancy details, so that we can analyse before processing for March file?

            Note : We can not start to process the March files unless and untill confirm the files are valid for Jan and Feb files.

            Thanks,
            Revan

            Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited Hi Amber Love-Jones , Comment Link https://workterra.atlassian.net/browse/WT-8076?focusedCommentId=97429&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-97429 Prime (the client) has provided some feedback on the reporting provided on 10/Mar/17 5:52 AM. Please see comments below: Prime is looking at the January file for Sherman Oaks and below are the following concerns: 1. There are employees that are on the Workterra system but are not being pulled when you send the file. Example Carlos Canas - He is set up on Workterra as an active employee but he is not on the January file as an Opt out. Screenshot below shows that employee is enrolled in Waive Medical Opt Out Plan effective 1/1/2017: screenshot-2.png This enrollment missing will cause an error Prime has him as an employee client is not offering him medical benefits. Client states that they don't believe the files are right as they have over 80 discrepancies on the Sherman Oaks facility alone. Client will try to pull examples in the other Prime facilities for Development to research. Client believes that they are still not seeing the opt out credits on the January and February files. Please research and add 2017 Waive Medical Opt Out plans to the files. [Harbinger] As we process the files who has offer but 'Carlos Canas' employee doesn't have any aca plans offer i.e. Line 14 Code 1H & 'Waive Medical Opt Out ' plan is not marked as ACA Plan.So that the mentioned employee is not expected to be on the file. We verified that the employees who has aca plan offers but enrolled in medical opt out plans are already pulled out on the file. and whoever enrolled in 'Waive medical opt out plans' that employees 'Plan Code Accepted' has been set as blank as given instruction by you in the jira( https://workterra.atlassian.net/browse/WT-663?focusedCommentId=40270&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-40270 ). We have set blank for containing waive keyword in the 'Plan Code Accepted' . Please let us know do you require as blank for 'Medical Opt Out' plan also.? Comment Link- https://workterra.atlassian.net/browse/WT-8076?focusedCommentId=100436&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-100436 Please commence on processing March 2017 files. Client did have an item that they would like Dev to research: Saint Marys Reno Anesthesia for 2017 now shows none of the employees on WT's reporting exist in Prime's employee files. Prime is asking why they don't have any records of the actual employees that work under the FEIN 300852838. For example Shane Kruitbosch EEID198069 is active on WT under Saint Mary’s Medical Group but Prime hase him working at Saint Marys Reno Anesthesia. Karen Willemsen EEID1089 is under Saint Marys Reno Anesthesia FEIN on your report but Prime does not show this employee working for Prime at all. Note: This employee is listed under Summit Surgery Center at Saint Marys Galena, which is no longer with WorkTerra as of 9/30/2016. Can you please look at these examples and advise the client what is going on with this FEIN? Prime advises that the 2016 files were fine for this FEIN, so can a comparison be run between 2016 and 2017 to see what changed? [Harbinger] 1.Shane Kruitbosch EEID198069-As per current customization the employee is found on file under the ein-455557052 i.e. Saint Marys Medical Group. These are two classes with different EIN .And Saint Marys Reno Anesthesia class (Reno Tahoe Anesthesiology) has no employee on Prime space healthcare. If you need this employee required under this Saint Marys Reno Anesthesia. We need to change the EIN in backend. Please let us know your confirmation to process accordingly. 2.Karen Willemsen EEID1089- As per current customization the employee is found on file under the ein-300852838 Reno Tahoe Anesthesia- St Mary's We are stopping all employees of Summit Surgery Center at Saint Marys Galena Can you please provide us the consolidated discrepancy details, so that we can analyse before processing for March file? Note : We can not start to process the March files unless and untill confirm the files are valid for Jan and Feb files. Thanks, Revan Smita Pawar Sachin Hingole Nandkumar Prabhakar Karlekar
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Amber Love-Jones [ alov ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 169.5h [ 610200 ] 176.5h [ 635400 ]
            Worklog Id 37584 [ 37584 ]
            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) made changes -
            Time Spent 176.5h [ 635400 ] 184.5h [ 664200 ]
            Worklog Id 37934 [ 37934 ]
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Per Mahendra Mungase, I am adding all new information for January 2017 going forward to WT-8255.

            Thank you.

            Show
            alov Amber Love-Jones (Inactive) added a comment - Per Mahendra Mungase , I am adding all new information for January 2017 going forward to WT-8255 . Thank you.
            alov Amber Love-Jones (Inactive) made changes -
            Assignee Amber Love-Jones [ alov ] Revansiddha Gaur [ revansiddha.gaur ]
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 14/Apr/17 09:00 PM
            • Time Spent:
              6h
               

              Call Document Preparation.

            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 184.5h [ 664200 ] 190.5h [ 685800 ]
            Worklog Id 38533 [ 38533 ]
            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.

            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 190.5h [ 685800 ] 192.5h [ 693000 ]
            Worklog Id 39534 [ 39534 ]
            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) made changes -
            Time Spent 192.5h [ 693000 ] 194.5h [ 700200 ]
            Worklog Id 41657 [ 41657 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 194.5h [ 700200 ] 199.5h [ 718200 ]
            Worklog Id 42209 [ 42209 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 199.5h [ 718200 ] 202.5h [ 729000 ]
            Worklog Id 42619 [ 42619 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 202.5h [ 729000 ] 203.5h [ 732600 ]
            Worklog Id 42623 [ 42623 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Worklog Id 42623 [ 42623 ]
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Smita Pawar, Nandkumar Prabhakar Karlekar,

            Hello,

            While we are waiting for WT-9121 to be completed, the client has advised that they have an answer regarding Summit Surgery Center Galena employees. These employees are under contract and have a TPA which processes their 1095 C's, so these employees do not need to be included in any ACA reporting for 2017.

            Thank you,

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Smita Pawar , Nandkumar Prabhakar Karlekar , Hello, While we are waiting for WT-9121 to be completed, the client has advised that they have an answer regarding Summit Surgery Center Galena employees. These employees are under contract and have a TPA which processes their 1095 C's, so these employees do not need to be included in any ACA reporting for 2017. Thank you, Amber
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Revansiddha Gaur, Smita Pawar

            Attached, please find screenshots and explanation from Prime regarding St. Marys Reno Anesthesia employees being reported under St Marys Medical Group.

            Thank you,

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Revansiddha Gaur , Smita Pawar Attached, please find screenshots and explanation from Prime regarding St. Marys Reno Anesthesia employees being reported under St Marys Medical Group. Thank you, Amber
            alov Amber Love-Jones (Inactive) made changes -
            Attachment WT-8076 Screenshots.docx [ 47486 ]
            Hide
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            Hi Amber Love-Jones

            1. we will stop all employees from "Summit Surgery Center at St Marys Galena" class for 2017.
            2. There are no employees present in workterra for Reno Tahoe Anesthesiology class.
            3. Can you provide the list of employees [EMPID or SSN] which need to be on file for EIN 300852838 so we can take care for the same.

            Thanks
            Nandkumar

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi Amber Love-Jones we will stop all employees from "Summit Surgery Center at St Marys Galena" class for 2017. There are no employees present in workterra for Reno Tahoe Anesthesiology class. Can you provide the list of employees [EMPID or SSN] which need to be on file for EIN 300852838 so we can take care for the same. Thanks Nandkumar
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Time Spent 203.5h [ 732600 ] 205h [ 738000 ]
            Worklog Id 44279 [ 44279 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Worklog Id 44279 [ 44279 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 11/May/17 12:58 AM - edited
            • Time Spent:
              1.5h
               
              <No comment>
            alov Amber Love-Jones (Inactive) made changes -
            Attachment JIRA - WT-8076 with password.docx [ 47677 ]
            Hide
            alov Amber Love-Jones (Inactive) added a comment - - edited

            Hello Nandkumar Prabhakar Karlekar and Revansiddha Gaur,

            Attached, please find a recent request from Prime_Healthcare. Attachment is titled JIRA - WT-8076 with password. The password will be emailed to you separately.

            Screenshot #1: The employees listed should be moved over to St. Mary’s Reno Anesthesia. Prime has listed the employees below, but WT needs to create a platform for FEIN 300852838 as it currently resides in Workterra as Summit but has the Reno Anesthesia FEIN# and Summit Employees.

            Screenshot #2: For the Summit employees, they need to remain under the Summit Platform with the FEIN of 77-0615561 and should NOT BE MOVED to St Mary’s Medical. Prime Healthcare does not need these employees reported to them as they do not process their ACA – it is handled through a TPA.

            Screenshot #3: Please move those employees to St. Marys Regional Medical Center FEIN 454-

            Lastly, client advises that WT should have 4 FEIN for Prime with 3 that they need reporting on:

            Reno Anesthesia 300852838
            ST Mary’s Regional 454989022
            ST Mary Medical Group 455557052

            Thank you!

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - - edited Hello Nandkumar Prabhakar Karlekar and Revansiddha Gaur , Attached, please find a recent request from Prime_Healthcare. Attachment is titled JIRA - WT-8076 with password. The password will be emailed to you separately. Screenshot #1: The employees listed should be moved over to St. Mary’s Reno Anesthesia. Prime has listed the employees below, but WT needs to create a platform for FEIN 300852838 as it currently resides in Workterra as Summit but has the Reno Anesthesia FEIN# and Summit Employees. Screenshot #2: For the Summit employees, they need to remain under the Summit Platform with the FEIN of 77-0615561 and should NOT BE MOVED to St Mary’s Medical. Prime Healthcare does not need these employees reported to them as they do not process their ACA – it is handled through a TPA. Screenshot #3: Please move those employees to St. Marys Regional Medical Center FEIN 454- Lastly, client advises that WT should have 4 FEIN for Prime with 3 that they need reporting on: Reno Anesthesia 300852838 ST Mary’s Regional 454989022 ST Mary Medical Group 455557052 Thank you! Amber
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Revansiddha Gaur,

            Please confirm if these are updates that can be made while we're waiting for completion of WT-9121.

            Thank you,

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Revansiddha Gaur , Please confirm if these are updates that can be made while we're waiting for completion of WT-9121 . Thank you, Amber
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Amber Love-Jones,

            Please provide the SSN list in editable format
            for the below point mentioned in the "JIRA - WT-8076 with password.docx" document.

            For the Summit employees in screenshot 2 below, these employees need to remain under the Summit Platform with the FEIN of 77-0615561 and should NOT BE MOVED to St Mary’s Medical. Prime Healthcare does not need these employees reported to them as they do not process their ACA – it is handled through a TPA.

            Thanks,
            Revan
            Nandkumar Prabhakar Karlekar Smita Pawar Sachin Hingole

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Amber Love-Jones , Please provide the SSN list in editable format for the below point mentioned in the "JIRA - WT-8076 with password.docx" document. For the Summit employees in screenshot 2 below, these employees need to remain under the Summit Platform with the FEIN of 77-0615561 and should NOT BE MOVED to St Mary’s Medical. Prime Healthcare does not need these employees reported to them as they do not process their ACA – it is handled through a TPA. Thanks, Revan Nandkumar Prabhakar Karlekar Smita Pawar Sachin Hingole
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Amber Love-Jones [ alov ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            smita.pawar Smita Pawar (Inactive) logged work - 22/May/17 02:06 PM
            • Time Spent:
              1h
               

              Analysis
              Internal discussion

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 205h [ 738000 ] 206h [ 741600 ]
            Worklog Id 47791 [ 47791 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 22/May/17 09:00 PM
            • Time Spent:
              4.5h
               

              Working on client comments implementation.

            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 206h [ 741600 ] 210.5h [ 757800 ]
            Worklog Id 47800 [ 47800 ]
            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) made changes -
            Time Spent 210.5h [ 757800 ] 216h [ 777600 ]
            Worklog Id 48152 [ 48152 ]
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Revansiddha Gaur,

            The ssns have been added to those employees that need to be Reno Tahoe Anesthesia. I have attached the document, titled Reno Tahoe Anesthesia JIRA screenshot with password, and will email the password separately.

            Thank you,

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Revansiddha Gaur , The ssns have been added to those employees that need to be Reno Tahoe Anesthesia. I have attached the document, titled Reno Tahoe Anesthesia JIRA screenshot with password , and will email the password separately. Thank you, Amber
            alov Amber Love-Jones (Inactive) made changes -
            alov Amber Love-Jones (Inactive) made changes -
            Assignee Amber Love-Jones [ alov ] Revansiddha Gaur [ revansiddha.gaur ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited

            Hi Amber Love-Jones,

            Please find the excel sheet EmployeePresentInMultipleCompany.xlsx for listed out the employee which are present in multiple company. so we need input from your end that from which company employee should be considered on the file?

            For your reference one employee record in the excel sheet has been highlighted in yellow color which is active in more than one company.

            Reno Tahoe Anesthesia JIRA screenshot with password in this sheet again screen shot is attached of ssn . If its in textual information so we can copy those ssn & we query on backend & complete the task sooner. so requesting you to please provide the same in textual information.

            Thanks,
            Revan

            Note : Password will mail you.

            Nandkumar Prabhakar Karlekar Sachin Hingole Smita Pawar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited Hi Amber Love-Jones , Please find the excel sheet EmployeePresentInMultipleCompany.xlsx for listed out the employee which are present in multiple company. so we need input from your end that from which company employee should be considered on the file? For your reference one employee record in the excel sheet has been highlighted in yellow color which is active in more than one company. Reno Tahoe Anesthesia JIRA screenshot with password in this sheet again screen shot is attached of ssn . If its in textual information so we can copy those ssn & we query on backend & complete the task sooner. so requesting you to please provide the same in textual information. Thanks, Revan Note : Password will mail you. Nandkumar Prabhakar Karlekar Sachin Hingole Smita Pawar
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 24/May/17 09:00 PM
            • Time Spent:
              1h
               

              Data audit.

            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Amber Love-Jones [ alov ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 216h [ 777600 ] 217h [ 781200 ]
            Worklog Id 48567 [ 48567 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 217h [ 781200 ] 222h [ 799200 ]
            Worklog Id 48788 [ 48788 ]
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Revansiddha Gaur,

            I reviewed the excel sheet EmployeePresentInMultipleCompany.xlsx. Please confirm:

            1. Are all of these employees on the spreadsheet duplicates?
            2. If they are all duplicates, please list which facility(s) they're listed under. I don't see duplicate names, and in most cases, only one facility. Column B has COMPANYNAME listed, and Column K has CLASS1Name Listed - both appear to be the same names. Please advise.
            3. There are no lines highlighted in this report, as indicated above. Please advise.

            Thank you,

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Revansiddha Gaur , I reviewed the excel sheet EmployeePresentInMultipleCompany.xlsx. Please confirm: 1. Are all of these employees on the spreadsheet duplicates? 2. If they are all duplicates, please list which facility(s) they're listed under. I don't see duplicate names, and in most cases, only one facility. Column B has COMPANYNAME listed, and Column K has CLASS1Name Listed - both appear to be the same names. Please advise. 3. There are no lines highlighted in this report, as indicated above. Please advise. Thank you, Amber
            alov Amber Love-Jones (Inactive) made changes -
            Assignee Amber Love-Jones [ alov ] Revansiddha Gaur [ revansiddha.gaur ]
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Revansiddha Gaur,

            Please respond to comments made last week. The client is very anxious to receive their January, February, March, April and May 2017 ACA monthly reports.

            Thank you.

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Revansiddha Gaur , Please respond to comments made last week. The client is very anxious to receive their January, February, March, April and May 2017 ACA monthly reports. Thank you. Amber
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Amber Love-Jones,

            Currently we are working with Amit Thorve for Metso Files. So once we completed the same. We will schedule for the Prime files.

            Thanks,
            Revan

            Nandkumar Prabhakar Karlekar Smita Pawar Sachin Hingole

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Amber Love-Jones , Currently we are working with Amit Thorve for Metso Files. So once we completed the same. We will schedule for the Prime files. Thanks, Revan Nandkumar Prabhakar Karlekar Smita Pawar Sachin Hingole
            Yamilka.Coca Yamilka Coca (Inactive) made changes -
            Company Prime Healthcare [ 10517 ] Prime Healthcare - Southern Regional [ 10607 ]
            Hide
            Yamilka.Coca Yamilka Coca (Inactive) added a comment -

            Hello,
            This item has been escalated to Dave and Nick, in addition to myself. We need to have this item prioritized as well. Please advise, what is the estimated timeframe when we can expect the files? Thank you.

            Show
            Yamilka.Coca Yamilka Coca (Inactive) added a comment - Hello, This item has been escalated to Dave and Nick, in addition to myself. We need to have this item prioritized as well. Please advise, what is the estimated timeframe when we can expect the files? Thank you.
            Hide
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            Hi Yamilka Coca

            Currently, we are processing the metso files. As this task will get complete. we will start prime file data analysis.
            we will provide Jan Month full file for review on or before 16 June 2017.

            Please let me know you View.

            Bharti Satpute,Amit Thorve

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi Yamilka Coca Currently, we are processing the metso files. As this task will get complete. we will start prime file data analysis. we will provide Jan Month full file for review on or before 16 June 2017. Please let me know you View. Bharti Satpute , Amit Thorve
            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) made changes -
            Time Spent 222h [ 799200 ] 226h [ 813600 ]
            Worklog Id 52760 [ 52760 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 226h [ 813600 ] 242h [ 871200 ]
            Worklog Id 52768 [ 52768 ]
            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

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 242h [ 871200 ] 250h [ 900000 ]
            Worklog Id 53020 [ 53020 ]
            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>
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            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

            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Yogesh Chaudhari [ yogesh.chaudhari ]
            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

            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Amber Love-Jones,
            We have uploaded Prime Files for Jan 2017 on FTP.

            URL: https://ftpsecure.ebsbenefits.com
            Path:/users/workterraaca/Prime/Prime_facility_06082017
            File name:1. Prime -Jan-2017.zip

            Note: Zip folder contains Employee & Dependent files.
            Sending password in email

            Thanks,
            Smita

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

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Amber Love-Jones , We have uploaded Prime Files for Jan 2017 on FTP. URL: https://ftpsecure.ebsbenefits.com Path:/users/workterraaca/Prime/Prime_facility_06082017 File name:1. Prime -Jan-2017.zip Note: Zip folder contains Employee & Dependent files. Sending password in email Thanks, Smita FYI Nandkumar Prabhakar Karlekar , Rakesh Roy , Sachin Hingole , Revansiddha Gaur , Amit Thorve
            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

            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 250h [ 900000 ] 255.5h [ 919800 ]
            Worklog Id 53496 [ 53496 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 255.5h [ 919800 ] 263.5h [ 948600 ]
            Worklog Id 53497 [ 53497 ]
            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) made changes -
            Time Spent 263.5h [ 948600 ] 265.5h [ 955800 ]
            Worklog Id 53498 [ 53498 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 265.5h [ 955800 ] 273.5h [ 984600 ]
            Worklog Id 53500 [ 53500 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 273.5h [ 984600 ] 282.5h [ 1017000 ]
            Worklog Id 53501 [ 53501 ]
            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) made changes -
            Time Spent 282.5h [ 1017000 ] 293.5h [ 1056600 ]
            Worklog Id 53689 [ 53689 ]
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment - - edited

            Hi Amber Love-Jones

            We have uploaded change files for the month of Feb & March 2017.
            Below are the details of uploaded files.

            URL:https://ftpsecure.ebsbenefits.com
            Path:/users/workterraaca/Prime/Prime_facility_06092017
            Name:Prime Feb & Mar.zip

            Our Observations are as follows

            1.While testing Feb months file we observed that employee 'VICKI M MATHIS' [Company:CHMC] has a election from 01/03/2017.This employee has not a offer for a complete month in the month of Jan 2017 . Hence this employee not reflected on Jan month's full file
            and reflected on Feb month's change file.
            2.Similarly we observed that there are duplicate records of employees in more than one company and its related data e.g..
            1.CONSUELO GARCIA ---HMC Comanay
            2.JOANNE R GENN ----PMC Company

            Note: Zip folder contains Employee & Dependent files.
            Sending password in email

            Thanks,
            Smita

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

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - - edited Hi Amber Love-Jones We have uploaded change files for the month of Feb & March 2017. Below are the details of uploaded files. URL: https://ftpsecure.ebsbenefits.com Path:/users/workterraaca/Prime/Prime_facility_06092017 Name:Prime Feb & Mar.zip Our Observations are as follows 1.While testing Feb months file we observed that employee 'VICKI M MATHIS' [Company:CHMC] has a election from 01/03/2017.This employee has not a offer for a complete month in the month of Jan 2017 . Hence this employee not reflected on Jan month's full file and reflected on Feb month's change file. 2.Similarly we observed that there are duplicate records of employees in more than one company and its related data e.g.. 1.CONSUELO GARCIA ---HMC Comanay 2.JOANNE R GENN ----PMC Company Note: Zip folder contains Employee & Dependent files. Sending password in email Thanks, Smita FYI Nandkumar Prabhakar Karlekar , Rakesh Roy , Sachin Hingole , Revansiddha Gaur , Amit Thorve , Yogesh Chaudhari
            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

            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Yogesh Chaudhari and Smita Pawar,

            Thank you for sending over the February and March files.

            Below are responses to the comments you made on the select employees above.

            CHMC employee Vicki Mathis was on a LOA and returned to work on 1/3/2017, and re-elected benefits

            HMC employee Consuelo Garcia is listed with two separate ssns - awaiting confirmation of which is correct from the facility.

            PMC employee Joanne R Genn - employee is listed under PMC (Pampa Regional Medical Center) and Prime_Healthcare zDelete Pampa Regional Medical Center. Employee information should be pulled from PMC site only. Facility transferred from Prime_Healthcare to it's own site, PMC.

            Thank you,

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Yogesh Chaudhari and Smita Pawar , Thank you for sending over the February and March files. Below are responses to the comments you made on the select employees above. CHMC employee Vicki Mathis was on a LOA and returned to work on 1/3/2017, and re-elected benefits HMC employee Consuelo Garcia is listed with two separate ssns - awaiting confirmation of which is correct from the facility. PMC employee Joanne R Genn - employee is listed under PMC (Pampa Regional Medical Center) and Prime_Healthcare zDelete Pampa Regional Medical Center. Employee information should be pulled from PMC site only. Facility transferred from Prime_Healthcare to it's own site, PMC. Thank you, Amber
            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

            Hide
            Prashant.samal Prashant Samal (Inactive) added a comment -

            Hi Amber Love-Jones,

            We have uploaded Prime Files for April and May 2017 on FTP.

            URL: https://ftpsecure.ebsbenefits.com
            Path:/users/workterraaca/Prime/Prime_facility_06122017

            File name : Prime Files April May.zip

            Note: Zip folder contains Employee & Dependent files.
            Sending password in email

            Thanks,
            S Prashant
            -----------------------------------------------------------------------------
            CC- Nandkumar Prabhakar Karlekar,Rakesh Roy,Sachin Hingole,Revansiddha Gaur,Amit Thorve Yogesh Chaudhari

            Show
            Prashant.samal Prashant Samal (Inactive) added a comment - Hi Amber Love-Jones , We have uploaded Prime Files for April and May 2017 on FTP. URL: https://ftpsecure.ebsbenefits.com Path:/users/workterraaca/Prime/Prime_facility_06122017 File name : Prime Files April May.zip Note: Zip folder contains Employee & Dependent files. Sending password in email Thanks, S Prashant ----------------------------------------------------------------------------- CC- Nandkumar Prabhakar Karlekar , Rakesh Roy , Sachin Hingole , Revansiddha Gaur , Amit Thorve Yogesh Chaudhari
            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

            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 293.5h [ 1056600 ] 300.5h [ 1081800 ]
            Worklog Id 54293 [ 54293 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 300.5h [ 1081800 ] 307.5h [ 1107000 ]
            Worklog Id 54294 [ 54294 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 307.5h [ 1107000 ] 314.5h [ 1132200 ]
            Worklog Id 54295 [ 54295 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 314.5h [ 1132200 ] 321h [ 1155600 ]
            Worklog Id 54307 [ 54307 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 321h [ 1155600 ] 328h [ 1180800 ]
            Worklog Id 54308 [ 54308 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 328h [ 1180800 ] 334h [ 1202400 ]
            Worklog Id 54310 [ 54310 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 334h [ 1202400 ] 341h [ 1227600 ]
            Worklog Id 54319 [ 54319 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 341h [ 1227600 ] 347h [ 1249200 ]
            Worklog Id 54321 [ 54321 ]
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - - edited

            Amber Love-Jones

            'VICKI M MATHIS' enrollment date is 01/03/2017 , means he do not have offer for the complete January month. Hence this employee not reflected on Jan month's full file and reflected on Feb month's change file. This is behavior of our system.

            Please see the attached screen shot from IRS site ( https://www.irs.gov/instructions/i109495c/ar01.html#d0e1116 ) which describes all days of a month offer is required.

            Please let us know your thought on same asap.

            Once you get confirmation about 'CONSUELO GARCIA' employee, please terminate him from respective old company and also terminate with same date in file as well.

            Nandkumar Prabhakar KarlekarSmita PawarPrashant SamalSachin Hingole

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - - edited Amber Love-Jones 'VICKI M MATHIS' enrollment date is 01/03/2017 , means he do not have offer for the complete January month. Hence this employee not reflected on Jan month's full file and reflected on Feb month's change file. This is behavior of our system. Please see the attached screen shot from IRS site ( https://www.irs.gov/instructions/i109495c/ar01.html#d0e1116 ) which describes all days of a month offer is required. Please let us know your thought on same asap. Once you get confirmation about 'CONSUELO GARCIA' employee, please terminate him from respective old company and also terminate with same date in file as well. Nandkumar Prabhakar Karlekar Smita Pawar Prashant Samal Sachin Hingole
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Worklog Id 54321 [ 54321 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Time Spent 347h [ 1249200 ] 355h [ 1278000 ]
            Worklog Id 54359 [ 54359 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 355h [ 1278000 ] 362h [ 1303200 ]
            Worklog Id 54408 [ 54408 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 362h [ 1303200 ] 369h [ 1328400 ]
            Worklog Id 54409 [ 54409 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Amit ThorveJennifer JohnsonAmber Love-JonesYamilka CocaNandkumar Prabhakar KarlekarRevansiddha GaurSmita Pawar

            Hi All,
            Please find the attached Prime_Duplicate_Active_Employee_List.zip file contains duplicate employees list whose status is Active in 2 or more companies of Prime. There are distinct 173 duplicate active employees present in multiple companies.

            Password sent in mail.

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Amit Thorve Jennifer Johnson Amber Love-Jones Yamilka Coca Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar Hi All, Please find the attached Prime_Duplicate_Active_Employee_List.zip file contains duplicate employees list whose status is Active in 2 or more companies of Prime. There are distinct 173 duplicate active employees present in multiple companies. Password sent in mail.
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Attachment IRS_EveryDayCoverage.jpg [ 51853 ]
            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

            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Yogesh Chaudhari,

            1. Vicki M Mathis returned from a Leave of Absence effective 1/3/2017, and according to plan rules, employees can re-enroll in benefits effective the same date that they return. I do not see any other place in the system where the coverage has to be reinstated the first of the month for a return from LOA.

            2. Employee Consuelo Garcia had the duplicate enrollment employment terminated.

            3. Currently reviewing duplicate employee list, and expect to have it completed this week.

            4. Prime Healthcare reviewing January 2017 full file and found the following employees listed with zDelete before the facility name:

            EEID 107647 - Johnny Guajardo: lists as zDelete Knapp in Prime Healthcare: Employee is currently Active under HMC
            EEID 107491 - Dusterhus, Luke: lists as zDelete Harlingen in Prime Healthcare: Employee was Active (now termed 1/31/17) under HMC
            EEID 107161 - Sheerin, Aisha: lists as zDelete Harlingen: Employee was Active (now termed 3/1/17) under HMC
            EEID 106411 - Vasquez, Georgina: lists as zDelete Harlingen: Employee was Active (now termed 1/31/17) under HMC
            EEID 107889 - Magallan, Cruz: Active under HMC
            EEID 106136 - Vega, Kady: lists as zDelete Harlingen: Employee was Active (now termed 1/31/17) under HMC
            EEID 100174 - Ortega, Jose: lists as zDelete Harlingen: Employee is currently Active under HMC

            These employees were moved from Prime Healthcare to HMC. Should those with zDelete be appearing on the January 2017 full file? Please advise.

            Thank you!

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Yogesh Chaudhari , 1. Vicki M Mathis returned from a Leave of Absence effective 1/3/2017, and according to plan rules, employees can re-enroll in benefits effective the same date that they return. I do not see any other place in the system where the coverage has to be reinstated the first of the month for a return from LOA. 2. Employee Consuelo Garcia had the duplicate enrollment employment terminated. 3. Currently reviewing duplicate employee list, and expect to have it completed this week. 4. Prime Healthcare reviewing January 2017 full file and found the following employees listed with zDelete before the facility name: EEID 107647 - Johnny Guajardo: lists as zDelete Knapp in Prime Healthcare: Employee is currently Active under HMC EEID 107491 - Dusterhus, Luke: lists as zDelete Harlingen in Prime Healthcare: Employee was Active (now termed 1/31/17) under HMC EEID 107161 - Sheerin, Aisha: lists as zDelete Harlingen: Employee was Active (now termed 3/1/17) under HMC EEID 106411 - Vasquez, Georgina: lists as zDelete Harlingen: Employee was Active (now termed 1/31/17) under HMC EEID 107889 - Magallan, Cruz: Active under HMC EEID 106136 - Vega, Kady: lists as zDelete Harlingen: Employee was Active (now termed 1/31/17) under HMC EEID 100174 - Ortega, Jose: lists as zDelete Harlingen: Employee is currently Active under HMC These employees were moved from Prime Healthcare to HMC. Should those with zDelete be appearing on the January 2017 full file? Please advise. Thank you! Amber
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 15/Jun/17 12:53 AM
            • Time Spent:
              6h
               
              <No comment>
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Amber Love-Jones

            1. Do you want this Vicki M Mathis employee on January month file? Please confirm and let me know.

            2. Please find the below details analysis for above mentioned employee. These employees is not belongs to Zdelete class. these are populating as per data in respective company.

            EEID 107647 - Johnny Guajardo : Employee is currently Active under KMC (Knap Medical Centre), it has an EIN of Harlingen Medical Centre at the employee level in KMC.
            This is data issue. Please check and confirm.

            EEID 107491 - Dusterhus, Luke : Employee was terminated on 1/31/2017 in HMC, As it has coverage for whole month in HMC, it is populating on January Month File.

            EEID 107161 - Sheerin, Aisha : Employee was active January month in HMC and terminated on 03/01/2017, Hence it is populating on January month file from HMC.

            EEID 106411 - Vasquez, Georgina : Employee was terminated on 1/31/2017 in HMC, As it has coverage for whole January month in HMC, so it is populating on January Month File.

            EEID 107889 - Magallan, Cruz: Employee is active in HMC from 11/30/2016, hence it is populating on January month file from HMC company

            EEID 106136 - Vega, Kady: Employee was terminated on 1/31/2017 in HMC, As it has coverage for whole January month in HMC, so it is populating on January Month File.

            EEID 100174 - Ortega, Jose: Employee is active in HMC from 12/21/1999, hence it is populating on January month file from HMC company

            Please let us know your inputs asap

            Nandkumar Prabhakar KarlekarSmita PawarRevansiddha Gaur

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Amber Love-Jones 1. Do you want this Vicki M Mathis employee on January month file? Please confirm and let me know. 2. Please find the below details analysis for above mentioned employee. These employees is not belongs to Zdelete class. these are populating as per data in respective company. EEID 107647 - Johnny Guajardo : Employee is currently Active under KMC (Knap Medical Centre), it has an EIN of Harlingen Medical Centre at the employee level in KMC. This is data issue. Please check and confirm. EEID 107491 - Dusterhus, Luke : Employee was terminated on 1/31/2017 in HMC, As it has coverage for whole month in HMC, it is populating on January Month File. EEID 107161 - Sheerin, Aisha : Employee was active January month in HMC and terminated on 03/01/2017, Hence it is populating on January month file from HMC. EEID 106411 - Vasquez, Georgina : Employee was terminated on 1/31/2017 in HMC, As it has coverage for whole January month in HMC, so it is populating on January Month File. EEID 107889 - Magallan, Cruz: Employee is active in HMC from 11/30/2016, hence it is populating on January month file from HMC company EEID 106136 - Vega, Kady: Employee was terminated on 1/31/2017 in HMC, As it has coverage for whole January month in HMC, so it is populating on January Month File. EEID 100174 - Ortega, Jose: Employee is active in HMC from 12/21/1999, hence it is populating on January month file from HMC company Please let us know your inputs asap Nandkumar Prabhakar Karlekar Smita Pawar Revansiddha Gaur
            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

            alov Amber Love-Jones (Inactive) made changes -
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Nandkumar Prabhakar Karlekar, Smita Pawar, Revansiddha Gaur,

            1. Please include Vicki Mathis on the January file.
            2. I still find these employees listed as Active or recently Active on the below facilities. What data issue could there be? The zDelete facility showing up on the ACA reporting is not correct:

            EEID 107647 - Johnny Guajardo: lists as zDelete Knapp in Prime Healthcare: Employee is currently Active under HMC
            EEID 107491 - Dusterhus, Luke: lists as zDelete Harlingen in Prime Healthcare: Employee was Active (now termed 1/31/17) under HMC
            EEID 107161 - Sheerin, Aisha: lists as zDelete Harlingen: Employee was Active (now termed 3/1/17) under HMC
            EEID 106411 - Vasquez, Georgina: lists as zDelete Harlingen: Employee was Active (now termed 1/31/17) under HMC
            EEID 107889 - Magallan, Cruz: Active under HMC
            EEID 106136 - Vega, Kady: lists as zDelete Harlingen: Employee was Active (now termed 1/31/17) under HMC
            EEID 100174 - Ortega, Jose: lists as zDelete Harlingen: Employee is currently Active under HMC

            3. Prime advised today, 6/15/17, that the employees on the attachment, titled "ACA 8076 Missing from January File" are active on the payroll system and are in WorkTerra, but are not on the January file. Please advise.

            Thank you,

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Nandkumar Prabhakar Karlekar , Smita Pawar , Revansiddha Gaur , 1. Please include Vicki Mathis on the January file. 2. I still find these employees listed as Active or recently Active on the below facilities. What data issue could there be? The zDelete facility showing up on the ACA reporting is not correct: EEID 107647 - Johnny Guajardo: lists as zDelete Knapp in Prime Healthcare: Employee is currently Active under HMC EEID 107491 - Dusterhus, Luke: lists as zDelete Harlingen in Prime Healthcare: Employee was Active (now termed 1/31/17) under HMC EEID 107161 - Sheerin, Aisha: lists as zDelete Harlingen: Employee was Active (now termed 3/1/17) under HMC EEID 106411 - Vasquez, Georgina: lists as zDelete Harlingen: Employee was Active (now termed 1/31/17) under HMC EEID 107889 - Magallan, Cruz: Active under HMC EEID 106136 - Vega, Kady: lists as zDelete Harlingen: Employee was Active (now termed 1/31/17) under HMC EEID 100174 - Ortega, Jose: lists as zDelete Harlingen: Employee is currently Active under HMC 3. Prime advised today, 6/15/17, that the employees on the attachment, titled "ACA 8076 Missing from January File" are active on the payroll system and are in WorkTerra, but are not on the January file. Please advise. Thank you, Amber
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hello Amber Love-Jones,Jennifer Johnson,Yamilka Coca,Amit Thorve,Nandkumar Prabhakar Karlekar,Revansiddha Gaur,Smita Pawar

            1. We can include Vicki Mathis in January month file, there are many employee those do not have offer for whole month i.e. everyday. We will have to populate those employee as well in January month file though they have offer for single day in month.

            2. Can we discuss about these 7 employee in call?

            3. Please find the attached file ACA 8076_Missing_January File_HB_Updated.xls contains detail analysis of employees those were reported as missing in January month with its reason.

            Can you please schedule call on your suitable time?

            Thanks,

            Yogesh

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hello Amber Love-Jones , Jennifer Johnson , Yamilka Coca , Amit Thorve , Nandkumar Prabhakar Karlekar , Revansiddha Gaur , Smita Pawar 1. We can include Vicki Mathis in January month file, there are many employee those do not have offer for whole month i.e. everyday. We will have to populate those employee as well in January month file though they have offer for single day in month. 2. Can we discuss about these 7 employee in call? 3. Please find the attached file ACA 8076_Missing_January File_HB_Updated.xls contains detail analysis of employees those were reported as missing in January month with its reason. Can you please schedule call on your suitable time? Thanks, Yogesh
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 16/Jun/17 02:01 PM
            • Time Spent:
              7h
               

              Analysis of Prime 20 employees provided

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Amber Love-Jones Do you any updates on above query and call? Thanks, Jennifer Johnson Yamilka Coca Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Time Spent 369h [ 1328400 ] 375h [ 1350000 ]
            Worklog Id 57049 [ 57049 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Time Spent 375h [ 1350000 ] 381h [ 1371600 ]
            Worklog Id 57050 [ 57050 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 381h [ 1371600 ] 388h [ 1396800 ]
            Worklog Id 57264 [ 57264 ]
            alov Amber Love-Jones (Inactive) made changes -
            Hide
            alov Amber Love-Jones (Inactive) added a comment - - edited

            Hello Yogesh Chaudhari,

            Jennifer Johnson and I can be available for a call 6/22 or 6/23 at 9:00 a.m. PST. Please let us know if this will work for you; if so, please send a call in number.

            In the interim, Prime Healthcare came back with another small list of employees who should have been on the January report, but are not. The names are attached under ACA 8076_EEs missing from January file. Please review and advise.

            You provided the report titled Prime_Duplicate_Active_Employee_List dated 6/13/2017. Can you please add hire dates and effective dates for each entry?

            Thank you,

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - - edited Hello Yogesh Chaudhari , Jennifer Johnson and I can be available for a call 6/22 or 6/23 at 9:00 a.m. PST. Please let us know if this will work for you; if so, please send a call in number. In the interim, Prime Healthcare came back with another small list of employees who should have been on the January report, but are not. The names are attached under ACA 8076_EEs missing from January file. Please review and advise. You provided the report titled Prime_Duplicate_Active_Employee_List dated 6/13/2017. Can you please add hire dates and effective dates for each entry? Thank you, Amber
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 21/Jun/17 11:20 PM
            • Time Spent:
              2h
               
              <No comment>
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - - edited

            Amber Love-JonesJennifer Johnson

            I have scheduled meeting today 6/22 at 9 a.m. PST. It is fine for us.
            Please see the meeting details.

            Thursday, June 22, 2017 | 9:30 pm India Time (GMT+05:30) (9 a.m. PST)
            Meeting number: 578 462 200
            Meeting link:https://harbingergroup.webex.com/harbingergroup/j.php?MTID=m53448787c9b15c07b589b267136a52a7

            Audio connection:
            1-8773614628 (US) Call-in toll-free number
            +91-180030106096 (India) Call-in number
            Leader Pin: 5857
            Conference Code: 128 328 7607

            Please find the attached file UPDATED_Prime_Duplicate_Active_Employee_List.zip contains list of duplicate employees along with Hire and Effective Date. Password sent in mail.

            Thanks,
            Yogesh Chaudhari

            Nandkumar Prabhakar KarlekarRevansiddha GaurSmita Pawar

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - - edited Amber Love-Jones Jennifer Johnson I have scheduled meeting today 6/22 at 9 a.m. PST. It is fine for us. Please see the meeting details. Thursday, June 22, 2017 | 9:30 pm India Time (GMT+05:30) (9 a.m. PST) Meeting number: 578 462 200 Meeting link: https://harbingergroup.webex.com/harbingergroup/j.php?MTID=m53448787c9b15c07b589b267136a52a7 Audio connection: 1-8773614628 (US) Call-in toll-free number +91-180030106096 (India) Call-in number Leader Pin: 5857 Conference Code: 128 328 7607 Please find the attached file UPDATED_Prime_Duplicate_Active_Employee_List.zip contains list of duplicate employees along with Hire and Effective Date. Password sent in mail. Thanks, Yogesh Chaudhari Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Amber Love-Jones Jennifer Johnson

            I have analysed missing employee provided in ACA 8076_EEs missing file.

            File contains almost 8 employees and out of these 6 employees is already exists in Jan-2017 file.

            Please find the attached updated HB_UPDATED_ACA 8076_EEs missing from January FIle.doc file with comment from Harbinger team.

            Thanks,
            Yogesh
            Nandkumar Prabhakar KarlekarRevansiddha GaurSmita Pawar

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Amber Love-Jones Jennifer Johnson I have analysed missing employee provided in ACA 8076_EEs missing file. File contains almost 8 employees and out of these 6 employees is already exists in Jan-2017 file. Please find the attached updated HB_UPDATED_ACA 8076_EEs missing from January FIle.doc file with comment from Harbinger team. Thanks, Yogesh Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar
            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

            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 388h [ 1396800 ] 396h [ 1425600 ]
            Worklog Id 57659 [ 57659 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 396h [ 1425600 ] 400h [ 1440000 ]
            Worklog Id 57668 [ 57668 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 400h [ 1440000 ] 408h [ 1468800 ]
            Worklog Id 57670 [ 57670 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 408h [ 1468800 ] 416h [ 1497600 ]
            Worklog Id 57676 [ 57676 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 22/Jun/17 11:06 PM
            • Time Spent:
              2h
               
              <No comment>
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hello Jennifer JohnsonAmber Love-JonesNandkumar Prabhakar Karlekar

            MOM of ACA Prime Call on 6/22

            1. Include Vicki Mathis in January month file and also if employee has offer for single day in Month should we include in file or Not?
            [EBS] : Jennifer and Amber is going to confirm with the client for the expected result.

            2. List of employees missing in Jan 2017 file and list of employees those should not populate in Jan month file reported by client.
            [EBS] : Jennifer and Amber will check the detail analysis provided by Yogesh for all the reported employees. They will share the feedback with harbinger team.

            3. List of Duplicate Active employees across all the facilities of Prime.
            [Harbinger] : Yogesh has shared list of duplicate employees those are active in two or more companies of Prime along with their Hire and Effective Date
            [EBS] : EBS is going to share duplicate active employee list with client, will take appropriate action for those.

            Thanks,
            Yogesh Chaudhari

            Revansiddha GaurSmita Pawar

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hello Jennifer Johnson Amber Love-Jones Nandkumar Prabhakar Karlekar MOM of ACA Prime Call on 6/22 1. Include Vicki Mathis in January month file and also if employee has offer for single day in Month should we include in file or Not? [EBS] : Jennifer and Amber is going to confirm with the client for the expected result. 2. List of employees missing in Jan 2017 file and list of employees those should not populate in Jan month file reported by client. [EBS] : Jennifer and Amber will check the detail analysis provided by Yogesh for all the reported employees. They will share the feedback with harbinger team. 3. List of Duplicate Active employees across all the facilities of Prime. [Harbinger] : Yogesh has shared list of duplicate employees those are active in two or more companies of Prime along with their Hire and Effective Date [EBS] : EBS is going to share duplicate active employee list with client, will take appropriate action for those. Thanks, Yogesh Chaudhari Revansiddha Gaur Smita Pawar
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 416h [ 1497600 ] 424h [ 1526400 ]
            Worklog Id 58033 [ 58033 ]
            alov Amber Love-Jones (Inactive) made changes -
            Attachment RE KMC ACA REPORTING FOR 2017.msg [ 53371 ]
            alov Amber Love-Jones (Inactive) made changes -
            Attachment Terminated employees.msg [ 53372 ]
            alov Amber Love-Jones (Inactive) made changes -
            Attachment Clean Up 6-2017.xlsx [ 53374 ]
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Yogesh Chaudhari, Rakesh Roy, Revansiddha Gaur,

            1. I have reviewed the report you attached titled UPDATED_Prime_Duplicate_Active_Employee_List.zip. There are several facilities that are listed that do not require ACA reporting for 2017 because they are no longer Active in WorkTerra:

            • Garden City (Part of Primehealthcare No-space)
            • GGH (Garden Grove)
            • Huntington Beach (part of Prime_Healthcare)
            • Roxborough (part of Prime_Healthcare)
            • Southern Regional
            • Suburban (Part of Primehealthcare No-space)
            • United Home Health (Part of Primehealthcare No-space)
            • West Anaheim (Part of Prime_Healthcare)

            I have sent the duplicates for the other Active facilities to Prime Healthcare for review.

            2. Please see the attached file titled KMC ACA REPORTING FOR 2017: The listing shows the plans employees were enrolled in medical plans before their termination prior to 1/31/17, but didn't show up on the January 2017 ACA report. Please review and provide updates.

            3. Attached file titled+Terminated employees+: There is a list of employees on this attachment that are on the January 2017 ACA report for HMC but are terminated in WT. Please review and provide updates.

            4. Please see attached file titled Clean Up 6-2017 (002): The client has 3 separate lists asking for information. Please review and provide updates.

            Thank you.

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Yogesh Chaudhari , Rakesh Roy , Revansiddha Gaur , 1. I have reviewed the report you attached titled UPDATED_Prime_Duplicate_Active_Employee_List.zip . There are several facilities that are listed that do not require ACA reporting for 2017 because they are no longer Active in WorkTerra: Garden City (Part of Primehealthcare No-space) GGH (Garden Grove) Huntington Beach (part of Prime_Healthcare) Roxborough (part of Prime_Healthcare) Southern Regional Suburban (Part of Primehealthcare No-space) United Home Health (Part of Primehealthcare No-space) West Anaheim (Part of Prime_Healthcare) I have sent the duplicates for the other Active facilities to Prime Healthcare for review. 2. Please see the attached file titled KMC ACA REPORTING FOR 2017 : The listing shows the plans employees were enrolled in medical plans before their termination prior to 1/31/17, but didn't show up on the January 2017 ACA report. Please review and provide updates. 3. Attached file titled+Terminated employees+: There is a list of employees on this attachment that are on the January 2017 ACA report for HMC but are terminated in WT. Please review and provide updates. 4. Please see attached file titled Clean Up 6-2017 (002) : The client has 3 separate lists asking for information. Please review and provide updates. Thank you.
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment - - edited

            Hi Amber Love-Jones,

            We have started working on same.
            Could you please eloborate point no.04 more so that it will be helpful for us.
            We will share our analysis for points 2 and 3.

            Thanks,
            Smita

            FYI Nandkumar Prabhakar Karlekar, Sachin Hingole,Yogesh Chaudhari,Prashant Samal,Revansiddha Gaur

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - - edited Hi Amber Love-Jones , We have started working on same. Could you please eloborate point no.04 more so that it will be helpful for us. We will share our analysis for points 2 and 3. Thanks, Smita FYI Nandkumar Prabhakar Karlekar , Sachin Hingole , Yogesh Chaudhari , Prashant Samal , Revansiddha Gaur
            smita.pawar Smita Pawar (Inactive) logged work - 27/Jun/17 12:58 PM
            • Time Spent:
              6h
               

              Analysis

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 424h [ 1526400 ] 430h [ 1548000 ]
            Worklog Id 58300 [ 58300 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 430h [ 1548000 ] 433h [ 1558800 ]
            Worklog Id 58417 [ 58417 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 433h [ 1558800 ] 441h [ 1587600 ]
            Worklog Id 58424 [ 58424 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 441h [ 1587600 ] 444h [ 1598400 ]
            Worklog Id 58429 [ 58429 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 444h [ 1598400 ] 448h [ 1612800 ]
            Worklog Id 58430 [ 58430 ]
            smita.pawar Smita Pawar (Inactive) logged work - 28/Jun/17 08:42 AM
            • Time Spent:
              3h
               

              Task discussion
              Meeting
              KT
              Client reply
              Review

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Time Spent 448h [ 1612800 ] 450h [ 1620000 ]
            Worklog Id 58699 [ 58699 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Time Spent 450h [ 1620000 ] 452h [ 1627200 ]
            Worklog Id 58700 [ 58700 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Time Spent 452h [ 1627200 ] 454h [ 1634400 ]
            Worklog Id 58721 [ 58721 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment Prime analysis KMC HMC .xls [ 53662 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment Prime analysis KMC HMC.zip [ 53663 ]
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Amber Love-Jones,

            Please find our analysis in attached file Prime analysis KMC HMC.zip.
            Sending password in separate mail.
            Let us know, if you need any additional information.

            Thanks,

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

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Amber Love-Jones , Please find our analysis in attached file Prime analysis KMC HMC.zip . Sending password in separate mail. Let us know, if you need any additional information. Thanks, FYI Nandkumar Prabhakar Karlekar , Sachin Hingole , Rakesh Roy , Yogesh Chaudhari , Revansiddha Gaur
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment Prime analysis KMC HMC.zip [ 53663 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment Prime analysis KMC HMC .xls [ 53662 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment Prime analysis KMC HMC.zip [ 53664 ]
            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>
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 454h [ 1634400 ] 460h [ 1656000 ]
            Worklog Id 59001 [ 59001 ]
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Yogesh Chaudhari,

            For item #4 above, please disregard.

            MOM of ACA Prime Call on 6/22 - please see my comments below.
            1. Include Vicki Mathis in January month file and also if employee has offer for single day in Month should we include in file or Not? - Client confirmed that any employees formerly on LOA that return to work are to be included in the monthly report in the month that they re-enrolled in benefits, regardless of the effective date.

            Additionally, CHMC employee April Joshua, EEID372915 – Returned from LOA and enrolled Family in EPO3 Plan eff 1/9/2017. Please include this employee on the January report.

            2. List of employees missing in Jan 2017 file and list of employees those should not populate in Jan month file reported by client.
            [EBS] : Jennifer and Amber will check the detail analysis provided by Yogesh for all the reported employees. They will share the feedback with harbinger team. - please provide report and password once again.

            3. List of Duplicate Active employees across all the facilities of Prime.
            [Harbinger] : Yogesh has shared list of duplicate employees those are active in two or more companies of Prime along with their Hire and Effective Date
            [EBS] : EBS is going to share duplicate active employee list with client, will take appropriate action for those. List has been provided to Prime to disseminate amongst the facilities. Still awaiting feedback from Prime.

            Attached, please find a new listing of employees that Prime has provided. It appears that existing Active employees in Workterra did not appear on the January 2017 report. Explanations of what is requested are listed above each grouping of employees. The password will be emailed to you separately.

            Thank you,

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Yogesh Chaudhari , For item #4 above, please disregard. MOM of ACA Prime Call on 6/22 - please see my comments below. 1. Include Vicki Mathis in January month file and also if employee has offer for single day in Month should we include in file or Not? - Client confirmed that any employees formerly on LOA that return to work are to be included in the monthly report in the month that they re-enrolled in benefits, regardless of the effective date. Additionally, CHMC employee April Joshua, EEID372915 – Returned from LOA and enrolled Family in EPO3 Plan eff 1/9/2017. Please include this employee on the January report. 2. List of employees missing in Jan 2017 file and list of employees those should not populate in Jan month file reported by client. [EBS] : Jennifer and Amber will check the detail analysis provided by Yogesh for all the reported employees. They will share the feedback with harbinger team. - please provide report and password once again. 3. List of Duplicate Active employees across all the facilities of Prime. [Harbinger] : Yogesh has shared list of duplicate employees those are active in two or more companies of Prime along with their Hire and Effective Date [EBS] : EBS is going to share duplicate active employee list with client, will take appropriate action for those. List has been provided to Prime to disseminate amongst the facilities. Still awaiting feedback from Prime. Attached, please find a new listing of employees that Prime has provided. It appears that existing Active employees in Workterra did not appear on the January 2017 report. Explanations of what is requested are listed above each grouping of employees. The password will be emailed to you separately. Thank you, Amber
            alov Amber Love-Jones (Inactive) made changes -
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 460h [ 1656000 ] 463h [ 1666800 ]
            Worklog Id 59157 [ 59157 ]
            alov Amber Love-Jones (Inactive) made changes -
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Smita Pawar,

            Please disregard the email attached dated 6/28/17 titled Dev_D.Fleury emails 6.21.217 with password.xlsx. I have audited all employees on the form and have created a new spreadsheet showing only the items that we need Dev to research. This report is titled Dev_UPDATED Report from Prime 6.30. The password will be sent via email.

            Additionally, Jennifer Leugers looked at the EEID numbers below:

            742958
            492973
            890883
            997700

            Each of the above records showed that EEs had a QE between January-May. For example EE originally enrolled in 1/1/2017, QE on 2/1/2017, report may be pulling the earliest effective date instead of the true effective date of the original enrollment. So the EE shows 2/1 and gets pulled onto 2/1 and not on the 1/1 report. Can you please see if perhaps this is the reason that so many employees are missing from the January 2017 reporting? Thank you.

            Amber Love-Jones
            Jennifer Johnson

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Smita Pawar , Please disregard the email attached dated 6/28/17 titled Dev_D.Fleury emails 6.21.217 with password.xlsx. I have audited all employees on the form and have created a new spreadsheet showing only the items that we need Dev to research. This report is titled Dev_UPDATED Report from Prime 6.30. The password will be sent via email. Additionally, Jennifer Leugers looked at the EEID numbers below: 742958 492973 890883 997700 Each of the above records showed that EEs had a QE between January-May. For example EE originally enrolled in 1/1/2017, QE on 2/1/2017, report may be pulling the earliest effective date instead of the true effective date of the original enrollment. So the EE shows 2/1 and gets pulled onto 2/1 and not on the 1/1 report. Can you please see if perhaps this is the reason that so many employees are missing from the January 2017 reporting? Thank you. Amber Love-Jones Jennifer Johnson
            smita.pawar Smita Pawar (Inactive) logged work - 03/Jul/17 12:14 PM
            • Time Spent:
              5h
               

              File testing

            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hello Amber Love-Jones

            1. To Include employees those formerly on LOA and return to work in the month that they re-enrolled in benefits, regardless of the effective date.
            [EBS] : You will have to select LOA status on all ACA plans from plan design screen for all the facilities of Prime. So when we will furnish file again such employees will get included in file.

            2. We are doing analysis of consolidated file Dev_UPDATED Report from Prime 6.30. provided by you. We will provide the detail analysis report of all these employees on Wednesday EOD.

            Jennifer Johnson Nandkumar Prabhakar KarlekarSmita Pawar

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hello Amber Love-Jones 1. To Include employees those formerly on LOA and return to work in the month that they re-enrolled in benefits, regardless of the effective date. [EBS] : You will have to select LOA status on all ACA plans from plan design screen for all the facilities of Prime. So when we will furnish file again such employees will get included in file. 2. We are doing analysis of consolidated file Dev_UPDATED Report from Prime 6.30. provided by you. We will provide the detail analysis report of all these employees on Wednesday EOD. Jennifer Johnson Nandkumar Prabhakar Karlekar Smita Pawar
            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.

            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Yogesh Chaudhari,

            I do not have the option to select LOA on all ACA plans from the plan design screen. We do not have ACA plans listed.

            We do not need to include employees on LOA on the reports; only*strong text* those employees who elect benefits on days other than the first of the month - those are indicators of people who were on LOA and have returned to work.

            I will look for the analysis reporting from you by EOD Wednesday, 7/5.

            Thank you.

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Yogesh Chaudhari , I do not have the option to select LOA on all ACA plans from the plan design screen. We do not have ACA plans listed. We do not need to include employees on LOA on the reports; only*strong text * those employees who elect benefits on days other than the first of the month - those are indicators of people who were on LOA and have returned to work. I will look for the analysis reporting from you by EOD Wednesday, 7/5. Thank you.
            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

            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Attachment Coshocton_ACA_Customization.jpg [ 54208 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hello Amber Love-Jones Jennifer Johnson

            I. To populate LOA employee on file we have only below 2 options.

            • We will have to select LOA status on all the ACA plans for all prime facilities. In that case all the employee those are LOA will also be populate on file.
            • Any employee who is on LOA and again renerolled in the system, he has to select his benefits from 1st of the month.
              If you are not agree with the above 2 options then will have to make the changes in code to handle above situations and for that we need Dave approval.

            II We have done analysis of file Dev_UPDATED Report from Prime 6.30. except employee of Providence Medical Center employees. Please find the attached Analysis_Dev_UPDATED_Prime 6.30.zip file contains detail analysis of all the employees.

            • Analysis of CHMC Employees sheet contains detail analysis of CHMC 52 employees why these were not populated on Jan-2017 file.
              Out of these 52, 14 employees were terminated before 01/01/2017 and 18 employees are in assessment period so we are not providing benefit to those 18 employee and detail analysis of remaining 20 employees.
            • Analysis of HMC Employees sheet contain analysis 7 employees analysis why they are populated on Jan month file.
            • There are basically 2 reasons why employees from Coshocton were not populated in Jan-2017 file.
              1. ACA plans in company is not marked as minimum essential coverage and self insured in the ACA customization screen. I have marked all medical plans as minimum essential and self insured plans in the system. Please see the attached screenshot.
              Please confirm the same.
              2.Other reason, There are almost 12 Class1 in Coshocton company,out of these only one Class1 Coshocton is mapped with genericeligibilityrule (i.e. EIN). From the list of employee you provided, almost 61 employees is belongs to other class1 (not with Coshocton).
              Coshocton Employee_Class1_Info sheet of attached file contains list of employee whose classes are other than Coshocton, so they are not populating on jan-2017 file. You will have to mapped other Class1 with genericeligibilityrule to populate these missing employees as well.

            We are doing analysis of Providence Medical Center employees. Password sent in mail.

            Note : It will be more helpful for us if you provide employee SSN while sending for employee for detail analysis.

            Nandkumar Prabhakar KarlekarSmita PawarRevansiddha Gaur

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hello Amber Love-Jones Jennifer Johnson I. To populate LOA employee on file we have only below 2 options. We will have to select LOA status on all the ACA plans for all prime facilities. In that case all the employee those are LOA will also be populate on file. Any employee who is on LOA and again renerolled in the system, he has to select his benefits from 1st of the month. If you are not agree with the above 2 options then will have to make the changes in code to handle above situations and for that we need Dave approval. II We have done analysis of file Dev_UPDATED Report from Prime 6.30. except employee of Providence Medical Center employees. Please find the attached Analysis_Dev_UPDATED_Prime 6.30.zip file contains detail analysis of all the employees. Analysis of CHMC Employees sheet contains detail analysis of CHMC 52 employees why these were not populated on Jan-2017 file. Out of these 52, 14 employees were terminated before 01/01/2017 and 18 employees are in assessment period so we are not providing benefit to those 18 employee and detail analysis of remaining 20 employees. Analysis of HMC Employees sheet contain analysis 7 employees analysis why they are populated on Jan month file. There are basically 2 reasons why employees from Coshocton were not populated in Jan-2017 file. 1. ACA plans in company is not marked as minimum essential coverage and self insured in the ACA customization screen. I have marked all medical plans as minimum essential and self insured plans in the system. Please see the attached screenshot. Please confirm the same . 2.Other reason, There are almost 12 Class1 in Coshocton company,out of these only one Class1 Coshocton is mapped with genericeligibilityrule (i.e. EIN). From the list of employee you provided, almost 61 employees is belongs to other class1 (not with Coshocton). Coshocton Employee_Class1_Info sheet of attached file contains list of employee whose classes are other than Coshocton, so they are not populating on jan-2017 file. You will have to mapped other Class1 with genericeligibilityrule to populate these missing employees as well. We are doing analysis of Providence Medical Center employees. Password sent in mail. Note : It will be more helpful for us if you provide employee SSN while sending for employee for detail analysis. Nandkumar Prabhakar Karlekar Smita Pawar Revansiddha Gaur
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Yogesh Chaudhari,

            Thank you for sending this list over.

            I. The employees need to be added to the file for the month that they return and enroll in benefits. If this falls on a date other than the first of the month, the employee still needs to be added. Please check with Dave. This is what Prime Healthcare has instructed us to do.

            II. I am checking with Prime Healthcare regarding Coshocton employees. There is only one class with several different facilities listed. I have asked Prime if there is an EIN attached to each facility. I will report back as soon as I have more information.

            Thank you!

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Yogesh Chaudhari , Thank you for sending this list over. I . The employees need to be added to the file for the month that they return and enroll in benefits. If this falls on a date other than the first of the month, the employee still needs to be added. Please check with Dave. This is what Prime Healthcare has instructed us to do. II . I am checking with Prime Healthcare regarding Coshocton employees. There is only one class with several different facilities listed. I have asked Prime if there is an EIN attached to each facility. I will report back as soon as I have more information. Thank you! Amber
            smita.pawar Smita Pawar (Inactive) logged work - 06/Jul/17 04:40 AM
            • Time Spent:
              1.5h
               

              Employee analysis and reply

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 463h [ 1666800 ] 464.5h [ 1672200 ]
            Worklog Id 60992 [ 60992 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 464.5h [ 1672200 ] 468.5h [ 1686600 ]
            Worklog Id 60993 [ 60993 ]
            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

            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 468.5h [ 1686600 ] 476.5h [ 1715400 ]
            Worklog Id 61025 [ 61025 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 476.5h [ 1715400 ] 484.5h [ 1744200 ]
            Worklog Id 61026 [ 61026 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 484.5h [ 1744200 ] 492.5h [ 1773000 ]
            Worklog Id 61027 [ 61027 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Worklog Id 61027 [ 61027 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 1h [ 3600 ]
            Time Spent 492.5h [ 1773000 ] 491.5h [ 1769400 ]
            Worklog Id 61025 [ 61025 ]
            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) made changes -
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Amber Love-Jones

            I. To handle the above condition of LOA to re-enrolled. We have only one way to do it. Though the employee is enrolled or eligible for single day of the month such employee will get populate on file irrespective of its status.

            • e.g. Employee XYZ hired on 06/01/2016 and enrollment is terminated on 01/18/2017. This employee will get populated on Jan-2017 month file by considering full month coverage irrespective of any status.
            • e.g. Employee PQR is hired on 10/22/2016 and its enrollment effective from 01/22/2017 and enrollment terminated on 04/30/2017. Still this employee will get populated on Jan-2017 file. We will consider eligible or enrolled in ACA medical plan for complete Jan month.
              Please confirm the above two examples.

            II. Please find the attached Analysis_Proviedence_Medical_Center.zip file contains detail analysis for 20 employees of Providence medical center.

            Password sent in mail.

            Jennifer Johnson Nandkumar Prabhakar KarlekarSmita PawarRevansiddha Gaur

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Amber Love-Jones I . To handle the above condition of LOA to re-enrolled. We have only one way to do it. Though the employee is enrolled or eligible for single day of the month such employee will get populate on file irrespective of its status. e.g. Employee XYZ hired on 06/01/2016 and enrollment is terminated on 01/18/2017. This employee will get populated on Jan-2017 month file by considering full month coverage irrespective of any status. e.g. Employee PQR is hired on 10/22/2016 and its enrollment effective from 01/22/2017 and enrollment terminated on 04/30/2017. Still this employee will get populated on Jan-2017 file. We will consider eligible or enrolled in ACA medical plan for complete Jan month. Please confirm the above two examples. II . Please find the attached Analysis_Proviedence_Medical_Center.zip file contains detail analysis for 20 employees of Providence medical center. Password sent in mail. Jennifer Johnson Nandkumar Prabhakar Karlekar Smita Pawar Revansiddha Gaur
            alov Amber Love-Jones (Inactive) made changes -
            Attachment screenshot-3.png [ 54412 ]
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Yogesh Chaudhari,

            I.*strong text*

            • e.g. Employee XYZ - if the employee is terminated mid-month, the term date for the medical plan will be end of month.
            • e.g. Employee PQR - if this employee is on LOA and becomes effective for benefits and enrolls 1/22/2017, yes, we want the employee to be included on the January file, even if it is for one day.

            *strong text*II.*strong text*Thank you for sending the Providence file - I will review and advise if there are any questions before sending it to Prime.

            strong text*III.*strong text I have confirmed with Prime Healthcare that the facility, Coshocton Regional Medical Center, has only one EIN:

            The same EIN needs to be used for the following facilities that fall under Coshocton:

            • Coshocton
            • Coshocton Arrowhead
            • Coshocton Cardiology
            • Coshocton Dresden Clinic
            • Coshocton Ent
            • Coshocton Family Phys
            • Coshocton Occ Med
            • Coshocton Ortho
            • Coshocton Pain Clinic
            • Coshocton Pleasant Valley
            • Coshocton Surgical Center
            • Coshocton Women's Health Center

            Thank you!

            Amber

            Jennifer Johnson

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Yogesh Chaudhari , I.*strong text * e.g. Employee XYZ - if the employee is terminated mid-month, the term date for the medical plan will be end of month. e.g. Employee PQR - if this employee is on LOA and becomes effective for benefits and enrolls 1/22/2017, yes , we want the employee to be included on the January file, even if it is for one day. *strong text*II.*strong text*Thank you for sending the Providence file - I will review and advise if there are any questions before sending it to Prime. strong text*III.*strong text I have confirmed with Prime Healthcare that the facility, Coshocton Regional Medical Center, has only one EIN: The same EIN needs to be used for the following facilities that fall under Coshocton: Coshocton Coshocton Arrowhead Coshocton Cardiology Coshocton Dresden Clinic Coshocton Ent Coshocton Family Phys Coshocton Occ Med Coshocton Ortho Coshocton Pain Clinic Coshocton Pleasant Valley Coshocton Surgical Center Coshocton Women's Health Center Thank you! Amber Jennifer Johnson
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hello Amber Love-Jones

            I. We can not handle this only for employee who was LOA and re-enrolled again. Any employee employee who is getting benefits for single day of month will get populate on respective month file irrespective of its any status.
            Below are some of the examples of employee which will get populate on file.

            • Suppose an employee PQR was terminated and again active in the system with enrollment effective date 01/15/2017. This employee will get populated on Jan month file.
            • An employee LMN was on LOA and becomes effective for benefits and enrolls 1/22/2017 then this employee will come on file.

            II. I have mapped all the facilities that fall under Coshocton with same EIN 320506896.

            Jennifer JohnsonNandkumar Prabhakar KarlekarSmita Pawar

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hello Amber Love-Jones I . We can not handle this only for employee who was LOA and re-enrolled again. Any employee employee who is getting benefits for single day of month will get populate on respective month file irrespective of its any status. Below are some of the examples of employee which will get populate on file. Suppose an employee PQR was terminated and again active in the system with enrollment effective date 01/15/2017. This employee will get populated on Jan month file. An employee LMN was on LOA and becomes effective for benefits and enrolls 1/22/2017 then this employee will come on file. II . I have mapped all the facilities that fall under Coshocton with same EIN 320506896 . Jennifer Johnson Nandkumar Prabhakar Karlekar Smita Pawar
            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.

            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - - edited

            Hello Amber Love-Jones,

            While doing analysis to populate employee who is getting benefit for single day of the encounter with below query. Please let us know your thoughts on same.

            • Employee Carl Ling Jr. is enrolled in waived medical plan from 01/01/2017 to 03/02/2017. Carl Ling Jr. terminated on 03/03/2017 in the system. He has an offer of minimum cost plan EPO1 Plan from 01/01/2017 to 03/02/2017. So in Jan-2017 and Feb-2017 EPO1 Plan is populated as minimum cost plan on ACA file. Now if the employee is eligible for single day of the month still we are going to show employee on the respective month file. As he is terminated on 03/03/2017 then what is the expected cost should we populate on March month file. (Should we show cost of minimum eligible plan EPO1 Plan on file?). Please let us know your inputs for the same.
            • Employee ELEANOR STOCKSTILL is enrolled in Saint Marys Regional Medical Center Employee Medical Plan plan from 01/01/2017 to 06/30/2017. He is terminated on 06/05/2017. He has offer of Saint Marys Regional Medical Center Employee PPO Medical Plan as minimum cost plan, so files from Jan-2017 to May- 2017 Saint Marys Regional Medical Center Employee PPO Medical Plan is populating as minimum cost plan on ACA file. Now if the employee has coverage of single day of the month we are going to populate it on file. As this employee is terminated on 06/05/2017 then which plan should we populate as minimum cost plan on the June-2017 file either enrolled plan (Saint Marys Regional Medical Center Employee Medical Plan) or minimum cost plan (Saint Marys Regional Medical Center Employee PPO Medical Plan) on June-2017 file? Please let us know your thoughts on same.
            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - - edited Hello Amber Love-Jones , While doing analysis to populate employee who is getting benefit for single day of the encounter with below query. Please let us know your thoughts on same. Employee Carl Ling Jr. is enrolled in waived medical plan from 01/01/2017 to 03/02/2017. Carl Ling Jr. terminated on 03/03/2017 in the system. He has an offer of minimum cost plan EPO1 Plan from 01/01/2017 to 03/02/2017. So in Jan-2017 and Feb-2017 EPO1 Plan is populated as minimum cost plan on ACA file. Now if the employee is eligible for single day of the month still we are going to show employee on the respective month file. As he is terminated on 03/03/2017 then what is the expected cost should we populate on March month file. (Should we show cost of minimum eligible plan EPO1 Plan on file?). Please let us know your inputs for the same. Employee ELEANOR STOCKSTILL is enrolled in Saint Marys Regional Medical Center Employee Medical Plan plan from 01/01/2017 to 06/30/2017. He is terminated on 06/05/2017. He has offer of Saint Marys Regional Medical Center Employee PPO Medical Plan as minimum cost plan, so files from Jan-2017 to May- 2017 Saint Marys Regional Medical Center Employee PPO Medical Plan is populating as minimum cost plan on ACA file. Now if the employee has coverage of single day of the month we are going to populate it on file. As this employee is terminated on 06/05/2017 then which plan should we populate as minimum cost plan on the June-2017 file either enrolled plan ( Saint Marys Regional Medical Center Employee Medical Plan ) or minimum cost plan ( Saint Marys Regional Medical Center Employee PPO Medical Plan ) on June-2017 file? Please let us know your thoughts on same.
            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.

            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello [~Yogesh],

            I have updated and attached the file titled_Analysis_Dev_UPDATED_Prime+6.30.zip for Development changes only. The password is the same, but will be emailed to you.

            Thank you for mapping all facilities that fall under Coshocton to the same EIN.

            I will review Providence file attached above as well as the two employees listed above and will have responses for you shortly.

            Thank you.

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello [~Yogesh] , I have updated and attached the file titled_Analysis_Dev_UPDATED_Prime+6.30.zip for Development changes only. The password is the same, but will be emailed to you. Thank you for mapping all facilities that fall under Coshocton to the same EIN. I will review Providence file attached above as well as the two employees listed above and will have responses for you shortly. Thank you. Amber
            alov Amber Love-Jones (Inactive) made changes -
            alov Amber Love-Jones (Inactive) made changes -
            Attachment Analysis_Dev_UPDATED_Prime 6.xls [ 54806 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 11/Jul/17 08:00 AM
            • Time Spent:
              4h
               
              <No comment>
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hello Amber Love-Jones

            While doing analysis to populate employee who is getting benefit for single day of the encounter with one more query in below scenario.

            • Employee JENNIFER VAZQUEZ is enrolled in Saint Marys Regional Medical Center Employee Medical Plan from 01/01/2015. JENNIFER VAZQUEZ is terminated on 05/22/2017. He has an offer of Saint Marys Regional Medical Center Employee PPO Medical Plan as minimum cost plan, so files from Jan-2017 to April- 2017 Saint Marys Regional Medical Center Employee PPO Medical Plan is populating as minimum cost plan on ACA file. Now if the employee has coverage of single day of month we are going to populate it on respective month file. As this employee is terminated on 05/22/2017 then its minimum plan offer(Saint Marys Regional Medical Center Employee PPO Medical Plan) is terminated on 05/22/2017 and its enrollment (Saint Marys Regional Medical Center Employee Medical Plan) is terminated on 05/31/2017 as we are terminating benefits on end of the month.
              Which plan should we populate as minimum cost plan on file of May-2017?

            We are working on the above provided file and let you know once we done with the analysis.

            Thanks,

            Yogesh Chaudhari
            Jennifer JohnsonNandkumar Prabhakar KarlekarSmita Pawar

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hello Amber Love-Jones While doing analysis to populate employee who is getting benefit for single day of the encounter with one more query in below scenario. Employee JENNIFER VAZQUEZ is enrolled in Saint Marys Regional Medical Center Employee Medical Plan from 01/01/2015. JENNIFER VAZQUEZ is terminated on 05/22/2017. He has an offer of Saint Marys Regional Medical Center Employee PPO Medical Plan as minimum cost plan, so files from Jan-2017 to April- 2017 Saint Marys Regional Medical Center Employee PPO Medical Plan is populating as minimum cost plan on ACA file. Now if the employee has coverage of single day of month we are going to populate it on respective month file. As this employee is terminated on 05/22/2017 then its minimum plan offer(Saint Marys Regional Medical Center Employee PPO Medical Plan) is terminated on 05/22/2017 and its enrollment (Saint Marys Regional Medical Center Employee Medical Plan) is terminated on 05/31/2017 as we are terminating benefits on end of the month. Which plan should we populate as minimum cost plan on file of May-2017? We are working on the above provided file and let you know once we done with the analysis. Thanks, Yogesh Chaudhari Jennifer Johnson Nandkumar Prabhakar Karlekar Smita Pawar
            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) made changes -
            Remaining Estimate 1h [ 3600 ] 0h [ 0 ]
            Time Spent 491.5h [ 1769400 ] 499.5h [ 1798200 ]
            Worklog Id 62647 [ 62647 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 499.5h [ 1798200 ] 500.5h [ 1801800 ]
            Worklog Id 62812 [ 62812 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 500.5h [ 1801800 ] 506.5h [ 1823400 ]
            Worklog Id 62853 [ 62853 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Worklog Id 62853 [ 62853 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 506.5h [ 1823400 ] 510h [ 1836000 ]
            Worklog Id 62858 [ 62858 ]
            alov Amber Love-Jones (Inactive) made changes -
            Attachment Delete ACA Report_7.13.xls [ 55377 ]
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Yogesh Chaudhari,

            We have had some of the Prime_Healthcare facilities notify us that some of their Active employees are listed under the facility called "Delete ACA." I ran the attached report for Prime_Healthcare and see that there is a substantial amount of Active employees that are listed under this facility. Password will be sent separately.

            Can you please provide an explanation? We are not sure why these employees are showing under Delete ACA.

            Thank you,

            Amber

            Jennifer Johnson

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Yogesh Chaudhari , We have had some of the Prime_Healthcare facilities notify us that some of their Active employees are listed under the facility called "Delete ACA." I ran the attached report for Prime_Healthcare and see that there is a substantial amount of Active employees that are listed under this facility. Password will be sent separately. Can you please provide an explanation? We are not sure why these employees are showing under Delete ACA. Thank you, Amber Jennifer Johnson
            alov Amber Love-Jones (Inactive) made changes -
            Attachment Delete ACA Report_7.13.xls [ 55378 ]
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hi Amber Love-Jones,

            We had shared list of duplicate employee across all the facilities of Prime in WT-6186. List contains employees SSN with their company names. Jennifer Johnson had provided inputs to delete duplicate employee from one of the facilities for all the employee. As we discussed, Instead of deleting these duplicate employees we had created new class 'DeleteACA' and moved duplicate employee in that class. Also while delivering ACA files we are not considering these employees.
            Please see the below link for more information.
            https://workterra.atlassian.net/browse/WT-6186?focusedCommentId=76805&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-76805

            Thanks,
            Yogesh Chaudhari

            Nandkumar Prabhakar KarlekarJennifer JohnsonSmita Pawar

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hi Amber Love-Jones , We had shared list of duplicate employee across all the facilities of Prime in WT-6186 . List contains employees SSN with their company names. Jennifer Johnson had provided inputs to delete duplicate employee from one of the facilities for all the employee. As we discussed, Instead of deleting these duplicate employees we had created new class 'DeleteACA' and moved duplicate employee in that class. Also while delivering ACA files we are not considering these employees. Please see the below link for more information. https://workterra.atlassian.net/browse/WT-6186?focusedCommentId=76805&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-76805 Thanks, Yogesh Chaudhari Nandkumar Prabhakar Karlekar Jennifer Johnson Smita Pawar
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 510h [ 1836000 ] 518h [ 1864800 ]
            Worklog Id 63831 [ 63831 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 518h [ 1864800 ] 526h [ 1893600 ]
            Worklog Id 64346 [ 64346 ]
            alov Amber Love-Jones (Inactive) made changes -
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Yogesh Chaudhari,

            I have completed the questions asked for the Providence employees and included the file: Analysis Providence Medical Center_with password. The password will be sent to you separately.

            Additionally, I added a second tab on the above attachment for the separate employee questions you posed on 7/10 and 7/11.

            All of the analysis reports have been sent to the Prime team for review. As soon as I receive a response, I will communicate with you.

            Thank you!

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Yogesh Chaudhari , I have completed the questions asked for the Providence employees and included the file: Analysis Providence Medical Center_with password. The password will be sent to you separately. Additionally, I added a second tab on the above attachment for the separate employee questions you posed on 7/10 and 7/11. All of the analysis reports have been sent to the Prime team for review. As soon as I receive a response, I will communicate with you. Thank you! Amber
            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) made changes -
            Time Spent 526h [ 1893600 ] 530h [ 1908000 ]
            Worklog Id 64816 [ 64816 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Time Spent 530h [ 1908000 ] 532h [ 1915200 ]
            Worklog Id 64835 [ 64835 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Time Spent 532h [ 1915200 ] 534h [ 1922400 ]
            Worklog Id 64864 [ 64864 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 20/Jul/17 08:00 AM
            • Time Spent:
              2h
               
              <No comment>
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hello Amber Love-Jones

            Do you have any updates?

            Thanks,
            Yogesh Chaudhari

            Nandkumar Prabhakar KarlekarJennifer JohnsonRevansiddha GaurSmita Pawar

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hello Amber Love-Jones Do you have any updates? Thanks, Yogesh Chaudhari Nandkumar Prabhakar Karlekar Jennifer Johnson Revansiddha Gaur Smita Pawar
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 25/Jul/17 08:00 AM
            • Time Spent:
              2h
               
              <No comment>
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 534h [ 1922400 ] 536h [ 1929600 ]
            Worklog Id 66240 [ 66240 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 536h [ 1929600 ] 541h [ 1947600 ]
            Worklog Id 66561 [ 66561 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 541h [ 1947600 ] 546h [ 1965600 ]
            Worklog Id 66572 [ 66572 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 4h [ 14400 ]
            Time Spent 546h [ 1965600 ] 542h [ 1951200 ]
            Worklog Id 60993 [ 60993 ]
            Worklog Time Spent 4h [ 14400 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 3h [ 10800 ]
            Time Spent 542h [ 1951200 ] 543h [ 1954800 ]
            Worklog Id 67047 [ 67047 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Remaining Estimate 3h [ 10800 ] 1h [ 3600 ]
            Time Spent 543h [ 1954800 ] 545h [ 1962000 ]
            Worklog Id 67509 [ 67509 ]
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hello Amber Love-Jones

            Do you have any updates on analysis reports shared with Prime team ?

            Tomorrow,I will share some of our queries regarding Providence Medical Center.

            Thanks,
            Yogesh Chaudhari

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hello Amber Love-Jones Do you have any updates on analysis reports shared with Prime team ? Tomorrow,I will share some of our queries regarding Providence Medical Center. Thanks, Yogesh Chaudhari
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hello Amber Love-Jones,

            Please find the attached sheet Updated_Analysis_Providence_Medical_Center_with password.zip contains feedback for Providence Medical Center employee. I have added one more columns as Harbinger Comment in attached sheet.

            When can we expect to export Prime files for rest of the months?
            It will be better if you shared feedback received from client, will made client suggested changes in next files.
            password sent in mail.

            Thanks,

            Yogesh Chaudhari

            Jennifer JohnsonAbhay PatilNandkumar Prabhakar KarlekarSmita PawarRevansiddha Gaur

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hello Amber Love-Jones , Please find the attached sheet Updated_Analysis_Providence_Medical_Center_with password.zip contains feedback for Providence Medical Center employee. I have added one more columns as Harbinger Comment in attached sheet. When can we expect to export Prime files for rest of the months? It will be better if you shared feedback received from client, will made client suggested changes in next files. password sent in mail. Thanks, Yogesh Chaudhari Jennifer Johnson Abhay Patil Nandkumar Prabhakar Karlekar Smita Pawar Revansiddha Gaur
            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) made changes -
            Remaining Estimate 1h [ 3600 ] 0h [ 0 ]
            Time Spent 545h [ 1962000 ] 546.5h [ 1967400 ]
            Worklog Id 70601 [ 70601 ]
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello [~yogesh],

            We are not ready to move forward with the January 2017 ACA files. The client has not completed their review of the recent HMC issue.

            Additionally, it was stated that there are several employees enrolled in a medical plan AND the Waive Opt Out/Spouse Opt Out Plans for St. Marys Health Network and St. Marys Medical Group. Please advise if you are able to run this reporting for both facilities and advise which employees are enrolled in both medical and opt out plans.

            Thank you!

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello [~yogesh] , We are not ready to move forward with the January 2017 ACA files. The client has not completed their review of the recent HMC issue. Additionally, it was stated that there are several employees enrolled in a medical plan AND the Waive Opt Out/Spouse Opt Out Plans for St. Marys Health Network and St. Marys Medical Group. Please advise if you are able to run this reporting for both facilities and advise which employees are enrolled in both medical and opt out plans. Thank you! Amber
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Yogesh Chaudhari,

            Please review paragraph 2 above. Can Development assist?

            Thank you!

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Yogesh Chaudhari , Please review paragraph 2 above. Can Development assist? Thank you! Amber
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hello Amber Love-Jones

            Please find the attached file Employee_List_Saint_Marys_Medical_OptOut.zip contains list of employees those are enrolled in Medical plan as well as in Waive Opt Out/Spouse Opt Out Plans in year 2017.

            List contains employee belongs to below 3 facilities.
            1. Saint Marys Regional Medical Center
            2. Saint Marys Medical Group
            3. Saint Marys General Hospital

            Password sent in mail.

            Thanks,
            Yogesh Chaudhari

            Nandkumar Prabhakar KarlekarSmita PawarRevansiddha Gaur

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hello Amber Love-Jones Please find the attached file Employee_List_Saint_Marys_Medical_OptOut.zip contains list of employees those are enrolled in Medical plan as well as in Waive Opt Out/Spouse Opt Out Plans in year 2017. List contains employee belongs to below 3 facilities. 1. Saint Marys Regional Medical Center 2. Saint Marys Medical Group 3. Saint Marys General Hospital Password sent in mail. Thanks, Yogesh Chaudhari Nandkumar Prabhakar Karlekar Smita Pawar Revansiddha Gaur
            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

            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 546.5h [ 1967400 ] 548.5h [ 1974600 ]
            Worklog Id 72747 [ 72747 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 18/Aug/17 09:00 PM
            • Time Spent:
              0.5h
               

              Discussion on cost query.

            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Yogesh Chaudhari,

            Thank you for creating the report. Will review and get back to Development with the next steps to resolve.

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Yogesh Chaudhari , Thank you for creating the report. Will review and get back to Development with the next steps to resolve. Amber
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 548.5h [ 1974600 ] 549h [ 1976400 ]
            Worklog Id 72970 [ 72970 ]
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hello Amber Love-Jones,

            Do you have any updates or receive feedback on all above reports sent?

            Thanks,

            Yogesh Chaudhari

            Nandkumar Prabhakar KarlekarSmita PawarRevansiddha Gaur

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hello Amber Love-Jones , Do you have any updates or receive feedback on all above reports sent? Thanks, Yogesh Chaudhari Nandkumar Prabhakar Karlekar Smita Pawar Revansiddha Gaur
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Yogesh Chaudhari,

            We are still awaiting feedback from Prime's ACA team; and we sent the St Marys reporting directly to the client to reconcile, and haven't received a response from them. I will keep you updated.

            Thank you,

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Yogesh Chaudhari , We are still awaiting feedback from Prime's ACA team; and we sent the St Marys reporting directly to the client to reconcile, and haven't received a response from them. I will keep you updated. Thank you, Amber
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Yogesh Chaudhari,

            Attached, please find the updated report for the Saint Marys facilities where employees were enrolled in both Medical plans and the Medical Opt Out Plans. Please remove the Opt Out Plan for all employees listed on the spreadsheet. The password will be emailed to you.

            Thank you!

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Yogesh Chaudhari , Attached, please find the updated report for the Saint Marys facilities where employees were enrolled in both Medical plans and the Medical Opt Out Plans. Please remove the Opt Out Plan for all employees listed on the spreadsheet. The password will be emailed to you. Thank you! Amber
            alov Amber Love-Jones (Inactive) made changes -
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hello Amber Love-Jones

            I have analysed attached 70 employees, all these employees are enrolled in 'Saint Marys Regional Medical Center Employee Medical Plan' as well as 'Spouse Opt out' plan. While exporting ACA files considering only medical benefits plans. The benefit Type of Spouse Opt Out plan is Spousal Opt Out Credit, We have not considered enrollment in this plan while exporting ACA files.
            Also system is not support to delete/remove opt out coverage automatically, so we can not remove its coverage from opt out plan, need to remove it manually.
            Please remove the Opt Out Plan manually at your end for all these employee.

            Thanks,
            Yogesh Chaudhari
            Nandkumar Prabhakar KarlekarSmita PawarRevansiddha Gaur

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hello Amber Love-Jones I have analysed attached 70 employees, all these employees are enrolled in 'Saint Marys Regional Medical Center Employee Medical Plan' as well as 'Spouse Opt out' plan. While exporting ACA files considering only medical benefits plans. The benefit Type of Spouse Opt Out plan is Spousal Opt Out Credit , We have not considered enrollment in this plan while exporting ACA files. Also system is not support to delete/remove opt out coverage automatically, so we can not remove its coverage from opt out plan, need to remove it manually. Please remove the Opt Out Plan manually at your end for all these employee. Thanks, Yogesh Chaudhari Nandkumar Prabhakar Karlekar Smita Pawar Revansiddha Gaur
            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

            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 549h [ 1976400 ] 551.5h [ 1985400 ]
            Worklog Id 76007 [ 76007 ]
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hello Amber Love-Jones

            Have you received any feedback from Prime's ACA team?
            When can we expect to export Prime files for rest of the months?

            Thanks,
            Yogesh Chaudhari

            Nandkumar Prabhakar KarlekarSmita PawarRevansiddha Gaur

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hello Amber Love-Jones Have you received any feedback from Prime's ACA team? When can we expect to export Prime files for rest of the months? Thanks, Yogesh Chaudhari Nandkumar Prabhakar Karlekar Smita Pawar Revansiddha Gaur
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 15/Sep/17 01:15 PM
            • Time Spent:
              3h
               

              call and analysis

            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Yogesh Chaudhari,

            I have reached out to the client several times, without receiving a response. I will call the client Monday, 9/18.

            Thank you.

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Yogesh Chaudhari , I have reached out to the client several times, without receiving a response. I will call the client Monday, 9/18. Thank you. Amber
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hi Amit Thorve

            MOM Call:
            1. Amit is going to set-up call with onshore team today or tomorrow.
            2. If employee is eligible for single day of the month, Should this employee populate on file?
            [EBS] : We will have to confirm this with client in call.

            3. Provides list of employees neither waive and nor enrolled for all the facilities of Prime.
            [Harbinger] : Harbinger team will provide list of neither enrolled nor waived employee for all the facilities of Prime.
            To get list of neither enrolled nor waive employee for one company need complete one day including verification. In Prime we have almost 15 facilities so we need 15 days to complete this task. Everyday we will try to complete 1 or 2 companies and share report with Amit and onshore team.

            4. List of waive or enrolled employee but not eligible for any ACA medical plan for all Prime facilities.
            [Harbinger] : Yogesh will provide employee those are enrolled or waived in medical but not eligible for any ACA medical plan for all the facilities of Prime.
            We need 3 days to complete this task for all the Prime facilities.

            Thanks,

            Yogesh Chaudhari
            Nandkumar Prabhakar KarlekarSmita PawarRevansiddha Gaur

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hi Amit Thorve MOM Call: 1. Amit is going to set-up call with onshore team today or tomorrow. 2. If employee is eligible for single day of the month, Should this employee populate on file? [EBS] : We will have to confirm this with client in call. 3. Provides list of employees neither waive and nor enrolled for all the facilities of Prime. [Harbinger] : Harbinger team will provide list of neither enrolled nor waived employee for all the facilities of Prime. To get list of neither enrolled nor waive employee for one company need complete one day including verification. In Prime we have almost 15 facilities so we need 15 days to complete this task. Everyday we will try to complete 1 or 2 companies and share report with Amit and onshore team. 4. List of waive or enrolled employee but not eligible for any ACA medical plan for all Prime facilities. [Harbinger] : Yogesh will provide employee those are enrolled or waived in medical but not eligible for any ACA medical plan for all the facilities of Prime. We need 3 days to complete this task for all the Prime facilities. Thanks, Yogesh Chaudhari Nandkumar Prabhakar Karlekar Smita Pawar Revansiddha Gaur
            smita.pawar Smita Pawar (Inactive) logged work - 20/Sep/17 01:49 PM
            • Time Spent:
              3h
               

              Analysis of client mail
              Call with Amit

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 551.5h [ 1985400 ] 554.5h [ 1996200 ]
            Worklog Id 80012 [ 80012 ]
            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

            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hello Amit Thorve

            As discussed in call, Please find the attached KMC_Neither_Enrolled_Nor_Waived_List.zip file contains list of employee those are neither waive nor enrolled in medical plan but are eligible for medical plan for KMC company.

            Password sent in mail.

            Thanks,
            Yogesh Chaudhari

            Amber Love-JonesYamilka CocaJennifer JohnsonAbhay PatilNickNandkumar Prabhakar KarlekarRevansiddha GaurSmita PawarSamir

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hello Amit Thorve As discussed in call, Please find the attached KMC_Neither_Enrolled_Nor_Waived_List.zip file contains list of employee those are neither waive nor enrolled in medical plan but are eligible for medical plan for KMC company. Password sent in mail. Thanks, Yogesh Chaudhari Amber Love-Jones Yamilka Coca Jennifer Johnson Abhay Patil Nick Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar Samir
            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) made changes -
            Time Spent 554.5h [ 1996200 ] 555.5h [ 1999800 ]
            Worklog Id 80373 [ 80373 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hello Amit Thorve,Amber Love-Jones

            As discussed in yesterday's call, Please find the attached Revised_Prime_Duplicate_Active_Employee_List.zip revised list of employee those are Active in multiple Prime companies.

            I have found almost 209 active employees those are duplicate across all the Prime facilities.

            Password sent in separate mail.

            Thanks,
            Yogesh Chaudhari

            Yamilka CocaJennifer JohnsonAbhay PatilNickNandkumar Prabhakar KarlekarRevansiddha GaurSmita Pawar

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hello Amit Thorve , Amber Love-Jones As discussed in yesterday's call, Please find the attached Revised_Prime_Duplicate_Active_Employee_List.zip revised list of employee those are Active in multiple Prime companies. I have found almost 209 active employees those are duplicate across all the Prime facilities. Password sent in separate mail. Thanks, Yogesh Chaudhari Yamilka Coca Jennifer Johnson Abhay Patil Nick Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar
            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.

            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hello Amit Thorve Revansiddha Gaur

            Please ignore previously uploaded * KMC_Neither_Enrolled_Nor_Waived_List.zip* file contains list of employees those are neither enrolled nor waived for KMC company.While testing this file found some discrepancies. We will upload updated file by today EOD.

            Thanks,
            Yogesh Chaudhari

            Yamilka CocaJennifer JohnsonNandkumar Prabhakar KarlekarRevansiddha GaurSmita Pawar

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hello Amit Thorve Revansiddha Gaur Please ignore previously uploaded * KMC_Neither_Enrolled_Nor_Waived_List.zip * file contains list of employees those are neither enrolled nor waived for KMC company.While testing this file found some discrepancies. We will upload updated file by today EOD. Thanks, Yogesh Chaudhari Yamilka Coca Jennifer Johnson Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Amber Love-Jones,

            Please find the neither enroll nor waived employee list for below companies on ftp site.

            Ftp Path: /users/workterraaca/Prime/2017/09232017
            Companies:
            1. Hospitality - WaiveList_Company ID_12444_Hospitality_09232017.xls
            2. KMC - WaiveList_CompanyID_12440_KMC_09232017.xls
            3. PMC-WaiveList_CompanyID_12443_PMC_09232017.xls

            Thanks,
            Revan

            CC: Amit Thorve, Nandkumar Prabhakar Karlekar, Yamilka Coca, Jennifer Johnson, Yogesh Chaudhari, Smita Pawar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Amber Love-Jones , Please find the neither enroll nor waived employee list for below companies on ftp site. Ftp Path: /users/workterraaca/Prime/2017/09232017 Companies: 1. Hospitality - WaiveList_Company ID_12444_Hospitality_09232017.xls 2. KMC - WaiveList_CompanyID_12440_KMC_09232017.xls 3. PMC-WaiveList_CompanyID_12443_PMC_09232017.xls Thanks, Revan CC: Amit Thorve , Nandkumar Prabhakar Karlekar , Yamilka Coca , Jennifer Johnson , Yogesh Chaudhari , Smita Pawar
            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

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 555.5h [ 1999800 ] 561.5h [ 2021400 ]
            Worklog Id 81160 [ 81160 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment Prime Checklist QA_Sep 25 2017.xls [ 62599 ]
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Amber Love-Jones,

            PFA '' Prime Checklist QA_Sep 25 2017.xls Harbinger's Prime check list and verified Prime companie's default plan mapping customization. Please review it and let us know, if any additions needs to be done from our side.

            Thanks,
            Smita

            FYI: Amit Thorve,Nandkumar Prabhakar Karlekar,Yamilka Coca,Jennifer Johnson,Yogesh Chaudhari,Revansiddha Gaur

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Amber Love-Jones , PFA '' Prime Checklist QA_Sep 25 2017.xls Harbinger's Prime check list and verified Prime companie's default plan mapping customization. Please review it and let us know, if any additions needs to be done from our side. Thanks, Smita FYI: Amit Thorve , Nandkumar Prabhakar Karlekar , Yamilka Coca , Jennifer Johnson , Yogesh Chaudhari , Revansiddha Gaur
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Amber Love-Jones,

            Please find the neither enroll nor waived employee list for below companies on ftp site.

            Ftp Path: /users/workterraaca/Prime/2017/09252017
            Companies:
            1. CHMC- WaiveList_CompanyID_12380_CHMC_09252017.xls Waive Employee Count- 68
            2. EHMC- WaiveList_CompanyID_12381_EHMC_09252017.xls Waive Employee Count-19

            Note:
            We found some discrepancy in previously shared files which we updated the sheet in the same folder for the below companies.

            1. KMC - WaiveList_CompanyID_12440_KMC_09232017.xls Waive Employee Count- 5
            2. PMC-WaiveList_CompanyID_12443_PMC_09232017.xls Waive Employee Count- 18

            Thanks,
            Revan
            CC: Amit Thorve, Nandkumar Prabhakar Karlekar, Yamilka Coca, Jennifer Johnson, Yogesh Chaudhari, Smita Pawar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Amber Love-Jones , Please find the neither enroll nor waived employee list for below companies on ftp site. Ftp Path: /users/workterraaca/Prime/2017/09252017 Companies: 1. CHMC- WaiveList_CompanyID_12380_CHMC_09252017.xls Waive Employee Count - 68 2. EHMC- WaiveList_CompanyID_12381_EHMC_09252017.xls Waive Employee Count -19 Note: We found some discrepancy in previously shared files which we updated the sheet in the same folder for the below companies. 1. KMC - WaiveList_CompanyID_12440_KMC_09232017.xls Waive Employee Count - 5 2. PMC-WaiveList_CompanyID_12443_PMC_09232017.xls Waive Employee Count - 18 Thanks, Revan CC: Amit Thorve , Nandkumar Prabhakar Karlekar , Yamilka Coca , Jennifer Johnson , Yogesh Chaudhari , Smita Pawar
            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

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 561.5h [ 2021400 ] 565.5h [ 2035800 ]
            Worklog Id 81418 [ 81418 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 565.5h [ 2035800 ] 569.5h [ 2050200 ]
            Worklog Id 81450 [ 81450 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 569.5h [ 2050200 ] 570.5h [ 2053800 ]
            Worklog Id 81450 [ 81450 ]
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - - edited

            Hi Amber Love-Jones

            Please find the attached EmployeeList_Demographic_Classwise_EIN_Different.zip file contains list of employees whose EIN on demograpic is different than class-wise EIN. We have found almost 322 such employees across all the Prime facilities processing for ACA.
            Attached file contains 2 columns EIN on Demographic (Employee EIN on his demograpic page ) and Class-wise EIN (EIN as per employee class1).
            As per our current logic we are giving priority to demographic EIN. On ACA file Demographic EIN is populating for all these employee.

            Can you please confirm with client about which EIN are valid/considered for all these employee?

            Password sent in mail.

            Thanks,
            Yogesh Chaudhari

            Amit ThorveYamilka CocaJennifer JohnsonNandkumar Prabhakar KarlekarRevansiddha GaurSmita Pawar

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - - edited Hi Amber Love-Jones Please find the attached EmployeeList_Demographic_Classwise_EIN_Different.zip file contains list of employees whose EIN on demograpic is different than class-wise EIN. We have found almost 322 such employees across all the Prime facilities processing for ACA. Attached file contains 2 columns EIN on Demographic (Employee EIN on his demograpic page ) and Class-wise EIN (EIN as per employee class1). As per our current logic we are giving priority to demographic EIN. On ACA file Demographic EIN is populating for all these employee. Can you please confirm with client about which EIN are valid/considered for all these employee? Password sent in mail. Thanks, Yogesh Chaudhari Amit Thorve Yamilka Coca Jennifer Johnson Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Time Spent 570.5h [ 2053800 ] 573.5h [ 2064600 ]
            Worklog Id 81702 [ 81702 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Time Spent 573.5h [ 2064600 ] 576.5h [ 2075400 ]
            Worklog Id 81721 [ 81721 ]
            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.

            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Amber Love-Jones,

            Please find the neither enroll nor waived employee list for below companies on ftp site.

            Ftp Path: /users/workterraaca/Prime/2017/09262017

            Companies:
            1. GGH- WaiveList_CompanyID_12382_GGH_09262017.xls Waive Employee Count-133
            2. SRMC-WaiveList_CompanyID_12429_SRMC_09262017.xls Waive Employee Count-76

            Note: We have completed 7 companies till now & remaining 7 companies.

            Thanks,
            Revan

            CC: Amit Thorve, Yamilka Coca, Jennifer Johnson, Nandkumar Prabhakar Karlekar, Yogesh Chaudhari, Smita Pawar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Amber Love-Jones , Please find the neither enroll nor waived employee list for below companies on ftp site. Ftp Path: /users/workterraaca/Prime/2017/09262017 Companies: 1. GGH- WaiveList_CompanyID_12382_GGH_09262017.xls Waive Employee Count -133 2. SRMC-WaiveList_CompanyID_12429_SRMC_09262017.xls Waive Employee Count -76 Note: We have completed 7 companies till now & remaining 7 companies. Thanks, Revan CC: Amit Thorve , Yamilka Coca , Jennifer Johnson , Nandkumar Prabhakar Karlekar , Yogesh Chaudhari , Smita Pawar
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 576.5h [ 2075400 ] 585.5h [ 2107800 ]
            Worklog Id 81763 [ 81763 ]
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Revansiddha Gaur,

            Can you please rerun the Neither Enroll Nor Waive Employee List to include hire dates?

            Thank you!

            Amber

            Amit Thorve, Yamilka Coca, Jennifer Johnson, Nandkumar Prabhakar Karlekar, Yogesh Chaudhari, Smita Pawar

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Revansiddha Gaur , Can you please rerun the Neither Enroll Nor Waive Employee List to include hire dates? Thank you! Amber Amit Thorve , Yamilka Coca , Jennifer Johnson , Nandkumar Prabhakar Karlekar , Yogesh Chaudhari , Smita Pawar
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello [~amit], Nandkumar Prabhakar Karlekar,

            Per our call this morning, attached, please find the most recent EIN listing that I have for the Prime facilities. Let me know if you need anything else.

            Thank you!

            Amber

            Jennifer Johnson, Yamilka Coca

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello [~amit] , Nandkumar Prabhakar Karlekar , Per our call this morning, attached, please find the most recent EIN listing that I have for the Prime facilities. Let me know if you need anything else. Thank you! Amber Jennifer Johnson , Yamilka Coca
            alov Amber Love-Jones (Inactive) made changes -
            Attachment 2017 PRIME FEIN NUMBERS.docx [ 62762 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 26/Sep/17 09:00 PM
            • Time Spent:
              9h
               

              Neither enroll nor waive list out & client call.

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Amber Love-Jones , With reference to comment- https://workterra.atlassian.net/browse/WT-8076?focusedCommentId=139857&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-139857 There is already provided hire dates in the excel sheet. Please refer employment date column for Hire Date. Thanks, Revan Amit Thorve , Yamilka Coca , Jennifer Johnson , Nandkumar Prabhakar Karlekar , Yogesh Chaudhari , Smita Pawar
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hello Amber Love-Jones

            Could you please provide most recent EIN list in Excel format?

            If we will get this Excel then it will be very easy for us to compare with old EIN in system.

            Thanks,
            Yogesh Chaudhari

            Amit ThorveNandkumar Prabhakar KarlekarRevansiddha Gaur

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hello Amber Love-Jones Could you please provide most recent EIN list in Excel format? If we will get this Excel then it will be very easy for us to compare with old EIN in system. Thanks, Yogesh Chaudhari Amit Thorve Nandkumar Prabhakar Karlekar Revansiddha Gaur
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 585.5h [ 2107800 ] 594.5h [ 2140200 ]
            Worklog Id 81837 [ 81837 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 594.5h [ 2140200 ] 605.5h [ 2179800 ]
            Worklog Id 81838 [ 81838 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 605.5h [ 2179800 ] 615.5h [ 2215800 ]
            Worklog Id 81839 [ 81839 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Worklog Id 81839 [ 81839 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 615.5h [ 2215800 ] 623.5h [ 2244600 ]
            Worklog Id 81840 [ 81840 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 623.5h [ 2244600 ] 631.5h [ 2273400 ]
            Worklog Id 81841 [ 81841 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 631.5h [ 2273400 ] 640.5h [ 2305800 ]
            Worklog Id 81842 [ 81842 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 640.5h [ 2305800 ] 648.5h [ 2334600 ]
            Worklog Id 81844 [ 81844 ]
            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..

            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 648.5h [ 2334600 ] 654.5h [ 2356200 ]
            Worklog Id 82100 [ 82100 ]
            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

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 654.5h [ 2356200 ] 659h [ 2372400 ]
            Worklog Id 82306 [ 82306 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Attachment Prime_COBRA_Plan_List.xls [ 62985 ]
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hi Amit ThorveAmber Love-Jones

            As per discussion in call, we have find list of cobra plan which are marked as ACAPlan across all prime facilities. We have found cobra plan is marked as ACA plan in below 3 companies.

            • PrimeHealthcare
            • Coshocton
            • EastLiverpool

            Please find the attached Prime_COBRA_Plan_List.xls file contains list of cobra plan those are marked as ACA across all Prime companies.
            Employee those are eligible for these plan will get populate on ACA files. On May-2017 change file such employees are populated for referance.

            Please let us know your thoughts.

            Thanks,
            Yogesh Chaudhari

            Nandkumar Prabhakar KarlekarYamilka CocaJennifer JohnsonRevansiddha GaurSmita Pawar

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hi Amit Thorve Amber Love-Jones As per discussion in call, we have find list of cobra plan which are marked as ACAPlan across all prime facilities. We have found cobra plan is marked as ACA plan in below 3 companies. PrimeHealthcare Coshocton EastLiverpool Please find the attached Prime_COBRA_Plan_List.xls file contains list of cobra plan those are marked as ACA across all Prime companies. Employee those are eligible for these plan will get populate on ACA files. On May-2017 change file such employees are populated for referance. Please let us know your thoughts. Thanks, Yogesh Chaudhari Nandkumar Prabhakar Karlekar Yamilka Coca Jennifer Johnson Revansiddha Gaur Smita Pawar
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hi Amber Love-Jones

            Please find the neither enroll nor waived employee list for below companies on ftp site.
            FTP Path: /users/workterraaca/Prime/2017/09282017
            Companies:
            1. AH- WaiveList_CompanyID_12439_AH_09282017.xls.xls Waive Employee Count-34

            NOTE : Please let us know when team is going to import these files into the system.

            Thanks,
            Yogesh Chaudhari

            Amit ThorveNandkumar Prabhakar KarlekarYamilka CocaRevansiddha GaurSmita PawarJennifer Johnson

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hi Amber Love-Jones Please find the neither enroll nor waived employee list for below companies on ftp site. FTP Path: /users/workterraaca/Prime/2017/09282017 Companies: 1. AH- WaiveList_CompanyID_12439_AH_09282017.xls.xls Waive Employee Count-34 NOTE : Please let us know when team is going to import these files into the system. Thanks, Yogesh Chaudhari Amit Thorve Nandkumar Prabhakar Karlekar Yamilka Coca Revansiddha Gaur Smita Pawar Jennifer Johnson
            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.

            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 659h [ 2372400 ] 667h [ 2401200 ]
            Worklog Id 82503 [ 82503 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 667h [ 2401200 ] 675h [ 2430000 ]
            Worklog Id 82504 [ 82504 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 675h [ 2430000 ] 679.25h [ 2445300 ]
            Worklog Id 82687 [ 82687 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 0.25h [ 900 ]
            Time Spent 679.25h [ 2445300 ] 679h [ 2444400 ]
            Worklog Id 82687 [ 82687 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 0.25h [ 900 ] 0h [ 0 ]
            Time Spent 679h [ 2444400 ] 687h [ 2473200 ]
            Worklog Id 82811 [ 82811 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 687h [ 2473200 ] 695h [ 2502000 ]
            Worklog Id 82814 [ 82814 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 695h [ 2502000 ] 703h [ 2530800 ]
            Worklog Id 82815 [ 82815 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 703h [ 2530800 ] 710h [ 2556000 ]
            Worklog Id 82821 [ 82821 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 710h [ 2556000 ] 718h [ 2584800 ]
            Worklog Id 82822 [ 82822 ]
            smita.pawar Smita Pawar (Inactive) logged work - 29/Sep/17 01:52 PM
            • Time Spent:
              5.5h
               

              Data verification for CHMC, EHMC, AH, GGH

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 718h [ 2584800 ] 723.5h [ 2604600 ]
            Worklog Id 82868 [ 82868 ]
            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

            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 723.5h [ 2604600 ] 731.5h [ 2633400 ]
            Worklog Id 82871 [ 82871 ]
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Amber Love-Jones,

            Please find the neither enroll nor waived employee list for below company on ftp site.

            Ftp Path: /users/workterraaca/Prime/2017/09292017

            Companies:
            1. Prime Healthcare- WaiveList_CompanyID_11614_Prime Healthcare_09292017.xls

            Waive Employee Count- 664

            Below facilities are not considered in waive list.

            1. Bio Medical Services Inc
            2. Chino Valley Medical Center RNs
            3. Dallas Medical Center
            4. Dallas Regional Medical Center
            5.Garden City HGC
            6. Garden City PMG
            7. Glendora Community Hospital
            8. Huntington Beach Hospital
            9. La Palma Intercommunity Hospital
            10. Landmark
            11. Lower Bucks Hospital Non Union
            12. Lower Bucks Hospital Union
            13. North Vista Hospital
            14. PHS Gadsden Physician Management LLC
            15. Rehabilitation Hospital of RI
            16. Riverview Regional Medical Center
            17. Roxborough Memorial Hospital
            18. Saint Clares Health System
            19. Saint Marys General Hospital
            20. Summit Surgery Center at St Marys Galena
            21. United Home Health Services
            22. West Anaheim Medical Center

            Thanks,
            Revan

            Amit Thorve, Nandkumar Prabhakar Karlekar, Yamilka Coca, Jennifer Johnson, Yogesh Chaudhari, Smita Pawar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Amber Love-Jones , Please find the neither enroll nor waived employee list for below company on ftp site. Ftp Path: /users/workterraaca/Prime/2017/09292017 Companies: 1. Prime Healthcare- WaiveList_CompanyID_11614_Prime Healthcare_09292017.xls Waive Employee Count- 664 Below facilities are not considered in waive list. 1. Bio Medical Services Inc 2. Chino Valley Medical Center RNs 3. Dallas Medical Center 4. Dallas Regional Medical Center 5.Garden City HGC 6. Garden City PMG 7. Glendora Community Hospital 8. Huntington Beach Hospital 9. La Palma Intercommunity Hospital 10. Landmark 11. Lower Bucks Hospital Non Union 12. Lower Bucks Hospital Union 13. North Vista Hospital 14. PHS Gadsden Physician Management LLC 15. Rehabilitation Hospital of RI 16. Riverview Regional Medical Center 17. Roxborough Memorial Hospital 18. Saint Clares Health System 19. Saint Marys General Hospital 20. Summit Surgery Center at St Marys Galena 21. United Home Health Services 22. West Anaheim Medical Center Thanks, Revan Amit Thorve , Nandkumar Prabhakar Karlekar , Yamilka Coca , Jennifer Johnson , Yogesh Chaudhari , Smita Pawar
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 29/Sep/17 09:00 PM
            • Time Spent:
              8h
               

              Waive list out-Prime Healthcare.

            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Amber Love-Jones,

            Please find the neither enroll nor waived employee list for below companies on ftp site.

            Ftp Path: /users/workterraaca/Prime/2017/10032017

            Companies:

            1. HMC- WaiveList_CompanyID_12441_HMC_10032017.xls (Waive Employee Count-49)

            2. MHIN-WaiveList_CompanyID_12442_MHIN_10032017.xls (Waive Employee Count-70)

            3.PrimeHealthCare (Without space)- WaiveList_CompanyID_12131_PrimeHealthcare_10032017.xls (Waive Employee Count-77)

            Thanks,
            Revan

            Amit Thorve, Yamilka Coca, Jennifer Johnson, Nandkumar Prabhakar Karlekar, Yogesh Chaudhari, Smita Pawar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Amber Love-Jones , Please find the neither enroll nor waived employee list for below companies on ftp site. Ftp Path: /users/workterraaca/Prime/2017/10032017 Companies: 1. HMC- WaiveList_CompanyID_12441_HMC_10032017.xls ( Waive Employee Count-49 ) 2. MHIN-WaiveList_CompanyID_12442_MHIN_10032017.xls ( Waive Employee Count-70 ) 3.PrimeHealthCare (Without space)- WaiveList_CompanyID_12131_PrimeHealthcare_10032017.xls ( Waive Employee Count-77 ) Thanks, Revan Amit Thorve , Yamilka Coca , Jennifer Johnson , Nandkumar Prabhakar Karlekar , Yogesh Chaudhari , Smita Pawar
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 731.5h [ 2633400 ] 739.5h [ 2662200 ]
            Worklog Id 83000 [ 83000 ]
            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

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 739.5h [ 2662200 ] 744.5h [ 2680200 ]
            Worklog Id 83030 [ 83030 ]
            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

            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - - edited

            Hi Amber Love-Jones,

            Please find the neither enrolled nor waived employee list for below companies on ftp site.
            Ftp Path: /users/workterraaca/Prime/2017/10042017

            Companies:
            1. EastLiverPool - WaiveList_CompanyID_12793_EastLiverpool_10042017.xls (Waive Employee Count-320)
            2. Coshocton - WaiveList_CompanyID_12777_Coshocton_10042017.xls (Waive Employee Count-232)

            We have completed and uploaded neither enrolled nor waived employee list for all 14 facilities of Prime on FTP server.
            Have you started loading these records into the system?

            Thanks,
            Yogesh Chaudhari

            Amit ThorveYamilka CocaJennifer Johnson Nandkumar Prabhakar KarlekarRevansiddha GaurSmita Pawar

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - - edited Hi Amber Love-Jones , Please find the neither enrolled nor waived employee list for below companies on ftp site. Ftp Path: /users/workterraaca/Prime/2017/10042017 Companies: 1. EastLiverPool - WaiveList_CompanyID_12793_EastLiverpool_10042017.xls (Waive Employee Count-320) 2. Coshocton - WaiveList_CompanyID_12777_Coshocton_10042017.xls (Waive Employee Count-232) We have completed and uploaded neither enrolled nor waived employee list for all 14 facilities of Prime on FTP server. Have you started loading these records into the system? Thanks, Yogesh Chaudhari Amit Thorve Yamilka Coca Jennifer Johnson Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar
            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) made changes -
            Attachment 2017_Prime_EIN_LIST.zip [ 64057 ]
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hello Amber Love-Jones,

            We have verified the EIN list Provided by you with the EIN and classes in system. All the classes and EIN are matched with EIN and classes in system. We have found discrepancy for the 4 EIN classes. Please find the attached 2017_Prime_EIN_LIST.zip file for more information.

            Please check and let us know your feedback for these 4 EIN Classes.

            Password sent in mail.

            Thanks,
            Yogesh Chaudhari

            Amit ThorveNandkumar Prabhakar KarlekarYamilka CocaJennifer JohnsonRevansiddha GaurSmita Pawar

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hello Amber Love-Jones , We have verified the EIN list Provided by you with the EIN and classes in system. All the classes and EIN are matched with EIN and classes in system. We have found discrepancy for the 4 EIN classes. Please find the attached 2017_Prime_EIN_LIST.zip file for more information. Please check and let us know your feedback for these 4 EIN Classes. Password sent in mail. Thanks, Yogesh Chaudhari Amit Thorve Nandkumar Prabhakar Karlekar Yamilka Coca Jennifer Johnson Revansiddha Gaur Smita Pawar
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 744.5h [ 2680200 ] 752.5h [ 2709000 ]
            Worklog Id 84282 [ 84282 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 752.5h [ 2709000 ] 760.5h [ 2737800 ]
            Worklog Id 84285 [ 84285 ]
            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

            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 760.5h [ 2737800 ] 763.5h [ 2748600 ]
            Worklog Id 84293 [ 84293 ]
            sumeet.kolge Sumeet.Kolge (Inactive) made changes -
            Assignee Yogesh Chaudhari [ yogesh.chaudhari ] Amber Love-Jones [ alov ]
            sumeet.kolge Sumeet.Kolge (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hello Amber Love-Jones ,

            Do you have any updates on all above comments from clients?

            Thanks,
            Yogesh Chaudhari

            Amit ThorveNandkumar Prabhakar KarlekarRevansiddha GaurJennifer JohnsonYamilka CocaSmita Pawar

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hello Amber Love-Jones , Do you have any updates on all above comments from clients? Thanks, Yogesh Chaudhari Amit Thorve Nandkumar Prabhakar Karlekar Revansiddha Gaur Jennifer Johnson Yamilka Coca Smita Pawar
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Yogesh Chaudhari,

            We have not received any response from the client.

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Yogesh Chaudhari , We have not received any response from the client. Amber
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 763.5h [ 2748600 ] 768.5h [ 2766600 ]
            Worklog Id 87590 [ 87590 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 768.5h [ 2766600 ] 769h [ 2768400 ]
            Worklog Id 87590 [ 87590 ]
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            satyap Satya made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            satyap Satya made changes -
            Resolution Done [ 10000 ]
            Status In Progress [ 3 ] Resolved [ 5 ]
            Transition Time In Source Status Execution Times
            Rakesh Roy (Inactive) made transition -
            Open Waiting for Customer Input
            10d 11h 52m 1
            Sumeet.Kolge (Inactive) made transition -
            In Progress Waiting for Customer Input
            170d 12h 34m 8
            Satya made transition -
            Waiting for Customer Input In Progress
            105d 1h 42m 9
            Satya made transition -
            In Progress Resolved
            18s 1

              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