Skip to content

Derived Fields Categorization 2018 Onward

Jump to bottom
David Roell edited this page Oct 2, 2020 · 1 revision

This wiki explains how ethnicity, race, sex, and confirming loan limit derived fields are categorized.

Ethnicity

Aggregation of Disaggregated Ethnicity Information

  • If Applicant or Co-Applicant Ethnicity: 1, 2, 3, 4 or 5 is 11, 12, 13, and/or 14, then the Applicant Ethnicity in that field is aggregated to Hispanic or Latino (Any code beginning in 1 is aggregated to Hispanic or Latino).

  • Disaggregated applicant and co-applicant ethnicities are aggregated up and counted only once (i.e. reporting three different Hispanic subcategories still just rolls up to Hispanic and is counted only once).

Free Form Text Only

IF

  • Ethnicity of Applicant or Borrower: 1 is blank

THEN

  • Categorize as Free Form Text Only

Ethnicity Not Available

IF

  • Applicant Ethnicity = (3) or (4)

THEN

  • Categorize as Ethnicity not available

Hispanic or Latino

IF

  • Applicant Ethnicity:1 = Hispanic or Latino (1, 11, 12, 13 or 14)

AND

  • Applicant Ethnicity: 2, 3, 4 and 5 are blank

AND

  • Co-Applicant Ethnicity: 1, 2, 3 4 or 5 does not equal Not Hispanic or Latino (Code 2)

THEN

  • Categorize as Hispanic or Latino (1)

IF

  • Applicant Ethnicity:1, 2, 3, 4 and 5 contain only Hispanic codes (1, 11, 12, 13 and/or 14)

AND

  • Co-Applicant Ethnicity: 1, 2, 3 4 or 5 does not equal Not Hispanic or Latino (Code 2)

THEN

  • Categorize as Hispanic or Latino (1)

Not Hispanic or Latino

IF

  • Applicant Ethnicity:1 = Not Hispanic or Latino (Code 2)

AND

  • Applicant Ethnicity: 2, 3, 4 and 5 are blank

AND

  • Co-Applicant Ethnicity: 1, 2, 3, 4 and 5 does not equal 1, 11, 12, 13, and/or 14

THEN

  • Categorize as Not Hispanic or Latino (2)

Joint

IF

  • Applicant Ethnicity: 1, 2, 3, 4 or 5 = Hispanic or Latino (1, 11, 12, 13 and/or 14)

AND

  • Co-Applicant Ethnicity: 1, 2, 3, 4 or 5 = Not Hispanic or Latino (2)

THEN

  • Categorize as Joint

IF

  • Applicant Ethnicity: 1, 2, 3, 4 or 5 = Not Hispanic or Latino (2)

AND

  • Co-Applicant Ethnicity: 1, 2, 3, 4 or 5 = Hispanic or Latino (1, 11, 12, 13, or 14)

THEN

  • Categorize as Joint

IF

  • Applicant has more than one ethnicity (1, 11, 12, 13, and/or 14 AND 2 in the 5 ethnicity fields)

OR

  • Co-Applicant has more than one ethnicity (1, 11, 12, 13, and/or 14 AND 2 in the 5 ethnicity fields)

THEN

  • Categorize as Joint

Race

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

  • 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 (1)

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 equals White (5)

AND

  • Applicant Race 2, 3, 4 and 4 are Blank

THEN

  • Categorize as Joint

Sex

Sex Not Available

IF

  • Sex of Applicant or Borrower = (3) or (4)

THEN

  • Categorize as Sex not available

Male

IF

  • Applicant Sex = 1 (Male)

AND

  • Co-Applicant Sex does not equal 2 (Female) or 6 (Male and Female)

THEN

  • Categorize as Male

Female

IF

  • Applicant Sex = 2 (Female)

AND

  • Co-Applicant Sex does not equal 1 (Male) or 6 (Male and Female)

THEN

  • Categorize as Female (2)

Joint

IF

  • Applicant Sex = 1 (Male)

