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
            Kira.Hamilton Kira Hamilton (Inactive) created issue -
            rakeshr Rakesh Roy (Inactive) made changes -
            Field Original Value New Value
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Report(10109)
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Type Functional [ 15402 ]
            Component/s BenAdmin [ 10000 ]
            Environment Production [ 10005 ]
            Level Partner [ 15802 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Vijay Siddha [ vijays ] Prasanna Karlekar [ prasanna ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Jyoti Agrawal [ jyoti.agrawal ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 8h [ 28800 ]
            Worklog Id 78037 [ 78037 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206)
            Original Estimate 0h [ 0 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 8h [ 28800 ] 8.75h [ 31500 ]
            Worklog Id 78182 [ 78182 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Attachment IncorrectSelfInsuredComponents.xls [ 61272 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 8.75h [ 31500 ] 15.75h [ 56700 ]
            Worklog Id 78278 [ 78278 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 15.75h [ 56700 ] 16.5h [ 59400 ]
            Worklog Id 78517 [ 78517 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Code Review Date 14/Sep/2017
            Code Reviewed By Prasanna Karlekar [ 11907 ]
            Dev Due Date 15/Sep/2017
            Developer Prasanna Karlekar [ prasanna ] Jyoti Agrawal [ jyoti.agrawal ]
            Sprint WT Sprint 37 - Bugs [ 87 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Attachment HopeCommunityIncorrectData.xls [ 61616 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 16.5h [ 59400 ] 22.5h [ 81000 ]
            Worklog Id 79046 [ 79046 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 22.5h [ 81000 ] 30.5h [ 109800 ]
            Worklog Id 79049 [ 79049 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 30.5h [ 109800 ] 37h [ 133200 ]
            Worklog Id 79054 [ 79054 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Production Due Date 21/Sep/2017
            Stage Due Date 20/Sep/17 [ 2017-09-20 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 37h [ 133200 ] 37.75h [ 135900 ]
            Worklog Id 79188 [ 79188 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 37.75h [ 135900 ] 38.5h [ 138600 ]
            Worklog Id 79195 [ 79195 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Sachin Hingole [ sachin.hingole ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Venkatesh Pujari [ venkatesh.pujari ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 38.5h [ 138600 ] 39.5h [ 142200 ]
            Worklog Id 79601 [ 79601 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Stage Due Date 20/Sep/17 [ 2017-09-20 ] 21/Sep/17 [ 2017-09-21 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Production Due Date 21/Sep/2017 22/Sep/2017
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 39.5h [ 142200 ] 42.5h [ 153000 ]
            Worklog Id 79892 [ 79892 ]
            amita.sangani Amita Sangani (Inactive) made changes -
            Time Spent 42.5h [ 153000 ] 43.25h [ 155700 ]
            Worklog Id 79903 [ 79903 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Jyoti Agrawal [ jyoti.agrawal ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Link This issue relates to WT-11228 [ WT-11228 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Venkatesh Pujari [ venkatesh.pujari ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Kira Hamilton [ kira.hamilton ]
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 43.25h [ 155700 ] 47.75h [ 171900 ]
            Worklog Id 80638 [ 80638 ]
            prasadp Prasad Pise (Inactive) made changes -
            Time Spent 47.75h [ 171900 ] 48h [ 172800 ]
            Worklog Id 80987 [ 80987 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 48h [ 172800 ] 49h [ 176400 ]
            Worklog Id 81189 [ 81189 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 1h [ 3600 ]
            Time Spent 49h [ 176400 ] 48h [ 172800 ]
            Worklog Id 79601 [ 79601 ]
            Worklog Time Spent 1h [ 3600 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 1h [ 3600 ] 0h [ 0 ]
            Time Spent 48h [ 172800 ] 49.5h [ 178200 ]
            Worklog Id 81414 [ 81414 ]
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Link This issue relates to WB-647 [ WB-647 ]
            satyap Satya made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]

              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