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

COB - Amwins MediGap Rate Recalculation Error

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Support Task Type:
      Query Resolution
    • Environment:
      Production
    • Reported by:
      Client
    • Company:
      COB
    • Module:
      BenAdmin - Report
    • Severity:
      Simple

      Description

      Hi,

      Per BCC:

      We were recently notified by the group that there are in state and out of state rates for the AmWins MediGap Medical plan. I have gone into the system and made the appropriate changes by adding a second Sub Rate within the AmWins Medigap Rate using state to differentiate between the two rate “plans”.

      I then went into the SA Toolbox to extend and recalculate the rate since the rate needed to be corrected back to January 2018. This correctly recalculated the rate back to 1/1/18, I confirmed this on the Employee’s Confirmation Statement as well. The employee I have used as an test person in the LIVE system is Rick Ambrose.

      The problem comes when I go to run the February Invoice. I should see in the January Adjustment section of the invoice two entries:
      1. A credit for the incorrect rate of -$456.16
      2. A rebilling for January for the amount of $445.17

      This is not occurring. Instead of rebilling the total premium of $445.17, it is only rebilling $401.71 which is a Self-Insured Component of the total premium.

      I have not recalculated and extended the rate for the entire population in the MediGap plan, there are 87 more Retirees that will need to have their rates corrected as well.

      Could you please have Development look into this and correct ASAP?

      Thank you,
      Kira Hamilton
      Debbie Kulling

        Attachments

          Issue Links

            Activity

            Kira.Hamilton Kira Hamilton (Inactive) created issue -
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Field Original Value New Value
            Assignee Satya [ ID10004 ] Prasanna Karlekar [ prasanna ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue is caused by WT-10187 [ WT-10187 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Kira Hamilton [ kira.hamilton ]
            Kira.Hamilton Kira Hamilton (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Resolved [ 5 ]
            Kira.Hamilton Kira Hamilton (Inactive) made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Closed [ 6 ] Reopen [ 4 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Kira Hamilton [ kira.hamilton ] Prasanna Karlekar [ prasanna ]
            Status Reopen [ 4 ] In Progress [ 3 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Attachment WT-13063_ImpactedInvoices.xlsx [ 71730 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Kira Hamilton [ kira.hamilton ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 2h [ 7200 ]
            Worklog Id 100369 [ 100369 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 2h [ 7200 ] 4.5h [ 16200 ]
            Worklog Id 100375 [ 100375 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Kira Hamilton [ kira.hamilton ] Prasanna Karlekar [ prasanna ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue relates to NF-5698 [ NF-5698 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Comment [ Please verify this issue, once NF-5698 is deployed as we had already fixed this issue in NF-5698.

            Thank you!

            cc: [~jyoti.agrawal] ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue relates to NF-5698 [ NF-5698 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue relates to WT-13053 [ WT-13053 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Comment [ This issue got fixed while working WT-13053.

            Thank you!

            cc: [~jyoti.agrawal] ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Kira Hamilton [ kira.hamilton ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Kira Hamilton [ kira.hamilton ] Prasanna Karlekar [ prasanna ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Venkatesh Pujari [ venkatesh.pujari ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Kira Hamilton [ kira.hamilton ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Resolved [ 5 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 4.5h [ 16200 ] 6.5h [ 23400 ]
            Worklog Id 100800 [ 100800 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 6.5h [ 23400 ] 9h [ 32400 ]
            Worklog Id 101282 [ 101282 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 9h [ 32400 ] 10h [ 36000 ]
            Worklog Id 101305 [ 101305 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 10h [ 36000 ] 12.5h [ 45000 ]
            Worklog Id 101399 [ 101399 ]
            Prajakta.belhe Prajakta Belhe (Inactive) made changes -
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Report(10109)

              People

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

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 12.5h
                  12.5h