MATCHINGGIFTPREFERENCEINFO

Stores information pertaining to matching gift preferences.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
AUTOCREATEMGFROMMGRELATIONS	bit		Default = 0	Auto-create matching gift claim from matching gift relationships
AUTOCREATEMGFROMSPOUSEMGRELATIONS	bit		Default = 0	Auto-create matching gift claim from spouse matching gift relationships
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.
ADDRECOGNITIONCREDITSONMGCLAIMADD	bit		Default = 0	If true, add recognition credit for the original donor when a matching gift claim is created.
ADDRECOGNITIONCREDITSONMGPAYMENTAPPLY	bit		Default = 0	If true, add recognition credit for the original donor when a matching gift payment is applied.
MGCLAIMADDRECOGNITIONTYPECODE	tinyint		Default = 0	0=Create recognition credit for donor only, 1=Create recognition credits based on recognition from original revenue
MGCLAIMADDRECOGNITIONTYPE	nvarchar(69) (Computed)	yes	CASE [MGCLAIMADDRECOGNITIONTYPECODE] WHEN 0 THEN N'Create recognition credit for donor only' WHEN 1 THEN N'Create recognition credits based on recognition from original revenue' END	Provides a translation for the 'MGCLAIMADDRECOGNITIONTYPECODE' field.
MGPAYMENTAPPLYRECOGNITIONTYPECODE	tinyint		Default = 0	0=Create recognition credit for donor only, 1=Create recognition credits based on recognition from original revenue
MGPAYMENTAPPLYRECOGNITIONTYPE	nvarchar(69) (Computed)	yes	CASE [MGPAYMENTAPPLYRECOGNITIONTYPECODE] WHEN 0 THEN N'Create recognition credit for donor only' WHEN 1 THEN N'Create recognition credits based on recognition from original revenue' END	Provides a translation for the 'MGPAYMENTAPPLYRECOGNITIONTYPECODE' field.
ADDRECOGNITIONCREDITSTOMATCHINGORGONMGCLAIMADD	bit		Default = 0	If true, add recognition credit for the matching organization when a matching gift claim is created.
ADDRECOGNITIONCREDITSTOMATCHINGORGONMGPAYMENTAPPLY	bit		Default = 0	If true, add recognition credit for the matching organization when a matching gift payment is applied.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
MATCHINGGIFTCONDITIONTYPECODEID	uniqueidentifier	yes	MATCHINGGIFTCONDITIONTYPECODE.ID	FK to MATCHINGGIFTCONDITIONTYPECODE
SPOUSEMATCHINGGIFTCONDITIONTYPECODEID	uniqueidentifier	yes	MATCHINGGIFTCONDITIONTYPECODE.ID	FK to MATCHINGGIFTCONDITIONTYPECODE
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CLAIMREVENUERECOGNITIONTYPECODEID	uniqueidentifier	yes	REVENUERECOGNITIONTYPECODE.ID	FK to REVENUERECOGNITIONTYPECODE
PAYMENTREVENUERECOGNITIONTYPECODEID	uniqueidentifier	yes	REVENUERECOGNITIONTYPECODE.ID	FK to REVENUERECOGNITIONTYPECODE
MATCHINGORGCLAIMREVENUERECOGNITIONTYPECODEID	uniqueidentifier	yes	REVENUERECOGNITIONTYPECODE.ID	FK to REVENUERECOGNITIONTYPECODE
MATCHINGORGPAYMENTREVENUERECOGNITIONTYPECODEID	uniqueidentifier	yes	REVENUERECOGNITIONTYPECODE.ID	FK to REVENUERECOGNITIONTYPECODE

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_MATCHINGGIFTPREFERENCEINFO_DATEADDED	DATEADDED			yes
IX_MATCHINGGIFTPREFERENCEINFO_DATECHANGED	DATECHANGED
PK_MATCHINGGIFTPREFERENCEINFO	ID	yes	yes

Triggers

Trigger Name	Description
TR_MATCHINGGIFTPREFERENCEINFO_AUDIT_UPDATE
TR_MATCHINGGIFTPREFERENCEINFO_AUDIT_DELETE