Details

    • Type: Bug
    • Status: Rejected
    • Priority: High
    • Resolution: System Behaviour
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Client
    • Sprint:
      WT Sprint 38 - Bugs

      Description

      Issue: Yesterday I updated the User Defined Field- Life and ADD Insurance 50K field, for all active employees. I needed to choose “not elected” or “elected”. I made this BCC Admin Change effective 4/1/17 for all employees.

      I inadvertently updated this for three terminated employees and this caused the termination date to change for these employees resulting in credits on the bill for Oct.

      Please see Helen Carnes as an example. Her history shows that changing her UDF caused her termination date to change from 6/30/17 to 4/1/17. I tried to undo the error by using a BCC admin change effective 4/1/17 again and removing the UDF selection. This did not correct the error.

      Please see the billing adjustments below that should not be occurring.

      June 2017 Adjustment:
      CARNES HELEN Regular FT (40 HRS/Week) AFSCME Terminated $-1288.22 Option 2 PPO

      May 2017 Adjustment:
      CARNES HELEN Regular FT (40 HRS/Week) AFSCME Terminated $-1288.22 Option 2 PPO
      April 2017 Adjustment:
      CARNES HELEN Regular FT (40 HRS/Week) AFSCME Terminated $-1288.22 Option 2 PPO

      The other two employees with the same issue are:

      Margarita Flores termed 5/31
      Victoria Hutchens termed 9/30

      Please advise on how to correct.

        Attachments

          Issue Links

            Activity

            avnish.yadav Avnish Yadav (Inactive) created issue -
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-11058 [ WT-11058 ]
            amruta.lohiya Amruta Lohiya made changes -
            Assignee Amruta Lohiya [ amruta.baheti ] Shailendra Honrao [ shailendra.honrao ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Developer Shailendra Honrao [ shailendra.honrao ]
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            shailendra.honrao Shailendra Honrao (Inactive) logged work - 20/Sep/17 01:04 PM
            • Time Spent:
              4h
               

              analysis,code debugging,discussion with avnish & jyoti

            Hide
            shailendra.honrao Shailendra Honrao (Inactive) added a comment -

            Hi Avnish Yadav,

            We are working on this & will update.

            Tahnks
            Shailendra Honrao

            Cc:Jyoti Mayne

            Show
            shailendra.honrao Shailendra Honrao (Inactive) added a comment - Hi Avnish Yadav , We are working on this & will update. Tahnks Shailendra Honrao Cc: Jyoti Mayne
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 4h [ 14400 ]
            Worklog Id 79976 [ 79976 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Dev Due Date 25/Sep/2017
            Original Estimate 0h [ 0 ]
            shailendra.honrao Shailendra Honrao (Inactive) logged work - 21/Sep/17 01:47 PM
            • Time Spent:
              8h
               

              analysis,discussion with avnish & amruta

            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Time Spent 4h [ 14400 ] 12h [ 43200 ]
            Worklog Id 80330 [ 80330 ]
            Hide
            shailendra.honrao Shailendra Honrao (Inactive) added a comment -

            Hi Swapnil Pandhare,

            Please find below details:

            • EE 'CARNES HELEN' was active and got election with effective date 04/01/2017 in core plans.
            • She was terminated with 06/01/2017 effective date.
            • So election was terminated as per termination rule as:
              Effective Date Termination Date Plan Name
              04/01/2017 06/30/2017 Life Insurance
            • Then with retro date QE '04/01/2017' on 2017-09-07 05:59:42.120, employee data change has been made.
            • It resulted in updating elections termination date as follow:
              Effective Date Termination Date
              04/01/2017 04/01/2017
            • Her details at this point of time were:
              Employee Status Effective Date Status Change Date
              Terminated 04/01/2017 06/01/2017
            • So our concern is, if EE is Active on 04/01/2017 effective date then what EE status has to be considered while processing enrollment data. Pleas check this EE history details and let us know those are correct or not?

            Thanks,
            Shailendra Honrao

            Cc: Amruta Lohiya,Avnish Yadav,Jyoti Mayne

            Show
            shailendra.honrao Shailendra Honrao (Inactive) added a comment - Hi Swapnil Pandhare , Please find below details: EE 'CARNES HELEN' was active and got election with effective date 04/01/2017 in core plans. She was terminated with 06/01/2017 effective date. So election was terminated as per termination rule as: Effective Date Termination Date Plan Name 04/01/2017 06/30/2017 Life Insurance Then with retro date QE '04/01/2017' on 2017-09-07 05:59:42.120, employee data change has been made. It resulted in updating elections termination date as follow: Effective Date Termination Date 04/01/2017 04/01/2017 Her details at this point of time were: Employee Status Effective Date Status Change Date Terminated 04/01/2017 06/01/2017 So our concern is, if EE is Active on 04/01/2017 effective date then what EE status has to be considered while processing enrollment data. Pleas check this EE history details and let us know those are correct or not? Thanks, Shailendra Honrao Cc: Amruta Lohiya , Avnish Yadav , Jyoti Mayne
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Assignee Shailendra Honrao [ shailendra.honrao ] Swapnil Pandhare [ swapnil.pandhare ]
            shailendra.honrao Shailendra Honrao (Inactive) logged work - 22/Sep/17 01:00 PM
            • Time Spent:
              1h
               

              discussion with jyoti,amruta

            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Time Spent 12h [ 43200 ] 13h [ 46800 ]
            Worklog Id 80655 [ 80655 ]
            jyoti.mayne Jyoti Mayne logged work - 22/Sep/17 03:21 PM
            • Time Spent:
              0.5h
               

              discussion and analysis

            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 13h [ 46800 ] 13.5h [ 48600 ]
            Worklog Id 80747 [ 80747 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Assignee Swapnil Pandhare [ swapnil.pandhare ] Jyotibala Pardeshi [ jyotibala ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 38 - Bugs [ 89 ]
            jyotibala Jyotibala Pardeshi (Inactive) made changes -
            Dev Due Date 25/Sep/2017 26/Sep/2017
            jyotibala Jyotibala Pardeshi (Inactive) made changes -
            Dev Due Date 26/Sep/2017 27/Sep/2017
            jyotibala Jyotibala Pardeshi (Inactive) made changes -
            Developer Shailendra Honrao [ shailendra.honrao ] Jyotibala Pardeshi [ jyotibala ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Dev Estimates 20
            Hide
            jyotibala Jyotibala Pardeshi (Inactive) added a comment - - edited

            Hi Shailendra Honrao

            If EE is Active on 04/01/2017 effective date then in this condition it will treat the employee as terminated, so the status would be terminated.

            This is the system behavior and it is considering the latest employee history record, and for this employee the latest record is with terminated status.

            Please let us know if you have any concern.

            Thanks and Regards,
            Jyotibala P.

            CC: Satya, Swapnil Pandhare, Sheetal Bodhale

            Show
            jyotibala Jyotibala Pardeshi (Inactive) added a comment - - edited Hi Shailendra Honrao If EE is Active on 04/01/2017 effective date then in this condition it will treat the employee as terminated, so the status would be terminated. This is the system behavior and it is considering the latest employee history record, and for this employee the latest record is with terminated status. Please let us know if you have any concern. Thanks and Regards, Jyotibala P. CC: Satya , Swapnil Pandhare , Sheetal Bodhale
            jyotibala Jyotibala Pardeshi (Inactive) made changes -
            Time Spent 13.5h [ 48600 ] 20.75h [ 74700 ]
            Worklog Id 81561 [ 81561 ]
            jyotibala Jyotibala Pardeshi (Inactive) made changes -
            Assignee Jyotibala Pardeshi [ jyotibala ] Shailendra Honrao [ shailendra.honrao ]
            jyotibala Jyotibala Pardeshi (Inactive) made changes -
            Dev Due Date 27/Sep/2017 26/Sep/2017
            swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 26/Sep/17 12:35 PM
            • Time Spent:
              2h
               

              Debugging issue with Jyoti.
              Discussion

            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Time Spent 20.75h [ 74700 ] 22.75h [ 81900 ]
            Worklog Id 81596 [ 81596 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Time Spent 22.75h [ 81900 ] 23.25h [ 83700 ]
            Worklog Id 81607 [ 81607 ]
            jyotibala Jyotibala Pardeshi (Inactive) logged work - 27/Sep/17 12:18 AM
            • Time Spent:
              7.25h
               

              Debugging and analysis of the data with Swapnil.
              Internal discussion with Swapnil and Shailendra.

            sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 27/Sep/17 12:38 AM
            • Time Spent:
              0.5h
               

              internal discussion with jyotibala

            Hide
            shailendra.honrao Shailendra Honrao (Inactive) added a comment -

            Hi Avnish Yadav,

            Please find below details:

            • EE 'CARNES HELEN' was active and got election with effective date 04/01/2017 in core plans.
            • She was terminated with 06/01/2017 effective date.
            • So election was terminated as per termination rule as:
              Effective Date Termination Date Plan Name
              04/01/2017 06/30/2017 Life Insurance
            • Then with retro date QE '04/01/2017' on 2017-09-07 05:59:42.120, employee data change has been made.
            • It resulted in updating elections termination date as follow:
              Effective Date Termination Date
              04/01/2017 04/01/2017
            • This is the system behavior, it is considering the latest employee history record, and for this employee the latest record is with terminated status.Henceforth,even if EE is Active on 04/01/2017 effective date then in this condition it will treat the employee as terminated and update election termination dates.

            Thanks,
            Shailendra Honrao

            Cc:Amruta Lohiya,Jyoti Mayne

            Show
            shailendra.honrao Shailendra Honrao (Inactive) added a comment - Hi Avnish Yadav , Please find below details: EE 'CARNES HELEN' was active and got election with effective date 04/01/2017 in core plans. She was terminated with 06/01/2017 effective date. So election was terminated as per termination rule as: Effective Date Termination Date Plan Name 04/01/2017 06/30/2017 Life Insurance Then with retro date QE '04/01/2017' on 2017-09-07 05:59:42.120, employee data change has been made. It resulted in updating elections termination date as follow: Effective Date Termination Date 04/01/2017 04/01/2017 This is the system behavior, it is considering the latest employee history record, and for this employee the latest record is with terminated status.Henceforth,even if EE is Active on 04/01/2017 effective date then in this condition it will treat the employee as terminated and update election termination dates. Thanks, Shailendra Honrao Cc: Amruta Lohiya , Jyoti Mayne
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Developer Jyotibala Pardeshi [ jyotibala ] Shailendra Honrao [ shailendra.honrao ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Resolution System Behaviour [ 10100 ]
            Status In Development [ 10007 ] Rejected [ 10004 ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Dev Due Date 26/Sep/2017 29/Sep/2017
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            Transition Time In Source Status Execution Times
            Shailendra Honrao (Inactive) made transition -
            Open In Development
            5d 22h 37m 1
            Shailendra Honrao (Inactive) made transition -
            In Development Rejected
            9d 20m 1

              People

              Assignee:
              shailendra.honrao Shailendra Honrao (Inactive)
              Reporter:
              avnish.yadav Avnish Yadav (Inactive)
              Developer:
              Shailendra Honrao (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 23.25h
                  23.25h