Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 ADDSOLICITCODE bit   Default = 0 Indicates whether or not to add a solicit code deceased constituents.
 SETEFTSTATUS bit   Default = 0 Indicates whether or not to changes the deceased's EFT status on all financial accounts.
 EFTSTATUSCODE tinyint   Default = 0 Indicates the changed EFT status value.
 EFTSTATUS nvarchar(10) (Computed) CASE [EFTSTATUSCODE] WHEN 0 THEN N'Prenotify' WHEN 1 THEN N'In process' WHEN 2 THEN N'EFT' WHEN 3 THEN N'Inactive' END Provides a translation for the 'EFTSTATUSCODE' field.
 DISABLEWEATHRATINGS bit   Default = 0 Indicates whether or not to disable wealth ratings for deceased prospects.
 DISABLESPOUSERECOGNITIONCREDIT bit   Default = 0 Indicates whether or not to no longer give recognition credit for gifts given by the spouse.
 SETMARITALSTATUS bit   Default = 0 Indicates whether or not to change the spouse's marital status.
 MARKINACTIVE bit   Default = 0 Indicates whether or not to contact deceased constituents.
 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.

Foreign Key Field Type Null Notes Description
 SOLICITCODEID uniqueidentifier SOLICITCODE.ID Solicit code to add
 MARITALSTATUSCODEID uniqueidentifier MARITALSTATUSCODE.LOCALID Change marital status of spouse to.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_DECEASINGRULE_DATEADDED DATEADDED    
 IX_DECEASINGRULE_DATECHANGED DATECHANGED      
 PK_DECEASINGRULE ID  

Trigger Name Description
 TR_DECEASINGRULE_AUDIT_UPDATE
 TR_DECEASINGRULE_AUDIT_DELETE

Entity-Relationship diagram of this table