USP_DATAFORMTEMPLATE_VIEW_PROSPECTRESEARCHREQUESTCONSTITUENTALERTDATA

The load procedure used by the view dataform template "Prospect Research Request Constituent Alert Data View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@REQUESTNUMBER	nvarchar(100)	INOUT	Request number
@STATUS	nvarchar(100)	INOUT	Status
@PRIORITY	nvarchar(100)	INOUT	Priority
@DUEDATE	datetime	INOUT	Due date
@REQUESTTYPE	nvarchar(100)	INOUT	Request type
@ASSIGNEDTO	nvarchar(154)	INOUT	Assigned to
@PROSPECT	nvarchar(154)	INOUT	Prospect
@REQUESTEDBY	nvarchar(154)	INOUT	Requested by
@SUBMITTEDBY	nvarchar(154)	INOUT	Submitted by
@STATUSCHANGEREASON	nvarchar(100)	INOUT	Status change reason

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PROSPECTRESEARCHREQUESTCONSTITUENTALERTDATA (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @REQUESTNUMBER nvarchar(100) = null output,
                    @STATUS nvarchar(100) = null output,
                    @PRIORITY nvarchar(100) = null output,
                    @DUEDATE datetime = null output,
                    @REQUESTTYPE nvarchar(100) = null output,
                    @ASSIGNEDTO nvarchar(154) = null output,
                    @PROSPECT nvarchar(154) = null output,
                    @REQUESTEDBY nvarchar(154) = null output,
                    @SUBMITTEDBY nvarchar(154) = null output,
                    @STATUSCHANGEREASON nvarchar(100) = null output
                ) as
                    set nocount on;

                    -- be sure to set this, in case the select returns no rows

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @REQUESTNUMBER = REQUEST.[REQUESTNO],
                        @STATUS = REQUEST.[STATUS],
                        @PRIORITY = PRIORITY.[DESCRIPTION],
                        @DUEDATE = REQUEST.[DUEDATE],
                        @REQUESTTYPE = REQUESTTYPE.[DESCRIPTION],
                        @ASSIGNEDTO = ASSIGNEDTO.[NAME],
                        @PROSPECT = PROSPECT.[NAME],
                        @SUBMITTEDBY = SUBMITTEDBYNAME.[NAME],
                        @REQUESTEDBY = REQUESTEDBYNAME.[NAME],
                        @STATUSCHANGEREASON = STATUSCHANGE.[DESCRIPTION]
                    from
                        dbo.[PROSPECTRESEARCHREQUESTCONSTITUENT] REQUEST
                    left join
                        dbo.[PROSPECTRESEARCHREQUEST] PARENT on PARENT.[ID] = REQUEST.[PROSPECTRESEARCHREQUESTID]
                    left join
                        dbo.[PROSPECTRESEARCHREQUESTPRIORITYCODE] PRIORITY on PRIORITY.[ID] = REQUEST.[PROSPECTRESEARCHREQUESTPRIORITYCODEID]
                    left join
                        dbo.[PROSPECTRESEARCHREQUESTTYPECODE] REQUESTTYPE on REQUESTTYPE.[ID] = REQUEST.[PROSPECTRESEARCHREQUESTTYPECODEID]
                    left join
                        dbo.[CONSTITUENT] ASSIGNEDTO on ASSIGNEDTO.[ID] = REQUEST.[ASSIGNEDTOID]
                    left join
                        dbo.[CONSTITUENT] PROSPECT on PROSPECT.[ID] = REQUEST.[CONSTITUENTID]
                    left join
                        dbo.[CONSTITUENT] SUBMITTEDBYNAME on SUBMITTEDBYNAME.[ID] = PARENT.[SUBMITTEDBYID]
                    left join
                        dbo.[CONSTITUENT] REQUESTEDBYNAME on REQUESTEDBYNAME.[ID] = PARENT.[REQUESTEDBYID]    
                    left join
                        dbo.[PROSPECTRESEARCHREQUESTSTATUSCHANGECODE] STATUSCHANGE on STATUSCHANGE.[ID] = REQUEST.[PROSPECTRESEARCHREQUESTSTATUSCHANGECODEID]
                    where
                        REQUEST.[ID] = @ID;

                    return 0;