Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 SPOUSEISCONSTITUENT bit   Default = 1 Determines if a spouse of a constituent is considered a constituent.
 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.
 LOYALDONORCONSTITUENCYDEFPERIOD int   Default = 3 The number of years or months in which a constituent must have given consecutively to have the Loyal donor constituency.
 LOYALDONORCONSTITUENCYDEFPERIODUNITCODE tinyint   Default = 0 The unit of time used to determine Loyal donor constituency 0 - years, or 1 - months.
 LOYALDONORCONSTITUENCYDEFPERIODUNIT nvarchar(6) (Computed) CASE [LOYALDONORCONSTITUENCYDEFPERIODUNITCODE] WHEN 0 THEN N'Years' WHEN 1 THEN N'Months' END Provides a translation for the 'LOYALDONORCONSTITUENCYDEFPERIODUNITCODE' field.
 MAJORDONORCONSTITUENCYDEFLIFETIMEAMOUNT money   Default = 1000 The minimum lifetime giving amount which a constituent must have given to have the Major donor constituency.
 MAJORDONORCONSTITUENCYDEFLARGESTGIFTAMOUNT money   Default = 0 The minimum largest gift amount which a constituent must have given to have the Major donor constituency.
 MAJORDONORCONSTITUENCYDEFCONSIDERRECOGNITION bit   Default = 0 Consider recognition credits when evaluating the Major donor constituency.

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_CONSTITUENCYCRITERIASPOUSE_DATEADDED DATEADDED    
 IX_CONSTITUENCYCRITERIASPOUSE_DATECHANGED DATECHANGED      
 PK_CONSTITUENCYCRITERIASPOUSE ID  

Trigger Name Description
 TR_CONSTITUENCYCRITERIASPOUSE_ONLYONEROW
 TR_CONSTITUENCYCRITERIASPOUSE_AUDIT_UPDATE
 TR_CONSTITUENCYCRITERIASPOUSE_AUDIT_DELETE