USP_PHONEFINDER_GETINFO

Retrieves information about a PhoneFinder process

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@DATELASTRUN	datetime	INOUT
@DESCRIPTION	nvarchar(250)	INOUT
@STEP	nvarchar(300)	INOUT
@SELECTIONNAME	nvarchar(250)	INOUT
@INDIVIDUALADDRESSINCLUDECODE	tinyint	INOUT
@INDIVIDUALADDRESSINCLUDE	nvarchar(150)	INOUT
@INDIVIDUALADDRESSTYPECODE	nvarchar(250)	INOUT
@ORGANIZATIONADDRESSINCLUDECODE	tinyint	INOUT
@ORGANIZATIONADDRESSINCLUDE	nvarchar(150)	INOUT
@ORGANIZATIONADDRESSTYPECODE	nvarchar(250)	INOUT
@CREATEOUTPUTIDSET	bit	INOUT
@OUTPUTIDSETNAME	nvarchar(100)	INOUT
@OVERWRITEOUTPUTIDSET	bit	INOUT
@PHONEFINDERSUBMITPROCESSID	uniqueidentifier	INOUT
@PHONEFINDERGETPROCESSID	uniqueidentifier	INOUT
@NAME	nvarchar(150)	INOUT
@SITENAME	nvarchar(500)	INOUT
@FILEUPLOADED	bit	INOUT
@FILEAVAILABLE	bit	INOUT
@FILEDOWNLOADED	bit	INOUT

Definition

Copy



CREATE procedure dbo.USP_PHONEFINDER_GETINFO
(
    @ID uniqueidentifier = null output,
    @DATELASTRUN datetime = null output,
    @DESCRIPTION nvarchar(250) = null output,
    @STEP nvarchar(300) = 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,
    @PHONEFINDERGETPROCESSID uniqueidentifier = null output,
    @NAME nvarchar(150) = null output,
    @SITENAME nvarchar(500) = null output,
    @FILEUPLOADED bit = null output,
    @FILEAVAILABLE bit = null output,
    @FILEDOWNLOADED bit = null output
)
as
begin
    set nocount on;

    declare @PHONEFINDERID uniqueidentifier = @ID;
    set @ID = null;

    select
        @ID = PHONEFINDER.[ID],
        @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],
        @PHONEFINDERSUBMITPROCESSID = PHONEFINDERSUBMITPROCESS.[ID],
        @PHONEFINDERGETPROCESSID = PHONEFINDERGETPROCESS.[ID],
        @NAME = PHONEFINDER.[NAME],
        @SITENAME = SITE.[NAME],
        @FILEUPLOADED = PHONEFINDER.[FILEUPLOADED],
        @FILEAVAILABLE = PHONEFINDER.[FILEAVAILABLE],
        @FILEDOWNLOADED = PHONEFINDER.[FILEDOWNLOADED]
    from
        dbo.PHONEFINDER
        inner join dbo.PHONEFINDERSUBMITPROCESS on PHONEFINDERSUBMITPROCESS.[PHONEFINDERID] = PHONEFINDER.[ID]
        inner join dbo.PHONEFINDERGETPROCESS on PHONEFINDERGETPROCESS.[PHONEFINDERID] = PHONEFINDER.[ID]
        left outer join dbo.SITE on SITE.[ID] = PHONEFINDER.[SITEID]
    where
        PHONEFINDER.[ID] = @PHONEFINDERID;

end