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

            aniruddha.dev Aniruddha Dev (Inactive) created issue -
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-2008 [ WT-2008 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Description This is related to WT-2008

             It 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.
            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.
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Rajendra Pawar [ rajendra.pawar ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Dev Due Date 05/Aug/2016
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: In Progress(10206)
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Code Review Date 05/Aug/2016
            Code Reviewed By Vinalyak Kulkarni [ 12100 ]
            Developer Vinayak Kulkarni [ vinayak.kulkarni ] Rajendra Pawar [ rajendra.pawar ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Attachment Affected Files.txt [ 23378 ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            gokul.sonawane Gokul Sonawane (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Assignee Rajendra Pawar [ rajendra.pawar ] Aniruddha Dev [ aniruddha.dev ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            gokul.sonawane Gokul Sonawane (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            gokul.sonawane Gokul Sonawane (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Production Due Date 12/Aug/2016
            Stage Due Date 11/Aug/16 [ 2016-08-11 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Production Due Date 12/Aug/2016 16/Aug/2016
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Aniruddha Dev [ aniruddha.dev ] Jennifer Leugers [ jennifer.leugers ]
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]

              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: