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

          Issue Links

            Activity

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

              Issue analysis, discussion

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

              Discussion on issue repro
              Discussion issue verification

            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

            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

            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

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

              Pair Programming-
              Issue analysis related to Datetimestamp

            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

            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

            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

            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

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

              Testing on LB

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

              INternal Discussion with Gaurav and Jyoti

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

              Testing on Stage and Production

            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