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

City of Durham > HR Simplified COBRA > Custom Event > Dependents of Retirees Turning 65

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Export
    • Reported by:
      Support
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have
    • Sprint:
      WT Sprint 27
    • Severity:
      Simple

      Description

      Hello,
      We received a request from the client and broker to include a new custom event for COBRA.
      Note from the broker:

      I have confirmed that the loss of health coverage for dependents’ of retirees that are terminated from retiree coverage for the reason of age (Medicare eligibility at age 65) are eligible for a 36 month COBRA offer. The retiree is not eligible for an offer. Only the dependents are eligible.

      Linked to WT-8808

      Please provide WTS for production deployment so i can communicate to Client, Broker and Vendor.

      Thanks,
      Chris

        Attachments

        1. affectedFiles.txt
          0.4 kB
        2. Analysis of WT-8875.doc
          112 kB
        3. template-statues.png
          template-statues.png
          24 kB
        4. Test Scenarios_8875.xls
          16 kB

          Issue Links

            Activity

            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Hi Chris Ellenberger,

            Please go through our comments on above points.

            #1
            We will surely find the way out to handle Voluntary and involuntary termination types on new approach . To achieve it, can you please provide the requirement specs document for this COBRA file ?

            #2 & #3
            Yes, Divorce and OAD events were never captured on Old Approach. Those will get captured on New Approach if Events Builders are created for the same.

            Please let us know if we can help you further on this.

            CC:Vinayak Kulkarni Hrishikesh Deshpande

            Thanks & Regards,
            Aniruddha Dev

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Hi Chris Ellenberger , Please go through our comments on above points. #1 We will surely find the way out to handle Voluntary and involuntary termination types on new approach . To achieve it, can you please provide the requirement specs document for this COBRA file ? #2 & #3 Yes, Divorce and OAD events were never captured on Old Approach. Those will get captured on New Approach if Events Builders are created for the same. Please let us know if we can help you further on this. CC: Vinayak Kulkarni Hrishikesh Deshpande Thanks & Regards, Aniruddha Dev
            Hide
            Chris.ellenberger Chris Ellenberger added a comment -

            Hi Aniruddha Dev,

            I have finalized events and the new template. I matched the run date maintenance to a previous live file run date, but i am not getting all of the coverages for the participant that exported on the live file. Can you please check to see why they do not match?

            Live Template: PandA Group_Cobra Term
            -Latest file from 7/26/2017 exported medical, dental, vision and FSA for Samantha Quiser.

            New Template: PandA Group_Cobra Term_NEW
            -exported with matching previous run date maintenance but only one line for dental exported for Samantha Quiser.

            Thanks,
            Chris

            Show
            Chris.ellenberger Chris Ellenberger added a comment - Hi Aniruddha Dev , I have finalized events and the new template. I matched the run date maintenance to a previous live file run date, but i am not getting all of the coverages for the participant that exported on the live file. Can you please check to see why they do not match? Live Template: PandA Group_Cobra Term -Latest file from 7/26/2017 exported medical, dental, vision and FSA for Samantha Quiser. New Template: PandA Group_Cobra Term_NEW -exported with matching previous run date maintenance but only one line for dental exported for Samantha Quiser. Thanks, Chris
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - - edited

            Hi Chris Ellenberger,

            We could not look into this today due to other priority tasks . We will update you on this by Monday,(07/31/2017).

            CC:Hrishikesh Deshpande Vinayak Kulkarni

            Thanks & Regards,
            Aniruddha Dev

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - - edited Hi Chris Ellenberger , We could not look into this today due to other priority tasks . We will update you on this by Monday,(07/31/2017). CC: Hrishikesh Deshpande Vinayak Kulkarni Thanks & Regards, Aniruddha Dev
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Hi Chris Ellenberger

            In order to get all coverages for Participant on export file for 'COBRA Data' type templates 'Enrollment Is COBRA Write All Plans Records Indicator' needs to be mapped on each subtemplate (Employee ,Spouse and Child).

            Please add a dummy field on each subtemplate and map the mentioned indicator to it.
            We have verified this on City Of Durham Test company on Production for 'PandA Group_Cobra Term_NEW Template' records exported properly for employee 'Samantha Quiser'.

            Please let us know if we can help you further on this.

            CC:Hrishikesh Deshpande Vinayak Kulkarni

            Thanks & Regards,
            Aniruddha Dev

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Hi Chris Ellenberger In order to get all coverages for Participant on export file for 'COBRA Data' type templates ' Enrollment Is COBRA Write All Plans Records Indicator ' needs to be mapped on each subtemplate (Employee ,Spouse and Child). Please add a dummy field on each subtemplate and map the mentioned indicator to it. We have verified this on City Of Durham Test company on Production for 'PandA Group_Cobra Term_NEW Template' records exported properly for employee 'Samantha Quiser'. Please let us know if we can help you further on this. CC: Hrishikesh Deshpande Vinayak Kulkarni Thanks & Regards, Aniruddha Dev
            Hide
            Chris.ellenberger Chris Ellenberger added a comment -

            Thanks Aniruddha Dev.

            This template (PandA Group_Cobra Term_NEW) is now scheduled and will take over for the legacy file beginning Wednesday, 8/2/2017 and weekly on wednesdays going forward.

            Thanks,
            Chris

            cc Kevin Walker

            Show
            Chris.ellenberger Chris Ellenberger added a comment - Thanks Aniruddha Dev . This template (PandA Group_Cobra Term_NEW) is now scheduled and will take over for the legacy file beginning Wednesday, 8/2/2017 and weekly on wednesdays going forward. Thanks, Chris cc Kevin Walker

              People

              Assignee:
              Chris.ellenberger Chris Ellenberger
              Reporter:
              Chris.ellenberger Chris Ellenberger
              Account Executive:
              Kevin Walker (Inactive)
              EDI Analyst 1:
              Chris Ellenberger
              Developer:
              Vinayak Kulkarni (Inactive)
              QA:
              Chris Ellenberger
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 56h Original Estimate - 56h
                  56h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 77h
                  77h