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

            Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) created issue -
            rakeshr Rakesh Roy (Inactive) made changes -
            Field Original Value New Value
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107)
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Vijay Siddha [ vijays ] Jyoti Mayne [ jyoti.mayne ]
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Jyoti Mayne [ jyoti.mayne ] Umesh Kadam [ umesh.kadam ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Attachment WT-9121_Employee_List.xls [ 44902 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Assignee Umesh Kadam [ umesh.kadam ] Traci Simpson [ traci.simpson@ebsbenefits.com ]
            Resolution Done [ 10000 ]
            Status In Progress [ 3 ] Resolved [ 5 ]
            Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Closed [ 6 ] Reopened [ 4 ]
            Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) made changes -
            Assignee Traci Simpson [ traci.simpson@ebsbenefits.com ] Umesh Kadam [ umesh.kadam ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Status Reopened [ 4 ] In Progress [ 3 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Attachment WT-9121_Employee_List.xls [ 44902 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Attachment WT_9121_Employee_List.xls [ 44980 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Attachment WT_9121_Employee_List.xls [ 44980 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Attachment WT_9121_Employee_List.xls [ 44981 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Assignee Umesh Kadam [ umesh.kadam ] Traci Simpson [ traci.simpson@ebsbenefits.com ]
            Resolution Done [ 10000 ]
            Status In Progress [ 3 ] Resolved [ 5 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 0.5h [ 1800 ]
            Worklog Id 37477 [ 37477 ]
            Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) made changes -
            Assignee Traci Simpson [ traci.simpson@ebsbenefits.com ] Umesh Kadam [ umesh.kadam ]
            Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Resolved [ 5 ] Reopened [ 4 ]
            Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) made changes -
            Comment [ Password not received ]
            Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) made changes -
            Assignee Umesh Kadam [ umesh.kadam ] Traci Simpson [ traci.simpson@ebsbenefits.com ]
            Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Reopened [ 4 ] Resolved [ 5 ]
            Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            jyoti.mayne Jyoti Mayne made changes -
            Resolution Done [ 10000 ]
            Status Closed [ 6 ] Reopened [ 4 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 0.5h [ 1800 ] 0.75h [ 2700 ]
            Worklog Id 37811 [ 37811 ]
            jyoti.mayne Jyoti Mayne made changes -
            Resolution Fixed [ 1 ]
            Status Reopened [ 4 ] Closed [ 6 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Closed [ 6 ] Reopened [ 4 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Time Spent 0.75h [ 2700 ] 4.75h [ 17100 ]
            Worklog Id 37899 [ 37899 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Reopened [ 4 ] Closed [ 6 ]
            alov Amber Love-Jones (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Closed [ 6 ] Reopened [ 4 ]
            alov Amber Love-Jones (Inactive) made changes -
            Attachment 1. FINAL_AH_Alvarado Hospital Medical Verification.xlsx [ 46281 ]
            Attachment 1. FINAL_Chino Valley Medical Verification.xlsx [ 46282 ]
            Attachment 1. FINAL_CHMC_Centinela Hospital Medical Center Medical Verification.xlsx [ 46283 ]
            Attachment 1. FINAL_Desert Valley Medical Verification.xlsx [ 46284 ]
            Attachment 1. FINAL_EHMC_Encino Hospital Medical Center Medical Verification.xlsx [ 46285 ]
            Attachment 1. FINAL_HMC_Medical Elections.xlsx [ 46286 ]
            Attachment 1. FINAL_Hospital Business Services Inc Medical Verification.xlsx [ 46287 ]
            Attachment 1. FINAL_Hospitality Medical Verification.xlsx [ 46288 ]
            Attachment 1. FINAL_KMC_Knapp Medical Center Medical Verification.xlsx [ 46289 ]
            Attachment 1. FINAL_MHIN_Monroe Hospital Medical Verification.xlsx [ 46290 ]
            Attachment 1. FINAL_Montclair Hospital Medical Verification.xlsx [ 46291 ]
            Attachment 1. FINAL_Paradise Valley Hospital Medical Enrollment Clean up report from EBS 4-20-17.xlsx [ 46292 ]
            Attachment 1. FINAL_PMC_Pampa Medical Center Medical Verification_without ssns (003).xlsx [ 46293 ]
            Attachment 1. FINAL_Prime Management Medical Verification.xlsx [ 46294 ]
            Attachment 1. FINAL_Saint Marys Medical Group Medical Verification.xlsx [ 46295 ]
            Attachment 1. FINAL_Saint Marys Regional Medical Center Medical Verification_without ssns.xlsx [ 46296 ]
            Attachment 1. FINAL_San Dimas Community Hospital Medical Verification_without ssns.xlsx [ 46297 ]
            Attachment 1. FINAL_Sherman Oaks Hospital Medical Verification.xls [ 46298 ]
            Attachment 1. FINAL_SRMC_Shasta Regional Medical Center Medical Verification_without ssns.xlsx [ 46299 ]
            alov Amber Love-Jones (Inactive) made changes -
            Assignee Traci Simpson [ traci.simpson@ebsbenefits.com ] Umesh Kadam [ umesh.kadam ]
            alov Amber Love-Jones (Inactive) made changes -
            Priority Medium [ 3 ] High [ 2 ]
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Umesh Kadam [ umesh.kadam ] Nandkumar [ satyap ]
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Nandkumar [ satyap ] Vijay Siddha [ vijays ]
            jyoti.mayne Jyoti Mayne made changes -
            Module Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107) Parent values: ACA(10104)Level 1 values: 2017(12000)
            vijays Vijay Siddha (Inactive) made changes -
            Assignee Vijay Siddha [ vijays ] Nandkumar [ satyap ]
            satyap Satya made changes -
            Assignee Nandkumar [ satyap ] Satya [ ID10004 ]
            Status Reopened [ 4 ] In Progress [ 3 ]
            satyap Satya made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            satyap Satya made changes -
            Assignee Satya [ ID10004 ] Amber Love-Jones [ alov ]
            alov Amber Love-Jones (Inactive) made changes -
            Assignee Amber Love-Jones [ alov ] Satya [ ID10004 ]
            satyap Satya made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            satyap Satya made changes -
            Assignee Satya [ ID10004 ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Sachin Hingole [ sachin.hingole ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 4.75h [ 17100 ] 5h [ 18000 ]
            Worklog Id 41194 [ 41194 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 5h [ 18000 ] 5.5h [ 19800 ]
            Worklog Id 41496 [ 41496 ]
            vijays Vijay Siddha (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Suraj Sokasane [ suraj.sokasane ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Time Spent 5.5h [ 19800 ] 6.5h [ 23400 ]
            Worklog Id 41863 [ 41863 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 6.5h [ 23400 ] 8.5h [ 30600 ]
            Worklog Id 42421 [ 42421 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 8.5h [ 30600 ] 9h [ 32400 ]
            Worklog Id 42497 [ 42497 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Amber Love-Jones [ alov ]
            jjsassy99 Jennifer Johnson (Inactive) made changes -
            Assignee Amber Love-Jones [ alov ] Suraj Sokasane [ suraj.sokasane ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Amber Love-Jones [ alov ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 9h [ 32400 ] 10.5h [ 37800 ]
            Worklog Id 42931 [ 42931 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            alov Amber Love-Jones (Inactive) made changes -
            Assignee Amber Love-Jones [ alov ] Suraj Sokasane [ suraj.sokasane ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 10.5h [ 37800 ] 17.5h [ 63000 ]
            Worklog Id 44202 [ 44202 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Amber Love-Jones [ alov ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 17.5h [ 63000 ] 23.5h [ 84600 ]
            Worklog Id 44425 [ 44425 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 23.5h [ 84600 ] 30h [ 108000 ]
            Worklog Id 44429 [ 44429 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 30h [ 108000 ] 32h [ 115200 ]
            Worklog Id 44434 [ 44434 ]
            alov Amber Love-Jones (Inactive) made changes -
            Assignee Amber Love-Jones [ alov ] Suraj Sokasane [ suraj.sokasane ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 32h [ 115200 ] 35h [ 126000 ]
            Worklog Id 45331 [ 45331 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Worklog Id 45331 [ 45331 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Amber Love-Jones [ alov ]
            alov Amber Love-Jones (Inactive) made changes -
            Assignee Amber Love-Jones [ alov ] Suraj Sokasane [ suraj.sokasane ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Pallavi Kulkarni [ pallavi.kulkarni ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 35h [ 126000 ] 38.5h [ 138600 ]
            Worklog Id 45798 [ 45798 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 38.5h [ 138600 ] 40.5h [ 145800 ]
            Worklog Id 45798 [ 45798 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Worklog Id 45798 [ 45798 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Attachment screenshot-1.png [ 48335 ]
            Pallavi.kulkarni Pallavi Kulkarni (Inactive) made changes -
            Assignee Pallavi Kulkarni [ pallavi.kulkarni ] Suraj Sokasane [ suraj.sokasane ]
            Pallavi.kulkarni Pallavi Kulkarni (Inactive) made changes -
            Time Spent 40.5h [ 145800 ] 46.5h [ 167400 ]
            Worklog Id 46191 [ 46191 ]
            Pallavi.kulkarni Pallavi Kulkarni (Inactive) made changes -
            Time Spent 46.5h [ 167400 ] 52.5h [ 189000 ]
            Worklog Id 46193 [ 46193 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Amber Love-Jones [ alov ]
            alov Amber Love-Jones (Inactive) made changes -
            Attachment screenshot-2.png [ 48489 ]
            alov Amber Love-Jones (Inactive) made changes -
            Assignee Amber Love-Jones [ alov ] Suraj Sokasane [ suraj.sokasane ]
            Pallavi.kulkarni Pallavi Kulkarni (Inactive) made changes -
            Time Spent 52.5h [ 189000 ] 54.5h [ 196200 ]
            Worklog Id 46932 [ 46932 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 54.5h [ 196200 ] 60.5h [ 217800 ]
            Worklog Id 46942 [ 46942 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Pallavi Kulkarni [ pallavi.kulkarni ]
            alov Amber Love-Jones (Inactive) made changes -
            Assignee Pallavi Kulkarni [ pallavi.kulkarni ] Suraj Sokasane [ suraj.sokasane ]
            Pallavi.kulkarni Pallavi Kulkarni (Inactive) made changes -
            Time Spent 60.5h [ 217800 ] 64.5h [ 232200 ]
            Worklog Id 48372 [ 48372 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Nandkumar [ satyap ]
            Prajakta.belhe Prajakta Belhe (Inactive) made changes -
            Time Spent 64.5h [ 232200 ] 69.5h [ 250200 ]
            Worklog Id 48915 [ 48915 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 69.5h [ 250200 ] 70.5h [ 253800 ]
            Worklog Id 50718 [ 50718 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 70.5h [ 253800 ] 71.5h [ 257400 ]
            Worklog Id 50718 [ 50718 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 71.5h [ 257400 ] 72h [ 259200 ]
            Worklog Id 50737 [ 50737 ]
            jjsassy99 Jennifer Johnson (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            jjsassy99 Jennifer Johnson (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Link This issue causes WT-12813 [ WT-12813 ]

              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