USP_DATAFORMTEMPLATE_VIEW_PHONEFINDERTUNEUP

The load procedure used by the view dataform template "PhoneFinder Tune-Up 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	Last run on
@DESCRIPTION	nvarchar(250)	INOUT	Description
@STEP	nvarchar(250)	INOUT	Step
@SELECTIONNAME	nvarchar(250)	INOUT	Selected constituents
@INDIVIDUALADDRESSINCLUDECODE	tinyint	INOUT	Addresses to include
@INDIVIDUALADDRESSTYPECODE	nvarchar(250)	INOUT	Address type code
@ORGANIZATIONADDRESSINCLUDECODE	tinyint	INOUT	Organization addresses to include
@ORGANIZATIONADDRESSTYPECODE	nvarchar(250)	INOUT	Organization address type
@PRIMARYCONTACTNAME	nvarchar(250)	INOUT	Primary contact name
@PRIMARYCONTACTEMAIL	UDT_EMAILADDRESS	INOUT	Primary contact email address
@PRIMARYCONTACTPHONE	nvarchar(20)	INOUT	Primary contact phone number
@FILEAVAILABLE	bit	INOUT	FILEAVAILABLE

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PHONEFINDERTUNEUP
(
    @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,
    @INDIVIDUALADDRESSTYPECODE nvarchar(250) = null output,
    @ORGANIZATIONADDRESSINCLUDECODE tinyint = null output,
    @ORGANIZATIONADDRESSTYPECODE nvarchar(250) = null output,
    @PRIMARYCONTACTNAME nvarchar(250) = null output,
    @PRIMARYCONTACTEMAIL dbo.UDT_EMAILADDRESS = null output,
    @PRIMARYCONTACTPHONE nvarchar(20) = null output,
    @FILEAVAILABLE bit = null output
)
as
begin
    set nocount on;

    select 
        @DATALOADED = 1,
        @DATELASTRUN = dbo.UFN_PHONEFINDER_GETLASTRUNDATE(PHONEFINDER.[ID]),
        @DESCRIPTION = PHONEFINDER.[DESCRIPTION],
        @STEP = dbo.UFN_PHONEFINDER_GETSTEP(PHONEFINDER.[ID]),
        @SELECTIONNAME = coalesce(dbo.UFN_IDSET_GETNAME(PHONEFINDERSUBMITPROCESS.[IDSETREGISTERID]), N'All constituents'), 
        @INDIVIDUALADDRESSINCLUDECODE = PHONEFINDERSUBMITPROCESS.[INDIVIDUALADDRESSINCLUDECODE],
        @INDIVIDUALADDRESSTYPECODE = dbo.UFN_ADDRESSTYPECODE_GETDESCRIPTION(PHONEFINDERSUBMITPROCESS.[INDIVIDUALADDRESSTYPECODEID]),
        @ORGANIZATIONADDRESSINCLUDECODE = PHONEFINDERSUBMITPROCESS.[ORGANIZATIONADDRESSINCLUDECODE],
        @ORGANIZATIONADDRESSTYPECODE = dbo.UFN_ADDRESSTYPECODE_GETDESCRIPTION(PHONEFINDERSUBMITPROCESS.[ORGANIZATIONADDRESSTYPECODEID]),
        @PRIMARYCONTACTNAME = PHONEFINDER.[PRIMARYCONTACTNAME],
        @PRIMARYCONTACTEMAIL = PHONEFINDER.[PRIMARYCONTACTEMAIL],
        @PRIMARYCONTACTPHONE = PHONEFINDER.[PRIMARYCONTACTPHONE],
        @FILEAVAILABLE = PHONEFINDER.[FILEAVAILABLE]
    from dbo.PHONEFINDER
        inner join dbo.PHONEFINDERSUBMITPROCESS on PHONEFINDERSUBMITPROCESS.[PHONEFINDERID] = PHONEFINDER.[ID]
    where PHONEFINDER.[ID] = @ID;

    return 0;
end