V_QUERY_PROSPECTPLANREQUEST
Queries prospect plan requests
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| STATUS | nvarchar(8) | yes | Status |
| NAME | nvarchar(100) | Requested plan name | |
| NARRATIVE | nvarchar(1000) | Requested plan narrative | |
| PROSPECTPLANTYPECODE | nvarchar(100) | yes | Type |
| PRIMARYMANAGERFUNDRAISERID | uniqueidentifier | yes | Requested primary manager ID |
| REQUESTEDPRIMARYMANAGER | nvarchar(154) | yes | Requested primary manager |
| SECONDARYMANAGERFUNDRAISERID | uniqueidentifier | yes | Requested secondary manager ID |
| REQUESTEDSECONDARYMANAGER | nvarchar(154) | yes | Requested secondary manager |
| PRIMARYMANAGERSTARTDATE | datetime | yes | Requested primary manager start date |
| SECONDARYMANAGERSTARTDATE | datetime | yes | Requested secondary manager start date |
| REVIEWDATE | datetime | yes | Review date |
| REVIEWEDBYNAME | nvarchar(128) | yes | Reviewed by name |
| REVIEWEDBYID | uniqueidentifier | yes | Reviewed by system ID |
| SUBMITTEDBYNAME | nvarchar(128) | yes | Submitted by name |
| SUBMITTEDBYID | uniqueidentifier | Submitted by system ID | |
| REQUESTEDPROSPECTID | uniqueidentifier | REQUESTEDPROSPECTID | |
| 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 |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:35:24 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_PROSPECTPLANREQUEST AS
select
PROSPECTPLANREQUEST.ID,
PROSPECTPLANREQUEST.STATUS,
PROSPECTPLANREQUEST.NAME,
PROSPECTPLANREQUEST.NARRATIVE,
PROSPECTPLANTYPECODE.DESCRIPTION PROSPECTPLANTYPECODE,
PROSPECTPLANREQUEST.PRIMARYMANAGERFUNDRAISERID,
NF_PM.NAME REQUESTEDPRIMARYMANAGER,
PROSPECTPLANREQUEST.SECONDARYMANAGERFUNDRAISERID,
NF_SM.NAME REQUESTEDSECONDARYMANAGER,
PROSPECTPLANREQUEST.PRIMARYMANAGERSTARTDATE,
PROSPECTPLANREQUEST.SECONDARYMANAGERSTARTDATE,
PROSPECTPLANREQUEST.REVIEWDATE,
dbo.UFN_APPUSER_GETNAME(PROSPECTPLANREQUEST.REVIEWEDBYID) REVIEWEDBYNAME,
PROSPECTPLANREQUEST.REVIEWEDBYID,
dbo.UFN_APPUSER_GETNAME(PROSPECTPLANREQUEST.SUBMITTEDBYID) SUBMITTEDBYNAME,
PROSPECTPLANREQUEST.SUBMITTEDBYID,
PROSPECTPLANREQUEST.PROSPECTID REQUESTEDPROSPECTID,
PROSPECTPLANREQUEST.DATEADDED,
PROSPECTPLANREQUEST.DATECHANGED,
PROSPECTPLANREQUEST.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME
from dbo.PROSPECTPLANREQUEST
left join dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = PROSPECTPLANREQUEST.ADDEDBYID
left join dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = PROSPECTPLANREQUEST.CHANGEDBYID
left join dbo.PROSPECTPLANTYPECODE on PROSPECTPLANREQUEST.PROSPECTPLANTYPECODEID = PROSPECTPLANTYPECODE.ID
outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(PROSPECTPLANREQUEST.PRIMARYMANAGERFUNDRAISERID) NF_PM
outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(PROSPECTPLANREQUEST.SECONDARYMANAGERFUNDRAISERID) NF_SM