[WT-11244] County of Sutter-Invoice Adjustment Errors - Workterra Jira

Details

Type: Bug
Status: Production Complete
Priority: Medium
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:
Client
Company:
County of Sutter
Item State:
Production Complete - Closed
Sprint:
WT Sprint 38 - Bugs

Dev Estimates:
23
Code Reviewed By:

Prasanna Karlekar

Description

Hello,

Per the client: County of Sutter has notified BCC they are having an issue with the billing adjustments on their August invoice (please see attached).

We have looked into the issue with Harminder Dosanjh:
1.       Beginning May 1, 2017 when BCC begins administration of COSR, Employee is enrolled in the Anthem PPO 500 plan as Employee + 1 Child (Rate $1,463.00)
2.       On June 20, 2017 QE Add Newborn occurs, takes the Anthem PPO 500 plan enrollment to Employee + 2 Children (Rate $2,072.00)
3.       Billing rule is Free In/Pay Out and is built in the Billing Period Policies on the General Plan Design page as follows:
a.       Billing Period Adds = Premiums Waived After the Cut-Off Day; Day of Billing Period = 1
b.      Billing Period Changes/Terminations = Bill for Entire Month; Day of Billing Period = 0
4.       The August invoice incorrectly credits the June premium.
5.       The August invoice does correctly credit and bill the July adjustments
6.       The August invoice does correctly bill for the month of August

       Kenya Olivas is having the exact same issue as Harminder Dosanjh
a.       EE has been effective since 5/1/17 on the Anthem PPO 1000 plan with EE + SP + 2+ Children on the plan (Rate $1,698.00)
b.      On 6/23/17 QE Add Newborn was initiated for a baby born 5/24/17. This has no effect on the enrollment level as the EE already has 2+ Children on the plan
c.       Billing rule is Free In/Pay Out and is built in the Billing Period Policies on the General Plan Design page as follows:
i.      Billing Period Adds = Premiums Waived After the Cut-Off Day; Day of Billing Period = 1
    ii.      Billing Period Changes/Terminations = Bill for Entire Month; Day of Billing Period = 0
d.      The August invoice incorrectly credits the May premium
e.      The August invoice does correctly credit and bill the June and July adjustments
f.        The August invoice does correctly bill for the month of August

Could you please have your development team look into this ASAP, the group is extremely unhappy with their invoices.

Thank you,
Kira
Debbie Kulling

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

20170921 COSR August Monthly Invoice.xlsx
655 kB
22/Sep/17 04:07 PM

Issue Links

causes

WT-11691 City of SeaTac-November Invoice

Production Complete

is cloned by

NF-5137 County of Sutter-Invoice Adjustment Errors

Closed

Activity

Ascending order - Click to sort in descending order

Kira Hamilton (Inactive) created issue - 22/Sep/17 04:08 PM

Satya made changes - 23/Sep/17 05:48 AM

Field	Original Value	New Value
Assignee	Vijay Siddha [ vijays ]	Prasanna Karlekar [ prasanna ]

Prasanna Karlekar (Inactive) made changes - 23/Sep/17 01:00 PM

Status

Open [ 1 ]

In Development [ 10007 ]

Jyoti Agrawal (Inactive) made changes - 25/Sep/17 12:33 PM

Dev Due Date		28/Sep/2017
Dev Estimates		23
Sprint		WT Sprint 38 - Bugs [ 89 ]

Jyoti Agrawal (Inactive) made changes - 25/Sep/17 01:14 PM

Remaining Estimate		0h [ 0 ]
Time Spent		5h [ 18000 ]
Worklog Id		81124 [ 81124 ]

Jyoti Agrawal (Inactive) made changes - 26/Sep/17 04:46 AM

Assignee

Prasanna Karlekar [ prasanna ]

Jyoti Agrawal [ jyoti.agrawal ]

Prasanna Karlekar (Inactive) made changes - 26/Sep/17 05:08 AM

