Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
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