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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.

DFF Help Needed: Need Ethnicity Indicator DFF if the employee selects more than one ethnicity

edited Sep 18, 2020 9:33PM in Human Capital Management 2 comments

Content

With 20B, and how Two or More Races is no longer applicable, and employees can now select multiple races, we have an issue with a whole bunch of broken statistical reports.

THUS I need help with what options we could build

Option 1 - Can I build a DFF indicator that uses SQL logic?  For example: ...  If two or more ethnicities are selected in the per_ethnicity table are selected, default to YES...then store the Yes under a DFF called "Two or More Races" indicator.

or

Option 2  - Can I keep the Two or More Races from the per_ethnicity table (it still appears as enabled on the table) and if someone selects multiple races, then could I default the reportable values as the Two or More Races field, instead of being reported in the actual race/ethnicity they checked.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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