USP_DATAFORMTEMPLATE_LOAD_CONTACTBATCHCONSTITUENTINFORMATION

The load procedure used by the view dataform template "Contact Batch Constituent Information View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@FIRSTNAME	nvarchar(100)	INOUT	FIRSTNAME
@KEYNAME	nvarchar(100)	INOUT	KEYNAME
@TITLECODEID	nvarchar(100)	INOUT	TITLECODEID
@SUFFIXCODEID	nvarchar(100)	INOUT	SUFFIXCODEID
@BIRTHDAY	datetime	INOUT	BIRTHDAY
@PHONES	xml	INOUT	PHONES
@ADDRESSES	xml	INOUT	ADDRESSES
@EMAILADDRESSES	xml	INOUT	EMAILADDRESSES
@WEBADDRESS	nvarchar(100)	INOUT	WEBADDRESS
@NICKNAME	nvarchar(100)	INOUT	NICKNAME
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@MIDDLENAME	nvarchar(50)	INOUT

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_LOAD_CONTACTBATCHCONSTITUENTINFORMATION
                (
                    @ID uniqueidentifier,
                    @FIRSTNAME nvarchar(100) = null output,
                    @KEYNAME nvarchar(100) = null output,
                    @TITLECODEID nvarchar(100) = null output,
                    @SUFFIXCODEID nvarchar(100) = null output,
                    @BIRTHDAY datetime = null output,
                    @PHONES xml = null output,
                    @ADDRESSES xml = null output,
                    @EMAILADDRESSES xml = null output,
                    @WEBADDRESS nvarchar(100) = null output,
                    @NICKNAME nvarchar(100) = null output,
                    @DATALOADED bit = 0 output,
                    @MIDDLENAME nvarchar(50) = null output
                )
                as
                    set nocount on;

                    select
                        @FIRSTNAME = CONSTITUENT.FIRSTNAME,
                        @KEYNAME = CONSTITUENT.KEYNAME,
                        @TITLECODEID = dbo.UFN_TITLECODE_GETDESCRIPTION(CONSTITUENT.TITLECODEID),
                        @SUFFIXCODEID = dbo.UFN_SUFFIXCODE_GETDESCRIPTION(CONSTITUENT.SUFFIXCODEID),
                        @BIRTHDAY = dbo.UFN_DATE_FROMFUZZYDATE(CONSTITUENT.BIRTHDATE),
                        @PHONES = dbo.UFN_EXCHANGECONTACTSYNC_GETCONSTITUENTPHONES_TOITEMLISTXML(CONSTITUENT.ID),
                        @ADDRESSES = dbo.UFN_EXCHANGECONTACTSYNC_GETCONSTITUENTADDRESSES_TOITEMLISTXML(CONSTITUENT.ID),
                        @EMAILADDRESSES = dbo.UFN_EXCHANGECONTACTSYNC_GETCONSTITUENTEMAILADDRESSES_TOITEMLISTXML(CONSTITUENT.ID),
                        @WEBADDRESS = CONSTITUENT.WEBADDRESS,
                        @NICKNAME = CONSTITUENT.NICKNAME,
                        @MIDDLENAME = CONSTITUENT.MIDDLENAME,
                        @DATALOADED = 1
                    from
                        dbo.CONSTITUENT
                    where
                        CONSTITUENT.ID = @ID;