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

Prime_Healthcare: Hospital Business Services COBRA Notice

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Production
    • Module:
      BenAdmin - Export
    • Reported by:
      Client
    • Company:
      Prime Healthcare
    • Item State:
      Production Complete

      Description

      Hello,

      HR Simplified confirmed that a notification to send a COBRA packet was sent for overage dependent Cailynn Shields. This is a dependent of Hospital Business Services employee Janice Johnson (EEID 13307). The overage dependent turned 26 in October of 2016, and is showing on the HR Simplified file as being eligible for the EPO Medical Plan. The employee is not enrolled in any medical plans - she has the Waive Opt Out Medical Plan.

      Please research why this record transmitted over to HR Simplified.

      Thank you.

        Attachments

        1. AffectedFiles.txt
          0.4 kB
        2. Macro Details.xls
          10 kB
        3. screenshot-1.png
          screenshot-1.png
          11 kB
        4. screenshot-2.png
          screenshot-2.png
          30 kB
        5. View Enrollment Summary.png
          View Enrollment Summary.png
          17 kB
        6. Waive_medical.png
          Waive_medical.png
          12 kB

          Issue Links

            Activity

            Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 21/Dec/16 01:30 PM - edited
            • Time Spent:
              4h
               

              1) Checked logic of fetch cobra reason
              2) Checked logic processing member
              3) Verified template customization
              4) Checked enrollment and coverage data

            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 22/Dec/16 01:22 PM
            • Time Spent:
              6h
               
              <No comment>
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 03/Jan/17 01:34 PM
            • Time Spent:
              4.5h
               

              1) Discussion with team for approach
              2) Analysis
              3) Checked event builder implementation

            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 03/Jan/17 02:03 PM
            • Time Spent:
              1h
               
              <No comment>
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 09/Jan/17 01:42 PM
            • Time Spent:
              2h
               
              <No comment>
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 17/Jan/17 01:36 PM - edited
            • Time Spent:
              2.75h
               
              <No comment>
            rajendra.pawar Rajendra Pawar (Inactive) logged work - 19/Jan/17 08:44 AM
            • Time Spent:
              0.75h
               
              <No comment>
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 19/Jan/17 09:39 AM - edited
            • Time Spent:
              0.75h
               

              Discussion

            rohan.khandave Rohan J Khandave (Inactive) logged work - 19/Jan/17 12:51 PM
            • Time Spent:
              1h
               
              <No comment>
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 19/Jan/17 01:00 PM
            • Time Spent:
              0.75h
               

              Design team meeting

            saurabh.sablaka Saurabh Sablaka (Inactive) logged work - 19/Jan/17 01:46 PM
            • Time Spent:
              0.75h
               

              Design team meeting - COBRA logic on Export feeds

            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 19/Jan/17 03:12 PM
            • Time Spent:
              1h
               
              <No comment>
            rakesh.shahane Rakesh Shahane (Inactive) logged work - 19/Jan/17 05:53 PM
            • Time Spent:
              0.75h
               
              <No comment>
            sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 19/Jan/17 08:52 PM
            • Time Spent:
              0.5h
               

              design team meeting

            Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 23/Jan/17 02:12 PM
            • Time Spent:
              2h
               

              1) fetched additional field column list for cobra events.

            Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 02/Feb/17 02:23 PM
            • Time Spent:
              1h
               

              1) Get additional macro name and details.

            Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 09/Feb/17 02:38 PM
            • Time Spent:
              4h
               
              <No comment>
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 10/Feb/17 01:17 PM
            • Time Spent:
              1h
               
              <No comment>
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 10/Feb/17 02:29 PM
            • Time Spent:
              2.5h
               

              1) Modified logic in store procedure.
              2) Internal Discussion.

            rakesh.shahane Rakesh Shahane (Inactive) logged work - 15/Feb/17 01:32 PM
            • Time Spent:
              4h 5m
               
              <No comment>
            rakesh.shahane Rakesh Shahane (Inactive) logged work - 16/Feb/17 01:38 PM - edited
            • Time Spent:
              5.8h
               
              <No comment>
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 16/Feb/17 01:52 PM
            • Time Spent:
              1h
               
              <No comment>
            rakesh.shahane Rakesh Shahane (Inactive) logged work - 17/Feb/17 11:59 AM
            • Time Spent:
              4.8h
               
              <No comment>
            rakesh.shahane Rakesh Shahane (Inactive) logged work - 22/Feb/17 02:07 PM
            • Time Spent:
              6.5h
               
              <No comment>
            rakesh.shahane Rakesh Shahane (Inactive) logged work - 23/Feb/17 02:01 PM
            • Time Spent:
              6.4h
               
              <No comment>
            rakesh.shahane Rakesh Shahane (Inactive) logged work - 23/Feb/17 02:08 PM
            • Time Spent:
              0.4h
               
              <No comment>
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 23/Feb/17 02:48 PM
            • Time Spent:
              3h
               
              <No comment>
            Pallavi.kulkarni Pallavi Kulkarni (Inactive) logged work - 24/Feb/17 11:34 AM
            • Time Spent:
              2.5h
               

              COBRA File setup with Rakesh

            rakesh.shahane Rakesh Shahane (Inactive) logged work - 24/Feb/17 02:15 PM
            • Time Spent:
              6.2h
               
              <No comment>
            rakesh.shahane Rakesh Shahane (Inactive) logged work - 24/Feb/17 02:18 PM
            • Time Spent:
              40m
               
              <No comment>
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 24/Feb/17 03:13 PM
            • Time Spent:
              1h
               
              <No comment>
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 27/Feb/17 03:32 PM
            • Time Spent:
              1h
               
              <No comment>
            rakesh.shahane Rakesh Shahane (Inactive) logged work - 01/Mar/17 05:05 AM
            • Time Spent:
              20m
               
              <No comment>
            Prajakta.belhe Prajakta Belhe (Inactive) logged work - 01/Mar/17 06:39 PM
            • Time Spent:
              5h
               

              testing
              discussion with anirudha

            Prajakta.belhe Prajakta Belhe (Inactive) logged work - 02/Mar/17 06:50 PM
            • Time Spent:
              4h
               

              testing
              discussion with anirudha

            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 06/Mar/17 01:20 PM
            • Time Spent:
              1h
               
              <No comment>
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 07/Mar/17 06:21 PM
            • Time Spent:
              2h
               

              Testing on LB

            rakesh.shahane Rakesh Shahane (Inactive) logged work - 08/Mar/17 01:20 PM
            • Time Spent:
              1.4h
               
              <No comment>
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 08/Mar/17 05:58 PM
            • Time Spent:
              1h
               

              Stage Testing

            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 10/Mar/17 01:21 PM
            • Time Spent:
              1h
               

              CDC script changes.

            rakesh.shahane Rakesh Shahane (Inactive) logged work - 14/Mar/17 12:43 PM
            • Time Spent:
              1h
               
              <No comment>

              People

              Assignee:
              alov Amber Love-Jones (Inactive)
              Reporter:
              alov Amber Love-Jones (Inactive)
              Account Executive:
              Amber Love-Jones (Inactive)
              Developer:
              Rakesh Shahane (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 30.25h Original Estimate - 30.25h
                  30.25h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 97h 5m
                  97h 5m