HMDA
HMDA
Report type: hmda
About this export
- HMDA required gender, race, and ethnicity questions
- Denial reasons
- Other information that may be helpful in your HMDA filing process
- 1 row per application
caution
- Your organization is responsible for ensuring that your HMDA submission is complete and accurate.
- This report is provided as a convenience to assist with your HMDA filing process.
- Your organization should review the report and make any necessary adjustments before submitting to the appropriate regulatory agency.
| Position | Field Name | Datatype | Mode | Date Added | Definition | Categorical Values | Format Notes | Misc. Notes |
|---|---|---|---|---|---|---|---|---|
| 1 | application_uuid_value | STRING | NON-NULLABLE | 2022-09-21 | Not part of required HMDA fields | |||
| 2 | RecordID | STRING | NON-NULLABLE | 2022-09-21 | Not part of required HMDA fields | |||
| 3 | LEI | STRING | NULLABLE | 2022-09-21 | Legal entity identifier | |||
| 4 | ULI | STRING | NULLABLE | 2022-09-21 | Universal loan identifier | |||
| 5 | ApplDate | STRING | NON-NULLABLE | 2022-09-21 | The date the applicant signed the application summary document | YYYYMMDD | ||
| 6 | LoanType | INTEGER | NULLABLE | 2022-09-21 | Loan type 1. Conventional (not insured or guaranteed by FHA VA RHS or FSA) | 1 | ||
| 7 | Purpose | INTEGER | NULLABLE | 2022-09-21 | Loan purpose 2. Home improvement 4. Other purpose | 2 4 | ||
| 8 | Preapproval | INTEGER | NON-NULLABLE | 2022-09-21 | Preapproval type 1. Preapproval requested 2. Preapproval not requested | 2 | ||
| 9 | ConstructionMethod | INTEGER | NON-NULLABLE | 2022-09-21 | Construction method: 1. Site-built 2. Manufactured Home | 1 | ||
| 10 | OccupancyType | INTEGER | NON-NULLABLE | 2022-09-21 | Occupancy type 1. Principal residence 2. Second residence 3. Investment property | 1 2 3 | ||
| 11 | LoanAmountInDollars | FLOAT | NON-NULLABLE | 2022-09-21 | Loan amount The midpoint for the $10000 interval into which the reported value falls (e.g. for a reported value of $117834 disclose $115000 as the midpoint between values = $110000 and < $120000) | |||
| 12 | Action | INTEGER | NON-NULLABLE | 2022-09-21 | Action Taken 1. Loan originated 2. Application approved but not accepted 3. Application denied 4. Application withdrawn by applicant | 1 2 3 4 | ||
| 13 | ActionDate | STRING | NON-NULLABLE | 2022-09-21 | Action taken date | YYYYMMDD | ||
| 14 | Address | STRING | NON-NULLABLE | 2022-09-21 | Full property address | |||
| 15 | City | STRING | NON-NULLABLE | 2022-09-21 | Property city | |||
| 16 | State_Abrv | STRING | NON-NULLABLE | 2022-09-21 | Property state | |||
| 17 | Zip | STRING | NON-NULLABLE | 2022-09-21 | Property Zipcode | |||
| 18 | County_5 | STRING | NON-NULLABLE | 2022-09-21 | Property county | |||
| 19 | Tract_11 | STRING | NULLABLE | 2022-09-21 | Property tract | |||
| 20 | Ethnicity_1 | INTEGER | NULLABLE | 2022-09-21 | HMDA Ethnicity/Race/Gender questions: 1.Hispanic or Latino 11. Mexican 12. Puerto Rican 13. Cuban 14. Other Hispanic or Latino 2. Not Hispanic or Latino 3. Information not provided by applicant in mail internet or telephone application 4. Not applicable. If the Applicant or Borrower did not select any ethnicity(ies) and only provided ethnicity(ies) in the Ethnicity of Applicant or Borrower: Free Form Text Field for Other Hispanic or Latino, this data field may be left blank. | 1 11 12 13 14 2 3 4 | ||
| 21 | Ethnicity_2 | INTEGER | NULLABLE | 2022-09-21 | ^^ | ^^ | ||
| 22 | Ethnicity_3 | INTEGER | NULLABLE | 2022-09-21 | ^^ | ^^ | ||
| 23 | Ethnicity_4 | INTEGER | NULLABLE | 2022-09-21 | ^^ | ^^ | ||
| 24 | Ethnicity_5 | INTEGER | NULLABLE | 2022-09-21 | ^^ | ^^ | ||
| 25 | EthnicityOther | STRING | NULLABLE | 2022-09-21 | HMDA Ethnicity/Race/Gender questions | |||
| 26 | Coa_Ethnicity_1 | INTEGER | NON-NULLABLE | 2022-09-21 | HMDA Ethnicity/Race/Gender questions 5. No co-applicant. | 5 | Always "5" for HELOCs. Figure does not accept co-borrowers. Figure does require additional signers in situations that require it, but these additional signers are not part of the approval or underwriting process. | |
| 27 | Coa_Ethnicity_2 | INTEGER | NULLABLE | 2022-09-21 | Always blank because no co applicant | |||
| 28 | Coa_Ethnicity_3 | INTEGER | NULLABLE | 2022-09-21 | Always blank because no co applicant | |||
| 29 | Coa_Ethnicity_4 | INTEGER | NULLABLE | 2022-09-21 | Always blank because no co applicant | |||
| 30 | Coa_Ethnicity_5 | INTEGER | NULLABLE | 2022-09-21 | Always blank because no co applicant | |||
| 31 | Coa_EthnicityOther | INTEGER | NULLABLE | 2022-09-21 | HMDA Ethnicity/Race/Gender questions | |||
| 32 | Ethnicity_Determinant | INTEGER | NON-NULLABLE | 2022-09-21 | HMDA Ethnicity/Race/Gender questions Descriptions: 1. Collected on the basis of visual observation or surname 2. Not collected on the basis of visual observation or surname 3. Not applicable | 1 2 3 | Never 1 | |
| 33 | Coa_Ethnicity_Determinant | INTEGER | NON-NULLABLE | 2022-09-21 | HMDA Ethnicity/Race/Gender questions Descriptions: 1. Collected on the basis of visual observation or surname 2. Not collected on the basis of visual observation or surname 3. Not applicable 4. No co-applicant | 1 2 3 4 | Always 4 | |
| 34 | Race_1 | INTEGER | NULLABLE | 2022-09-21 | HMDA Ethnicity/Race/Gender questions: Descriptions: 1. American Indian or Alaska Native 2. Asian 21. Asian Indian 22. Chinese 23. Filipino 24. Japanese 25. Korean 26. Vietnamese 27. Other Asian 3. Black or African American 4. Native Hawaiian or Other Pacific Islander 41. Native Hawaiian 42. Guamanian or Chamorro 43. Samoan 44. Other Pacific Islander 5. White 6. Information not provided by applicant in mail internet or telephone application 7. Not applicable. If the Applicant or Borrower did not select any race(s) and only provided race(s) in the Race of Applicant or Borrower: Free Form Text Field for American Indian or Alaska Native Enrolled or Principal Tribe, Race of Applicant or Borrower: Free Form Text Field for Other Asian, and/or Race of Applicant or Borrower: Free Form Text Field for Other Pacific Islander, either leave this data field blank or enter, as appropriate, Code 1, 27, or 44. | 1 2 21 22 23 24 25 26 27 3 4 41 42 43 44 5 6 7 | ||
| 35 | Race_2 | INTEGER | NULLABLE | 2022-09-21 | ^^ | ^^ | ||
| 36 | Race_3 | INTEGER | NULLABLE | 2022-09-21 | ^^ | ^^ | ||
| 37 | Race_4 | INTEGER | NULLABLE | 2022-09-21 | ^^ | ^^ | ||
| 38 | Race_5 | INTEGER | NULLABLE | 2022-09-21 | ^^ | ^^ | ||
| 39 | Race1_other | STRING | NULLABLE | 2022-09-21 | HMDA Ethnicity/Race/Gender questions: Populated if race code 1 is selected AND the borrower chose to enter an additional designation in the freeform text field | |||
| 40 | Race27_other | STRING | NULLABLE | 2022-09-21 | HMDA Ethnicity/Race/Gender questions: Populated if race code 27 is selected AND the borrower chose to enter an additional designation in the freeform text field | |||
| 41 | Race44_other | STRING | NULLABLE | 2022-09-21 | HMDA Ethnicity/Race/Gender questions: Populated if race code 44 is selected AND the borrower chose to enter an additional designation in the freeform text field | |||
| 42 | CoaRace_1 | INTEGER | NON-NULLABLE | 2022-09-21 | HMDA Ethnicity/Race/Gender questions: 8. No co-applicant. | 8 | Always 8 for no co-applicant | |
| 43 | CoaRace_2 | INTEGER | NULLABLE | 2022-09-21 | Always blank because no co applicant | |||
| 44 | CoaRace_3 | INTEGER | NULLABLE | 2022-09-21 | Always blank because no co applicant | |||
| 45 | CoaRace_4 | INTEGER | NULLABLE | 2022-09-21 | Always blank because no co applicant | |||
| 46 | CoaRace_5 | INTEGER | NULLABLE | 2022-09-21 | Always blank because no co applicant | |||
| 47 | CoaRace1_Other | STRING | NULLABLE | 2022-09-21 | Always blank because no co applicant | |||
| 48 | CoaRace27_Other | STRING | NULLABLE | 2022-09-21 | Always blank because no co applicant | |||
| 49 | CoaRace44_Other | STRING | NULLABLE | 2022-09-21 | Always blank because no co applicant | |||
| 50 | Race_Determinant | INTEGER | NON-NULLABLE | 2022-09-21 | HMDA Ethnicity/Race/Gender questions: Descriptions: 1. Collected on the basis of visual observation or surname 2. Not collected on the basis of visual observation or surname 3. Not applicable | 1 2 3 | Never 1 | |
| 51 | Coa_Race_Determinant | INTEGER | NON-NULLABLE | 2022-09-21 | HMDA Ethnicity/Race/Gender questions: 4. No co-applicant | 4 | Always 4 | |
| 52 | Sex | INTEGER | NON-NULLABLE | 2022-09-21 | HMDA Ethnicity/Race/Gender questions 1. Male 2. Female 3. Information not provided by applicant in mail internet or telephone application 4. Not applicable 6. Applicant selected both male and female | 1 2 3 4 6 | Comma-separated list. | |
| 53 | CoaSex | INTEGER | NON-NULLABLE | 2022-09-21 | HMDA Ethnicity/Race/Gender questions 5. No co-applicant | 5 | Always 5 | |
| 54 | Sex_Determinant | INTEGER | NON-NULLABLE | 2022-09-21 | HMDA Ethnicity/Race/Gender questions 1. Collected on the basis of visual observation or surname 2. Not collected on the basis of visual observation or surname 3. Not applicable | 1 2 3 | Never 1 | |
| 55 | CoaSex_Determinant | INTEGER | NON-NULLABLE | 2022-09-21 | HMDA Ethnicity/Race/Gender questions 4. No co-applicant | 4 | Always 4 | |
| 56 | Age | INTEGER | NON-NULLABLE | 2022-09-21 | HMDA Ethnicity/Race/Gender questions | 8888 if Age is not available. | ||
| 57 | Coa_Age | INTEGER | NON-NULLABLE | 2022-09-21 | HMDA Ethnicity/Race/Gender questions 9999 if No-Co-Applicant | 9999 | ||
| 58 | Income | INTEGER | NON-NULLABLE | 2022-09-21 | Borrower income | |||
| 59 | Purchaser | INTEGER | NON-NULLABLE | 2022-09-21 | Purchaser 9. Other type of purchaser | 9 | ||
| 60 | Rate_spread | FLOAT | NON-NULLABLE | 2022-09-21 | Rate spread | (-99) - 99 | ||
| 61 | HOEPA_Status | INTEGER | NON-NULLABLE | 2022-09-21 | Home Ownership and Equity Protection Act status 1. High-cost mortgage 2. Not a high-cost mortgage 3. Not applicable | 1 2 3 | Never 1 | |
| 62 | Lien_Status | INTEGER | NON-NULLABLE | 2022-09-21 | Lien status position 1. Secured by a first lien 2. Secured by a subordinate lien | 1 2 | Never 1 | |
| 63 | CreditScore | INTEGER | NON-NULLABLE | 2022-09-21 | Credit score of borrower | |||
| 64 | Coa_CreditScore | INTEGER | NON-NULLABLE | 2022-09-21 | ||||
| 65 | CreditModel | INTEGER | NON-NULLABLE | 2022-09-21 | Credit model | 0-10 | ||
| 66 | CreditModelOther | STRING | NULLABLE | 2022-09-21 | Credit model name | |||
| 67 | Coa_CreditModel | INTEGER | NON-NULLABLE | 2022-09-21 | COA Credit model 10. No co-applicant | 10 | Always 10 | |
| 68 | Coa_CreditModelOther | STRING | NULLABLE | 2022-09-21 | Credit model name | |||
| 69 | DENIAL1 | INTEGER | NULLABLE | 2022-09-21 | Denial code 1 Descriptions: 1. Debt-to-income ratio 2. Employment history 3. Credit history 4. Collateral 5. Insufficient cash (downpayment closing costs) 6. Unverifiable information 7. Credit application incomplete 8. Mortgage insurance denied 9. Other 10. Not applicable | 1 2 3 4 5 6 7 8 9 10 | ||
| 70 | DENIAL2 | INTEGER | NULLABLE | 2022-09-21 | ^^ | ^^ | ||
| 71 | DENIAL3 | INTEGER | NULLABLE | 2022-09-21 | ^^ | ^^ | ||
| 72 | DENIAL4 | INTEGER | NULLABLE | 2022-09-21 | ^^ | ^^ | ||
| 73 | DenialOther | STRING | NULLABLE | 2022-09-21 | Other denial reasons | Other denail reasons | ||
| 74 | TotalLoanCosts | STRING | NULLABLE | 2022-09-21 | Total loan costs | |||
| 75 | TotalPtsAndFees | STRING | NULLABLE | 2022-09-21 | Total points and fees | |||
| 76 | OrigFees | STRING | NULLABLE | 2022-09-21 | Origination fees | |||
| 77 | DiscountPts | STRING | NULLABLE | 2022-09-21 | Discount points | |||
| 78 | LenderCredts | STRING | NULLABLE | 2022-09-21 | Lender credits | |||
| 79 | InterestRate | STRING | NULLABLE | 2022-09-21 | Interest rate | |||
| 80 | PPPTerm | STRING | NULLABLE | 2022-09-21 | PPP Term | |||
| 81 | DTIRatio | FLOAT | NULLABLE | 2022-09-21 | Debt to income ratio | 0-999999999 | ||
| 82 | CLTV | FLOAT | NULLABLE | 2022-09-21 | Cash loan to value | 0-999999999 | ||
| 83 | Loan_Term_Months | FLOAT | NULLABLE | 2022-09-21 | Loan term months | |||
| 84 | IntroRatePeiod | STRING | NULLABLE | 2022-09-21 | Intoductory rate period | |||
| 85 | BalloonPMT | INTEGER | NON-NULLABLE | 2022-09-21 | Balloon payment 1. Balloon payment 2. No balloon payment | 1 2 | ||
| 86 | IOPMT | INTEGER | NON-NULLABLE | 2022-09-21 | Interest Only Payments 1. Interest-only payments 2. No interest-only payments | 1 2 | ||
| 87 | NegAM | INTEGER | NON-NULLABLE | 2022-09-21 | Negative Amortization 2. No negative amortization | 2 | ||
| 88 | NonAMortz | INTEGER | NON-NULLABLE | 2022-09-21 | Other Non-amortizing Features: 2. No other non-fully amortizing features | 2 | ||
| 89 | PropertyValue | INTEGER | NON-NULLABLE | 2022-09-21 | Property value | 0-999999999 | ||
| 90 | MHSecPropType | INTEGER | NULLABLE | 2022-09-21 | MH secondary property type 3. Not applicable | 3 | ||
| 91 | MHLandPropInt | INTEGER | NON-NULLABLE | 2022-09-21 | MHLandPropInt: 5. Not applicable | 5 | ||
| 92 | TotalUnits | INTEGER | NON-NULLABLE | 2022-09-21 | Total units | 1 2 3 4 | ||
| 93 | MFAHU | STRING | NON-NULLABLE | 2022-09-21 | Multifamily Affordable Units | |||
| 94 | APPMethod | INTEGER | NON-NULLABLE | 2022-09-21 | Application method 1. Submitted directly to your institution | 1 | ||
| 95 | PayableInst | INTEGER | NON-NULLABLE | 2022-09-21 | Payable instrument 1. Initially payable to your institution | 1 | ||
| 96 | AUSystem1 | INTEGER | NON-NULLABLE | 2022-09-21 | Automated Underwriting System: 1 6. Not applicable | 6 | ||
| 97 | AUSystem2 | INTEGER | NULLABLE | 2022-09-21 | Automated Underwriting System: 2 | Always blank | ||
| 98 | AUSystem3 | INTEGER | NULLABLE | 2022-09-21 | Automated Underwriting System: 3 | Always blank | ||
| 99 | AUSystem4 | INTEGER | NULLABLE | 2022-09-21 | Automated Underwriting System: 4 | Always blank | ||
| 100 | AUSystem5 | INTEGER | NULLABLE | 2022-09-21 | Automated Underwriting System: 5 | Always blank | ||
| 101 | AUSystemOther | STRING | NULLABLE | 2022-09-21 | Automated Underwriting System: Other | Always blank | ||
| 102 | AUResult1 | INTEGER | NON-NULLABLE | 2022-09-21 | Automated Underwriting System 1: Result | 17 | ||
| 103 | AUResult2 | INTEGER | NULLABLE | 2022-09-21 | Automated Underwriting System 2: Result | Always blank | ||
| 104 | AUResult3 | INTEGER | NULLABLE | 2022-09-21 | Automated Underwriting System 3: Result | Always blank | ||
| 105 | AUResult4 | INTEGER | NULLABLE | 2022-09-21 | Automated Underwriting System 4: Result | Always blank | ||
| 106 | AUResult5 | INTEGER | NULLABLE | 2022-09-21 | Automated Underwriting System 5: Result | Always blank | ||
| 107 | AUResultOther | STRING | NULLABLE | 2022-09-21 | Automated Underwriting System Other: Result | Always blank | ||
| 108 | REVMTG | INTEGER | NON-NULLABLE | 2022-09-21 | Reverse Mortgage: 2. Not a reverse mortgage | 2 | ||
| 109 | OpenLOC | INTEGER | NON-NULLABLE | 2022-09-21 | Open line of credit: 1. Open-end line of credit | 1 | ||
| 110 | BUSCML | INTEGER | NON-NULLABLE | 2022-09-21 | BUSCML: 2. Not primarily for a business or commercial purpose | 2 | ||
| 111 | organization | STRING | NON-NULLABLE | 2022-09-21 | Organization name | Not part of required HMDA fields | ||
| 112 | nmls_mlo_id | STRING | NULLABLE | 2022-09-21 | NLMS MLO ID | |||
| 113 | full_name | STRING | NULLABLE | 2022-09-21 | MLO full name | |||
| 114 | mlo_employee_id | STRING | NULLABLE | 2022-09-21 | MLO employee ID | |||
| 115 | referring_mlo_name | STRING | NULLABLE | 2022-09-21 | Referring MLO name | |||
| 116 | referring_mlo_nmls_no | STRING | NULLABLE | 2022-09-21 | Referring MLO NMLS number |