V_QUERY_RE7_SOLICITORGOAL
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| APPEAL_LOCALID | int | yes | |
| CAMPAIGN_LOCALID | int | yes | |
| CATEGORY | nvarchar(100) | yes | |
| FUND_LOCALID | int | yes | |
| GOAL | numeric(30, 6) | yes | |
| LOCALID | int | ||
| CONSTITUENT_LOCALID | int | ||
| REPORTSTOCONSTITUENT_LOCALID | int | yes | |
| TEAMCAPTAIN | bit | ||
| TEAM_LOCALID | int | yes | |
| TYPE | varchar(11) | yes | |
| ISACTIVE | bit |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 2/6/2025 8:50:37 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3901.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RE7_SOLICITORGOAL AS
select
[SG].[APPEAL_LOCALID],
[SG].[CAMPAIGN_LOCALID],
[CC].[DESCRIPTION] [CATEGORY],
[SG].[FUND_LOCALID],
[SG].[GOAL],
[SG].[LOCALID],
[SG].[CONSTITUENT_LOCALID],
[SG].[REPORTSTOCONSTITUENT_LOCALID],
[SG].[TEAMCAPTAIN],
[SG].[TEAM_LOCALID],
case [SG].[TYPECODE_LOCALID] when 1 then 'Campaign' when 2 then 'Fund' when 3 then 'Unspecified' when 4 then 'Appeal' end [TYPE],
[SG].[ISACTIVE]
from [dbo].[RE7_SOLICITORGOAL] [SG]
left outer join dbo.[RE7_SOLICITORGOALCATEGORYCODE] [CC] on [SG].[CATEGORYCODE_LOCALID] = [CC].[LOCALID];