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

Auto enroll plans are not showing correct effective date

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Medium
    • Resolution: System Behaviour
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Support Task Type:
      Data Correction
    • Environment:
      Production
    • Reported by:
      Support
    • Company:
      LONG Building Technologies
    • Module:
      BenAdmin - Enrollment
    • Severity:
      Simple

      Description

      Hello Dev Team

      Employee (CODY HENSLEY) moving from UNION to STAFF under OE Event "Union to Non-Union". I changed the QE rule to read "waiting period "first of the month following event date", However the Confirmation Statement is showing effective date of change

      Can you help determine why this is happening

        Attachments

          Activity

          darryn.carter darryn.carter created issue -
          amruta.lohiya Amruta Lohiya made changes -
          Field Original Value New Value
          Assignee Vijay Siddha [ vijays ] Umesh Kadam [ umesh.kadam ]
          prasadp Prasad Pise (Inactive) made changes -
          Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107)
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Assignee Umesh Kadam [ umesh.kadam ] Shailendra Honrao [ shailendra.honrao ]
          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Developer Shailendra Honrao [ shailendra.honrao ]
          jyoti.mayne Jyoti Mayne logged work - 10/Oct/17 09:50 AM
          • Time Spent:
            0.5h
             

            analysis and discussion

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

          Hi darryn.carter,

          We are working on this & will update you.

          Thanks,
          Shailendra Honrao

          Cc:Jyoti Mayne

          Show
          shailendra.honrao Shailendra Honrao (Inactive) added a comment - Hi darryn.carter , We are working on this & will update you. Thanks, Shailendra Honrao Cc: Jyoti Mayne
          shailendra.honrao Shailendra Honrao (Inactive) logged work - 10/Oct/17 12:55 PM - edited
          • Time Spent:
            6h
             

            analysis data from back-end,discussion with jyoti related to qualifying event concept and its working,try to reproduce on local company.

          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 6h [ 21600 ]
          Worklog Id 84151 [ 84151 ]
          shailendra.honrao Shailendra Honrao (Inactive) logged work - 12/Oct/17 12:54 PM
          • Time Spent:
            1h
             

            analysis

          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Time Spent 6h [ 21600 ] 7h [ 25200 ]
          Worklog Id 84586 [ 84586 ]
          jyoti.mayne Jyoti Mayne logged work - 13/Oct/17 10:41 AM
          • Time Spent:
            0.75h
             

            analysis and discussion

          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Attachment raised_qualifying_event.png [ 64436 ]
          Hide
          shailendra.honrao Shailendra Honrao (Inactive) added a comment -

          Hi Swapnil Pandhare,

          Customization:

          Screen Event Name Rule
          Event Builder Union to Non-Union NA
          Qualifying Event screen Union to Non-Union

          Analysis:

          • This event was raised on '10/09/2017', and as per rule set on this event effective date should be 11/01/2017.
          • And elections of reported EE (CODY HENSLEY) also have same effective date.

          Observations:

          • We have observed that, in RaisedQualifyingEvent table value of Effective Date column goes NULL. PFA below
          • As Effective date goes NULL, EE got elections with event date i.e;10/09/2017

          Can you please look into this issue, why effective date goes NULL?

          Note: We have also added new EE on HSPL to reproduce this issue with union class & then change his class from Union to Staff but event cannot be raised.

          Thanks,
          Shailendra Honrao

          Cc:Jyoti Mayne

          Show
          shailendra.honrao Shailendra Honrao (Inactive) added a comment - Hi Swapnil Pandhare , Customization: Screen Event Name Rule Event Builder Union to Non-Union NA Qualifying Event screen Union to Non-Union Analysis: This event was raised on '10/09/2017', and as per rule set on this event effective date should be 11/01/2017. And elections of reported EE (CODY HENSLEY) also have same effective date. Observations: We have observed that, in RaisedQualifyingEvent table value of Effective Date column goes NULL. PFA below As Effective date goes NULL, EE got elections with event date i.e;10/09/2017 Can you please look into this issue, why effective date goes NULL? Note: We have also added new EE on HSPL to reproduce this issue with union class & then change his class from Union to Staff but event cannot be raised. Thanks, Shailendra Honrao Cc: Jyoti Mayne
          shailendra.honrao Shailendra Honrao (Inactive) logged work - 13/Oct/17 12:56 PM
          • Time Spent:
            8h
             

            analysis,restore company,executing scripts,added new EE & try to reproduce an issue,discussion with jyoti

          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Time Spent 7h [ 25200 ] 15h [ 54000 ]
          Worklog Id 84910 [ 84910 ]
          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Assignee Shailendra Honrao [ shailendra.honrao ] Swapnil Pandhare [ swapnil.pandhare ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Assignee Swapnil Pandhare [ swapnil.pandhare ] Sheetal Bodhale [ sheetal.bodhale ]
          jyoti.mayne Jyoti Mayne made changes -
          Time Spent 15h [ 54000 ] 15.5h [ 55800 ]
          Worklog Id 85056 [ 85056 ]
          jyoti.mayne Jyoti Mayne made changes -
          Time Spent 15.5h [ 55800 ] 16.25h [ 58500 ]
          Worklog Id 85085 [ 85085 ]
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 14/Oct/17 10:31 PM
          • Time Spent:
            1h
             

            Analysis

          Hide
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

          Hi Shailendra Honrao,

          We do not refer effective date column of RaisedQualifyingEvent table.That is added by ACA team.
          If employee raises QE then effective date will be calculated as per rule and It is working fine.

          If we change employee class then as per event builder setting,selected QE will be raised automatically.And elections will be updated by status change date.

          CC:Swapnil PandhareJyoti Mayne

          Thanks,
          Sheetal Bodhale

          Show
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Hi Shailendra Honrao , We do not refer effective date column of RaisedQualifyingEvent table.That is added by ACA team. If employee raises QE then effective date will be calculated as per rule and It is working fine. If we change employee class then as per event builder setting,selected QE will be raised automatically.And elections will be updated by status change date. CC: Swapnil Pandhare Jyoti Mayne Thanks, Sheetal Bodhale
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Assignee Sheetal Bodhale [ sheetal.bodhale ] Shailendra Honrao [ shailendra.honrao ]
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Time Spent 16.25h [ 58500 ] 17.25h [ 62100 ]
          Worklog Id 85249 [ 85249 ]
          Hide
          shailendra.honrao Shailendra Honrao (Inactive) added a comment -

          Hi Hrishikesh Deshpande,

          Please refer comment of Sheetal Bodhale.

          As per this comment,

          • If we raise normal QE then elections will get with effective date rule set on raised QE.
          • We have event builder setting and if we change EE class then elections will get with status change date not with effective date rule set on QE.

          Please verify this.

          Thanks,
          Shailendra Honrao

          Cc: Jyoti Mayne,Sheetal Bodhale,Swapnil Pandhare

          Show
          shailendra.honrao Shailendra Honrao (Inactive) added a comment - Hi Hrishikesh Deshpande , Please refer comment of Sheetal Bodhale . As per this comment, If we raise normal QE then elections will get with effective date rule set on raised QE. We have event builder setting and if we change EE class then elections will get with status change date not with effective date rule set on QE. Please verify this. Thanks, Shailendra Honrao Cc: Jyoti Mayne , Sheetal Bodhale , Swapnil Pandhare
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Time Spent 17.25h [ 62100 ] 21.45h [ 77220 ]
          Worklog Id 85322 [ 85322 ]
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 17/Oct/17 01:27 AM
          • Time Spent:
            4.2h
             

            Analysis
            Testing
            Updated comments

          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Assignee Shailendra Honrao [ shailendra.honrao ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Shailendra Honrao [ shailendra.honrao ]
          Status Open [ 1 ] In Progress [ 3 ]
          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Assignee Shailendra Honrao [ shailendra.honrao ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
          Hide
          darryn.carter darryn.carter added a comment -

          Hello Dev Team
          Are you able to provide any update on this issue

          Show
          darryn.carter darryn.carter added a comment - Hello Dev Team Are you able to provide any update on this issue
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Priya Dhamande [ priya.dhamande ]
          Hide
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          Hi darryn.carter,

          We are working on the request, few scenarios are verified. We will be able to give complete analysis and issue resolution on 24/10/2017.

          Hrishikesh Deshpande Jyotibala Pardeshi

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - Hi darryn.carter , We are working on the request, few scenarios are verified. We will be able to give complete analysis and issue resolution on 24/10/2017. Hrishikesh Deshpande Jyotibala Pardeshi
          Hide
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          Hi darryn.carter,

          Environment: Production
          Company: Long for Hspl
          Login: partner and Employee

          Event Builder Union to Non-Union
          When Class change is done using Event builder
          In this case, the effective date is considered as the date of Event change, it ignores QE rule. This functionality is working as expected.

          QE Union to Non-Union
          When Class change is done using QE
          In this case, the effective date should be as per QE rule. Currently, we have found some discrepancy in this so created jira with ID: WT-11776.

          For the scenario mentioned in this support task, it should ignore QE Rule and consider the Effective date as per teh Event change date.

          Hrishikesh Deshpande Sheetal Bodhale Swapnil Pandhare Shailendra Honrao

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - Hi darryn.carter , Environment: Production Company: Long for Hspl Login: partner and Employee Event Builder Union to Non-Union When Class change is done using Event builder In this case, the effective date is considered as the date of Event change, it ignores QE rule. This functionality is working as expected. QE Union to Non-Union When Class change is done using QE In this case, the effective date should be as per QE rule. Currently, we have found some discrepancy in this so created jira with ID: WT-11776 . For the scenario mentioned in this support task, it should ignore QE Rule and consider the Effective date as per teh Event change date. Hrishikesh Deshpande Sheetal Bodhale Swapnil Pandhare Shailendra Honrao
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Resolution System Behaviour [ 10100 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          priya.dhamande Priya Dhamande (Inactive) logged work - 24/Oct/17 01:16 PM - edited
          • Time Spent:
            2h
             

            Issue repro
            discussion with sheetal and Hrishikesh

          Hide
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          Please let us know if more inputs are required.

          Thanks

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - Please let us know if more inputs are required. Thanks
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Assignee Priya Dhamande [ priya.dhamande ] darryn.carter [ darryn.carter ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Time Spent 21.45h [ 77220 ] 22.45h [ 80820 ]
          Worklog Id 86103 [ 86103 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Time Spent 22.45h [ 80820 ] 23.45h [ 84420 ]
          Worklog Id 86103 [ 86103 ]
          shailendra.honrao Shailendra Honrao (Inactive) made changes -
          Worklog Id 84151 [ 84151 ]
          satyap Satya made changes -
          Environment_New Production [ 18442 ]
          Transition Time In Source Status Execution Times
          Sheetal Bodhale (Inactive) made transition -
          In Progress Open
          6d 4h 57m 1
          Shailendra Honrao (Inactive) made transition -
          Open In Progress
          2d 3h 50m 2
          Priya Dhamande (Inactive) made transition -
          In Progress Resolved
          6d 5h 21m 1

            People

            Assignee:
            darryn.carter darryn.carter
            Reporter:
            darryn.carter darryn.carter
            Developer:
            Shailendra Honrao (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 23.45h
                23.45h