I want two new reports. I want them to come in excel.
The first is a COBRA report – this should list all COBRA eligible changes that have occurred for a an employee or their dependents. It should list the name of the employee – the name of the dependent if applicable – and all benefits that the lost eligibility for. This will help with manual reporting of COBRA eligible changes – loss of eligibility, termination, etc.
The second is just a list of what has changed – this would be similar to the add/change/term report but it should only be benefit related. It should list every change to benefits – coverage – add or termed – dependents added or termed – it should also list any address changes- this is the only change that is not benefits related that should be included.
- is blocked by
-
WT-3089 LB:- Change class/status throwing server error on For QA LB Austin Ind company.
-
- Closed
-
Field | Original Value | New Value |
---|---|---|
Assignee | Satya [ ID10004 ] | Amnesh Goel [ amnesh.goel ] |
Account Executive | Amnesh Goel [ amnesh.goel ] | David Rhodes [Administrator] [ admin ] |
Item State | Parent values: Development(10200)Level 1 values: Development Backlog(10205) |
Fix Version/s | 1.0 [ 10000 ] |
Rank | Ranked lower |
Sprint | WT Sprint 1 [ 6 ] |
Rank | Ranked higher |
Status | New Request [ 10029 ] | Pending for Approval [ 10002 ] |
Status | Pending for Approval [ 10002 ] | Approved for Development [ 10003 ] |
Status | Approved for Development [ 10003 ] | In Development [ 10007 ] |
Item State | Parent values: Development(10200)Level 1 values: Development Backlog(10205) | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
Assignee | Amnesh Goel [ amnesh.goel ] | Jyoti Agrawal [ jyoti.agrawal ] |
Summary | new reports : to come in excel | Cobra new reports : to come in excel |
Summary | Cobra new reports : to come in excel | Cobra new reports : to come in excel (In Analysis) |
Dev Due Date | 21/Apr/2016 | |
Dev Estimates | 16 |
Sprint | WT Sprint 1 [ 6 ] | WT Sprint 2 [ 7 ] |
Rank | Ranked higher |
Summary | Cobra new reports : to come in excel (In Analysis) | Cobra new reports : to come in excel |
Dev Due Date | 21/Apr/2016 | 04/May/2016 |
Dev Estimates | 16 | 50 |
Attachment | COBRA Report Analysis.doc [ 16308 ] |
Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Development(10200)Level 1 values: In Progress(10206) |
Sprint | WT Sprint 2 [ 7 ] | WT Sprint 3 [ 8 ] |
Rank | Ranked lower |
Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: Development(10200)Level 1 values: On Hold(10207) |
Sprint | WT Sprint 3 [ 8 ] | WT Sprint 4 [ 9 ] |
Rank | Ranked lower |
Item State | Parent values: Development(10200)Level 1 values: On Hold(10207) | Parent values: Development(10200)Level 1 values: In Progress(10206) |
Issue Importance | Must Have [ 11800 ] |
Sprint | WT Sprint 4 [ 9 ] | WT Sprint 3 [ 8 ] |
Rank | Ranked higher |
Dev Due Date | 04/May/2016 | 09/May/2016 |
Dev Due Date | 09/May/2016 | 23/May/2016 |
Sprint | WT Sprint 3 [ 8 ] | WT Sprint 4 [ 9 ] |
Rank | Ranked lower |
Dev Estimates | 50 | 4 |
Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
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) |
Assignee | Jyoti Agrawal [ jyoti.agrawal ] | Deepali Tidke [ deepalit ] |
Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
QA Estimates | 16 |
Assignee | Deepali Tidke [ deepalit ] | Aditya Vishwakarma [ aditya.vishwakarma ] |
Issue Importance | Must Have [ 11800 ] | Must Have 25 [ 12200 ] |
Issue Importance | Must Have 25 [ 12200 ] | Must have Additional [ 12201 ] |
Assignee | Aditya Vishwakarma [ aditya.vishwakarma ] | Deepali Tidke [ deepalit ] |
Attachment | COBRA_Term_Report.xls [ 19710 ] |
Assignee | Deepali Tidke [ deepalit ] | Venkatesh Pujari [ venkatesh.pujari ] |
Assignee | Venkatesh Pujari [ venkatesh.pujari ] | Jyoti Agrawal [ jyoti.agrawal ] |
Sprint | WT Sprint 4 [ 9 ] | WT Sprint 7 [ 20 ] |
Rank | Ranked higher |
Assignee | Jyoti Agrawal [ jyoti.agrawal ] | Venkatesh Pujari [ venkatesh.pujari ] |
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
Developer | Jyoti Agrawal [ jyoti.agrawal ] |
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) |
Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
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) |
Status | Local Testing [ 10200 ] | Pending for Stage Approval [ 10300 ] |
Status | Pending for Stage Approval [ 10300 ] | Approved for Stage [ 10030 ] |
Status | Approved for Stage [ 10030 ] | Stage Testing [ 10201 ] |
Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
Status | Stage Testing [ 10201 ] | Pending for Production Approval [ 10301 ] |
Status | Pending for Production Approval [ 10301 ] | Approved for production [ 10034 ] |
Status | Approved for production [ 10034 ] | Production Testing [ 10202 ] |
Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production QA(10203)Level 1 values: Re-open(10220) |
Status | Production Testing [ 10202 ] | Reopen in Production [ 10027 ] |
Assignee | Venkatesh Pujari [ venkatesh.pujari ] | Jyoti Agrawal [ jyoti.agrawal ] |
Status | Reopen in Production [ 10027 ] | In Development [ 10007 ] |
Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Status | Local Testing [ 10200 ] | Pending for Stage Approval [ 10300 ] |
Status | Pending for Stage Approval [ 10300 ] | Approved for Stage [ 10030 ] |
Status | Approved for Stage [ 10030 ] | Stage Testing [ 10201 ] |
Status | Stage Testing [ 10201 ] | Pending for Production Approval [ 10301 ] |
Status | Pending for Production Approval [ 10301 ] | Approved for production [ 10034 ] |
Assignee | Jyoti Agrawal [ jyoti.agrawal ] | Venkatesh Pujari [ venkatesh.pujari ] |
Item State | Parent values: Production QA(10203)Level 1 values: Re-open(10220) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
Status | Approved for production [ 10034 ] | Production Testing [ 10202 ] |
Resolution | Done [ 10000 ] | |
Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
Resolution | Done [ 10000 ] | Fixed [ 1 ] |
Status | Production Complete [ 10028 ] | Closed [ 6 ] |
Transition | Time In Source Status | Execution Times |
---|
|
5d 21h 23m | 1 |
|
2s | 1 |
|
2s | 1 |
|
2h 42m | 1 |
|
2h 53m | 1 |
|
43d 7h 37m | 2 |
|
48d 18h 52m | 2 |
|
4s | 2 |
|
1m 2s | 2 |
|
3d 23h 59m | 2 |
|
8s | 2 |
|
19h 14m | 2 |
|
15s | 1 |
|
1m 33s | 1 |
Hi Amnesh,
As discussed with Dave, below two reports will be generic enhancement across all clients.
Please add this task to development queue & will schedule on priority.
Thanks & Regards,
Satya Prakash