Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 ADDRESSSTANDARDIZATIONENABLED bit   Default = 0
 FIELDCAPITALIZATIONENABLED bit   Default = 0
 DATEADDED datetime   Default = getdate()
 DATECHANGED datetime   Default = getdate()
 TS timestamp  
 TSLONG bigint (Computed) CONVERT(bigint, TS)
 DIFFERENTPHONECODE tinyint   Default = 3
 NEWPHONEENDDATECODE tinyint   Default = 0
 NEWPHONEPRIMARYCODE tinyint   Default = 1
 DIFFERENTEMAILCODE tinyint   Default = 3
 NEWEMAILENDDATECODE tinyint   Default = 0
 NEWEMAILPRIMARYCODE tinyint   Default = 1
 DIFFERENTEMAIL nvarchar(42) (Computed) CASE [DIFFERENTEMAILCODE] WHEN 0 THEN N'Ignore email address' WHEN 2 THEN N'Require manual review (generate exception)' WHEN 3 THEN N'Add as new email address' END
 CREATEHISTORICALNAMECODE tinyint   Default = 1
 CREATEHISTORICALNAME nvarchar(3) (Computed) CASE [CREATEHISTORICALNAMECODE] WHEN 0 THEN N'No' WHEN 1 THEN N'Yes' END
 NAMECODE tinyint   Default = 1
 SIMILARADDRESSCODE tinyint   Default = 3
 UNSIMILARADDRESSCODE tinyint   Default = 3
 UNSIMILARADDRESS nvarchar(42) (Computed) CASE [UNSIMILARADDRESSCODE] WHEN 0 THEN N'Ignore address' WHEN 2 THEN N'Require manual review (generate exception)' WHEN 3 THEN N'Add as new address' END
 NEWADDRESSENDDATECODE tinyint   Default = 0
 NEWADDRESSPRIMARYCODE tinyint   Default = 1
 BIRTHDATERULECODE tinyint   Default = 1
 NAME nvarchar(42) (Computed) CASE [NAMECODE] WHEN 0 THEN N'Ignore name' WHEN 1 THEN N'Update name' WHEN 2 THEN N'Require manual review (generate exception)' WHEN 3 THEN N'Add name as an alias' END
 SIMILARADDRESS nvarchar(63) (Computed) CASE [SIMILARADDRESSCODE] WHEN 0 THEN N'Ignore address' WHEN 1 THEN N'Update existing address (old address data will not be retained)' WHEN 2 THEN N'Require manual review (generate exception)' WHEN 3 THEN N'Add as new address' END
 NEWADDRESSENDDATE nvarchar(30) (Computed) CASE [NEWADDRESSENDDATECODE] WHEN 0 THEN N'Make existing address inactive' WHEN 1 THEN N'Keep existing address active' END
 NEWADDRESSPRIMARY nvarchar(61) (Computed) CASE [NEWADDRESSPRIMARYCODE] WHEN 0 THEN N'Never' WHEN 1 THEN N'Only if the current primary address has the same address type' WHEN 2 THEN N'Always' END
 DIFFERENTPHONE nvarchar(42) (Computed) CASE [DIFFERENTPHONECODE] WHEN 0 THEN N'Ignore phone' WHEN 2 THEN N'Require manual review (generate exception)' WHEN 3 THEN N'Add as new phone' END
 NEWPHONEENDDATE nvarchar(28) (Computed) CASE [NEWPHONEENDDATECODE] WHEN 0 THEN N'Make existing phone inactive' WHEN 1 THEN N'Keep existing phone active' END
 NEWPHONEPRIMARY nvarchar(57) (Computed) CASE [NEWPHONEPRIMARYCODE] WHEN 0 THEN N'Never' WHEN 1 THEN N'Only if the current primary phone has the same phone type' WHEN 2 THEN N'Always' END
 NEWEMAILENDDATE nvarchar(36) (Computed) CASE [NEWEMAILENDDATECODE] WHEN 0 THEN N'Make existing email address inactive' WHEN 1 THEN N'Keep existing email address active' END
 NEWEMAILPRIMARY nvarchar(65) (Computed) CASE [NEWEMAILPRIMARYCODE] WHEN 0 THEN N'Never' WHEN 1 THEN N'Only if the current primary email address has the same email type' WHEN 2 THEN N'Always' END
 BIRTHDATERULE nvarchar(17) (Computed) CASE [BIRTHDATERULECODE] WHEN 0 THEN N'Ignore birth date' WHEN 1 THEN N'Update birth date' END

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

Index Name Field(s) Unique Primary Clustered
 IX_CONSTITUENTBUSINESSRULESSETTINGS_DATEADDED DATEADDED    
 IX_CONSTITUENTBUSINESSRULESSETTINGS_DATECHANGED DATECHANGED      
 PK_CONSTITUENTBUSINESSRULESSETTINGS ID  

Trigger Name Description
 TR_CONSTITUENTBUSINESSRULESSETTINGS_ENSUREONEROW_DELETE
 TR_CONSTITUENTBUSINESSRULESSETTINGS_ENSUREONEROW_INSERT
 TR_CONSTITUENTBUSINESSRULESSETTINGS_AUDIT_UPDATE
 TR_CONSTITUENTBUSINESSRULESSETTINGS_AUDIT_DELETE