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.