[WT-1719] Cobra new reports : to come in excel - Workterra Jira

Details

Type: Enhancement
Status: Closed
Priority: Medium
Resolution: Done
Affects Version/s: None
Fix Version/s: 1.0
Component/s: BenAdmin
Labels:
None

Module:
BenAdmin - Report
Reported by:
Support
Item State:
Production Complete - Closed
Issue Importance:
Must have Additional
Sprint:
WT Sprint 7

Dev Estimates:
4
QA Estimates:
16

Description

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.

Attachments

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

Attachments

COBRA_Term_Report.xls
14 kB
15/Jun/16 05:43 AM
COBRA Report Analysis.doc
67 kB
26/Apr/16 10:57 AM

Issue Links

is blocked by

WT-3089 LB:- Change class/status throwing server error on For QA LB Austin Ind company.

Closed

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

Satya added a comment - 07/Apr/16 07:18 AM

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

Show

Satya added a comment - 07/Apr/16 07:18 AM 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

Hide

Permalink

Jyoti Agrawal (Inactive) added a comment - 20/Apr/16 02:54 AM

These are the estimates for analysis only. We will update this ticket for development estimates once analysis is over. Also we are only working on COBRA term report and not on ACT as of now.
However ACT will be taken into consideration after this development.

Show

Jyoti Agrawal (Inactive) added a comment - 20/Apr/16 02:54 AM These are the estimates for analysis only. We will update this ticket for development estimates once analysis is over. Also we are only working on COBRA term report and not on ACT as of now. However ACT will be taken into consideration after this development.

Hide

Permalink

Jyoti Agrawal (Inactive) added a comment - 27/Apr/16 01:31 PM

Keeping in hold this enhancement due to priority task of including Provider Details on Column Wise Billing Details Report

Show

Jyoti Agrawal (Inactive) added a comment - 27/Apr/16 01:31 PM Keeping in hold this enhancement due to priority task of including Provider Details on Column Wise Billing Details Report

Hide

Permalink

Priya Dhamande (Inactive) added a comment - 03/May/16 06:34 AM

Test cases for the enhancement are updated on TestLink under the Workterra > Benadmin > Cobra_Term_Report.

Thanks

Show

Priya Dhamande (Inactive) added a comment - 03/May/16 06:34 AM Test cases for the enhancement are updated on TestLink under the Workterra > Benadmin > Cobra_Term_Report. Thanks

Hide

Permalink

shyam sharma (Inactive) added a comment - 23/May/16 12:41 PM

Development has been completed and only deployment is remaining
estimated efforts for deployment in sprint 4 will be 4 hours.
In sprint 3 development efforts = 46

Show

shyam sharma (Inactive) added a comment - 23/May/16 12:41 PM Development has been completed and only deployment is remaining estimated efforts for deployment in sprint 4 will be 4 hours. In sprint 3 development efforts = 46

Hide

Permalink

Deepali Tidke (Inactive) added a comment - 27/May/16 11:38 AM

Once on LB reports issue is fixed , can start testing enhancement.

As per discussion with Aditya Vishwakarma replication on LB will be up by Monday 30 May

Show

Deepali Tidke (Inactive) added a comment - 27/May/16 11:38 AM Once on LB reports issue is fixed , can start testing enhancement. As per discussion with Aditya Vishwakarma replication on LB will be up by Monday 30 May

Hide

Permalink

Aditya Vishwakarma (Inactive) added a comment - 27/May/16 12:33 PM

I am trying to fix replication on LB. I will try to make it up by Tuesday 31 May EOD , but still its kind of Hit and trial method so date may get delayed as I am not sure exact cause of this issue yet.

Show

Aditya Vishwakarma (Inactive) added a comment - 27/May/16 12:33 PM I am trying to fix replication on LB. I will try to make it up by Tuesday 31 May EOD , but still its kind of Hit and trial method so date may get delayed as I am not sure exact cause of this issue yet.

Hide

Permalink

Rakesh Roy (Inactive) added a comment - 31/May/16 05:45 AM

Aditya Vishwakarma Please update.

Show

Rakesh Roy (Inactive) added a comment - 31/May/16 05:45 AM Aditya Vishwakarma Please update.

Hide

Permalink

Aditya Vishwakarma (Inactive) added a comment - 31/May/16 06:36 AM

Rakesh Roy Not Yet able to find root cause , still working on it.

Show

Aditya Vishwakarma (Inactive) added a comment - 31/May/16 06:36 AM Rakesh Roy Not Yet able to find root cause , still working on it.

Hide

Permalink

shyam sharma (Inactive) added a comment - 08/Jun/16 05:48 AM - edited

Aditya Vishwakarma : could your please update the status for this task ? as more then 1 week past but there is no updates from your side
Amnesh Goel FYI

Show

shyam sharma (Inactive) added a comment - 08/Jun/16 05:48 AM - edited Aditya Vishwakarma : could your please update the status for this task ? as more then 1 week past but there is no updates from your side Amnesh Goel FYI

Hide

Permalink

