WRAP Data Dictionary: WRAP Race Data Elements

This article describes the logic used in generating the "WRAPRaceAssignment" calculated field.
Previously there were several fields used for race (documented below in deprecated section).
The original values were mapped to the following OpenClinica data elements:
1. What is your race? Mark one or more to indicate what you consider yourself to be (multi-select)
1- White
2- Black/African American
4- American Indian or Alaska Native (specify enrolled or principal tribe)
5- Asian
6- Native Hawaiian or Other Pacific Islander
7- Other
8- Unknown
2. Specify enrolled or principal tribe: (Enabled only when "4- American Indian or Alaska Native (specify enrolled or principal tribe)" is selected for "What is your race?")
3. Specify other: (Enabled only when "7- Other" is selected for "What is your race?")
4. Are you of Hispanic, Latino, or Spanish origin?
1- No, not of Hispanic, Latino, or Spanish origin
2- Yes, Puerto Rican
3- Yes, Mexican, Mexican American or Chicano
4- Yes, Cuban
5- Yes, Other Spanish/Hispanic/Latino (specify group)
5. Specify group (Enabled only when "5- Yes, Other Spanish/Hispanic/Latino (specify group)" is selected for "Are you of Hispanic, Latino, or Spanish origin?")
The only difference in these fields when moved the the WRAP Freeze are that the "What is your race?" field is broken into:
race1
race2
race3
Currently we have no participants with more than 3 races selected, this logic may need to be addressed if that happens.
The below has been deprecated with the migration to OpenClinica
There have been two questions asked of WRAP Participants in regards to their race or ethnic category.
The first question was asked early on in the "Entry Assessment Form" at their first Visit.  The question was:
      Which race or ethnic category best describes you?   (Field: race)
 
                 Checkbox Symbol1  American Indian / Native American
                 Checkbox Symbol2  Asian
                 Checkbox Symbol3  Black / African American
                 Checkbox Symbol4  White / Caucasian
                 Checkbox Symbol5  Spanish / Hispanic
                 Checkbox Symbol6  Other
This question was then followed up in the "Personal and Family Background" assessment of their second Visit
with the following question:
 
      What is your race and ethnic background?  Mark one or more to indicate what you consider yourself to be.   (Field: Race_W2_Or_W1Post2016)
 
                 Checkbox Symbol1  White
                 Checkbox Symbol2  Black / African American
                 Checkbox Symbol   Spanish / Hispanic / Latino.  If yes:
                                   Checkbox Symbol3  Puerto Rican
                                   Checkbox Symbol4  Mexican, Mexican American or Chicano
                                   Checkbox Symbol5  Cuban
                                   Checkbox Symbol6  Other Spanish / Hispanic / Latino (specify group: __________________________)   (Field: RaceOth)
                 Checkbox Symbol7  American Indian or Alaska Native (specify enrolled or principal tribe: __________________________)   (Field: RaceOth)
                 Checkbox Symbol8  Other (specify: __________________________)   (Field: RaceOth)
(Note: The "race", "Race_W2_Or_W1Post2016" and "RaceOth" fields are all present in the "Demographics" table.)
In 2016, the first question was no longer used, and the second question was moved to the Entry Assessment at Visit 1.
Because of the significant amount of variability in the possible responses, including the free-text fields
("Other Spanish / Hispanic / Latino (specify group: _______)",
"American Indian or Alaska Native (specify enrolled or principal tribe: ____________)" and
"Other (specify: ____________)" ), it was impossible to create SQL that would take into account all
of the possible responses, and determine a Race Assignment.  So, all of the observed responses were
placed into a table, named "codRaceEthnicityDeterminations".  For each observed combination of responses,
a "WRAP Race Assignment", "NIH Enrollment Form Assignment", "GAAIN Race Assignment" and
"GAAIN Ethnicity Assignment" were assigned by Sterling Johnson and Allen Wenzel.
A VBA function was created, named "FindParticipantRaceEthnicity", that is used in queries to return the
"WRAPRaceAssignment" for a WRAP Participant given their responses to the two race / ethnicity related
questions.  This is the function that produces the values for the "WRAPRaceAssignment" variable in the
"MiscVars" table of the WRAP Data Freezes.
It should be noted that before each WRAP Data Freeze, the observed responses for the two race / ethnicity
questions for all WRAP Participants are compared to the entries in the "codRaceEthnicityDeterminations" table,
and additional table entries are added if new response combinations are observed.
Lastly, it should be noted that this process has some limitations.  If in the second question above more than one
race or ethnicity was selected, and/or if the WRAP Participant answered both the first and second questions above,
and the responses differed, then the "WRAP Race Assignment", "NIH Enrollment Form Assignment",
"GAAIN Race Assignment" and "GAAIN Ethnicity Assignment" fields in the
"codRaceEthnicityDeterminations" table were assigned a single race / ethnicity value by Sterling Johnson and
Allen Wenzel based on their best professional judgement.  If there is an interest in the component race / ethnicities
reported by the WRAP Participant, then the "race", "Race_W2_Or_W1Post2016" and "RaceOth" fields
in the "Demographics" table should be consulted directly.
If you have any questions about this, please contact Allen Wenzel of WRAP.


Keywords:
race ethnicity open clinica 
Doc ID:
93923
Owned by:
Dan P. in Wisconsin Alzheimer’s Program
Created:
2019-08-16
Updated:
2023-12-11
Sites:
Wisconsin Alzheimer’s Program