PDF Data Definitions - Home | Federal Housing Finance Agency

AMA_PUDB_definitions_2016

Data Definitions

Federal Housing Finance Agency Federal Home Loan Bank Purchased Mortgage Files For 2016 Data Release Column 1 Year 2 Assigned ID 3 Bank 4 FIPSStateCode 5 FIPSCountyCode 6 MSA

7 FeatureID 8 Tract 9 MinPer 10 TraMedY 11 LocMedY 12 TractRat 13 Income 14 CurAreY 15 IncRat 16 UPB 17 LTV 18 MortDate 19 AcquDate 20 Purpose

21 Coop

22 Product

23 FedGuar

24 Term 25 AmorTerm 26 SellType

27 NumBor 28 First

Definition Year Loan was reported Unique Record ID (Not Actual Loan Number) Name of Federal Home Loan Bank District FIPS State Code FIPS County Code Core Based Statistical Area 99999=State/County/Tract combination is not located in a CBSA

Geographic Names Information System (GNIS) Feature ID Census Tract Census Tract Minority Percentage Census Tract Median Family Income in Whole Dollars Local Area Median Income in Whole Dollars Tract Income Ratio Total Borrower(s) Annual Income in Whole Dollars Area Median Family Income in Whole Dollars Borrower Income Ratio Acquisition Unpaid Principal Balance in Whole Dollars Loan to Value Ratio at Origination Year of Mortgage Note Year of Acquisition Note Loan Purpose 1=purchase; 2=refinancing; 3=second mortgage; 4=new construction; 5=rehabilitation

Cooperative Unit Mortgage 1=yes; 2=no

Product Type 01=Fixed Rate; 02=ARM; 03=Balloon; 04=GPM/GEM; 05=Reverse Annuity Mortgage; 06=other

Federal Guarantee 0=no federal guarantee; 1=FHA; 2=VA; 3=FMHA-Guaranteed Rural Housing Loan; 4=HECMs; 5=Title1-FHA

Term of Mortgage at Origination in months

Amortization Term in months Type of Acquiring Lender Institution 1=Insured depository institution; 2=Housing Associate; 3=Insurance Company

Number of Borrowers First Time Home Buyer 1=yes; 2=no

Effective 10/18/16

Page 1 of 5

Column 29 CICA

30 BoRace

31 CoRace

32 BoGender 33 CoGender

34 BoAge 35 CoAge 36 Occup 37 NumUnits 38 Bed1 39 Bed2 40 Bed3 41 Bed4 42 Aff1 43 Aff2 44 Aff3

AMA_PUDB_definitions_2016

Definition Code indicating whether the mortgage is on a project funded under an AHP, CIP or other CICA program. 1=AHP; 2=CIP; 3=Other CICA 9=Not Applicable; Not Purchased under AHP, CIP, or CICA

Borrower Race or National Origin 1=American Indian or Alaskan Native; 2=Asian; 3=Black or African American; 4=Native Hawaiian or Other Pacific Islander; 5=White; 7=Information not provided by applicant in mail or telephone application

Co-borrower Race or National Origin 1=American Indian or Alaskan Native; 2=Asian; 3=Black or African American; 4=Native Hawaiian or Other Pacific Islander; 5=White; 7=Information not provided by applicant in mail or telephone application; 8=No Co-Borrower Borrower Gender 1=Male; 2=Female; 3=Information not provided by applicant in mail or telephone application

Co-Borrower Gender 1=Male; 2=Female; 3=Information not provided by applicant in mail or telephone application; 4=No Co-Borrower

Age of Borrower in years 99=Not provided by applicant in mail or telephone application Age of Co-Borrower in years 98=No Co-Borrower; 99=Not provided by applicant in mail or telephone application Occupancy Code 1=Principal residence/owner-occupied; 2=second home; 3=investment property (rental) Number of Units Unit1--Number of Bedrooms 98=no non-owner-occupied dwelling units Unit2--Number of Bedrooms 98=no non-owner-occupied dwelling units Unit3--Number of Bedrooms 98=no non-owner-occupied dwelling units Unit4--Number of Bedrooms 98=no non-owner-occupied dwelling units Unit1--Affordable Category meets the housing goals implemented by HERA Section 1205 1=yes; 2=no

Unit2--Affordable Category meets the housing goals implemented by HERA Section 1205 1=yes; 2=no

Unit3--Affordable Category meets the housing goals implemented by HERA Section 1205 1=yes; 2=no

Page 2 of 5

Column 45 Aff4

46 Rent1 47 Rent2 48 Rent3 49 Rent4 50 RentUt1 51 RentUt2 52 RentUt3 53 RentUt4 54 Geog

55 Rate 56 Amount 57 Front 58 Back 59 BoCreditScor 60 CoBoCreditScor 61 PMI 62 Self 63 PropType

64 ArmIndex

65 ArmMarg 66 PrepayP

AMA_PUDB_definitions_2016

Definition Unit4--Affordable Category meets the housing goals implemented by HERA Section 1205 1=yes; 2=no

Unit1-- Reported Rent Level in whole dollars 9999999999=no non-owner-occupied dwelling units Unit2-- Reported Rent Level in whole dollars 9999999999=no non-owner-occupied dwelling units Unit3-- Reported Rent Level in whole dollars 9999999999=no non-owner-occupied dwelling units Unit4-- Reported Rent Level in whole dollars 9999999999=no non-owner-occupied dwelling units Unit1--Reported Rent Plus Utilities in whole dollars 9999999999=no non-owner-occupied dwelling units Unit2--Reported Rent Plus Utilities in whole dollars 9999999999=no non-owner-occupied dwelling units Unit3--Reported Rent Plus Utilities in whole dollars 9999999999=no non-owner-occupied dwelling units Unit4--Reported Rent Plus Utilities in whole dollars 9999999999=no non-owner-occupied dwelling units Geographically Targeted Indicator indicating whether the property is in census tracts annually classified as underserved by HUD 1=yes; 2=no Interest Rate Loan Amount in Whole Dollars Front-end Ratio Back-end Ratio Credit Scores are separated into ranges: 1 = ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download