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

El Dorado - Payroll file records

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Support
    • Company:
      El Dorado
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have
    • Sprint:
      WT Sprint 34-Bugs

      Description

      Hi Satya,

      Can you please assist with why the Dental and Vision records exported on the Payroll_El Dorado_DV_2016 template and the Medical exported out on the next Medical file on 01/19/2017 for Debra Touchette. Medical template called Payroll_El Dorado_Medical_2016

      According to the client Debra Touchette had a pending request during the 1/6 file timeframe but was not approved until after this time and they are saying the dental/vision elections should not have exported out on the file on 1/6. Pending requests are not coming over, correct?

      On Fri, Jan 20, 2017 at 1:46 PM, Sandra Kesler <sandra.kesler@edcgov.us> wrote:
      Touchette came over on the Dental/Vision file but not the Medical file posted on 1/6

      Also:
      Angela Weide had no changes for any fields associated with the Medical file and did not export as expected but did come on the Dental/Vision file on 01/19/2017. Need to know why the elections for Angela Weide exported on the Dental/Vision export file.

      Thanks!
      Cindy

        Attachments

          Issue Links

            Activity

            Hide
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited

            Hi Cindy Wibbing,

            Please find below details.

            Concern: Why Medical, Dental and Vision record's are exported on 01/19/2017 for Debra Touchette.

            Cause: As we checked Debra Touchette previously enrolled in medical , dental and vision with EE+SP and on 1/6/2017 new coverage get added due to this new enrollment's get added to system with EE+SP+CH. The below templates are changes only templates and both template has previously exported on 1/5/2017 and above changes are made on 1/6/2017, due this it was roll out on 1/16/2017 export. Please find below medical,dental and vision enrollment details snap.


            Templates:

            • Payroll_El Dorado_DV_2016
            • Payroll_El Dorado_Medical_2016

            CC-Vinayak Kulkarni

            Please let us know if require more details

            Thanks,
            Ganesh

            Show
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited Hi Cindy Wibbing , Please find below details. Concern : Why Medical, Dental and Vision record's are exported on 01/19/2017 for Debra Touchette. Cause : As we checked Debra Touchette previously enrolled in medical , dental and vision with EE+SP and on 1/6/2017 new coverage get added due to this new enrollment's get added to system with EE+SP+CH. The below templates are changes only templates and both template has previously exported on 1/5/2017 and above changes are made on 1/6/2017, due this it was roll out on 1/16/2017 export. Please find below medical,dental and vision enrollment details snap. Templates: Payroll_El Dorado_DV_2016 Payroll_El Dorado_Medical_2016 CC- Vinayak Kulkarni Please let us know if require more details Thanks, Ganesh
            Hide
            Cindy.Wibbing Cindy Wibbing (Inactive) added a comment -

            Ganesh Sadawarte
            The issue with Touchette is that the dental and vision came on the 1/5 file. They are saying the election was pending and should not have exported.

            Also, did you have a chance to look at the other issue:
            Angela Weide had no changes for any fields associated with the Medical file and did not export as expected but elections did come on the Dental/Vision file on 01/19/2017. Need to know why the elections for Angela Weide exported on the Dental/Vision export file.

            Show
            Cindy.Wibbing Cindy Wibbing (Inactive) added a comment - Ganesh Sadawarte The issue with Touchette is that the dental and vision came on the 1/5 file. They are saying the election was pending and should not have exported. Also, did you have a chance to look at the other issue: Angela Weide had no changes for any fields associated with the Medical file and did not export as expected but elections did come on the Dental/Vision file on 01/19/2017. Need to know why the elections for Angela Weide exported on the Dental/Vision export file.
            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Cindy,

            Please see below details,

            For employee Debra Touchette, Dental and Vision was never pended, only Medical was pended and it was approved on 01/06. Dental and Vision should have pended and our enrollment team is looking into it.

            For Angela Weide, dental and vision election were updated on 01/13/2017 due to employee data change. Actually there is no change in election information due to which it can't be seen on screen but we have seen record is modified which led it to populate on export file. Ideally this should not have been updated at all and our enrollment team is looking into this and will share the details.

            Jyoti Mayne Can you take look into this. Thanks.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Cindy, Please see below details, For employee Debra Touchette, Dental and Vision was never pended, only Medical was pended and it was approved on 01/06. Dental and Vision should have pended and our enrollment team is looking into it. For Angela Weide, dental and vision election were updated on 01/13/2017 due to employee data change. Actually there is no change in election information due to which it can't be seen on screen but we have seen record is modified which led it to populate on export file. Ideally this should not have been updated at all and our enrollment team is looking into this and will share the details. Jyoti Mayne Can you take look into this. Thanks.
            Hide
            Cindy.Wibbing Cindy Wibbing (Inactive) added a comment -

            Jyoti Mayne
            Do you have any updates on this ticket?
            Thanks,
            Cindy

            cc Abhay Patil

            Show
            Cindy.Wibbing Cindy Wibbing (Inactive) added a comment - Jyoti Mayne Do you have any updates on this ticket? Thanks, Cindy cc Abhay Patil
            Hide
            vinanti.yadav Vinanti Yadav (Inactive) added a comment -

            Hi Hrishikesh Deshpande,

            Issue 1 :
            Election of Contingent Force Plans are not going in pending queue.

            Employee Name : DEBORAH TOUCHETTE
            Qualifying Event : BIRTH-ADOPTION
            Qualifying Event settings :
            IsVerifycationFlag is Yes.

            this employee is enrolled in plan 'Kaiser HMO' (benefit type : medical) with Effectivedate '1/1/2017' .

            Force Plan : -

            1. Delta Dental PPO Premier
            2. VSP Vision

            this issue is not getting introduce at our end. Please help up to reproducing this issue and share your findings with client.

            Issue 2 :
            Force contingent enrollments are getting updated by employee data change.
            there is no actual change in enrollment, it is just updating enrollment date-time stamp.
            For this issue please refer WT-8485.

            CC :Jaideep Vinchurkar

            Show
            vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hi Hrishikesh Deshpande , Issue 1 : Election of Contingent Force Plans are not going in pending queue. Employee Name : DEBORAH TOUCHETTE Qualifying Event : BIRTH-ADOPTION Qualifying Event settings : IsVerifycationFlag is Yes. this employee is enrolled in plan 'Kaiser HMO' (benefit type : medical) with Effectivedate '1/1/2017' . Force Plan : - Delta Dental PPO Premier VSP Vision this issue is not getting introduce at our end. Please help up to reproducing this issue and share your findings with client. Issue 2 : Force contingent enrollments are getting updated by employee data change. there is no actual change in enrollment, it is just updating enrollment date-time stamp. For this issue please refer WT-8485 . CC : Jaideep Vinchurkar
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Hi Prasad,

            Can you please take this forward with your team?

            Regards,
            Aniruddha Dev

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Hi Prasad, Can you please take this forward with your team? Regards, Aniruddha Dev
            Hide
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            Because of the other prioritized items - we have not started testing this yet.
            We will take this to reproduce soon and update the status.

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - Because of the other prioritized items - we have not started testing this yet. We will take this to reproduce soon and update the status.
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi Vinanti Yadav,

            CC:Rakesh Roy,Hrishikesh Deshpande,Jyoti Mayne,Alankar Chavan,Jaideep Vinchurkar

            I have verified this issue as per employee DEBORAH TOUCHETTE view history and it is getting reproduced below are the steps:

            Admin Login/partner login:

            1] Done 1st enrollment through Admin change event with effective date 08/01/2016 with EE+SP tier in Medical Plan Kaiser HMO plan Dental and vision plan are contingent so it was also enrolled with same effective date.

            Employee Login:

            2]Done 2nd enrollment through BIRTH-ADOPTION event with effective date 04/01/2017 with EE+SP+CH tier in Medical Plan Kaiser HMO plan medical plan going for Admin Approval pending but force contingent plan Delta Dental PPO Premier and VSP Vision are not. refer below screen shots:

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Vinanti Yadav , CC: Rakesh Roy , Hrishikesh Deshpande , Jyoti Mayne , Alankar Chavan , Jaideep Vinchurkar I have verified this issue as per employee DEBORAH TOUCHETTE view history and it is getting reproduced below are the steps: Admin Login/partner login: 1] Done 1st enrollment through Admin change event with effective date 08/01/2016 with EE+SP tier in Medical Plan Kaiser HMO plan Dental and vision plan are contingent so it was also enrolled with same effective date. Employee Login: 2]Done 2nd enrollment through BIRTH-ADOPTION event with effective date 04/01/2017 with EE+SP+CH tier in Medical Plan Kaiser HMO plan medical plan going for Admin Approval pending but force contingent plan Delta Dental PPO Premier and VSP Vision are not. refer below screen shots: Thanks, Rashmita
            Hide
            umesh.kadam Umesh Kadam (Inactive) added a comment -

            Hi,

            Please find below 3Cs details :

            Concern El Dorado - Payroll file records : From employee login, after changing coverage/tier in medical plan (parent), medical is going to pend but Vision and Dental are not even though both as forced on Medical
            Cause This scenario specific issue of forced contingency. While adding elections from Employee Login, approval pending flag was missed for child plan elections
            Correction We have added code to consider approval pending flag of parent.

            Please find below Impacted scenarios/areas :

            • Accept/Reject scenarios (for child and parent)
            • Approval Pending added on Parent only, QE only, both parent and QE, none of parent and QE
            • Forced and normal contingency scenarios for parent and child plans

            Impacted areas should be tested using :

            • Enroll Now screen
            • Employee Data Change
            • Import
            • Pending Queue
            • Also using Admin and Employee Login
            • Also test scenario(s) of related JIRA ticket i.e. WT-8485

            Thanks and Regards,
            :: Umesh Kadam

            CC : Jaideep Vinchurkar, Jyoti Mayne, Vinanti Yadav, Hrishikesh Deshpande

            Show
            umesh.kadam Umesh Kadam (Inactive) added a comment - Hi, Please find below 3Cs details : Concern El Dorado - Payroll file records : From employee login, after changing coverage/tier in medical plan (parent), medical is going to pend but Vision and Dental are not even though both as forced on Medical Cause This scenario specific issue of forced contingency. While adding elections from Employee Login, approval pending flag was missed for child plan elections Correction We have added code to consider approval pending flag of parent. Please find below Impacted scenarios/areas : Accept/Reject scenarios (for child and parent) Approval Pending added on Parent only, QE only, both parent and QE, none of parent and QE Forced and normal contingency scenarios for parent and child plans Impacted areas should be tested using : Enroll Now screen Employee Data Change Import Pending Queue Also using Admin and Employee Login Also test scenario(s) of related JIRA ticket i.e. WT-8485 Thanks and Regards, :: Umesh Kadam CC : Jaideep Vinchurkar , Jyoti Mayne , Vinanti Yadav , Hrishikesh Deshpande
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified this issue on Lb Environment consider below scenario
            Customization
            Dental and vision plan force contingent on Medical plan with Exact tier match up.
            Scenario 1: Done 1st enrollment through Admin change event with effective date 08/01/2016 with EE+SP tier in Medical Plan with Dental and vision which are contingent Plan so it was also enrolled with same effective date.
            2]Done 2nd enrollment through BIRTH-ADOPTION event with effective date 04/01/2017 with EE+SP+CH tier in Medical going for Admin Approval pending with contingent plan Dental Vision

            Scenario 2: Pending Queue when we accept Medical plan then Enrollment done both with medical and all contingent plan.

            Scenario 3:Pending Queue when we Reject Medical plan then contingent plan should be rejected also.

            this scenario 3 is not working it will not reject contingent plan
            refer pending queue screen shots

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified this issue on Lb Environment consider below scenario Customization Dental and vision plan force contingent on Medical plan with Exact tier match up. Scenario 1: Done 1st enrollment through Admin change event with effective date 08/01/2016 with EE+SP tier in Medical Plan with Dental and vision which are contingent Plan so it was also enrolled with same effective date. 2]Done 2nd enrollment through BIRTH-ADOPTION event with effective date 04/01/2017 with EE+SP+CH tier in Medical going for Admin Approval pending with contingent plan Dental Vision Scenario 2: Pending Queue when we accept Medical plan then Enrollment done both with medical and all contingent plan. Scenario 3:Pending Queue when we Reject Medical plan then contingent plan should be rejected also. this scenario 3 is not working it will not reject contingent plan refer pending queue screen shots
            Hide
            umesh.kadam Umesh Kadam (Inactive) added a comment -

            Hi Rashmita Dudhe,

            As discussed, issue which you have reported in your recent comment is scenario specific and not caused due to code fix of this bug. Please check and confirm.

            Thanks and Regards,
            :: Umesh Kadam

            CC : Jyoti Mayne, Hrishikesh Deshpande, Prasad Pise

            Show
            umesh.kadam Umesh Kadam (Inactive) added a comment - Hi Rashmita Dudhe , As discussed, issue which you have reported in your recent comment is scenario specific and not caused due to code fix of this bug. Please check and confirm. Thanks and Regards, :: Umesh Kadam CC : Jyoti Mayne , Hrishikesh Deshpande , Prasad Pise
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - - edited

            Verified this issue on Lb Environment consider below scenario
            Customization
            Dental and vision plan force contingent on Medical plan with Exact tier match up.
            1]: Done 1st enrollment through Admin change event with effective date 08/01/2016 with EE+SP tier in Medical Plan with Dental and vision which are contingent Plan so it was also enrolled with same effective date.
            2]Done 2nd enrollment through BIRTH-ADOPTION event with effective date 04/01/2017 with EE+SP+CH tier in Medical going for Admin Approval pending with contingent plan Dental Vision

            Scenario 1: Pending Queue when we accept Medical plan then Enrollment done both with medical and all contingent plan.

            Scenario 2:Pending Queue when we Reject Medical plan then contingent plan also rejected.
            working fine as expected

            found one scenario specific issue created jira :WT-10501 with this known issue changing status as ready for stage

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - - edited Verified this issue on Lb Environment consider below scenario Customization Dental and vision plan force contingent on Medical plan with Exact tier match up. 1]: Done 1st enrollment through Admin change event with effective date 08/01/2016 with EE+SP tier in Medical Plan with Dental and vision which are contingent Plan so it was also enrolled with same effective date. 2]Done 2nd enrollment through BIRTH-ADOPTION event with effective date 04/01/2017 with EE+SP+CH tier in Medical going for Admin Approval pending with contingent plan Dental Vision Scenario 1 : Pending Queue when we accept Medical plan then Enrollment done both with medical and all contingent plan. Scenario 2 :Pending Queue when we Reject Medical plan then contingent plan also rejected. working fine as expected found one scenario specific issue created jira : WT-10501 with this known issue changing status as ready for stage
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified this issue on Stage Environment consider below scenario
            Customization
            Dental and vision plan force contingent on Medical plan with Exact tier match up.
            1]: Done 1st enrollment through Admin change event with effective date 08/01/2016 with EE+SP tier in Medical Plan with Dental and vision which are contingent Plan so it was also enrolled with same effective date.
            2]Done 2nd enrollment through BIRTH-ADOPTION event with effective date 04/01/2017 with EE+SP+CH tier in Medical going for Admin Approval pending with contingent plan Dental Vision

            Scenario 1: Pending Queue when we accept Medical plan then Enrollment done both with medical and all contingent plan.

            Scenario 2:Pending Queue when we Reject Medical plan then contingent plan also rejected.
            working fine as expected

            found one scenario specific issue created jira :WT-10501 with this known issue changing status as ready for production

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified this issue on Stage Environment consider below scenario Customization Dental and vision plan force contingent on Medical plan with Exact tier match up. 1]: Done 1st enrollment through Admin change event with effective date 08/01/2016 with EE+SP tier in Medical Plan with Dental and vision which are contingent Plan so it was also enrolled with same effective date. 2]Done 2nd enrollment through BIRTH-ADOPTION event with effective date 04/01/2017 with EE+SP+CH tier in Medical going for Admin Approval pending with contingent plan Dental Vision Scenario 1: Pending Queue when we accept Medical plan then Enrollment done both with medical and all contingent plan. Scenario 2:Pending Queue when we Reject Medical plan then contingent plan also rejected. working fine as expected found one scenario specific issue created jira : WT-10501 with this known issue changing status as ready for production
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified this issue on Production Environment consider below scenario
            Customization
            Dental and vision plan force contingent on Medical plan with Exact tier match up.
            1]: Done 1st enrollment through Admin change event with effective date 08/01/2016 with EE+SP tier in Medical Plan with Dental and vision which are contingent Plan so it was also enrolled with same effective date.
            2]Done 2nd enrollment through BIRTH-ADOPTION event with effective date 04/01/2017 with EE+SP+CH tier in Medical going for Admin Approval pending with contingent plan Dental Vision
            Scenario 1: Pending Queue when we accept Medical plan then Enrollment done both with medical and all contingent plan.
            Scenario 2:Pending Queue when we Reject Medical plan then contingent plan also rejected.
            working fine as expected

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified this issue on Production Environment consider below scenario Customization Dental and vision plan force contingent on Medical plan with Exact tier match up. 1]: Done 1st enrollment through Admin change event with effective date 08/01/2016 with EE+SP tier in Medical Plan with Dental and vision which are contingent Plan so it was also enrolled with same effective date. 2]Done 2nd enrollment through BIRTH-ADOPTION event with effective date 04/01/2017 with EE+SP+CH tier in Medical going for Admin Approval pending with contingent plan Dental Vision Scenario 1: Pending Queue when we accept Medical plan then Enrollment done both with medical and all contingent plan. Scenario 2:Pending Queue when we Reject Medical plan then contingent plan also rejected. working fine as expected
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi,

            This is deployed and verified on Production.
            While testing found one existing issue Jira:WT-10501 which is under development.

            Kindly, Check and Update this jira accordingly.

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi, This is deployed and verified on Production. While testing found one existing issue Jira: WT-10501 which is under development. Kindly, Check and Update this jira accordingly. Thanks, Rashmita
            Hide
            Cindy.Wibbing Cindy Wibbing (Inactive) added a comment -

            I have not had any additional issues reported. Closing ticket

            Show
            Cindy.Wibbing Cindy Wibbing (Inactive) added a comment - I have not had any additional issues reported. Closing ticket

              People

              Assignee:
              Cindy.Wibbing Cindy Wibbing (Inactive)
              Reporter:
              Cindy.Wibbing Cindy Wibbing (Inactive)
              Developer:
              Umesh Kadam (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 32h Original Estimate - 32h
                  32h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 81h 55m
                  81h 55m