V_QUERY_SPONSORSHIPPROGRAM
This provides the ability to query all sponsorship program fields.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| NAME | nvarchar(100) | Name | |
| SPONSORSHIPOPPORTUNITYGROUPID | uniqueidentifier | SPONSORSHIPOPPORTUNITYGROUPID | |
| AMOUNT | money | Default monthly amount | |
| ISAFFILIATEPROGRAM | int | Affiliate program | |
| AFFILIATEID | uniqueidentifier | yes | AFFILIATEID |
| AFFILIATESPONSORCONSTITUENCY | nvarchar(100) | yes | Affiliate sponsor constituency |
| 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 |
| SPONSORSHIPGREATESTNEEDRULESETID | uniqueidentifier | Greatest need rule set ID | |
| BASECURRENCYID | uniqueidentifier | yes | Base currency |
| SPONSORSHIPGREATESTNEEDRULESETNAME | nvarchar(50) | yes | Greatest need rule set |
| CONSTITUENCYCODEID | uniqueidentifier | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 1/21/2016 5:07:41 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.154.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_SPONSORSHIPPROGRAM AS
select
SPONSORSHIPPROGRAM.ID,
SPONSORSHIPPROGRAM.NAME,
SPONSORSHIPPROGRAM.SPONSORSHIPOPPORTUNITYGROUPID,
SPONSORSHIPPROGRAM.AMOUNT,
case when SPONSORSHIPAFFILIATEPROGRAM.ID is not null then 1 else 0 end ISAFFILIATEPROGRAM,
SPONSORSHIPAFFILIATEPROGRAM.AFFILIATEID,
CONSTITUENCYCODE.DESCRIPTION AFFILIATESPONSORCONSTITUENCY,
[ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
[ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
[CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
[CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME],
SPONSORSHIPPROGRAM.DATEADDED,
SPONSORSHIPPROGRAM.DATECHANGED,
SPONSORSHIPPROGRAM.TSLONG,
SPONSORSHIPPROGRAM.SPONSORSHIPGREATESTNEEDRULESETID,
SPONSORSHIPPROGRAM.BASECURRENCYID,
SPONSORSHIPGREATESTNEEDRULESET.NAME as SPONSORSHIPGREATESTNEEDRULESETNAME,
CONSTITUENCYCODE.ID as CONSTITUENCYCODEID
from dbo.SPONSORSHIPPROGRAM
left join dbo.SPONSORSHIPAFFILIATEPROGRAM on SPONSORSHIPAFFILIATEPROGRAM.ID = SPONSORSHIPPROGRAM.ID
left join dbo.CONSTITUENCYCODE on CONSTITUENCYCODE.ID = SPONSORSHIPAFFILIATEPROGRAM.CONSTITUENCYCODEID
left join dbo.SPONSORSHIPGREATESTNEEDRULESET on SPONSORSHIPPROGRAM.SPONSORSHIPGREATESTNEEDRULESETID = SPONSORSHIPGREATESTNEEDRULESET.ID
left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = SPONSORSHIPPROGRAM.ADDEDBYID
left join dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = SPONSORSHIPPROGRAM.CHANGEDBYID