V_QUERY_MATCHINGGIFTCONDITION
Provides the ability to query a constituent's matching gift conditions.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| ORGANIZATIONID | uniqueidentifier | Organization ID | |
| MGC_TYPE | nvarchar(100) | yes | Matching gift condition type |
| MATCHINGFACTOR | decimal(5, 2) | Matching factor | |
| MAXMATCHANNUAL | money | Max matching per year | |
| MAXMATCHPERGIFT | money | Max match per gift | |
| MINMATCHPERGIFT | money | Min match per gift | |
| MAXMATCHTOTAL | money | Max match total | |
| NOTES | nvarchar(max) | Notes | |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | Added by application |
| ADDEDBY_USERNAME | nvarchar(128) | yes | Added by user name |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | Changed by application |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | Changed by user name |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
| MATCHTYPE | nvarchar(27) | yes | Matching amount |
| REVENUETYPE | nvarchar(11) | yes | Revenue type |
| SEQUENCE | int | Sequence | |
| BASECURRENCYID | uniqueidentifier | yes | Base currency ID |
| ORGANIZATIONMAXMATCHANNUAL | money | Organization max matching per year | |
| ORGANIZATIONMAXMATCHPERGIFT | money | Organization max match per gift | |
| ORGANIZATIONMINMATCHPERGIFT | money | Organization min match per gift | |
| ORGANIZATIONMAXMATCHTOTAL | money | Organization max match total | |
| ORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes | Organization exchange rate |
| MATCHINGGIFTCONDITIONTYPECODEID | uniqueidentifier |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/30/2015 1:01:47 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_MATCHINGGIFTCONDITION AS
select
MATCHINGGIFTCONDITION.ID,
MATCHINGGIFTCONDITION.ORGANIZATIONID,
dbo.UFN_MATCHINGGIFTCONDITIONTYPECODE_GETDESCRIPTION(MATCHINGGIFTCONDITION.MATCHINGGIFTCONDITIONTYPECODEID) MGC_TYPE,
MATCHINGGIFTCONDITION.MATCHINGFACTOR,
MATCHINGGIFTCONDITION.MAXMATCHANNUAL,
MATCHINGGIFTCONDITION.MAXMATCHPERGIFT,
MATCHINGGIFTCONDITION.MINMATCHPERGIFT,
MATCHINGGIFTCONDITION.MAXMATCHTOTAL,
MATCHINGGIFTCONDITION.NOTES,
[ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
[ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
[CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
[CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME],
MATCHINGGIFTCONDITION.DATEADDED,
MATCHINGGIFTCONDITION.DATECHANGED,
MATCHINGGIFTCONDITION.TSLONG,
MATCHINGGIFTCONDITION.MATCHTYPE,
MATCHINGGIFTCONDITION.REVENUETYPE,
MATCHINGGIFTCONDITION.SEQUENCE,
MATCHINGGIFTCONDITION.BASECURRENCYID,
MATCHINGGIFTCONDITION.ORGANIZATIONMAXMATCHANNUAL,
MATCHINGGIFTCONDITION.ORGANIZATIONMAXMATCHPERGIFT,
MATCHINGGIFTCONDITION.ORGANIZATIONMINMATCHPERGIFT,
MATCHINGGIFTCONDITION.ORGANIZATIONMAXMATCHTOTAL,
MATCHINGGIFTCONDITION.ORGANIZATIONEXCHANGERATEID,
[MATCHINGGIFTCONDITION].[MATCHINGGIFTCONDITIONTYPECODEID]
/*#EXTENSION*/
from dbo.MATCHINGGIFTCONDITION
left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = MATCHINGGIFTCONDITION.ADDEDBYID
left join dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = MATCHINGGIFTCONDITION.CHANGEDBYID