Aditya Vishwakarma (Inactive) added a comment - 10/Jun/16 08:48 AM

Hello Deepali Tidke
Report is running on LB , you can start testing for this enhancement.

Thanks

Show

Aditya Vishwakarma (Inactive) added a comment - 10/Jun/16 08:48 AM Hello Deepali Tidke Report is running on LB , you can start testing for this enhancement. Thanks

Hide

Permalink

shyam sharma (Inactive) added a comment - 13/Jun/16 07:28 AM

Rakesh Roy : could you please let me know test plan for this task.
Please Note: this task is from Sprint 4 and ideally by this time it should complete but still this is on local testing.
Deepali Tidke

Show

shyam sharma (Inactive) added a comment - 13/Jun/16 07:28 AM Rakesh Roy : could you please let me know test plan for this task. Please Note: this task is from Sprint 4 and ideally by this time it should complete but still this is on local testing. Deepali Tidke

Hide

Permalink

shyam sharma (Inactive) added a comment - 14/Jun/16 11:26 AM

Rakesh Roy : Can you please check why this task is still in local testing. This task is from sprint 4

Show

shyam sharma (Inactive) added a comment - 14/Jun/16 11:26 AM Rakesh Roy : Can you please check why this task is still in local testing. This task is from sprint 4

Hide

Permalink

Deepali Tidke (Inactive) added a comment - 15/Jun/16 06:18 AM

Please start testing this on LB.

Show

Deepali Tidke (Inactive) added a comment - 15/Jun/16 06:18 AM Please start testing this on LB.

Hide

Permalink

Venkatesh Pujari (Inactive) added a comment - 15/Jun/16 12:45 PM

Testing is in progress.

Show

Venkatesh Pujari (Inactive) added a comment - 15/Jun/16 12:45 PM Testing is in progress.

Hide

Permalink

Venkatesh Pujari (Inactive) added a comment - 20/Jun/16 05:22 AM

Hi Jyoti,

I am not able to test the event builder scenarios as server error is being displayed on change class or change status on LB.

Please re-assign this ticket to me once this is fixed.

Thanks,
Venkatesh.

Show

Venkatesh Pujari (Inactive) added a comment - 20/Jun/16 05:22 AM Hi Jyoti, I am not able to test the event builder scenarios as server error is being displayed on change class or change status on LB. Please re-assign this ticket to me once this is fixed. Thanks, Venkatesh.

Hide

Permalink

shyam sharma (Inactive) added a comment - 20/Jun/16 07:39 AM

Jyoti Agrawal : could you please update on this ? by when this will be completed ? as this task is from sprint 4 and ideally by this time it should be completed.

Show

shyam sharma (Inactive) added a comment - 20/Jun/16 07:39 AM Jyoti Agrawal : could you please update on this ? by when this will be completed ? as this task is from sprint 4 and ideally by this time it should be completed.

Hide

Permalink

shyam sharma (Inactive) added a comment - 24/Jun/16 07:38 AM

Amnesh Goel :This task is from sprint 4 and still i can see this on LB, can you please look in to this ?

Show

shyam sharma (Inactive) added a comment - 24/Jun/16 07:38 AM Amnesh Goel :This task is from sprint 4 and still i can see this on LB, can you please look in to this ?

Hide

Permalink

Amnesh Goel (Inactive) added a comment - 27/Jun/16 11:30 AM - edited

Hi shyam sharma,

During testing on LB, QA had reported an issue i.e. ~~WT-3089~~ which is blocking further testing of this item. Venkatesh Pujari have asked EDS team to check this issue and unless that is fixed, this item cannot proceed further.

Thanks,
Amnesh Goel

Show

Amnesh Goel (Inactive) added a comment - 27/Jun/16 11:30 AM - edited Hi shyam sharma , During testing on LB, QA had reported an issue i.e. WT-3089 which is blocking further testing of this item. Venkatesh Pujari have asked EDS team to check this issue and unless that is fixed, this item cannot proceed further. Thanks, Amnesh Goel

Hide

Permalink

Rakesh Roy (Inactive) added a comment - 04/Jul/16 01:37 PM

Amnesh Goel Jyoti Agrawal What is the current status ?

Show

Rakesh Roy (Inactive) added a comment - 04/Jul/16 01:37 PM Amnesh Goel Jyoti Agrawal What is the current status ?

Hide

Permalink

Amnesh Goel (Inactive) added a comment - 05/Jul/16 05:21 AM

Rakesh Roy Issue is still open with EDS team. You may check ~~WT-3089~~ for details.

Show

Amnesh Goel (Inactive) added a comment - 05/Jul/16 05:21 AM Rakesh Roy Issue is still open with EDS team. You may check WT-3089 for details.

Hide

Permalink

shyam sharma (Inactive) added a comment - 05/Jul/16 07:57 AM

Moved from sprint 4 to Sprint 7 as EDS team is working on bug fixes for ~~WT-3089~~ and this is linked with ~~WT-1719~~

Show

