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

List of EEs Not Enrolled In Medical Benefit Type

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Support Task Type:
      Configuration
    • Reported by:
      Support
    • Module:
      ACA - 2017
    • Severity:
      Simple

      Description

      Hello Dev,

      We need a list of EEs that are not enrolled in any medical benefit type (this includes medical, waive and opt out plans) for the following facilities:

      Prime_Healthcare
      AH
      CHMC
      EHMC
      HMC
      Hospitality
      KMC
      MHIN
      PMC
      SRMC

      Thank you

      Amber Love-Jones

        Attachments

        1. 1. FINAL_AH_Alvarado Hospital Medical Verification_UPDATED 4.26.17.xlsx
          60 kB
        2. 1. FINAL_AH_Alvarado Hospital Medical Verification.xlsx
          55 kB
        3. 1. FINAL_Chino Valley Medical Verification.xlsx
          790 kB
        4. 1. FINAL_Chino Valley Medical Verification (1)_UPDATED 4.26.17.xlsx
          799 kB
        5. 1. FINAL_CHMC_Centinela Hospital Medical Center Medical Verification.xlsx
          72 kB
        6. 1. FINAL_Desert Valley Medical Verification.xlsx
          916 kB
        7. 1. FINAL_Desert Valley Medical Verification (1)_UPDATED 4.26.17.xlsx
          579 kB
        8. 1. FINAL_EHMC_Encino Hospital Medical Center Medical Verification.xlsx
          28 kB
        9. 1. FINAL_EHMC_Encino Hospital Medical Center Medical Verification (2)_UPDATED 4.26.17.xlsx
          34 kB
        10. 1. FINAL_HMC_Medical Elections.xlsx
          88 kB
        11. 1. FINAL_HMC Medical Verification_UPDATED 5.15.17.xlsx
          179 kB
        12. 1. FINAL_Hospital Business Services Inc Medical Verification.xlsx
          775 kB
        13. 1. FINAL_Hospital Business Services Inc Medical Verification (1)_UPDATED 4.26.17.xlsx
          779 kB
        14. 1. FINAL_Hospitality Medical Verification_UPDATED 5.19.xlsx
          17 kB
        15. 1. FINAL_Hospitality Medical Verification.xlsx
          19 kB
        16. 1. FINAL_KMC_Knapp Medical Center Medical Verification_UPDATED 5.15.2017.xlsx
          145 kB
        17. 1. FINAL_KMC_Knapp Medical Center Medical Verification.xlsx
          40 kB
        18. 1. FINAL_MHIN_Monroe Hospital Medical Verification.xlsx
          31 kB
        19. 1. FINAL_Montclair Hospital Medical Verification_UPDATED 4.26.17.xlsx
          792 kB
        20. 1. FINAL_Montclair Hospital Medical Verification.xlsx
          784 kB
        21. 1. FINAL_Paradise Valley Hospital Medical Enrollment Clean up report from EBS 4-20-17.xlsx
          842 kB
        22. 1. FINAL_Paradise Valley Hospital Medical Verification_UPDATED 4.26.17.xlsx
          859 kB
        23. 1. FINAL_PMC_Pampa Medical Center Medical Verification_without ssns (003)_5.22.2017.xlsx
          21 kB
        24. 1. FINAL_PMC_Pampa Medical Center Medical Verification_without ssns (003).xlsx
          28 kB
        25. 1. FINAL_Prime Management Medical Verification_UPDATED 4.26.17.xlsx
          43 kB
        26. 1. FINAL_Prime Management Medical Verification.xlsx
          786 kB
        27. 1. FINAL_Saint Marys Medical Group Medical Verification.xlsx
          799 kB
        28. 1. FINAL_Saint Marys Regional Medical Center Medical Verification_UPDATED 5.22.2017.xlsx
          776 kB
        29. 1. FINAL_Saint Marys Regional Medical Center Medical Verification_without ssns.xlsx
          817 kB
        30. 1. FINAL_San Dimas Community Hospital Medical Verification_UPDATED 4.26.17.xlsx
          1.28 MB
        31. 1. FINAL_San Dimas Community Hospital Medical Verification_without ssns.xlsx
          796 kB
        32. 1. FINAL_Sherman Oaks Hospital Medical Verification.xls
          1.81 MB
        33. 1. FINAL_SRMC_Shasta Regional Medical Center Medical Verification_UPDATED 4.26.17.xlsx
          77 kB
        34. 1. FINAL_SRMC_Shasta Regional Medical Center Medical Verification_without ssns.xlsx
          57 kB
        35. FINAL_Saint Marys Medical Group Medical Verification_UPDATED 5.22.2017.xlsx
          19 kB
        36. screenshot-1.png
          screenshot-1.png
          217 kB
        37. screenshot-2.png
          screenshot-2.png
          84 kB
        38. Updated_5.9.2017_FINAL_CHMC_Centinela Hospital Medical Center Medical Verification (1).xlsx
          96 kB
        39. WT_9121_Employee_List.xls
          2.40 MB

          Issue Links

            Activity

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

            Hello Suraj Sokasane,

            Please find the final facilities listed for Development to provide updates:

            • Saint Marys Regional Medical Center_UPDATED 5.22.2017
            • Saint Marys Medical Group_UPDATED 5.22.2017
            • Pampa Medical Center_5.22.2017
            • Hospitality_UPDATED 5.19

            The password will be sent to you separately.

            Thank you.

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - - edited Hello Suraj Sokasane , Please find the final facilities listed for Development to provide updates: Saint Marys Regional Medical Center_UPDATED 5.22.2017 Saint Marys Medical Group_UPDATED 5.22.2017 Pampa Medical Center_5.22.2017 Hospitality_UPDATED 5.19 The password will be sent to you separately. Thank you. Amber
            Hide
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - - edited

            Hi Amber Love-Jones,

            Our EDI team has completed the Imports. Saint Marys Regional Medical Center and Saint Marys Medical Group were imported together. There were very less number of bad records. We'll mail you the details and the bad files through Email.

            Thanks.

            ----------------------------------------------
            CC- Jaideep Vinchurkar Nandkumar Prabhakar Karlekar, Mandar Kulkarni

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - - edited Hi Amber Love-Jones , Our EDI team has completed the Imports. Saint Marys Regional Medical Center and Saint Marys Medical Group were imported together. There were very less number of bad records. We'll mail you the details and the bad files through Email. Thanks. ---------------------------------------------- CC- Jaideep Vinchurkar Nandkumar Prabhakar Karlekar , Mandar Kulkarni
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Suraj Sokasane,

            I reviewed the bad files you sent over for Hospitality, PMC and Prime Healthcare. Nothing needs to be done with them:

            • Hospitality - 4 employees were terminated in 2015 and 2016. Employee George Bikouvanis was already enrolled in the EPO1 Plan before he was termed in 2/2017
            • PMC - I manually enrolled employee Kristie Bai in the Waive Medical Plan effective 1/1/2017
            • St Marys Medical Group (Under Prime_Healthcare) had one employee on the bad file. Employee Deanna Brown was only employed for 6 days, so she was not enrolled in any medical plan.

            I reviewed the ticket messages above and do not see any other open questions.. Please confirm that all facilities have been updated and nothing additional is needed from me. Once this has been done, please begin working on WT-8076 to re-run the ACA reports for January, February, March and April, 2017.

            Thank you.

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Suraj Sokasane , I reviewed the bad files you sent over for Hospitality, PMC and Prime Healthcare. Nothing needs to be done with them: Hospitality - 4 employees were terminated in 2015 and 2016. Employee George Bikouvanis was already enrolled in the EPO1 Plan before he was termed in 2/2017 PMC - I manually enrolled employee Kristie Bai in the Waive Medical Plan effective 1/1/2017 St Marys Medical Group (Under Prime_Healthcare) had one employee on the bad file. Employee Deanna Brown was only employed for 6 days, so she was not enrolled in any medical plan. I reviewed the ticket messages above and do not see any other open questions.. Please confirm that all facilities have been updated and nothing additional is needed from me. Once this has been done, please begin working on WT-8076 to re-run the ACA reports for January, February, March and April, 2017. Thank you. Amber
            Hide
            suraj.sokasane Suraj Sokasane (Inactive) added a comment -

            Hi Nandkumar Prabhakar Karlekar

            We have completed the Imports. You can proceed with ACA reports.

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - Hi Nandkumar Prabhakar Karlekar We have completed the Imports. You can proceed with ACA reports.
            Hide
            jjsassy99 Jennifer Johnson (Inactive) added a comment -

            All have been completed and ACA files have been sent for review -

            Show
            jjsassy99 Jennifer Johnson (Inactive) added a comment - All have been completed and ACA files have been sent for review -

              People

              Assignee:
              nandkumar Nandkumar Prabhakar Karlekar (Inactive)
              Reporter:
              Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 72h
                  72h