AND

  • Co-Applicant Sex = 2 (Female) or 6 (Male and Female)

THEN

  • Categorize as Joint

IF

  • Applicant Sex = 2 (Female)

AND

  • Co-Applicant Sex equals 1 (Male) or 6 (Male and Female)

THEN

  • Categorize as Joint

IF

  • Applicant Sex = 6 (Male and Female)

OR

  • Co-Applicant Sex equals 6 (Male and Female)

THEN

  • Categorize as Joint

Conforming Loan Limit

There are 4 possible values included in the conforming loan limit flag field. FHFA periodically updates conforming loan limits, so this logic will need to be updated in future years when the conforming loan limits change.

  • C (Conforming)
  • NC (Nonconforming)
  • U (Undetermined)
  • NA (Not Applicable)

Logic to determine which value (these should be completed in the order listed):

A. The steps below do not require referencing outside data & can be determined using just the information in the LAR record.

  1. If Total Units >= 5, assign a value of NA
  2. If Lien Status =1, and Total Units = 1, and Loan Amount is <= $453,100.00, assign a value of C
  3. If Lien Status =1, and Total Units = 2, and Loan Amount is <= $580,150.00 = C
  4. If Lien Status =1, and Total Units = 3, and Loan Amount is <= $701,250.00 = C
  5. If Lien Status =1, and Total Units = 4, and Loan Amount is <= $871,450.00 = C
  6. If Lien Status =1, and Total Units = 1, and Loan Amount is > $721,150.00 = NC
  7. If Lien Status =1, and Total Units = 2, and Loan Amount is > $923,050.00 = NC
  8. If Lien Status =1, and Total Units = 3, and Loan Amount is > $1,115,800.00 = NC
  9. If Lien Status =1, and Total Units =4, and Loan Amount is > $1,386,650.00 = NC
  10. If Lien Status =2, and Total Units = 1, and Loan Amount is <= $226,550.00 = C
  11. If Lien Status =2, and Total Units = 2, and Loan Amount is <= $290,075.00 = C
  12. If Lien Status =2, and Total Units = 3, and Loan Amount is <= $350,625.00 = C
  13. If Lien Status =2, and Total Units = 4, and Loan Amount is <= $435,725.00 = C
  14. If Lien Status =2, and Total Units = 1, and Loan Amount is > $360,575.00 = NC
  15. If Lien Status =2, and Total Units = 2, and Loan Amount is > $461,525.00 = NC
  16. If Lien Status =2, and Total Units = 3, and Loan Amount is > $557,900.00 = NC
  17. If Lien Status =2, and Total Units = 2, and Loan Amount is > $693,325.00 = NC

B. The steps below require referencing data in the FHFA's Conforming Loan Limit file AND require that County data is reported in the LAR.

  1. Lien Status = 1, Total Units = 1, Reference the 1 Unit Limit for the specific County reported.
  • If Loan Amount is <= that limit, assign a value of C.
  • If Loan Amount is > that limit, assign a value of NC
  1. Lien Status = 1, Total Units = 2, Reference the 2 Unit Limit for the specific County reported.
  • If Loan Amount is <= that limit, assign a value of C.
  • If Loan Amount is > that limit, assign a value of NC
  1. Lien Status = 1, Total Units = 3, Reference the 3 Unit Limit for the specific County reported.
  • If Loan Amount is <= that limit, assign a value of C.
  • If Loan Amount is > that limit, assign a value of NC
  1. Lien Status = 1, Total Units = 4, Reference the 4 Unit Limit for the specific County reported.
  • If Loan Amount is <= that limit, assign a value of C.
  • If Loan Amount is > that limit, assign a value of NC
  1. Lien Status = 2, Total Units = 1, Reference the 1 Unit Limit for the specific County reported.
  • If Loan Amount is <= HALF of that limit, assign a value of C.
  • If Loan Amount is > HALF of that limit, assign a value of NC
  1. Lien Status = 2, Total Units = 2, Reference the 2 Unit Limit for the specific County reported.
  • If Loan Amount is <= HALF of that limit, assign a value of C.
  • If Loan Amount is > HALF of that limit, assign a value of NC
  1. Lien Status = 2, Total Units = 3, Reference the 3 Unit Limit for the specific County reported.
  • If Loan Amount is <= HALF of that limit, assign a value of C.
  • If Loan Amount is > HALF of that limit, assign a value of NC
  1. Lien Status = 2, Total Units = 4, Reference the 4 Unit Limit for the specific County reported.
  • If Loan Amount is <= HALF of that limit, assign a value of C.
  • If Loan Amount is > HALF of that limit, assign a value of NC

