New this month, Premise ID: The Premise ID is an "umbrella" number the Multifamily Insurance System (MFIS) assigns to a "property." Each active or terminated FHA loan secured by a particular "property" will have the same 10-digit Premise ID. Use the Premise ID to join active and terminated loans associated with the same property. Some Examples:  

• If an active 221d4 loan has a subordinate 241a additions loan, the 221d4 and the 241a loans will have different FHA Project Numbers, but the same Premise ID.
• If a 223a7 refinances a 223f loan, the active 223a7 loan and the terminated 223f loan will have different FHA Project Numbers but the same Premise ID.

This Excel 2003 file includes all active HUD Multifamily insured mortgages. The data is as of January 31, 2013 and is updated monthly. It is extracted from MFIS and includes the following data elements:

FHA Project Number
Premise ID
Project Name
Project Street
Project City
Project State
Project Zip Code
Number of total Units (or total beds for health and hospital care)
Initial Endorsement Date
Final Endorsement Date
Original Mortgage Amount
First Payment Date
Maturity Date
Term of loan in months
Interest Rate
Monthly Principal and Interest Payment
Amortized Unpaid Principal Balance
Holder Name
Holder City
Holder State
Servicer Name
Servicer City
Servicer State
Section of the Act Code (SoA)
Section of the Act Category/Sub Category

Tax Exempt Bond Financing Code (Mortgages financed by tax exempt bonds are indicated by "TE" code. This field was updated on new endorsements beginning in CY 2000).

Tax Credit Code (Mortgages that include Low Income Housing Tax Credits (LIHTC) are indicated by the "TC" code. This field was updated on endorsements beginning in the middle of 1998).
 

This file can be used with current or past versions of Access or Excel going back until at least 2000. If you wish to use the file in an Access database, simply select the option in Access to import an Excel file.

EXCEL 2003 FORMAT