Reporting Race/Ethnicity

The current method forofficially reporting race/ethnicity began in the spring semester of 2010. It is based on race/ethnicity data collection and reporting requirements from the federal government.

Data Collection

A two-question format is used to collect self-reported race and ethnicity categories from students, staff and faculty. This data collection occurs on admission applications and IU human resources forms, among other methods. For question 2, multiple races can be selected.

Question 1: Are you Hispanic or Latino (Y or N).

Question 2: What is your race?

  1. American Indian or Alaska Native
  2. Asian
  3. Black or African American
  4. Native Hawaiian or Other Pacific Islander
  5. White

These self-reported race and ethnicity identifiers are displayed as Y/N values in the following columns. A sample list of tables with these columns is also listed below.

  • Column names:
  • PRSN_ETHNIC_DTL_WHT_IND
  • PRSN_ETHNIC_DTL_BLK_IND
  • PRSN_ETHNIC_DTL_HISP_IND
  • PRSN_ETHNIC_DTL_ASN_IND
  • PRSN_ETHNIC_DTL_AMIN_IND
  • PRSN_ETHNIC_DTL_NONE_IND
  • PRSN_ETHNIC_DTL_PCFC_ISLDR_IND
  • PRSN_ETHNIC_VLDTD_IND – indicates that the student has answered the two new race/ethnicity questions
  • PRSN_ETHNIC_HISP_IND – indicates the answer to the first question
  • Sample tables:
  • DSS_RDS.SR_STU_TERM_GT
  • DSS_RDS.IR_CEN_TRM_SNPSHT_GT

Race/Ethnicity Reporting

According to federal guidelines, we report race/ethnicity using the following derived values:

PRSN_DRVD_IPEDS_ETHNIC_CDPRSN_DRVD_IPEDS_ETHNIC_DESC

1White

2Black/African American

3Hispanic/Latino

4Asian

5American Indian/Alaska Native

6NR – Alien

7Native Hawaiian/Pacific Islander

8Two or More Races

These reporting race/ethnicity values are assigned using the following logic:

  1. First, international individuals are reported as 6 – NR alien (non-resident alien). This is the case regardless of what the individual selects in the data collection questions. (See below for information about how international students are identified for this field.)
  2. Next, individuals who self-identify as Hispanic or Latino are reported as 3 – Hispanic/Latino. This is the case even if the individual selects other options in Question 2 of the data collection question (see above).
  3. Next, if an individual is not in the first two categories above (neither international nor Hispanic/Latino), and the individual selected two or more options under Question 2 of the data collection question, this person is reported as 8 – Two or More Races.
  4. Finally, any remaining individuals are reported based on their selection of a single category in Question 2 of the data collection question.

When reporting from IR_CEN_TRM_SNPSHT_GT, we use PRSN_DRVD_ETHNIC_IR_RPT_CD/DESC. This field is populated prior to 4099 from PRSN_DRVD_ETHNIC_CD/DESC and for term(s) equal to or in the future of 4099, the data are pulled from PRSN_DRVD_IPEDS_ETHNIC_CD/DESC.

There are also two other derived race/ethnicity groupings that are used in official reporting, and the DSS_RDS dimension tableDSS_SH.SH_PRSN_IPEDS_ETHN_GRP_DM can be used via SQL to consistently group and report students as Domestic Minority or Under-Represented Minority.

  1. Domestic Minority (or “Minority”)
  2. This includes individuals with PRSN_DRVD_IPEDS_ETHNIC_DESC values of Hispanic, African American, Asian, American Indian, Pacific Islander, or Two or More Races.
  3. Under-Represented Minority
  4. This is similar to Domestic Minority, but excludes Asian.

Identifying International Students for Race/Ethnicity Reporting

International individuals are identified based on their most recent visa permit type in the Student Information System (SIS). Individuals whose most recent visa permit type is a value other thanthe codes listed below is reported as 6 - NR Alien (non-resident alien). Note that a student’s “citizenship” coding in the SIS is not taken into account for Race/Ethnicity Reporting.

PRSN_VPRMT_TYP_CD / PRSN_VPRMT_TYP_DESC / PRSN_VPRMT_CTGRY_DESC
I-9 / I-9 (Employment Eligibility) / Employment Elig
EVY / e-Verify / Employment Elig
NLR / Now US Citizen-No Visa Reqd / Naturalized US Citizen
ZZZ / Unknown.InternalOnly.DoNotUse / Not Applicable
REF / Refugee / Resident Alien
LPR / Permanent Resident / Resident Alien
PIP / Public Interest Parolee / Resident Alien
ASY / Asylee (Political asylum) / Resident Alien

Legacy Fields – Avoid Using These

A number of legacy fields related to race/ethnicity exist in various tables. These are not used by UIRR for reporting race/ethnicity (exceptions noted below):

PRSN_PRM_ETHNIC_CD

PRSN_PRM_ETHNIC_SHRT_DESC

PRSN_PRM_ETHNIC_DESC

PRSN_PRM_ETHNIC_DTL_CD

PRSN_PRM_ETHNIC_DTL_SHRT_DESC

PRSN_PRM_ETHNIC_DTL_DESC

PRSN_DRVD_RPT_ETHNIC_CD (This was used by UIRR prior to 2010.)

PRSN_DRVD_RPT_ETHNIC_DESC(This was used by UIRR prior to 2010.)

\\ads\usss\External_Share\UIRR\Misc_Working_Files\Website\1-uirr webserve\www\reports\resources\IRDSI\doc\ir data guides\Reporting Ethnicity.doc Page 1 of 3