Time Spent	5h [ 18000 ]	5.75h [ 20700 ]
Worklog Id		81236 [ 81236 ]

Rakesh Roy (Inactive) made changes - 26/Sep/17 06:40 AM

Environment		Production [ 10005 ]
Original Estimate		0h [ 0 ]

Rakesh Roy (Inactive) made changes - 26/Sep/17 07:18 AM

Module

Parent values: BenAdmin(10100)

Parent values: BenAdmin(10100)Level 1 values: Report(10109)

Prasanna Karlekar (Inactive) made changes - 26/Sep/17 11:29 AM

Time Spent	5.75h [ 20700 ]	10.75h [ 38700 ]
Worklog Id		81442 [ 81442 ]

Jyoti Agrawal (Inactive) made changes - 26/Sep/17 01:12 PM

Time Spent	10.75h [ 38700 ]	17.75h [ 63900 ]
Worklog Id		81694 [ 81694 ]

Jyoti Agrawal (Inactive) made changes - 27/Sep/17 09:21 AM

Developer

Prasanna Karlekar [ prasanna ]

Jyoti Agrawal [ jyoti.agrawal ]

Jyoti Agrawal (Inactive) made changes - 27/Sep/17 09:21 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Jyoti Agrawal (Inactive) made changes - 27/Sep/17 01:07 PM

Time Spent	17.75h [ 63900 ]	21.75h [ 78300 ]
Worklog Id		81949 [ 81949 ]

Jyoti Agrawal (Inactive) made changes - 28/Sep/17 04:53 AM

Code Review Date		27/Sep/2017
Code Reviewed By		Prasanna Karlekar [ 11907 ]

Prasanna Karlekar (Inactive) made changes - 28/Sep/17 05:32 AM

Time Spent	21.75h [ 78300 ]	22.75h [ 81900 ]
Worklog Id		82087 [ 82087 ]

Prasanna Karlekar (Inactive) made changes - 28/Sep/17 06:16 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)

Khandu Kshirsagar (Inactive) made changes - 28/Sep/17 11:41 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Jyoti Agrawal (Inactive) made changes - 28/Sep/17 11:59 AM

Assignee

Jyoti Agrawal [ jyoti.agrawal ]

Sachin Hingole [ sachin.hingole ]

Sachin Hingole (Inactive) made changes - 28/Sep/17 12:21 PM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Sachin Hingole (Inactive) made changes - 28/Sep/17 12:23 PM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Sachin Hingole (Inactive) made changes - 28/Sep/17 12:23 PM

Assignee

Sachin Hingole [ sachin.hingole ]

Amita Sangani [ amita.sangani ]

Kira Hamilton (Inactive) made changes - 28/Sep/17 04:39 PM

Company

County of Sutter [ 18405 ]

Prasanna Karlekar (Inactive) made changes - 29/Sep/17 11:42 AM

Time Spent	22.75h [ 81900 ]	23.25h [ 83700 ]
Worklog Id		82736 [ 82736 ]

Prasanna Karlekar (Inactive) made changes - 29/Sep/17 11:46 AM

Time Spent	23.25h [ 83700 ]	23.5h [ 84600 ]
Worklog Id		82742 [ 82742 ]

Prasanna Karlekar (Inactive) made changes - 29/Sep/17 11:50 AM

Time Spent	23.5h [ 84600 ]	26h [ 93600 ]
Worklog Id		82752 [ 82752 ]

Amita Sangani (Inactive) made changes - 29/Sep/17 12:39 PM

Time Spent	26h [ 93600 ]	27h [ 97200 ]
Worklog Id		82803 [ 82803 ]

Rakesh Roy (Inactive) made changes - 29/Sep/17 02:43 PM

Amita Sangani [ amita.sangani ]

Amita Sangani (Inactive) made changes - 04/Oct/17 12:40 PM

Time Spent	27h [ 97200 ]	30h [ 108000 ]
Worklog Id		83200 [ 83200 ]

Amita Sangani (Inactive) made changes - 04/Oct/17 12:45 PM

Time Spent	30h [ 108000 ]	33.3h [ 119880 ]
Worklog Id		83205 [ 83205 ]

Amita Sangani (Inactive) made changes - 04/Oct/17 12:47 PM

Remaining Estimate	0h [ 0 ]	3h [ 10800 ]
Time Spent	33.3h [ 119880 ]	30.3h [ 109080 ]
Worklog Id	83200 [ 83200 ]
Worklog Time Spent	3h [ 10800 ]

Amita Sangani (Inactive) made changes - 05/Oct/17 12:14 PM

Assignee

Amita Sangani [ amita.sangani ]

Venkatesh Pujari [ venkatesh.pujari ]

Venkatesh Pujari (Inactive) made changes - 05/Oct/17 07:05 PM

Remaining Estimate	3h [ 10800 ]	1h [ 3600 ]
Time Spent	30.3h [ 109080 ]	32.3h [ 116280 ]
Worklog Id		83453 [ 83453 ]

Venkatesh Pujari (Inactive) made changes - 06/Oct/17 09:24 PM

Status

Local Testing [ 10200 ]

Reopen in Local [ 10018 ]

Venkatesh Pujari (Inactive) made changes - 06/Oct/17 09:24 PM

Assignee

Venkatesh Pujari [ venkatesh.pujari ]

Jyoti Agrawal [ jyoti.agrawal ]

Venkatesh Pujari (Inactive) made changes - 06/Oct/17 09:24 PM

Remaining Estimate	1h [ 3600 ]	0h [ 0 ]
Time Spent	32.3h [ 116280 ]	33.3h [ 119880 ]
Worklog Id		83736 [ 83736 ]

Venkatesh Pujari (Inactive) made changes - 06/Oct/17 09:24 PM

Item State

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

Venkatesh Pujari (Inactive) made changes - 09/Oct/17 07:46 AM

Comment

[ Hi [~jyoti.agrawal],

I have started testing this on LB on For QA ASML company. I think there exists some issue after your fix also. Please find the below mentioned scenario and do revert if anything is wrong here :-

1] *Rate Name* :- Billed Rate (01/01/2017 to 12/31/2017 )
   *Health Tier* :- EE+2+Children --> billed rate value = 200

    *Plan Name* :- Venky Gold
    *Add Policy* :- Bill for entire month
    *Term Policy* :- Bill for entire month

     *Enrollment details:-*
     1] Edit an employee who has 3 children. Now enroll this EE in Venky Gold plan effective from 10/01/2017 with tier as EE+2+Children. That is enrollment in Venky Gold plan is with Employee and 2 children. Now generate the invoice for the Oct 2017 month. Proper details are displayed on the invoice.
     2] Now in the month of Oct 2017 I changed the billed rate value of Billed Rate rate to 400. Next I again edit the EE which I had enrolled in Venky Gold plan and change the coverage with effective date as 10/16/2017. Here only the 3rd child is added to the enrollment but the health tier id remains the same.
     3] Now I generate the invoice for the month of Nov 2017. Here the details which are displayed have a missing record that is the new billed rate being charged for the Oct month. Only the returns of the old charged value is displayed. And also the new billed rate value charged for Nov 2017 are displayed.

So as per my understanding there exists some issue. Please could you look into this and reassign this ticket once verified.

[~prasanna],[~sachin.hingole],[~amita.sangani]

Thanks,
Venkatesh



]

Venkatesh Pujari (Inactive) made changes - 09/Oct/17 08:28 AM

Item State

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Venkatesh Pujari (Inactive) made changes - 09/Oct/17 08:28 AM

Status

Reopen in Local [ 10018 ]

In Development [ 10007 ]

Venkatesh Pujari (Inactive) made changes - 09/Oct/17 08:28 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Venkatesh Pujari (Inactive) made changes - 09/Oct/17 10:20 AM

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)

Venkatesh Pujari (Inactive) made changes - 09/Oct/17 10:20 AM

Time Spent	33.3h [ 119880 ]	35.3h [ 127080 ]
Worklog Id		83856 [ 83856 ]

Khandu Kshirsagar (Inactive) made changes - 10/Oct/17 06:23 AM

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)

Jyoti Agrawal (Inactive) made changes - 10/Oct/17 06:45 AM

Assignee

Jyoti Agrawal [ jyoti.agrawal ]

Venkatesh Pujari [ venkatesh.pujari ]

Venkatesh Pujari (Inactive) made changes - 10/Oct/17 01:28 PM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Venkatesh Pujari (Inactive) made changes - 10/Oct/17 01:28 PM

Item State

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Venkatesh Pujari (Inactive) made changes - 10/Oct/17 02:38 PM

Time Spent	35.3h [ 127080 ]	36.3h [ 130680 ]
Worklog Id		84223 [ 84223 ]

Venkatesh Pujari (Inactive) made changes - 12/Oct/17 12:57 PM

Time Spent	36.3h [ 130680 ]	36.8h [ 132480 ]
Worklog Id		84590 [ 84590 ]

Venkatesh Pujari (Inactive) made changes - 12/Oct/17 12:57 PM

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)

Jyoti Agrawal (Inactive) made changes - 13/Oct/17 01:23 PM

Time Spent	36.8h [ 132480 ]	38.8h [ 139680 ]
Worklog Id		84945 [ 84945 ]

Venkatesh Pujari (Inactive) made changes - 14/Oct/17 10:55 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Venkatesh Pujari (Inactive) made changes - 14/Oct/17 10:56 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Parent values: Production Complete(10222)Level 1 values: Closed(10223)

Venkatesh Pujari (Inactive) made changes - 14/Oct/17 10:57 AM

Assignee	Venkatesh Pujari [ venkatesh.pujari ]	Kira Hamilton [ kira.hamilton ]
Resolution		Fixed [ 1 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Venkatesh Pujari (Inactive) made changes - 14/Oct/17 10:58 AM

Time Spent	38.8h [ 139680 ]	39.8h [ 143280 ]
Worklog Id		85087 [ 85087 ]

Ashwin Wankhede (Inactive) made changes - 14/Oct/17 12:31 PM

Item State

Parent values: Production Complete(10222)Level 1 values: Closed(10223)

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Rakesh Roy (Inactive) made changes - 16/Oct/17 01:07 PM

Item State

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Parent values: Production Complete(10222)Level 1 values: Closed(10223)

Prasanna Karlekar (Inactive) made changes - 19/Oct/17 11:15 AM

Link

This issue causes ~~WT-11691~~ [ ~~WT-11691~~ ]

Prasanna Karlekar (Inactive) made changes - 26/Oct/17 06:46 AM

Time Spent	39.8h [ 143280 ]	43.3h [ 155880 ]
Worklog Id		86540 [ 86540 ]

Satya made changes - 04/Nov/17 06:35 AM

Environment_New

Production [ 18442 ]

Jyoti Agrawal (Inactive) made changes - 23/Nov/17 06:42 AM

Link

This issue is cloned by ~~NF-5137~~ [ ~~NF-5137~~ ]

People

Assignee:: Kira Hamilton (Inactive)

Reporter:: Kira Hamilton (Inactive)

Account Executive:: Debbie Kulling

Developer:: Jyoti Agrawal (Inactive)

QA:: Amita Sangani (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 22/Sep/17 04:08 PM

Updated:: 23/Nov/17 06:42 AM

Resolved:: 14/Oct/17 10:57 AM

Dev Due Date:: 28/Sep/2017

Code Review Date:: 27/Sep/2017

Time Tracking

Estimated:

Remaining:

Logged:

43.3h