USP_BBNC_COMMITEVENTREGISTRATIONGUESTADD

Adds a guest's biographical information from an event registration Blackbaud Internet Solutions transaction to the system from a given batch.

Parameters

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

Definition

Copy



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

                declare @SUFFIXCODEID uniqueidentifier = null;

                exec dbo.USP_BBNC_COMMITEVENTREGISTRATIONGUESTADD_1_1
                @ID output,
                @BBNCMAPID output,
                @FIRSTNAME,
                @MIDDLENAME,
                @KEYNAME,
                @CONSTITUENCYCODEID,
                @CHANGEAGENTID,
                @CHANGEDATE,
                @TITLECODEID,
                @SUFFIXCODEID;
                return 0;