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- 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)
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)
1 American Indian / Native American
2 Asian
3 Black / African American
4 White / Caucasian
5 Spanish / Hispanic
6 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)
1 White
2 Black / African American
Spanish / Hispanic / Latino. If yes:
3 Puerto Rican
4 Mexican, Mexican American or Chicano
5 Cuban
6 Other Spanish / Hispanic / Latino (specify group: __________________________) (Field: RaceOth)
7 American Indian or Alaska Native (specify enrolled or principal tribe: __________________________) (Field: RaceOth)
8 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.