Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-1719

Cobra new reports : to come in excel

    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

      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

          Issue Links

            Activity

            Hide
            satyap Satya added a comment -

            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
            satyap Satya added a comment - 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
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            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 Jyoti Agrawal (Inactive) added a comment - 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
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

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

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Keeping in hold this enhancement due to priority task of including Provider Details on Column Wise Billing Details Report
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

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

            Thanks

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - Test cases for the enhancement are updated on TestLink under the Workterra > Benadmin > Cobra_Term_Report. Thanks
            Hide
            shyam.sharma shyam sharma (Inactive) added a comment -

            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 shyam sharma (Inactive) added a comment - 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
            deepalit Deepali Tidke (Inactive) added a comment -

            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
            deepalit Deepali Tidke (Inactive) added a comment - 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
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment -

            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 Aditya Vishwakarma (Inactive) added a comment - 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
            rakeshr Rakesh Roy (Inactive) added a comment -

            Aditya Vishwakarma Please update.

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Aditya Vishwakarma Please update.
            Hide
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment -

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

            Show
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - Rakesh Roy Not Yet able to find root cause , still working on it.
            Hide
            shyam.sharma shyam sharma (Inactive) added a comment - - 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 shyam sharma (Inactive) added a comment - - 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
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment -

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

            Thanks

            Show
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - Hello Deepali Tidke Report is running on LB , you can start testing for this enhancement. Thanks
            Hide
            shyam.sharma shyam sharma (Inactive) added a comment -

            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 shyam sharma (Inactive) added a comment - 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
            shyam.sharma shyam sharma (Inactive) added a comment -

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

            Show
            shyam.sharma shyam sharma (Inactive) added a comment - Rakesh Roy : Can you please check why this task is still in local testing. This task is from sprint 4
            Hide
            deepalit Deepali Tidke (Inactive) added a comment -

            Please start testing this on LB.

            Show
            deepalit Deepali Tidke (Inactive) added a comment - Please start testing this on LB.
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Testing is in progress.

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Testing is in progress.
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            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 Venkatesh Pujari (Inactive) added a comment - 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
            shyam.sharma shyam sharma (Inactive) added a comment -

            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 shyam sharma (Inactive) added a comment - 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
            shyam.sharma shyam sharma (Inactive) added a comment -

            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 shyam sharma (Inactive) added a comment - Amnesh Goel :This task is from sprint 4 and still i can see this on LB, can you please look in to this ?
            Hide
            amnesh.goel Amnesh Goel (Inactive) added a comment - - 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 Amnesh Goel (Inactive) added a comment - - 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
            rakeshr Rakesh Roy (Inactive) added a comment -

            Amnesh Goel Jyoti Agrawal What is the current status ?

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Amnesh Goel Jyoti Agrawal What is the current status ?
            Hide
            amnesh.goel Amnesh Goel (Inactive) added a comment -

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

            Show
            amnesh.goel Amnesh Goel (Inactive) added a comment - Rakesh Roy Issue is still open with EDS team. You may check WT-3089 for details.
            Hide
            shyam.sharma shyam sharma (Inactive) added a comment -

            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 shyam sharma (Inactive) added a comment - 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
            shyam.sharma shyam sharma (Inactive) added a comment -

            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 shyam sharma (Inactive) added a comment - 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
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            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 Venkatesh Pujari (Inactive) added a comment - 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
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            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 Venkatesh Pujari (Inactive) added a comment - Hi Jyoti, I have tested the Event Builder scenario also. The cobra report is fetching that data also Ready for stage. Thanks, Venkatesh
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            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 Venkatesh Pujari (Inactive) added a comment - 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
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            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 Venkatesh Pujari (Inactive) added a comment - 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
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            Hi Venkatesh Pujari,

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

            Thanks,
            Jyoti A

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Hi Venkatesh Pujari , This is not getting reproduced. Please test it again and confirm. Thanks, Jyoti A
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            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.

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - 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 Venkatesh Pujari (Inactive)
              Reporter:
              deepalit 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:
                Updated:
                Resolved:
                Dev Due Date: