USP_BBNC_COMMITPROFILEUPDATEBIOGRAPHICAL

Updates a constituent's biographical information from a Blackbaud Internet Solutions profile transaction to the system from a given batch.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@BIRTHDATE	UDT_FUZZYDATE	IN
@FIRSTNAME	nvarchar(50)	IN
@GENDERCODE	tinyint	IN
@KEYNAME	nvarchar(100)	IN
@MAIDENNAME	nvarchar(100)	IN
@MARITALSTATUSCODEID	uniqueidentifier	IN
@MIDDLENAME	nvarchar(50)	IN
@NICKNAME	nvarchar(50)	IN
@TITLECODEID	uniqueidentifier	IN
@SUFFIXCODEID	uniqueidentifier	IN
@REQUESTNOEMAIL	bit	IN
@CUSTOMIDENTIFIER	nvarchar(36)	IN
@WEBADDRESS	UDT_WEBADDRESS	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN
@TITLE2CODEID	uniqueidentifier	IN
@SUFFIX2CODEID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_BBNC_COMMITPROFILEUPDATEBIOGRAPHICAL
                (
                    @ID uniqueidentifier = null,                            
                    @BIRTHDATE dbo.UDT_FUZZYDATE = '00000000',
                    @FIRSTNAME nvarchar(50) = '',
                    @GENDERCODE tinyint = 0,
                    @KEYNAME nvarchar(100),
                    @MAIDENNAME nvarchar(100) = '',
                    @MARITALSTATUSCODEID uniqueidentifier = null,
                    @MIDDLENAME nvarchar(50) = '',
                    @NICKNAME nvarchar(50) = '',
                    @TITLECODEID uniqueidentifier = null,
                    @SUFFIXCODEID uniqueidentifier = null,
                    @REQUESTNOEMAIL bit = 0,
                    @CUSTOMIDENTIFIER nvarchar(36) = '',
                    @WEBADDRESS dbo.UDT_WEBADDRESS = '',
                    @CHANGEAGENTID uniqueidentifier = null,
                    @CHANGEDATE datetime = null,
                    @TITLE2CODEID uniqueidentifier = null,
                    @SUFFIX2CODEID uniqueidentifier = null
                ) as
                    set nocount on;

          exec dbo.USP_BBNC_COMMITPROFILEUPDATEBIOGRAPHICAL_1
          @ID,
                    @BIRTHDATE,
                    @FIRSTNAME,
                    @GENDERCODE,
                    @KEYNAME,
                    @MAIDENNAME,
                    @MARITALSTATUSCODEID,
                    @MIDDLENAME,
                    @NICKNAME,
                    @TITLECODEID ,
                    @SUFFIXCODEID ,
                    @REQUESTNOEMAIL ,
                    @CUSTOMIDENTIFIER ,
                    @WEBADDRESS,
                    @CHANGEAGENTID,
                    @CHANGEDATE ,
                    @TITLE2CODEID ,
                    @SUFFIX2CODEID ,
          null

          return 0;