2 3 A B C D E F H I L M N O P R S T W X Y Z

Display Name	Definition
2
202/811 Loans or Grants	A yes/no indicator signifying whether the property has any 202 or 811 loans or grants. A 202 loan or grant is a HUD program that offers interest free capital advances to finance the development of supportive elder rental housing. Typically serves 0 - 50% of area median income. An 811 grant or loan is a HUD program that offers interest free capital advances to finance the development of rental housing for very low income (typically 0 - 30% of area median income) adults with disabilities.
221/d3 Loans	A yes/no indicator signifying whether any of the active financing for the property are 221/d3 loans. 221/d3 loans originally provided the owner with a below market interest rate of 3% and were targeted towards non-profit organizations.
221/d4 Loans	A yes/no indicator signifying whether any of the active financing for the property are 221/d4 loans. 221/d4 loans originally provided the owner with a below market interest rate of 4% and were targeted towards profit motivated entities.
236 Loans	A yes/no indicator signifying whether any of the active financing for the property are 236 loans. 236 loans provide a subsidy to reduce mortgage interest payments to provide rental housing for households making 0 - 80% of area median income.
2nd Subsidy Contract Number	Contract number for the secondary type of subsidy used to ensure affordability for the property.
2nd Subsidy Expiration Date	Contract expiration date for the secondary type of subsidy used to ensure affordability for the property.
2nd Subsidy Notes	Explanatory notes for the secondary type of subsidy used to ensure affordability for the property.
2nd Subsidy Program	The secondary type of subsidy used to ensure affordability for the property, for example: HUD Insured, Low Income Housing Tax Credits (LIHTC), Rural Development, Section 8 Uninsured.
^ Top 3
3rd Subsidy Contract Number	Contract number for the tertiary type of subsidy used to ensure affordability for the property.
3rd Subsidy Expiration Date	Contract expiration date for the tertiary type of subsidy used to ensure affordability for the property.
3rd Subsidy Notes	Explanatory notes for the tertiary type of subsidy used to ensure affordability for the property.
3rd Subsidy Program	The tertiary type of subsidy used to ensure affordability for the property, for example: HUD Insured, Low Income Housing Tax Credits (LIHTC), Rural Development, Section 8 Uninsured.
^ Top A
Allocation Year	The year in which the state has allocated tax credits to this project.
Assisted Living Loans	A yes/no indicator signifying whether any of the active financing for the property are loans for an assisted living property.
Associated Financing Number	For a property with active financing, this is the FHA number or the 202/811 number.
^ Top B
BMIR Loans	A yes/no indicator signifying whether the property has any active financing that includes a below market interest rate (BMIR) loan.
Board and Care Loans	A yes/no indicator signifying whether any of the active financing for the property are loans for a board and care property.
^ Top C
CDBG Funds	A yes/no indicator signifying whether the property received CDBG funds.
Census Tract Number, 2000	The census tract number of the property for the 2000 census.
Co-Insured Loans	A yes/no indicator signifying whether the property has any active financing that includes a co-insured loan.
Congressional District Code	The property's congressional district code.
Construction Loan Date (RD Only)	The date of the construction loan. This information is available for Rural Development Properties only.
Contract Document Type	Indicates type of subsidy contract, i.e. HUD Housing Assistance payment Contract, USDA Rural Development Rental Assistance Contract.
Contract renewal submitted?	This field indicates whether a notice has been submitted indicating that the owner wishes to renew their contract. If the answer is no, no such notice has been submitted.
Contract Term, Months	The number of months in the term of the contract.
Count: 0 Bedroom	The number of units for this specific bedroom size - studio or efficiency - that receive assistance under this contract.
Count: 1 Bedroom	The number of units for this specific bedroom size - one bedroom - that receive assistance under this contract.
Count: 2 Bedroom	The number of units for this specific bedroom size - two bedroom - that receive assistance under this contract.
Count: 3 Bedroom	The number of units for this specific bedroom size - three bedroom - that receive assistance under this contract.
Count: 4 Bedroom	The number of units for this specific bedroom size - four bedroom - that receive assistance under this contract.
Count: 5+ Bedroom	The number of units for this specific bedroom size - five plus bedrooms - that receive assistance under this contract.
County FIPS Code, 2000	The County FIPS (Federal Information Processing Standard) Code for the year 2000.
Current Expiration Date	The expiration date of the current term of the contract. If there are multiple terms in the contract, this date is before the overall expiration date.
Current rents: 0 Bedrooms	The current rent for any units in the building that are zero bedroom, studio or efficiency. If no such units exist, the field will be zero.
Current rents: 1 Bedroom	The current rent for any units in the building that are one bedroom. If no such units exist, the field will be zero.
Current Rents: 2 Bedroom	The current rent for any units in the building that are two bedroom. If no such units exist, the field will be zero.
Current Rents: 3 Bedroom	The current rent for any units in the building that are three bedroom. If no such units exist, the field will be zero.
Current Rents: 4 Bedroom	The current rent for any units in the building that are four bedroom. If no such units exist, the field will be zero.
Current Rents: 5 plus Bedroom	The current rent for any units in the building that are five plus bedrooms. If no such units exist, the field will be zero.
^ Top D
Date of Last Data Update	The date of last update to the data in this database.
Date submitted.	The date the opt-out notice was submitted.
^ Top E
Effective Date	The effective date of the current contract.
ELIHPA	“Emergency Low Income Housing Preservation Act” (ELIHPA). A yes/no indicator signifying whether the property has an approved Plan of Action under the Emergency Low Income Housing Preservation Act (ELIHPA). Sometimes referred to as Title II.
^ Top F
Fair Market Rent: 0 Bedroom	The Fair Market Rent for this specific bedroom size (zero, studio or efficiency). If no such units exist, the field will be zero.
Fair Market Rent: 1 Bedroom	The Fair Market Rent for this specific bedroom size (one bedroom). If no such units exist, the field will be zero.
Fair Market Rent: 2 Bedroom	The Fair Market Rent for this specific bedroom size (two bedroom). If no such units exist, the field will be zero.
Fair Market Rent: 3 Bedroom	The Fair Market Rent for this specific bedroom size (three bedroom). If no such units exist, the field will be zero.
Fair Market Rent: 4 Bedroom	The Fair Market Rent for this specific bedroom size (four bedroom). If no such units exist, the field will be zero.
FHA Insured Loans	Indicates whether the property received FHA Insured Loans.
Financing Adjustment Factor (FAF)	A yes/no indicator signifying whether the property has received a Financing Adjustment Factor (FAF). Under a bond-refunder agreement with HUD, project cost savings resulting from reduced debt service are shared between OHCS and HUD.
FIPS Code, 2000	The Unique 2000 Census ID. Digits 1-2 indicate the State FIPS Code, digits 3-5 indicate the County FIPS (Federal Information Processing Standard) Code and digits 6-11 indicate the census tract number.
FIPS Place Code, 2000	FIPS (Federal Information Processing Standard) Place Code, 2000
Flag: Year Missing	Indicates how missing Year Placed in Service and Allocation Year data are handled. 0=Data complete, 1=Missing Allocation Year replaced with Year Placed in Service, 2=Missing Year Placed in Service replaced with Allocation Year.
FMHA Section 515 Loans	Indicates whether an FMHA Section 515 Loan was received.
^ Top H
HOME Funds	Indicates whether the property received HOME Funds.
Hospital Loans	A yes/no indicator signifying whether any of the active financing for the property are loans for a hospital.
Housing Assistance Payment Expiration	Original expiration date of the Housing Assistance Payment contract.
Housing Assistance Payment Renewed	A Yes/No indicator signifying whether the owner has renewed the Housing Assistance Payment contract. If the field is blank, the contract has not yet expired.
HUD Administered	Indicates whether HUD is the administrator of the contract.
HUD Contact	Name of a contact person at the US Department of Housing and Urban Development who can provide information on this property loan or financing. This information is subject to change.
HUD Contract Number	The Contract number assigned to this property by the US Department of Housing and Urban Development, if available.
HUD held loans	A yes/no indicator signifying whether any active financing instruments associated with the property are HUD-held loans.
HUD ID	The ID number assigned by the US Department of Housing and Urban Development, if available.
HUD Owned	A yes/no indicator signifying whether the property is HUD owned.
HUD Property Category	Indicates a HUD program: Subsidized, No HUD Financing, HUD Owned, HUD Held, 202/811, Insured-Subsidized, Insured-Unsubsidized.
HUD Property ID	The ID number assigned to this property by the US Department of Housing and Urban Development, if available.
HUD Status	Field indicates whether the property is considered "active" by HUD, i.e. project has active subsidy contract or insured mortgage.
^ Top I
ID	Unique identifier for each property included in this database.
In Difficult Development Area Census Tract	Indicates whether the property is in a Difficult Development Area Census Tract. 0=not in DDA; 1=in Metro DDA; 2=in non-Metro DDA
In Metro Area Census Tract	Indicates whether the property is in a metro area census tract. 1=Metro/Non-central; 2=Metro/Central City; 3=Non-Metro
In Qualified Census Tract	Indicates whether the property is in a Qualified Census Tract. 1=in a qualified tract; 2=not in a qualified tract
Increase in Eligible Basis	Indicates whether the property has experienced an increase in eligible basis.
Insured	A yes/no indicator signifying whether the property has any active financing that is associated with insurance.
^ Top L
Latitude	A measurement, in degrees which gives the location of a place on earth north or south of the equator.
LIHTC Year 15	The final year of the fifteen year compliance period imposed by the LIHTC program.
LIHPRHA	“Low Income Housing Preservation and Resident Homeownership Act” (LIHPRHA). A yes/no indicator signifying whether the property has an approved Plan of Action under the Low Income Housing Preservation and Resident Homeownership Act (LIHPRHA). Sometimes referred to as Title VI.
Longitude	A measurement, in degrees which gives the location of a place on earth in relation to the Greenwich Meridian.
^ Top M
Management Agent Address 1	Address, Line 1 of the management agent.
Management Agent Address 2	Address, Line 2 of the management agent.
Management Agent City	City of the management agent.
Management Agent Company Type	Type of Management Agent's company, i.e., Limited Dividend, Non-Profit, Other or Profit Motivated.
Management Agent Email	Email address of the management agent.
Management Agent Fax	Fax number of the management agent.
Management Agent First Name	First name of the management agent.
Management Agent Full Name	Full name of the management agent.
Management Agent HUD ID	The identification number assigned by the US Department of Housing and Urban Development for this Management Agent.
Management Agent Last Name	Last name of the management agent.
Management Agent Middle Name	Middle name of the management agent.
Management Agent Organization Name	Organization name of the management agent.
Management Agent Phone	Phone number of the management agent.
Management Agent State	State of the management agent.
Management Agent Title	Title of the management agent.
Management Agent Zip Code	Zip code of the management agent.
Management Agent Zip plus 4	Four digit zip code extension of the management agent.
MIP Loans	A yes/no indicator signifying whether the property is paying a Mortgage Insurance Premium.
Month Paid	Indicates the month that the loan was paid off. If the field is blank, the loan has not yet been paid off.
Mortgage Maturity Date	The mortgage's maturity date.
Mortgage Requirement	Indicates whether the mortgage is subject to old regulations or new regulations, if the property has a mortgage with the state housing finance agency.
MSA Name	The property's metropolitan statistical area name.
Multiple Subsidies or Contracts?	The property has multiple subsidies or contracts from one or more federal or state government agency. Please see notes section for details.
^ Top N
Non Insured Loans	A yes/no indicator signifying whether the property has any active financing that includes a non-insured loan.
Non Profit Sponsor?	Indicates whether the tax credits associated with the property have a non profit sponsor. 1= Yes, 2= No
Non-Monitored Program	An indicator used by HUD, (1= Yes) indicating that the program is no longer monitored for the LIHTC program due to expired use or other reason. It does not indicate whether the project remains affordable.
Notes	General property notes
Number of units for elderly	The number of units designated for elderly residents by the property.
Number of units for families	The number of units designated for families by the property.
Nursing Home Loans	A yes/no indicator signifying whether any of the active financing for the property are loans for a nursing home.
^ Top O
OHCS ID	The ID number assigned by Oregon Housing and Community Services, if available.
Old ACC Indicated	Indicates whether the contract is an older version of the Annual Contributions Contract (ACC) that provided fewer restrictions on the ability to take out residual receipts when the contract is terminated.
Overall expiration Date	The overall expiration date of the contract.
Overall expiration Fiscal Year	The overall expiration Fiscal Year of the contract. Note: Fiscal Year is defined as October 1 - September 30 for this field.
Overall expiration quarter	The overall expiration quarter of the contract. Q1 = 10/01 - 12/31, Q2 = 01/01 - 03/31, Q3 = 04/01 - 06/30, Q4 = 07/01-9/30.
Owner Address Line 1	Address, Line 1 of the owner
Owner Address Line 2	Address, Line 2 of the owner.
Owner City	City of the owner.
Owner Company Type	Type of Owner's Company, i.e., Limited Dividend, Non-Profit, Profit Motivated, or Other.
Owner Email	Email address of the owner.
Owner Fax Number	Fax number of the owner.
Owner First Name	First name of the owner.
Owner Full Name	Full name of the owner.
Owner HUD ID	The identification number assigned by the US Department of Housing and Urban Development for this owner.
Owner Last Name	Last name of the owner.
Owner Middle Name	Middle name of the owner.
Owner Organization Name	Organization name of the owner.
Owner Phone Number	Phone number of the owner.
Owner State	State of the owner.
Owner Title	Title of the owner.
Owner Zip	Zip code of the owner.
Owner Zip plus 4	Four digit zip code extension of the owner.
Ownership effective date	The effective date of ownership for the current owners.
^ Top P
Population Served	The type of population served by the property, i.e., families, elderly, disabled.
Primary Contact Address	The address of the company or person deemed to be the primary contact for the property.
Primary Contact City	The city of the company or person deemed to be the primary contact for the property.
Primary Contact Company	The name of the company deemed to be the primary contact for the property.
Primary Contact Email	The email of the company or person deemed to be the primary contact for the property.
Primary Contact Fax	The fax number of the company or person deemed to be the primary contact for the property.
Primary Contact First Name	The first name of the person deemed to be the primary contact person for the property.
Primary Contact Last Name	The last name of the person deemed to be the primary contact person for the property.
Primary Contact Phone	The phone number of the company or person deemed to be the primary contact for the property.
Primary Contact State	The state of the company or person deemed to be the primary contact for the property.
Primary Contact Website	Website of the person deemed to be the primary contact person for the property.
Primary Contact Zip Code	The zip code of the company or person deemed to be the primary contact for the property.
Primary Contact Zip Code plus 4	The 4-digit zip code extension of the company or person deemed to be the primary contact for the property.
Primary Financing	This field identifies the primary type of financing associated with the property. This field is used for properties associated with HUD. The possible financing types are: Insured, 202/811, HUD Owned, HUD Held, or Non-Insured.
Program Type Code	HUD field defined as a derived field based on the program type name and contract document type. Based on program type name, 202/8NC=202, 202/8SR=202, 515/8NC=515, 515/8SR=515, HFDA/8NC=HFDA, HFDA/8SR=HFDA, LMSA=LMSA, 202/162MR=PAC, 202/162NC=PAC, 202/162SR=PAC, PAC/202=PAC, PAC/811=PAC, PAC/202=PAC, PAC/202=PAC, PAC/811=PAC, PD/8Existing=PD, PD/8MR=PD, PD/8SR=PD, PRAC/202= 202 with Project Rental Assistance Contract/811= 811 with Project Rental Assistance Contract, Preservation=PRES, RAP=RAP, Rent Supplement=SUPP, Sec 8 Substantial Rehab=S8SR, Sec 8 New Construction=S8NC, Contains Service Coo=Service Coordinator, contains UnasstPrj = Unassisted Project, SCRAP= Service Coordinator, All others=UNK.
Program Type Group Name	HUD Field defined as a derived field based on the program type group code: 202=Sec. 202,515=S8 FmHA, HFDA=S8 State Agency, LMSA=S8 Loan Mgmt, PAC=PAC 202/811, PD=S8 Prop. Disp., PRAC=PRAC 202/811, PRES=S8 Preservation, RAP= Sec. 236 RAP, SUPP=Rent Supplement, S8NC=Other S8 New, S8SR=Other S8 Rehab, Service Coordinator=Service Coordinator, All others=Unknown.
Program Type Name	The name of the program type.
Property Address 1	The address, line 1, of the property.
Property Address 2	The address, line 2, of the property.
Property City	The city of the property.
Property County	The property's county name.
Property County Code	The county code for the property.
Property Zip+4 Code	The four digit zip code extension of the property's address
^ Top R
REAC Score	REAC Score as assigned by HUD. REAC Scores are the result of an inspection by the Real Estate Assessment Center. These assessments review the physical quality of buildings.
Refinanced Loans	A yes/no indicator signifying whether any of the active financing for the property has been refinanced.
Rent to FMR Description	A description of the Rent to FMR Ratio as determined above.
Rent to FMR Ratio	Ratio of the rent gross amount to the Fair Market Rent gross amount. This field is determined through a HUD formula.
Risk Sharing Loans	A yes/no indicator signifying whether the property has an active financing that includes a risk-sharing loan.
RUP Expiration Date	USDA Rural Development Restrictive Use Provision expiration date.
^ Top S
Short Term Renewal	Renewal term of less than one year – sometimes used by HUD to extend contract term when required one-year contract expiration notice has not been provided by owner.
State House District Code	The property's state house district code.
State Senate District Code	The property's state senate district code.
Status	An index that assesses the property's potential to lose its use restrictions and affordability. Possible options include: For Sale (property is currently for sale), Status 1 (property's potential to lose its use restrictions and affordability is high), Status 2 (property's potential to lose its use restrictions and affordability is medium), Status 3 (property's potential to lose its use restrictions is low), Unknown (the property's status is unknown), Transfer Pending (transfer or sale of the property is currently pending), Preserved (property's affordability has been preserved), Opting Out (property's owners are opting out of their affordability contracts).
Subsidy Program Type	The primary type of subsidy used to ensure affordability for the property, for example: HUD Insured, Low Income Housing Tax Credits (LIHTC), Rural Development, Section 8 Uninsured.
Subsidy Type Notes	Explanatory notes for the primary type of subsidy used to ensure affordability for the property.
^ Top T
Targeted Population	If the property targets a specific population, this field specifies the population.
Targets Disabled	Indicates whether the property specifically targets the disabled population.
Targets Elderly	Indicates whether the property specifically targets the elderly population.
Targets Families	Indicates whether the property specifically targets families.
Targets Homeless	Indicates whether the property specifically targets the homeless population.
Targets Other	Indicates whether the property targets a specific population, other.
Targets Specific Populations	Indicates whether the property targets specific populations.
Total Number of Assisted Units	The total number of units receiving assistance under this contract.
Total Number of Units	The total number of units in the property.
Type of Construction	Indicates the type of construction of the property. 1=new construction; 2=Acquisition and Rehab; 3=Both new construction and A/R; 4=existing
Type of Credit Percent	1=30 percent present value; 2=70 percent present value; 3=Both. An indicator for Low Income Housing Tax Credit properties that indicates the type of credit the property receives.
^ Top W
Weatherization Assistance Program Eligible	Indicates a U.S. Department of Energy Weatherization Assistance Program eligible project.
^ Top X
X GPS Coordinates	Coordinates used by the Global Positioning System (GPS) to designate a specific place on earth through the use of orbiting satellites and computer technology.
^ Top Y
Y GPS Coordinates	Coordinates used by the Global Positioning System (GPS) to designate a specific place on earth through the use of orbiting satellites and computer technology.
Year 15 provision, LIHTC Properties	Any provisions that govern ownership, affordability and other uses of a property after the fifteen year use agreement expires.
Year Built	The year the property was built.
Year Placed in Service	The year the property was placed in service.
^ Top Z
Z GPS Coordinates	Coordinates used by the Global Positioning System (GPS) to designate a specific place on earth through the use of orbiting satellites and computer technology.