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

Suburban Electric - DBS COBRApoint QB update

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Configuration
    • Environment:
      Production
    • Reported by:
      EDI
    • Company:
      Suburban Electric
    • Module:
      BenAdmin - Export
    • Issue Importance:
      Must Have
    • Severity:
      Simple

      Description

      Client: Suburban Electric
      Company Template: DBS_COBRApoint_QB
      Export Date: 02/21/2018
      Terminated employee affected: Daniel Niemuth
      Spouse: Jessica Niemuth
      Plan / coverage level affected: Superior Voluntary Vision Plan / EE+SPOUSE

      Hello Development Team,

      Carrier is requesting us to remove the coveragelevel EE+SPOUSE for only the Superior Voluntary Vision Plan. There was a miscommunication between carrier and wageworks. They have manually removed this coveragelevel from today's QB file and reloaded it. We won't need to resend them a new file, but they are expecting future files to not include this coveragelevel for the vision plan. Below is their original message for reference:

      The QB Import however had incurred one error which upon further investigation, was due to DBS not communicating the proper instructions to Wageworks. The error was connected to the Superior Vision Plan, our rates for this plan do not include a separate rate for QB + Spouse however on the import instructions we had communicated that this was true. The previous instructions to include a separate rate for the employee + spouse (QB +Spouse) was incorrect and we apologize for this. The correct rate bands for the Superior Voluntary Vision are as follows:

      QB Only: 11.68

      QB + Child: $23.36

      QB + Family: $30.99

      Spouse Only: $11.68

      Please remove the QB+ Spouse for the Superior Voluntary Vision Plan from today’s and future reports for Suburban Electrical Employees.

      Thank you,

      Jacqueline Lauersdorf, COBRA Specialist
      jlauersdorf@dbsbenefits.com

      Let me know if you need additional info.

      Thank you,

      Alex

        Attachments

          Activity

          alexn Alex Nguyen created issue -
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Field Original Value New Value
          Assignee Satya [ ID10004 ] Vinayak Kulkarni [ vinayak.kulkarni ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Prajakta Belhe [ prajakta.belhe ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 22/Feb/18 11:11 AM
          • Time Spent:
            3h
             
            <No comment>
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Remaining Estimate 8h [ 28800 ]
          Original Estimate 8h [ 28800 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Remaining Estimate 8h [ 28800 ] 5h [ 18000 ]
          Time Spent 3h [ 10800 ]
          Worklog Id 105814 [ 105814 ]
          Prajakta.belhe Prajakta Belhe (Inactive) logged work - 22/Feb/18 11:17 AM
          • Time Spent:
            5h
             

            Analysis
            rules creation
            testing

          Prajakta.belhe Prajakta Belhe (Inactive) made changes -
          Remaining Estimate 5h [ 18000 ] 0h [ 0 ]
          Time Spent 3h [ 10800 ] 8h [ 28800 ]
          Worklog Id 105831 [ 105831 ]
          rajendra.pawar Rajendra Pawar (Inactive) logged work - 22/Feb/18 11:53 AM
          • Time Spent:
            1h
             
            <No comment>
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Time Spent 8h [ 28800 ] 9h [ 32400 ]
          Worklog Id 105918 [ 105918 ]
          Prajakta.belhe Prajakta Belhe (Inactive) made changes -
          Attachment suburban electric.PNG [ 73712 ]
          Hide
          Prajakta.belhe Prajakta Belhe (Inactive) added a comment -

          Hi Alex Nguyen,

          We have added the rules for Coverage tier labels. It is working as expected.
          In case of Superior Voluntary Vision Plan and EE+SPOUSE coverage, CoverageLevel will populate as EE but QBDEPENDENTPLAN will populate as well since the Spouse is enrolled. Please refer attached screenshot for the same.

          Let us know if anything else is needed.

          Thanks,
          Prajakta

          CC - Vinayak Kulkarni

          Show
          Prajakta.belhe Prajakta Belhe (Inactive) added a comment - Hi Alex Nguyen , We have added the rules for Coverage tier labels. It is working as expected. In case of Superior Voluntary Vision Plan and EE+SPOUSE coverage, CoverageLevel will populate as EE but QBDEPENDENTPLAN will populate as well since the Spouse is enrolled. Please refer attached screenshot for the same. Let us know if anything else is needed. Thanks, Prajakta CC - Vinayak Kulkarni
          Prajakta.belhe Prajakta Belhe (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          Hide
          alexn Alex Nguyen added a comment -

          Hi Prajakta Belhe,

          I just talked to the carrier and they said if employee and spouse are enrolled in the Superior Vision plan to send as EE+Family. This has been confirmed by the DBS analyst and their manager. Let me know if you need additional info.

          Thank you,

          Alex

          Show
          alexn Alex Nguyen added a comment - Hi Prajakta Belhe , I just talked to the carrier and they said if employee and spouse are enrolled in the Superior Vision plan to send as EE+Family . This has been confirmed by the DBS analyst and their manager. Let me know if you need additional info. Thank you, Alex
          Hide
          Prajakta.belhe Prajakta Belhe (Inactive) added a comment -

          Hi Alex Nguyen,

          We are done with the changes. Please verify the same at your end.

          Let us know if anything else is needed.

          Thanks,
          Prajakta

          CC - Vinayak Kulkarni

          Show
          Prajakta.belhe Prajakta Belhe (Inactive) added a comment - Hi Alex Nguyen , We are done with the changes. Please verify the same at your end. Let us know if anything else is needed. Thanks, Prajakta CC - Vinayak Kulkarni
          Prajakta.belhe Prajakta Belhe (Inactive) logged work - 23/Feb/18 12:30 PM
          • Time Spent:
            1h
             

            Analysis
            changes
            testing

          Prajakta.belhe Prajakta Belhe (Inactive) made changes -
          Time Spent 9h [ 32400 ] 10h [ 36000 ]
          Worklog Id 106073 [ 106073 ]
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Assignee Prajakta Belhe [ prajakta.belhe ] Alex Nguyen [ alexn ]
          Hide
          alexn Alex Nguyen added a comment -

          Thank you Prajakta Belhe. There's no term records today to check, but I will let you know if the change resolves it.

          Alex

          Show
          alexn Alex Nguyen added a comment - Thank you Prajakta Belhe . There's no term records today to check, but I will let you know if the change resolves it. Alex
          Hide
          alexn Alex Nguyen added a comment -

          Hi Prajakta Belhe. There's no term record this week and last week to check and not sure when it becomes available to verify. I will close the ticket for now, but will reopen if issue persist. Thank you.

          Alex

          Show
          alexn Alex Nguyen added a comment - Hi Prajakta Belhe . There's no term record this week and last week to check and not sure when it becomes available to verify. I will close the ticket for now, but will reopen if issue persist. Thank you. Alex
          alexn Alex Nguyen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times
          Vinayak Kulkarni (Inactive) made transition -
          Open In Progress
          10h 52m 1
          Prajakta Belhe (Inactive) made transition -
          In Progress Resolved
          7h 58m 1
          Alex Nguyen made transition -
          Resolved Closed
          14d 11h 54m 1

            People

            Assignee:
            alexn Alex Nguyen
            Reporter:
            alexn Alex Nguyen
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 8h Original Estimate - 8h
                8h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 10h
                10h