DECEASINGOPTION

Contains system deceasing options.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

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)	yes	CONVERT(bigint, TS)	Numeric representation of the timestamp.

Foreign Keys

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

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_DECEASINGOPTION_DATEADDED	DATEADDED			yes
IX_DECEASINGOPTION_DATECHANGED	DATECHANGED
PK_DECEASINGOPTION	ID	yes	yes

Triggers

Trigger Name	Description
TR_DECEASINGOPTION_AUDIT_UPDATE
TR_DECEASINGOPTION_AUDIT_DELETE