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
Get Started with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Trying to Retrieve the Specific Ethnicity Record Associated with each Period of Service

Summary:It appears that there is a separate row in table per_ethnicities for each of an employee's period of service. Looking for a query


Content (please ensure you mask any confidential information): For each period of service, the system appears to be creating at least one record in the per_ethnicitiess table. Is there a way to know which row(s) in per_ethnicities is associated with which period of service?

If the employee always chooses the same ethnicity or list of ethnicities, then this should not be a problem, but what if they don't? How would one select the current list of ethnicities for the current period of service (as shown in the Demographic Info screen)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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