A lot of times, we need to find to out the Person Habits for Benefits if an employee is tobacco user or not. You can use and change the SQL with your requirements
SQL to find all the potential and processed life events
You can use the below SQL Query to retrieve Person and Assignment Information from Oracle HCM Cloud.
Use this Query to fetch benefits data from Oracle Cloud / HCM Fusion.
Here are some sample queries that you can use with Oracle Cloud. Try these in SQLConnect to get used to the application and its features. Benefits Queries Person and Assignment Queries