Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 UPDATECONSTITUENCIES bit   Default = 0 Indicates whether or not to update deceased's constituencies.
 UPDATERELATIONSHIPS bit   Default = 0 Indicates whether or not to update deceased's relationships.
 ADDDOCUMENTATION bit   Default = 0 Indicates whether or not to add documentation to deceased.
 UPDATECONSTITUENTINTERACTIONS bit   Default = 0 Indicates whether or not to update deceased's planned and pending interactions.
 UPDATECONSTITUENTNAMEFORMATS bit   Default = 0 Indicates whether or not to update deceased's name formats.
 ADDTRIBUTE bit   Default = 0 Indicates whether or not to add a tribute of the deceased constituent.
 UPDATEHOUSEHOLDMEMBERS bit   Default = 0 Indicates whether or not to update deceased's household members.
 UPDATEHOUSEHOLDINTERACTIONS bit   Default = 0 Indicates whether or not to update deceased's household planned and pending interactions.
 UPDATEHOUSEHOLDNAMEFORMATS bit   Default = 0 Indicates whether or not to update deceased's household name formats.
 SHOWGROUPS bit   Default = 0 Indicates whether or not to show groups associated with deceased.
 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
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_DECEASINGOPTION_DATEADDED DATEADDED    
 IX_DECEASINGOPTION_DATECHANGED DATECHANGED      
 PK_DECEASINGOPTION ID  

Trigger Name Description
 TR_DECEASINGOPTION_AUDIT_UPDATE
 TR_DECEASINGOPTION_AUDIT_DELETE