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

Del Norte Dental and Vision Rates

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Support Task Type:
      Configuration
    • Environment:
      Production
    • Reported by:
      Support
    • Company:
      County of Del Norte
    • Module:
      BenAdmin

      Description

      Please add the dental and vision rates we pay to the carriers in the billed rate on the rate page in WT.

      The Dental Rate is a flat rate of $7.00 and the Vision Rate is Tiered and you should have those already.

      Thank you,

      Lisa and Deana

        Attachments

        1. ct-669_Del Norte.xls
          180 kB
        2. ct-669_Del Norte.xls
          180 kB
        3. image001.jpg
          image001.jpg
          1.0 kB
        4. image002.jpg
          image002.jpg
          1 kB
        5. image003.png
          image003.png
          1 kB
        6. image004.jpg
          image004.jpg
          1 kB
        7. image005.png
          image005.png
          5 kB
        8. image006.jpg
          image006.jpg
          64 kB
        9. image007.jpg
          image007.jpg
          2 kB
        10. image008.jpg
          image008.jpg
          2 kB
        11. image010.png
          image010.png
          0.7 kB
        12. screenshot-1.png
          screenshot-1.png
          16 kB
        13. visionDel Norte.xls
          40 kB

          Activity

          Dpender Deana Pender (Inactive) created issue -
          Hide
          jphi Jennifer Melgoza added a comment -

          HI Deana,

          Per previous discussions we are not able to do this due to the 5% rates. This was noted in the implementation notes.

          Thank you,

          Jennifer Philp | Account Executive, WORKTERRA
          Employee Benefit Specialists, Inc.
          PO Box 11657, Pleasanton, CA 94588
          PH: 925-218-3532 | FAX: 925-460-3920 | jennifer.philp@ebsbenefits.com<jennifer.philp@ebsbenefits.com>
          [cid:image001.jpg@01D25B9B.E8340EF0]<http://twitter.com/#!/workterra> [cid:image002.jpg@01D25B9B.E8340EF0] <http://www.linkedin.com/company/workterra> [cid:image003.png@01D25B9B.E8340EF0] <http://www.facebook.com/workterra> [Description: Description: Description: http://chemtool.com/uploaded/six%20sigma%20logo.jpg] <http://en.wikipedia.org/wiki/Six_Sigma>

          Show
          jphi Jennifer Melgoza added a comment - HI Deana, Per previous discussions we are not able to do this due to the 5% rates. This was noted in the implementation notes. Thank you, Jennifer Philp | Account Executive, WORKTERRA Employee Benefit Specialists, Inc. PO Box 11657, Pleasanton, CA 94588 PH: 925-218-3532 | FAX: 925-460-3920 | jennifer.philp@ebsbenefits.com< jennifer.philp@ebsbenefits.com > [cid:image001.jpg@01D25B9B.E8340EF0] < http://twitter.com/#!/workterra > [cid:image002.jpg@01D25B9B.E8340EF0] < http://www.linkedin.com/company/workterra > [cid:image003.png@01D25B9B.E8340EF0] < http://www.facebook.com/workterra > [Description: Description: Description: http://chemtool.com/uploaded/six%20sigma%20logo.jpg] < http://en.wikipedia.org/wiki/Six_Sigma >
          jphi Jennifer Melgoza made changes -
          Field Original Value New Value
          Attachment image003.png [ 35670 ]
          Attachment image004.jpg [ 35671 ]
          Attachment image005.png [ 35672 ]
          Attachment image006.jpg [ 35673 ]
          Attachment image007.jpg [ 35674 ]
          Attachment image008.jpg [ 35675 ]
          Attachment image010.png [ 35676 ]
          Attachment image001.jpg [ 35668 ]
          Attachment image002.jpg [ 35669 ]
          Hide
          jjsassy99 Jennifer Johnson (Inactive) added a comment -

          JP - I recalced and it looks like the rates are showing - Im thinking b/c it was a weird mid date, it was missed during OE - All set!

          Deana - can you please re-run it and see if its working?

          Jenni

          Show
          jjsassy99 Jennifer Johnson (Inactive) added a comment - JP - I recalced and it looks like the rates are showing - Im thinking b/c it was a weird mid date, it was missed during OE - All set! Deana - can you please re-run it and see if its working? Jenni
          jjsassy99 Jennifer Johnson (Inactive) made changes -
          Assignee Jennifer Philp [ jphi ] Deana Pender [ dpender ]
          jjsassy99 Jennifer Johnson (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status To Do [ 10000 ] Done [ 10001 ]
          Hide
          jphi Jennifer Melgoza added a comment -

          Jennifer Johnson I don't know what was done to fix this - Deana mentioned this is incorrect still. Can you meet with me to show me what you did to update the rates? Perhaps it is just a recalc?

          Show
          jphi Jennifer Melgoza added a comment - Jennifer Johnson I don't know what was done to fix this - Deana mentioned this is incorrect still. Can you meet with me to show me what you did to update the rates? Perhaps it is just a recalc?
          jphi Jennifer Melgoza made changes -
          Assignee Deana Pender [ dpender ] Jennifer Fernandes [ jjsassy99 ]
          jphi Jennifer Melgoza made changes -
          Resolution Done [ 10000 ]
          Status Done [ 10001 ] To Do [ 10000 ]
          Hide
          jphi Jennifer Melgoza added a comment -

          Jennifer Johnson Hey jenni i ran a report, there are 20/48 people that still show as blanks. However, i initiate the qualifying event for 7/1/2015 the old rate comes up, and then when i initiate the QE for 12/1/2016 the new rate comes up successfully.

          It seems like the recalc did not originally work.

          I've attached the people that are affected.

          Thanks,
          Jen

          Show
          jphi Jennifer Melgoza added a comment - Jennifer Johnson Hey jenni i ran a report, there are 20/48 people that still show as blanks. However, i initiate the qualifying event for 7/1/2015 the old rate comes up, and then when i initiate the QE for 12/1/2016 the new rate comes up successfully. It seems like the recalc did not originally work. I've attached the people that are affected. Thanks, Jen
          jphi Jennifer Melgoza made changes -
          Attachment visionDel Norte.xls [ 37040 ]
          Hide
          jjsassy99 Jennifer Johnson (Inactive) added a comment -

          Can you provide me your list of blanks - I will send them to Dev to recalc

          Jenni

          Show
          jjsassy99 Jennifer Johnson (Inactive) added a comment - Can you provide me your list of blanks - I will send them to Dev to recalc Jenni
          jjsassy99 Jennifer Johnson (Inactive) made changes -
          Assignee Jennifer Fernandes [ jjsassy99 ] Jennifer Philp [ jphi ]
          Hide
          jphi Jennifer Melgoza added a comment -

          Hi, I attached it to this ticket yesterday

          Show
          jphi Jennifer Melgoza added a comment - Hi, I attached it to this ticket yesterday
          jphi Jennifer Melgoza made changes -
          Assignee Jennifer Philp [ jphi ] Jennifer Fernandes [ jjsassy99 ]
          jphi Jennifer Melgoza made changes -
          Attachment screenshot-1.png [ 37472 ]
          Hide
          jphi Jennifer Melgoza added a comment -

          Jennifer Johnson Hey Jenni, I was checking the list, and there are people that still need to be recalced to updated the rate so there is no zero for vision:
          (attached)

          Show
          jphi Jennifer Melgoza added a comment - Jennifer Johnson Hey Jenni, I was checking the list, and there are people that still need to be recalced to updated the rate so there is no zero for vision: (attached)
          janine.calendo Janine Calendo (Inactive) made changes -
          Attachment ct-669_Del Norte.xls [ 37721 ]
          Hide
          janine.calendo Janine Calendo (Inactive) added a comment -

          In reviewing this ticket I see that the Dental Plan was not Mapped. Vision is a reporting issue that I will advise DEV. And one EE needs updating. (see attached)

          ct-669_Del Norte.xls

          Janine

          Show
          janine.calendo Janine Calendo (Inactive) added a comment - In reviewing this ticket I see that the Dental Plan was not Mapped. Vision is a reporting issue that I will advise DEV. And one EE needs updating. (see attached) ct-669_Del Norte.xls Janine
          Hide
          jphi Jennifer Melgoza added a comment -

          Janine Calendo that is the dental, because there is no rate. Vison needs to be recalced, can jenni Jennifer Johnsonplease do this today?

          Show
          jphi Jennifer Melgoza added a comment - Janine Calendo that is the dental, because there is no rate. Vison needs to be recalced, can jenni Jennifer Johnson please do this today?
          darryn.carter darryn.carter made changes -
          Attachment ct-669_Del Norte.xls [ 37741 ]
          Hide
          darryn.carter darryn.carter added a comment -

          As discussed with Jennifer Philp
          The dental plan is updated by billing and rates will not by in WT
          Vision will be sent to DV (reporting issues) rate is in WT but not rates in report

          single EE issue (Shafer Julie) retiree rates not showing will continue to review EE eligibility

          Show
          darryn.carter darryn.carter added a comment - As discussed with Jennifer Philp The dental plan is updated by billing and rates will not by in WT Vision will be sent to DV (reporting issues) rate is in WT but not rates in report single EE issue (Shafer Julie) retiree rates not showing will continue to review EE eligibility
          Hide
          Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) added a comment -

          Hello Development,

          Can you please review the Retiree Vision rate for County of Del Norte? For some reason we are unable to get the rates to show on the report attached.

          Thank you

          Show
          Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) added a comment - Hello Development, Can you please review the Retiree Vision rate for County of Del Norte? For some reason we are unable to get the rates to show on the report attached. Thank you
          Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) made changes -
          Environment Production [ 10005 ]
          Issue Type Task [ 3 ] Support Activity [ 10301 ]
          Key CT-669 WT-7881
          Project WORKTERRA-CT [ 10800 ] WORKTERRA [ 10000 ]
          Status To Do [ 10000 ] Open [ 1 ]
          Support Task Type Customization [ 11204 ]
          Workflow CT: Task Management Workflow [ 29333 ] WT_Support [ 30936 ]
          Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) made changes -
          Assignee Jennifer Fernandes [ jjsassy99 ] Vijay Siddha [ vijays ]
          vijays Vijay Siddha (Inactive) made changes -
          Assignee Vijay Siddha [ vijays ] Mandar Kulkarni [ mandark ]
          Hide
          mandark Mandar Kulkarni (Inactive) added a comment -

          Hi Prasanna Karlekar,
          As discussed, could you please check why Vision Rates are not showing in the report? thanks.

          -----------------------------------------------------
          CC: Vijay Siddha, Hrishikesh Deshpande

          Show
          mandark Mandar Kulkarni (Inactive) added a comment - Hi Prasanna Karlekar , As discussed, could you please check why Vision Rates are not showing in the report? thanks. ----------------------------------------------------- CC: Vijay Siddha , Hrishikesh Deshpande
          mandark Mandar Kulkarni (Inactive) made changes -
          Assignee Mandar Kulkarni [ mandark ] Prasanna Karlekar [ prasanna ]
          mandark Mandar Kulkarni (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 1h [ 3600 ]
          Worklog Id 19951 [ 19951 ]
          mandark Mandar Kulkarni (Inactive) logged work - 19/Jan/17 10:26 PM
          • Time Spent:
            1h
             
            <No comment>
          Hide
          mandark Mandar Kulkarni (Inactive) added a comment -

          Hi Deana Pender,
          We checked this, billing report is showing blank amounts since the implementation of the report is done that way. Enrollment report shows the values correctly. Thanks.

          ---------------------------------------
          CC: Vijay Siddha

          Show
          mandark Mandar Kulkarni (Inactive) added a comment - Hi Deana Pender , We checked this, billing report is showing blank amounts since the implementation of the report is done that way. Enrollment report shows the values correctly. Thanks. --------------------------------------- CC: Vijay Siddha
          mandark Mandar Kulkarni (Inactive) made changes -
          Assignee Prasanna Karlekar [ prasanna ] Deana Pender [ dpender ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Open [ 1 ] Resolved [ 5 ]
          satyap Satya made changes -
          Environment_New Production [ 18442 ]
          Transition Time In Source Status Execution Times
          Jennifer Johnson (Inactive) made transition -
          To Do Done
          12d 19h 1
          Jennifer Melgoza made transition -
          Done To Do
          5d 22h 46m 1
          Traci Simpson (Inactive) made transition -
          To Do Open
          9d 6h 15m 1
          Rakesh Roy (Inactive) made transition -
          Open Resolved
          3d 18h 44m 1

            People

            Assignee:
            Dpender Deana Pender (Inactive)
            Reporter:
            Dpender Deana Pender (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved:

                Time Tracking

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