Public HMDA - LAR Data Fields
activity_year
-
Description: The calendar year the data submission covers
activity_year Value 2017 2017 2018 2018 2019 2019 2020 2020 2021 2021 2022 2022 2023 2023 2024 2024
lei
- Description: A financial institution’s Legal Entity Identifier
- Values:
- Varying values
derived_msa-md
- Description: The 5 digit derived MSA (metropolitan statistical area) or MD (metropolitan division) code. An MSA/MD is an area that has at least one urbanized area of 50,000 or more population.
- Values:
- Varying values
state_code
- Description: Two-letter state code
- Values:
- Varying values
county_code
- Description: State-county FIPS code
- Values:
- Varying values
census_tract
- Description: 11 digit census tract number
- Values:
- Varying values
derived_loan_product_type
- Description: Derived loan product type from Loan Type and Lien Status fields for easier querying of specific records
- Values:
- Conventional:First Lien
- FHA:First Lien
- VA:First Lien
- FSA/RHS:First Lien
- Conventional:Subordinate Lien
- FHA:Subordinate Lien
- VA:Subordinate Lien
- FSA/RHS:Subordinate Lien
derived_dwelling_category
- Description: Derived dwelling type from Construction Method and Total Units fields for easier querying of specific records
- Values:
- Single Family (1-4 Units):Site-Built
- Multifamily:Site-Built (5+ Units)
- Single Family (1-4 Units):Manufactured
- Multifamily:Manufactured (5+ Units)
conforming_loan_limit
- Description: Indicates whether the reported loan amount exceeds the GSE (government sponsored enterprise) conforming loan limit
- Values:
- C (Conforming)
- NC (Nonconforming)
- U (Undetermined)
- NA (Not Applicable)
derived_ethnicity
- Description: Single aggregated ethnicity categorization derived from applicant/borrower and co-applicant/co-borrower ethnicity fields
- Values:
- Hispanic or Latino
- Not Hispanic or Latino
- Joint
- Ethnicity Not Available
- Free Form Text Only
derived_race
- Description: Single aggregated race categorization derived from applicant/borrower and co-applicant/co-borrower race fields
- Values:
- American Indian or Alaska Native
- Asian
- Black or African American
- Native Hawaiian or Other Pacific Islander
- White
- 2 or more minority races
- Joint
- Free Form Text Only
- Race Not Available
derived_sex
- Description: Single aggregated sex categorization derived from applicant/borrower and co-applicant/co-borrower sex fields
- Values:
- Male
- Female
- Joint
- Sex Not Available
action_taken
- Description: The action taken on the covered loan or application
- Values:
- 1 - Loan originated
- 2 - Application approved but not accepted
- 3 - Application denied
- 4 - Application withdrawn by applicant
- 5 - File closed for incompleteness
- 6 - Purchased loan
- 7 - Preapproval request denied
- 8 - Preapproval request approved but not accepted
purchaser_type
- Description: Type of entity purchasing a covered loan from the institution
- Values:
- 0 - Not applicable
- 1 - Fannie Mae
- 2 - Ginnie Mae
- 3 - Freddie Mac
- 4 - Farmer Mac
- 5 - Private securitizer
- 6 - Commercial bank, savings bank, or savings association
- 71 - Credit union, mortgage company, or finance company
- 72 - Life insurance company
- 8 - Affiliate institution
- 9 - Other type of purchaser
preapproval
- Description: Whether the covered loan or application involved a request for a preapproval of a home purchase loan under a preapproval program
- Values:
- 1 - Preapproval requested
- 2 - Preapproval not requested
loan_type
- Description: The type of covered loan or application
- Values:
- 1 - Conventional (not insured or guaranteed by FHA, VA, RHS, or FSA)
- 2 - Federal Housing Administration insured (FHA)
- 3 - Veterans Affairs guaranteed (VA)
- 4 - USDA Rural Housing Service or Farm Service Agency guaranteed (RHS or FSA)
loan_purpose
- Description: The purpose of covered loan or application
- Values:
- 1 - Home purchase
- 2 - Home improvement
- 31 - Refinancing
- 32 - Cash-out refinancing
- 4 - Other purpose
- 5 - Not applicable
lien_status
- Description: Lien status of the property securing the covered loan, or in the case of an application, proposed to secure the covered loan
- Values:
- 1 - Secured by a first lien
- 2 - Secured by a subordinate lien
reverse_mortgage
- Description: Whether the covered loan or application is for a reverse mortgage
- Values:
- 1 - Reverse mortgage
- 2 - Not a reverse mortgage
- 1111 - Exempt
open-end_line_of_credit
- Description: Whether the covered loan or application is for an open-end line of credit
- Values:
- 1 - Open-end line of credit
- 2 - Not an open-end line of credit
- 1111 - Exempt
business_or_commercial_purpose
- Description: Whether the covered loan or application is primarily for a business or commercial purpose
- Values:
- 1 - Primarily for a business or commercial purpose
- 2 - Not primarily for a business or commercial purpose
- 1111 - Exempt
loan_amount
- Description: The amount of the covered loan, or the amount applied for
- Values:
- Varying values