[WB-286] El Dorado - missing coverage tier and effective date information on billing details report - Workterra Jira

Details

Type: Bug
Status: Closed
Priority: Medium
Resolution: Bug Fixed
Labels:
None

Environment:

Production
Categories:
Report - Billing
Company:
El Dorado
Reported by:
Support

Dev Estimates:
6
QA Estimates:
6
Sprint:
WT - Sprint 44

Description

When I ran the March 2018 billing details report the attached enrollments had no information in the coverage tier and effective date columns. It could have to do with these being spouse only enrollments. The actual retirees are in different plans due to differences with their spouse in medicare.

Dev can you explain why on the billing details report the coverage tier label doesn't show for enrollments for Spouse only?

Thanks

Attachments

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

Attachments

Affected_Clients_For_Plan.xls
8 kB
15/Feb/18 09:52 AM
Criteria.png
19 kB
04/May/18 01:31 PM
Criteria.png
19 kB
04/May/18 01:31 PM
Life Premium-All PlansLife Premium-All Plans37306_5247.zip
862 kB
07/May/18 04:47 AM

Issue Links

duplicates

WB-1030 Report Data Discrepencies

Closed

relates to

WB-327 Issue with coverage in Billing Summary Report for plans having family rate customization

Closed

WB-1016 AFFCO - Enrollment Report Issues

Closed

WB-1018 Report Inconsistency-

Closed

Activity

Ascending order - Click to sort in descending order

regina johnson (Inactive) created issue - 07/Feb/18 04:32 PM

regina johnson (Inactive) made changes - 07/Feb/18 04:32 PM

Field	Original Value	New Value
Link		This issue causes CT-4128 [ CT-4128 ]

Parmeshwar Jumbad (Inactive) made changes - 08/Feb/18 04:08 AM

Assignee

Satya [ ID10004 ]

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Parmeshwar Jumbad (Inactive) made changes - 08/Feb/18 05:29 AM

Module

Parent values: BenAdmin(10100)

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

Parmeshwar Jumbad (Inactive) made changes - 08/Feb/18 05:47 AM

Status

Open [ 1 ]

In Progress [ 3 ]

Parmeshwar Jumbad (Inactive) made changes - 08/Feb/18 12:48 PM

Time Spent		6.5h [ 23400 ]
Worklog Id		103866 [ 103866 ]

Parmeshwar Jumbad (Inactive) made changes - 08/Feb/18 12:50 PM

Status

In Progress [ 3 ]

Waiting for Customer Input [ 10500 ]

Parmeshwar Jumbad (Inactive) made changes - 08/Feb/18 12:50 PM

Assignee

Parmeshwar Jumbad [ parmeshwar.jumbade ]

regina johnson [ regina.johnson ]

Jennifer Johnson (Inactive) made changes - 14/Feb/18 10:43 PM

Status

Waiting for Customer Input [ 10500 ]

Open [ 1 ]

Jennifer Johnson (Inactive) made changes - 14/Feb/18 10:43 PM

Assignee

regina johnson [ regina.johnson ]

Jackie Sivigny [ jackie.sivigny ]

Parmeshwar Jumbad (Inactive) made changes - 15/Feb/18 09:52 AM

Attachment

Affected_Clients_For_Plan.xls [ 73431 ]

Parmeshwar Jumbad (Inactive) made changes - 15/Feb/18 09:56 AM

Status

Open [ 1 ]

Waiting for Customer Input [ 10500 ]

Parmeshwar Jumbad (Inactive) made changes - 15/Feb/18 09:57 AM

Time Spent	6.5h [ 23400 ]	8h [ 28800 ]
Worklog Id		104708 [ 104708 ]

Parmeshwar Jumbad (Inactive) made changes - 15/Feb/18 10:29 AM

Dev Estimates

Prashant Samal (Inactive) made changes - 15/Feb/18 01:16 PM

Issue Type	Support Activity [ 10301 ]	Bug [ 1 ]
Status	Waiting for Customer Input [ 10500 ]	Open [ 1 ]
Support Task Type	Data Audit [ 18401 ]
Workflow	WT_Support [ 63411 ]	WT_Defects [ 63942 ]

Satya made changes - 21/Feb/18 09:49 AM

Sprint

WT - Sprint 44 [ 10 ]

Hrishikesh Deshpande (Inactive) made changes - 21/Feb/18 11:27 AM

QA		Venkatesh Pujari [ venkatesh.pujari ]
QA Estimates		6

Parmeshwar Jumbad (Inactive) made changes - 21/Feb/18 11:29 AM

Assignee

Jackie Sivigny [ jackie.sivigny ]

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Parmeshwar Jumbad (Inactive) made changes - 21/Feb/18 11:29 AM

Developer

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Parmeshwar Jumbad (Inactive) made changes - 21/Feb/18 11:30 AM

Dev Due Date

28/Feb/2018

Parmeshwar Jumbad (Inactive) made changes - 21/Feb/18 11:33 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Parmeshwar Jumbad (Inactive) made changes - 21/Feb/18 11:33 AM

Item State

Parent values: Development(10200)Level 1 values: On Hold(10207)

Parmeshwar Jumbad (Inactive) made changes - 23/Feb/18 12:39 PM

Item State

Parent values: Development(10200)Level 1 values: On Hold(10207)

Parent values: Development(10200)Level 1 values: In Progress(10206)

Parmeshwar Jumbad (Inactive) made changes - 26/Feb/18 04:55 AM

Time Spent	8h [ 28800 ]	11h [ 39600 ]
Worklog Id		106148 [ 106148 ]

Parmeshwar Jumbad (Inactive) made changes - 01/Mar/18 12:54 PM

Time Spent	11h [ 39600 ]	15.5h [ 55800 ]
Worklog Id		106883 [ 106883 ]

Parmeshwar Jumbad (Inactive) made changes - 01/Mar/18 12:54 PM

Item State

Parent values: Development(10200)Level 1 values: In Progress(10206)

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

Prashant Samal (Inactive) made changes - 03/Mar/18 10:16 AM

Categories		Parent values: Report(18507)
Key	~~WT-13301~~	~~WB-286~~
Project	WORKTERRA [ 10000 ]	Workterra BenAdmin [ 11501 ]
Workflow	WT_Defects [ 63942 ]	WB: Bugs Project Management Workflow [ 65080 ]

Parmeshwar Jumbad (Inactive) made changes - 07/Mar/18 12:54 PM

Time Spent	15.5h [ 55800 ]	23h [ 82800 ]
Worklog Id		107410 [ 107410 ]

Jennifer Reed (Inactive) made changes - 07/Mar/18 07:55 PM

Categories

Parent values: Report(18507)

Parent values: Report(18507)Level 1 values: Billing(18515)

Prashant Samal (Inactive) made changes - 08/Mar/18 08:40 AM

Workflow

WB: Bugs Project Management Workflow [ 65080 ]

0803 Copy of WB: Bugs Project Management Workflow [ 65744 ]

Parmeshwar Jumbad (Inactive) made changes - 14/Mar/18 12:23 PM

Assignee

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Sachin Hingole [ sachin.hingole ]

Prasad Pise (Inactive) made changes - 16/Mar/18 01:05 PM

Assignee

Sachin Hingole [ sachin.hingole ]

Venkatesh Pujari [ venkatesh.pujari ]

Prasad Pise (Inactive) made changes - 16/Mar/18 01:05 PM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Venkatesh Pujari (Inactive) made changes - 19/Mar/18 01:00 PM

Time Spent	23h [ 82800 ]	27h [ 97200 ]
Worklog Id		108953 [ 108953 ]

Prashant Samal (Inactive) made changes - 22/Mar/18 07:07 AM

Workflow

0803 Copy of WB: Bugs Project Management Workflow [ 65744 ]

2203 WB: Bugs Project Management Workflow [ 66896 ]

Prashant Samal (Inactive) made changes - 06/Apr/18 04:28 AM

Workflow

2203 WB: Bugs Project Management Workflow [ 66896 ]

0604 Issues Management Workflow [ 68262 ]

Sachin Hingole (Inactive) made changes - 09/Apr/18 11:02 PM

Link

This issue relates to ~~WB-327~~ [ ~~WB-327~~ ]

Sachin Hingole (Inactive) made changes - 09/Apr/18 11:02 PM

Status

In LB Testing [ 10200 ]

LB Testing ON HOLD [ 11609 ]

Rakesh Roy (Inactive) made changes - 13/Apr/18 02:00 AM

Status

LB Testing ON HOLD [ 11609 ]

In LB Testing [ 10200 ]

Rakesh Roy (Inactive) made changes - 13/Apr/18 02:00 AM

Status

In LB Testing [ 10200 ]

LB Testing ON HOLD [ 11609 ]

