V_QUERY_SPONSORSHIPGREATESTNEEDPROJECT
Returns the subset of fields on a project used for determining greatest need.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ID | |
| SPONSORSHIPOPPORTUNITYGROUPID | uniqueidentifier | SPONSORSHIPOPPORTUNITYGROUPID | |
| SPONSORSHIPLOCATIONID | uniqueidentifier | Location | |
| SPROPPPROJECTCATEGORYCODEID | uniqueidentifier | yes | Category |
| NUMBERACTIVESPONSORS | int | yes | Active sponsor count |
| DATEADDED | datetime | Date added | |
| LASTDOCUMENTATIONDATE | date | yes | Last documentation date |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 4/13/2016 4:58:48 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.158.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_SPONSORSHIPGREATESTNEEDPROJECT AS
select
SPONSORSHIPOPPORTUNITY.ID,
SPONSORSHIPOPPORTUNITY.SPONSORSHIPOPPORTUNITYGROUPID,
SPONSORSHIPOPPORTUNITY.SPONSORSHIPLOCATIONID,
SPONSORSHIPOPPORTUNITYPROJECT.SPROPPPROJECTCATEGORYCODEID,
(
select count(1)
from dbo.SPONSORSHIP
where
SPONSORSHIPOPPORTUNITYID = SPONSORSHIPOPPORTUNITY.ID
and STATUSCODE = 1
) as NUMBERACTIVESPONSORS,
SPONSORSHIPOPPORTUNITY.DATEADDED,
SPONSORSHIPOPPORTUNITY.LASTDOCUMENTATIONDATE
from dbo.SPONSORSHIPOPPORTUNITY
inner join dbo.SPONSORSHIPOPPORTUNITYLOCK on SPONSORSHIPOPPORTUNITYLOCK.ID = SPONSORSHIPOPPORTUNITY.ID
inner join dbo.SPONSORSHIPOPPORTUNITYPROJECT on SPONSORSHIPOPPORTUNITYPROJECT.ID = SPONSORSHIPOPPORTUNITY.ID
left outer join dbo.SPONSORSHIPLOCATION on SPONSORSHIPLOCATION.ID = SPONSORSHIPOPPORTUNITY.SPONSORSHIPLOCATIONID
where
SPONSORSHIPOPPORTUNITY.ELIGIBILITYCODE = 1
and SPONSORSHIPOPPORTUNITY.AVAILABILITYCODE = 0
and SPONSORSHIPOPPORTUNITYLOCK.LOCKED = 0