eGIS API and Metadata Documentation

eGIS API

Introduction

The eGIS API and Metadata Documentation page is covers some of the technical details about the eGIS data provided on this site, including the data dictionaries for each service as well as documentation on how the application programming interface (API) works. The data dictionaries provide each field’s coded name, the alias, and a brief description of the field.

The eGIS API documentation explains how to programmatically access all of our geospatial data services in a variety of open formats, which is great for building applications like the CPD Maps or keeping up to date with our data releases. These services support your basic queries as well as geospatial ones like envelope intersections and offsets.

If you have any questions or comments regarding the data, please let us know at GISHelpDesk@hud.gov.

We have a GeoService (ArcGIS REST API) available.

The Base URL:

All datasets are currently hosted on HUD's Open Data portal which provides the GeoService API. All layers may be accessed at the following location:

http://services.arcgis.com/<the layer's UID>/arcgis/rest/services/<FeatureServiceName>/FeatureServer/0/

You can find this address by navigating to the layer descritpion page at https://egis-hud.opendata.arcgis.com, selecting 'Download Dataset' and copying the GeoService address from the API dropdown menu.

The GeoService API link will provide the REST query service which also provides links to the service's metadata. To query the layer, you can either construct a query string manually or use the online form provided.

To use the GeoService, navigate to the layer in question and pull the base url from the opendata page

http://services.arcgis.com/VTyQ9soqVukalItT/ArcGIS/rest/services/FairMarketRents/FeatureServer/0/query?where=1=1&outFields=*&outSR=4326&objectids=1&f=geojson

Back to top

Example Queries

A good place to begin is in collecting all the HUD subsidized Multi-Family properties.

Subsidized Multifamily Properties

The corresponding field allows you to query for all HUD subsidized MF properties:

is_subsidized_ind='Y'

To construct the query, we'll take the base URL, and replace the where statement "1=1" with any valid SQL where statement. So for this example, we'd construct this query:

http://services.arcgis.com/VTyQ9soqVukalItT/ArcGIS/rest/services/MultiFamilyProperties/FeatureServer/0/query?where=IS_SUBSIDIZED_IND='Y'&outFields=*&outSR=4326&objectids=1&f=geojson

Project-based Section 8 Properties

A logical second step would be to query the Multi-Family Properties layer for low income, and the corresponding field for project-based Section 8 properties is:

is_sec8_ind='Y'

so the query http string that returns the data in geojson looks like this:

http://services.arcgis.com/VTyQ9soqVukalItT/arcgis/rest/services/MultiFamilyProperties/FeatureServer/0//query?where=is_sec8_ind='Y'&f=pgeojson

Since we're focusing on Seattle, here's how we would set our input geometry:

{"xmin":-13676570.60682338,"ymin":6018679.182711435,"xmax":-13559316.205433873,"ymax":6064541.399682558,"spatialReference":{"wkid":102100}}

We then include this directly in our query using the geometry parameter:

http://services.arcgis.com/VTyQ9soqVukalItT/arcgis/rest/services/MultiFamilyProperties/FeatureServer/0/query?where=is_sec8_ind%3D%27Y%27&geometry={"xmin":-13676570.60682338,"ymin":6018679.182711435,"xmax":-13559316.205433873,"ymax":6064541.399682558,"spatialReference":{"wkid":102100}}&f=pgeojson

Multifamily Elderly and Disabled Properties

For this query, we'll need to combine a few different criteria. These include:

(1) is_sec8_202='Y'
(2) IS_811_CAPITAL_ADVANCE_IND='Y'
(3) IS_PAC_811_IND='Y'
(4) IS_PRAC_811_IND='Y'

To combine critera, we can use logic statments in the URL call. To include this, add the criteria to the where statement with AND/OR between each criteria, as shown in the example below:

http://services.arcgis.com/VTyQ9soqVukalItT/arcgis/rest/services/MultiFamilyProperties/FeatureServer/0/query?where=IS_811_CAPITAL_ADVANCE_IND='Y'+OR+IS_PAC_811_IND='Y'+OR+IS_PRAC_811_IND='Y'&f=pgeojson

Lastly, lets trim the results down to return Seattle results only.

http://services.arcgis.com/VTyQ9soqVukalItT/arcgis/rest/services/MultiFamilyProperties/FeatureServer/0/query?where=HUB_NAME_TEXT='Seattle'+AND+(IS_811_CAPITAL_ADVANCE_IND='Y'+OR+IS_PAC_811_IND='Y'+OR+IS_PRAC_811_IND='Y')&f=pgeojson

Back to top

Query Parameters

Parameter Description
Where A where clause for the query filter. Any legal SQL where clause operating on the fields in the layer is allowed.
Object IDs The object IDs of this layer/table to be queried.
Time The time instant or the time extent to query.
Time instant
Syntax:  time=timeInstant
Example:  time=1199145600000
Time extent
Syntax:  time=startTime, endTime
Example:  time=1199145600000, 1230768000000
Input Geometry The geometry to apply as the spatial filter. The structure of the geometry is the same as the structure of the json geometry objects returned by the ArcGIS REST API. In addition to the json structures, for envelopes and points, you can specify the geometry with a simpler comma-separated syntax.
Syntax:
  • json structures:  geometryType=<geometryType>&geometry={geometry}
  • Envelope simple syntax: geometryType=
    esriGeometryEnvelope&geometry=<xmin>,
    <ymin>,<xmax>,<ymax>}
  • Point simple syntax:  geometryType=esriGeometryPoint&geometry=<x>,<y>
Examples:
  • geometryType=<geometryType>&geometry={xmin: -104, ymin: 35.6, xmax: -94.32, ymax: 41}
  • geometryType=esriGeometryPoint&geometry=-104,35.6
Geometry Type The type of geometry specified by the geometry parameter. The geometry type can be an envelope, point, line, or polygon. The default geometry type is an envelope.
Values: esriGeometryPoint | esriGeometryMultipoint | esriGeometryPolyline | esriGeometryPolygon | esriGeometryEnvelope
Input Spatial Reference The spatial relationship to be applied on the input geometry while performing the query. The supported spatial relationships include intersects, contains, envelope intersects, within, etc. The default spatial relationship is intersects (esriSpatialRelIntersects). Options are:  intersects, contains, crosses, envelope intersects, index intersects, overlaps, touches, and within.
Distance Distance to buffer input geometry.
Units Return distance values in the specified units. Options are meters, miles, feet, kilometers, nautical miles, and US nautical miles.
Out Fields Attribute fields to include in response. Default is all (*).
Return Geometry Boolean parameter. If 'true', each feature in the FeatureSet includes the geometry.
Max Allowable Offset The maximum allowable offset used for generalizing geometries returned by the query operation.
Geometry Precision Specify the number of decimal places for the geometries returned by the query operation.
Output Spatial Reference The spatial reference for the returned geometry.
Return IDs Only If true, the response only includes an array of object IDs. Otherwise the response is a feature set. The default is false.
Return Count Only If true, the response only includes the count (number of features/records) that would be returned by a query. Otherwise the response is a feature set. The default is false. This option supersedes the returnIdsOnly parameter.
Return Extent Only Boolean parameter set to return the query features extent only.
Order By Fields One or more field names using the features/records that need to be ordered. Use ASC or DESC for ascending or desending order respectively.
Group By Fields Group by fields (for statistics).
Output Statistics The definitions for one or more field-based statistics to be calculated.
Result Offset This option can be used for fetching query results by skipping the specified number of records and starts from the next record (i.e.resultOffset + 1th). The Default is 0.
Result Record Count This option can be used for fetching query results up to the resultRecordCount specified. When resultOffset is specified but this parameter is not, map service defaults it to maxRecordCount. The maximum value for this parameter is the value of the layer's maxRecordCount property.
ReturnZ If true, the Z values will be included in the results if the features have Z values. Otherwise Z values are not returned. The default is false.
ReturnM If true, M values will be included in the results if the features have m values. Otherwise, M values are not returned. The default is false.
Quantization Parameters Used to project the geometry onto a virtual grid, likely representing pixels on the screen.
Format The response format. Default format is html but options include html, json, and geojson

Back to top


Metadata

Public Housing Authorities

Public Housing Authorities Metadata
Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
PARTICIPANT_CODE PHA code of the PHA administering the FSS contract.
FORMAL_PARTICIPANT_NAME Business title of the participant used in addresses and letterhead.
HA_PHN_NUM Housing Authority Phone Number
HA_FAX_NUM Housing Authority Fax Number
HA_EMAIL_ADDR_TEXT Housing Authority Email Address
EXEC_DIR_PHONE Phone Number of Executive Director
EXEC_DIR_FAX Fax Number of Executive Director
EXEC_DIR_EMAIL Email of Executive Director
PHAS_DESIGNATION The overall performance of PHA derived from the phas_designation_type_code field: Advisory, High Performer, Standard Performer, Substandard Financial, Substandard Physical and Troubled Performer
HA_LOW_RENT_SIZE_CATEGORY Extra Large (10,000+), Large (1,250 - 9,999), Medium High (500 - 1,249), Medium Low (250 - 499), Small (50 - 249), Very Small (1 - 49) and No units
HA_SECTION_8_SIZE_CATEGORY Extra Large (10,000+), Large (1,250 - 9,999), Medium High (500 - 1,249), Medium Low (250 - 499), Small (50 - 249), Very Small (1 - 49) and No units
HA_COMBINED_SIZE_CATEGORY Extra Large (10,000+), Large (1,250 - 9,999), Medium High (500 - 1,249), Medium Low (250 - 499), Small (50 - 249), Very Small (1 - 49) and No units
HA_FYE ha_fy_end_month
HA_PROGRAM_TYPE A code that uniquely identifies the participant program type and is derived from participant_program_type. Combined, Low-Rent and Section 8.
TOTAL_UNITS total_units_count The number of total units associated with the participant.
TOTAL_DWELLING_UNITS summ_total_dwelling_unit_count The total number of all the dwelling units within the HA.
ACC_UNITS summ_acc_unit_count The total number of all the acc units within the HA.
TOTAL_OCCUPIED summ_occupied_unit_count The total number of all the occupied units within the HA.
REGULAR_VACANT summ_vacant_unit_count The total number of all the vacant units within the HA.
SECTION8_UNITS_CNT total_section_8_unit_count Total Section 8 units for an HA.
PHA_TOTAL_UNITS Number of units under contract for federal subsidy and available for occupancy
STATE2KX Census 2010 FIPS State Code
CNTY_NM2KX Census 2010 County Name
CNTY2KX Census 2010 FIPS County Code
TRACT2KX Census 2010 Tract
BG2KX Census 2010 Block Group
BLOCK2KX Census 2010 Block ID
DPVACT DPV Vacancy Flag
DPVNOST DPV "No Stat" Flag
CURCNTY_NM Current FIPS County Name
CURCNTY Current FIPS County Code
CURCOSUB Current County Subdivision Code (MCD/CC
CURCOSUB_NM Current County Subdivision Name (MCD/CC
PLACE2KX FIPS Place Code
PLACE_NM2KX FIPS Place name
PLACE_CC2KX FIPS Place Class Code
PLACE_INC2KX FIPS Place Incorporated Flag
MSA Metropolitan Statistical Area Code
MSA_NM MSA/PMSA Name
CBSA Core Based Statistical Area
CBSA_NM Core Based Statistical Area, Lowest Level N
NECTA New England City and Town Area, Lowest Le
NECTA_NM NECTA Lowest Level Name
METRO CBSA Metropolitan Area Indicator
MICRO CBSA Micropolitan Area Indicator
FCD_FIPS91 Federal Congressional District (FIPS 9.1 std.)
HLC HUD Locality Code
DPV DPV Return Code
DPVRC Delivery Point Validation(DPV) Indicator
STD_ADDR USPS Standardized Address
URB_OUT Puerto Rico Urbanization Name
STD_CITY USPS Standardized City Name
STD_ST USPS Standardized State Abbreviation
STD_ZIP5 USPS Standardized ZIP Code
STD_ZIP9 USPS Standardized ZIP+4 Code
ZIP_CLASS Type of Zip Code
ZCTA2KX Census 2010 Zip Code Tabulation Area
DPBC Delivery Point Bar Code
DPBC_CKSUM Delivery Point Bar Code, Check Digit
STD_ZIP11 Postnet Bar Code
ADDR_TYPE USPS Address Type "" - no match, "S" - House/Street match, "H" - Highrise, "P" - PO Box, "G" - General Delivery, "R" - Rural Route/Highway Contract
APT_NO Apartment Number
APT_TYPE Apartment Type; Contains the secondary address type abbreviation (Apt = Apartment, Ste = Suite, # = Apartment, RM = Room, FL = Floor, etc..)
C1PGRC General Return Code
C1PPRB Address Match Probability
C1PDRC Directional Return Code
C1PSRC Suffix Return Code
C1PARC Apartment Return Code
C1PZRC ZIP Return Code
MSGUSPS Postal Matcher Status Message
LAT Latitude (decimal)
LON Longitude (decimal)
RC2KX Census 2010 Geocoder General Return Code
STM2KX Census 2010 Geocoder Street Matcher Return Code
LVL2KX Census 2010 Geocoder Lat/Long Geocoding Return Code
UR Urban/Rural Indicator
MSG2KX Census 2010 Geocoder Lat/Long Level Status
COUNTY_LEVEL 5 character combination of state and county FIPS codes
PLACE_LEVEL 7 characters. For CDBG Entitlement Cities, this is the CDBG ID. For Urban Counties and State Nonentitlement Areas, is a concatenation of state and place FIPS codes
TRACT_LEVEL 11 character combination of state, county, and Census Tract codes
BLKGRP_LEVEL 12 character combination of State, county, tract, and block group
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map

Back to top

Public Housing Buildings

Public Housing Buildings Metadata
Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
PARTICIPANT_CODE PHA code of the PHA administering the FSS contract.
FORMAL_PARTICIPANT_NAME Business title of the participant used in addresses and letterhead.
DEVELOPMENT_CODE A code that uniquely identifies a project or a development.
PROJECT_NAME The name of the physical development.
TOTAL_UNITS total_units_count The number of total units associated with the participant.
TOTAL_DWELLING_UNITS summ_total_dwelling_unit_count The count of the entire dwelling building structures within the Physical Development.
ACC_UNITS summ_acc_unit_count The total number of all the acc units within the HA.
TOTAL_OCCUPIED summ_occupied_unit_count The total number of all the occupied units within the Building Entrance.
REGULAR_VACANT summ_vacant_unit_count The total number of all the vacant units within the Building Entrance.
PHA_TOTAL_UNITS Number of units under contract for federal subsidy and available for occupancy
PCT_OCCUPIED Occupied units as the % of units available.
NUMBER_REPORTED Number of households for which reports were received (These are households reported as of 12/2000 with effective dates spanning the prior 18 months.)
PCT_REPORTED Households for which reports were received, as % of occupied units. (These are households reported as of 12/2000 with effective dates spanning the prior 18 months.)
MONTHS_SINCE_REPORT Average number of months since manager reported on household. (Calculations exclude zero values and missing values.)
PCT_MOVEIN % in program less than a year (the difference between the effective date and the date of admission: type of action = 1).
PEOPLE_PER_UNIT Average size of household (with decimal point and place, e.g., 2.5). (Excludes zerovalues and missing values.)
PEOPLE_TOTAL Total number of people (shown in thousands).
RENT_PER_MONTH Average gross household contribution towards rent per month (includes payment toward rent and utilities). (Excludes zero values and missing values.)
SPENDING_PER_MONTH Average federal spending per unit per month (not fully comparable across programs). For public housing, sum of the operating subsidy and capital improvement cost is divided by the total number of occupied units (such spending data is available at the PHA level only). For tenant-based Section 8, Section 8 Moderate Rehabilitation, and Multifamily Assisted, the housing assistance payment (HAP) is divided by the total number of reported households. An amount is added for administrative cost in Section 8 tenant based and Section 8 Moderate Rehabilitation. (Excludes zero values and missing values.)
HH_INCOME Average total household income per year (shown in thousands of dollars per year with decimal point). (Numerator includes zero income but excludes missing income; denominator includes all households.)
PERSON_INCOME Average household income per person per year (shown in thousands of dollars per year with decimal point). (Numerator includes zero income but excludes missing income; denominator includes all members of households.)
PCT_LT5K % below $5,000 per year.
PCT_5K_LT10K % between $5,000-$9,999 per year.
PCT_10K_LT15K % between $10,000-$14,999 per year.
PCT_15K_LT20K % between $15,000-$19,999 per year.
PCT_GE20K % $20,000 or more per year.
PCT_WAGE_MAJOR % of households where the majority of household income is derived from wages and/or business
PCT_WELFARE_MAJOR % of households where the majority of household income is derived from welfare (TANF, General Assistance, or Public Assistance).
PCT_OTHER_MAJOR % of households where the majority of household income is derived from a source other than wage and welfare.
PCT_MEDIAN Household income as a percent of local area median family income, as defined by HUD, and adjusted for household size. (Numerator includes zero income but excludes missing income; denominator includes all households.)
PCT_LT50_MEDIAN % of households with income below 50% of local area median family income, as defined by HUD, adjusted for household size (refer to the downloadable file only, not in published report). (Numerator includes zero income but excludes missing income; denominator includes all households.)
PCT_LT30_MEDIAN % of households with income below 30% of local area median family income, as defined by HUD, adjusted for household size. (Numerator includes zero income but excludes missing income; denominator includes all households.)
PCT_2ADULTS % with two spouses and 1 or more children under 18 years.
PCT_1ADULT % where spouse not present and 1 or more children under 18 years.
PCT_FEMALE_HEAD % of households headed by a female.
PCT_FEMALE_HEAD_CHILD % of households headed by a female with children.
PCT_DISABLED_LT62 % of households below age 62 where either household head or spouse (or cohead)has a disability.
PCT_DISABLED_GE62 % of households age 62 or older where either household head or spouse (or cohead) has a disability.
PCT_DISABLED_ALL % of all persons in household with a disability.
PCT_LT24_HEAD % 24 or less years: household head or spouse (whoever is older).
PCT_AGE25_50 % 25 to 50 years: household head or spouse (whoever is older).
PCT_AGE51_61 % 51 to 61 years: household head or spouse (whoever is older).
PCT_AGE62PLUS % age 62 and older.
PCT_AGE85PLUS % age 85 and older.
PCT_MINORITY % Minority.
PCT_BLACK % Black, non-Hispanic.
PCT_NATIVE_AMERICAN % Native American, non-Hispanic.
PCT_ASIAN % Asian or Pacific Islander, non-Hispanic.
PCT_HISPANIC % Hispanic (of any race).
MONTHS_WAITING Average months on waiting list among admissions. Excludes programs that do not report waiting list dates. (Excludes zero values and missing values.)
MONTHS_FROM_MOVEIN Average months since moved in. (Excludes zero values and missing values.)
PCT_UTILITY_ALLOW % with valid utility allowance ($1 to $1000). This is an estimate of the utilities that the household pays to the utility company. It is zero if all utilities are included in the rent.
AVE_UTIL_ALLOW Average utility allowance among households who have it (in $ per month). (Excludes zero values and missing values.)
PCT_BED1 % of households with 0- or 1-bedroom units (efficiencies and one-bedrooms).
PCT_BED2 % of households with 2-bedroom units.
PCT_BED3 % of households with 3- or more bedroom units.
PCT_OVERHOUSED % overhoused (households with more bedrooms than people).
TMINORITY Minorities as % of total population in the census tract where HUD assisted families reside (Census 2010 tracts; ACS 2008-2012 data)
TPOVERTY Percent of the population below poverty level, in census tract where HUD assisted households reside (Census 2010 tracts; ACS 2008-2012 data)
TPCT_OWNSFD % of households who are owner-occupants of single-family detached homes in the census tract that surrounds the project (Census 2010 tracts; ACS 2008-2012 data)
STATE2KX Census 2010 FIPS State Code
CNTY_NM2KX Census 2010 County Name
CNTY2KX Census 2010 FIPS County Code
TRACT2KX Census 2010 Tract
BG2KX Census 2010 Block Group
BLOCK2KX Census 2010 Block ID
DPVACT DPV Vacancy Flag
DPVNOST DPV "No Stat" Flag
CURCNTY_NM Current FIPS County Name
CURCNTY Current FIPS County Code
CURCOSUB Current County Subdivision Code (MCD/CC
CURCOSUB_NM Current County Subdivision Name (MCD/CC
PLACE2KX FIPS Place Code
PLACE_NM2KX FIPS Place name
PLACE_CC2KX FIPS Place Class Code
PLACE_INC2KX FIPS Place Incorporated Flag
MSA Metropolitan Statistical Area Code
MSA_NM MSA/PMSA Name
CBSA Core Based Statistical Area
CBSA_NM Core Based Statistical Area, Lowest Level N
NECTA New England City and Town Area, Lowest Le
NECTA_NM NECTA Lowest Level Name
METRO CBSA Metropolitan Area Indicator
MICRO CBSA Micropolitan Area Indicator
FCD_FIPS91 Federal Congressional District (FIPS 9.1 std.)
HLC HUD Locality Code
DPV DPV Return Code
DPVRC Delivery Point Validation(DPV) Indicator
STD_ADDR USPS Standardized Address
URB_OUT Puerto Rico Urbanization Name
STD_CITY USPS Standardized City Name
STD_ST USPS Standardized State Abbreviation
STD_ZIP5 USPS Standardized ZIP Code
STD_ZIP9 USPS Standardized ZIP+4 Code
ZIP_CLASS Type of Zip Code
ZCTA2KX Census 2010 Zip Code Tabulation Area
DPBC Delivery Point Bar Code
DPBC_CKSUM Delivery Point Bar Code, Check Digit
STD_ZIP11 Postnet Bar Code
ADDR_TYPE USPS Address Type "" - no match, "S" - House/Street match, "H" - Highrise, "P" - PO Box, "G" - General Delivery, "R" - Rural Route/Highway Contract
APT_NO Apartment Number
APT_TYPE Apartment Type; Contains the secondary address type abbreviation (Apt = Apartment, Ste = Suite, # = Apartment, RM = Room, FL = Floor, etc..)
C1PGRC General Return Code
C1PPRB Address Match Probability
C1PDRC Directional Return Code
C1PSRC Suffix Return Code
C1PARC Apartment Return Code
C1PZRC ZIP Return Code
MSGUSPS Postal Matcher Status Message
LAT Latitude (decimal)
LON Longitude (decimal)
RC2KX Census 2010 Geocoder General Return Code
STM2KX Census 2010 Geocoder Street Matcher Return Code
LVL2KX Census 2010 Geocoder Lat/Long Geocoding Return Code
UR Urban/Rural Indicator
MSG2KX Census 2010 Geocoder Lat/Long Level Status
COUNTY_LEVEL 5 character combination of state and county FIPS codes
PLACE_LEVEL 7 characters. For CDBG Entitlement Cities, this is the CDBG ID. For Urban Counties and State Nonentitlement Areas, is a concatenation of state and place FIPS codes
TRACT_LEVEL 11 character combination of state, county, and Census Tract codes
BLKGRP_LEVEL 12 character combination of State, county, tract, and block group
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
BUILDING_NAME The name of the building.
BUILDING_NUMBER A number, which uniquely identifies the building.
BUILDING_TYPE_CODE A code uniquely identifying the type of building structure and includes ES (Elevator Structure), NDS (Non Dwelling Structure), RW, SD, SF, WU and MX (Mixed Type).
BUILDING_STATUS_TYPE_CODE A code, which uniquely identifies the status of a building entrance. The different building_status_type_codes include DDAPRD (DemoDispo -Approved), DDDRFT (DemoDispo – TBD)
NATIONAL_BUILDING_ID A unique ID assigned to each building.
DEV_BUIL_NU_ENTRANCE Development Building Number Entrance
CONSTRUCT_DATE Construction Date
DOFA_ACTUAL_DT Date of Full Availability Actual Date

Back to top

Public Housing Developments

Public Housing Developments Metadata
Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
PARTICIPANT_CODE PHA code of the PHA administering the FSS contract.
FORMAL_PARTICIPANT_NAME Business title of the participant used in addresses and letterhead.
DEVELOPMENT_CODE A code that uniquely identifies a project or a development.
PROJECT_NAME The name of the physical development.
SCATTERED_SITE_IND An indicator, which determines whether or not a physical development is made up of scattered buildings/units.
PD_STATUS_TYPE_CODE Defines the status of the physical development. D (Development), M (Management) and T(Terminated).
TOTAL_UNITS total_units_count The number of total units associated with the participant.
TOTAL_DWELLING_UNITS summ_total_dwelling_unit_count The count of the entire dwelling building structures within the Physical Development.
ACC_UNITS summ_acc_unit_count The total number of all the acc units within the HA.
TOTAL_OCCUPIED summ_occupied_unit_count The total number of all the occupied units within the Building Entrance.
REGULAR_VACANT summ_vacant_unit_count The total number of all the vacant units within the Building Entrance.
PHA_TOTAL_UNITS Number of units under contract for federal subsidy and available for occupancy
PCT_OCCUPIED Occupied units as the % of units available.
NUMBER_REPORTED Number of households for which reports were received (These are households reported as of 12/2000 with effective dates spanning the prior 18 months.)
PCT_REPORTED Households for which reports were received, as % of occupied units. (These are households reported as of 12/2000 with effective dates spanning the prior 18 months.)
MONTHS_SINCE_REPORT Average number of months since manager reported on household. (Calculations exclude zero values and missing values.)
PCT_MOVEIN % in program less than a year (the difference between the effective date and the date of admission: type of action = 1).
PEOPLE_PER_UNIT Average size of household (with decimal point and place, e.g., 2.5). (Excludes zerovalues and missing values.)
PEOPLE_TOTAL Total number of people (shown in thousands).
RENT_PER_MONTH Average gross household contribution towards rent per month (includes payment toward rent and utilities). (Excludes zero values and missing values.)
SPENDING_PER_MONTH Average federal spending per unit per month (not fully comparable across programs). For public housing, sum of the operating subsidy and capital improvement cost is divided by the total number of occupied units (such spending data is available at the PHA level only). For tenant-based Section 8, Section 8 Moderate Rehabilitation, and Multifamily Assisted, the housing assistance payment (HAP) is divided by the total number of reported households. An amount is added for administrative cost in Section 8 tenant based and Section 8 Moderate Rehabilitation. (Excludes zero values and missing values.)
HH_INCOME Average total household income per year (shown in thousands of dollars per year with decimal point). (Numerator includes zero income but excludes missing income; denominator includes all households.)
PERSON_INCOME Average household income per person per year (shown in thousands of dollars per year with decimal point). (Numerator includes zero income but excludes missing income; denominator includes all members of households.)
PCT_LT5K % below $5,000 per year.
PCT_5K_LT10K % between $5,000-$9,999 per year.
PCT_10K_LT15K % between $10,000-$14,999 per year.
PCT_15K_LT20K % between $15,000-$19,999 per year.
PCT_GE20K % $20,000 or more per year.
PCT_WAGE_MAJOR % of households where the majority of household income is derived from wages and/or business
PCT_WELFARE_MAJOR % of households where the majority of household income is derived from welfare (TANF, General Assistance, or Public Assistance).
PCT_OTHER_MAJOR % of households where the majority of household income is derived from a source other than wage and welfare.
PCT_MEDIAN Household income as a percent of local area median family income, as defined by HUD, and adjusted for household size. (Numerator includes zero income but excludes missing income; denominator includes all households.)
PCT_LT50_MEDIAN % of households with income below 50% of local area median family income, as defined by HUD, adjusted for household size (refer to the downloadable file only, not in published report). (Numerator includes zero income but excludes missing income; denominator includes all households.)
PCT_LT30_MEDIAN % of households with income below 30% of local area median family income, as defined by HUD, adjusted for household size. (Numerator includes zero income but excludes missing income; denominator includes all households.)
PCT_2ADULTS % with two spouses and 1 or more children under 18 years.
PCT_1ADULT % where spouse not present and 1 or more children under 18 years.
PCT_FEMALE_HEAD % of households headed by a female.
PCT_FEMALE_HEAD_CHILD % of households headed by a female with children.
PCT_DISABLED_LT62 % of households below age 62 where either household head or spouse (or cohead)has a disability.
PCT_DISABLED_GE62 % of households age 62 or older where either household head or spouse (or cohead) has a disability.
PCT_DISABLED_ALL % of all persons in household with a disability.
PCT_LT24_HEAD % 24 or less years: household head or spouse (whoever is older).
PCT_AGE25_50 % 25 to 50 years: household head or spouse (whoever is older).
PCT_AGE51_61 % 51 to 61 years: household head or spouse (whoever is older).
PCT_AGE62PLUS % age 62 and older.
PCT_AGE85PLUS % age 85 and older.
PCT_MINORITY % Minority.
PCT_BLACK % Black, non-Hispanic.
PCT_NATIVE_AMERICAN % Native American, non-Hispanic.
PCT_ASIAN % Asian or Pacific Islander, non-Hispanic.
PCT_HISPANIC % Hispanic (of any race).
MONTHS_WAITING Average months on waiting list among admissions. Excludes programs that do not report waiting list dates. (Excludes zero values and missing values.)
MONTHS_FROM_MOVEIN Average months since moved in. (Excludes zero values and missing values.)
PCT_UTILITY_ALLOW % with valid utility allowance ($1 to $1000). This is an estimate of the utilities that the household pays to the utility company. It is zero if all utilities are included in the rent.
AVE_UTIL_ALLOW Average utility allowance among households who have it (in $ per month). (Excludes zero values and missing values.)
PCT_BED1 % of households with 0- or 1-bedroom units (efficiencies and one-bedrooms).
PCT_BED2 % of households with 2-bedroom units.
PCT_BED3 % of households with 3- or more bedroom units.
PCT_OVERHOUSED % overhoused (households with more bedrooms than people).
TMINORITY Minorities as % of total population in the census tract where HUD assisted families reside (Census 2010 tracts; ACS 2008-2012 data)
TPOVERTY Percent of the population below poverty level, in census tract where HUD assisted households reside (Census 2010 tracts; ACS 2008-2012 data)
TPCT_OWNSFD % of households who are owner-occupants of single-family detached homes in the census tract that surrounds the project (Census 2010 tracts; ACS 2008-2012 data)
STATE2KX Census 2010 FIPS State Code
CNTY_NM2KX Census 2010 County Name
CNTY2KX Census 2010 FIPS County Code
TRACT2KX Census 2010 Tract
BG2KX Census 2010 Block Group
BLOCK2KX Census 2010 Block ID
DPVACT DPV Vacancy Flag
DPVNOST DPV "No Stat" Flag
CURCNTY_NM Current FIPS County Name
CURCNTY Current FIPS County Code
CURCOSUB Current County Subdivision Code (MCD/CC
CURCOSUB_NM Current County Subdivision Name (MCD/CC
PLACE2KX FIPS Place Code
PLACE_NM2KX FIPS Place name
PLACE_CC2KX FIPS Place Class Code
PLACE_INC2KX FIPS Place Incorporated Flag
MSA Metropolitan Statistical Area Code
MSA_NM MSA/PMSA Name
CBSA Core Based Statistical Area
CBSA_NM Core Based Statistical Area, Lowest Level N
NECTA New England City and Town Area, Lowest Le
NECTA_NM NECTA Lowest Level Name
METRO CBSA Metropolitan Area Indicator
MICRO CBSA Micropolitan Area Indicator
FCD_FIPS91 Federal Congressional District (FIPS 9.1 std.)
HLC HUD Locality Code
DPV DPV Return Code
DPVRC Delivery Point Validation(DPV) Indicator
STD_ADDR USPS Standardized Address
URB_OUT Puerto Rico Urbanization Name
STD_CITY USPS Standardized City Name
STD_ST USPS Standardized State Abbreviation
STD_ZIP5 USPS Standardized ZIP Code
STD_ZIP9 USPS Standardized ZIP+4 Code
ZIP_CLASS Type of Zip Code
ZCTA2KX Census 2010 Zip Code Tabulation Area
DPBC Delivery Point Bar Code
DPBC_CKSUM Delivery Point Bar Code, Check Digit
STD_ZIP11 Postnet Bar Code
ADDR_TYPE USPS Address Type "" - no match, "S" - House/Street match, "H" - Highrise, "P" - PO Box, "G" - General Delivery, "R" - Rural Route/Highway Contract
APT_NO Apartment Number
APT_TYPE Apartment Type; Contains the secondary address type abbreviation (Apt = Apartment, Ste = Suite, # = Apartment, RM = Room, FL = Floor, etc..)
C1PGRC General Return Code
C1PPRB Address Match Probability
C1PDRC Directional Return Code
C1PSRC Suffix Return Code
C1PARC Apartment Return Code
C1PZRC ZIP Return Code
MSGUSPS Postal Matcher Status Message
LAT Latitude (decimal)
LON Longitude (decimal)
RC2KX Census 2010 Geocoder General Return Code
STM2KX Census 2010 Geocoder Street Matcher Return Code
LVL2KX Census 2010 Geocoder Lat/Long Geocoding Return Code
UR Urban/Rural Indicator
MSG2KX Census 2010 Geocoder Lat/Long Level Status
COUNTY_LEVEL 5 character combination of state and county FIPS codes
PLACE_LEVEL 7 characters. For CDBG Entitlement Cities, this is the CDBG ID. For Urban Counties and State Nonentitlement Areas, is a concatenation of state and place FIPS codes
TRACT_LEVEL 11 character combination of state, county, and Census Tract codes
BLKGRP_LEVEL 12 character combination of State, county, tract, and block group
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map

Back to top

Low Income Housing Tax Credits

Low Income Housing Tax Credits Metadata
Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
HUD_ID Unique Project Identifier for the Database characters 1-3: Allocating agency code (see table below)
digits 4-7: Year placed in service (0000 or 0001 if unknown or missing)
digits 8-10: Record number within allocating agency and year placed in service
PROJECT Project name
PROJ_ADD Project street address
PROJ_CTY Project city
PROJ_ST Project state
PROJ_ZIP Project zip
STATE_ID State-defined Project ID
CONTACT Owner or owner's contact
COMPANY Name of contact company
CO_ADD Contact's business address
CO_CTY Contact's city
CO_ST Contact's state
CO_ZIP Contact's zip
CO_TEL Contact's telephone
ALLOCAMT Annual dollar amount of tax credits allocated
N_UNITS Total number of units
LI_UNITS Total number of low income units
N_0BR Number of efficiencies
N_1BR Number of 1 bedroom units
N_2BR Number of 2 bedroom units
N_3BR Number of 3 bedroom units
N_4BR Number of 4 bedroom units
INC_CEIL Elected rent/income ceiling for low income units
LOW_CEIL Units set aside with rents lower than elected rent/income ceiling
CEILUNIT Number of units set aside with rents lower than elected rent/income ceiling
YR_PIS Year placed in service
YR_ALLOC Allocation year
NON_PROF Non-profit sponsor
BASIS Increase in eligible basis
BOND Tax-exempt bond received
FMHA_514 FmHA (RHS) Section 514 loan
FMHA_515 FmHA (RHS) Section 515 loan
FMHA_538 FmHA (RHS) Section 538 loan
HOME HOME Investment Partnership Program funds
HOME_AMT HOME Investment Partnership Program funds
CDBG Community Development Block Grant funds
CDBG_AMT Dollar amount of CDBG funds
FHA FHA-insured loan
HOPEVI Forms part of a HOPEVI development
HPVI_AMT Dollar amount of HOPEVI funds for development or building costs
TRGT_POP Targets a specific population with specialized services or facilities
TRGT_FAM Targets a specific population – families
TRGT_ELD Targets a specific population – elderly
TRGT_DIS Targets a specific population – disabled
TRGT_HML Targets a specific population – homeless
TRGT_SPC Targets a specific population – other as specified
CREDIT Type of credit percentage
N_UNITSR Total number of units or if total units missing or inconsistent, total low income units
LI_UNITR Total number of low income units or if total low income units missing, total units
DDA Is the census tract in a difficult development area?(DDA status is based on placed in service year.)
QCT Is the census tract a qualified census tract? (For projects placed in service prior to 2003, QCT is based on 1990 Census tract. For projects placed in service since 2003, QCT is based on 2000 Census tract.)
NONPROG No longer monitored for LIHTC program due to expired use or other reason (Status of no longer being monitored for the LIHTC Program is indicated for projects as specified by the allocating agency. This does not indicate whether or not a project remains affordable to low income populations.)
DATANOTE Notes about data record changes processed for database update.
YRMISFLG An indicator  equal to 1 if the allocation year is missing and equal to 2 if the placed in service year is missing
STATE2KX Census 2010 FIPS State Code
CNTY_NM2KX Census 2010 County Name
CNTY2KX Census 2010 FIPS County Code
TRACT2KX Census 2010 Tract
BG2KX Census 2010 Block Group
BLOCK2KX Census 2010 Block ID
CURCNTY_NM Current FIPS County Name
CURCNTY Current FIPS County Code
CURCOSUB Current County Subdivision Code (MCD/CC
CURCOSUB_NM Current County Subdivision Name (MCD/CC
PLACE2KX FIPS Place Code
PLACE_NM2KX FIPS Place name
PLACE_CC2KX FIPS Place Class Code
PLACE_INC2KX FIPS Place Incorporated Flag
MSA Metropolitan Statistical Area Code
MSA_NM MSA/PMSA Name
CBSA Core Based Statistical Area
CBSA_NM Core Based Statistical Area, Lowest Level N
NECTA New England City and Town Area, Lowest Le
NECTA_NM NECTA Lowest Level Name
METRO CBSA Metropolitan Area Indicator
MICRO CBSA Micropolitan Area Indicator
FCD_FIPS91 Federal Congressional District (FIPS 9.1 std.)
HLC HUD Locality Code
DPVRC DPV Return Code
DPV Delivery Point Validation(DPV) Indicator
STD_ADDR USPS Standardized Address
URB_OUT Puerto Rico Urbanization Name
STD_CITY USPS Standardized City Name
STD_ST USPS Standardized State Abbreviation
STD_ZIP5 USPS Standardized ZIP Code
STD_ZIP9 USPS Standardized ZIP+4 Code
ZIP_CLASS Type of Zip Code
ZCTA2KX Census 2010 Zip Code Tabulation Area
DPBC Delivery Point Bar Code
DPBC_CKSUM Delivery Point Bar Code, Check Digit
STD_ZIP11 Postnet Bar Code
ADDR_TYPE USPS Address Type "" - no match, "S" - House/Street match, "H" - Highrise, "P" - PO Box, "G" - General Delivery, "R" - Rural Route/Highway Contract
APT_NO Apartment Number
APT_TYPE Apartment Type; Contains the secondary address type abbreviation (Apt = Apartment, Ste = Suite, # = Apartment, RM = Room, FL = Floor, etc..)
C1PGRC General Return Code
C1PPRB Address Match Probability
C1PDRC Directional Return Code
C1PSRC Suffix Return Code
C1PARC Apartment Return Code
C1PRC9 ZIP Return Code
MSGUSPS Postal Matcher Status Message
LAT Latitude (decimal)
LON Longitude (decimal)
RC2KX Census 2010 Geocoder General Return Code
STM2KX Census 2010 Geocoder Street Matcher Return Code
LVL2KX Census 2010 Geocoder Lat/Long Geocoding Return Code
UR Urban/Rural Indicator
MSG2KX Census 2010 Geocoder Lat/Long Level Status
COUNTY_LEVEL 5 character combination of state and county FIPS codes
PLACE_LEVEL 7 characters. For CDBG Entitlement Cities, this is the CDBG ID. For Urban Counties and State Nonentitlement Areas, is a concatenation of state and place FIPS codes
TRACT_LEVEL 11 character combination of state, county, and Census Tract codes
BLKGRP_LEVEL 12 character combination of State, county, tract, and block group
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
MFF_RA HUD Multi-Family financing/rental assistance
MFF_RA_ID HUD Multi-Family financing/rental assistance Property ID
HOME_IDISI HOME Investment Partnership Program funds IDIS ID
TCAP Tax Credit Assistance Program (TCAP) funds
TCAP_AMT TCAP Amount
TCAP_IDISI TCAP ISIS ID
CDBG_IDISI Community Development Block Grant (CDBG) funds IDIS ID
TCEP TCEP Funds
TCEP_AMT TCEP Amount
RENTASSIST Federal or state project-based rental assistance contract
TRGT_OTH Targets a specific population – other
TYPE Type of construction

Back to top

Multifamily Properties - Assisted

Multifamily Properties - Assisted Metadata
Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
PROPERTY_ID The identifier assigned by the HEREMS database that identifies the active property.
HUB_NAME_TEXT The name of the HUD hub responsiblefor the active property’s HUD servicing site.
SERVICING_SITE_NAME_TEXT The name of the HUD servicing site responsible for the management/servicing functions for the active property.
PROJECT_MANAGER_NAME_TEXT The name of the active property’s project manager.
PROPERTY_NAME_TEXT The recorded name of the active property.
ADDRESS_LINE1_TEXT The primary street address or the first line of the mailing address for the active property.
ADDRESS_LINE2_TEXT The primary suite number, PO box or other information for the second line of the mailing address for the active property.
AUTOMATIC_GEOCODE_IND A yes/no indicator signifying whether the Geocode information in the primary address for the active property has been automatically set or manually set by the user (N indicates the address has been set by the user).
CONGRESSIONAL_DISTRICT_CODE The congressional district code for the active property.
PLACED_BASE_CITY_NAME_TEXT The name of the standard place based
city for the active property.
TOTAL_ASSISTED_UNIT_COUNT The total number of assisted units for
the active property.
TOTAL_UNIT_COUNT The total number of units for the active property.
PROPERTY_ON_SITE_PHONE_NUMBER The phone number for the active property’s on site property manager.
PROPERTY_CATEGORY_NAME The category name for the active property in terms of the following:
202/811, Insured-Subsidized,Insured – Previously Subsidized, Insured-Unsubsidized, HUD Owned, HUD Held, Subsidized – Previously 202/811, Subsidized – Previously Insured Subsidized, No HUD Financing, Flexible Subsidy
Use Restriction, Other Subsidy Servicing Required (Only)
CLIENT_GROUP_CODE The code that identifies the primary population or need served by the active property.
CLIENT_GROUP_NAME The name that describes the primary population or need served by the active property.
CLIENT_GROUP_TYPE The broad category for the primary population or need served by the active property i.e., Disabled, Elderly, Family, or Health Care.
REAC_LAST_INSPECTION_ID The identifier assigned to the latest REAC physical inspection associated with the active property.
REAC_LAST_INSPECTION_SCORE The score of the latest REAC physical inspection associated with the active property.
FASS_LAST_PERFORMANCE_VALUE The performance value of the latest AFS submission for the latest reporting period associated with the active property.
FASS_LST_TOT_MGMT_COND_CNT The total number of management conditions in the latest AFS submission for the latest reporting period associated with the active property.
FASS_LAST_REFERRED_TO_CODE The organization to which the compliance review was referred for the latest AFS submission for the latest reporting period associated with the active property
IS_AFS_REQUIRED_IND A yes/no indicator signifying whether an AFS is required for the active property.
AFS_FISCAL_YR_END_DATE The AFS fiscal year end for the active property, in the format of month and year.
HAS_ACTIVE_FINANCING_IND A yes/no indicator signifying whether there is active financing for the active property.
PRIMARY_FINANCING_TYPE The primary type of financing for the
active property in terms of the following: Insured, 202/811, HUD Owned, HUD Held, Non-Insured, Flexible Subsidy
IS_ALL_FINANCING_PIPELINE_IND A yes/no indicator signifying whether all of the active financing for the active property is in the pipeline.
IS_ALL_CONTRACT_PIPELINE_IND A yes/no indicator signifying whether all of the active contracts for the active property are in the pipeline.
IS_UNDER_MANAGEMENT_IND A yes/no indicator signifying whether the active property is under management.
HAS_SERVICE_AGREEMENT_IND A yes/no indicator signifying whether an active Service Agreement exists for the active property.
HAS_USE_RESTRICTION_IND A yes/no indicator signifying whether an active Use Restriction exists for the active property.
HAS_ACTIVE_IRP_IND A yes/no indicator signifying whether or not an active interest reduction payment agreement is associated with the property.
IS_SERVICE_COORDINATOR_IND A yes/no indicator signifying whether there are any active service coordinator contractsor grants for the active property.
PRIMARY_FHA_NUMBER The Federal Housing Authority (FHA) number assigned to the primary loan for the active property when it has active insurance.
ASSOCIATED_FHA_NUMBER The FHA number associated with the active property.
ASSOCIATED_CONTRACT_NUMBER The contract number associated with the active property.
TROUBLED_CODE A code that identifies if the active property is considered troubled by the field office.
OPIIS_RISK_CATEGORY Per the OPIIS documentation, the property risk category classifies a property based on its calculated risk score (opiis_int_risk_score.) Higher scores indicate higher risk profile. A property is considered to have a ‘Low’ level of risk if the score is 0-29. Properties with a score of 30-39 are assigned a ‘Moderate’ category, and properties with a score of 40 and over are assigned a ‘High’ category.
OPIIS_SIZE_CATEGORY Per the OPIIS documentation, the property size category classifies a property based on loan size.
Properties with higher Unpaid Principal Balances (UPB) are expected to have a higher impact to FHA in the event of
failure. ‘Very Low’ = &lt 300K, ‘Low’ = &lt 300K and &lt 800K, ‘Low Medium’ = &gt 800K and &lt 2MM, ‘High Medium’ = &gt 2MM and &lt 5MM, ‘Large’ = &gt 5MM and &lt 10MM, ‘Very Large’ = &gt 10MM
OPIIS_INT_RISK_SCORE This is the discrete numeric value calculated by OPIIS in order to determine a property’s level of risk.
IS_ACTIVE_DEC_CASE_IND A Y/N flag that indicates whether or not a property is currently in the DEC.
WAS_EVER_DEC_CASE_IND A Y/N flag that indicates whether or not a currently active property is currently or was ever in the DEC.
IS_INSURED_IND A yes/no indicator signifying whether there is any active insured financing for the active property.
WAS_EVER_INSURED_IND A yes/no indicator signifying whether the currently active property was ever (i.e., is currently or was previously)
insured.
IS_202_811_IND A yes/no indicator signifying whether there are any active 202/811 grants/loans for the active property.
WAS_EVER_202_811_IND A yes/no indicator signifying whether the currently active property ever had (i.e., is currently or was previously) any
202/811 loans/grants.
IS_HUD_HELD_IND A yes/no indicator signifying whether there are any active HUD-held loans for the active property.
IS_HUD_OWNED_IND A yes/no indicator signifying whether the active property is HUD-owned.
IS_FLEXIBLE_SUBSIDY_IND A yes/no indicator signifying whether there are any active flexible subsidy loans for the active property.
IS_HOSPITAL_IND A yes/no indicator signifying whether there are any active hospital loans for the active property.
IS_NURSING_HOME_IND A yes/no indicator signifying whether there are any active nursing home loans for the active property.
IS_BOARD_AND_CARE_IND A yes/no indicator signifying whether there are any active board and care facility loans for the active property.
IS_ASSISTED_LIVING_IND A yes/no indicator signifying whether there are any active assisted living facility loans for the active property.
IS_REFINANCED_IND A yes/no indicator signifying whether there are any active refinanced loans for the active property.
IS_221D3_IND A yes/no indicator signifying whether there are any active 221/d3 loans for the active property.
IS_221D4_IND A yes/no indicator signifying whether there are any active 221/d4 loans for the active property.
IS_236_IND A yes/no indicator signifying whether there are any active 236 loans for the active property.
IS_IN_DEFAULT_DELINQUENT_IND A yes/no indicator signifying whether or not a loan is delinquent or in default per MDDR.
IS_NON_INSURED_IND A yes/no indicator signifying whether there are any active non-insured loans for the active property.
IS_BMIR_IND A yes/no indicator signifying whether there are any active Below Market Interest Rate (BMIR) loans for the active property.
IS_RISK_SHARING_IND A yes/no indicator signifying whether there is any active risk sharing loans for the active property.
IS_MIP_IND A yes/no indicator signifying whether there is any active Mortgagee in Possession (MIP) loans for the active property.
IS_CO_INSURED_IND A yes/no indicator signifying whether there are any active co-insured loans for the active property.
IS_SUBSIDIZED_IND A yes/no indicator signifying whether the active property is subsidized.
WAS_EVER_SUBSIDIZED_IND A yes/no indicator signifying whether the currently active property was ever (i.e., is currently or was previously)
subsidized.
HAS_ACTIVE_ASSISTANCE_IND A yes/no indicator signifying whether there is any active assistance for the active property.
WAS_EVER_ASSISTED_IND A yes/no indicator signifying whether the currently active property was ever (i.e., is currently or was previously)
assisted.
IS_ACC_OLD_IND A yes/no indicator signifying whether there are any active old Annual Contributions Contracts (ACCs) for the active property.
IS_ACC_PERFORMANCE_BASED_IND A yes/no indicator signifying whether there are any active performancebased ACC contracts for the active property.
IS_SEC8_IND A yes/no indicator signifying whether there are any active Section 8 contracts for the active property.
IS_PAC_IND A yes/no indicator signifying whether there are any active Project Assistance Contracts (PACs) for the active property.
IS_PRAC_IND A yes/no indicator signifying whether there are any active Project Rental Assistance Contracts (PRACs) for the active property.
IS_RENT_SUPPLEMENT_IND A yes/no indicator signifying whether there are any active rental supplement contracts for the active property.
IS_SECTION_236_RAP_IND A yes/no indicator signifying whether there are any active Section 236 Rental Assistance Payments (RAP) contracts for the active property.
IS_SEC8_202_IND A yes/no indicator signifying whether there are any active Section 8 202 contracts for the active property.
IS_SEC8_FMHA_515_IND A yes/no indicator signifying whether there are any active Section 8 Farmers Home Administration (FMHA) 515 contracts for the active property.
IS_SEC8_STATE_AGENCY_HFA_IND A yes/no indicator signifying whether there are any active Section 8 state agency Housing Federal Authority (HFA) contracts for the active property.
IS_SEC8_LMSA_IND A yes/no indicator signifying whether there are any active Section 8 Loan Management Set-Aside (LMSA) contracts for the active property.
IS_SEC8_PRPRTY_DISPOSITION_IND A yes/no indicator signifying whether there is any active property disposition contracts for the active property.
IS_SEC8_PRESERVATION_IND A yes/no indicator signifying whether there are any active Section 8 preservation contracts for the active property.
IS_SEC8_OTHR_NW_CNSTRCTION_IND A yes/no indicator signifying whether there is any active Section 8 other new construction contracts for the active
property.
IS_SEC8_OTHER_SUB_REHAB_IND A yes/no indicator signifying whether there is any active Section 8 other sub rehab contracts for the active property.
IS_PENSION_FUND_IND A yes/no indicator signifying whether there is any active pension fund contracts for the active property.
IS_PAC_202_IND A yes/no indicator signifying whether there is any active PAC 202 contracts for the active property.
IS_PAC_811_IND A yes/no indicator signifying whether there is any active PAC 811 contracts for the active property.
IS_PRAC_202_IND A yes/no indicator signifying whether there is any active PRAC 202 contracts for the active property.
IS_PRAC_811_IND A yes/no indicator signifying whether there is any active PRAC 811 contracts for the active property.
HAS_FULL_DEBT_RESTRUCTURE_IND Identifies if the property has a restructured loan associated with it, as defined from MDDR.
LAST_CRITICAL_DATE_DESC This is the description of the latest critical item tracked in MDDR for this property
OAHP_PROJECT_RECOMMENDATION_TX The comments or recommentdations from OAHP for the project
OAHP_PROCESSING_TYPE This is the translated description of the type of restructuring for the property.
IS_ON_WATCH_LIST_IND This indicates whether the property is on the Watch List.
IS_GREEN_RETROFIT_IND This indicates whether the property has a green retrofit loan associated to it
IS_202_DIRECT_LOAN_IND This indicates whether the property has a 202 direct loan associated to it
IS_202_CAPITAL_ADVANCE_IND This indicates whether the property has a 202 capital advance loan associated to it
IS_811_CAPITAL_ADVANCE_IND This indicates whether the property has a 811 capital advance loan associated to it
ENERGY_PERFORMANCE_CONTRCT_IND Indicates if the property has a energy performance contract
IS_SEC8_RAD_DEMO_CONV_IND This indicates wheter the property has a RAD contract associated to it.
FINANCIAL_STMNT_REQ_IND A yes/no indicator signifying whether an AFS is required for the active property
IS_811_PRA_DEMO_IND Indicates if there is a active_contract.is_811_pra_demo_ind contract set to Y or N
CONTRACT1 Active contract # 1 associated with the property
CONTRACT2 Active contract # 2 associated with the property
CONTRACT_COUNT Total number of active contracts associated with the property
UNITS1 The maximum number of units available on the active contract # 1
UNITS2 The maximum number of units available on the active contract # 2
MAXIMUM_CONTRACT_UNIT_COUNT Total number of units across all the active contracts associated with the property
PROGRAM_TYPE1 The name of the program type for the active contract # 1
PROGRAM_TYPE2 The name of the program type for the active contract # 2
EXPIRATION_DATE1 The fiscal year quarter in which the overall active contract expires, for active contract # 1
EXPIRATION_DATE2 The fiscal year quarter in which the overall active contract expires, for active contract # 2
RENT_TO_FMR_RATIO1 Rent to FMR Ratio 1
RENT_TO_FMR_RATIO2 Rent to FMR Ratio 2
BD0_CNT1 The total number of efficiencies for active contract #1
BD0_CNT2 The total number of efficiencies for active contract #2
BD1_CNT1 The total number of units with one bedroom for active contract #1
BD1_CNT2 The total number of units with one bedroom for active contract #2
BD2_CNT1 The total number of units with two bedrooms for active contract #1
BD2_CNT2 The total number of units with two bedrooms for active contract #2
BD3_CNT1 The total number of units with three bedrooms for active contract #1
BD3_CNT2 The total number of units with three bedrooms for active contract #2
BD4_CNT1 The total number of units with four bedrooms for active contract #1
BD4_CNT2 The total number of units with four bedrooms for active contract #2
BD5_CNT1 The total number of units with five or more bedrooms for active contract #1
BD5_CNT2 The total number of units with five or more bedrooms foractive contract #2
FHA_NUM1 The number assigned to identify the active financing # 1 associated with the property
FHA_NUM2 The number assigned to identify the active financing # 2 associated with the property
SOACODE1 Section of the Act Code (SoA) for active financing # 1
SOACODE2 Section of the Act Code (SoA) for active financing # 2
SOA_NAME1 Section of the Act Name (SoA) for active financing # 1
SOA_NAME2 Section of the Act Name (SoA) for active financing # 2
TAXCREDIT1 A yes/no indicator signifying whether the associated active financing # 1 in the DAP system has a tax credit
TAXCREDIT2 A yes/no indicator signifying whether the associated active financing # 2 in the DAP system has a tax credit
FHA_COUNT Total number of active financing associated with the property
STATE2KX Census 2010 FIPS State Code
CNTY_NM2KX Census 2010 County Name
CNTY2KX Census 2010 FIPS County Code
TRACT2KX Census 2010 Tract
BG2KX Census 2010 Block Group
BLOCK2KX Census 2010 Block ID
CURCNTY_NM Current FIPS County Name
CURCNTY Current FIPS County Code
CURCOSUB Current County Subdivision Code (MCD/CC
CURCOSUB_NM Current County Subdivision Name (MCD/CC
PLACE2KX FIPS Place Code
PLACE_NM2KX FIPS Place name
PLACE_CC2KX FIPS Place Class Code
PLACE_INC2KX FIPS Place Incorporated Flag
MSA Metropolitan Statistical Area Code
MSA_NM MSA/PMSA Name
CBSA Core Based Statistical Area
CBSA_NM Core Based Statistical Area, Lowest Level N
NECTA New England City and Town Area, Lowest Le
NECTA_NM NECTA Lowest Level Name
METRO CBSA Metropolitan Area Indicator
MICRO CBSA Micropolitan Area Indicator
FCD_FIPS91 Federal Congressional District (FIPS 9.1 std.)
HLC HUD Locality Code
DPV Delivery Point Validation(DPV) Indicator
DPVRC DPV Return Code
DPVACT DPV Vacancy Flag
DPVNOST DPV "No Stat" Flag
STD_ADDR USPS Standardized Address
URB_OUT Puerto Rico Urbanization Name
STD_CITY USPS Standardized City Name
STD_ST USPS Standardized State Abbreviation
STD_ZIP5 USPS Standardized ZIP Code
STD_ZIP9 USPS Standardized ZIP+4 Code
ZIP_CLASS Type of Zip Code
ZCTA2KX Census 2010 Zip Code Tabulation Area
DPBC Delivery Point Bar Code
DPBC_CKSUM Delivery Point Bar Code, Check Digit
STD_ZIP11 Postnet Bar Code
ADDR_TYPE USPS Address Type "" - no match, "S" - House/Street match, "H" - Highrise, "P" - PO Box, "G" - General Delivery, "R" - Rural Route/Highway Contract
APT_NO Apartment Number
APT_TYPE Apartment Type; Contains the secondary address type abbreviation (Apt = Apartment, Ste = Suite, # = Apartment, RM = Room, FL = Floor, etc..)
C1PGRC General Return Code
C1PPRB Address Match Probability
C1PDRC Directional Return Code
C1PSRC Suffix Return Code
C1PARC Apartment Return Code
C1PRC9 ZIP Return Code
MSGUSPS Postal Matcher Status Message
LAT Latitude (decimal)
LON Longitude (decimal)
RC2KX Census 2010 Geocoder General Return Code
STM2KX Census 2010 Geocoder Street Matcher Return
LVL2KX Census 2010 Geocoder Lat/Long Geocoding L
UR Urban/Rural Indicator
MSG2KX Census 2010 Geocoder Lat/Long Level Status
COUNTY_LEVEL 5 character combination of state and county FIPS codes
PLACE_LEVEL 10 characters. For CDBG Entitlement Cities, this is the CDBG ID. For Urban Counties and State Nonentitlement Areas, is a concatenation of state, county, and place FIPS codes
TRACT_LEVEL 11 character combination of state, county, and Census Tract codes
BLKGRP_LEVEL 12 character combination of State, county, tract, and block group
CAT_LATEST_MROC_SCORE_COLOR Most recent MROC risk category
CAT_LTST_INTGRTD_RSK_SCORE_CAT Most recent IRA risk category
MTR_LATEST_DSCR Most recent Debt Service Coverage Ratio
MGMT_AGENT_ORG_NAME The registered organization name of the active property’s current management agent.
MGMT_CONTACT_FULL_NAME The full name of the active property’s management agent contact.
MGMT_CONTACT_INDV_TITLE_TEXT The official title of the active property’s management agent contact.
MGMT_CONTACT_ADDRESS_LINE1 The street address or the first line of the mailing address for the active property’s management agent contact.
MGMT_CONTACT_ADDRESS_LINE2 The suite number, PO box or other information for the second line of the mailing address for the active property’s management agent contact.
MGMT_CONTACT_CITY_NAME The name of the city in the mailing address for the active property’s management agent contact.
MGMT_CONTACT_STATE_CODE The state code in the mailing address for the active property’s management
agent contact.
MGMT_CONTACT_ZIP_CODE The four-digit zip code extension in the mailing address for the active property’s management agent contact.
MGMT_CONTACT_MAIN_PHN_NBR The main phone number for the active property’s management agent contact.
MGMT_CONTACT_EMAIL_TEXT The Internet email address for the active property’s management agent contact.
LOAN_MATURITY_DATE The date the active financing matures.
DEMO_RESTRUCTURE_CLOSING_DATE The demo restructure closing date
REAC_LAST_INSPCT_RELEASE_DATE The date for release of the latest REAC Physical inspection data associated with the active property
MARK_TO_MARKET_RESTRUCTURE_DT The markup to market restructure date
REAC_LAST_INSPECTION_DATE The date of the latest REAC physical inspection associated with the active property.
FASS_LAST_AFS_CLOSED_DATE The close date of the AFS review of the latest AFS submission for the latest reporting period associated with the active property.
FASS_LAST_REPORTING_END_DT The end of the period covered by the latest Annual Financial Statement (AFS) submission for the latest reporting period associated with the active property.
FULL_DEBT_RESTRUCTURE_DATE The date when the debt restructure occurred
LAST_CRITICAL_DATE This is the date of the latest critical item tracked in MDDR for this property
NGHBRHD_NTWRK_EST_DATE The date the network neighborhood associated with the active property was established.
OCCUPANCY_DATE The initial date that tenants occupied the active property.
OPIIS_RISK_CATEGORY_CHANGE_DT This is the date that the OPIIS risk category last changed.
TROUBLED_STATUS_UPDATE_DATE This is the date that the troubled code was last changed in REMS
WATCH_LIST_DATE This is the date the propery was put on the Watch List.
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map

Back to top

Housing Choice Vouchers by Tract

Housing Choice Vouchers by Tract Metadata
Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
GEOID Geographic Identifier - fully concatenated 11-digit geographic code (State FIPS Code and County FIPS Code and Tract-level Code)
STATE State FIPS Code
COUNTY County FIPS Code
TRACT Census Tract FIPS Code
EACODE Bureau of Economic Analysis Region Code
EANAME Bureau of Economic Analysis Region Name
HCV_PUBLIC Public HCV Count
HCV_PCT_RENTER_OCC_UNITS HCV as a Percent of Renter Occupied Housing Units
HCV_PUBLIC_PCT HCV as a Percent of Renter Occupied Housing Units
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape
SHAPE.LEN Length of the shape's outer line

Back to top

Fair Market Rents

Fair Market Rents Metadata
Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
FMR_0BDR Fair market rent for efficiency apartments
FMR_1BDR Fair market rent for one bedroom apartments
FMR_2BDR Fair market rent for two bedroom apartments
FMR_3BDR Fair market rent for three bedroom apartments
FMR_4BDR Fair market rent for four bedroom apartments
FMR_AREANAME Fair market name
FMR_CODE Fair market code
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in…
SHAPE.LEN Length of the shape's outer line

Back to top

Field Offices

Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
UNIQUEID Unique identifier for each office; number followed by a character
OFFICE HUD Region Office - City and State Abbreviation with a comma between
OFFICE_NM The name of the HUD Office
REGION_OFC HUD Region Office - City and State Abbreviation Only with no comma between
REGION HUD Region Number - Roman Numeral only
REGION_TXT HUD Region Number with 'Region' text, like, "RegionVIII"
URL Web address with relevant information on the HUD web site
BLDG_NM Building name, where it is known
PHONE Telephone Number
EMAIL Email Contact Address
CATEGORY Field, Regional, or Headquarters designation
STATE2KX Census 2010 FIPS State Code
CNTY_NM2KX Census 2010 County Name
CNTY2KX Census 2010 FIPS County Code
TRACT2KX Census 2010 Tract
BG2KX Census 2010 Block Group
BLOCK2KX Census 2010 Block ID
CURCNTY_NM Current FIPS County Name
CURCNTY Current FIPS County Code
CURCOSUB Current County Subdivision Code (MCD/CC
CURCOSUB_NM Current County Subdivision Name (MCD/CC
PLACE2KX FIPS Place Code
PLACE_NM2KX FIPS Place name
PLACE_CC2KX FIPS Place Class Code
PLACE_INC2KX FIPS Place Incorporated Flag
MSA Metropolitan Statistical Area Code
MSA_NM MSA/PMSA Name
CBSA Core Based Statistical Area
CBSA_NM Core Based Statistical Area, Lowest Level Name
NECTA New England City and Town Area, Lowest Level Name
NECTA_NM NECTA Lowest Level Name
METRO CBSA Metropolitan Area Indicator
MICRO CBSA Micropolitan Area Indicator
FCD_FIPS91 Federal Congressional District (FIPS 9.1 std.)
HLC HUD Locality Code
DPV Delivery Point Validation(DPV) Indicator
DPVRC DPV Return Code
DPVACT DPV Vacancy Flag
DPVNOST DPV "No Stat" Flag
STD_ADDR USPS Standardized Address
URB_OUT Puerto Rico Urbanization Name
STD_CITY USPS Standardized City Name
STD_ST USPS Standardized State Abbreviation
STD_ZIP5 USPS Standardized ZIP Code
STD_ZIP9 USPS Standardized ZIP+4 Code
ZIP_CLASS Type of Zip Code
ZCTA2KX Census 2010 Zip Code Tabulation Area
DPBC Delivery Point Bar Code
DPBC_CKSUM Delivery Point Bar Code, Check Digit
STD_ZIP11 Postnet Bar Code
ADDR_TYPE USPS Address Type "" - no match, "S" - House/Street match, "H" - Highrise, "P" - PO Box, "G" - General Delivery, "R" - Rural Route/Highway Contract
APT_NO Apartment Number
APT_TYPE Apartment Type; Contains the secondary address type abbreviation (Apt = Apartment, Ste = Suite, # = Apartment, RM = Room, FL = Floor, etc..)
C1PGRC General Return Code
C1PPRB Address Match Probability
C1PDRC Directional Return Code
C1PSRC Suffix Return Code
C1PARC Apartment Return Code
C1PRC9 ZIP Return Code
MSGUSPS Postal Matcher Status Message
LAT Latitude (decimal)
LON Longitude (decimal)
RC2KX Census 2010 Geocoder General Return Code
STM2KX Census 2010 Geocoder Street Matcher Return
LVL2KX Census 2010 Geocoder Lat/Long Geocoding Level Return
UR Urban/Rural Indicator
MSG2KX Census 2010 Geocoder Lat/Long Level Status
COUNTY_LEVEL 5 character combination of state and county FIPS codes
PLACE_LEVEL 10 characters. For CDBG Entitlement Cities, this is the CDBG ID. For Urban Counties and State Nonentitlement Areas, is a concatenation of state, county, and place FIPS codes
TRACT_LEVEL 11 character combination of state, county, and Census Tract codes
BLKGRP_LEVEL 12 character combination of State, county, tract, and block group
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map

Regions

Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
REGION_NAME HUD Region Name, ie. NEW ENGLAND
REGION Roman Numeral equivalent of HUD Region number
REGION_LABELS Region label to use when labeling data in a map or application
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in meters
SHAPE.LEN Length of the shape's outer line

Back to top

CDBG Activity

CDBG Activity Metadata
Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
ID In IDIS, a uniquely generated value that identifies the record; Numeric version of ID
GRANTEE Name of Grantee
GRANTEE_TYPE Type of Grantee; state grantees (TYPE = 21), entitlement grantees (TYPE = 51, 52, 61), Hawaiian small cities (TYPE = 77) and consortia (TYPE = 90). Entitlement grantees can be categorized as metropolitan cities, central city (TYPE = 51), metropolitan cities, other city (TYPE = 52) and urban counties (TYPE = 61).
GRANTEE_ID Grantee ID associated with CDBG Grantee
IDIS_ACTV_ID IDIS Activity ID representing the individual activity associated with the CDBG Grantee
ADDRESS Street Address
CITY Name of City
STATE State Abbreviation
ZIP ZIP Code
LAT Latitude (Decimal)
LON Longitude (Decimal)
GROUPING Type of CDBG Activity; GROUPING = 'Acquisition' , GROUPING = 'Economic Development', GROUPING = 'Housing', GROUPING = 'Public Improvements', GROUPING = 'Public Services' and GROUPING = 'Other'
NAME Name of Activity
ALIAS Alias
ACTV_FUNDING_AMT Activity Funding Amount
COMPLETED_DT Date Actiivity is Completed
ACTV_CDBG_GEOMETRY The characteristic appearance or visible form of a geographic object as represented on a map

Back to top

CDBG Activity by Tract

CDBG Activity by Tract Metadata
Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
GEOID 11 -character combination of state, county, and Census Tract codes
STATE Census 2010 FIPS State Code
COUNTY Census 2010 FIPS County Code
TRACT Census 2010 Tract Code
NAME Census 2010 Tract Name
CNTY_FIPS 5 character combination of state and county FIPS codes
EACODE Bureau of Economic Analysis (BEA) Economic Area Code
EANAME Bureau of Economic Analysis (BEA) Economic Area Name
STUSAB State Abbreviation
ACQ_COUNT Count of CDBG acquisition activities related to acquisition, including disposition, clearance and demolition, and clean-up of contaminated Sites/brownfields.
ACQ_FUNDING_AMT Funding amount of CDBG acquisition activities related to acquisition, including disposition, clearance and demolition, and clean-up of contaminated Sites/brownfields.
ED_COUNT Count of CDBG Economic Development activities related to economic development, including commercial or industrial rehab, commercial or industrial land acquisition, commercial or industrial construction, commercial or industrial infrastructure development, direct assistance to businesses, and micro-enterprise assistance.
ED_FUNDING_AMT Funding amount of CDBG Economic Development activities related to economic development, including commercial or industrial rehab, commercial or industrial land acquisition, commercial or industrial construction, commercial or industrial infrastructure development, direct assistance to businesses, and micro-enterprise assistance.
HSQ_COUNT Count of CDBG Housing activities related to housing, including multifamily rehab, housing services, code enforcement, operation and repair of foreclosed property and public housing modernization.
HSG_FUNDING_AMT Funding amount of CDBG Housing activities related to housing, including multifamily rehab, housing services, code enforcement, operation and repair of foreclosed property and public housing modernization.
OTH_COUNT Count of CDBG Other activities related to urban renewal completion, non-profit organization capacity building, and assistance to institutions of higher education.
OTH_FUNDING_AMT Funding Amount of CDBG Other activities related to urban renewal completion, non-profit organization capacity building, and assistance to institutions of higher education.
PI_COUNT Count of CDBG Public Improvements activities related to public improvements, including senior centers, youth centers, parks, street improvements, water/sewer improvements, child care centers, fire stations, health centers, non-residential historic preservation, etc.
PI_FUNDING_AMT Funding Amount of CDBG Public Improvements activities related to public improvements, including senior centers, youth centers, parks, street improvements, water/sewer improvements, child care centers, fire stations, health centers, non-residential historic preservation, etc.
PS_COUNT Count of CDBG Public Services activities related to public services, including senior services, legal services, youth services, employment training, health services, homebuyer counseling, food banks, etc. 
PS_FUNDING_AMT Funding Amount of CDBG Public Services activities related to public services, including senior services, legal services, youth services, employment training, health services, homebuyer counseling, food banks, etc. 
TOTAL_COUNT Count of Total CDBG Activities
TOTAL_AMT Funding Amount of Total CDBG Activities
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map

Back to top

HOME Activity by Tract

Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
GEOID 11 -character combination of state, county, and Census Tract codes
STATE Census 2010 FIPS State Code
COUNTY Census 2010 FIPS County Code
TRACT Census 2010 Tract Code
NAME Census 2010 Tract Name
CNTY_FIPS 5 character combination of state and county FIPS codes
EACODE Bureau of Economic Analysis (BEA) Economic Area Code
EANAME Bureau of Economic Analysis (BEA) Economic Area Name
STUSAB State Abbreviation
UAHB_COUNT Home Buyer Assistance Count
FUND_DHB_AMT Home Buyer Assistance Funding Amount
UAHOR_COUNT Home Owner Rehab Assistance Count
FUND_DHOR_AMT Home Owner Rehab Assistance Funding Amount
UATBRA_COUNT Tenant Based Rental Assistance Count
FUND_DTBRA_AMT Tenant Based Rental Assistance Funding Amount
RENTAL_COUNT Multifamily Rental Count
RENTAL_AMT  Multifamily Rental Funding Amount
OTHER_COUNT Count of Other Activity
OTHER_AMT Funding Amount of Other Activity
TOTAL_COUNT  Count of Total Activity
TOTAL_AMT Total Activity Funding Amount
UATOTHOA_COUNT Count of Home Buyer and Home Owner Rehab Assistance
UATOTHOA_AMT Funding Amount of Home Buyer and Home Owner Rehab Assistance
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map

Back to top

CDBG Grantee Areas

CDBG Grantee Areas Metadata
Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
UOGID Grantee ID
NAME Name
TYPE Grantee Type
STUSAB State Abbreviation
STATE The state Federal Information Processing Standard code.
CDBG_AMT CDBG Grant amount
ESG_AMT ESG Grant amount
HOME_AMT HOME grant amount
HOPWA_AMT HOPWA grant amount
TOT_AMT Total Amount
YEAR Year
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in…
SHAPE.LEN Length of the shape's outer line

Back to top

ESG Grantee Areas

Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
UOGID Grantee ID
NAME Name
TYPE Grantee Type
STUSAB State Abbreviation
STATE The state Federal Information Processing Standard code.
CDBG_AMT CDBG Grant amount
ESG_AMT ESG Grant amount
HOME_AMT HOME grant amount
HOPWA_AMT HOPWA grant amount
TOT_AMT Total Amount
YEAR Fiscal Year
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in…
SHAPE.LEN Length of the shape's outer line

Back to top

HOME Grantee Areas

Column Name Column Description
OBJECTID OBJECTID
UOGID Grantee ID
NAME Name
TYPE Grantee Type
STUSAB State Abbreviation
STATE The state Federal Information Processing Standard code.
CDBG_AMT CDBG Grant amount
ESG_AMT ESG Grant amount
HOME_AMT HOME grant amount
HOPWA_AMT HOPWA grant amount
TOT_AMT Total Amount
YEAR Year
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in…
SHAPE.LEN Length of the shape's outer line

Back to top

HOPWA Grantee Areas

Column Name Column Description
OBJECTID OBJECTID
UOGID Grantee ID
NAME Grantee Name
TYPE Grantee Type
STUSAB State Abbreviation
STATE State FIPS Code
CDBG_AMT CDBG Grant Amount
ESG_AMT ESG Grant Amount
HOME_AMT HOME Grant Amount
HOPWA_AMT HOPWA Grant Amount
TOT_AMT Total Grant Amount
YEAR Fiscal Year
PLWH Count of persons living with HIV non-AIDS
PLWHAP Count of Persons living with HIV and AIDS
POP Most Recent Population for area (2013)
TOT_CASES Cumulative cases of AIDS reported
YR1_CASES Number of new cases prior year
YR1_PCI Rate per population
YR3_CASES Number of new cases prior year
YR3_POP Three year population for area
YR3_PCI Rate per population (3 years of data)
UN_TOT Total Unmet need
UN_TBRA Unmet tenant based rental assistance
UN_STRMU Unmet Short-term Rent, Mortgage, and Utility
UN_FBH Unmet Facility Based Housing (Permanent, short-term or transitional)
TBRA Tenant based rental assistance
PH_FAC Permanent housing in facilities
ST_TH Short-term or transitional housing facilities
STRMU Short-term Rent, Mortgage, and Utility
PH_PLAC Permanent housing placement
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in meters
SHAPE.LEN Length of the shape's outer line

Back to top

SCRP Grantees

SCRP Grantees Metadata
Column Name Column Description
OBJECTID OBJECTID
GRANT_NUMB The Grant Tracking Number assigned to applicants when they submit their final applications on Grants.gov
APPLICANT The legal name of the grant applicant
CITY City where the lead applicant is located
STATUS Indicates whether the applicant is a FY10 grantee, FY11 grantee, or only a Preferred Sustainability Status (PSS) holder. Note: grantees also hold PSS in addition to receiving funds.
FUNDING Federal funding awarded to the grantee
STATE State where the lead applicant is located
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in meters
SHAPE.LEN Length of the shape's outer line

Back to top

Choice Grantees

Column Name Column Description
OBJECTID OBJECTID
GRANT_NUM The grant number used in HUD systems for each individual Choice Neighborhoods grant.
LEAD_APP The primary entity responsible for implementing the activities identified in the Transformation Plan. The Lead Applicant will sign the Grant Agreement and is the sole entity that will have access to HUD’s Line of Credit Control System (LOCCS) in order to drawdown Choice Neighborhoods funding.
CO_APP Any entity with which the Lead Applicant chooses to apply for funding under the FY2012 Choice Neighborhoods NOFA. The Co-Applicant will also sign the Grant Agreement and be responsible for implementing the activities identified in the Transformation Plan, but will not directly receive access to funding through HUD’s Line of Credit Control System (LOCCS).
PROJ_CITY The state where the housing site(s) and neighborhood targeted in the Choice Neighborhoods application are located.
PROJ_STATE The state where the housing site(s) and neighborhood targeted in the Choice Neighborhoods application are located.
E_PHA_DEV The type of housing targeted by the Choice Neighborhoods application. Eligible housing types include housing assisted under sections 8 or 9 of the United States Housing Act of 1937 (42 U.S.C. 1437f and 42 U.S.C 1437g), section 202 of Housing Act of 1959 (12 U.S.C. 1701q), and section 811 of the National Affordable Housing Act of 1990 (42 U.S.C 8013). Project-based vouchers (section 8o(13) of the US Housing Act of 1937, as amended) are included in the Section 8 definition, but tenant-based vouchers are excluded except as permitted by HUD.
GRANT_TYPE Specifies whether the applicant received a Choice Neighborhoods Planning grant or Implementation grants. Choice Neighborhoods Planning grants support the development of comprehensive neighborhood revitalization plans which focused on directing resources to address three core goals: Housing, People and Neighborhoods. Choice Neighborhoods Implementation Grants support those communities that have undergone a comprehensive local planning process and are ready to implement their “Transformation Plan” to redevelop the neighborhood.
GRANT_YEAR The year Choice Neighborhoods grant funds were awarded.
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in…
SHAPE.LEN Length of the shape's outer line

Back to top

RIF Grantees

Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
APPLICANT The application number assigned to the grantee upon receipt of their request for funding.
FUNDREQUEST Grant funds awarded to the grantee
GRANTTYPE Indicates the type of grant the responsible organization applied for. (Single Purpose, Comprehensive, or Grants for Economic Development and Entrepreneurship for Federally Recognized Indian Tribes)
NAME The name of the grant recipient legally responsible for the administration of the project or activity proposed at this location
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in…
SHAPE.LEN Length of the shape's outer line

Back to top

UGLG (Unit of General Local Government)

Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
STUSAB State
UGLGSUMLEV UGLG Summary Level
UGLGNAME UGLG Name
UGLGKEY UGLG Key
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in…
SHAPE.LEN Length of the shape's outer line

Back to top

FHA Insured In Force Properties by Census Tract

PFHA Insured In Force Properties by Census Tract Metadata
Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
GEOID Geographic Identifier - fully concatenated geographic code (State FIPS and district number)
STUSAB State Abbreviation
STATE State FIPS Code
COUNTY County FIPS Code
TRACT Census Tract FIPS Code
EACODE BEA Economic Area Code
EANAME BEA Economic Area Name
AREALAND Land Area
AREASQMI Total Area in Square Miles
POPDENSITY Population Density
HUDENSITY Housing Unit Density
NAME Census Tract Name
P001001 100 Percent Population Count
H001001 100 Percent Housing Unit Count
UNPD_BAL_SUM Unpaid Balance
IIF_CNT Count of Active Insured Loans
ORIG_MRTG_AMT_SUM Original Mortgage Amount Aggregate
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in…
SHAPE.LEN Length of the shape's outer line

Back to top

FHA REO Properties for Sale

FHA REO Properties for Sale Metadata
Column Name Column Description
OBJECTID OBJECTID
CASE_NUM Case Number
CASE_STEP_NUMBER Case Step Number
STREET_NUM Street Number
DIRECTION_PREFIX Street Direction Prefix
STREET_NAME Street Name
CITY City
STATE_CODE State
DISPLAY_ZIP_CODE ZIP Code
CENSUS_BLOCK Census Block
CENSUS_TRACT Census Tract
FIPS_STATE_CODE FIPS State Code
CONGRESS_DISSTR Congressional District
OUT_GTLVL Geocode Return Code
MAP_LATITUDE Latitude
MAP_LONGITUDE Longitude
DATE_ACQUIRED Date Acquired
DATE_CLOSED Date Closed
DATE_RECONCILED Date Reconciled
ADDRESS Address
REVITE_NAME Revite Name
REVITE_HOC Revite HOC
GLOBALID FIPS Place Code
SHAPE SHAPE

Back to top

Low and Moderate Income Areas

Column Name Column Description
OBJECTID OBJECTID
GEOID Concatenation of State, County, and Tract FIPS codes
STATE 2-charcter State FIPS code
COUNTY 3-character County FIPS code
TRACT 5-Charcter 2010 Tract FIPS code
BLOCKGROUP 1 character block group FIPS code.
LOW The count of Low income persons.
LMMI The count of Low, Moderate, and Medium income persons
LOWMOD The count of Low and Moderate income persons.
LOWMODUNIV Persons with the potential for being deemed as Low and Moderate income.
LOWMOD_PCT The percentage of Low and Moderate income persons.
UCLOW The uncapped count of Low income persons.
UCLMOD The uncapped count of Low and Moderate income persons.
UCLMOD_P Persons with the potential for being deemed as uncapped Low and Moderate income (same as LOWMODUNIV)
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in meters
SHAPE.LEN Length of the shape's outer line

NSP1 Target Areas

Column Name Column Description
OBJECTID ID
ST State
GR_NAME Grant Name
GRANTNUM Grant Number
GR_AWARD Grant Award
NSP_TYPE NSP Type
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in meters
SHAPE.LEN Length of the shape's outer line

Back to top

NSP2 Target Areas Developments

Column Name Column Description
OBJECTID ID
GR_NAME Grant Name
GRANT_NUM Grant Number
GR_AWARD Grant Award
NSP_TYPE NSP Type
ST State
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in meters
SHAPE.LEN Length of the shape's outer line

Back to top

NSP3 Target Areas

Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
GRANTEE_NAME NSP3 Grantee Name
STATE State
GRANT_NUMBER NSP3 Grant Number
GRANT_AMOUNT NSP3 Grant Amount
NEIGH_ID Neighborhood ID Number, auto-generated by webtool https://www.huduser.gov/NSP/NSP3.html
NEIGH_NAME Neighborhood Name (User Entry)
NSP3_SCORE Neighborhood NSP3 Score, see https://www.huduser.gov/portal/datasets/NSP.html
STATE_SCORE State Minimum Threshold NSP3 Score, see https://www.huduser.gov/portal/datasets/NSP.html
TOTAL_UNIT Total Housing Units in Neighborhood, Census 2000 (Sum90)
AMI_120 Percent Persons Less than 120% AMI
AMI_80 Percent Persons Less than 80% AMI
USPS_UNIT USPS Residential Addresses in Neighborhood
VAC_90DAY Vacant 90 Days or More (USPS, March 2010)
VAC_NOSTAT Residential Addresses NO STAT (USPS, March 2010)
HMDA_TOTAL Total Housing Units to Receive a Mortgage '04-'07 (HMDA)
HMDA_DLQNT Percent of Housing Units with a high cost mortgage '04-'07 (HMDA)
HMDA_HGHCS Percent of Housing Units 90 or more days delinquent or in foreclosure (HMDA)
FC_STARTS Number of Foreclosure Starts in Past Year (HMDA)
REO_UNITS Number of Housing Units Real Estate Owned (July '09 - June '10)
IMPACT_UNI Estimated Number of Properties needed to make an impact, see https://www.huduser.gov/portal/datasets/NSP.html
HOME_VALUE Metro Area (or non-metro area balance) percent fall in home value since peak (FHFA Home Price Index, through June 2010)
UNEMP_05 Place (if place over 20k) or county unemployment rate, June '05 (BLS)
UNEMP_10 Place (if place over 20k) or county unemployment rate, June '10 (BLS)
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in meters
SHAPE.LEN Length of the shape's outer line

Back to top

NSP Activities by Tract

Column Name Column Description
OBJECTID OBJECTID
GEOID Census Tract
STUSAB State
EACODE Economic Area Code
EANAME Economic Area Name
NSP_COUNT total count of NSP-assisted addresses in the tract. Probably over-counts the number of units.
CONSTR_COUNT addresses assisted under the activity categories “Construction of new housing” or “Rehabilitation/reconstruction of residential structures”.
BUYERASST_COUNT addresses assisted under the activity category “Homeownership Assistance to low- and moderate-income”.
DEMO_COUNT addresses assisted under the activity category “Clearance and Demolition”.
LANDBANK_COUNT addresses assisted under the activity categories “Land Banking - Acquisition (NSP Only)” or “Land Banking - Disposition (NSP Only)”.
ACQ_COUNT addresses assisted under the activity category “Acquisition – general”.
OTHERNSP_COUNT addresses assisted through all other activity categories (Acquisition, construction, reconstruction of public facilities; Administration; Capacity building for nonprofit or public entities; Construction/reconstruction of streets; Disposition; Planning; Public services; Rehabilitation/reconstruction of a public improvement; Rehabilitation/reconstruction of other non-residential structures; Rehabilitation/reconstruction of public facilities; and Relocation payments and assistance).
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map

Back to top

Difficult to Develop Areas

Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
GEOID County FIPS
NAME County Name
METRO Metro Indicator
METRO_NAME Metro Name
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape
SHAPE.LEN Length of the shape's outer line

Back to top

Qualified Census Tracts

Column Name Column Description
OBJECTID OBJECTID
GEOID Census Tract ID
STATE State FIPS
COUNTY County FIPS
TRACT Census Tract
NAME Census Tract Name
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in meters
SHAPE.LEN Length of the shape's outer line

Back to top

Underserved Areas

Column Name Column Description
OBJECTID OBJECTID
UNDSRV_KEY Underserved Key
STATE 2-digit FIPS State code
COUNTY County FIPS
TRACT 6-digit 2010 Census tract code (2 decimals implied)
MSA2010 MSA Indicator: 2010 Census/ACS CBSA Code for metropolitan areas, 99999 for nonmetro counties and micropolitan areas
AIAN American Indian Area/Alaska Native Area/Hawaiian Home Land (2010 Census)
SERVED 1-digit underserved flag 0 = served, 1 = underserved, 2 = no determination (no population, no housing units, or no median family income estimate)
UNDSRV_IND 1-digit underserved indicator 0 = not underserved (served or no determination), 1 = underserved
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in square meters
SHAPE.LEN Length of the shape's outer line in meters

Back to top

Homeownership Centers

Column Name Column Description
OBJECTID OBJECTID
HOC Homeownership Center
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in meters
SHAPE.LEN Length of the shape's outer line

Back to top

Homeownership Centers by State

Column Name Column Description
OBJECTID OBJECTID
GEOID State FIPS
STUSAB State FIPS
REGION Region
HOC Homeownership Centers
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in meters
SHAPE.LEN Length of the shape's outer line

Back to top

Revitalization Areas

Column Name Column Description
OBJECTID OBJECTID
NAME Revitalization Area
HOC State
STUSAB Homeownership Center
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in meters
SHAPE.LEN Length of the shape's outer line

Back to top

Revitalization Areas By Block Group

Column Name Column Description
OBJECTID OBJECTID
GEOID Census Block Group ID
STATE State FIPS
COUNTY County FIPS
TRACT Census Tract
BLKGRP Census Block Group
OLD_REVITE_NAME Old Revitalization Area
REVITE_NAME Revitalization Area
COMMENTS HOC Comments
HOC HOC
METRO_STATUS Metro Status
SUR_AREA_NAME Surrounding Area Name
MEDHHINC Block Group Median Household Income
SUR_AREA_MEDHHINC Surrounding Area Median Household Income
INC_ELGBL Eligible Based on Income
HMOWN_RT Block Group Home Ownership Rate
SUR_AREA_HOMEOWNRT Surrounding Area Home Ownership Rate
HMOWN_ELGBL Eligible Based on Home Ownership Rate
ONE_ELIGIBLE Eligible Based on Income or Home Ownership Rate
BOTH_ELIGIBLE Eligible Based on Both Income and Home Ownership Rate
INELGBL_IN_2KX Ineligible by Income and Home Ownership Rate
RHIST_2YR 2-Year REO Sales
RHIST_2YR_RT 2-Year REO Sales (as a % of Active FHA)
RACTIVE Curent REO
RACTIVE_RT Curent REO (as a % of Active FHA)
DFLT_90DY 90-Day FHA Defaults
DFLT_90DY_RT 90-Day FHA Defaults (as a % of Active FHA)
DFLT_90DYFC 90-Day Defaults in Foreclosure
DFLT_90DYFC_RT 90-Day Defaults in Foreclosure (as a % of Active FHA)
IIF_ACTIVE Active FHA-Insured Single Family
IIF_ACTIVE_RT Active FHA-Insured Single Family (as a % of Owner Occupied Units)
CTRC_SALE REO Sales (12-months)
CTRC_SALE_AVG Average REO Sales Price (12-months)
OWN_OCC_HU Owner Occupied Housing Units
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE.AREA Area of the shape in meters
SHAPE.LEN Length of the shape's outer line

Back to top

School Proficiency Index

Column Name Column Description
OBJECTID OBJECTID
BLOCKGROUPID Census Blockgroup ID
SCHL_IDX School Index Values are percentile ranked and range from 0 to 100. The higher the score, the higher the school system quality is in a neighborhood. 

Back to top

Environmental Health Hazard Index

Column Name Column Description
OBJECTID OBJECTID
BLOCKGROUPID Census Blockgroup ID
HAZ_IDX Environmental Health Hazard Index Values are percentile ranked and range from 0 to 100. The higher the index value, the less exposure to toxins harmful to human health. Therefore, the higher the value, the better the environmental quality of a neighborhood, where a neighborhood is a census block-group.

Back to top

Low Poverty Index

Column Name Column Description
OBJECTID OBJECTID
BLOCKGROUPID Census Blockgroup ID
POV_IDX Low Poverty Index Values are percentile ranked and range from 0 to 100. The higher the score, the less exposure to poverty in a neighborhood.

Back to top

Jobs Proximity Index

Column Name Column Description
OBJECTID OBJECTID
BLOCKGROUPID Census Blockgroup ID
JOBS_IDX Jobs Proximity Index Values are percentile ranked and range from 0 to 100. The higher the index value, the better the access to employment opportunities for residents in a neighborhood.

Back to top

Low Transportation Cost Index

Column Name Column Description
OBJECTID OBJECTID
BLOCKGROUPID Census Blockgroup ID
TCOST_IDX Low Transportation Cost Index Values are percentile ranked and range from 0 to 100. The higher the transportation cost index, the lower the cost of transportation in that neighborhood. Transportation costs may be low for a range of reasons, including greater access to public transportation and the density of homes, services, and jobs in the neighborhood and surrounding community.
TRANS_IDX Low Transportation Index Values are percentile ranked and range from 0 to 100.

Back to top

HUD Insured Hospitals

Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
PROPERTY_ID The identifier assigned by the HEREMS database that identifies the active property.
HUB_NAME_TEXT The name of the HUD hub responsiblefor the active property’s HUD servicing site.
SERVICING_SITE_NAME_TEXT The name of the HUD servicing site responsible for the management/servicing functions for the active property.
PROJECT_MANAGER_NAME_TEXT The name of the active property’s project manager.
PROPERTY_NAME_TEXT The recorded name of the active property.
ADDRESS_LINE1_TEXT The primary street address or the first line of the mailing address for the active property.
ADDRESS_LINE2_TEXT The primary suite number, PO box or other information for the second line of the mailing address for the active property.
AUTOMATIC_GEOCODE_IND A yes/no indicator signifying whether the Geocode information in the primary address for the active property has been automatically set or manually set by the user (N indicates the address has been set by the user).
CONGRESSIONAL_DISTRICT_CODE The congressional district code for the active property.
PLACED_BASE_CITY_NAME_TEXT The name of the standard place based
city for the active property.
TOTAL_ASSISTED_UNIT_COUNT The total number of assisted units for
the active property.
TOTAL_UNIT_COUNT The total number of units for the active property.
PROPERTY_ON_SITE_PHONE_NUMBER The phone number for the active property’s on site property manager.
PROPERTY_CATEGORY_NAME The category name for the active property in terms of the following:
202/811, Insured-Subsidized,Insured – Previously Subsidized, Insured-Unsubsidized, HUD Owned, HUD Held, Subsidized – Previously 202/811, Subsidized – Previously Insured Subsidized, No HUD Financing, Flexible Subsidy
Use Restriction, Other Subsidy Servicing Required (Only)
CLIENT_GROUP_CODE The code that identifies the primary population or need served by the active property.
CLIENT_GROUP_NAME The name that describes the primary population or need served by the active property.
CLIENT_GROUP_TYPE The broad category for the primary population or need served by the active property i.e., Disabled, Elderly, Family, or Health Care.
REAC_LAST_INSPECTION_ID The identifier assigned to the latest REAC physical inspection associated with the active property.
REAC_LAST_INSPECTION_SCORE The score of the latest REAC physical inspection associated with the active property.
FASS_LAST_PERFORMANCE_VALUE The performance value of the latest AFS submission for the latest reporting period associated with the active property.
FASS_LST_TOT_MGMT_COND_CNT The total number of management conditions in the latest AFS submission for the latest reporting period associated with the active property.
FASS_LAST_REFERRED_TO_CODE The organization to which the compliance review was referred for the latest AFS submission for the latest reporting period associated with the active property
IS_AFS_REQUIRED_IND A yes/no indicator signifying whether an AFS is required for the active property.
AFS_FISCAL_YR_END_DATE The AFS fiscal year end for the active property, in the format of month and year.
HAS_ACTIVE_FINANCING_IND A yes/no indicator signifying whether there is active financing for the active property.
PRIMARY_FINANCING_TYPE The primary type of financing for the
active property in terms of the following: Insured, 202/811, HUD Owned, HUD Held, Non-Insured, Flexible Subsidy
IS_ALL_FINANCING_PIPELINE_IND A yes/no indicator signifying whether all of the active financing for the active property is in the pipeline.
IS_ALL_CONTRACT_PIPELINE_IND A yes/no indicator signifying whether all of the active contracts for the active property are in the pipeline.
IS_UNDER_MANAGEMENT_IND A yes/no indicator signifying whether the active property is under management.
HAS_SERVICE_AGREEMENT_IND A yes/no indicator signifying whether an active Service Agreement exists for the active property.
HAS_USE_RESTRICTION_IND A yes/no indicator signifying whether an active Use Restriction exists for the active property.
HAS_ACTIVE_IRP_IND A yes/no indicator signifying whether or not an active interest reduction payment agreement is associated with the property.
IS_SERVICE_COORDINATOR_IND A yes/no indicator signifying whether there are any active service coordinator contractsor grants for the active property.
PRIMARY_FHA_NUMBER The Federal Housing Authority (FHA) number assigned to the primary loan for the active property when it has active insurance.
ASSOCIATED_FHA_NUMBER The FHA number associated with the active property.
ASSOCIATED_CONTRACT_NUMBER The contract number associated with the active property.
TROUBLED_CODE A code that identifies if the active property is considered troubled by the field office.
OPIIS_RISK_CATEGORY Per the OPIIS documentation, the property risk category classifies a property based on its calculated risk score (opiis_int_risk_score.) Higher scores indicate higher risk profile. A property is considered to have a ‘Low’ level of risk if the score is 0-29. Properties with a score of 30-39 are assigned a ‘Moderate’ category, and properties with a score of 40 and over are assigned a ‘High’ category.
OPIIS_SIZE_CATEGORY Per the OPIIS documentation, the property size category classifies a property based on loan size.
Properties with higher Unpaid Principal Balances (UPB) are expected to have a higher impact to FHA in the event of
failure. ‘Very Low’ = &lt 300K, ‘Low’ = &lt 300K and &lt 800K, ‘Low Medium’ = &gt 800K and &lt 2MM, ‘High Medium’ = &gt 2MM and &lt 5MM, ‘Large’ = &gt 5MM and &lt 10MM, ‘Very Large’ = &gt 10MM
OPIIS_INT_RISK_SCORE This is the discrete numeric value calculated by OPIIS in order to determine a property’s level of risk.
IS_ACTIVE_DEC_CASE_IND A Y/N flag that indicates whether or not a property is currently in the DEC.
WAS_EVER_DEC_CASE_IND A Y/N flag that indicates whether or not a currently active property is currently or was ever in the DEC.
IS_INSURED_IND A yes/no indicator signifying whether there is any active insured financing for the active property.
WAS_EVER_INSURED_IND A yes/no indicator signifying whether the currently active property was ever (i.e., is currently or was previously)
insured.
IS_202_811_IND A yes/no indicator signifying whether there are any active 202/811 grants/loans for the active property.
WAS_EVER_202_811_IND A yes/no indicator signifying whether the currently active property ever had (i.e., is currently or was previously) any
202/811 loans/grants.
IS_HUD_HELD_IND A yes/no indicator signifying whether there are any active HUD-held loans for the active property.
IS_HUD_OWNED_IND A yes/no indicator signifying whether the active property is HUD-owned.
IS_FLEXIBLE_SUBSIDY_IND A yes/no indicator signifying whether there are any active flexible subsidy loans for the active property.
IS_HOSPITAL_IND A yes/no indicator signifying whether there are any active hospital loans for the active property.
IS_NURSING_HOME_IND A yes/no indicator signifying whether there are any active nursing home loans for the active property.
IS_BOARD_AND_CARE_IND A yes/no indicator signifying whether there are any active board and care facility loans for the active property.
IS_ASSISTED_LIVING_IND A yes/no indicator signifying whether there are any active assisted living facility loans for the active property.
IS_REFINANCED_IND A yes/no indicator signifying whether there are any active refinanced loans for the active property.
IS_221D3_IND A yes/no indicator signifying whether there are any active 221/d3 loans for the active property.
IS_221D4_IND A yes/no indicator signifying whether there are any active 221/d4 loans for the active property.
IS_236_IND A yes/no indicator signifying whether there are any active 236 loans for the active property.
IS_IN_DEFAULT_DELINQUENT_IND A yes/no indicator signifying whether or not a loan is delinquent or in default per MDDR.
IS_NON_INSURED_IND A yes/no indicator signifying whether there are any active non-insured loans for the active property.
IS_BMIR_IND A yes/no indicator signifying whether there are any active Below Market Interest Rate (BMIR) loans for the active property.
IS_RISK_SHARING_IND A yes/no indicator signifying whether there is any active risk sharing loans for the active property.
IS_MIP_IND A yes/no indicator signifying whether there is any active Mortgagee in Possession (MIP) loans for the active property.
IS_CO_INSURED_IND A yes/no indicator signifying whether there are any active co-insured loans for the active property.
IS_SUBSIDIZED_IND A yes/no indicator signifying whether the active property is subsidized.
WAS_EVER_SUBSIDIZED_IND A yes/no indicator signifying whether the currently active property was ever (i.e., is currently or was previously)
subsidized.
HAS_ACTIVE_ASSISTANCE_IND A yes/no indicator signifying whether there is any active assistance for the active property.
WAS_EVER_ASSISTED_IND A yes/no indicator signifying whether the currently active property was ever (i.e., is currently or was previously)
assisted.
IS_ACC_OLD_IND A yes/no indicator signifying whether there are any active old Annual Contributions Contracts (ACCs) for the active property.
IS_ACC_PERFORMANCE_BASED_IND A yes/no indicator signifying whether there are any active performancebased ACC contracts for the active property.
IS_SEC8_IND A yes/no indicator signifying whether there are any active Section 8 contracts for the active property.
IS_PAC_IND A yes/no indicator signifying whether there are any active Project Assistance Contracts (PACs) for the active property.
IS_PRAC_IND A yes/no indicator signifying whether there are any active Project Rental Assistance Contracts (PRACs) for the active property.
IS_RENT_SUPPLEMENT_IND A yes/no indicator signifying whether there are any active rental supplement contracts for the active property.
IS_SECTION_236_RAP_IND A yes/no indicator signifying whether there are any active Section 236 Rental Assistance Payments (RAP) contracts for the active property.
IS_SEC8_202_IND A yes/no indicator signifying whether there are any active Section 8 202 contracts for the active property.
IS_SEC8_FMHA_515_IND A yes/no indicator signifying whether there are any active Section 8 Farmers Home Administration (FMHA) 515 contracts for the active property.
IS_SEC8_STATE_AGENCY_HFA_IND A yes/no indicator signifying whether there are any active Section 8 state agency Housing Federal Authority (HFA) contracts for the active property.
IS_SEC8_LMSA_IND A yes/no indicator signifying whether there are any active Section 8 Loan Management Set-Aside (LMSA) contracts for the active property.
IS_SEC8_PRPRTY_DISPOSITION_IND A yes/no indicator signifying whether there is any active property disposition contracts for the active property.
IS_SEC8_PRESERVATION_IND A yes/no indicator signifying whether there are any active Section 8 preservation contracts for the active property.
IS_SEC8_OTHR_NW_CNSTRCTION_IND A yes/no indicator signifying whether there is any active Section 8 other new construction contracts for the active
property.
IS_SEC8_OTHER_SUB_REHAB_IND A yes/no indicator signifying whether there is any active Section 8 other sub rehab contracts for the active property.
IS_PENSION_FUND_IND A yes/no indicator signifying whether there is any active pension fund contracts for the active property.
IS_PAC_202_IND A yes/no indicator signifying whether there is any active PAC 202 contracts for the active property.
IS_PAC_811_IND A yes/no indicator signifying whether there is any active PAC 811 contracts for the active property.
IS_PRAC_202_IND A yes/no indicator signifying whether there is any active PRAC 202 contracts for the active property.
IS_PRAC_811_IND A yes/no indicator signifying whether there is any active PRAC 811 contracts for the active property.
HAS_FULL_DEBT_RESTRUCTURE_IND Identifies if the property has a restructured loan associated with it, as defined from MDDR.
LAST_CRITICAL_DATE_DESC This is the description of the latest critical item tracked in MDDR for this property
OAHP_PROJECT_RECOMMENDATION_TX The comments or recommentdations from OAHP for the project
OAHP_PROCESSING_TYPE This is the translated description of the type of restructuring for the property.
IS_ON_WATCH_LIST_IND This indicates whether the property is on the Watch List.
IS_GREEN_RETROFIT_IND This indicates whether the property has a green retrofit loan associated to it
IS_202_DIRECT_LOAN_IND This indicates whether the property has a 202 direct loan associated to it
IS_202_CAPITAL_ADVANCE_IND This indicates whether the property has a 202 capital advance loan associated to it
IS_811_CAPITAL_ADVANCE_IND This indicates whether the property has a 811 capital advance loan associated to it
ENERGY_PERFORMANCE_CONTRCT_IND Indicates if the property has a energy performance contract
IS_SEC8_RAD_DEMO_CONV_IND This indicates wheter the property has a RAD contract associated to it.
FINANCIAL_STMNT_REQ_IND A yes/no indicator signifying whether an AFS is required for the active property
IS_811_PRA_DEMO_IND Indicates if there is a active_contract.is_811_pra_demo_ind contract set to Y or N
CONTRACT1 Active contract # 1 associated with the property
CONTRACT2 Active contract # 2 associated with the property
CONTRACT_COUNT Total number of active contracts associated with the property
UNITS1 The maximum number of units available on the active contract # 1
UNITS2 The maximum number of units available on the active contract # 2
MAXIMUM_CONTRACT_UNIT_COUNT Total number of units across all the active contracts associated with the property
PROGRAM_TYPE1 The name of the program type for the active contract # 1
PROGRAM_TYPE2 The name of the program type for the active contract # 2
EXPIRATION_DATE1 The fiscal year quarter in which the overall active contract expires, for active contract # 1
EXPIRATION_DATE2 The fiscal year quarter in which the overall active contract expires, for active contract # 2
RENT_TO_FMR_RATIO1 Rent to FMR Ratio 1
RENT_TO_FMR_RATIO2 Rent to FMR Ratio 2
BD0_CNT1 The total number of efficiencies for active contract #1
BD0_CNT2 The total number of efficiencies for active contract #2
BD1_CNT1 The total number of units with one bedroom for active contract #1
BD1_CNT2 The total number of units with one bedroom for active contract #2
BD2_CNT1 The total number of units with two bedrooms for active contract #1
BD2_CNT2 The total number of units with two bedrooms for active contract #2
BD3_CNT1 The total number of units with three bedrooms for active contract #1
BD3_CNT2 The total number of units with three bedrooms for active contract #2
BD4_CNT1 The total number of units with four bedrooms for active contract #1
BD4_CNT2 The total number of units with four bedrooms for active contract #2
BD5_CNT1 The total number of units with five or more bedrooms for active contract #1
BD5_CNT2 The total number of units with five or more bedrooms foractive contract #2
FHA_NUM1 The number assigned to identify the active financing # 1 associated with the property
FHA_NUM2 The number assigned to identify the active financing # 2 associated with the property
SOACODE1 Section of the Act Code (SoA) for active financing # 1
SOACODE2 Section of the Act Code (SoA) for active financing # 2
SOA_NAME1 Section of the Act Name (SoA) for active financing # 1
SOA_NAME2 Section of the Act Name (SoA) for active financing # 2
TAXCREDIT1 A yes/no indicator signifying whether the associated active financing # 1 in the DAP system has a tax credit
TAXCREDIT2 A yes/no indicator signifying whether the associated active financing # 2 in the DAP system has a tax credit
FHA_COUNT Total number of active financing associated with the property
STATE2KX Census 2010 FIPS State Code
CNTY_NM2KX Census 2010 County Name
CNTY2KX Census 2010 FIPS County Code
TRACT2KX Census 2010 Tract
BG2KX Census 2010 Block Group
BLOCK2KX Census 2010 Block ID
CURCNTY_NM Current FIPS County Name
CURCNTY Current FIPS County Code
CURCOSUB Current County Subdivision Code (MCD/CC
CURCOSUB_NM Current County Subdivision Name (MCD/CC
PLACE2KX FIPS Place Code
PLACE_NM2KX FIPS Place name
PLACE_CC2KX FIPS Place Class Code
PLACE_INC2KX FIPS Place Incorporated Flag
MSA Metropolitan Statistical Area Code
MSA_NM MSA/PMSA Name
CBSA Core Based Statistical Area
CBSA_NM Core Based Statistical Area, Lowest Level N
NECTA New England City and Town Area, Lowest Le
NECTA_NM NECTA Lowest Level Name
METRO CBSA Metropolitan Area Indicator
MICRO CBSA Micropolitan Area Indicator
FCD_FIPS91 Federal Congressional District (FIPS 9.1 std.)
HLC HUD Locality Code
DPV Delivery Point Validation(DPV) Indicator
DPVRC DPV Return Code
DPVACT DPV Vacancy Flag
DPVNOST DPV "No Stat" Flag
STD_ADDR USPS Standardized Address
URB_OUT Puerto Rico Urbanization Name
STD_CITY USPS Standardized City Name
STD_ST USPS Standardized State Abbreviation
STD_ZIP5 USPS Standardized ZIP Code
STD_ZIP9 USPS Standardized ZIP+4 Code
ZIP_CLASS Type of Zip Code
ZCTA2KX Census 2010 Zip Code Tabulation Area
DPBC Delivery Point Bar Code
DPBC_CKSUM Delivery Point Bar Code, Check Digit
STD_ZIP11 Postnet Bar Code
ADDR_TYPE USPS Address Type "" - no match, "S" - House/Street match, "H" - Highrise, "P" - PO Box, "G" - General Delivery, "R" - Rural Route/Highway Contract
APT_NO Apartment Number
APT_TYPE Apartment Type; Contains the secondary address type abbreviation (Apt = Apartment, Ste = Suite, # = Apartment, RM = Room, FL = Floor, etc..)
C1PGRC General Return Code
C1PPRB Address Match Probability
C1PDRC Directional Return Code
C1PSRC Suffix Return Code
C1PARC Apartment Return Code
C1PRC9 ZIP Return Code
MSGUSPS Postal Matcher Status Message
LAT Latitude (decimal)
LON Longitude (decimal)
RC2KX Census 2010 Geocoder General Return Code
STM2KX Census 2010 Geocoder Street Matcher Return
LVL2KX Census 2010 Geocoder Lat/Long Geocoding L
UR Urban/Rural Indicator
MSG2KX Census 2010 Geocoder Lat/Long Level Status
COUNTY_LEVEL 5 character combination of state and county FIPS codes
PLACE_LEVEL 10 characters. For CDBG Entitlement Cities, this is the CDBG ID. For Urban Counties and State Nonentitlement Areas, is a concatenation of state, county, and place FIPS codes
TRACT_LEVEL 11 character combination of state, county, and Census Tract codes
BLKGRP_LEVEL 12 character combination of State, county, tract, and block group
CAT_LATEST_MROC_SCORE_COLOR Most recent MROC risk category
CAT_LTST_INTGRTD_RSK_SCORE_CAT Most recent IRA risk category
MTR_LATEST_DSCR Most recent Debt Service Coverage Ratio
MGMT_AGENT_ORG_NAME The registered organization name of the active property’s current management agent.
MGMT_CONTACT_FULL_NAME The full name of the active property’s management agent contact.
MGMT_CONTACT_INDV_TITLE_TEXT The official title of the active property’s management agent contact.
MGMT_CONTACT_ADDRESS_LINE1 The street address or the first line of the mailing address for the active property’s management agent contact.
MGMT_CONTACT_ADDRESS_LINE2 The suite number, PO box or other information for the second line of the mailing address for the active property’s management agent contact.
MGMT_CONTACT_CITY_NAME The name of the city in the mailing address for the active property’s management agent contact.
MGMT_CONTACT_STATE_CODE The state code in the mailing address for the active property’s management
agent contact.
MGMT_CONTACT_ZIP_CODE The four-digit zip code extension in the mailing address for the active property’s management agent contact.
MGMT_CONTACT_MAIN_PHN_NBR The main phone number for the active property’s management agent contact.
MGMT_CONTACT_EMAIL_TEXT The Internet email address for the active property’s management agent contact.
LOAN_MATURITY_DATE The date the active financing matures.
DEMO_RESTRUCTURE_CLOSING_DATE The demo restructure closing date
REAC_LAST_INSPCT_RELEASE_DATE The date for release of the latest REAC Physical inspection data associated with the active property
MARK_TO_MARKET_RESTRUCTURE_DT The markup to market restructure date
REAC_LAST_INSPECTION_DATE The date of the latest REAC physical inspection associated with the active property.
FASS_LAST_AFS_CLOSED_DATE The close date of the AFS review of the latest AFS submission for the latest reporting period associated with the active property.
FASS_LAST_REPORTING_END_DT The end of the period covered by the latest Annual Financial Statement (AFS) submission for the latest reporting period associated with the active property.
FULL_DEBT_RESTRUCTURE_DATE The date when the debt restructure occurred
LAST_CRITICAL_DATE This is the date of the latest critical item tracked in MDDR for this property
NGHBRHD_NTWRK_EST_DATE The date the network neighborhood associated with the active property was established.
OCCUPANCY_DATE The initial date that tenants occupied the active property.
OPIIS_RISK_CATEGORY_CHANGE_DT This is the date that the OPIIS risk category last changed.
TROUBLED_STATUS_UPDATE_DATE This is the date that the troubled code was last changed in REMS
WATCH_LIST_DATE This is the date the propery was put on the Watch List.
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map

Back to top

HUD Insured Multifamily Properties

Column Name Column Description
OBJECTID In ArcGIS, a system-managed value that uniquely identifies a record or feature.
PROPERTY_ID The identifier assigned by the HEREMS database that identifies the active property.
HUB_NAME_TEXT The name of the HUD hub responsiblefor the active property’s HUD servicing site.
SERVICING_SITE_NAME_TEXT The name of the HUD servicing site responsible for the management/servicing functions for the active property.
PROJECT_MANAGER_NAME_TEXT The name of the active property’s project manager.
PROPERTY_NAME_TEXT The recorded name of the active property.
ADDRESS_LINE1_TEXT The primary street address or the first line of the mailing address for the active property.
ADDRESS_LINE2_TEXT The primary suite number, PO box or other information for the second line of the mailing address for the active property.
AUTOMATIC_GEOCODE_IND A yes/no indicator signifying whether the Geocode information in the primary address for the active property has been automatically set or manually set by the user (N indicates the address has been set by the user).
CONGRESSIONAL_DISTRICT_CODE The congressional district code for the active property.
PLACED_BASE_CITY_NAME_TEXT The name of the standard place based
city for the active property.
TOTAL_ASSISTED_UNIT_COUNT The total number of assisted units for
the active property.
TOTAL_UNIT_COUNT The total number of units for the active property.
PROPERTY_ON_SITE_PHONE_NUMBER The phone number for the active property’s on site property manager.
PROPERTY_CATEGORY_NAME The category name for the active property in terms of the following:
202/811, Insured-Subsidized,Insured – Previously Subsidized, Insured-Unsubsidized, HUD Owned, HUD Held, Subsidized – Previously 202/811, Subsidized – Previously Insured Subsidized, No HUD Financing, Flexible Subsidy
Use Restriction, Other Subsidy Servicing Required (Only)
CLIENT_GROUP_CODE The code that identifies the primary population or need served by the active property.
CLIENT_GROUP_NAME The name that describes the primary population or need served by the active property.
CLIENT_GROUP_TYPE The broad category for the primary population or need served by the active property i.e., Disabled, Elderly, Family, or Health Care.
REAC_LAST_INSPECTION_ID The identifier assigned to the latest REAC physical inspection associated with the active property.
REAC_LAST_INSPECTION_SCORE The score of the latest REAC physical inspection associated with the active property.
FASS_LAST_PERFORMANCE_VALUE The performance value of the latest AFS submission for the latest reporting period associated with the active property.
FASS_LST_TOT_MGMT_COND_CNT The total number of management conditions in the latest AFS submission for the latest reporting period associated with the active property.
FASS_LAST_REFERRED_TO_CODE The organization to which the compliance review was referred for the latest AFS submission for the latest reporting period associated with the active property
IS_AFS_REQUIRED_IND A yes/no indicator signifying whether an AFS is required for the active property.
AFS_FISCAL_YR_END_DATE The AFS fiscal year end for the active property, in the format of month and year.
HAS_ACTIVE_FINANCING_IND A yes/no indicator signifying whether there is active financing for the active property.
PRIMARY_FINANCING_TYPE The primary type of financing for the
active property in terms of the following: Insured, 202/811, HUD Owned, HUD Held, Non-Insured, Flexible Subsidy
IS_ALL_FINANCING_PIPELINE_IND A yes/no indicator signifying whether all of the active financing for the active property is in the pipeline.
IS_ALL_CONTRACT_PIPELINE_IND A yes/no indicator signifying whether all of the active contracts for the active property are in the pipeline.
IS_UNDER_MANAGEMENT_IND A yes/no indicator signifying whether the active property is under management.
HAS_SERVICE_AGREEMENT_IND A yes/no indicator signifying whether an active Service Agreement exists for the active property.
HAS_USE_RESTRICTION_IND A yes/no indicator signifying whether an active Use Restriction exists for the active property.
HAS_ACTIVE_IRP_IND A yes/no indicator signifying whether or not an active interest reduction payment agreement is associated with the property.
IS_SERVICE_COORDINATOR_IND A yes/no indicator signifying whether there are any active service coordinator contractsor grants for the active property.
PRIMARY_FHA_NUMBER The Federal Housing Authority (FHA) number assigned to the primary loan for the active property when it has active insurance.
ASSOCIATED_FHA_NUMBER The FHA number associated with the active property.
ASSOCIATED_CONTRACT_NUMBER The contract number associated with the active property.
TROUBLED_CODE A code that identifies if the active property is considered troubled by the field office.
OPIIS_RISK_CATEGORY Per the OPIIS documentation, the property risk category classifies a property based on its calculated risk score (opiis_int_risk_score.) Higher scores indicate higher risk profile. A property is considered to have a ‘Low’ level of risk if the score is 0-29. Properties with a score of 30-39 are assigned a ‘Moderate’ category, and properties with a score of 40 and over are assigned a ‘High’ category.
OPIIS_SIZE_CATEGORY Per the OPIIS documentation, the property size category classifies a property based on loan size.
Properties with higher Unpaid Principal Balances (UPB) are expected to have a higher impact to FHA in the event of
failure. ‘Very Low’ = &lt 300K, ‘Low’ = &lt 300K and &lt 800K, ‘Low Medium’ = &gt 800K and &lt 2MM, ‘High Medium’ = &gt 2MM and &lt 5MM, ‘Large’ = &gt 5MM and &lt 10MM, ‘Very Large’ = &gt 10MM
OPIIS_INT_RISK_SCORE This is the discrete numeric value calculated by OPIIS in order to determine a property’s level of risk.
IS_ACTIVE_DEC_CASE_IND A Y/N flag that indicates whether or not a property is currently in the DEC.
WAS_EVER_DEC_CASE_IND A Y/N flag that indicates whether or not a currently active property is currently or was ever in the DEC.
IS_INSURED_IND A yes/no indicator signifying whether there is any active insured financing for the active property.
WAS_EVER_INSURED_IND A yes/no indicator signifying whether the currently active property was ever (i.e., is currently or was previously)
insured.
IS_202_811_IND A yes/no indicator signifying whether there are any active 202/811 grants/loans for the active property.
WAS_EVER_202_811_IND A yes/no indicator signifying whether the currently active property ever had (i.e., is currently or was previously) any
202/811 loans/grants.
IS_HUD_HELD_IND A yes/no indicator signifying whether there are any active HUD-held loans for the active property.
IS_HUD_OWNED_IND A yes/no indicator signifying whether the active property is HUD-owned.
IS_FLEXIBLE_SUBSIDY_IND A yes/no indicator signifying whether there are any active flexible subsidy loans for the active property.
IS_HOSPITAL_IND A yes/no indicator signifying whether there are any active hospital loans for the active property.
IS_NURSING_HOME_IND A yes/no indicator signifying whether there are any active nursing home loans for the active property.
IS_BOARD_AND_CARE_IND A yes/no indicator signifying whether there are any active board and care facility loans for the active property.
IS_ASSISTED_LIVING_IND A yes/no indicator signifying whether there are any active assisted living facility loans for the active property.
IS_REFINANCED_IND A yes/no indicator signifying whether there are any active refinanced loans for the active property.
IS_221D3_IND A yes/no indicator signifying whether there are any active 221/d3 loans for the active property.
IS_221D4_IND A yes/no indicator signifying whether there are any active 221/d4 loans for the active property.
IS_236_IND A yes/no indicator signifying whether there are any active 236 loans for the active property.
IS_IN_DEFAULT_DELINQUENT_IND A yes/no indicator signifying whether or not a loan is delinquent or in default per MDDR.
IS_NON_INSURED_IND A yes/no indicator signifying whether there are any active non-insured loans for the active property.
IS_BMIR_IND A yes/no indicator signifying whether there are any active Below Market Interest Rate (BMIR) loans for the active property.
IS_RISK_SHARING_IND A yes/no indicator signifying whether there is any active risk sharing loans for the active property.
IS_MIP_IND A yes/no indicator signifying whether there is any active Mortgagee in Possession (MIP) loans for the active property.
IS_CO_INSURED_IND A yes/no indicator signifying whether there are any active co-insured loans for the active property.
IS_SUBSIDIZED_IND A yes/no indicator signifying whether the active property is subsidized.
WAS_EVER_SUBSIDIZED_IND A yes/no indicator signifying whether the currently active property was ever (i.e., is currently or was previously)
subsidized.
HAS_ACTIVE_ASSISTANCE_IND A yes/no indicator signifying whether there is any active assistance for the active property.
WAS_EVER_ASSISTED_IND A yes/no indicator signifying whether the currently active property was ever (i.e., is currently or was previously)
assisted.
IS_ACC_OLD_IND A yes/no indicator signifying whether there are any active old Annual Contributions Contracts (ACCs) for the active property.
IS_ACC_PERFORMANCE_BASED_IND A yes/no indicator signifying whether there are any active performancebased ACC contracts for the active property.
IS_SEC8_IND A yes/no indicator signifying whether there are any active Section 8 contracts for the active property.
IS_PAC_IND A yes/no indicator signifying whether there are any active Project Assistance Contracts (PACs) for the active property.
IS_PRAC_IND A yes/no indicator signifying whether there are any active Project Rental Assistance Contracts (PRACs) for the active property.
IS_RENT_SUPPLEMENT_IND A yes/no indicator signifying whether there are any active rental supplement contracts for the active property.
IS_SECTION_236_RAP_IND A yes/no indicator signifying whether there are any active Section 236 Rental Assistance Payments (RAP) contracts for the active property.
IS_SEC8_202_IND A yes/no indicator signifying whether there are any active Section 8 202 contracts for the active property.
IS_SEC8_FMHA_515_IND A yes/no indicator signifying whether there are any active Section 8 Farmers Home Administration (FMHA) 515 contracts for the active property.
IS_SEC8_STATE_AGENCY_HFA_IND A yes/no indicator signifying whether there are any active Section 8 state agency Housing Federal Authority (HFA) contracts for the active property.
IS_SEC8_LMSA_IND A yes/no indicator signifying whether there are any active Section 8 Loan Management Set-Aside (LMSA) contracts for the active property.
IS_SEC8_PRPRTY_DISPOSITION_IND A yes/no indicator signifying whether there is any active property disposition contracts for the active property.
IS_SEC8_PRESERVATION_IND A yes/no indicator signifying whether there are any active Section 8 preservation contracts for the active property.
IS_SEC8_OTHR_NW_CNSTRCTION_IND A yes/no indicator signifying whether there is any active Section 8 other new construction contracts for the active
property.
IS_SEC8_OTHER_SUB_REHAB_IND A yes/no indicator signifying whether there is any active Section 8 other sub rehab contracts for the active property.
IS_PENSION_FUND_IND A yes/no indicator signifying whether there is any active pension fund contracts for the active property.
IS_PAC_202_IND A yes/no indicator signifying whether there is any active PAC 202 contracts for the active property.
IS_PAC_811_IND A yes/no indicator signifying whether there is any active PAC 811 contracts for the active property.
IS_PRAC_202_IND A yes/no indicator signifying whether there is any active PRAC 202 contracts for the active property.
IS_PRAC_811_IND A yes/no indicator signifying whether there is any active PRAC 811 contracts for the active property.
HAS_FULL_DEBT_RESTRUCTURE_IND Identifies if the property has a restructured loan associated with it, as defined from MDDR.
LAST_CRITICAL_DATE_DESC This is the description of the latest critical item tracked in MDDR for this property
OAHP_PROJECT_RECOMMENDATION_TX The comments or recommentdations from OAHP for the project
OAHP_PROCESSING_TYPE This is the translated description of the type of restructuring for the property.
IS_ON_WATCH_LIST_IND This indicates whether the property is on the Watch List.
IS_GREEN_RETROFIT_IND This indicates whether the property has a green retrofit loan associated to it
IS_202_DIRECT_LOAN_IND This indicates whether the property has a 202 direct loan associated to it
IS_202_CAPITAL_ADVANCE_IND This indicates whether the property has a 202 capital advance loan associated to it
IS_811_CAPITAL_ADVANCE_IND This indicates whether the property has a 811 capital advance loan associated to it
ENERGY_PERFORMANCE_CONTRCT_IND Indicates if the property has a energy performance contract
IS_SEC8_RAD_DEMO_CONV_IND This indicates wheter the property has a RAD contract associated to it.
FINANCIAL_STMNT_REQ_IND A yes/no indicator signifying whether an AFS is required for the active property
IS_811_PRA_DEMO_IND Indicates if there is a active_contract.is_811_pra_demo_ind contract set to Y or N
CONTRACT1 Active contract # 1 associated with the property
CONTRACT2 Active contract # 2 associated with the property
CONTRACT_COUNT Total number of active contracts associated with the property
UNITS1 The maximum number of units available on the active contract # 1
UNITS2 The maximum number of units available on the active contract # 2
MAXIMUM_CONTRACT_UNIT_COUNT Total number of units across all the active contracts associated with the property
PROGRAM_TYPE1 The name of the program type for the active contract # 1
PROGRAM_TYPE2 The name of the program type for the active contract # 2
EXPIRATION_DATE1 The fiscal year quarter in which the overall active contract expires, for active contract # 1
EXPIRATION_DATE2 The fiscal year quarter in which the overall active contract expires, for active contract # 2
RENT_TO_FMR_RATIO1 Rent to FMR Ratio 1
RENT_TO_FMR_RATIO2 Rent to FMR Ratio 2
BD0_CNT1 The total number of efficiencies for active contract #1
BD0_CNT2 The total number of efficiencies for active contract #2
BD1_CNT1 The total number of units with one bedroom for active contract #1
BD1_CNT2 The total number of units with one bedroom for active contract #2
BD2_CNT1 The total number of units with two bedrooms for active contract #1
BD2_CNT2 The total number of units with two bedrooms for active contract #2
BD3_CNT1 The total number of units with three bedrooms for active contract #1
BD3_CNT2 The total number of units with three bedrooms for active contract #2
BD4_CNT1 The total number of units with four bedrooms for active contract #1
BD4_CNT2 The total number of units with four bedrooms for active contract #2
BD5_CNT1 The total number of units with five or more bedrooms for active contract #1
BD5_CNT2 The total number of units with five or more bedrooms foractive contract #2
FHA_NUM1 The number assigned to identify the active financing # 1 associated with the property
FHA_NUM2 The number assigned to identify the active financing # 2 associated with the property
SOACODE1 Section of the Act Code (SoA) for active financing # 1
SOACODE2 Section of the Act Code (SoA) for active financing # 2
SOA_NAME1 Section of the Act Name (SoA) for active financing # 1
SOA_NAME2 Section of the Act Name (SoA) for active financing # 2
TAXCREDIT1 A yes/no indicator signifying whether the associated active financing # 1 in the DAP system has a tax credit
TAXCREDIT2 A yes/no indicator signifying whether the associated active financing # 2 in the DAP system has a tax credit
FHA_COUNT Total number of active financing associated with the property
STATE2KX Census 2010 FIPS State Code
CNTY_NM2KX Census 2010 County Name
CNTY2KX Census 2010 FIPS County Code
TRACT2KX Census 2010 Tract
BG2KX Census 2010 Block Group
BLOCK2KX Census 2010 Block ID
CURCNTY_NM Current FIPS County Name
CURCNTY Current FIPS County Code
CURCOSUB Current County Subdivision Code (MCD/CC
CURCOSUB_NM Current County Subdivision Name (MCD/CC
PLACE2KX FIPS Place Code
PLACE_NM2KX FIPS Place name
PLACE_CC2KX FIPS Place Class Code
PLACE_INC2KX FIPS Place Incorporated Flag
MSA Metropolitan Statistical Area Code
MSA_NM MSA/PMSA Name
CBSA Core Based Statistical Area
CBSA_NM Core Based Statistical Area, Lowest Level N
NECTA New England City and Town Area, Lowest Le
NECTA_NM NECTA Lowest Level Name
METRO CBSA Metropolitan Area Indicator
MICRO CBSA Micropolitan Area Indicator
FCD_FIPS91 Federal Congressional District (FIPS 9.1 std.)
HLC HUD Locality Code
DPV Delivery Point Validation(DPV) Indicator
DPVRC DPV Return Code
DPVACT DPV Vacancy Flag
DPVNOST DPV "No Stat" Flag
STD_ADDR USPS Standardized Address
URB_OUT Puerto Rico Urbanization Name
STD_CITY USPS Standardized City Name
STD_ST USPS Standardized State Abbreviation
STD_ZIP5 USPS Standardized ZIP Code
STD_ZIP9 USPS Standardized ZIP+4 Code
ZIP_CLASS Type of Zip Code
ZCTA2KX Census 2010 Zip Code Tabulation Area
DPBC Delivery Point Bar Code
DPBC_CKSUM Delivery Point Bar Code, Check Digit
STD_ZIP11 Postnet Bar Code
ADDR_TYPE USPS Address Type "" - no match, "S" - House/Street match, "H" - Highrise, "P" - PO Box, "G" - General Delivery, "R" - Rural Route/Highway Contract
APT_NO Apartment Number
APT_TYPE Apartment Type; Contains the secondary address type abbreviation (Apt = Apartment, Ste = Suite, # = Apartment, RM = Room, FL = Floor, etc..)
C1PGRC General Return Code
C1PPRB Address Match Probability
C1PDRC Directional Return Code
C1PSRC Suffix Return Code
C1PARC Apartment Return Code
C1PRC9 ZIP Return Code
MSGUSPS Postal Matcher Status Message
LAT Latitude (decimal)
LON Longitude (decimal)
RC2KX Census 2010 Geocoder General Return Code
STM2KX Census 2010 Geocoder Street Matcher Return
LVL2KX Census 2010 Geocoder Lat/Long Geocoding L
UR Urban/Rural Indicator
MSG2KX Census 2010 Geocoder Lat/Long Level Status
COUNTY_LEVEL 5 character combination of state and county FIPS codes
PLACE_LEVEL 10 characters. For CDBG Entitlement Cities, this is the CDBG ID. For Urban Counties and State Nonentitlement Areas, is a concatenation of state, county, and place FIPS codes
TRACT_LEVEL 11 character combination of state, county, and Census Tract codes
BLKGRP_LEVEL 12 character combination of State, county, tract, and block group
CAT_LATEST_MROC_SCORE_COLOR Most recent MROC risk category
CAT_LTST_INTGRTD_RSK_SCORE_CAT Most recent IRA risk category
MTR_LATEST_DSCR Most recent Debt Service Coverage Ratio
MGMT_AGENT_ORG_NAME The registered organization name of the active property’s current management agent.
MGMT_CONTACT_FULL_NAME The full name of the active property’s management agent contact.
MGMT_CONTACT_INDV_TITLE_TEXT The official title of the active property’s management agent contact.
MGMT_CONTACT_ADDRESS_LINE1 The street address or the first line of the mailing address for the active property’s management agent contact.
MGMT_CONTACT_ADDRESS_LINE2 The suite number, PO box or other information for the second line of the mailing address for the active property’s management agent contact.
MGMT_CONTACT_CITY_NAME The name of the city in the mailing address for the active property’s management agent contact.
MGMT_CONTACT_STATE_CODE The state code in the mailing address for the active property’s management
agent contact.
MGMT_CONTACT_ZIP_CODE The four-digit zip code extension in the mailing address for the active property’s management agent contact.
MGMT_CONTACT_MAIN_PHN_NBR The main phone number for the active property’s management agent contact.
MGMT_CONTACT_EMAIL_TEXT The Internet email address for the active property’s management agent contact.
LOAN_MATURITY_DATE The date the active financing matures.
DEMO_RESTRUCTURE_CLOSING_DATE The demo restructure closing date
REAC_LAST_INSPCT_RELEASE_DATE The date for release of the latest REAC Physical inspection data associated with the active property
MARK_TO_MARKET_RESTRUCTURE_DT The markup to market restructure date
REAC_LAST_INSPECTION_DATE The date of the latest REAC physical inspection associated with the active property.
FASS_LAST_AFS_CLOSED_DATE The close date of the AFS review of the latest AFS submission for the latest reporting period associated with the active property.
FASS_LAST_REPORTING_END_DT The end of the period covered by the latest Annual Financial Statement (AFS) submission for the latest reporting period associated with the active property.
FULL_DEBT_RESTRUCTURE_DATE The date when the debt restructure occurred
LAST_CRITICAL_DATE This is the date of the latest critical item tracked in MDDR for this property
NGHBRHD_NTWRK_EST_DATE The date the network neighborhood associated with the active property was established.
OCCUPANCY_DATE The initial date that tenants occupied the active property.
OPIIS_RISK_CATEGORY_CHANGE_DT This is the date that the OPIIS risk category last changed.
TROUBLED_STATUS_UPDATE_DATE This is the date that the troubled code was last changed in REMS
WATCH_LIST_DATE This is the date the propery was put on the Watch List.
SHAPE The characteristic appearance or visible form of a geographic object as represented on a map

Back to top

COC Areas

Column Name Column Description
OBJECTID OBJECTID
COCNAME Length of the shape's outer line
STUSAB State FIPS Code
COCNUM Six digit string variable. Unique identifier for each Continuum of Care. First two digits are the state abbreviation, then a dash, then a three digit number starting with 5 or 6
STATE_NAME State Name
STATUS Status
NEEDSTATUS Needs Status Classification
PPRN Pro-Rata Classification
ES_CN_HWACW Emergency Shelter Beds - Year Round for Households with Adult(s) and Child(ren)
ES_CN_HWOA_TOT Emergency Shelter Beds - Year Round for Households with Only Adults
ES_CN_HWOC Emergency Shelter Beds – Year Round for Households with Only Children
ES_CN_VET Emergency Shelter Beds designated for veterans
ES_VSO_HWAC_TOT Emergency Shelter Beds - Voucher/Seasonal/Overflow Beds for Households with Adult(s) and Child(ren)
ES_VSO_HWOA_TOT Emergency Shelter Beds - Voucher/Seasonal/Overflow Beds for Households with Only Adults
ES_VSO_HWOC_TOT Emergency Shelter Beds – Voucher/Seasonal/Overflow Beds for Households with Only Children
ES_VSO_VET_TOT Emergency Shelter Voucher/Seasonal/Overflow Beds designated for veterans
TH_CN_HWAC_TOT Transitional Housing Beds - Year Round Beds - Households with Adult(s) and Child(ren) – Beds for households with children
TH_CN_HWOA Transitional Housing Beds - Year Round Beds - Households with Only Adults
TH_CN_HWOC Transitional Housing Beds – Year Round Beds for Households with Only Children
TH_CN_VET Transitional Housing beds designated for veterans
RRH_CN_HWAC_TOT Rapid Rehousing Beds - Year Round Beds - Households with Adult(s) and Child(ren) – Beds for households with children
RRH_CN_HWOA Rapid Rehousing Beds - Year Round Beds - Households with Only Adults
RRH_CN_HWOC Rapid Rehousing Beds – Year Round Beds for Households with Only Children
RRH_CN_VET Rapid Rehousing beds designated for veterans
PSH_CN_HWAC_TOT Current/New Permanent Supportive Housing Beds - Year Round Beds - Households with Adult(s) and Child(ren) – Beds for households with children
PSH_CN_HWOA Current/New Permanent Supportive Housing Beds - Year Round Beds - Households with Only Adults
PSH_CN_HWOC Current/New Permanent Supportive Housing Beds – Year Round Beds for Households with Only Children
PSH_CN_VET Current/New Permanent Supportive Housing beds designated for veterans
PSH_CN_CH Current/New Permanent Supportive Housing beds designated for chronically homeless persons
PSH_U_HWAC_TOT Under Development Permanent Supportive Housing Beds - Year Round Beds - Households with Adult(s) and Child(ren) – Beds for households with children
PSH_U_HWOA Under Development Permanent Supportive Housing Beds - Year Round Beds - Households with Only Adults
PSH_U_HWOC Under Development Permanent Supportive Housing Beds – Year Round Beds for Households with Only Children
PSH_U_VET Under Development Permanent Supportive Housing beds designated for veterans
PSH_U_CH Under Development Permanent Supportive Housing beds designated for chronically homeless persons
SH_CN_HWOA Safe Haven Beds - Year Round Beds - Households with Only Adults
SH_CN_HWOC Safe Haven Beds – Year Round Beds for Households with Only Children
SH_CN_VET Safe Haven beds designated for veterans
SH_PERS_HWOA Sheltered persons in households with only adults
UNSH_PERS_HWOA Unsheltered persons in households with only adults
SH_PERS_HWOC Sheltered persons in households with only children
UNSH_PERS_HWOC Unsheltered persons in households with only children
SH_PERS_HWAC Sheltered persons in households with adults and children
UNSH_PERS_HWAC Unsheltered persons in households with adults and children
SH_CH Chronically homeless sheltered adults
UNSH_CH Chronically homeless unsheltered adults
SH_UY Sheltered Unaccompanied Youth
UNSH_UY Unsheltered Unaccompanied Youth
SH_VETS Sheltered Veterans
UNSH_VETS Unsheltered Veterans
STATE State
CONTACT_TYPE Contact Type
PREFIX Prefix
FIRST_NAME First Name
LAST_NAME Last Name
SUFFIX Suffix
TITLE Title
PRIMARY_PHONE Primary Phone
PRIMARY_PHONE_EXT Primary Phone Extension
FAX Fax
EMAIL_ADDRESS Email Address
YEAR Program Year
SHAPE_AREA The characteristic appearance or visible form of a geographic object as represented on a map
SHAPE_LEN Area of the shape in meters

Back to top

Challenge Grantees (polygons)

Column Name Column Description
OBJECTID OBJECTID
GRANTNUM Grant Number
LEGALNAME Legal Name
CITY City
STATE State
STATUS Status
TOTALAWARD Total Award
SHAPE SHAPE
SHAPE.AREA SHAPE.AREA
SHAPE.LEN SHAPE.LEN

Back to top

RECAP Tract Current and Historic

Column Name Column Description
OBJECTID OBJECTID
TRACTID Census Tract ID
RCAP_10 Racially/Ethnically Concentrated Area of Poverty 2010
RCAP_00 Racially/Ethnically Concentrated Area of Poverty 2000
RCAP_90 Racially/Ethnically Concentrated Area of Poverty 1990
SHAPE SHAPE
SHAPE.AREA SHAPE.AREA
SHAPE.LEN SHAPE.LEN

Back to top

Labor Market Engagement Index

Column Name Column Description
OBJECTID OBJECTID
BLOCKGROUPID Census Blockgroup ID
LBR_IDX Labor Market Engagement Index Values are percentile ranked and range from 0 to 100. The higher the score, the higher the labor force participation and human capital in a neighborhood.

Back to top

HOME Activity

Column Name Column Description
OBJECTID OBJECTID
ID In IDIS, a uniquely generated value that identifies the record; Numeric version of ID
GRANTEE Name of Grantee
GRANTEE_TYPE Type of Grantee; state grantees (TYPE = 21), entitlement grantees (TYPE = 51, 52, 61), Hawaiian small cities (TYPE = 77) and consortia (TYPE = 90). Entitlement grantees can be categorized as metropolitan cities, central city (TYPE = 51), metropolitan cities, other city (TYPE = 52) and urban counties (TYPE = 61).
GRANTEE_ID Grantee ID associated with CDBG Grantee
IDIS_ACTV_ID IDIS Activity ID representing the individual activity associated with the CDBG Grantee
ADDRESS Street Address
CITY Name of City
STATE State Abbreviation
ZIP ZIP Code
LAT Latitude (Decimal)
LON Longitude (Decimal)
NAME Name
TOTAL_HOME_FUND Total HOME Fund
TOTAL_UNITS Total Units
TOTAL_HOME_UNITS Total HOME Units
COMPLETED_DT Completed Date
ID_CHAR Character Version of ID
ACTV_HOME_GEOMETRY Geometry

Back to top

Back to top