Venkatesh Pujari (Inactive) made changes - 25/Apr/18 09:11 PM

Status

LB Testing ON HOLD [ 11609 ]

In LB Testing [ 10200 ]

Venkatesh Pujari (Inactive) made changes - 25/Apr/18 09:11 PM

Status

In LB Testing [ 10200 ]

Ready for Pre-Prod [ 11615 ]

Venkatesh Pujari (Inactive) made changes - 25/Apr/18 09:12 PM

Status

Ready for Pre-Prod [ 11615 ]

Pre-Prod Deployed [ 11601 ]

Venkatesh Pujari (Inactive) made changes - 25/Apr/18 11:37 PM

Status

Pre-Prod Deployed [ 11601 ]

IN Pre-prod Testing [ 11500 ]

Venkatesh Pujari (Inactive) made changes - 25/Apr/18 11:44 PM

Assignee	Venkatesh Pujari [ venkatesh.pujari ]	Amruta Lohiya [ amruta.baheti ]
Status	IN Pre-prod Testing [ 11500 ]	REOPENED IN PRE-PROD [ 11603 ]

Venkatesh Pujari (Inactive) made changes - 25/Apr/18 11:45 PM

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

Jyoti Agrawal (Inactive) made changes - 30/Apr/18 02:49 AM

Link

This issue relates to ~~WB-1018~~ [ ~~WB-1018~~ ]

Jyoti Agrawal (Inactive) made changes - 30/Apr/18 02:51 AM

Link

This issue relates to ~~WB-1016~~ [ ~~WB-1016~~ ]

Prashant Samal (Inactive) made changes - 30/Apr/18 08:41 AM

Link

This issue duplicates ~~WB-1030~~ [ ~~WB-1030~~ ]

Tiquanna (Inactive) made changes - 01/May/18 01:10 PM

Link

This issue is blocked by CT-4720 [ CT-4720 ]

Venkatesh Pujari (Inactive) made changes - 02/May/18 12:34 AM

Time Spent	30h [ 108000 ]	31h [ 111600 ]
Worklog Id	114879 [ 114879 ]

Tiquanna (Inactive) made changes - 03/May/18 02:53 PM

Link

This issue is blocked by CT-4763 [ CT-4763 ]

darryn.carter made changes - 04/May/18 10:46 AM

Link

This issue relates to CT-4771 [ CT-4771 ]

darryn.carter made changes - 04/May/18 11:07 AM

Link

This issue relates to CT-4758 [ CT-4758 ]

Tiquanna (Inactive) made changes - 04/May/18 01:31 PM

Attachment		Criteria.png [ 77441 ]
Attachment		Criteria.png [ 77442 ]

Amruta Lohiya made changes - 06/May/18 11:08 PM

Assignee

Amruta Lohiya [ amruta.baheti ]

Jyoti Agrawal [ jyoti.agrawal ]

Sachin Hingole (Inactive) made changes - 07/May/18 04:26 AM

Time Spent	31h [ 111600 ]	32h [ 115200 ]
Worklog Id	115141 [ 115141 ]

Jyoti Agrawal (Inactive) made changes - 07/May/18 04:47 AM

Attachment

Life Premium-All PlansLife Premium-All Plans37306_5247.zip [ 77481 ]

Jyoti Agrawal (Inactive) made changes - 08/May/18 12:23 AM

Status

REOPENED IN PRE-PROD [ 11603 ]

In Development [ 10007 ]

Jyoti Agrawal (Inactive) made changes - 08/May/18 12:24 AM

Status

In Development [ 10007 ]

LB Deployed [ 11600 ]

Jyoti Agrawal (Inactive) made changes - 08/May/18 12:24 AM

Status

LB Deployed [ 11600 ]

In LB Testing [ 10200 ]

Jyoti Agrawal (Inactive) made changes - 08/May/18 12:24 AM

Status

In LB Testing [ 10200 ]

Ready for Pre-Prod [ 11615 ]

Jyoti Agrawal (Inactive) made changes - 08/May/18 12:24 AM

Status

Ready for Pre-Prod [ 11615 ]

Pre-Prod Deployed [ 11601 ]

Jyoti Agrawal (Inactive) made changes - 08/May/18 12:27 AM

Assignee

Jyoti Agrawal [ jyoti.agrawal ]

Venkatesh Pujari [ venkatesh.pujari ]

Venkatesh Pujari (Inactive) made changes - 08/May/18 12:55 AM

