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

            Hide
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            Hi Kira Hamilton,

            We are analyzing the issue. We will update you soon.

            Thanks,
            Jyoti Agrawal

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Hi Kira Hamilton , We are analyzing the issue. We will update you soon. Thanks, Jyoti Agrawal
            Hide
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            Hi Kira Hamilton,

            We have found the root cause. There was an issue in script. We will be providing the fix as per deployement process.

            For now we have corrected the data for rate of 'RETIREE DELTA DENTAL SF PPO' plan. This rate will be now calculating the entire premium on the invoice including PBIA Admin Fee of $0.35. To see the changes you need to regenerate October invoice. The mentioned retirees will also appear in invoice. Let us know if you still see issue for this rate.

            Apart from mentioned rate we also scanned all rates in this company which have similar issue. Please see attached file IncorrectSelfInsuredComponents.xls consisting list of rates and there components which are affected. We have corrected few data and this is still in progress. We will be scanning all companies for this issue.

            cc:Prasanna Karlekar

            Thank You!
            Jyoti Agrawal

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Hi Kira Hamilton , We have found the root cause. There was an issue in script. We will be providing the fix as per deployement process. For now we have corrected the data for rate of 'RETIREE DELTA DENTAL SF PPO' plan. This rate will be now calculating the entire premium on the invoice including PBIA Admin Fee of $0.35. To see the changes you need to regenerate October invoice. The mentioned retirees will also appear in invoice . Let us know if you still see issue for this rate. Apart from mentioned rate we also scanned all rates in this company which have similar issue. Please see attached file IncorrectSelfInsuredComponents.xls consisting list of rates and there components which are affected. We have corrected few data and this is still in progress. We will be scanning all companies for this issue. cc: Prasanna Karlekar Thank You! Jyoti Agrawal
            Hide
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            3C's
            Concern :-
            On changing self Insured component IsBillable flag from non billable to billable -
            a) Only last tier data was getting updated from non billable to billable when there were more than 1 tier defined.
            b) The cost after decimal was becoming zero on update.

            Cause :-
            a)
            i) Part of code checkin for ticket WT-7195 is missing on Stage and Production.
            ii) There was an issue in trigger, only single entry was getting inserted on bulk update

            b) The data type for cost was Int instead of Decimal

            Correction :-
            a)
            i)Will do missing code check-in on Stage and Production against ticket WT-7195
            ii)Changes made to insert data for every tier on update

            b) Changed cost data type to Decimal

            Affected Files :-
            trgUpdSelfInsuredChanges_LogBillableToNonBillable

            Affected Area :-
            IsBillable flag change for SelfInsuredComponent

            Tested Scenarios :-
            Verfied data for all tiers on Isbillable flag change (Non-Billale to Billable and Billable to Non-Billable) for rates effective from past, current and future mont

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - 3C's Concern :- On changing self Insured component IsBillable flag from non billable to billable - a) Only last tier data was getting updated from non billable to billable when there were more than 1 tier defined. b) The cost after decimal was becoming zero on update. Cause :- a) i) Part of code checkin for ticket WT-7195 is missing on Stage and Production. ii) There was an issue in trigger, only single entry was getting inserted on bulk update b) The data type for cost was Int instead of Decimal Correction :- a) i)Will do missing code check-in on Stage and Production against ticket WT-7195 ii)Changes made to insert data for every tier on update b) Changed cost data type to Decimal Affected Files :- trgUpdSelfInsuredChanges_LogBillableToNonBillable Affected Area :- IsBillable flag change for SelfInsuredComponent Tested Scenarios :- Verfied data for all tiers on Isbillable flag change (Non-Billale to Billable and Billable to Non-Billable) for rates effective from past, current and future mont
            Hide
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            Hi Kira Hamilton,

            We have corrected all incorrect self Insured rates in this company. Please refer IncorrectSelfInsuredComponents.xls that we provided earlier.

            We scanned all companies in production and found 'Hope Community Resources' only with similar issue.
            See the attached list of incorrect Self Insured Components HopeCommunityIncorrectData.xls . We have corrected all data in this company too.

            Below are our observation for invoice in 'Hope Community Resources':-
            Employee: KAREN LESKO
            Plans:
            a) CO PAID COBRA Aetna Dental
            b) CO PAID COBRA VSP Vision
            c) Company Paid COBRA Aetna Medical HRA

            1) In invoice for the month of September for mentioned plan this employee was billed with Zero cost. But according to system data, the the cost shouldn't be Zero. We assume the data has been edited from UI in Invoice. Can you please confirm on this if data has been edited from Invoice UI or not ? If not, we need to find the root cause for zero cost.

            2) Due to incorrect data related to Self Insured Components, this employee is getting incorrectly billed in October Invoice(recently generated) for the above three plans. We have made data correction. Please regenerate October invoice to get correct bill.

            Thank You!
            Jyoti Agrawal

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Hi Kira Hamilton , We have corrected all incorrect self Insured rates in this company. Please refer IncorrectSelfInsuredComponents.xls that we provided earlier. We scanned all companies in production and found 'Hope Community Resources' only with similar issue. See the attached list of incorrect Self Insured Components HopeCommunityIncorrectData.xls . We have corrected all data in this company too. Below are our observation for invoice in 'Hope Community Resources':- Employee: KAREN LESKO Plans: a) CO PAID COBRA Aetna Dental b) CO PAID COBRA VSP Vision c) Company Paid COBRA Aetna Medical HRA 1) In invoice for the month of September for mentioned plan this employee was billed with Zero cost. But according to system data, the the cost shouldn't be Zero. We assume the data has been edited from UI in Invoice. Can you please confirm on this if data has been edited from Invoice UI or not ? If not, we need to find the root cause for zero cost. 2) Due to incorrect data related to Self Insured Components, this employee is getting incorrectly billed in October Invoice(recently generated) for the above three plans. We have made data correction. Please regenerate October invoice to get correct bill. Thank You! Jyoti Agrawal
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            Verified this fix on LB on Venky Hub company. Now the system is giving proper adjustments even if we change self insured component from Non Billable to Billable and vice versa. Also the system is not considering zero for decimal value. Proper entries are being inserted into SelfInsuredRateChanges_Log. This is good to be deployed on Stage.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Verified this fix on LB on Venky Hub company. Now the system is giving proper adjustments even if we change self insured component from Non Billable to Billable and vice versa. Also the system is not considering zero for decimal value. Proper entries are being inserted into SelfInsuredRateChanges_Log. This is good to be deployed on Stage. Thanks, Venkatesh
            Hide
            Kira.Hamilton Kira Hamilton (Inactive) added a comment -

            Hello,

            Per the client:

            Issue: I reviewed Karen Lesko’s billing on the October invoice for Hope.

            We billed:

            a.) CO Paid COBRA Aetna Dental- $53.52
            b.) CO Paid COBRA VSP Vision- $14.00
            c.) Company Paid COBRA Aetna Medical HRA- $41.67

            The Oct. invoice should show the total billed rate for each line of coverage. It is not showing the total for medical or vision.

            Dental is fine.

            The $41.67 for medical is just one component, but the total billed rate is $996.64.

            The $14.00 for vision isn’t one component, nor a sum of other components, the total billed rate is $15.54

            Please ask development to make this correction.

            Also, Since we already finalized October, I believe we would need to run November to see if adjustments appear, correct?-DEV, please advise.

            Thank you,
            Kira Hamilton
            Debbie Kulling

            Show
            Kira.Hamilton Kira Hamilton (Inactive) added a comment - Hello, Per the client: Issue: I reviewed Karen Lesko’s billing on the October invoice for Hope. We billed: a.) CO Paid COBRA Aetna Dental- $53.52 b.) CO Paid COBRA VSP Vision- $14.00 c.) Company Paid COBRA Aetna Medical HRA- $41.67 The Oct. invoice should show the total billed rate for each line of coverage. It is not showing the total for medical or vision. Dental is fine. The $41.67 for medical is just one component, but the total billed rate is $996.64. The $14.00 for vision isn’t one component, nor a sum of other components, the total billed rate is $15.54 Please ask development to make this correction. Also, Since we already finalized October, I believe we would need to run November to see if adjustments appear, correct?-DEV, please advise. Thank you, Kira Hamilton Debbie Kulling
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            Please could you look into the above concern.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Please could you look into the above concern. Thanks, Venkatesh
            Hide
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            Hi Kira Hamilton,

            We will look into this issue tomorrow (9/22).

            Thanks,
            Jyoti Agrawal

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Hi Kira Hamilton , We will look into this issue tomorrow (9/22). Thanks, Jyoti Agrawal
            Hide
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            This is a bug type ticket and we have already given code fix for the issue.
            We have created a new support ticket for all data corrections related to this issue. For further support activity please refer to ticket WT-11228.

            Kira Hamilton,Venkatesh Pujari, Gaurav Sodani Prasanna Karlekar

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - This is a bug type ticket and we have already given code fix for the issue. We have created a new support ticket for all data corrections related to this issue. For further support activity please refer to ticket WT-11228 . Kira Hamilton , Venkatesh Pujari , Gaurav Sodani Prasanna Karlekar
            Hide
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            Hi Venkatesh Pujari,

            I'll look into Kira's concern in new support ticket WT-11228. Hence, assigning this ticket back to you.

            Thank You,
            Jyoti A

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Hi Venkatesh Pujari , I'll look into Kira's concern in new support ticket WT-11228 . Hence, assigning this ticket back to you. Thank You, Jyoti A
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            Verified this fix on Stage on AFI For Hspl company. Now the system is giving proper adjustments even if we change self insured component from Non Billable to Billable and vice versa. Also the system is not considering zero for decimal value. Proper entries are being inserted into SelfInsuredRateChanges_Log.

            This is good to be deployed on Production.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Verified this fix on Stage on AFI For Hspl company. Now the system is giving proper adjustments even if we change self insured component from Non Billable to Billable and vice versa. Also the system is not considering zero for decimal value. Proper entries are being inserted into SelfInsuredRateChanges_Log. This is good to be deployed on Production. Thanks, Venkatesh
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            Verified this fix on Production on AFI For Hspl company. Now the system is giving proper adjustments even if we change self insured component from Non Billable to Billable and vice versa. Also the system is not considering zero for decimal value. Proper entries are being inserted into SelfInsuredRateChanges_Log.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Verified this fix on Production on AFI For Hspl company. Now the system is giving proper adjustments even if we change self insured component from Non Billable to Billable and vice versa. Also the system is not considering zero for decimal value. Proper entries are being inserted into SelfInsuredRateChanges_Log. Thanks, Venkatesh
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Kira Hamilton,

            The issue has been resolved and also deployed on production. It is working as per expectation. Please could you verify and close this ticket if issue does not exists

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Kira Hamilton , The issue has been resolved and also deployed on production. It is working as per expectation. Please could you verify and close this ticket if issue does not exists Thanks, Venkatesh
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            Kira Hamilton Could you please confirm?

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Kira Hamilton Could you please confirm?

              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