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

Does anyone knows what tables stores this information?

Accepted answer
31
Views
1
Comments

Summary:

Retrieving compensation informations

Content (required):

Under My Client Groups -> Elements -> Search Element Name I have this configuration for additional compensations:


One employee has this situation under his additional compensation and I'd like to retrieve the highlighted value for HCM Extract:


My HCM Extracts uses ELEMENT ENTRIES as User Entity and I'm able to get the amount of 9000 (same as previous image):

This values comes from this field defined in HCM Extract:

As mentioned I'm looking for the monthly payment amount but if I run the query used in user entity ELEMENT ENTRIES (with the same Extract_Employee_Payroll_Relationship_ID or Person_ID) I cannot find them in any of the tables it uses (not even the 9000 value!!).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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