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

JE Dunn Payroll OE Elections rolling on File All Templates are Current Year Yes

    Details

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

      Description

      EE Michael Day has a medical and Dental OE record went across on the payroll file. Some of his records are New Hire enrollment and Some are Open Enrollment. Looking at the history he was a new hire benefits eff 112/1 but made a change to the Dental in the OE Window. Why were those records fetched, the client should not be getting those yet. Please advise

      Thank you

      Group File:
      JE Dunn 2017
      Company:
      Payroll CMIC Payroll MED DEN VIS 2017
      Payroll CMIC Payroll FSA 2017
      Payroll Vol Supp Life CMIC EE SP 2017
      Payroll CMIC Vo ADD Tobacco LTD 2017
      Payroll CMIC Payroll HSA Only 2017
      Payroll Voluntary CMIC Child Life 2017

        Attachments

          Issue Links

            Activity

            Damion.Velasquez Damion M Velasquez created issue -
            Damion.Velasquez Damion M Velasquez made changes -
            Field Original Value New Value
            Link This issue relates to EDI-2769 [ EDI-2769 ]
            Damion.Velasquez Damion M Velasquez made changes -
            Link This issue is cloned by WT-12428 [ WT-12428 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Ganesh Sadawarte [ ganesh.sadawarte ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Rajendra Pawar [ rajendra.pawar ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Component/s BenAdmin [ 10000 ]
            Issue Importance Must Have [ 11800 ]
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Export(10110)
            Remaining Estimate 8h [ 28800 ]
            Original Estimate 8h [ 28800 ]
            rajendra.pawar Rajendra Pawar (Inactive) logged work - 29/Nov/17 01:00 PM
            • Time Spent:
              1h
               
              <No comment>
            Hide
            rajendra.pawar Rajendra Pawar (Inactive) added a comment -

            Hi Damion M Velasquez,

            We are in progress of analyzing this issue, we will update you by tomorrow.

            With kind regards,
            Rajendra Pawar
            -------------------------------------------
            Vinayak Kulkarni Ganesh Sadawarte

            Show
            rajendra.pawar Rajendra Pawar (Inactive) added a comment - Hi Damion M Velasquez , We are in progress of analyzing this issue, we will update you by tomorrow. With kind regards, Rajendra Pawar ------------------------------------------- Vinayak Kulkarni Ganesh Sadawarte
            Hide
            rajendra.pawar Rajendra Pawar (Inactive) added a comment -

            Hi Damion M Velasquez,

            We could not able to look into this, we will let you know ASAP.

            With kind regards,
            Rajendra Pawar
            -----------------------
            Prashant Samal

            Show
            rajendra.pawar Rajendra Pawar (Inactive) added a comment - Hi Damion M Velasquez , We could not able to look into this, we will let you know ASAP. With kind regards, Rajendra Pawar ----------------------- Prashant Samal
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Remaining Estimate 8h [ 28800 ] 7h [ 25200 ]
            Time Spent 1h [ 3600 ]
            Worklog Id 94247 [ 94247 ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Attachment EnrollmentHistory.JPG [ 69005 ]
            Hide
            rajendra.pawar Rajendra Pawar (Inactive) added a comment -

            Hi Damion M Velasquez,

            Below are the 3C's

            Concern : EE Michael Day has a medical and Dental OE record went across on the payroll file. Some of his records are New Hire enrollment and Some are Open Enrollment. Looking at the history he was a new hire benefits eff 112/1 but made a change to the Dental in the OE Window. Why were those records fetched, the client should not be getting those yet.

            Cause : Below transactions happened in New hire and OE window period

            • Employee got New hire mode and he enrolled into CoPay Dental plan with effective date 11/01/2017 on 11/6/2017 6:23:37 AM.
            • After 20 minutes he got OE window and he enrolled for next year Traditional Dental plan with effective date 01/01/2018 on 11/6/2017 6:43:36 AM. So CoPay Dental plan got terminated with termination date 12/31/2017 with Open enrollment Mode.

            Please see attached snap for more detail.

            So inserted election mode was New hire and then latest updated mode is Open Enrollment Mode for terminated record.

            We have Enrollment Election Change Reason mapped on sub template. The logic for this field is, it will roll out latest mode on file.

            Correction : As off now we don't have field to handle such scenarios and export data correctly. If required then we need to develop new field and this needs approval.

            With kind regards,
            Rajendra Pawar
            ------------------------------------------
            Vinayak Kulkarni Ganesh Sadawarte

            Show
            rajendra.pawar Rajendra Pawar (Inactive) added a comment - Hi Damion M Velasquez , Below are the 3C's Concern : EE Michael Day has a medical and Dental OE record went across on the payroll file. Some of his records are New Hire enrollment and Some are Open Enrollment. Looking at the history he was a new hire benefits eff 112/1 but made a change to the Dental in the OE Window. Why were those records fetched, the client should not be getting those yet. Cause : Below transactions happened in New hire and OE window period Employee got New hire mode and he enrolled into CoPay Dental plan with effective date 11/01/2017 on 11/6/2017 6:23:37 AM. After 20 minutes he got OE window and he enrolled for next year Traditional Dental plan with effective date 01/01/2018 on 11/6/2017 6:43:36 AM. So CoPay Dental plan got terminated with termination date 12/31/2017 with Open enrollment Mode . Please see attached snap for more detail. So inserted election mode was New hire and then latest updated mode is Open Enrollment Mode for terminated record. We have Enrollment Election Change Reason mapped on sub template. The logic for this field is, it will roll out latest mode on file. Correction : As off now we don't have field to handle such scenarios and export data correctly. If required then we need to develop new field and this needs approval. With kind regards, Rajendra Pawar ------------------------------------------ Vinayak Kulkarni Ganesh Sadawarte
            rajendra.pawar Rajendra Pawar (Inactive) logged work - 01/Dec/17 12:37 PM
            • Time Spent:
              4h
               
              <No comment>
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Remaining Estimate 7h [ 25200 ] 3h [ 10800 ]
            Time Spent 1h [ 3600 ] 5h [ 18000 ]
            Worklog Id 94344 [ 94344 ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Assignee Rajendra Pawar [ rajendra.pawar ] Damion Velasquez [ damion.velasquez ]
            rohan.khandave Rohan J Khandave (Inactive) logged work - 01/Dec/17 02:33 PM
            • Time Spent:
              1h
               

              discussion with team

            rohan.khandave Rohan J Khandave (Inactive) made changes -
            Remaining Estimate 3h [ 10800 ] 2h [ 7200 ]
            Time Spent 5h [ 18000 ] 6h [ 21600 ]
            Worklog Id 94601 [ 94601 ]
            Damion.Velasquez Damion M Velasquez made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Damion.Velasquez Damion M Velasquez made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            Damion.Velasquez Damion M Velasquez made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            Damion.Velasquez Damion M Velasquez made changes -
            Resolution Done [ 10000 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            Damion.Velasquez Damion M Velasquez made changes -
            Resolution Done [ 10000 ] Fixed [ 1 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Rajendra Pawar (Inactive) made transition -
            Open In Development
            11h 54m 1
            Damion M Velasquez made transition -
            In Development In LB Testing
            5d 18h 7m 1
            Damion M Velasquez made transition -
            In LB Testing Stage Testing
            3s 1
            Damion M Velasquez made transition -
            Stage Testing In Production Testing
            55s 1
            Damion M Velasquez made transition -
            In Production Testing Production Complete
            9s 1
            Damion M Velasquez made transition -
            Production Complete Closed
            1m 35s 1

              People

              Assignee:
              Damion.Velasquez Damion M Velasquez
              Reporter:
              Damion.Velasquez Damion M Velasquez
              Account Executive:
              Tracy Kot (Inactive)
              EDI Analyst 1:
              Damion M Velasquez
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 8h
                  8h
                  Remaining:
                  Time Spent - 6h Remaining Estimate - 2h
                  2h
                  Logged:
                  Time Spent - 6h Remaining Estimate - 2h
                  6h