USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTBATCHROW

The load procedure used by the edit dataform template "Constituent Batch Row Edit 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.
@ISORGANIZATION	tinyint	INOUT	Constituent type
@KEYNAME	nvarchar(100)	INOUT	Last/organization name
@FIRSTNAME	nvarchar(50)	INOUT	First name
@MIDDLENAME	nvarchar(50)	INOUT	Middle name
@MAIDENNAME	nvarchar(100)	INOUT	Maiden name
@NICKNAME	nvarchar(50)	INOUT	Nickname
@TITLECODEID	uniqueidentifier	INOUT	Title
@SUFFIXCODEID	uniqueidentifier	INOUT	Suffix
@BIRTHDATE	UDT_FUZZYDATE	INOUT	Birth date
@GENDERCODE	tinyint	INOUT	Gender
@WEBADDRESS	UDT_WEBADDRESS	INOUT	Web site address
@INDUSTRYCODEID	uniqueidentifier	INOUT	Industry
@PARENTCORPID	uniqueidentifier	INOUT	Parent org
@NUMEMPLOYEES	int	INOUT	No. of employees
@NUMSUBSIDIARIES	int	INOUT	No. of subsidiary orgs
@ADDRESS_ADDRESSTYPECODEID	uniqueidentifier	INOUT	Address type
@ADDRESS_COUNTRYID	uniqueidentifier	INOUT	Country
@ADDRESS_ADDRESSBLOCK	nvarchar(150)	INOUT	Address
@ADDRESS_CITY	nvarchar(50)	INOUT	City
@ADDRESS_STATEID	uniqueidentifier	INOUT	State
@ADDRESS_POSTCODE	nvarchar(12)	INOUT	ZIP
@ADDRESS_DONOTMAIL	bit	INOUT	Do not send mail to this address
@PHONES	xml	INOUT	Phones
@EMAILADDRESS_EMAILADDRESSTYPECODEID	uniqueidentifier	INOUT	Email type
@EMAILADDRESS_EMAILADDRESS	UDT_EMAILADDRESS	INOUT	Email address
@CUSTOMIDENTIFIER	nvarchar(100)	INOUT	Lookup ID
@SEQUENCE	int	INOUT	Sequence
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTBATCHROW
                    (
                            @ID uniqueidentifier,
                            @DATALOADED bit = 0 output,                            
                            @ISORGANIZATION tinyint = null output,
                            @KEYNAME nvarchar(100) = null output,
                            @FIRSTNAME nvarchar(50) = null output,
                            @MIDDLENAME nvarchar(50) = null output,
                            @MAIDENNAME nvarchar(100) = null output,
                            @NICKNAME nvarchar(50) = null output,
                            @TITLECODEID uniqueidentifier = null output,
                            @SUFFIXCODEID uniqueidentifier = null output,
                            @BIRTHDATE dbo.UDT_FUZZYDATE = null output,
                            @GENDERCODE tinyint = null output,
                            @WEBADDRESS dbo.UDT_WEBADDRESS = null output,
                            @INDUSTRYCODEID uniqueidentifier = null output,
                            @PARENTCORPID uniqueidentifier = null output,
                            @NUMEMPLOYEES int = null output,
                            @NUMSUBSIDIARIES int = null output,
                            @ADDRESS_ADDRESSTYPECODEID uniqueidentifier = null output,
                            @ADDRESS_COUNTRYID uniqueidentifier = null output,
                            @ADDRESS_ADDRESSBLOCK nvarchar(150) = null output,
                            @ADDRESS_CITY nvarchar(50) = null output,
                            @ADDRESS_STATEID uniqueidentifier = null output,
                            @ADDRESS_POSTCODE nvarchar(12) = null output,
                            @ADDRESS_DONOTMAIL bit = null output,
                            @PHONES xml = null output,
                            @EMAILADDRESS_EMAILADDRESSTYPECODEID uniqueidentifier = null output,
                            @EMAILADDRESS_EMAILADDRESS dbo.UDT_EMAILADDRESS = null output,
                            @CUSTOMIDENTIFIER nvarchar(100) = null output,
                            @SEQUENCE int = null output,
                            @TSLONG bigint = 0 output
                        ) as
                            set nocount on;

                            set @DATALOADED = 0;
                            set @TSLONG = 0;

                            select
                                @DATALOADED = 1,                            
                                @ISORGANIZATION = [ISORGANIZATION],
                                @KEYNAME = [KEYNAME],
                                @FIRSTNAME = [FIRSTNAME],
                                @MIDDLENAME = [MIDDLENAME],
                                @MAIDENNAME = [MAIDENNAME],
                                @NICKNAME = [NICKNAME],
                                @TITLECODEID = [TITLECODEID],
                                @SUFFIXCODEID = [SUFFIXCODEID],
                                @BIRTHDATE = [BIRTHDATE],
                                @GENDERCODE = [GENDERCODE],
                                @WEBADDRESS = [WEBADDRESS],
                                @INDUSTRYCODEID = [INDUSTRYCODEID],
                                @PARENTCORPID = [PARENTCORPID],
                                @NUMEMPLOYEES = [NUMEMPLOYEES],
                                @NUMSUBSIDIARIES = [NUMSUBSIDIARIES],
                                @ADDRESS_ADDRESSTYPECODEID = [ADDRESS_ADDRESSTYPECODEID],
                                @ADDRESS_COUNTRYID = [ADDRESS_COUNTRYID],
                                @ADDRESS_ADDRESSBLOCK = [ADDRESS_ADDRESSBLOCK],
                                @ADDRESS_CITY = [ADDRESS_CITY],
                                @ADDRESS_STATEID = [ADDRESS_STATEID],
                                @ADDRESS_POSTCODE = [ADDRESS_POSTCODE],
                                @ADDRESS_DONOTMAIL = [ADDRESS_DONOTMAIL],
                                @PHONES = dbo.UFN_CONSTITUENTBATCH_GETPHONES_TOITEMLISTXML(ID),
                                @EMAILADDRESS_EMAILADDRESSTYPECODEID = [EMAILADDRESS_EMAILADDRESSTYPECODEID],
                                @EMAILADDRESS_EMAILADDRESS = [EMAILADDRESS_EMAILADDRESS],
                                @CUSTOMIDENTIFIER = [CUSTOMID],
                                @SEQUENCE = [SEQUENCE],
                                @TSLONG = [TSLONG]
                            from
                                dbo.BATCHCONSTITUENT
                            where
                                BATCHCONSTITUENT.ID = @ID;                            

                            return 0;