Alert Composer - when the dependents for employee has Pending Action Items — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Alert Composer - when the dependents for employee has Pending Action Items

in Benefits 5 comments

Hello Team,

Can anyone please share an SQL query that can show me the list of all dependents for an employee who have a pending action in the benefit plans like Medical, Dental and Vison

lets say for a dependent , The Birth Certificate needs to be added and this is marked as a pending item.

1. The above mentioned question needs to be incorporated in Alert Composer

2. In the email body is it possible to list the dependents name? example :

Dear "emp name"

In order for your dependent’s coverage to remain in effect, the following dependent(s) need to have their eligibility verified: 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!