V_QUERY_STEWARDSHIPPLAN
Provides the ability to query stewardship plans.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| MANAGERID | uniqueidentifier | yes | Manager ID |
| NARRATIVE | nvarchar(1000) | Narrative | |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
| 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 |
| CONSTITUENTID | uniqueidentifier | Constituent ID | |
| NAME | nvarchar(100) | Name | |
| BASECURRENCYID | uniqueidentifier | yes | BASECURRENCYID |
| STARTDATE | datetime | yes | Start date |
| PLANTYPE | nvarchar(100) | yes | Plan type |
| PLANSUBTYPE | nvarchar(100) | yes | Plan subtype |
| ISACTIVE | int |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 5/3/2024 2:17:33 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3700.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_STEWARDSHIPPLAN AS
select
STEWARDSHIPPLAN.ID,
STEWARDSHIPPLAN.MANAGERID,
STEWARDSHIPPLAN.NARRATIVE,
STEWARDSHIPPLAN.DATEADDED,
STEWARDSHIPPLAN.DATECHANGED,
STEWARDSHIPPLAN.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
STEWARDSHIPPLAN.CONSTITUENTID,
STEWARDSHIPPLAN.NAME,
STEWARDSHIPPLAN.BASECURRENCYID,
STEWARDSHIPPLAN.STARTDATE,
STEWARDSHIPPLANTYPECODE.DESCRIPTION as PLANTYPE,
STEWARDSHIPPLANSUBTYPECODE.DESCRIPTION as PLANSUBTYPE,
CASE WHEN STEWARDSHIPPLAN.ISACTIVE=1 THEN 0 ELSE 1 END AS ISACTIVE
/*#EXTENSION*/
from
dbo.STEWARDSHIPPLAN
left join
dbo.STEWARDSHIPPLANTYPECODE on STEWARDSHIPPLAN.PLANTYPECODEID = STEWARDSHIPPLANTYPECODE.ID
left join
dbo.STEWARDSHIPPLANSUBTYPECODE on STEWARDSHIPPLAN.PLANSUBTYPECODEID = STEWARDSHIPPLANSUBTYPECODE.ID
left join
dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = STEWARDSHIPPLAN.ADDEDBYID
left join
dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = STEWARDSHIPPLAN.CHANGEDBYID;