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

Intrepid USA error on billing details reports

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Report
    • Reported by:
      Support
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      Attached is a spreadsheet with the errors I have found for Intrepid. This thing is a mess. Rates are doubling, Coverages are doubling, I have included notes next to each line item.

      The billing details coverage amounts don't match the enrollment coverage amounts. Is there anyway to stop the report from pulling life ltd std etc when they are still pending approval? These should not be billed for until we have approved coverage on them.

      Also on the child life this is a problem with all clients with this type of coverage - If the coverage is per family - ie - you have 1 child and elect $10,000 in coverage the approved coverage amount on the bill should be $10,000, likewise if you have 3 children. But the report pulls $30,000. This amount is incorrect. In most cases, however the premium is correct, not in all but in most. if we could find a fix for this across the board that would be great.

        Attachments

          Issue Links

            Activity

            lhernandez Lisa Hernandez (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)
            vijays Vijay Siddha (Inactive) made changes -
            Assignee Vijay Siddha [ vijays ] Prasanna Karlekar [ prasanna ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Aditya Vishwakarma [ aditya.vishwakarma ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 0.75h [ 2700 ]
            Worklog Id 28134 [ 28134 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Link This issue relates to WT-8642 [ WT-8642 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Time Spent 0.75h [ 2700 ] 7.25h [ 26100 ]
            Worklog Id 28175 [ 28175 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 28/Feb/2017
            Original Estimate 0h [ 0 ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Assignee Aditya Vishwakarma [ aditya.vishwakarma ] Sachin Hingole [ sachin.hingole ]
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Item State Parent values: Production Complete(10222) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)
            aditya.vishwakarma Aditya Vishwakarma (Inactive) made changes -
            Code Reviewed By Prasanna Karlekar [ 11907 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Meghana Kulkarni [ meghana.kulkarni ]
            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)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Stage Due Date 6/Mar/17 [ 2017-03-06 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Developer Aditya Vishwakarma [ aditya.vishwakarma ]
            QA Meghana Kulkarni [ meghana.kulkarni ]
            meghana.joshi Meghana Joshi (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)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Time Spent 7.25h [ 26100 ] 12.25h [ 44100 ]
            Worklog Id 28506 [ 28506 ]
            khandu.kshirsagar Khandu Kshirsagar (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)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            sachin.hingole Sachin Hingole (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)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 13/Mar/2017
            Stage Due Date 6/Mar/17 [ 2017-03-06 ] 8/Mar/17 [ 2017-03-08 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 13/Mar/2017 14/Mar/2017
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Time Spent 12.25h [ 44100 ] 13.75h [ 49500 ]
            Worklog Id 30007 [ 30007 ]
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            meghana.joshi Meghana Joshi (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)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Assignee Meghana Kulkarni [ meghana.kulkarni ] Tracy Kot [ tkot ]
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Time Spent 13.75h [ 49500 ] 14.75h [ 53100 ]
            Worklog Id 30797 [ 30797 ]
            Tkot Tracy Kot (Inactive) made changes -
            Assignee Tracy Kot [ tkot ] Lisa Hernandez [ lhernandez ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Severity Medium [ 16702 ]
            Dev Due Date 28/Feb/2017 28/Feb/2017
            Production Due Date 14/Mar/2017 14/Mar/2017
            Stage Due Date 8/Mar/17 [ 2017-03-08 ] 8/Mar/17 [ 2017-03-08 ]
            satyap Satya made changes -
            Environment_New Production [ 18442 ]

              People

              Assignee:
              lhernandez Lisa Hernandez (Inactive)
              Reporter:
              lhernandez Lisa Hernandez (Inactive)
              Account Executive:
              Tracy Kot (Inactive)
              Developer:
              Aditya Vishwakarma (Inactive)
              QA:
              Meghana Joshi (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:

                  Time Tracking

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