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

EE Terms not Passing if EE term date equals end of policy year and new coverage for renewal #39 on log

    Details

    • Type: Enhancement
    • Status: Production Complete
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Export
    • Reported by:
      White Label
    • Item State:
      Production Complete - Closed

      Description

      Hi all - please below and original email attached.

      I looked everywhere and can’t locate an email identifying the issue. We first realized this was an issue with UVU this past July. Essentially the issue at hand will impact any employee whose termination date reflects the end of the Policy Year (e.g. December 31st) and either has been defaulted into new coverage and/or actively elected new coverage during their OE.

      The system wasn’t sending the employee termination as the OE term as never effective was trumping the employee termination. This impacted roughly 30 employees on UVU and would imagine a fair amount of exposure will be experienced this renewal if not corrected since the bulk of our business renews in January.

      Please let us know if this issue was ever resolved. If not, please provide an ETA on release.

        Attachments

          Activity

          jennifer.leugers Jennifer Leugers created issue -
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment -

          Rohan J Khandave
          More details:-
          Issue:-Employee terms during OE (ensure term date passes to carriers as needed – seen as never effective)
          EBS feedback:-This was discussed last year and was committed to being provided by OE 2016

          EBS requesting more info on this - these are employees whose termination date equal end of policy year. System is not recognizing those transactions as something that should pass and is not sending on any feeds.

          12/10 - Information required

          Latest update:- If not done please provide ETA

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Rohan J Khandave More details:- Issue:-Employee terms during OE (ensure term date passes to carriers as needed – seen as never effective) EBS feedback:-This was discussed last year and was committed to being provided by OE 2016 EBS requesting more info on this - these are employees whose termination date equal end of policy year. System is not recognizing those transactions as something that should pass and is not sending on any feeds. 12/10 - Information required Latest update:- If not done please provide ETA
          rakeshr Rakesh Roy (Inactive) made changes -
          Field Original Value New Value
          Assignee Satya [ ID10004 ] Rohan Khandave [ rohan.khandave ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Assignee Rohan Khandave [ rohan.khandave ] Vinayak Kulkarni [ vinayak.kulkarni ]
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment - - edited

          Vinayak Kulkarni]Please check and update.

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - - edited Vinayak Kulkarni ]Please check and update.
          Hide
          jennifer.leugers Jennifer Leugers added a comment -

          Hi all - please provide an update on this as my call with UHC is in a couple of hours.

          Show
          jennifer.leugers Jennifer Leugers added a comment - Hi all - please provide an update on this as my call with UHC is in a couple of hours.
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment - - edited

          Vinayak KulkarniRohan J KhandaveIs there any update on this?Please update if possible.

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - - edited Vinayak Kulkarni Rohan J Khandave Is there any update on this?Please update if possible.
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Hi Jennifer,

          We are analyzing this issue, there are some code changes required to solve this issue.
          Unfortunately, due to daily support tasks & other issues, We could not complete our analysis.

          So at this moment, We do not have ETA but we will provide rough estimates by end of Monday 22th Feb 2016.
          Please apologize for the inconvenience occurred.

          Thanks

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Jennifer, We are analyzing this issue, there are some code changes required to solve this issue. Unfortunately, due to daily support tasks & other issues, We could not complete our analysis. So at this moment, We do not have ETA but we will provide rough estimates by end of Monday 22th Feb 2016. Please apologize for the inconvenience occurred. Thanks
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment -

          Vinayak KulkarniPlease check.

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Vinayak Kulkarni Please check.
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Hi Jennifer,

          During analysis we got following query.

          Lets consider below example.
          An employee has medical election in plan P1 with Employee+Spouse+Child covered with effective date 01/01/2016.

          Child became ineligible from 03/01/2016. So Employee+Spouse+Child election termed with termination date 02/29/2016.
          And Employee+Spouse continued coverage with new effective date 03/01/2016.

          This child went on Weekly cobra file as OAD.

          Then in next week employee's employment got terminated ( status changed to terminated) with retro date 02/29/2016.
          Due to this, new election (Employee+Spouse) which was effective from 03/01/2016 became terminated as never effective.
          And Employee+Spouse+Child was already termed as 02/29/2016.

          So in next Cobra file this employee will get reported with Spouse & Child as dependent.
          Here Child's record is sent on two cobra file, one is due to Overage dependent & other due to employee's employment termination. Is this file?

          Amit Thorve Jennifer Leugers Please look into this query.
          If this is confusing to you then we can have a call to discuss this scenario.

          Let us know your inputs on same.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Jennifer, During analysis we got following query. Lets consider below example. An employee has medical election in plan P1 with Employee+Spouse+Child covered with effective date 01/01/2016. Child became ineligible from 03/01/2016. So Employee+Spouse+Child election termed with termination date 02/29/2016. And Employee+Spouse continued coverage with new effective date 03/01/2016. This child went on Weekly cobra file as OAD. Then in next week employee's employment got terminated ( status changed to terminated) with retro date 02/29/2016. Due to this, new election (Employee+Spouse) which was effective from 03/01/2016 became terminated as never effective. And Employee+Spouse+Child was already termed as 02/29/2016. So in next Cobra file this employee will get reported with Spouse & Child as dependent. Here Child's record is sent on two cobra file, one is due to Overage dependent & other due to employee's employment termination. Is this file? Amit Thorve Jennifer Leugers Please look into this query. If this is confusing to you then we can have a call to discuss this scenario. Let us know your inputs on same.
          Hide
          jennifer.leugers Jennifer Leugers added a comment -

          Hi all - why are we talking about OADs? I don't think this issue has to do with overage dependents. This is in regards to OE and the term as never effective so the termination does not go over on the COBRA file as the system doesn't see an active plan to send.

          Show
          jennifer.leugers Jennifer Leugers added a comment - Hi all - why are we talking about OADs? I don't think this issue has to do with overage dependents. This is in regards to OE and the term as never effective so the termination does not go over on the COBRA file as the system doesn't see an active plan to send.
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Jennifer Leugers Yes, this issue is not related to OAD.

          But the root cause for this issue & root cause of above mentioned OAD issue is same.
          And solution for both the issues will be same. So before proposing a solution, we asked query about OAD issue.

          Let me know if you have any queries on this.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Jennifer Leugers Yes, this issue is not related to OAD. But the root cause for this issue & root cause of above mentioned OAD issue is same. And solution for both the issues will be same. So before proposing a solution, we asked query about OAD issue. Let me know if you have any queries on this.
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Jennifer Leugers [ jennifer.leugers ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Component/s BenAdmin [ 10000 ]
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment -

          Vinayak KulkarniRohan J KhandaveCan you provide the efforts required to fix this issue ?

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Vinayak Kulkarni Rohan J Khandave Can you provide the efforts required to fix this issue ?
          Hide
          rohan.khandave Rohan J Khandave (Inactive) added a comment -

          Jennifer Leugers Rakesh Roy

          Hello,

          Any update on vinayak's query?

          So we can do analysis and work accordingly to full fill your requirement.

          Thanks,
          RohanK

          Show
          rohan.khandave Rohan J Khandave (Inactive) added a comment - Jennifer Leugers Rakesh Roy Hello, Any update on vinayak's query? So we can do analysis and work accordingly to full fill your requirement. Thanks, RohanK
          Hide
          jennifer.leugers Jennifer Leugers added a comment -

          Hi all - are you able to drop the dependent from the second event since the child has already been passed? In the case of an OAD and an employee term that occurs in the same month or reporting period, we would expect the OAD to pass on the PAR file and to not pass again as a dependent when the EE terminates.

          Show
          jennifer.leugers Jennifer Leugers added a comment - Hi all - are you able to drop the dependent from the second event since the child has already been passed? In the case of an OAD and an employee term that occurs in the same month or reporting period, we would expect the OAD to pass on the PAR file and to not pass again as a dependent when the EE terminates.
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Jennifer Leugers [ jennifer.leugers ] Rohan Khandave [ rohan.khandave ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Rohan Khandave [ rohan.khandave ] Rakesh Roy [ rakeshr ]
          Status Open [ 1 ] In Progress [ 3 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Rakesh Roy [ rakeshr ] Rohan Khandave [ rohan.khandave ]
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment -

          Rohan J KhandavePlease update.

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Rohan J Khandave Please update.
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          We are working on this, We have analyzed & found out way to pick up second event i.e. employee termination.
          However, in that way it is picking up dependent as well in second event even if child has already been passed on file.

          Now, we are analyzing to drop the dependent from second event. We will provide ETA by tomorrow.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - We are working on this, We have analyzed & found out way to pick up second event i.e. employee termination. However, in that way it is picking up dependent as well in second event even if child has already been passed on file. Now, we are analyzing to drop the dependent from second event. We will provide ETA by tomorrow.
          Hide
          jennifer.leugers Jennifer Leugers added a comment -

          I don't understand this comment ... this comment is also on JIRA 923. These are not the same issue.

          Show
          jennifer.leugers Jennifer Leugers added a comment - I don't understand this comment ... this comment is also on JIRA 923. These are not the same issue.
          Hide
          jennifer.leugers Jennifer Leugers added a comment -

          There are two issues - one involving the OAD and one involving a "regular" employee term during Open Enrollment.

          Show
          jennifer.leugers Jennifer Leugers added a comment - There are two issues - one involving the OAD and one involving a "regular" employee term during Open Enrollment.
          Hide
          rohan.khandave Rohan J Khandave (Inactive) added a comment -

          Vinayak Kulkarni Please chek

          Show
          rohan.khandave Rohan J Khandave (Inactive) added a comment - Vinayak Kulkarni Please chek
          rohan.khandave Rohan J Khandave (Inactive) made changes -
          Assignee Rohan Khandave [ rohan.khandave ] Vinayak Kulkarni [ vinayak.kulkarni ]
          rohan.khandave Rohan J Khandave (Inactive) made changes -
          Environment Production [ 10005 ]
          Issue Type Support Activity [ 10301 ] Enhancement [ 4 ]
          Status In Progress [ 3 ] Local Testing [ 10200 ]
          Workflow WT_Support [ 12814 ] WT_Features [ 14102 ]
          Hide
          jennifer.leugers Jennifer Leugers added a comment -

          Hi all - any updates on this? It has been quite a awhile since any updates were on this ticket.

          Show
          jennifer.leugers Jennifer Leugers added a comment - Hi all - any updates on this? It has been quite a awhile since any updates were on this ticket.
          Hide
          rohan.khandave Rohan J Khandave (Inactive) added a comment -

          Jennifer Leugers fix deployed on our local testing environment.

          Show
          rohan.khandave Rohan J Khandave (Inactive) added a comment - Jennifer Leugers fix deployed on our local testing environment.
          Hide
          rohan.khandave Rohan J Khandave (Inactive) added a comment -

          Hrishikesh Deshpande Please verify.

          Show
          rohan.khandave Rohan J Khandave (Inactive) added a comment - Hrishikesh Deshpande Please verify.
          rohan.khandave Rohan J Khandave (Inactive) made changes -
          Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
          satyap Satya made changes -
          Item State Parent values: Local QA(10201)Level 1 values: In Testing(10210)
          satyap Satya made changes -
          Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Export(10110)
          Hide
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - - edited

          Verified this enhancement for below scenarios on Payroll Data Template for Old COBRA implementation

          1) Coverage Tier : EE+CH
          Scenario : Child made ineligible on 03/16/2016 and COBRA file exported on 03/17/2016 . After exporting COBRA child on file status of the employee changed to terminated and again exported the cobra file
          Result : COBRA child (Ineligible Dependent) exported for 1st run and COBRA employee (Termination) exported on 2nd run.
          2) Repeated above scenario for EE+SP+CH, EE+SP+4Ch Coverage Tier .
          3) Also verified employee termination after OE changes scenario

          Scenarios working fine on LB

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - - edited Verified this enhancement for below scenarios on Payroll Data Template for Old COBRA implementation 1) Coverage Tier : EE+CH Scenario : Child made ineligible on 03/16/2016 and COBRA file exported on 03/17/2016 . After exporting COBRA child on file status of the employee changed to terminated and again exported the cobra file Result : COBRA child (Ineligible Dependent) exported for 1st run and COBRA employee (Termination) exported on 2nd run. 2) Repeated above scenario for EE+SP+CH, EE+SP+4Ch Coverage Tier . 3) Also verified employee termination after OE changes scenario Scenarios working fine on LB
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Item State Parent values: Local QA(10201)Level 1 values: In Testing(10210) Parent values: Local QA(10201)Level 1 values: Ready for Stage(10213)
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Developer Rohan Khandave [ rohan.khandave ]
          QA Aniruddha Dev [ aniruddha.dev ]
          rohan.khandave Rohan J Khandave (Inactive) made changes -
          Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Item State Parent values: Local QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Aniruddha Dev [ aniruddha.dev ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Item State Parent values: Stage QA(10202) 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)
          Hide
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          Verified on stage on Prime Healthcare for HSPL company along with WT-923

          Working as expected on Stage

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified on stage on Prime Healthcare for HSPL company along with WT-923 Working as expected on Stage
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
          Hide
          jennifer.leugers Jennifer Leugers added a comment -

          Hi all - do we have a production deployment date?

          Show
          jennifer.leugers Jennifer Leugers added a comment - Hi all - do we have a production deployment date?
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Hi Jennifer,

          This will be deployed on production in Tomorrow's patch.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Jennifer, This will be deployed on production in Tomorrow's patch.
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Status Approved for production [ 10034 ] Production Testing [ 10202 ]
          Hide
          priya.dhamande Priya Dhamande (Inactive) added a comment - - edited

          The above issue is verified on production. Please check.

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - - edited The above issue is verified on production. Please check.
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Assignee Aniruddha Dev [ aniruddha.dev ] Priya Dhamande [ priya.dhamande ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Assignee Priya Dhamande [ priya.dhamande ] Jennifer Leugers [ jennifer.leugers ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
          rakeshr Rakesh Roy (Inactive) made changes -
          Account Executive Jennifer Leugers [ jennifer.leugers ]
          Hide
          jennifer.leugers Jennifer Leugers added a comment -

          Hi all - the above seems to be in regards to an OAD which was another issue that UHC brought up. But the initial issue was in regards to employees terming and the terms not going over as it was seeing their benefits as termed as never effective due to OE elections. Example - I switch from the HMO to the PPO during OE in November with a 1.1.16 effective date. I then term in December but my term doesn't go over as the system sees that my plan was already termed (because I have new plans elected for 1.1.16)

          Show
          jennifer.leugers Jennifer Leugers added a comment - Hi all - the above seems to be in regards to an OAD which was another issue that UHC brought up. But the initial issue was in regards to employees terming and the terms not going over as it was seeing their benefits as termed as never effective due to OE elections. Example - I switch from the HMO to the PPO during OE in November with a 1.1.16 effective date. I then term in December but my term doesn't go over as the system sees that my plan was already termed (because I have new plans elected for 1.1.16)
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment -

          Priya DhamandePlease update.

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Priya Dhamande Please update.
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Jennifer Leugers [ jennifer.leugers ] Priya Dhamande [ priya.dhamande ]
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Hi Jennifer,

          Yes, the initial issue mentioned by you related OE is also fixed on production.
          Let us know if you have any queries on this.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Jennifer, Yes, the initial issue mentioned by you related OE is also fixed on production. Let us know if you have any queries on this.
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Priya Dhamande [ priya.dhamande ] Jennifer Leugers [ jennifer.leugers ]
          Transition Time In Source Status Execution Times
          Rakesh Roy (Inactive) made transition -
          Open In Progress
          13d 6h 19m 1
          Rohan J Khandave (Inactive) made transition -
          In Progress In LB Testing
          17d 6h 42m 1
          Aniruddha Dev (Inactive) made transition -
          In LB Testing Pending for Stage Approval
          3d 22h 19m 1
          Rakesh Roy (Inactive) made transition -
          Pending for Stage Approval Approved for Stage
          18h 44m 1
          Rohan J Khandave (Inactive) made transition -
          Approved for Stage Stage Testing
          2d 6h 13m 1
          Aniruddha Dev (Inactive) made transition -
          Stage Testing Pending for Production Approval
          2d 19h 34m 1
          Rakesh Roy (Inactive) made transition -
          Pending for Production Approval Approved for production
          6d 1h 6m 1
          Rajendra Pawar (Inactive) made transition -
          Approved for production In Production Testing
          1d 2h 12m 1
          Priya Dhamande (Inactive) made transition -
          In Production Testing Production Complete
          4h 5m 1

            People

            Assignee:
            jennifer.leugers Jennifer Leugers
            Reporter:
            jennifer.leugers Jennifer Leugers
            Account Executive:
            Jennifer Leugers
            Developer:
            Rohan J Khandave (Inactive)
            QA:
            Aniruddha Dev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: