V_QUERY_SPONSORSHIPOPPORTUNITYGREATESTNEED
Returns all valid sponsorship opportunity/program combinations and the opportunity's greatest need for the program.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | yes | System record ID |
| SPONSORSHIPPROGRAMID | uniqueidentifier | yes | Program ID |
| PROGRAM | varchar(1) | Program | |
| GNORDER | int | Greatest need ranking |
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_SPONSORSHIPOPPORTUNITYGREATESTNEED AS
select
newid() ID,
newid() SPONSORSHIPPROGRAMID,
'' PROGRAM,
0 GNORDER