WORKTERRAProject Type: software

WORKTERRA

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

          causes

          Analysis - Analysis WT-12813 Prime Healthcare: EDI Test Terming Benefits

          • Critical - This problem will block progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            Permalink
            jyoti.mayne Jyoti Mayne logged work - 10/Apr/17 03:09 PM
            • Time Spent:
              0.25h
               

              discussion with Umesh and script review

            Permalink
            umesh.kadam Umesh Kadam (Inactive) logged work - 10/Apr/17 04:30 PM
            • Time Spent:
              4h
               

              Generic Script preparation
              Script review
              data validation
              shared list for given companies

            Permalink
            umesh.kadam Umesh Kadam (Inactive) logged work - 11/Apr/17 04:30 PM
            • Time Spent:
              0.5h
               

              Analysis
              Shared list of employees

            Permalink
            jyoti.mayne Jyoti Mayne logged work - 26/Apr/17 07:17 AM
            • Time Spent:
              0.25h
               

              discussion

            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 27/Apr/17 02:25 PM
            • Time Spent:
              0.5h
               
              <No comment>
            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 28/Apr/17 07:21 AM
            • Time Spent:
              1h
               
              <No comment>
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 28/Apr/17 01:14 PM
            • Time Spent:
              2h
               

              converting the files, Discussion with Nandu and analysis of data in files.

            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 28/Apr/17 02:47 PM
            • Time Spent:
              0.5h
               

              discussion

            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 02/May/17 12:32 PM
            • Time Spent:
              6h
               
              <No comment>
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 03/May/17 01:05 PM
            • Time Spent:
              1.5h
               

              File Analysis.

            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 05/May/17 12:36 PM
            • Time Spent:
              6.5h
               
              <No comment>
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 09/May/17 03:31 PM
            • Time Spent:
              7h
               

              Creating the data files, customization, import and data analysis.

            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 10/May/17 12:43 PM
            • Time Spent:
              2h
               
              <No comment>
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 11/May/17 03:27 PM - edited
            • Time Spent:
              3h
               

              Correction

            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 12/May/17 07:12 AM - edited
            • Time Spent:
              5.5h
               

              Discussion with Pallavi, Jaideep, Hrishikesh.
              Data correction.

            Permalink
            Pallavi.kulkarni Pallavi Kulkarni (Inactive) logged work - 12/May/17 05:16 PM
            • Time Spent:
              6h
               

              Importing files for AH,EHMC & SRMC HSPL,verifying the bad records for the same.
              Importing same file on main companies.
              Creating import file for CHMC,Verifying same for HSPL
              Discussion with Suraj

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

              importing files on AH , EHMC
              -cloning templates
              -verifying bad records

              • on HSPL and on Main
            Permalink
            Pallavi.kulkarni Pallavi Kulkarni (Inactive) logged work - 16/May/17 05:12 PM
            • Time Spent:
              6h
               

              Importing bad file on for AH,CHMC,EHMC & SRMC HSPL,verifying the bad records for the same.
              Importing same file on main companies.
              Creating import file for HMC & KMC
              Verifying on same for HSPL then on main
              Discussion with Suraj

            Permalink
            Pallavi.kulkarni Pallavi Kulkarni (Inactive) logged work - 18/May/17 06:00 PM
            • Time Spent:
              2h
               

              Verifying on HSPL copy for EHMC and CHMC.

            Permalink
            Pallavi.kulkarni Pallavi Kulkarni (Inactive) logged work - 23/May/17 11:19 AM
            • Time Spent:
              4h
               

              Creating file for PMC
              Verifying on HSPL
              Importing file on Main comapnies

            Permalink
            Prajakta.belhe Prajakta Belhe (Inactive) logged work - 23/May/17 01:01 PM
            • Time Spent:
              5h
               

              Import files for Hospitality and Prime healthcare on HSPL and main companies

            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 23/May/17 04:26 PM - edited
            • Time Spent:
              2h
               

              Analysis and discussion with EDI team

            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 24/May/17 04:36 PM
            • Time Spent:
              0.5h
               

              final analysis

              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