V_QUERY_STEWARDSHIP_PLAN_STEP_UPDATEEXCEPTIONREPORT
View used for output for the Stewardship Plan Step Update batch exception report.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| NAME | nvarchar(154) | yes | Constituent name |
| PLANNAME | nvarchar(100) | Plan name | |
| CATEGORY | nvarchar(100) | yes | Category |
| OBJECTIVE | nvarchar(100) | Objective | |
| STATUS | varchar(9) | yes | Status |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:51:11 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_STEWARDSHIP_PLAN_STEP_UPDATEEXCEPTIONREPORT AS
select
STEWARDSHIPPLANSTEP.[ID],
NF.NAME,
[PLAN].NAME PLANNAME,
STEWARDSHIPSTEPCATEGORYCODE.DESCRIPTION as CATEGORY,
OBJECTIVE,
case
when STATUSCODE = 0 then 'Pending'
when STATUSCODE = 1 then 'Completed'
when STATUSCODE = 2 then 'Canceled'
when STATUSCODE = 3 then 'Declined'
end as STATUS
from
dbo.STEWARDSHIPPLANSTEP
inner join dbo.STEWARDSHIPPLAN [PLAN]
on STEWARDSHIPPLANSTEP.PLANID = [PLAN].ID
left outer join dbo.STEWARDSHIPSTEPCATEGORYCODE
on STEWARDSHIPPLANSTEP.CATEGORYCODEID = STEWARDSHIPSTEPCATEGORYCODE.ID
cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME([PLAN].CONSTITUENTID) NF;