shyam sharma (Inactive) added a comment - 05/Jul/16 07:57 AM Moved from sprint 4 to Sprint 7 as EDS team is working on bug fixes for WT-3089 and this is linked with WT-1719

Hide

Permalink

shyam sharma (Inactive) added a comment - 12/Jul/16 06:18 AM

Rakesh Roy Amnesh Goel Jyoti Agrawal Now ~~WT-3089~~ is fixed and closed. can you please now take this task ahead ?
Rakesh Roy : Just wanted to know who will take action on this now Dev team or QA team for this task ?

Show

shyam sharma (Inactive) added a comment - 12/Jul/16 06:18 AM Rakesh Roy Amnesh Goel Jyoti Agrawal Now WT-3089 is fixed and closed. can you please now take this task ahead ? Rakesh Roy : Just wanted to know who will take action on this now Dev team or QA team for this task ?

Hide

Permalink

Venkatesh Pujari (Inactive) added a comment - 12/Jul/16 06:30 AM

Hi shyam sharma,

The issue which was blocking my testing has been resolved but the parent ticket has not been assigned to me so that is why this is pending from QA side.

Rakesh Roy

Thanks,
Venkatesh.

Show

Venkatesh Pujari (Inactive) added a comment - 12/Jul/16 06:30 AM Hi shyam sharma , The issue which was blocking my testing has been resolved but the parent ticket has not been assigned to me so that is why this is pending from QA side. Rakesh Roy Thanks, Venkatesh.

Hide

Permalink

Venkatesh Pujari (Inactive) added a comment - 12/Jul/16 12:05 PM

Hi Jyoti,

I have tested the Event Builder scenario also. The cobra report is fetching that data also

Ready for stage.

Thanks,
Venkatesh

Show

Venkatesh Pujari (Inactive) added a comment - 12/Jul/16 12:05 PM Hi Jyoti, I have tested the Event Builder scenario also. The cobra report is fetching that data also Ready for stage. Thanks, Venkatesh

Hide

Permalink

Venkatesh Pujari (Inactive) added a comment - 14/Jul/16 06:54 AM

Hi Jyoti,

Tested the Cobra Term Report enhancement and found that functionality is working as per expected. Also events like Employee Retirement, Military Leave, FMLA, Employee Deceased, Divorce, Ineligible Dependent and LOA are handled,event builder and proper dependent relationships are displayed.

Ready for Production.

Thanks,
Venkatesh.

Show

Venkatesh Pujari (Inactive) added a comment - 14/Jul/16 06:54 AM Hi Jyoti, Tested the Cobra Term Report enhancement and found that functionality is working as per expected. Also events like Employee Retirement, Military Leave, FMLA, Employee Deceased, Divorce, Ineligible Dependent and LOA are handled,event builder and proper dependent relationships are displayed. Ready for Production. Thanks, Venkatesh.

Hide

Permalink

Venkatesh Pujari (Inactive) added a comment - 18/Jul/16 09:38 AM

Hi Jyoti,

Tested the Cobra Term Report enhancement and found that functionality is not working as per expected. Also events like Employee Retirement, Military Leave, FMLA, Employee Deceased, Divorce, Ineligible Dependent and LOA are are not being displayed on Cobra Term Report.

Reopening the Ticket.

Thanks,
Venkatesh

Show

Venkatesh Pujari (Inactive) added a comment - 18/Jul/16 09:38 AM Hi Jyoti, Tested the Cobra Term Report enhancement and found that functionality is not working as per expected. Also events like Employee Retirement, Military Leave, FMLA, Employee Deceased, Divorce, Ineligible Dependent and LOA are are not being displayed on Cobra Term Report. Reopening the Ticket. Thanks, Venkatesh

Hide

Permalink

Jyoti Agrawal (Inactive) added a comment - 18/Jul/16 12:29 PM

Hi Venkatesh Pujari,

This is not getting reproduced. Please test it again and confirm.

Thanks,
Jyoti A

Show

Jyoti Agrawal (Inactive) added a comment - 18/Jul/16 12:29 PM Hi Venkatesh Pujari , This is not getting reproduced. Please test it again and confirm. Thanks, Jyoti A

Hide

Permalink

Venkatesh Pujari (Inactive) added a comment - 19/Jul/16 07:46 AM

Hi Jyoti,

Thanks,
Venkatesh.

Show

Venkatesh Pujari (Inactive) added a comment - 19/Jul/16 07:46 AM Hi Jyoti, Tested the Cobra Term Report enhancement and found that functionality is working as per expected. Also events like Employee Retirement, Military Leave, FMLA, Employee Deceased, Divorce, Ineligible Dependent and LOA are handled,event builder and proper dependent relationships are displayed. Thanks, Venkatesh.

People

Assignee:: Venkatesh Pujari (Inactive)

Reporter:: Deepali Tidke (Inactive)

Account Executive:: David Rhodes (Inactive)

Developer:: Jyoti Agrawal (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 07/Apr/16 07:01 AM

Updated:: 19/Jul/16 07:48 AM

Resolved:: 19/Jul/16 07:48 AM

Dev Due Date:: 23/May/2016