SQL to get individual compensation plan items to show under Additional compensation

Raghavendra M

I want fetch Additional Compensation details for Individual Compensation plan through SQL. below is the screen I want to query. Person will have multiple plan and options and for them percentage also . Which table holds these values? I checked on these tables

cmp_plans_tl , cmp_plan_attributes, cmp_attribute_elements

But not able to figure out the link with employee , can anyone help me with these please.

Syamantak Saha

Try using the Individual Compensation under HCM for this:

https://docs.oracle.com/en/cloud/saas/human-resources/faucf/overview-of-individual-compensation.html

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/26780/sql-to-get-individual-compensation-plan-items-to-show-under-additional-compensation

Hi Raghavendra,

Welcome to Oracle Analytics Community.

This forum is specific to FDI. Please post it on cloud customer connect for better response and traction.

Thanks.