WORKTERRAProject Type: software

WORKTERRA

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

COSB-Retiree Billing Issue

    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 Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - Report
    • Reported by:
      Client
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 37 - Bugs

      Description

      Hello,

      Per the client:

      Issue: We have an issue with the SBCERS invoice for group COSB. The rate for dental plan – RETIREE DELTA DENTAL SF PPO is not calculating the entire premium on the invoice. There is a PBIA Admin Fee of $0.35 that is not included in the total billed premium.

      Here are few examples of retirees to research:
      Allen Meskimen
      Daniel Gosselin
      Richard Yoerks

      Attached:
      • Screen shots of confirm statements for each retiree above
      • Copy of the invoice showing 1003 retirees with this rate error

      When we pull the confirm statements the premium amount is correct.

      Thank you!
      Kira Hamilton
      Debbie Kulling

        Attachments

        1. HopeCommunityIncorrectData.xls
          9 kB
          Jyoti Agrawal
        2. IncorrectSelfInsuredComponents.xls
          8 kB
          Jyoti Agrawal
        3. SBCERS Invoice Delta Dental SF.xlsx
          116 kB
          Kira Hamilton
        4. Screen Shot 09-07-17 at 10.28 AM.PNG
          122 kB
          Kira Hamilton
        5. Screen Shot 09-07-17 at 10.30 AM.PNG
          122 kB
          Kira Hamilton
        6. Screen Shot 09-07-17 at 10.30 AM 001.PNG
          119 kB
          Kira Hamilton

          Issue Links

          relates to

          Support Activity - Support Activity WT-11228 Invoice management -> Incorrect self insured component billing in Invoice

          • Medium - Has the potential to affect progress.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. WB-647 Kittitas County - Providerwise file Issue

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 11/Sep/17 01:12 PM
            • Time Spent:
              8h
               

              Issue analysis, discussion

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 11/Sep/17 09:00 PM
            • Time Spent:
              0.75h
               

              Discussion on issue repro
              Discussion issue verification

            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 12/Sep/17 01:06 PM
            • Time Spent:
              7h
               

              Analysis,Code fix, Unit Testing, data correction, discussion with Prasanna

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 12/Sep/17 10:30 PM
            • Time Spent:
              0.75h
               

              Discussion on fix done
              Data correction scenario discussion
              Review of reply to be done

            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 13/Sep/17 12:52 PM
            • Time Spent:
              6h
               

              Data correction, writing generic script to verify data in all companies

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 13/Sep/17 09:30 PM
            • Time Spent:
              0.75h
               

              Pair Programming-
              Issue analysis related to Datetimestamp

            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 14/Sep/17 12:56 PM
            • Time Spent:
              8h
               

              Data correction, verification of incorrect data in all companies, writing generic script to correct data in all companies

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 14/Sep/17 09:15 PM
            • Time Spent:
              0.75h
               

              Code review
              Discussion on changes to be done
              Discussion on correction script to correct bulk data

            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 15/Sep/17 12:57 PM
            • Time Spent:
              6.5h
               

              Data correction, data verification, discussion, code fix and check-in, jira update

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 15/Sep/17 10:00 PM
            • Time Spent:
              1h
               

              Discussion on query for Bulk data correction
              Review of reply to be done

            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 20/Sep/17 08:53 AM
            • Time Spent:
              3h
               

              Testing on LB

            Permalink
            amita.sangani Amita Sangani (Inactive) logged work - 20/Sep/17 09:32 AM
            • Time Spent:
              0.75h
               
              <No comment>
            Permalink
            prasadp Prasad Pise (Inactive) logged work - 22/Sep/17 09:08 AM
            • Time Spent:
              0.25h
               

              INternal Discussion with Gaurav and Jyoti

            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 22/Sep/17 12:53 PM
            • Time Spent:
              4.5h
               

              Testing on Stage and Production

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 22/Sep/17 08:00 PM
            • Time Spent:
              1.5h
               

              Client comment go through
              Discussion
              Backend data analysis
              Review of reply to be done

              People

              Assignee:
              Kira.Hamilton Kira Hamilton (Inactive)
              Reporter:
              Kira.Hamilton Kira Hamilton (Inactive)
              Account Executive:
              Debbie Kulling
              Developer:
              Jyoti Agrawal (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 49.5h
                  49.5h