V_QUERY_STEWARDSHIPPLANSTEPS
Provides the ability to query stewardship plan steps.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| PLANID | uniqueidentifier | Plan ID | |
| CATEGORY | nvarchar(100) | yes | Category |
| OBJECTIVE | nvarchar(100) | Objective | |
| TARGETDATE | datetime | Target date | |
| DATELOCKED | bit | Date locked | |
| ACTUALDATE | datetime | yes | Actual date |
| CONTACTPERSONID | uniqueidentifier | yes | Contact person |
| CONTACTMETHOD | nvarchar(100) | yes | Contact method |
| CONSTITUENTID | uniqueidentifier | yes | Assigned to |
| TEMPLATE | nvarchar(100) | Template | |
| RECURS | nvarchar(17) | yes | Frequency |
| STARTDATE | datetime | yes | Start date |
| ENDDATE | datetime | yes | End date |
| STATUS | nvarchar(9) | yes | Status |
| BENEFITID | uniqueidentifier | yes | Benefit |
| EVENTID | uniqueidentifier | yes | Event |
| MAILINGID | uniqueidentifier | yes | Mailing |
| 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 |
| COMPLETED | int | Completed | |
| TARGETSTARTTIME | UDT_HOURMINUTE | Target start time | |
| TARGETENDTIME | UDT_HOURMINUTE | Target end time | |
| TIMEZONE_TRANSLATION | nvarchar(200) | yes | Time zone |
| ACTUALSTARTTIME | UDT_HOURMINUTE | Actual start time | |
| ACTUALENDTIME | UDT_HOURMINUTE | Actual end time |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 10/27/2018 10:42:49 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.186.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_STEWARDSHIPPLANSTEPS AS
select
STEP.ID,
STEP.PLANID,
CATEGORYCODE.DESCRIPTION as CATEGORY,
STEP.OBJECTIVE,
STEP.TARGETDATE,
STEP.DATELOCKED,
STEP.ACTUALDATE,
STEP.CONTACTPERSONID,
CONTACTMETHODCODE.DESCRIPTION as CONTACTMETHOD,
STEP.CONSTITUENTID,
STEP.TEMPLATE,
STEP.RECURS,
STEP.STARTDATE,
STEP.ENDDATE,
STEP.STATUS,
STEP.BENEFITID,
STEP.EVENTID,
STEP.MAILINGID,
STEP.DATEADDED,
STEP.DATECHANGED,
STEP.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
STEP.COMPLETED,
STEP.TARGETSTARTTIME,
STEP.TARGETENDTIME,
TIMEZONEENTRY.DISPLAYNAME as TIMEZONE_TRANSLATION,
STEP.ACTUALSTARTTIME,
STEP.ACTUALENDTIME
/*#EXTENSION*/
from
dbo.STEWARDSHIPPLANSTEP STEP
left outer join dbo.STEWARDSHIPSTEPCATEGORYCODE CATEGORYCODE
on STEP.CATEGORYCODEID = CATEGORYCODE.ID
left outer join dbo.INTERACTIONTYPECODE CONTACTMETHODCODE
on STEP.CONTACTMETHODCODEID = CONTACTMETHODCODE.ID
left outer join dbo.CHANGEAGENT ADDEDBY
on STEP.ADDEDBYID = ADDEDBY.ID
left outer join dbo.CHANGEAGENT CHANGEDBY
on STEP.CHANGEDBYID = CHANGEDBY.ID
left outer join dbo.TIMEZONEENTRY
on STEP.TIMEZONEENTRYID = TIMEZONEENTRY.ID;