What's new in Customer Journeys?

Connect and learn more! ×
query picking up blank submit and missing the dependent amt changes in benefits life event — 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

query picking up blank submit and missing the dependent amt changes in benefits life event

Accepted answer
22
Views
3
Comments
edited Jan 5, 2024 5:46PM in Benefits 3 comments

1- we have 2 different queries written for Open Enrollments and New Hire, Unrestricted & Other Life events .

2- we want employee records to be pulled when employee finally clicks "submit" on their life events .

3- we want to consider records when employee has changed their benefits amount for the respective life event and 4- code should also pick up record when employee changes only the percentages of the amount divided among them and their dependents/beneficiary .

5-we want to reject blank submits

6- kindly help us with SQL queries or help us to identify columns and tables which gets populated with certain values on these events .

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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