USP_DATAFORMTEMPLATE_VIEW_PHONEFINDERSUBMITPROCESS

The load procedure used by the view dataform template "PhoneFinder Submit Process 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.
@DATELASTRUN	datetime	INOUT	Date last run
@DESCRIPTION	nvarchar(250)	INOUT	Description
@STEP	nvarchar(250)	INOUT	Step
@SELECTIONNAME	nvarchar(250)	INOUT	Selected constituents
@INDIVIDUALADDRESSINCLUDECODE	tinyint	INOUT	Individual address include code
@INDIVIDUALADDRESSINCLUDE	nvarchar(150)	INOUT	Individual addresses to include
@INDIVIDUALADDRESSTYPECODE	nvarchar(250)	INOUT	Individual address type code
@ORGANIZATIONADDRESSINCLUDECODE	tinyint	INOUT	Organization address include code
@ORGANIZATIONADDRESSINCLUDE	nvarchar(150)	INOUT	Organization addresses to include
@ORGANIZATIONADDRESSTYPECODE	nvarchar(250)	INOUT	Organization address type code
@CREATEOUTPUTIDSET	bit	INOUT	Create output selection
@OUTPUTIDSETNAME	nvarchar(100)	INOUT	Output selection name
@OVERWRITEOUTPUTIDSET	bit	INOUT	Overwrite existing selection
@PROCESSCAPTION	nvarchar(700)	INOUT	Process caption
@FILEUPLOADED	bit	INOUT	FILEUPLOADED
@FILEAVAILABLE	bit	INOUT	FILEAVAILABLE
@FILEDOWNLOADED	bit	INOUT	FILEDOWNLOADED
@PHONEFINDERID	uniqueidentifier	INOUT	PHONEFINDERID
@PHONEFINDERSUBMITPROCESSID	uniqueidentifier	INOUT	PHONEFINDERSUBMITPROCESSID
@PHONEFINDERRESUBMITPROCESSID	uniqueidentifier	INOUT	PHONEFINDERRESUBMITPROCESSID

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PHONEFINDERSUBMITPROCESS
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @DATELASTRUN datetime = null output,
    @DESCRIPTION nvarchar(250) = null output,
    @STEP nvarchar(250) = null output,
    @SELECTIONNAME nvarchar(250) = null output,
    @INDIVIDUALADDRESSINCLUDECODE tinyint = null output,
    @INDIVIDUALADDRESSINCLUDE nvarchar(150) = null output,
    @INDIVIDUALADDRESSTYPECODE nvarchar(250) = null output,
    @ORGANIZATIONADDRESSINCLUDECODE tinyint = null output,
    @ORGANIZATIONADDRESSINCLUDE nvarchar(150) = null output,
    @ORGANIZATIONADDRESSTYPECODE nvarchar(250) = null output,
    @CREATEOUTPUTIDSET bit = null output,
    @OUTPUTIDSETNAME nvarchar(100) = null output,
    @OVERWRITEOUTPUTIDSET bit = null output,
    @PROCESSCAPTION nvarchar(700) = null output,
    @FILEUPLOADED bit = null output,
    @FILEAVAILABLE bit = null output,
    @FILEDOWNLOADED bit = null output,
    @PHONEFINDERID uniqueidentifier = null output,
    @PHONEFINDERSUBMITPROCESSID uniqueidentifier = null output,
    @PHONEFINDERRESUBMITPROCESSID uniqueidentifier = null output
)
as begin
    set nocount on;

    set @DATALOADED = 0;

    declare @NAME nvarchar(150);
    declare @SITENAME nvarchar(500);

    select
        @DATALOADED = 1,
        @DATELASTRUN = dbo.UFN_PHONEFINDER_GETLASTRUNDATE(PHONEFINDER.[ID]),
        @DESCRIPTION = PHONEFINDER.[DESCRIPTION],
        @STEP = PHONEFINDER.[STEP],
        @SELECTIONNAME = coalesce(dbo.UFN_IDSET_GETNAME(PHONEFINDERSUBMITPROCESS.[IDSETREGISTERID]), N'All constituents'),
        @INDIVIDUALADDRESSINCLUDECODE = PHONEFINDERSUBMITPROCESS.[INDIVIDUALADDRESSINCLUDECODE],
        @INDIVIDUALADDRESSINCLUDE = PHONEFINDERSUBMITPROCESS.[INDIVIDUALADDRESSINCLUDE],
        @INDIVIDUALADDRESSTYPECODE = dbo.UFN_ADDRESSTYPECODE_GETDESCRIPTION(PHONEFINDERSUBMITPROCESS.[INDIVIDUALADDRESSTYPECODEID]),
        @ORGANIZATIONADDRESSINCLUDECODE = PHONEFINDERSUBMITPROCESS.[ORGANIZATIONADDRESSINCLUDECODE],
        @ORGANIZATIONADDRESSINCLUDE = PHONEFINDERSUBMITPROCESS.[ORGANIZATIONADDRESSINCLUDE],
        @ORGANIZATIONADDRESSTYPECODE = dbo.UFN_ADDRESSTYPECODE_GETDESCRIPTION(PHONEFINDERSUBMITPROCESS.[ORGANIZATIONADDRESSTYPECODEID]),
        @CREATEOUTPUTIDSET = PHONEFINDERSUBMITPROCESS.[CREATEOUTPUTIDSET],
        @OVERWRITEOUTPUTIDSET = PHONEFINDERSUBMITPROCESS.[OVERWRITEOUTPUTIDSET],
        @OUTPUTIDSETNAME = PHONEFINDERSUBMITPROCESS.[OUTPUTIDSETNAME],
        @NAME = PHONEFINDER.[NAME],
        @SITENAME = SITE.[NAME],
        @FILEUPLOADED = PHONEFINDER.[FILEUPLOADED],
        @FILEAVAILABLE = PHONEFINDER.[FILEAVAILABLE],
        @FILEDOWNLOADED = PHONEFINDER.[FILEDOWNLOADED],
        @PROCESSCAPTION = coalesce(SITE.[NAME] + N' - ', N'') + coalesce(PHONEFINDER.[NAME], N''),
        @PHONEFINDERSUBMITPROCESSID = PHONEFINDERSUBMITPROCESS.[ID],
        @PHONEFINDERID = PHONEFINDER.[ID],
        @PHONEFINDERRESUBMITPROCESSID = PHONEFINDERRESUBMITPROCESS.[ID]
    from
        dbo.PHONEFINDERSUBMITPROCESS
        inner join dbo.PHONEFINDER on PHONEFINDER.[ID] = PHONEFINDERSUBMITPROCESS.[PHONEFINDERID]
        inner join dbo.PHONEFINDERGETPROCESS on PHONEFINDERGETPROCESS.[PHONEFINDERID] = PHONEFINDER.[ID]
        inner join dbo.PHONEFINDERRESUBMITPROCESS on PHONEFINDERRESUBMITPROCESS.[PHONEFINDERID] = PHONEFINDER.[ID]
        left outer join dbo.SITE on SITE.[ID] = PHONEFINDER.[SITEID]
    where
        PHONEFINDERSUBMITPROCESS.[ID] = @ID;

    return 0;
end