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

Table to create Data Model fetching Element Entries created for Individual Compensation Plans

Accepted answer


Need to create a SQL Data Model to fetch the Element Entries for those attached to a specific ICP.

Content (required):

Hi team,

I need to create a SQL based Data Model where i can join the ICP and the Element Entries created for the allocation made to employee.

ICP Plan IDs can be found in CMP_PLANS_VL and CMP_PLANS_B and Elements have theirs, but how do i connect so that i can have similar data to what we normally get in the ICP Subject Area.

May someone please share a sample query.


Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


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