• PH_HOUSEHOLD has one row for all constituents that are in a household, and a row for any constituent NOT in a household.
• PH_HOUSEHOLD_RECOGNITIONSPLIT has at least one record for each gift at the household level. Spouses who share soft credits will have one gift in PH_HOUSEHOLD_RECOGNITIONSPLIT.
• PH_CONSTITUENT.HOUSEHOLDDIMID corresponds with PH_HOUSEHOLD.HOUSEHOLDCONSTITUENTDIMID, i.e. these are the two IDs to be used in SQL joins.
• Within a household there is only one primary member and only one secondary member. It is possible to have more than 2 members in a household within CRM, but MGB policy is only two members.