USP_DATAFORMTEMPLATE_VIEW_BBNCCONSTITBIODATA

The load procedure used by the view dataform template "NetCommunity Constituent Biographical Data 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.
@BIRTHDATE	UDT_FUZZYDATE	INOUT	BIRTHDATE
@FIRSTNAME	nvarchar(50)	INOUT	FIRSTNAME
@NAME	nvarchar(154)	INOUT	NAME
@GENDER	nvarchar(100)	INOUT	GENDER
@KEYNAME	nvarchar(100)	INOUT	KEYNAME
@MAIDENNAME	nvarchar(100)	INOUT	MAIDENNAME
@MIDDLENAME	nvarchar(50)	INOUT	MIDDLENAME
@NICKNAME	nvarchar(50)	INOUT	NICKNAME
@TITLECODE	nvarchar(100)	INOUT	TITLECODE
@SUFFIXCODE	nvarchar(100)	INOUT	SUFFIXCODE
@REQUESTNOEMAIL	bit	INOUT	REQUESTNOEMAIL
@LOOKUPID	nvarchar(36)	INOUT	LOOKUPID
@MARITALSTATUSCODE	nvarchar(100)	INOUT	MARITALSTATUSCODE
@WEBADDRESS	UDT_WEBADDRESS	INOUT	WEBADDRESS
@ISDECEASED	bit	INOUT	ISDECEASED
@DECEASEDDATE	UDT_FUZZYDATE	INOUT	DECEASEDDATE
@TITLE2CODE	nvarchar(100)	INOUT	TITLE2CODE
@SUFFIX2CODE	nvarchar(100)	INOUT	SUFFIX2CODE

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_BBNCCONSTITBIODATA
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @BIRTHDATE dbo.UDT_FUZZYDATE = null output,
                    @FIRSTNAME nvarchar(50) = null output,
                    @NAME nvarchar(154) = null output,
                    @GENDER nvarchar(100) = null output,
                    @KEYNAME nvarchar(100) = null output,
                    @MAIDENNAME nvarchar(100) = null output,
                    @MIDDLENAME nvarchar(50) = null output,
                    @NICKNAME nvarchar(50) = null output,
                    @TITLECODE nvarchar(100) = null output,
                    @SUFFIXCODE nvarchar(100) = null output,
                    @REQUESTNOEMAIL bit = null output,
                    @LOOKUPID nvarchar(36) = null output,
                    @MARITALSTATUSCODE nvarchar(100) = null output,
                    @WEBADDRESS dbo.UDT_WEBADDRESS = null output,
                    @ISDECEASED bit = null output,
                    @DECEASEDDATE dbo.UDT_FUZZYDATE = null output,
                    @TITLE2CODE nvarchar(100) = null output,
                    @SUFFIX2CODE nvarchar(100) = null output
                )
                as
                    set nocount on;
                    set @DATALOADED = 0;

                    declare @BBNCID int;
                    select @BBNCID = [SEQUENCEID] from dbo.CONSTITUENT where [ID] = @ID;

                    declare @T table(BIRTHDATE dbo.UDT_FUZZYDATE, 
                                     FIRSTNAME nvarchar(50),
                                     NAME nvarchar(154),
                                     GENDER nvarchar(100),
                                     KEYNAME nvarchar(100),
                                     MAIDENNAME nvarchar(100),
                                     MIDDLENAME nvarchar(50),
                                     NICKNAME nvarchar(50),
                                     TITLECODE nvarchar(100),
                                     TITLE2CODE nvarchar(100),
                                     SUFFIXCODE nvarchar(100),
                                     SUFFIX2CODE nvarchar(100),
                                     REQUESTNOEMAIL bit,
                                     LOOKUPID nvarchar(36),
                                     MARITALSTATUSCODE nvarchar(100),
                                     WEBADDRESS nvarchar(2047),
                                     ISORGANIZATION bit,
                                     INDUSTRYCODE nvarchar(100),
                                     NUMEMPLOYEES int,
                                     NUMSUBSIDIARIES int,
                                     ISDECEASED bit,
                                     DECEASEDDATE dbo.UDT_FUZZYDATE,
                   TARGET nvarchar(200),
                   INCOME nvarchar(200),
                   GIVESANONYMOUSLY bit
                                     );

                    insert into @T 
                    (
                        BIRTHDATE, 
                        FIRSTNAME,
                        NAME,
                        GENDER,
                        KEYNAME,
                        MAIDENNAME,
                        MIDDLENAME,
                        NICKNAME,
                        TITLECODE,
                        TITLE2CODE,
                        SUFFIXCODE,
                        SUFFIX2CODE,
                        REQUESTNOEMAIL,
                        LOOKUPID,
                        MARITALSTATUSCODE,
                        WEBADDRESS,
                        ISORGANIZATION,
                        INDUSTRYCODE,
                        NUMEMPLOYEES,
                        NUMSUBSIDIARIES,
                        ISDECEASED,
                        DECEASEDDATE,
            TARGET,
            INCOME,
            GIVESANONYMOUSLY
                    )
                    exec dbo.USP_BBNC_CONSTITBIODATA @BBNCID;

                    select top 1 
                        @DATALOADED = 1,
                        @BIRTHDATE = [BIRTHDATE],
                        @FIRSTNAME = [FIRSTNAME],
                        @NAME = [NAME],
                        @GENDER = [GENDER],
                        @KEYNAME = [KEYNAME],
                        @MAIDENNAME = [MAIDENNAME],
                        @MIDDLENAME = [MIDDLENAME],
                        @NICKNAME = [NICKNAME],
                        @TITLECODE = [TITLECODE],
                        @TITLE2CODE = [TITLE2CODE],
                        @SUFFIXCODE = [SUFFIXCODE],
                        @SUFFIX2CODE = [SUFFIX2CODE],
                        @REQUESTNOEMAIL = [REQUESTNOEMAIL],
                        @LOOKUPID = [LOOKUPID],
                        @MARITALSTATUSCODE = [MARITALSTATUSCODE],
                        @WEBADDRESS = [WEBADDRESS],
                        @ISDECEASED = [ISDECEASED],
                        @DECEASEDDATE = DECEASEDDATE
                    from @T;

                    return 0;