This table contains an organization's conditions for matching gifts.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
MATCHINGFACTOR
|
decimal(5, 2)
|
false
|
|
Stores the ratio at which the organization commonly matches gifts for the relationship type.
|
|
MAXMATCHANNUAL
|
money
|
false
|
|
Stores the maximum annual matching gift contribution per donor for the relationship type.
|
|
MAXMATCHPERGIFT
|
money
|
false
|
|
Stores the maximum matching gift contribution per gift for the relationship type.
|
|
MAXMATCHTOTAL
|
money
|
false
|
|
Stores the maximum total matching gift contribution per donor for the relationship type.
|
|
MINMATCHPERGIFT
|
money
|
false
|
|
Stores the minimum matching gift contribution per gift for the relationship type.
|
|
NOTES
|
nvarchar(max)
|
false
|
|
Stores notes regarding the matching gift condition.
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
MATCHTYPECODE
|
tinyint
|
false
|
|
Specifies how the organization calculates its match amount.
|
|
MATCHTYPE
|
nvarchar(27) (Computed)
|
true
|
|
Provides a translation for the 'MATCHTYPECODE' field.
|
|
REVENUETYPECODE
|
tinyint
|
false
|
|
Revenue split type.
|
|
REVENUETYPE
|
nvarchar(11) (Computed)
|
true
|
|
Provides a translation for the 'REVENUETYPECODE' field.
|
|
SEQUENCE
|
int
|
false
|
|
Specifies the order in which to use conditions in the case of multiple matches.
|
|
ORGANIZATIONMAXMATCHANNUAL
|
money
|
false
|
|
Stores the maximum annual matching gift contribution per donor for the relationship type in organization currency.
|
|
ORGANIZATIONMAXMATCHPERGIFT
|
money
|
false
|
|
Stores the maximum matching gift contribution per gift for the relationship type in organization currency.
|
|
ORGANIZATIONMAXMATCHTOTAL
|
money
|
false
|
|
Stores the maximum total matching gift contribution per donor for the relationship type in organization currency.
|
|
ORGANIZATIONMINMATCHPERGIFT
|
money
|
false
|
|
Stores the minimum matching gift contribution per gift for the relationship type in organization currency.
|
