USP_BBNC_COMMITDONORINFORMATIONBIOADD

Adds a constituent's biographical information from a Blackbaud Internet Solutions transaction with donor information to the system from a given batch.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@BBNCMAPID	int	INOUT
@TITLECODEID	uniqueidentifier	IN
@FIRSTNAME	nvarchar(50)	IN
@KEYNAME	nvarchar(100)	IN
@CONSTITUENCYCODEID	uniqueidentifier	IN
@XMLITEMS	xml	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            CREATE procedure dbo.USP_BBNC_COMMITDONORINFORMATIONBIOADD
            (
                @ID uniqueidentifier = null output,
                @BBNCMAPID int = null output,
                @TITLECODEID uniqueidentifier = null,
                @FIRSTNAME nvarchar(50) = '',
                @KEYNAME nvarchar(100),
                @CONSTITUENCYCODEID uniqueidentifier = null,
                @XMLITEMS xml = null,
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null
            )
            as
                set nocount on;

                declare @MIDDLENAME as nvarchar(50)='';
                declare    @ISORGANIZATION as bit = 0;

                exec dbo.USP_BBNC_COMMITDONORINFORMATIONBIOADD_1_1
                @ID output,
                @BBNCMAPID  output,
                @TITLECODEID,
                @FIRSTNAME,
                @KEYNAME ,
                @CONSTITUENCYCODEID ,
                @XMLITEMS,
                @CHANGEAGENTID ,
                @CHANGEDATE ,
                @MIDDLENAME ,
                @ISORGANIZATION

                return 0;