Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 MATCHINGFACTOR decimal(5, 2)   Default = 0 Stores the ratio at which the organization commonly matches gifts for the relationship type.
 MAXMATCHANNUAL money   Default = 0 Stores the maximum annual matching gift contribution per donor for the relationship type.
 MAXMATCHPERGIFT money   Default = 0 Stores the maximum matching gift contribution per gift for the relationship type.
 MAXMATCHTOTAL money   Default = 0 Stores the maximum total matching gift contribution per donor for the relationship type.
 MINMATCHPERGIFT money   Default = 0 Stores the minimum matching gift contribution per gift for the relationship type.
 NOTES nvarchar(max)   Default = '' Stores notes regarding the matching gift condition.
 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.
 MATCHTYPECODE tinyint   Default = 0 Specifies how the organization calculates its match amount.
 MATCHTYPE nvarchar(27) (Computed) CASE [MATCHTYPECODE] WHEN 0 THEN N'Full gift amount' WHEN 1 THEN N'Tax deductible portion only' END Provides a translation for the 'MATCHTYPECODE' field.
 REVENUETYPECODE tinyint   Default = 0 Revenue split type.
 REVENUETYPE nvarchar(11) (Computed) CASE [REVENUETYPECODE] WHEN 0 THEN N'Gift' WHEN 9 THEN N'Sponsorship' END Provides a translation for the 'REVENUETYPECODE' field.
 SEQUENCE int   Default = 0 Specifies the order in which to use conditions in the case of multiple matches.
 ORGANIZATIONMAXMATCHANNUAL money   Default = 0 Stores the maximum annual matching gift contribution per donor for the relationship type in organization currency.
 ORGANIZATIONMAXMATCHPERGIFT money   Default = 0 Stores the maximum matching gift contribution per gift for the relationship type in organization currency.
 ORGANIZATIONMAXMATCHTOTAL money   Default = 0 Stores the maximum total matching gift contribution per donor for the relationship type in organization currency.
 ORGANIZATIONMINMATCHPERGIFT money   Default = 0 Stores the minimum matching gift contribution per gift for the relationship type in organization currency.

Foreign Key Field Type Null Notes Description
 ORGANIZATIONID uniqueidentifier   CONSTITUENT.LOCALID FK to CONSTITUENT
 MATCHINGGIFTCONDITIONTYPECODEID uniqueidentifier   MATCHINGGIFTCONDITIONTYPECODE.ID FK to MATCHINGGIFTCONDITIONTYPECODE
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this revenue.
 ORGANIZATIONEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert to organization amount.

Index Name Field(s) Unique Primary Clustered
 IX_MATCHINGGIFTCONDITION_DATEADDED DATEADDED    
 IX_MATCHINGGIFTCONDITION_DATECHANGED DATECHANGED      
 PK_MATCHINGGIFTCONDITION ID  
 UIX_MATCHINGGIFTCONDITION_ORGANIZATIONID_MATCHINGGIFTCONDITIONTYPECODEID ORGANIZATIONID, MATCHINGGIFTCONDITIONTYPECODEID    

Trigger Name Description
 TR_MATCHINGGIFTCONDITION_MARKORGANIZATIONASCONSTITUENT
 TR_MATCHINGGIFTCONDITION_AUDIT_UPDATE
 TR_MATCHINGGIFTCONDITION_AUDIT_DELETE
 TR_MATCHINGGIFTCONDITION_INSERTUPDATE_CURRENCY

Referenced by Field
 BATCHREVENUE MGCONDITIONID
 BATCHREVENUEENHANCEDMATCHINGGIFTS MATCHINGGIFTCONDITIONID
 MATCHINGGIFTCONDITIONRELATIONSHIP MATCHINGGIFTCONDITIONID
 REVENUEMATCHINGGIFT MATCHINGGIFTCONDITIONID

Entity-Relationship diagram of this table