Uploaded image for project: 'Workterra BenAdmin'
  1. Workterra BenAdmin
  2. WB-236

Saint Mary Regional Medical terms didn't transmit to HR Simplified COBRA

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Bug Fixed
    • Labels:
      None
    • Environment:
      Production
    • Categories:
      EDS
    • Company:
      Prime Healthcare
    • Reported by:
      EDI
    • Provider & Benefits:
      Vision VSP-Vision

      Description

      COBRA_P_EBSBenefits_Alecto_010920180223_230647628140.txt  Client: Prime Healthcare
      Facility: Saint Mary Regional Medical Center
      Group Template:
      Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group
      Prime Healthcare_NEW HR Simplified COBRA Participant_Group
      Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group
      Company Template affected:
      NEW HRSimplified_COBRA Coverage
      NEW HR Simplified COBRA Participant
      NEW HR Simplified COBRA DEPENDENT
      Export date: November and December 2017
      Export date example: 12/4/17, 12/19/2017
      Example affected: Christina Abina (terminated/per diem)

      Hello Vinayak Kulkarni,

      The carrier provided us a list of Saint Mary employees who's coverage were terminated but never went over on the HR Simplified COBRA files. There's many for the month of November and December. I didn't see Christina Abina on any of the files between 12/4/17 - 12/28/17. She had Medical, VSP vision, and Delta Dental terminated effective 12/31/17.

      Please see attachment with list of employees provided by the carrier. I took a quick look at the company templates and can see the facility, status, and plans are correctly selected. Not sure why many aren't coming over St Mary Employees.xlsx on the file.

      Thank you,

      Alex

      CC: Amit Thorve Amber Love-Jones

       

      Adding all COBRA files requested to be sent associated with this Bug. 

      Files are being attached to this ticket.

      In Jan 2018
      St Rose
      WNJ
      HMC
      Prime HealthCare
      PrimeHealthCare
      EHMC
      Hallmark Aviation Services
      KMC
      MHIN
      SRMC
      Karma
      El Camino
      Symphony
      PMC

       

      March 2018
      St Rose
      Prime Healthcare
      MHIN
      Karma
      City of Bellevue

        Attachments

        1. AlectoHealthcareCoverage-St Rose201801110333.txt
          1.0 kB
        2. AlectoHealthcareCoverage-St Rose201803260326.txt
          0.2 kB
        3. AlectoHealthcareDependent-St Rose201801110333.txt
          0.7 kB
        4. AlectoHealthcareDependent-St Rose201803260325.txt
          0.1 kB
        5. AlectoHealthcareParticipant-St Rose201801110333.txt
          1 kB
        6. AlectoHealthcareParticipant-St Rose201803260323.txt
          0.3 kB
        7. COBRA_P_EBSBenefits_Alecto_010920180223_230647628140.txt
          8 kB
        8. COBRA_P_EBSBenefits_Alecto_010920180223_230647628140.txt
          8 kB
        9. COBRA_P_EBSBenefits_Alecto_011120181120.txt
          7 kB
        10. EBS_TERMS_COBRA010920180331.xls
          19 kB
        11. EBS_TERMS_COBRA03272018_Karma
          14 kB
        12. exported.jpg
          exported.jpg
          290 kB
        13. January 2018_Prime Healthcare.zip
          11 kB
        14. March 2018_Prime Healthcare.zip
          4 kB
        15. PrimeHealthCareCobra.zip
          8 kB
        16. Re Cobra file for missed records on Nexion.msg
          65 kB
        17. Re Export Feed List From 01 11 2018 8AM To 01 12 2018 8AM PST.msg
          224 kB
        18. St Mary Employees_Updated-Final.xls
          31 kB
        19. St Mary Employees.xlsx
          13 kB
        20. WARNING - ENCRYPTED ATTACHMENT NOT VIRUS SCANNED Cobra file for missed records on Nexion.msg
          64 kB
        21. WARNING - ENCRYPTED ATTACHMENT NOT VIRUS SCANNED Missing cobra records files.msg
          72 kB
        22. WB-236.xls
          18 kB
        23. WB-236 Issue.doc
          490 kB

          Issue Links

            Activity

            alexn Alex Nguyen created issue -
            alexn Alex Nguyen made changes -
            Field Original Value New Value
            Link This issue relates to EDI-2855 [ EDI-2855 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Rakesh Shahane [ rakesh.shahane ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 7.3h [ 26280 ]
            Worklog Id 99273 [ 99273 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Time Spent 7.3h [ 26280 ] 14.8h [ 53280 ]
            Worklog Id 99278 [ 99278 ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Time Spent 14.8h [ 53280 ] 17.8h [ 64080 ]
            Worklog Id 99368 [ 99368 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Assignee Rakesh Shahane [ rakesh.shahane ] Vinayak Kulkarni [ vinayak.kulkarni ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Attachment PrimeHealthCareCobra.zip [ 71301 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Module Parent values: BenAdmin(10100)Level 1 values: Export(10110) Parent values: BenAdmin(10100)Level 1 values: EDS(10108)
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Sheetal Bodhale [ sheetal.bodhale ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Attachment PrimeHealthCareCobra.zip [ 71301 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Attachment PrimeHealthCareCobra.zip [ 71303 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Time Spent 17.8h [ 64080 ] 19.8h [ 71280 ]
            Worklog Id 99398 [ 99398 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Time Spent 19.8h [ 71280 ] 23.8h [ 85680 ]
            Worklog Id 99400 [ 99400 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Time Spent 23.8h [ 85680 ] 31.6h [ 113760 ]
            Worklog Id 99511 [ 99511 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Time Spent 31.6h [ 113760 ] 39.6h [ 142560 ]
            Worklog Id 99512 [ 99512 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Time Spent 39.6h [ 142560 ] 44.1h [ 158760 ]
            Worklog Id 99513 [ 99513 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Time Spent 44.1h [ 158760 ] 48.1h [ 173160 ]
            Worklog Id 99654 [ 99654 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Link This issue relates to WT-13027 [ WT-13027 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Time Spent 48.1h [ 173160 ] 53.6h [ 192960 ]
            Worklog Id 99802 [ 99802 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Time Spent 53.6h [ 192960 ] 60.1h [ 216360 ]
            Worklog Id 99806 [ 99806 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Time Spent 60.1h [ 216360 ] 62.1h [ 223560 ]
            Worklog Id 100481 [ 100481 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Time Spent 62.1h [ 223560 ] 62.85h [ 226260 ]
            Worklog Id 100848 [ 100848 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Assignee Sheetal Bodhale [ sheetal.bodhale ] Swapnil Pandhare [ swapnil.pandhare ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Time Spent 62.85h [ 226260 ] 66.85h [ 240660 ]
            Worklog Id 101339 [ 101339 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Time Spent 66.85h [ 240660 ] 67.85h [ 244260 ]
            Worklog Id 101345 [ 101345 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Time Spent 67.85h [ 244260 ] 69.85h [ 251460 ]
            Worklog Id 101349 [ 101349 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Time Spent 69.85h [ 251460 ] 73.85h [ 265860 ]
            Worklog Id 102499 [ 102499 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Time Spent 73.85h [ 265860 ] 74.35h [ 267660 ]
            Worklog Id 104297 [ 104297 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Assignee Swapnil Pandhare [ swapnil.pandhare ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Issue Type Support Activity [ 10301 ] Bug [ 1 ]
            Status In Progress [ 3 ] Open [ 1 ]
            Support Task Type Customization [ 11204 ]
            Workflow WT_Support [ 60824 ] WT_Defects [ 64178 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Time Spent 74.35h [ 267660 ] 75.35h [ 271260 ]
            Worklog Id 105740 [ 105740 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: EDS(18481)
            Component/s BenAdmin [ 10000 ]
            Key WT-12928 WB-236
            Project WORKTERRA [ 10000 ] Workterra BenAdmin [ 11501 ]
            Workflow WT_Defects [ 64178 ] WB: Bugs Project Management Workflow [ 65030 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Workflow WB: Bugs Project Management Workflow [ 65030 ] 0803 Copy of WB: Bugs Project Management Workflow [ 65852 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Link This issue relates to WB-560 [ WB-560 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Time Spent 75.35h [ 271260 ] 76.85h [ 276660 ]
            Worklog Id 108661 [ 108661 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Link This issue relates to WB-560 [ WB-560 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Link This issue is duplicated by WB-560 [ WB-560 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Link This issue duplicates WB-560 [ WB-560 ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Rajendra Pawar [ rajendra.pawar ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Time Spent 76.85h [ 276660 ] 82.35h [ 296460 ]
            Worklog Id 108952 [ 108952 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            QA Swapnil Eksambekar [ swapnil.eksambekar ]
            QA Estimates 16
            Original Estimate 0h [ 0 ]
            satyap Satya made changes -
            Sprint WB - Sprint 45 [ 102 ]
            satyap Satya made changes -
            Link This issue duplicates WB-560 [ WB-560 ]
            satyap Satya made changes -
            Assignee Rajendra Pawar [ rajendra.pawar ] Niteen Surwase [ niteen.surwase ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Dev Due Date 22/Mar/2018
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Developer Niteen Surwase [ niteen.surwase ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Dev Estimates 8
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Time Spent 82.35h [ 296460 ] 87.85h [ 316260 ]
            Worklog Id 109297 [ 109297 ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Time Spent 87.85h [ 316260 ] 94.65h [ 340740 ]
            Worklog Id 109302 [ 109302 ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Worklog Id 109302 [ 109302 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Workflow 0803 Copy of WB: Bugs Project Management Workflow [ 65852 ] 2203 WB: Bugs Project Management Workflow [ 67046 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 94.65h [ 340740 ] 97.15h [ 349740 ]
            Worklog Id 109315 [ 109315 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Worklog Id 109315 [ 109315 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 97.15h [ 349740 ] 103.65h [ 373140 ]
            Worklog Id 109316 [ 109316 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 103.65h [ 373140 ] 105.15h [ 378540 ]
            Worklog Id 109429 [ 109429 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 105.15h [ 378540 ] 109.15h [ 392940 ]
            Worklog Id 109505 [ 109505 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Attachment WB-236.xls [ 75145 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Time Spent 109.15h [ 392940 ] 111.15h [ 400140 ]
            Worklog Id 109522 [ 109522 ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Time Spent 111.15h [ 400140 ] 117.15h [ 421740 ]
            Worklog Id 109558 [ 109558 ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Time Spent 117.15h [ 421740 ] 124.15h [ 446940 ]
            Worklog Id 109559 [ 109559 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 124.15h [ 446940 ] 129.15h [ 464940 ]
            Worklog Id 109562 [ 109562 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 129.15h [ 464940 ] 134.15h [ 482940 ]
            Worklog Id 109563 [ 109563 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 134.15h [ 482940 ] 139.15h [ 500940 ]
            Worklog Id 109564 [ 109564 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 139.15h [ 500940 ] 140.65h [ 506340 ]
            Worklog Id 109565 [ 109565 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 140.65h [ 506340 ] 144.15h [ 518940 ]
            Worklog Id 109573 [ 109573 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Worklog Id 109564 [ 109564 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 144.15h [ 518940 ] 145.15h [ 522540 ]
            Worklog Id 109576 [ 109576 ]
            Prajakta.belhe Prajakta Belhe (Inactive) made changes -
            Time Spent 145.15h [ 522540 ] 152.15h [ 547740 ]
            Worklog Id 109899 [ 109899 ]
            Prajakta.belhe Prajakta Belhe (Inactive) made changes -
            Time Spent 152.15h [ 547740 ] 154.15h [ 554940 ]
            Worklog Id 110103 [ 110103 ]
            Prajakta.belhe Prajakta Belhe (Inactive) made changes -
            Time Spent 154.15h [ 554940 ] 158.15h [ 569340 ]
            Worklog Id 110109 [ 110109 ]
            Prajakta.belhe Prajakta Belhe (Inactive) made changes -
            Time Spent 158.15h [ 569340 ] 159.15h [ 572940 ]
            Worklog Id 110109 [ 110109 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Description *Client:* Prime Healthcare
            *Facility:* Saint Mary Regional Medical Center
            *Group Template:*
            Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group
            Prime Healthcare_NEW HR Simplified COBRA Participant_Group
            Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group
            *Company Template affected:*
            NEW HRSimplified_COBRA Coverage
            NEW HR Simplified COBRA Participant
            NEW HR Simplified COBRA DEPENDENT
            *Export date:* November and December 2017
            *Export date example:* 12/4/17, 12/19/2017
            *Example affected:* Christina Abina (terminated/per diem)

            Hello [~Vinayak.Kulkarni],

            The carrier provided us a list of Saint Mary employees who's coverage were terminated but never went over on the HR Simplified COBRA files. There's many for the month of November and December. I didn't see Christina Abina on any of the files between 12/4/17 - 12/28/17. She had Medical, VSP vision, and Delta Dental terminated effective 12/31/17.

            Please see attachment with list of employees provided by the carrier. I took a quick look at the company templates and can see the facility, status, and plans are correctly selected. Not sure why many aren't coming over [^St Mary Employees.xlsx] on the file.

            Thank you,

            Alex

            CC: [~amitthorve] [~alov]
             *Client:* Prime Healthcare
             *Facility:* Saint Mary Regional Medical Center
             *Group Template:*
             Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group
             Prime Healthcare_NEW HR Simplified COBRA Participant_Group
             Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group
             *Company Template affected:*
             NEW HRSimplified_COBRA Coverage
             NEW HR Simplified COBRA Participant
             NEW HR Simplified COBRA DEPENDENT
             *Export date:* November and December 2017
             *Export date example:* 12/4/17, 12/19/2017
             *Example affected:* Christina Abina (terminated/per diem)

            Hello [~Vinayak.Kulkarni],

            The carrier provided us a list of Saint Mary employees who's coverage were terminated but never went over on the HR Simplified COBRA files. There's many for the month of November and December. I didn't see Christina Abina on any of the files between 12/4/17 - 12/28/17. She had Medical, VSP vision, and Delta Dental terminated effective 12/31/17.

            Please see attachment with list of employees provided by the carrier. I took a quick look at the company templates and can see the facility, status, and plans are correctly selected. Not sure why many aren't coming over [^St Mary Employees.xlsx] on the file.

            Thank you,

            Alex

            CC: [~amitthorve] [~alov]
            satyap Satya made changes -
            Sprint WB - Sprint 45 [ 102 ] WB - Sprint 46 [ 104 ]
            satyap Satya made changes -
            Rank Ranked lower
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Dev Due Date 22/Mar/2018 06/Apr/2018
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 159.15h [ 572940 ] 160.65h [ 578340 ]
            Worklog Id 111291 [ 111291 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Time Spent 160.65h [ 578340 ] 162.65h [ 585540 ]
            Worklog Id 111295 [ 111295 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 162.65h [ 585540 ] 164.15h [ 590940 ]
            Worklog Id 111409 [ 111409 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 164.15h [ 590940 ] 171.15h [ 616140 ]
            Worklog Id 111542 [ 111542 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Workflow 2203 WB: Bugs Project Management Workflow [ 67046 ] 0604 Issues Management Workflow [ 68204 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 171.15h [ 616140 ] 176.65h [ 635940 ]
            Worklog Id 111693 [ 111693 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Status In Development [ 10007 ] In Analysis [ 10008 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Dev Due Date 06/Apr/2018 10/Apr/2018
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 176.65h [ 635940 ] 179.65h [ 646740 ]
            Worklog Id 111770 [ 111770 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 179.65h [ 646740 ] 188.15h [ 677340 ]
            Worklog Id 112170 [ 112170 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 188.15h [ 677340 ] 196.15h [ 706140 ]
            Worklog Id 112171 [ 112171 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Worklog Id 112170 [ 112170 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 196.15h [ 706140 ] 198.65h [ 715140 ]
            Worklog Id 112172 [ 112172 ]
            alexn Alex Nguyen made changes -
            Attachment January 2018_Prime Healthcare.zip [ 76245 ]
            alexn Alex Nguyen made changes -
            Attachment March 2018_Prime Healthcare.zip [ 76246 ]
            Cindy.Wibbing Cindy Wibbing (Inactive) made changes -
            Link This issue is blocked by EDI-3113 [ EDI-3113 ]
            Cindy.Wibbing Cindy Wibbing (Inactive) made changes -
            Attachment EBS_TERMS_COBRA010920180331.xls [ 76251 ]
            Cindy.Wibbing Cindy Wibbing (Inactive) made changes -
            Attachment EBS_TERMS_COBRA03272018_Karma [ 76252 ]
            Cindy.Wibbing Cindy Wibbing (Inactive) made changes -
            Description  *Client:* Prime Healthcare
             *Facility:* Saint Mary Regional Medical Center
             *Group Template:*
             Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group
             Prime Healthcare_NEW HR Simplified COBRA Participant_Group
             Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group
             *Company Template affected:*
             NEW HRSimplified_COBRA Coverage
             NEW HR Simplified COBRA Participant
             NEW HR Simplified COBRA DEPENDENT
             *Export date:* November and December 2017
             *Export date example:* 12/4/17, 12/19/2017
             *Example affected:* Christina Abina (terminated/per diem)

            Hello [~Vinayak.Kulkarni],

            The carrier provided us a list of Saint Mary employees who's coverage were terminated but never went over on the HR Simplified COBRA files. There's many for the month of November and December. I didn't see Christina Abina on any of the files between 12/4/17 - 12/28/17. She had Medical, VSP vision, and Delta Dental terminated effective 12/31/17.

            Please see attachment with list of employees provided by the carrier. I took a quick look at the company templates and can see the facility, status, and plans are correctly selected. Not sure why many aren't coming over [^St Mary Employees.xlsx] on the file.

            Thank you,

            Alex

            CC: [~amitthorve] [~alov]
             *Client:* Prime Healthcare
             *Facility:* Saint Mary Regional Medical Center
             *Group Template:*
             Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group
             Prime Healthcare_NEW HR Simplified COBRA Participant_Group
             Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group
             *Company Template affected:*
             NEW HRSimplified_COBRA Coverage
             NEW HR Simplified COBRA Participant
             NEW HR Simplified COBRA DEPENDENT
             *Export date:* November and December 2017
             *Export date example:* 12/4/17, 12/19/2017
             *Example affected:* Christina Abina (terminated/per diem)

            Hello [~Vinayak.Kulkarni],

            The carrier provided us a list of Saint Mary employees who's coverage were terminated but never went over on the HR Simplified COBRA files. There's many for the month of November and December. I didn't see Christina Abina on any of the files between 12/4/17 - 12/28/17. She had Medical, VSP vision, and Delta Dental terminated effective 12/31/17.

            Please see attachment with list of employees provided by the carrier. I took a quick look at the company templates and can see the facility, status, and plans are correctly selected. Not sure why many aren't coming over [^St Mary Employees.xlsx] on the file.

            Thank you,

            Alex

            CC: [~amitthorve] [~alov]

             

            Adding all COBRA files requested to be sent associated with this Bug. 

            Files are being attached to this ticket.

            *{color:#333333}In Jan 2018{color}*{color:#333333}
             St Rose
             WNJ
             HMC
             Prime HealthCare
             PrimeHealthCare
             EHMC
             Hallmark Aviation Services
             KMC
             MHIN
             SRMC
             Karma
             El Camino
             Symphony
             PMC{color}

            {color:#333333} {color}

            *{color:#333333}March 2018{color}*{color:#333333}
             St Rose
             Prime Healthcare
             MHIN
             Karma
             City of Bellevue{color}
            Rochelle.Thomas Rochelle Thomas made changes -
            Rochelle.Thomas Rochelle Thomas made changes -
            Rochelle.Thomas Rochelle Thomas made changes -
            Rochelle.Thomas Rochelle Thomas made changes -
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 198.65h [ 715140 ] 200.65h [ 722340 ]
            Worklog Id 112348 [ 112348 ]
            Rochelle.Thomas Rochelle Thomas made changes -
            Rochelle.Thomas Rochelle Thomas made changes -
            Rochelle.Thomas Rochelle Thomas made changes -
            Rochelle.Thomas Rochelle Thomas made changes -
            Rochelle.Thomas Rochelle Thomas made changes -
            Rochelle.Thomas Rochelle Thomas made changes -
            Description  *Client:* Prime Healthcare
             *Facility:* Saint Mary Regional Medical Center
             *Group Template:*
             Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group
             Prime Healthcare_NEW HR Simplified COBRA Participant_Group
             Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group
             *Company Template affected:*
             NEW HRSimplified_COBRA Coverage
             NEW HR Simplified COBRA Participant
             NEW HR Simplified COBRA DEPENDENT
             *Export date:* November and December 2017
             *Export date example:* 12/4/17, 12/19/2017
             *Example affected:* Christina Abina (terminated/per diem)

            Hello [~Vinayak.Kulkarni],

            The carrier provided us a list of Saint Mary employees who's coverage were terminated but never went over on the HR Simplified COBRA files. There's many for the month of November and December. I didn't see Christina Abina on any of the files between 12/4/17 - 12/28/17. She had Medical, VSP vision, and Delta Dental terminated effective 12/31/17.

            Please see attachment with list of employees provided by the carrier. I took a quick look at the company templates and can see the facility, status, and plans are correctly selected. Not sure why many aren't coming over [^St Mary Employees.xlsx] on the file.

            Thank you,

            Alex

            CC: [~amitthorve] [~alov]

             

            Adding all COBRA files requested to be sent associated with this Bug. 

            Files are being attached to this ticket.

            *{color:#333333}In Jan 2018{color}*{color:#333333}
             St Rose
             WNJ
             HMC
             Prime HealthCare
             PrimeHealthCare
             EHMC
             Hallmark Aviation Services
             KMC
             MHIN
             SRMC
             Karma
             El Camino
             Symphony
             PMC{color}

            {color:#333333} {color}

            *{color:#333333}March 2018{color}*{color:#333333}
             St Rose
             Prime Healthcare
             MHIN
             Karma
             City of Bellevue{color}
             [^COBRA_P_EBSBenefits_Alecto_010920180223_230647628140.txt]  *Client:* Prime Healthcare
             *Facility:* Saint Mary Regional Medical Center
             *Group Template:*
             Prime Healthcare_NEW HRSimplified_COBRA Coverage_Group
             Prime Healthcare_NEW HR Simplified COBRA Participant_Group
             Prime Healthcare_NEW HR Simplified COBRA DEPENDENT_Group
             *Company Template affected:*
             NEW HRSimplified_COBRA Coverage
             NEW HR Simplified COBRA Participant
             NEW HR Simplified COBRA DEPENDENT
             *Export date:* November and December 2017
             *Export date example:* 12/4/17, 12/19/2017
             *Example affected:* Christina Abina (terminated/per diem)

            Hello [~Vinayak.Kulkarni],

            The carrier provided us a list of Saint Mary employees who's coverage were terminated but never went over on the HR Simplified COBRA files. There's many for the month of November and December. I didn't see Christina Abina on any of the files between 12/4/17 - 12/28/17. She had Medical, VSP vision, and Delta Dental terminated effective 12/31/17.

            Please see attachment with list of employees provided by the carrier. I took a quick look at the company templates and can see the facility, status, and plans are correctly selected. Not sure why many aren't coming over [^St Mary Employees.xlsx] on the file.

            Thank you,

            Alex

            CC: [~amitthorve] [~alov]

             

            Adding all COBRA files requested to be sent associated with this Bug. 

            Files are being attached to this ticket.

            *{color:#333333}In Jan 2018{color}*{color:#333333}
             St Rose
             WNJ
             HMC
             Prime HealthCare
             PrimeHealthCare
             EHMC
             Hallmark Aviation Services
             KMC
             MHIN
             SRMC
             Karma
             El Camino
             Symphony
             PMC{color}

            {color:#333333} {color}

            *{color:#333333}March 2018{color}*{color:#333333}
             St Rose
             Prime Healthcare
             MHIN
             Karma
             City of Bellevue{color}
            Prashant.samal Prashant Samal (Inactive) made changes -
            Sprint WB - Sprint 46 [ 104 ] WB - Sprint 46, Carry Over from Sprint 46 [ 104, 113 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Rank Ranked higher
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 200.65h [ 722340 ] 202.65h [ 729540 ]
            Worklog Id 112529 [ 112529 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 202.65h [ 729540 ] 203.65h [ 733140 ]
            Worklog Id 112760 [ 112760 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 203.65h [ 733140 ] 207.65h [ 747540 ]
            Worklog Id 113018 [ 113018 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 207.65h [ 747540 ] 211.15h [ 760140 ]
            Worklog Id 113213 [ 113213 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 211.15h [ 760140 ] 214.9h [ 773640 ]
            Worklog Id 113214 [ 113214 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 0.5h [ 1800 ]
            Time Spent 214.9h [ 773640 ] 214.4h [ 771840 ]
            Worklog Id 113213 [ 113213 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Remaining Estimate 0.5h [ 1800 ] 0h [ 0 ]
            Time Spent 214.4h [ 771840 ] 216.4h [ 779040 ]
            Worklog Id 113233 [ 113233 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Time Spent 216.4h [ 779040 ] 216.9h [ 780840 ]
            Worklog Id 113234 [ 113234 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 216.9h [ 780840 ] 219.4h [ 789840 ]
            Worklog Id 113867 [ 113867 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 219.4h [ 789840 ] 222.65h [ 801540 ]
            Worklog Id 113868 [ 113868 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Status In Analysis [ 10008 ] In Development [ 10007 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Status In Development [ 10007 ] LB Deployed [ 11600 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Status LB Deployed [ 11600 ] In LB Testing [ 10200 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Status In LB Testing [ 10200 ] Ready for Pre-Prod [ 11615 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Status Ready for Pre-Prod [ 11615 ] Pre-Prod Deployed [ 11601 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Status Pre-Prod Deployed [ 11601 ] IN Pre-prod Testing [ 11500 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Status IN Pre-prod Testing [ 11500 ] Ready for Production [ 10024 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Status Ready for Production [ 10024 ] Production Deployed [ 10025 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Status Production Deployed [ 10025 ] In Production Testing [ 10202 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Resolution Cannot Reproduce [ 5 ]
            Status In Production Testing [ 10202 ] In Production Review [ 11501 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Attachment WB-236 Issue.doc [ 76992 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 222.65h [ 801540 ] 224.15h [ 806940 ]
            Worklog Id 114240 [ 114240 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Time Spent 224.15h [ 806940 ] 224.65h [ 808740 ]
            Worklog Id 114308 [ 114308 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Time Spent 224.65h [ 808740 ] 225.65h [ 812340 ]
            Worklog Id 114315 [ 114315 ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Link This issue is blocked by WB-1085 [ WB-1085 ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Link This issue is blocked by WB-1085 [ WB-1085 ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Link This issue is duplicated by WB-1085 [ WB-1085 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Resolution Cannot Reproduce [ 5 ] Unresolved [ 10200 ]
            Status In Production Review [ 11501 ] REOPENED IN PRODUCTION REVIEW [ 11605 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Status REOPENED IN PRODUCTION REVIEW [ 11605 ] In Development [ 10007 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 225.65h [ 812340 ] 233.65h [ 841140 ]
            Worklog Id 115481 [ 115481 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 233.65h [ 841140 ] 237.15h [ 853740 ]
            Worklog Id 115485 [ 115485 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Worklog Id 115485 [ 115485 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 237.15h [ 853740 ] 240.15h [ 864540 ]
            Worklog Id 115486 [ 115486 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Time Spent 240.15h [ 864540 ] 241.15h [ 868140 ]
            Worklog Id 115525 [ 115525 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Assignee Niteen Surwase [ niteen.surwase ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Status In Development [ 10007 ] LB Deployed [ 11600 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Status LB Deployed [ 11600 ] In LB Testing [ 10200 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Status In LB Testing [ 10200 ] Ready for Pre-Prod [ 11615 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Status Ready for Pre-Prod [ 11615 ] Pre-Prod Deployed [ 11601 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Status Pre-Prod Deployed [ 11601 ] IN Pre-prod Testing [ 11500 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Status IN Pre-prod Testing [ 11500 ] Ready for Production [ 10024 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Status Ready for Production [ 10024 ] Production Deployed [ 10025 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 241.15h [ 868140 ] 244.15h [ 878940 ]
            Worklog Id 115557 [ 115557 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Swapnil Eksambekar [ swapnil.eksambekar ]
            alexn Alex Nguyen made changes -
            Attachment exported.jpg [ 77742 ]
            alexn Alex Nguyen made changes -
            Time Spent 244.15h [ 878940 ] 244.65h [ 880740 ]
            Worklog Id 115623 [ 115623 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Status Production Deployed [ 10025 ] In Production Testing [ 10202 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Assignee Swapnil Eksambekar [ swapnil.eksambekar ] Alex Nguyen [ alexn ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Assignee Alex Nguyen [ alexn ] Swapnil Eksambekar [ swapnil.eksambekar ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Time Spent 244.65h [ 880740 ] 250.65h [ 902340 ]
            Worklog Id 115730 [ 115730 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 250.65h [ 902340 ] 251.65h [ 905940 ]
            Worklog Id 115731 [ 115731 ]
            amit.kumawat Amit Kumawat (Inactive) made changes -
            Time Spent 251.65h [ 905940 ] 255.65h [ 920340 ]
            Worklog Id 116088 [ 116088 ]
            amit.kumawat Amit Kumawat (Inactive) made changes -
            Time Spent 255.65h [ 920340 ] 256.65h [ 923940 ]
            Worklog Id 116089 [ 116089 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 256.65h [ 923940 ] 258.65h [ 931140 ]
            Worklog Id 116118 [ 116118 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 258.65h [ 931140 ] 266.65h [ 959940 ]
            Worklog Id 116119 [ 116119 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 266.65h [ 959940 ] 276.15h [ 994140 ]
            Worklog Id 116120 [ 116120 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Swapnil Eksambekar [ swapnil.eksambekar ] Vinayak Kulkarni [ vinayak.kulkarni ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Swapnil Eksambekar [ swapnil.eksambekar ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Time Spent 276.15h [ 994140 ] 278.15h [ 1001340 ]
            Worklog Id 117277 [ 117277 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Time Spent 278.15h [ 1001340 ] 283.15h [ 1019340 ]
            Worklog Id 117843 [ 117843 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Time Spent 283.15h [ 1019340 ] 288.65h [ 1039140 ]
            Worklog Id 117844 [ 117844 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Time Spent 288.65h [ 1039140 ] 290.65h [ 1046340 ]
            Worklog Id 117916 [ 117916 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Resolution Unresolved [ 10200 ] Bug Fixed [ 10402 ]
            Status In Production Testing [ 10202 ] In Production Review [ 11501 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Assignee Swapnil Eksambekar [ swapnil.eksambekar ] Alex Nguyen [ alexn ]
            alexn Alex Nguyen made changes -
            Status In Production Review [ 11501 ] Closed [ 6 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Sprint WB - Sprint 46 [ 104 ] WB - Sprint 46, WB - Sprint 50 [ 104, 116 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Rank Ranked higher
            Prashant.samal Prashant Samal (Inactive) made changes -
            Sprint WB - Sprint 46, WB - Sprint 50 [ 104, 116 ] WB - Sprint 46 [ 104 ]

              People

              Assignee:
              alexn Alex Nguyen
              Reporter:
              alexn Alex Nguyen
              Developer:
              Niteen Surwase (Inactive)
              QA:
              Swapnil Eksambekar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              18 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 290.65h
                  290.65h