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

Export > OAD getting exported as dependent if OAD and EE termination happen in different months

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Export
    • Reported by:
      Client
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      Hi all - how did you verify the OAD scenario? UHC is stating it still is not working. Please see below -

      I’ve tested this in FDU Prod and it looks like it is working under the Divorce scenario, however, the OAD scenario is still incorrect.

      The Par files and the COV files are pulling in the correct info, but the Dep file is still pulling in the terminated (already previously sent) overaged dependent on the second set of dependent termination files.

      I tested this in FDU Prod with Jenna Test (OAD) and Travis Test (Divorce).

      These are what we are expecting on these connections:

      First set of test files run after the dependent is terminated:

      Par file: Dep (OAD/Ex-Spouse) termination

      Dep file: blank

      COV file: the coverage for the family

      Second Set of Test files after the EE has terminated status:

      Par file: EE termination

      Dep file: the remaining dependents (if any) excluding the OAD or Exspouse (Currently Ex-Spouse is correctly being withheld, OAD’s are still being passed)

      COV file: the coverage for the EE and remaining dependents

      These are the file templates I used:

      Test_RA clone COBRA PAR Del after testing

      Test_RA Clone COBRA dep del aft testing

      Test RA Clone COBCOV med Del aft test

      For Jenna Test, She had a child (Baby Test) who turned 26 on 7/21/16. The OAD service ran and removed her coverage. The first set of COBRA files picked up the Baby correctly. Jenna then termed status on 8/2. On the second set of COBRA files, the Par and COV files pulled the correct information, however, the child was still passed on the Dep file.

      After high level analysis we found below

      This occurs only when OAD and OAD followed by EE Termination scenarios take place in different months (as in case of Jenna Test). Implementation works fine when OAD and Employee Termination happen in same month.

        Attachments

          Issue Links

            Activity

            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - - edited

            Jennifer Leugers
            Hi Jennifer,

            This is in progress and we would be done with fix by end of this week on our local environment, it would take end of next week to get this deployed on production.

            Thanks,
            Vinayak

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - - edited Jennifer Leugers Hi Jennifer, This is in progress and we would be done with fix by end of this week on our local environment, it would take end of next week to get this deployed on production. Thanks, Vinayak
            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Rajendra, Please check this.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Rajendra, Please check this.
            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Aniruddha,

            We need to regress all cobra scenario for this testing, major part of testing could be

            1] Employee Termination ( with Employee Only and with Dependents both)
            2] Divorce
            3] Employee Termination after Divorce ( in same month of divorce and in next month of divorce)
            4] OAD
            5] Employee Termination after OAD ( in same month of OAD and in next month of OAD)
            6] Employee Deceased

            And include various Cobra approaches as well like FDU COBRA, MATT QE, and Jamba Juice's Discovery Benefits.

            Let us know if you need more information on this.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Aniruddha, We need to regress all cobra scenario for this testing, major part of testing could be 1] Employee Termination ( with Employee Only and with Dependents both) 2] Divorce 3] Employee Termination after Divorce ( in same month of divorce and in next month of divorce) 4] OAD 5] Employee Termination after OAD ( in same month of OAD and in next month of OAD) 6] Employee Deceased And include various Cobra approaches as well like FDU COBRA, MATT QE, and Jamba Juice's Discovery Benefits. Let us know if you need more information on this.
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have started this testing on our Local Environment. We will complete this testing and move patch on Stage environment by Friday,08/12 and then on Production environment by Tuesday,08/16.

            Thanks,
            Hrishikesh.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Hi Jennifer Leugers , We have started this testing on our Local Environment. We will complete this testing and move patch on Stage environment by Friday,08/12 and then on Production environment by Tuesday,08/16. Thanks, Hrishikesh.
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Tested the fix on LB on FDU company with below scenarios

            1) Employee Termination (having EE, EE+SP, EE+SP+2ch coverage tiers)
            (Current Month Termination and Next Month Termination)

            2) Overage Dependent Scenario (having EE+2ch, EE+SP+ch, EE+SP+2ch coverage tiers)

            3) Overage Dependent followed by EE Termination (for #2 scenarios)
            (in same month, end of same month and in next month of OAD)

            4) Divorce (EE+sp, EE+SP+ch, EE+SP+2ch)

            5) Divorce followed by EE Termination (for #4 scenarios)
            (in same month and in next month of OAD)

            All above scenarios are working as expected on LB . This fix Ready for Stage deployment

            Note: Deceased Scenario is not implemented for COBRA notice Indicator. Will check COBRA scenarios for Matt and Jamba Juice on stage as these companies are not present on LB.

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Tested the fix on LB on FDU company with below scenarios 1) Employee Termination (having EE, EE+SP, EE+SP+2ch coverage tiers) (Current Month Termination and Next Month Termination) 2) Overage Dependent Scenario (having EE+2ch, EE+SP+ch, EE+SP+2ch coverage tiers) 3) Overage Dependent followed by EE Termination (for #2 scenarios) (in same month, end of same month and in next month of OAD) 4) Divorce (EE+sp, EE+SP+ch, EE+SP+2ch) 5) Divorce followed by EE Termination (for #4 scenarios) (in same month and in next month of OAD) All above scenarios are working as expected on LB . This fix Ready for Stage deployment Note : Deceased Scenario is not implemented for COBRA notice Indicator. Will check COBRA scenarios for Matt and Jamba Juice on stage as these companies are not present on LB.
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - - edited

            HI Jennifer Leugers,

            We have deployed and Tested the fix on Stage . Verified the scenarios on UHC COBRA Templates on FDU test company on stage with all above listed scenarios .

            Fix is working as expected on stage and it is Ready for Production. This will be moved to Production as per patch process on Tuesday (08/16/2016) , till then you can start testing on Stage FDU.

            Regards,
            Aniruddha Dev

            .

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - - edited HI Jennifer Leugers , We have deployed and Tested the fix on Stage . Verified the scenarios on UHC COBRA Templates on FDU test company on stage with all above listed scenarios . Fix is working as expected on stage and it is Ready for Production. This will be moved to Production as per patch process on Tuesday (08/16/2016) , till then you can start testing on Stage FDU. Regards, Aniruddha Dev .
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            Jennifer Leugers

            This fix has been deployed on Production and working as expected.

            Thanks,
            Hrishikesh.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Jennifer Leugers This fix has been deployed on Production and working as expected. Thanks, Hrishikesh.

              People

              Assignee:
              jennifer.leugers Jennifer Leugers
              Reporter:
              aniruddha.dev Aniruddha Dev (Inactive)
              Developer:
              Rajendra Pawar (Inactive)
              QA:
              Aniruddha Dev (Inactive)
              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: