HUD Federal Housing Authority (FHA) Integrated Data Base (IDB)

The IDB datamart contains the current status of every single family loan insured by FHA since the inception of the program. The IDB datamart is a living or operational datamart in the sense that its tables are updated as new loans are insured or existing loans undergo a change in their insurance information. However, no loan records are ever removed from the tables within the IDB datamart.

The purpose for transferring of IDB datamart data to Census is to merge with housing surveys, thereby allowing the identification of households in housing surveys who have FHA mortgage insurance. Not all of these records are pertinent to HUD and Census's planned data matching activities. Specifically, HUD and Census are interested in matching records in the IDB datamart to the American Housing Survey (AHS) and the American Community Survey (ACS) for years 2010 and later. As such, HUD is supplying an extract of the full IDB datamart where the extract includes only: records that are currently active (an active insurance policy), or; records that are not currently active (terminated, claim, or other), but were active at any point after January 1, 2010.