	Public and Indian Housing
	About PIH
	Special Applications Center
		Demolition/ disposition
		Designated housing
		Eminent domain
		Homeownership
		Section 202 conversion
		Conversion
		Works in progress
		About the SAC
	HUD news
	Homes
	Resources
	Communities
	Working with HUD
	Tools
	Webcasts
	Mailing lists
	RSS Feeds
	Help

Required Conversion - Sanpshot Data Explained


	Information by State Print version

Related Information

Required Conversion

SAC Homepage

The snapshot data is captured by a job run on the first day of the month. This data resides on: HDRFNDD00(server).extract(database).dbo.P113PT_PH_UNIT_HISTORY(table)

The data all comes from the PIC database. Here are the tables and the fields in each table that is collected:

Table Name: P113PT_PH_UNIT
Fields: development_number
building_number
building_number_entrance
unit_number
bedroom_count
unit_type_code
unit_status_type_code
acc_unit_ind
initial_approved_ind
capfund_ind
unit_tenant_status_code
exception_reason_code
last_update_timestamp (renamed unit_update_date)

Table Name: P113PT_DEVELOPMENT_BUILDING_ENTRANCE
Fields: amp_group_number
building_status_type_code
unit_count
last_update_timestamp (renamed bldg_update_date)

Table Name: P113PT_PHYSICAL_DEVELOPMENT
Fields: participant_code
pd_program_type_code
pd_structure_type_code
pd_status_type_code
last_update_timestamp (renamed devel_update_date)

Each record is appended with the date when the snapshot was taken.

	FOIA	Privacy	Web Policies and Important Links	Home
	U.S. Department of Housing and Urban Development 451 7th Street S.W., Washington, DC 20410 Telephone: (202) 708-1112 TTY: (202) 708-1455 Find the address of a HUD office near you