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

JE Dunn COBRA QE Discovery File

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Export
    • Reported by:
      EDI
    • Company:
      JE Dunn
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have
    • Sprint:
      WT Sprint 41

      Description

      Template name: JE DUNN_Discovery Cobra QB_IN_Use_NEW 2017
      11/3 file
      1. Timothy Benbow is the EE; ISABELLA PIPARO - dependent Child removed during OE:
      2. Jesus Plata is the EE, we sent Eryn Eberlein - Divorce QE VERY OLD 2016 Divorce, back in 2016:

      11/10 file:
      1. EE is Dirk Schafer, removed child Carolyn Schafer form Medical/RX this also went over as a Divorce QE

      Can you look at the settings? We dont think this should pass this way

      Thank you

        Attachments

        1. Demographics_history.PNG
          Demographics_history.PNG
          21 kB
        2. Dev Tested Scenarios.xls
          6 kB
        3. Enrollment_History.PNG
          Enrollment_History.PNG
          45 kB
        4. FW 1211 Sprint - Development Approval.msg
          51 kB
        5. RunDates.PNG
          RunDates.PNG
          6 kB
        6. WT-12445 Affected Files.txt
          0.1 kB

          Issue Links

            Activity

            Hide
            rakesh.shahane Rakesh Shahane (Inactive) added a comment - - edited

            Hi Damion M Velasquez,

            Concern: Cobra reason went as Divorce for removed child.

            Cause: We have checked the details of mentioned employee, As per analysis we found that When EE Timothy Benbow Removed child, Enrollment got terminated but on the event builder, There is no such event present which can be captured due to termination, However after that EE Change the Spouse relationship from spouse to Ex-Spouse, So because of this Divorce event got satisfied and that reason went over the file.

            Same scenario happened with other mentioned employees.

            Correction: We need to discuss this with Amit Thorve.

            CC-Prashant Samal, Ganesh Sadawarte, Rajendra Pawar, Vinayak Kulkarni

            Show
            rakesh.shahane Rakesh Shahane (Inactive) added a comment - - edited Hi Damion M Velasquez , Concern: Cobra reason went as Divorce for removed child. Cause: We have checked the details of mentioned employee, As per analysis we found that When EE Timothy Benbow Removed child, Enrollment got terminated but on the event builder, There is no such event present which can be captured due to termination, However after that EE Change the Spouse relationship from spouse to Ex-Spouse, So because of this Divorce event got satisfied and that reason went over the file. Same scenario happened with other mentioned employees. Correction: We need to discuss this with Amit Thorve . CC- Prashant Samal , Ganesh Sadawarte , Rajendra Pawar , Vinayak Kulkarni
            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Damion,

            We have checked this and found that records for child should not have been populated on file.

            However they are populated and that too with incorrect reason code. We are working on fix and will let you know once it is done. Please ask discovery benefits to ignore this event. Thanks.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Damion, We have checked this and found that records for child should not have been populated on file. However they are populated and that too with incorrect reason code. We are working on fix and will let you know once it is done. Please ask discovery benefits to ignore this event. Thanks.
            Hide
            Damion.Velasquez Damion M Velasquez added a comment -

            Tracy Kot Do you have anymore to add fort this one?

            Please advise
            thanks

            Show
            Damion.Velasquez Damion M Velasquez added a comment - Tracy Kot Do you have anymore to add fort this one? Please advise thanks
            Hide
            Damion.Velasquez Damion M Velasquez added a comment -

            Vinayak KulkarniThe Fix can you link the support ticket?

            Thank you

            CC Deborah Mascot

            Show
            Damion.Velasquez Damion M Velasquez added a comment - Vinayak Kulkarni The Fix can you link the support ticket? Thank you CC Deborah Mascot
            Hide
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,

            Attaching the development approval email for your reference

            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, Attaching the development approval email for your reference Regards Gaurav
            Hide
            rajendra.pawar Rajendra Pawar (Inactive) added a comment -

            Attached is the unit testing document - Dev Tested Scenarios.xls

            Below cobra events has been tested in unit testing.

            • Employee Termination
            • Divorce- Spouse to Ex-Spouse
            • Overage Dependent
            • Retired
            • Class Change
            Show
            rajendra.pawar Rajendra Pawar (Inactive) added a comment - Attached is the unit testing document - Dev Tested Scenarios.xls Below cobra events has been tested in unit testing. Employee Termination Divorce- Spouse to Ex-Spouse Overage Dependent Retired Class Change
            Hide
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment -

            Getting server error ,while verifying following scenarios
            1)Employee termination
            2)Retired
            3)Class change

            Hence,It is* blocked* to test this bug .

            *Error Log- *
            ErrorID : 0
            ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->Employee.Save->Employee.UpdateEmployeeClass->Employee.GetEffectiveDateForEnrollmentMode
            ErrorMessage: Conversion from type 'DBNull' to type 'Date' is not valid.

            Hence assigning this to you,once it gets fixed , reassign back to me .

            Thanks,
            Swapnil Eksambekar.

            CC-Aniruddha DevRakesh RoyHrishikesh DeshpandeRajendra PawarVinayak Kulkarni

            Show
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - Getting server error ,while verifying following scenarios 1)Employee termination 2)Retired 3)Class change Hence,It is* blocked* to test this bug . *Error Log- * ErrorID : 0 ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->Employee.Save->Employee.UpdateEmployeeClass->Employee.GetEffectiveDateForEnrollmentMode ErrorMessage: Conversion from type 'DBNull' to type 'Date' is not valid. Hence assigning this to you,once it gets fixed , reassign back to me . Thanks, Swapnil Eksambekar. CC- Aniruddha Dev Rakesh Roy Hrishikesh Deshpande Rajendra Pawar Vinayak Kulkarni
            Hide
            Damion.Velasquez Damion M Velasquez added a comment -

            Umesh Kadam A new issue that I am not sure relates to this or not Steven Golubski terminated COBRA Eligible Benefits 11/20 and should have rolled out in the file 11/24. This was done in the OE Window I think as an Employee Data Change. Can you tell us why his record didnt pass? This is is a VP that termed so it is a Highly Sensitive issue

            Thank you

            CC Andrea DennisKristi SmithKevin WalkerVinayak KulkarniRajendra PawarHrishikesh DeshpandeAniruddha Dev

            Show
            Damion.Velasquez Damion M Velasquez added a comment - Umesh Kadam A new issue that I am not sure relates to this or not Steven Golubski terminated COBRA Eligible Benefits 11/20 and should have rolled out in the file 11/24. This was done in the OE Window I think as an Employee Data Change. Can you tell us why his record didnt pass? This is is a VP that termed so it is a Highly Sensitive issue Thank you CC Andrea Dennis Kristi Smith Kevin Walker Vinayak Kulkarni Rajendra Pawar Hrishikesh Deshpande Aniruddha Dev
            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Damion,

            here are details for Steven Golubski not populated on cobra file.

            Steven Golubski is terminated from WT on 11/15/2017 via scheduled import, see below

            But employee's enrollment did not terminate due to import back-end routine failed and file exported on 11/17/2017, so for this export it found enrollments active and thus it did not roll out on file

            and on 11/20/2017 SA terminated elections as part of data correction.

            Note: We found one more employee "Brandon Stanley" terminated on same import and did not populate on cobra file.

            let us know if you want these records to be forced on next cobra file. Thanks.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Damion, here are details for Steven Golubski not populated on cobra file. Steven Golubski is terminated from WT on 11/15/2017 via scheduled import, see below But employee's enrollment did not terminate due to import back-end routine failed and file exported on 11/17/2017, so for this export it found enrollments active and thus it did not roll out on file and on 11/20/2017 SA terminated elections as part of data correction. Note: We found one more employee "Brandon Stanley" terminated on same import and did not populate on cobra file. let us know if you want these records to be forced on next cobra file. Thanks.
            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            As discussed, We have forced these records from back-end, it will populate on next export. Thanks.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - As discussed, We have forced these records from back-end, it will populate on next export. Thanks.
            Hide
            snehal.shabade Snehal Shabade (Inactive) added a comment - - edited

            Hi Swapnil Eksambekar,

            Please find below 3Cs:

            Concern Getting server error while changing EE status as terminated
            Cause In "JE Dunn" company, 'Terminated' employee status is not selected for any New Hire / Re-Hire Rule due to which terminated employee is not eligible for any rule. And hence system gets 'null' value for effective date which is causing server error
            Correction Select 'Terminated' status for respected new hire / re-hire rule.We have tested the same in local and it is working fine. Please check and confirm.

            Thanks,
            Snehal Shabade

            Cc:Umesh Kadam

            Show
            snehal.shabade Snehal Shabade (Inactive) added a comment - - edited Hi Swapnil Eksambekar , Please find below 3Cs: Concern Getting server error while changing EE status as terminated Cause In "JE Dunn" company, 'Terminated' employee status is not selected for any New Hire / Re-Hire Rule due to which terminated employee is not eligible for any rule. And hence system gets 'null' value for effective date which is causing server error Correction Select 'Terminated' status for respected new hire / re-hire rule.We have tested the same in local and it is working fine. Please check and confirm. Thanks, Snehal Shabade Cc: Umesh Kadam
            Hide
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment -

            Verified following COBRA EVENT scenarios -

            • Employee Termination
            • Overage Dependent
            • Retired
            • Class Change

            Above mentioned scenarios are working as expected.
            Testing is in progress for Ex-Spouse or Divorced Cobra event.

            CC-Aniruddha DevHrishikesh DeshpandeRakesh Roy

            Show
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - Verified following COBRA EVENT scenarios - Employee Termination Overage Dependent Retired Class Change Above mentioned scenarios are working as expected. Testing is in progress for Ex-Spouse or Divorced Cobra event. CC- Aniruddha Dev Hrishikesh Deshpande Rakesh Roy
            Hide
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment -

            Verified for Ex-spouse or Divorced Cobra event along with all mentioned scenarios in above comment,It is working as expected.
            Ready for Stage deployment.

            CC-Aniruddha DevHrishikesh DeshpandeRakesh RoyVinayak Kulkarni

            Show
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - Verified for Ex-spouse or Divorced Cobra event along with all mentioned scenarios in above comment,It is working as expected. Ready for Stage deployment. CC- Aniruddha Dev Hrishikesh Deshpande Rakesh Roy Vinayak Kulkarni
            Hide
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,

            This ticket has been approved for stage deployment on 12/21/17.

            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, This ticket has been approved for stage deployment on 12/21/17. Regards Gaurav
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            This Issue is deployed on Stage. We will test it and update on Tuesday, 12/26.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - This Issue is deployed on Stage. We will test it and update on Tuesday, 12/26.
            Hide
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment -

            Below cobra events has been verified on Stage :-

            • Employee Termination
            • Divorce- Spouse to Ex-Spouse
            • Overage Dependent
            • Retired
            • Class Change

            It is working as expected.Ready for Production deployment.

            CC-Aniruddha DevRakesh ShahaneHrishikesh DeshpandeRakesh RoyGaurav Sodani

            Show
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - Below cobra events has been verified on Stage :- Employee Termination Divorce- Spouse to Ex-Spouse Overage Dependent Retired Class Change It is working as expected.Ready for Production deployment. CC- Aniruddha Dev Rakesh Shahane Hrishikesh Deshpande Rakesh Roy Gaurav Sodani
            Hide
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - - edited

            Unable to test below scenarios ,

            • Employee Termination
            • Divorce- Spouse to Ex-Spouse
            • Overage Dependent
            • Retired
            • Class Change

            It is blocked to test due to wt-12931 ,as It is getting server error.Once it gets resolved , reassign to me.

            CC-Aniruddha DevHrishikesh DeshpandeRakesh RoyVinayak Kulkarni

            Show
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - - edited Unable to test below scenarios , Employee Termination Divorce- Spouse to Ex-Spouse Overage Dependent Retired Class Change It is blocked to test due to wt-12931 ,as It is getting server error.Once it gets resolved , reassign to me. CC- Aniruddha Dev Hrishikesh Deshpande Rakesh Roy Vinayak Kulkarni
            Hide
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,

            Attaching the production deployment approval email for reference

            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, Attaching the production deployment approval email for reference Regards Gaurav
            Hide
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment -

            Hello Damion M Velasquez,

            We have deployed and verified this fix on production today
            Verified all below scenarios :-
            Employee Termination -Pass
            Divorce- Spouse to Ex-Spouse -Pass
            Overage Dependent -Pass
            Retired -Pass
            Class Change -Pass

            Can you please check this at your end and close this JIRA ?
            Please let us know in case of any queries or issues.

            CC-Aniruddha DevHrishikesh DeshpandeRakesh RoyGaurav SodaniVinayak Kulkarni

            Show
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - Hello Damion M Velasquez , We have deployed and verified this fix on production today Verified all below scenarios :- Employee Termination - Pass Divorce- Spouse to Ex-Spouse - Pass Overage Dependent - Pass Retired - Pass Class Change - Pass Can you please check this at your end and close this JIRA ? Please let us know in case of any queries or issues. CC- Aniruddha Dev Hrishikesh Deshpande Rakesh Roy Gaurav Sodani Vinayak Kulkarni

              People

              Assignee:
              Damion.Velasquez Damion M Velasquez
              Reporter:
              Damion.Velasquez Damion M Velasquez
              Account Executive:
              Tracy Kot (Inactive)
              EDI Analyst 1:
              Damion M Velasquez
              Developer:
              Rajendra Pawar (Inactive)
              QA:
              Aniruddha Dev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              8 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 - 28h Original Estimate - 28h
                  28h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 56h 32m
                  56h 32m