V_QUERY_PROSPECTRESEARCHREQUEST
Provides the ability to query prospect research request data.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| REQUESTNO | int | Request ID | |
| STATUS | nvarchar(11) | yes | Status |
| RECORDTYPE | nvarchar(13) | yes | Record type |
| EVENTID | uniqueidentifier | yes | Event ID |
| RESEARCHGROUPID | uniqueidentifier | yes | Research group ID |
| PRIORITYCODE | nvarchar(100) | yes | Priority |
| DUEDATE | datetime | Due date | |
| REQUESTDATE | datetime | Request date | |
| REQUESTTYPECODE | nvarchar(100) | yes | Research type |
| REQUESTREASONCODE | nvarchar(100) | yes | Request reason |
| REQUESTEDBYID | uniqueidentifier | yes | Requested by record |
| REQUESTEDBYNAME | nvarchar(154) | yes | Requested by name |
| SUBMITTEDBYID | uniqueidentifier | yes | Submitted by record |
| SUBMITTEDBYNAME | nvarchar(154) | yes | Submitted by name |
| ASSIGNEDTOID | uniqueidentifier | yes | Researcher record |
| ASSIGNEDTONAME | nvarchar(154) | yes | Researcher name |
| NOTES | nvarchar(max) | Request notes | |
| STATUSCHANGECODE | nvarchar(100) | yes | Status reason |
| STATUSCHANGENOTES | nvarchar(max) | Status comments | |
| 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 |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:09:57 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_PROSPECTRESEARCHREQUEST AS
select
PRR.ID,
PRR.REQUESTNO,
PRR.STATUS,
PRR.RECORDTYPE,
PRR.EVENTID,
PRR.RESEARCHGROUPID,
PRRPC.DESCRIPTION as [PRIORITYCODE],
PRR.DUEDATE,
PRR.DATEADDED as [REQUESTDATE],
PRRTC.DESCRIPTION as [REQUESTTYPECODE],
PRRRC.DESCRIPTION as [REQUESTREASONCODE],
PRR.REQUESTEDBYID,
dbo.UFN_CONSTITUENT_BUILDNAME(PRR.REQUESTEDBYID) as [REQUESTEDBYNAME],
PRR.SUBMITTEDBYID,
dbo.UFN_CONSTITUENT_BUILDNAME(PRR.SUBMITTEDBYID) as [SUBMITTEDBYNAME],
PRR.ASSIGNEDTOID,
dbo.UFN_CONSTITUENT_BUILDNAME(PRR.ASSIGNEDTOID) as [ASSIGNEDTONAME],
PRR.NOTES,
PRRSC.DESCRIPTION as [STATUSCHANGECODE],
PRR.STATUSCHANGENOTES,
ADDEDBY.APPLICATIONNAME as [ADDEDBY_APPLICATION],
ADDEDBY.USERNAME as [ADDEDBY_USERNAME],
CHANGEDBY.APPLICATIONNAME as [CHANGEDBY_APPLICATION],
CHANGEDBY.USERNAME as [CHANGEDBY_USERNAME],
PRR.DATEADDED,
PRR.DATECHANGED,
PRR.TSLONG
/*#EXTENSION*/
from
dbo.PROSPECTRESEARCHREQUEST PRR
left join dbo.PROSPECTRESEARCHREQUESTPRIORITYCODE PRRPC on PRRPC.ID = PRR.PROSPECTRESEARCHREQUESTPRIORITYCODEID
left join dbo.PROSPECTRESEARCHREQUESTTYPECODE PRRTC on PRRTC.ID = PRR.PROSPECTRESEARCHREQUESTTYPECODEID
left join dbo.PROSPECTRESEARCHREQUESTREASONCODE PRRRC on PRRRC.ID = PRR.PROSPECTRESEARCHREQUESTREASONCODEID
left join dbo.PROSPECTRESEARCHREQUESTSTATUSCHANGECODE PRRSC on PRRSC.ID = PRR.PROSPECTRESEARCHREQUESTSTATUSCHANGECODEID
left join dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = PRR.ADDEDBYID
left join dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = PRR.CHANGEDBYID