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

Wacker Neuson Corporation - 1/1/2018 dates for OE

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Support Task Type:
      Data Correction
    • Environment:
      Production
    • Reported by:
      Client
    • Company:
      Wacker Neuson Corporation
    • Module:
      BenAdmin - Enrollment
    • Severity:
      Simple

      Description

      Hi Dev -

      Client would like to move ALL enrollments to a 1/1/18 effective date. The elections should term 12/31/17 and then re-enrolled into the same plan with same election for 1/1/18. There are 4 employees that have elections that are not 1/1/18 and have a pending election. We can manually do those if needed (Listed below in comments).

      All 1/1/18 elections do not need to be changed, they can stay as is. We are requesting dev's assistance due to the large amount of elections.

      Please provide an ETA so that we can work towards a test payroll file for this client.

      Amit Thorve
      Deborah Larue

      Please provide a report before and after. I also have ran one as well. Please let me know if you have any questions!

      Jenni

        Attachments

          Activity

          Hide
          umesh.kadam Umesh Kadam (Inactive) added a comment -

          Hi Jennifer Johnson,

          Which report do you want before and after data correction? Could you please share report name?

          Also please share list of 4 employees for which enrollments are pended.

          Thanks and Regard,
          :: Umesh Kadam

          CC : Satya, Amruta Lohiya, Jyoti Mayne, Ganesh Sadawarte, Santosh Balid

          Show
          umesh.kadam Umesh Kadam (Inactive) added a comment - Hi Jennifer Johnson , Which report do you want before and after data correction? Could you please share report name? Also please share list of 4 employees for which enrollments are pended. Thanks and Regard, :: Umesh Kadam CC : Satya , Amruta Lohiya , Jyoti Mayne , Ganesh Sadawarte , Santosh Balid
          Hide
          umesh.kadam Umesh Kadam (Inactive) added a comment -

          Hi Jennifer Johnson,

          Please find our analysis below :

          • There are 44 plans for which we can move their enrollments to 01/01/2018 effective date.
          • Total 4122 enrollments will be moved during this.
          • During analysis, we found only one employees (i.e. John Her) whose 3 elections are pending for approval. Please share list of other employees if you found any.
          • Please note : If employee is NOT eligible for particular plan in 2018 then EE's election in that plan will be terminated with termination date 12/31/2017.

          We will perform following steps for this request

          1. Share "Enrollment Report" before moving all enrollments to a 01/01/2018 effective date.
          2. Move all enrollments of 44 plans to a 01/01/2018 effective date.
          3. Re-calculate rates (if needed)
          4. Re-calculate policy numbers (if needed)
          5. Share "Enrollment Report" after moving all enrollments to a 01/01/2018 effective date.

          Thanks and Regards,
          :: Umesh Kadam

          CC : Amit Thorve, Satya, Amruta Lohiya, Jyoti Mayne, Ganesh Sadawarte, Santosh Balid

          Show
          umesh.kadam Umesh Kadam (Inactive) added a comment - Hi Jennifer Johnson , Please find our analysis below : There are 44 plans for which we can move their enrollments to 01/01/2018 effective date. Total 4122 enrollments will be moved during this. During analysis, we found only one employees (i.e. John Her) whose 3 elections are pending for approval. Please share list of other employees if you found any. Please note : If employee is NOT eligible for particular plan in 2018 then EE's election in that plan will be terminated with termination date 12/31/2017. We will perform following steps for this request Share "Enrollment Report" before moving all enrollments to a 01/01/2018 effective date. Move all enrollments of 44 plans to a 01/01/2018 effective date. Re-calculate rates (if needed) Re-calculate policy numbers (if needed) Share "Enrollment Report" after moving all enrollments to a 01/01/2018 effective date. Thanks and Regards, :: Umesh Kadam CC : Amit Thorve , Satya , Amruta Lohiya , Jyoti Mayne , Ganesh Sadawarte , Santosh Balid
          Hide
          umesh.kadam Umesh Kadam (Inactive) added a comment - - edited

          Hi Jennifer Johnson,

          We have moved ALL enrollments to 01/01/2018 effective date. Please check and confirm.

          Please find below status of all STEPs mentioned above:

          1. Share "Enrollment Report" before moving all enrollments to a 01/01/2018 effective date.
          ---- Please find attached document Before_Enrollment_Report.xls.

          2. Move all enrollments of 44 plans to a 01/01/2018 effective date.
          ---- Please find list of affected plans in Affected_Plans.xls.

          3. Re-calculate rates (if needed)
          ---- Rate re-calculation not needed as all rates were moved with enrollment roll-over.

          4. Re-calculate policy numbers (if needed)
          ---- We have re-calculated policy numbers for affected plans.

          5. Share "Enrollment Report" after moving all enrollments to a 01/01/2018 effective date.
          ---- Please find attached After_Enrollment_Report_2016-2017.xls and After_Enrollment_Report_2018.xls.

          I will share password for attached document in separate mail.

          Thanks and Regards,
          :: Umesh Kadam

          CC : Amit Thorve, Satya, Gaurav Sodani, Amruta Lohiya, Jyoti Mayne, Ganesh Sadawarte, Santosh Balid

          Show
          umesh.kadam Umesh Kadam (Inactive) added a comment - - edited Hi Jennifer Johnson , We have moved ALL enrollments to 01/01/2018 effective date. Please check and confirm. Please find below status of all STEPs mentioned above: 1. Share "Enrollment Report" before moving all enrollments to a 01/01/2018 effective date. ---- Please find attached document Before_Enrollment_Report.xls . 2. Move all enrollments of 44 plans to a 01/01/2018 effective date. ---- Please find list of affected plans in Affected_Plans.xls . 3. Re-calculate rates (if needed) ---- Rate re-calculation not needed as all rates were moved with enrollment roll-over. 4. Re-calculate policy numbers (if needed) ---- We have re-calculated policy numbers for affected plans. 5. Share "Enrollment Report" after moving all enrollments to a 01/01/2018 effective date. ---- Please find attached After_Enrollment_Report_2016-2017.xls and After_Enrollment_Report_2018.xls . I will share password for attached document in separate mail. Thanks and Regards, :: Umesh Kadam CC : Amit Thorve , Satya , Gaurav Sodani , Amruta Lohiya , Jyoti Mayne , Ganesh Sadawarte , Santosh Balid

            People

            Assignee:
            jjsassy99 Jennifer Johnson (Inactive)
            Reporter:
            jjsassy99 Jennifer Johnson (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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 - 14h
                14h