Difference between SAHHAddress and SAHouseholdAddress Tables in RecTrac 3.1
Problem
What's the difference between the SAHHAddress table and the SAHouseholdAddress table in RecTrac 3.1?
Solution
SAHHAddress is the table used to store addresses for a household in the standard fill-in method of Household Creation.
When a city imports all known addresses into the database for selection when creating a new household), those addresses are stored in the SAAddress table. If this method of household creation is used, then the SAHouseholdAddress table is used for storing the link between the SAHousehold record and the SAAddress record(s) for that household.