Primary Key Field Type
 ID uniqueidentifier

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) 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) 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) 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
 ADDRECOGNITIONCREDITSTOMATCHINGORGONMGPAYMENTAPPLY bit   Default = 0

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

Index Name Field(s) Unique Primary Clustered
 IX_MATCHINGGIFTPREFERENCEINFO_DATEADDED DATEADDED    
 IX_MATCHINGGIFTPREFERENCEINFO_DATECHANGED DATECHANGED      
 PK_MATCHINGGIFTPREFERENCEINFO ID  

Trigger Name Description
 TR_MATCHINGGIFTPREFERENCEINFO_AUDIT_UPDATE
 TR_MATCHINGGIFTPREFERENCEINFO_AUDIT_DELETE

Entity-Relationship diagram of this table