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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
SQL to Pull Most Current Ethnicity record
Summary
Looking for BIP Data Model that will select the most current EthnicityContent
Hi,
I am creating a data model of person information and have been challenged when trying to pull the most current ethnicity row.
Example, Person A has 2 ethnicity rows, 1 showing "Not Disclosed and 1 showing Asian. The row value Asian is the most current row. When I query the PER_ETHNICITIES table, for person A, both rows are returned and the primary flag for the Not Disclosed row = Y and the primary flag for the Asian row = N.
When I view Person A in the UI under Personal Details, the most current row is displayed (ethnicity = Asian).
1