Status

Pre-Prod Deployed [ 11601 ]

IN Pre-prod Testing [ 11500 ]

Venkatesh Pujari (Inactive) made changes - 08/May/18 02:20 AM

Status

IN Pre-prod Testing [ 11500 ]

Ready for Production [ 10024 ]

Venkatesh Pujari (Inactive) made changes - 08/May/18 02:20 AM

Status

Ready for Production [ 10024 ]

Production Deployed [ 10025 ]

Venkatesh Pujari (Inactive) made changes - 08/May/18 02:20 AM

Status

Production Deployed [ 10025 ]

In Production Testing [ 10202 ]

Venkatesh Pujari (Inactive) made changes - 08/May/18 02:45 AM

Assignee	Venkatesh Pujari [ venkatesh.pujari ]	Monika Demla [ monika.demla ]
Resolution		Bug Fixed [ 10402 ]
Status	In Production Testing [ 10202 ]	In Production Review [ 11501 ]

Venkatesh Pujari (Inactive) made changes - 08/May/18 02:46 AM

Time Spent	32h [ 115200 ]	32h 40m [ 117600 ]
Worklog Id	115291 [ 115291 ]

Jyoti Agrawal (Inactive) made changes - 08/May/18 05:11 AM

Time Spent	32h 40m [ 117600 ]	36h 40m [ 132000 ]
Worklog Id	115317 [ 115317 ]

Monika Demla (Inactive) made changes - 08/May/18 11:40 AM

Assignee

Monika Demla [ monika.demla ]

Tiquanna [ tiquanna ]

Tiquanna (Inactive) made changes - 08/May/18 12:44 PM

Assignee

Tiquanna [ tiquanna ]

Monika Demla [ monika.demla ]

Monika Demla (Inactive) made changes - 08/May/18 01:08 PM

Assignee

Monika Demla [ monika.demla ]

Venkatesh Pujari [ venkatesh.pujari ]

Venkatesh Pujari (Inactive) made changes - 08/May/18 09:18 PM

Assignee

Venkatesh Pujari [ venkatesh.pujari ]

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Venkatesh Pujari (Inactive) made changes - 08/May/18 09:19 PM

Time Spent	36h 40m [ 132000 ]	37h [ 133200 ]
Worklog Id	115378 [ 115378 ]

Venkatesh Pujari (Inactive) made changes - 09/May/18 03:24 AM

Time Spent	37h [ 133200 ]	37h 20m [ 134400 ]
Worklog Id	115378 [ 115378 ]

Parmeshwar Jumbad (Inactive) made changes - 09/May/18 10:54 PM

Assignee

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Venkatesh Pujari [ venkatesh.pujari ]

Parmeshwar Jumbad (Inactive) made changes - 09/May/18 10:56 PM

Time Spent	37h 20m [ 134400 ]	40h 20m [ 145200 ]
Worklog Id	115537 [ 115537 ]

Hrishikesh Deshpande (Inactive) made changes - 16/May/18 02:55 AM

Assignee

Venkatesh Pujari [ venkatesh.pujari ]

Hrishikesh Deshpande [ hrishikesh.deshpande ]

Hrishikesh Deshpande (Inactive) made changes - 16/May/18 03:23 AM

Assignee

Hrishikesh Deshpande [ hrishikesh.deshpande ]

Venkatesh Pujari [ venkatesh.pujari ]

Venkatesh Pujari (Inactive) made changes - 16/May/18 08:19 AM

Time Spent	40h 20m [ 145200 ]	40h 35m [ 146100 ]
Worklog Id	116236 [ 116236 ]

Venkatesh Pujari (Inactive) made changes - 16/May/18 08:21 AM

Assignee

Venkatesh Pujari [ venkatesh.pujari ]

Tiquanna [ tiquanna ]

Tiquanna (Inactive) made changes - 16/May/18 08:31 AM

Status

In Production Review [ 11501 ]

Closed [ 6 ]

People

Assignee:: Tiquanna (Inactive)

Reporter:: regina johnson (Inactive)

Developer:: Parmeshwar Jumbad (Inactive)

QA:: Venkatesh Pujari (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 12 Start watching this issue

Dates

Created:: 07/Feb/18 04:32 PM

Updated:: 16/May/18 08:31 AM

Resolved:: 08/May/18 02:45 AM

Dev Due Date:: 28/Feb/2018

Time Tracking

Estimated:

Remaining:

Logged:

40h 35m