Skip to main content

Public LAR - Schema

FieldMax LengthType
activity_year4Numeric
lei20Alphanumeric
derived_msa_md5Alphanumeric
state_code2Alphanumeric
county_code5Alphanumeric
census_tract11Alphanumeric
conforming_loan_limit2Alphanumeric
derived_loan_product_type29Alphanumeric
derived_dwelling_category38Alphanumeric
derived_ethnicity23Alphanumeric
derived_race41Alphanumeric
derived_sex17Alphanumeric
action_taken1Numeric
purchaser_type1Numeric
preapproval1Numeric
loan_type1Numeric
loan_purpose2Numeric
lien_status1Numeric
reverse_mortgage4Numeric
open_end_line_of_credit4Numeric
business_or_commercial_purpose4Numeric
loan_amountAlphanumeric
combined_loan_to_value_ratioAlphanumeric
interest_rateAlphanumeric
rate_spreadAlphanumeric
hoepa_status1Numeric
total_loan_costsAlphanumeric
total_points_and_feesAlphanumeric
origination_chargesAlphanumeric
discount_pointsAlphanumeric
lender_creditsAlphanumeric
loan_termAlphanumeric
prepayment_penalty_termAlphanumeric
intro_rate_periodAlphanumeric
negative_amortization4Numeric
interest_only_payment4Numeric
balloon_payment4Numeric
other_nonamortizing_features4Numeric
property_valueAlphanumeric
construction_method1Numeric
occupancy_type1Numeric
manufactured_home_secured_property_type4Numeric
manufactured_home_land_property_interest4Numeric
total_units7Alphanumeric
multifamily_affordable_units6Alphanumeric
incomeAlphanumeric
debt_to_income_ratioAlphanumeric
applicant_credit_score_type4Numeric
co_applicant_credit_score_type4Numeric
applicant_ethnicity_12Alphanumeric
applicant_ethnicity_22Alphanumeric
applicant_ethnicity_32Alphanumeric
applicant_ethnicity_42Alphanumeric
applicant_ethnicity_52Alphanumeric
co_applicant_ethnicity_12Alphanumeric
co_applicant_ethnicity_22Alphanumeric
co_applicant_ethnicity_32Alphanumeric
co_applicant_ethnicity_42Alphanumeric
co_applicant_ethnicity_52Alphanumeric
applicant_ethnicity_observed1Alphanumeric
co_applicant_ethnicity_observed1Alphanumeric
applicant_race_12Alphanumeric
applicant_race_22Alphanumeric
applicant_race_32Alphanumeric
applicant_race_42Alphanumeric
applicant_race_52Alphanumeric
co_applicant_race_12Alphanumeric
co_applicant_race_22Alphanumeric
co_applicant_race_32Alphanumeric
co_applicant_race_42Alphanumeric
co_applicant_race_52Alphanumeric
applicant_race_observed1Numeric
co_applicant_race_observed1Numeric
applicant_sex1Numeric
co_applicant_sex1Numeric
applicant_sex_observed1Numeric
co_applicant_sex_observed1Numeric
applicant_ageAlphanumeric
co_applicant_ageAlphanumeric
applicant_age_above_62Alphanumeric
co_applicant_age_above_62Alphanumeric
submission_of_application4Alphanumeric
initially_payable_to_institution4Alphanumeric
aus_14Numeric
aus_21Alphanumeric
aus_31Alphanumeric
aus_41Alphanumeric
aus_51Alphanumeric
denial_reason_14Alphanumeric
denial_reason_21Alphanumeric
denial_reason_31Alphanumeric
denial_reason_41Alphanumeric
tract_populationNumeric
tract_minority_population_percentNumeric
ffiec_msa_md_median_family_incomeNumeric
tract_to_msa_income_percentageNumeric
tract_owner_occupied_unitsNumeric
tract_one_to_four_family_homesNumeric
tract_median_age_of_housing_unitsNumeric

ffiec.cfpb.gov

An official website of the CFPB's HMDA  v3.0.9

Looking for U.S. government information and services?  
Visit USA.gov