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

PAY_ELEMENT_ENTRIES_F - elements entries by assignment

edited Oct 16, 2017 5:16AM in Human Capital Management 3 comments

Summary

Element Entries by Assignment ID

Content

Hi All,   noticed that PAY_ELEMENT_ENTRIES_F tables( used to store the element entries value for employee) does not have an assignment id field but stores data based on person_id level.   this way we will not be able to join on assignment_id and get the element entries per assignments. wanted to check how others get the element entries based on assignment id ( In an SQL) .   should Oracle not store element entries by assignment id or is there any other table which i am missing. 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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