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

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

Received Response
51
Views
2
Comments
edited Sep 18, 2020 9:33PM in Human Resources 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!