USP_DATAFORMTEMPLATE_VIEW_PHONEFINDER

The load procedure used by the view dataform template "PhoneFinder View Data 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
@PHONEFINDERSUBMITPROCESSID	uniqueidentifier	INOUT	PhoneFinder submit process ID
@PROCESSCAPTION	nvarchar(700)	INOUT	Process caption

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PHONEFINDER
(
    @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,
    @PHONEFINDERSUBMITPROCESSID uniqueidentifier = null output,
    @PROCESSCAPTION nvarchar(700) = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

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

    exec dbo.USP_PHONEFINDER_GETINFO
        @ID output,
        @DATELASTRUN output,
        @DESCRIPTION output,
        @STEP output,
        @SELECTIONNAME output,
        @INDIVIDUALADDRESSINCLUDECODE output,
        @INDIVIDUALADDRESSINCLUDE output,
        @INDIVIDUALADDRESSTYPECODE output,
        @ORGANIZATIONADDRESSINCLUDECODE output,
        @ORGANIZATIONADDRESSINCLUDE output,
        @ORGANIZATIONADDRESSTYPECODE output,
        @CREATEOUTPUTIDSET output,
        @OUTPUTIDSETNAME output,
        @OVERWRITEOUTPUTIDSET output,
        @PHONEFINDERSUBMITPROCESSID output,
        null,
        @NAME output,
        @SITENAME output;

    if @ID is not null
        set @DATALOADED = 1;

    set @PROCESSCAPTION = coalesce(@SITENAME + N' - ', N'') + coalesce(@NAME, N'');

    return 0;