Sanpshot Data - SAC - HUD | HUD.gov / U.S. Department of Housing and Urban Development (HUD)

Required Conversion - Sanpshot Data Explained

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.

Related Information

	Required Conversion
	SAC Homepage