Skip to content

Race Categorization 2018

Jump to bottom
chynnakeys edited this page May 9, 2019 · 9 revisions

Aggregation of Disaggregated Race Information

IF

  • Applicant Race: 1, 2, 3, 4 or 5 is 21, 22, 23, 24, 25, 26, and/or 27, then the Applicant Race in that field is aggregated to Asian (Any code beginning in 2 is aggregated to Asian).

  • Applicant Race: 1, 2, 3, 4 or 5 is 41, 42, 43, or 44, then Applicant Race in that field is aggregated to Native Hawaiian or Other Pacific Islander (Any code beginning in 4 is aggregated to Native Hawaiian or Pacific Islander)

Free Form Text Only

IF

  • Race of Applicant or Borrower: 1 is blank

THEN

  • Categorize as Free Form Text Only

Race Not Available

IF

  • Applicant Race: 1 = 6 or 7

THEN

  • Categorize as Race not available

Minority Race

IF

  • Applicant Race: 1 = American Indian or Alaska Native (1)

AND

  • Applicant Race: 2, 3, 4, 5 are blank

AND

  • Co-applicant Race: 1, 2, 3, 4, or 5 does not equal White (5)

THEN

  • Categorize as American Indian or Alaska Native

IF

  • Applicant Race: 1 = Asian (2, 22, 23, 24, 25, 26 or 27)

AND

  • Applicant Race: 2, 3, 4, 5 are blank

AND

  • Co-applicant Race: 1, 2, 3, 4, or 5 does not equal White (5)

THEN

  • Categorize as Asian

IF

  • Applicant Race: 1 = Black or African American (3)

AND

  • Applicant Race: 2, 3, 4, 5 are blank

AND

  • Co-applicant Race: 1, 2, 3, 4, or 5 does not equal White (5)

THEN

  • Categorize as Black or African American

IF

  • Applicant Race: 1 = Native Hawaiian or Pacific Islander (4, 41, 42, 43, 44)

AND

  • Applicant Race: 2, 3, 4, 5 are blank

AND

  • Co-applicant Race: 1, 2, 3, 4, or 5 does not equal White (5)

THEN

  • Categorize as Native Hawaiian or Pacific Islander

IF"If Race of App: 1 is American Indian OR White AND Race of App 2: is White or American Indian, THEN..." and change that for each of the minority race categories

  • Applicant Race: 1 = American Indian or Alaska Native (1) or White (5)

AND

  • Applicant Race: 2 is White (5) or American Indian or Alaska Native

AND

  • Applicant Race: 3, 4 and 5 are blank

AND

  • Co-applicant Race: 1, 2, 3, 4, or 5 does not equal White (5)

THEN

  • Categorize as American Indian or Alaska Native

IF

  • Applicant Race: 1 = Asian (2, 22, 23, 24, 25, 26, 27) or White (5)

AND

  • Applicant Race: 2 is White (5) or Asian (2, 22, 23, 24, 25, 26, 27)

AND

  • Applicant Race: 3, 4 and 5 are blank

AND

  • Co-applicant Race: 1, 2, 3, 4, or 5 does not equal White (5)

THEN

  • Categorize as Asian

IF

  • Applicant Race: 1 = Black or African American (3) or White (5)

AND

  • Applicant Race: 2 is White (5) or Black or African American (3)

AND

  • Applicant Race: 3, 4 and 5 are blank

AND

  • Co-applicant Race: 1, 2, 3, 4, or 5 does not equal White (5)

THEN

  • Categorize as Black or African American

IF

  • Applicant Race: 1 = Native Hawaiian or Pacific Islander (4, 41, 42, 43 or 44) or White (5)

AND

  • Applicant Race: 2 is White (5) or Native Hawaiian or Pacific Islander (4, 41, 42, 43 or 44)

AND

  • Applicant Race: 3, 4 and 5 are blank

AND

  • Co-applicant Race: 1, 2, 3, 4, or 5 does not equal White (5)

THEN

  • Categorize as Native Hawaiian or Pacific Islander

IF

  • Applicant Race: 1, 2, 3, 4 and 5 contain only some combination of 2, 21, 22, 23, 24, 25, 26, 27, or 5 or blanks

AND

  • Co-applicant Race: 1, 2, 3, 4, or 5 does not equal White (5)

THEN

  • Categorize as Asian (2)

IF

  • Applicant Race: 1, 2, 3, 4 and 5 contain only some combination of 4, 41, 42, 43, 44, or 5 or blanks

AND

  • Co-applicant Race: 1, 2, 3, 4, or 5 does not equal White (5)

THEN

  • Categorize as Native Hawaiian or Pacific Islander

Two or more minorities

IF

  • Applicant has more than one minority race (1, 2 (21, 22, 23, 24, 25, 26 or 27), 3, or 4 (41, 42, 43, 44) in more than 1 of the 5 race data fields)

AND

  • Co-applicant Race: 1, 2, 3, 4, or 5 does not equal White (5)

THEN

  • Categorize as 2 or more minority races

White

IF

  • Applicant Race: 1 = 5

AND

  • Applicant Race: 2, 3, 4, 5 are blank

AND

  • Co-applicant Race: 1 = 5, 6, 7, or 8

AND

  • Co-applicant Race: 2, 3, 4 and 5 are blank

THEN

  • Categorize as White

Joint

IF

  • Applicant Race 1, 2, 3, 4 or 5 has one or more minority race (1, 2, 21, 22, 23, 24, 25, 26, 27, 3, 4, 41, 42, 43, or 44)

AND

  • Co-Applicant Race: 1, 2, 3, 4 or 5 equals White (5)

THEN

  • Categorize as Joint

IF

  • Co-Applicant Race: 1, 2, 3, 4 or 5 has one or more minority race (1, 2 21, 22, 23, 24, 25, 26, 27, 3, 4, 41, 42, 43, or 44)

AND

  • Applicant Race: 1, 2, 3, 4 or 5 equals White

THEN

  • Categorize as Joint
Clone this wiki locally