C. The steps below require referencing data in the FHFA's Conforming Loan Limit file AND require that State is data is reported in the LAR (so these are the records where county is reported NA, but State is reported).

  1. Lien Status = 1, Total Units = 1, Reference the minimum and maximum conforming limits for the STATE for 1 unit.
  • If Loan Amount is <= lowest possible limit for the state, assign a value of C
  • If Loan Amount is > highest possible limit for the state, assign a value of NC
  • If loan amount > the lowest possible limit but <= highest possible limit, assign a value of U
  1. Lien Status = 1, Total Units = 2, Reference the minimum and maximum conforming limits for the STATE for 2 units.
  • If Loan Amount is <= lowest possible limit for the state, assign a value of C
  • If Loan Amount is > highest possible limit for the state, assign a value of NC
  • If loan amount > the lowest possible limit but <= highest possible limit, assign a value of U
  1. Lien Status = 1, Total Units = 3, Reference the minimum and maximum conforming limits for the STATE for 3 units.
  • If Loan Amount is <= lowest possible limit for the state, assign a value of C
  • If Loan Amount is > highest possible limit for the state, assign a value of NC
  • If loan amount > the lowest possible limit but <= highest possible limit, assign a value of U
  1. Lien Status = 1, Total Units = 4, Reference the minimum and maximum conforming limits for the STATE for 4 units.
  • If Loan Amount is <= lowest possible limit for the state, assign a value of C
  • If Loan Amount is > highest possible limit for the state, assign a value of NC
  • If loan amount > the lowest possible limit but <= highest possible limit, assign a value of U
  1. Lien Status = 2, Total Units = 1, Reference the minimum and maximum conforming limits for the STATE for 1 unit.
  • If Loan Amount is <= HALF of lowest possible limit for the state, assign a value of C
  • If Loan Amount is > HALF of highest possible limit for the state, assign a value of NC
  • If loan amount > HALF the lowest possible limit but <= HALF of highest possible limit, assign a value of U
  1. Lien Status = 2, Total Units = 2, Reference the minimum and maximum conforming limits for the STATE for 2 unit.
  • If Loan Amount is <= HALF of lowest possible limit for the state, assign a value of C
  • If Loan Amount is > HALF of highest possible limit for the state, assign a value of NC
  • If loan amount > HALF the lowest possible limit but <= HALF of highest possible limit, assign a value of U
  1. Lien Status = 2, Total Units = 3, Reference the minimum and maximum conforming limits for the STATE for 3 unit.
  • If Loan Amount is <= HALF of lowest possible limit for the state, assign a value of C
  • If Loan Amount is > HALF of highest possible limit for the state, assign a value of NC
  • If loan amount > HALF the lowest possible limit but <= HALF of highest possible limit, assign a value of U
  1. Lien Status = 2, Total Units = 4, Reference the minimum and maximum conforming limits for the STATE for 4 unit.
  • If Loan Amount is <= HALF of lowest possible limit for the state, assign a value of C
  • If Loan Amount is > HALF of highest possible limit for the state, assign a value of NC
  • If loan amount > HALF the lowest possible limit but <= HALF of highest possible limit, assign a value of U

D. These are the records that have no state and county data (state & county reported NA) & have not been assigned a value in the preceding steps.

  1. If the record has not been assigned a value in steps 1 through 33, assign a value of U.
Clone this wiki locally