Hi Kira Hamilton,

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

Thanks,
Jyoti Agrawal

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

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

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

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

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

Hi Jyoti Agrawal,

Please could you look into the above concern.

Thanks,
Venkatesh

Hi Kira Hamilton,

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

Thanks,
Jyoti Agrawal

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

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

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

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

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

Kira Hamilton Could you please confirm?