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

County of Sutter - Invoice Issue

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Report
    • Reported by:
      Client
    • Company:
      County of Sutter
    • Item State:
      Development - On Hold
    • Reported by Customer:
      BCC

      Description

      Please see the email below from BCC

      The Retiree NM Anthem PPO 1000 0-4 sub rate for the Retiree NM Anthem PPO 1000 2 plan is not calculating correctly on the invoice. The billed rate should be $0 and it listed correctly as $0 in the subrate rate metric. The system is billing the $601.00 self-insured component that is listed in the rates, which is incorrect as the bill shouldn’t be picking up any of the self-insured components of the rate. This is working properly for the other sub rates in this plan, but it is not working correctly for this new 0-4 sub rate.

      I manually edited the November invoice to $0 so I could post the invoice today. Can you please look into why the system isn’t suppressing the self-insured component for this plan/sub rate?

      Kira Hamilton

        Attachments

          Issue Links

            Activity

            prasanna Prasanna Karlekar (Inactive) logged work - 11/Oct/17 10:30 PM
            • Time Spent:
              2h
               

              Issue analysis
              Data scanning script - In Progress
              JIRA update

            prasanna Prasanna Karlekar (Inactive) logged work - 12/Oct/17 09:00 PM
            • Time Spent:
              5.5h
               

              Impacted data fetching
              Data verification
              Discussion on reply to be done
              JIRA update

            prasanna Prasanna Karlekar (Inactive) logged work - 13/Oct/17 09:00 PM
            • Time Spent:
              3h
               

              Root cause analysis for incorrect IsBillable flag value
              Discussion
              JIRA update

            lalit.kumar Lalit Kumar (Inactive) logged work - 18/Oct/17 04:00 PM
            • Time Spent:
              0.5h
               

              Going through existing JIRA ticket , comments

            prasanna Prasanna Karlekar (Inactive) logged work - 19/Oct/17 12:00 AM
            • Time Spent:
              0.5h
               

              Discussion
              JIRA update

            prasanna Prasanna Karlekar (Inactive) logged work - 19/Oct/17 08:45 AM
            • Time Spent:
              0.25h
               

              JIRA go through
              JIRA update

            lalit.kumar Lalit Kumar (Inactive) logged work - 24/Oct/17 03:59 PM
            • Time Spent:
              1h
               

              Client call to discuss issues.

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 24/Oct/17 06:12 PM
            • Time Spent:
              1h
               

              client call

            prasanna Prasanna Karlekar (Inactive) logged work - 24/Oct/17 11:00 PM
            • Time Spent:
              2.5h
               

              Call preparation
              Client Call

            prasanna Prasanna Karlekar (Inactive) logged work - 26/Oct/17 01:30 AM
            • Time Spent:
              0.75h
               

              Listing of points discussed in Call

            prasanna Prasanna Karlekar (Inactive) logged work - 27/Oct/17 01:00 AM
            • Time Spent:
              1.25h
               

              MOM discussion with Lalit
              Correction script - In Progress

            lalit.kumar Lalit Kumar (Inactive) logged work - 27/Oct/17 03:59 PM - edited
            • Time Spent:
              0.5h
               

              Drafted call summary/MoM

            prasanna Prasanna Karlekar (Inactive) logged work - 27/Oct/17 09:30 PM
            • Time Spent:
              4h
               

              Data correction and verification script - Complete
              Script execution on ATC - Complete
              Script execution on County of Sutter - Pending
              Tried Workaround solution to exclude the NonBillable and verified the invoice
              Discussed this change with team members

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

              All company data scan
              List preparation

            prasanna Prasanna Karlekar (Inactive) logged work - 02/Nov/17 09:00 PM
            • Time Spent:
              2.5h
               

              Correction and Verification on HSPL
              Discussion with Export team for impact on Providerwise export
              Email draft for Enrollment Team

            prasanna Prasanna Karlekar (Inactive) logged work - 03/Nov/17 09:00 PM
            • Time Spent:
              2h
               

              Discussion on manipulations done
              Email Communication
              Correction on main company and verification
              JIRA update

            prasanna Prasanna Karlekar (Inactive) logged work - 07/Nov/17 01:30 AM
            • Time Spent:
              1.5h
               

              JIRA update
              Discussion
              Email communication

              People

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

                Dates

                Created:
                Updated:
                Dev Due Date:

                  Time Tracking

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