Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 HOUSEHOLDRECOGNIZEHOUSEHOLD bit   Default = 0 Indicates if a household will receive recognition credit for their own revenue.
 HOUSEHOLDRECOGNIZEMEMBERS bit   Default = 0 Indicates if a household's members will receive recognition credit for the household's revenue.
 MEMBERRECOGNIZEHOUSEHOLD bit   Default = 1 Indicates if a household will receive recognition credit for their member's revenue.
 MEMBERRECOGNIZEMEMBER bit   Default = 1 Indicates if a household member will receive recognition credit for their revenue.
 MEMBERRECOGNIZEOTHERMEMBERS bit   Default = 0 Indicates if a household member will receive recognition credit for a different household member's revenue.
 HOUSEHOLDSCANBEDONORS bit   Default = 1 Indicates whether revenue can belong to a household.

Foreign Key Field Type Null Notes Description
 NAMEFORMATFUNCTIONID uniqueidentifier   NAMEFORMATFUNCTION.ID The name format function which will be used to generate default household names in the system.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 HOUSEHOLDREVENUERECOGNITIONTYPECODEID uniqueidentifier REVENUERECOGNITIONTYPECODE.ID The ID of the recognition type for revenue from households to members
 MEMBERREVENUERECOGNITIONTYPECODEID uniqueidentifier REVENUERECOGNITIONTYPECODE.ID The ID of the recognition type for revenue from members to memebers
 MEMBERHOUSEHOLDREVENUERECOGNITIONTYPECODEID uniqueidentifier REVENUERECOGNITIONTYPECODE.ID The ID of the recognition type for revenue from members to the household

Index Name Field(s) Unique Primary Clustered
 IX_HOUSEHOLDINFO_DATEADDED DATEADDED    
 IX_HOUSEHOLDINFO_DATECHANGED DATECHANGED      
 PK_HOUSEHOLDINFO ID  

Trigger Name Description
 TR_HOUSEHOLDINFO_AUDIT_UPDATE
 TR_HOUSEHOLDINFO_AUDIT_DELETE
 TR_HOUSEHOLDINFO_ENSUREONEROW_DELETE
 TR_HOUSEHOLDINFO_ENSUREONEROW_INSERT

Entity-Relationship diagram of this table