V_QUERY_SPONSORSHIPTRANSACTION
Returns all sponsorship transactions.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| TRANSACTIONSEQUENCE | smallint | Sequence | |
| ACTION | nvarchar(24) | yes | Action |
| REASON | nvarchar(100) | yes | Reason |
| REASONTYPE | nvarchar(32) | yes | Reason type |
| TRANSACTIONDATE | date | yes | Date |
| CONTEXTSPONSORSHIPID | uniqueidentifier | yes | CONTEXTSPONSORSHIPID |
| TARGETSPONSORSHIPID | uniqueidentifier | yes | TARGETSPONSORSHIPID |
| DECLINEDSPONSORSHIPID | uniqueidentifier | yes | DECLINEDSPONSORSHIPID |
| GIFTFINANCIALSPONSORID | uniqueidentifier | yes | GIFTFINANCIALSPONSORID |
| ISLASTTRANSACTION | int | Is last transaction | |
| 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 |
| SPONSORSHIPREASONID | uniqueidentifier | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/28/2016 5:44:50 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.158.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_SPONSORSHIPTRANSACTION AS
select
TRANS.ID,
TRANS.TRANSACTIONSEQUENCE,
TRANS.ACTION,
SPONSORSHIPREASON.REASON,
SPONSORSHIPREASON.REASONTYPE,
TRANS.TRANSACTIONDATE,
TRANS.CONTEXTSPONSORSHIPID,
TRANS.TARGETSPONSORSHIPID,
TRANS.DECLINEDSPONSORSHIPID,
TRANS.GIFTFINANCIALSPONSORID,
case TRANS.TRANSACTIONSEQUENCE
when (select max(LASTTRANS.TRANSACTIONSEQUENCE) from dbo.SPONSORSHIPTRANSACTION LASTTRANS where LASTTRANS.SPONSORSHIPCOMMITMENTID = TRANS.SPONSORSHIPCOMMITMENTID) then 1
else 0
end ISLASTTRANSACTION,
[ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
[ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
[CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
[CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME],
TRANS.DATEADDED,
TRANS.DATECHANGED,
TRANS.TSLONG,
SPONSORSHIPREASON.ID as SPONSORSHIPREASONID
from dbo.SPONSORSHIPTRANSACTION as TRANS
left join dbo.SPONSORSHIPREASON on SPONSORSHIPREASON.ID = TRANS.SPONSORSHIPREASONID
left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = TRANS.ADDEDBYID
left join dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = TRANS.CHANGEDBYID