Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Support Task Type:
      Data Correction
    • Reported by:
      Client
    • Module:
      BenAdmin - Report
    • Severity:
      Simple

      Description

      Hello,

      Per the client:

      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.

      Thank you,
      Kira Hamilton
      Debbie Kulling

        Attachments

          Issue Links

            Activity

            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Kira Hamilton

            We have corrected the data for mentioned employees except for their elections related to EHCW Fee plan.

            Below are the scenarios and queries:
            Employee: CARNES HELEN
            Plan: EHCW Fee
            Scenario: This election was first termed with 6/30 then with 6/1 and then with 4/1.
            Query: What should be actual termination date for this election?

            Employee: FLORES MARGARITA
            Plan: EHCW Fee
            Scenario: This election got terminated with date 9/30 on 9/6.
            But there is problem with cost table.
            For span 1/1 to 3/31 it got rate EHCW with cost $30.68
            For span 4/1 to 9/30 it got rate EHCW 2017 with cost $41.63
            On 9/7, this elections cost effective with 4/1 was termed as never effective.
            Query: Should the termed as never effective cost i.e. one which is effective from 4/1 be terminated with 9/30?

            Please update us on above 2 queries so that these 2 can be corrected too.

            Thank you!

            cc: Gaurav Sodani, Avnish Yadav, Amruta Lohiya

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Kira Hamilton We have corrected the data for mentioned employees except for their elections related to EHCW Fee plan. Below are the scenarios and queries: Employee: CARNES HELEN Plan: EHCW Fee Scenario: This election was first termed with 6/30 then with 6/1 and then with 4/1. Query: What should be actual termination date for this election? Employee: FLORES MARGARITA Plan: EHCW Fee Scenario: This election got terminated with date 9/30 on 9/6. But there is problem with cost table. For span 1/1 to 3/31 it got rate EHCW with cost $30.68 For span 4/1 to 9/30 it got rate EHCW 2017 with cost $41.63 On 9/7, this elections cost effective with 4/1 was termed as never effective. Query: Should the termed as never effective cost i.e. one which is effective from 4/1 be terminated with 9/30? Please update us on above 2 queries so that these 2 can be corrected too. Thank you! cc: Gaurav Sodani , Avnish Yadav , Amruta Lohiya
            Hide
            Kira.Hamilton Kira Hamilton (Inactive) added a comment -

            Hi Prasanna Karlekar,

            Per the client:

            Query: What should be actual termination date for this election?
            Helen Carnes: termination date for all benefits- 6/30/17

            Query: Should the termed as never effective cost i.e. one which is effective from 4/1 be terminated with 9/30?
            Margarita Flores: termination date for all benefits -9/30/17

            Thank you!
            Kira Hamilton
            Debbie Kulling

            Show
            Kira.Hamilton Kira Hamilton (Inactive) added a comment - Hi Prasanna Karlekar , Per the client: Query: What should be actual termination date for this election? Helen Carnes: termination date for all benefits- 6/30/17 Query: Should the termed as never effective cost i.e. one which is effective from 4/1 be terminated with 9/30? Margarita Flores: termination date for all benefits -9/30/17 Thank you! Kira Hamilton Debbie Kulling
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Avnish Yadav,

            Please check above comments from Kira.
            Let us know once you are done with the corrections so that we can correct Billing data and verify the invoice.

            Thank you!

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Avnish Yadav , Please check above comments from Kira. Let us know once you are done with the corrections so that we can correct Billing data and verify the invoice. Thank you!
            Hide
            avnish.yadav Avnish Yadav (Inactive) added a comment -

            Hi Prasanna Karlekar,

            As per Kira comment we have corrected enrollment data. Please verify same at your end and let us know in case of issue/concern.

            Thanks,
            Avnish Y

            CC--Amruta Lohiya,Gaurav Sodani

            Show
            avnish.yadav Avnish Yadav (Inactive) added a comment - Hi Prasanna Karlekar , As per Kira comment we have corrected enrollment data. Please verify same at your end and let us know in case of issue/concern. Thanks, Avnish Y CC-- Amruta Lohiya , Gaurav Sodani
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Kira Hamilton,

            We have corrected Enrollment and Billing related data for mentioned 3 employees. Have verified the invoice and mentioned 3 employees are not appearing on Oct 2017 invoice.
            Kindly verify at your end once and do let us know if anything more is required.

            Avnish Yadav: Thank you! for helping out with Enrollment data corrections.

            Thank you!

            cc: Debbie Kulling, Gaurav Sodani, Amruta Lohiya, Avnish Yadav

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Kira Hamilton , We have corrected Enrollment and Billing related data for mentioned 3 employees. Have verified the invoice and mentioned 3 employees are not appearing on Oct 2017 invoice. Kindly verify at your end once and do let us know if anything more is required. Avnish Yadav : Thank you! for helping out with Enrollment data corrections. Thank you! cc: Debbie Kulling , Gaurav Sodani , Amruta Lohiya , Avnish Yadav

              People

              Assignee:
              Kira.Hamilton Kira Hamilton (Inactive)
              Reporter:
              Kira.Hamilton Kira Hamilton (Inactive)
              Account Executive:
              Debbie Kulling
              Developer:
              Amruta Lohiya
              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 - 7.25h
                  7.25h