HHType int NOT NULL, HHChronic int NULL, HHVet int NULL, HHDisability int NULL, HHFleeingDV int NULL, HoHRace int NULL, HoHEthnicity int NULL, HHAdult int NULL, HHChild int NULL, HHNoDOB int NULL, HHAdultAge int NULL, HHParent int NULL, ESTStatus int NULL, RRHStatus int NULL, RRHMoveIn int NULL, PSHStatus int NULL, PSHMoveIn int NULL, ESDays int NULL, THDays int NULL, ESTDays int NULL, ESTGeography int NULL, ESTLivingSit int NULL, ESTDestination int NULL, RRHPreMoveInDays int NULL, RRHPSHPreMoveInDays int NULL, RRHHousedDays int NULL, SystemDaysnotPSHHoused int NULL, RRHGeography int NULL, RRHLivingSit int NULL, RRHDestination int NULL, SystemHomelessDays int NULL, Other3917Days int NULL, TotalHomelessDays int NULL, PSHGeography int NULL, PSHLivingSit int NULL, PSHDestination int NULL, PSHHousedDays int NULL, SystemPath int NULL, ReportID int NULL, FirstEntry date NULL, LastActive date NULL, PRIMARY KEY (HoHID, HHType) ) ; if object_id ('tmp_Person') is not null drop table tmp_Person CREATE TABLE dbo.tmp_Person( PersonalID varchar(32) NOT NULL, HoHAdult int NULL, LastActive date NULL, CHStart date NULL, Age int NULL, Gender int NULL, Race int NULL, Ethnicity int NULL, VetStatus int NULL, DisabilityStatus int NULL, CHTime int NULL,
HHType int NOT NULL, HHChronic int NULL, HHVet int NULL, HHDisability int NULL, HHFleeingDV int NULL, HoHRace int NULL, HoHEthnicity int NULL, HHAdult int NULL, HHChild int NULL, HHNoDOB int NULL, HHAdultAge int NULL, HHParent int NULL, ESTStatus int NULL, RRHStatus int NULL, RRHMoveIn int NULL, PSHStatus int NULL, PSHMoveIn int NULL, ESDays int NULL, THDays int NULL, ESTDays int NULL, ESTGeography int NULL, ESTLivingSit int NULL, ESTDestination int NULL, RRHPreMoveInDays int NULL, RRHPSHPreMoveInDays int NULL, RRHHousedDays int NULL, SystemDaysnotPSHHoused int NULL, RRHGeography int NULL, RRHLivingSit int NULL, RRHDestination int NULL, SystemHomelessDays int NULL, Other3917Days int NULL, TotalHomelessDays int NULL, PSHGeography int NULL, PSHLivingSit int NULL, PSHDestination int NULL, PSHHousedDays int NULL, SystemPath int NULL, ReportID int NULL, FirstEntry date NULL, LastActive date NULL, PRIMARY KEY (HoHID, HHType) ) ; if object_id ('tmp_Person') is not null drop table tmp_Person CREATE TABLE dbo.tmp_Person( PersonalID varchar(32) NOT NULL, HoHAdult int NULL, LastActive date NULL, CHStart date NULL, Age int NULL, Gender int NULL, Race int NULL, Ethnicity int NULL, VetStatus int NULL, DisabilityStatus int NULL, CHTime int NULL,