USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTBATCHROW_3

The load procedure used by the edit dataform template "Constituent Batch Row Edit Form 3"

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.
@ADDRESS_CART	nvarchar(10)	INOUT	CART
@ADDRESS_DPC	nvarchar(8)	INOUT	DPC
@ADDRESS_LOT	nvarchar(5)	INOUT	LOT
@ADDRESS_STARTDATE	UDT_MONTHDAY	INOUT	Address start date
@ADDRESS_ENDDATE	UDT_MONTHDAY	INOUT	Address end date
@PRIMARYADDRESSEE_NAMEFORMATTYPECODEID	uniqueidentifier	INOUT	Addressee type
@PRIMARYADDRESSEE_NAMEFORMATFUNCTIONID	uniqueidentifier	INOUT	Addressee name format
@PRIMARYSALUTATION_NAMEFORMATTYPECODEID	uniqueidentifier	INOUT	Salutation type
@PRIMARYSALUTATION_NAMEFORMATFUNCTIONID	uniqueidentifier	INOUT	Salutation name format
@ISDECEASED	bit	INOUT	Is deceased
@DECEASEDDATE	UDT_FUZZYDATE	INOUT	Deceased date
@EDUCATIONALHISTORY_EDUCATIONALINSTITUTIONID	uniqueidentifier	INOUT	Educational institution
@EDUCATIONALHISTORY_ISPRIMARYRECORD	bit	INOUT	Educational is primary
@EDUCATIONALHISTORY_EDUCATIONALHISTORYTYPECODEID	uniqueidentifier	INOUT	Educational type
@EDUCATIONALHISTORY_EDUCATIONALHISTORYSTATUSCODEID	uniqueidentifier	INOUT	Educational detail
@EDUCATIONALHISTORY_CONSTITUENCYSTATUSCODE	tinyint	INOUT	Educational status
@EDUCATIONALHISTORY_CLASSOF	UDT_YEAR	INOUT	Class of
@EDUCATIONALHISTORY_EDUCATIONALDEGREECODEID	uniqueidentifier	INOUT	Degree
@EDUCATIONALHISTORY_GPA	decimal(3, 2)	INOUT	GPA
@EDUCATIONALHISTORY_STARTDATE	UDT_FUZZYDATE	INOUT	Educational start date
@EDUCATIONALHISTORY_ENDDATE	UDT_FUZZYDATE	INOUT	Educational end date
@EDUCATIONALHISTORY_KNOWNNAME	nvarchar(50)	INOUT	Known name
@EDUCATIONALHISTORY_FRATERNITY	nvarchar(50)	INOUT	Fraternity
@SPOUSEID	uniqueidentifier	INOUT	Spouse
@SPOUSE_RELATIONSHIPTYPECODEID	uniqueidentifier	INOUT	Spouse relationship type
@SPOUSE_RECIPROCALTYPECODEID	uniqueidentifier	INOUT	Spouse reciprocal type
@SPOUSE_KEYNAME	nvarchar(100)	INOUT	Spouse last name
@SPOUSE_FIRSTNAME	nvarchar(50)	INOUT	Spouse first name
@SPOUSE_MIDDLENAME	nvarchar(50)	INOUT	Spouse middle name
@SPOUSE_MAIDENNAME	nvarchar(100)	INOUT	Spouse maiden name
@SPOUSE_NICKNAME	nvarchar(50)	INOUT	Spouse nickname
@SPOUSE_TITLECODEID	uniqueidentifier	INOUT	Spouse title
@SPOUSE_SUFFIXCODEID	uniqueidentifier	INOUT	Spouse suffix
@SPOUSE_GENDERCODE	tinyint	INOUT	Spouse gender
@SPOUSE_BIRTHDATE	UDT_FUZZYDATE	INOUT	Spouse birth date
@SPOUSE_EMAILADDRESS_EMAILADDRESSTYPECODEID	uniqueidentifier	INOUT	Spouse email address type
@SPOUSE_EMAILADDRESS_EMAILADDRESS	UDT_EMAILADDRESS	INOUT	Spouse email address
@PRIMARYBUSINESSID	uniqueidentifier	INOUT	Business
@PRIMARYBUSINESS_RELATIONSHIPTYPECODEID	uniqueidentifier	INOUT	Business relationship type
@PRIMARYBUSINESS_RECIPROCALTYPECODEID	uniqueidentifier	INOUT	Business reciprocal type
@PRIMARYBUSINESS_KEYNAME	nvarchar(100)	INOUT	Business name
@PRIMARYBUSINESS_PHONE_PHONETYPECODEID	uniqueidentifier	INOUT	Business phone type
@PRIMARYBUSINESS_PHONE_NUMBER	nvarchar(100)	INOUT	Business phone number
@PRIMARYBUSINESS_EMAILADDRESS_EMAILADDRESSTYPECODEID	uniqueidentifier	INOUT	Business email type
@PRIMARYBUSINESS_EMAILADDRESS_EMAILADDRESS	UDT_EMAILADDRESS	INOUT	Business email address
@PRIMARYBUSINESS_ADDRESS_ADDRESSTYPECODEID	uniqueidentifier	INOUT	Business address type
@PRIMARYBUSINESS_ADDRESS_COUNTRYID	uniqueidentifier	INOUT	Business country
@PRIMARYBUSINESS_ADDRESS_ADDRESSBLOCK	nvarchar(150)	INOUT	Business address
@PRIMARYBUSINESS_ADDRESS_CITY	nvarchar(50)	INOUT	Business city
@PRIMARYBUSINESS_ADDRESS_STATEID	uniqueidentifier	INOUT	Business state
@PRIMARYBUSINESS_ADDRESS_POSTCODE	nvarchar(12)	INOUT	Business ZIP
@PRIMARYBUSINESS_ADDRESS_CART	nvarchar(10)	INOUT	Business CART
@PRIMARYBUSINESS_ADDRESS_DPC	nvarchar(8)	INOUT	Business DPC
@PRIMARYBUSINESS_ADDRESS_LOT	nvarchar(5)	INOUT	Business LOT
@PRIMARYBUSINESS_ADDRESS_DONOTMAIL	bit	INOUT	Business do not mail
@PRIMARYBUSINESS_INDUSTRYCODEID	uniqueidentifier	INOUT	Business industry
@PRIMARYBUSINESS_NUMEMPLOYEES	int	INOUT	Business no. of employees
@PRIMARYBUSINESS_NUMSUBSIDIARIES	int	INOUT	Business no. of subsidiary orgs
@PRIMARYBUSINESS_WEBADDRESS	UDT_WEBADDRESS	INOUT	Business web site address
@PRIMARYBUSINESS_PARENTCORPID	uniqueidentifier	INOUT	Business parent org
@CONSTITUENCY	xml	INOUT	User defined constituencies
@INTEREST	xml	INOUT	Interests
@EDUCATIONALMAJOR	xml	INOUT	Major
@EDUCATIONALMINOR	xml	INOUT	Minor
@SPOUSE_COPY_ADDRESS	bit	INOUT	Spouse copy address
@SPOUSE_COPY_PHONENUMBER	bit	INOUT	Spouse copy phone number
@SPOUSE_COPY_EMAILADDRESS	bit	INOUT	Spouse copy email address
@CONSTIT_SECURITY_ATTRIBUTEID	uniqueidentifier	INOUT	Constituent Security Attribute
@ADDRESS_COUNTYCODEID	uniqueidentifier	INOUT	County
@ADDRESS_OMITFROMVALIDATION	bit	INOUT	Omit from validation
@ADDRESS_CONGRESSIONALDISTRICTCODEID	uniqueidentifier	INOUT	Congressional district
@ADDRESS_STATEHOUSEDISTRICTCODEID	uniqueidentifier	INOUT	State house district
@ADDRESS_STATESENATEDISTRICTCODEID	uniqueidentifier	INOUT	State senate district
@ADDRESS_LOCALPRECINCTCODEID	uniqueidentifier	INOUT	Local precinct
@ADDRESS_INFOSOURCECODEID	uniqueidentifier	INOUT	Info source
@ADDRESS_REGIONCODEID	uniqueidentifier	INOUT	Region
@ADDRESS_LASTVALIDATIONATTEMPTDATE	datetime	INOUT	Last validation attempt date
@ADDRESS_VALIDATIONMESSAGE	nvarchar(200)	INOUT	Validation message
@ADDRESS_CERTIFICATIONDATA	int	INOUT	Certification data

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTBATCHROW_3
                    (
                            @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,
                            @ADDRESS_CART nvarchar(10) = null output,
                            @ADDRESS_DPC nvarchar(8) = null output,
                            @ADDRESS_LOT nvarchar(5) = null output,
                            @ADDRESS_STARTDATE dbo.UDT_MONTHDAY = null output,
                            @ADDRESS_ENDDATE dbo.UDT_MONTHDAY = null output,
                            @PRIMARYADDRESSEE_NAMEFORMATTYPECODEID uniqueidentifier = null output,
                            @PRIMARYADDRESSEE_NAMEFORMATFUNCTIONID uniqueidentifier = null output,
                            @PRIMARYSALUTATION_NAMEFORMATTYPECODEID uniqueidentifier = null output,
                            @PRIMARYSALUTATION_NAMEFORMATFUNCTIONID uniqueidentifier = null output,
                            @ISDECEASED bit = null output,
                            @DECEASEDDATE dbo.UDT_FUZZYDATE = null output,
                            @EDUCATIONALHISTORY_EDUCATIONALINSTITUTIONID uniqueidentifier = null output,
                            @EDUCATIONALHISTORY_ISPRIMARYRECORD bit = null output,
                            @EDUCATIONALHISTORY_EDUCATIONALHISTORYTYPECODEID uniqueidentifier = null output,
                            @EDUCATIONALHISTORY_EDUCATIONALHISTORYSTATUSCODEID uniqueidentifier = null output,
                            @EDUCATIONALHISTORY_CONSTITUENCYSTATUSCODE tinyint = null output,
                            @EDUCATIONALHISTORY_CLASSOF dbo.UDT_YEAR = null output,
                            @EDUCATIONALHISTORY_EDUCATIONALDEGREECODEID uniqueidentifier = null output,
                            @EDUCATIONALHISTORY_GPA decimal(3,2) = null output,
                            @EDUCATIONALHISTORY_STARTDATE dbo.UDT_FUZZYDATE = null output,
                            @EDUCATIONALHISTORY_ENDDATE dbo.UDT_FUZZYDATE = null output,
                            @EDUCATIONALHISTORY_KNOWNNAME nvarchar(50) = null output,
                            @EDUCATIONALHISTORY_FRATERNITY nvarchar(50) = null output,
                            @SPOUSEID uniqueidentifier = null output,
                            @SPOUSE_RELATIONSHIPTYPECODEID uniqueidentifier = null output,
                            @SPOUSE_RECIPROCALTYPECODEID uniqueidentifier = null output,
                            @SPOUSE_KEYNAME nvarchar(100) = null output,
                            @SPOUSE_FIRSTNAME nvarchar(50) = null output,
                            @SPOUSE_MIDDLENAME nvarchar(50) = null output,
                            @SPOUSE_MAIDENNAME nvarchar(100) = null output,
                            @SPOUSE_NICKNAME nvarchar(50) = null output,
                            @SPOUSE_TITLECODEID uniqueidentifier = null output,
                            @SPOUSE_SUFFIXCODEID uniqueidentifier = null output,
                            @SPOUSE_GENDERCODE tinyint = null output,
                            @SPOUSE_BIRTHDATE dbo.UDT_FUZZYDATE = null output,
                            @SPOUSE_EMAILADDRESS_EMAILADDRESSTYPECODEID uniqueidentifier = null output,
                            @SPOUSE_EMAILADDRESS_EMAILADDRESS dbo.UDT_EMAILADDRESS = null output,
                            @PRIMARYBUSINESSID uniqueidentifier = null output,
                            @PRIMARYBUSINESS_RELATIONSHIPTYPECODEID uniqueidentifier = null output,
                            @PRIMARYBUSINESS_RECIPROCALTYPECODEID uniqueidentifier = null output,
                            @PRIMARYBUSINESS_KEYNAME nvarchar(100) = null output,
                            @PRIMARYBUSINESS_PHONE_PHONETYPECODEID uniqueidentifier = null output,
                            @PRIMARYBUSINESS_PHONE_NUMBER nvarchar(100) = null output,
                            @PRIMARYBUSINESS_EMAILADDRESS_EMAILADDRESSTYPECODEID uniqueidentifier = null output,
                            @PRIMARYBUSINESS_EMAILADDRESS_EMAILADDRESS dbo.UDT_EMAILADDRESS = null output,
                            @PRIMARYBUSINESS_ADDRESS_ADDRESSTYPECODEID uniqueidentifier = null output,
                            @PRIMARYBUSINESS_ADDRESS_COUNTRYID uniqueidentifier = null output,
                            @PRIMARYBUSINESS_ADDRESS_ADDRESSBLOCK nvarchar(150) = null output,
                            @PRIMARYBUSINESS_ADDRESS_CITY nvarchar(50) = null output,
                            @PRIMARYBUSINESS_ADDRESS_STATEID uniqueidentifier = null output,
                            @PRIMARYBUSINESS_ADDRESS_POSTCODE nvarchar(12) = null output,
                            @PRIMARYBUSINESS_ADDRESS_CART nvarchar(10) = null output,
                            @PRIMARYBUSINESS_ADDRESS_DPC nvarchar(8) = null output,
                            @PRIMARYBUSINESS_ADDRESS_LOT nvarchar(5) = null output,
                            @PRIMARYBUSINESS_ADDRESS_DONOTMAIL bit = null output,
                            @PRIMARYBUSINESS_INDUSTRYCODEID uniqueidentifier = null output,
                            @PRIMARYBUSINESS_NUMEMPLOYEES int = null output,
                            @PRIMARYBUSINESS_NUMSUBSIDIARIES int = null output,
                            @PRIMARYBUSINESS_WEBADDRESS dbo.UDT_WEBADDRESS = null output,
                            @PRIMARYBUSINESS_PARENTCORPID uniqueidentifier = null output,
                            @CONSTITUENCY xml = null output,
                            @INTEREST xml = null output,
                            @EDUCATIONALMAJOR xml = null output,
                            @EDUCATIONALMINOR xml = null output,
                            @SPOUSE_COPY_ADDRESS bit = null output,
                            @SPOUSE_COPY_PHONENUMBER bit = null output,
                            @SPOUSE_COPY_EMAILADDRESS bit = null output,
                            @CONSTIT_SECURITY_ATTRIBUTEID uniqueidentifier = null output,
                            @ADDRESS_COUNTYCODEID uniqueidentifier = null output,
                            @ADDRESS_OMITFROMVALIDATION bit = null output,
                            @ADDRESS_CONGRESSIONALDISTRICTCODEID uniqueidentifier = null output,
                            @ADDRESS_STATEHOUSEDISTRICTCODEID uniqueidentifier = null output,
                            @ADDRESS_STATESENATEDISTRICTCODEID uniqueidentifier = null output,
                            @ADDRESS_LOCALPRECINCTCODEID uniqueidentifier = null output,
                            @ADDRESS_INFOSOURCECODEID uniqueidentifier = null output,
                            @ADDRESS_REGIONCODEID uniqueidentifier = null output,
                            @ADDRESS_LASTVALIDATIONATTEMPTDATE datetime = null output,
                            @ADDRESS_VALIDATIONMESSAGE nvarchar(200) = null output,
                            @ADDRESS_CERTIFICATIONDATA int = null 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],
                                @ADDRESS_CART = [ADDRESS_CART],
                                @ADDRESS_DPC = [ADDRESS_DPC],
                                @ADDRESS_LOT = [ADDRESS_LOT],
                                @ADDRESS_STARTDATE = [ADDRESS_STARTDATE],
                                @ADDRESS_ENDDATE = [ADDRESS_ENDDATE],
                                @PRIMARYADDRESSEE_NAMEFORMATTYPECODEID = [PRIMARYADDRESSEE_NAMEFORMATTYPECODEID],
                                @PRIMARYADDRESSEE_NAMEFORMATFUNCTIONID = [PRIMARYADDRESSEE_NAMEFORMATFUNCTIONID],
                                @PRIMARYSALUTATION_NAMEFORMATTYPECODEID = [PRIMARYSALUTATION_NAMEFORMATTYPECODEID],
                                @PRIMARYSALUTATION_NAMEFORMATFUNCTIONID = [PRIMARYSALUTATION_NAMEFORMATFUNCTIONID],
                                @ISDECEASED = [ISDECEASED],
                                @DECEASEDDATE = [DECEASEDDATE],
                                @EDUCATIONALHISTORY_EDUCATIONALINSTITUTIONID = [EDUCATIONALHISTORY_EDUCATIONALINSTITUTIONID],
                                @EDUCATIONALHISTORY_ISPRIMARYRECORD = [EDUCATIONALHISTORY_ISPRIMARYRECORD],
                                @EDUCATIONALHISTORY_EDUCATIONALHISTORYTYPECODEID = [EDUCATIONALHISTORY_EDUCATIONALHISTORYTYPECODEID],
                                @EDUCATIONALHISTORY_EDUCATIONALHISTORYSTATUSCODEID = [EDUCATIONALHISTORY_EDUCATIONALHISTORYSTATUSCODEID],
                                @EDUCATIONALHISTORY_CONSTITUENCYSTATUSCODE = [EDUCATIONALHISTORY_CONSTITUENCYSTATUSCODE],
                                @EDUCATIONALHISTORY_CLASSOF = [EDUCATIONALHISTORY_CLASSOF],
                                @EDUCATIONALHISTORY_EDUCATIONALDEGREECODEID = [EDUCATIONALHISTORY_EDUCATIONALDEGREECODEID],
                                @EDUCATIONALHISTORY_GPA = [EDUCATIONALHISTORY_GPA],
                                @EDUCATIONALHISTORY_STARTDATE = [EDUCATIONALHISTORY_STARTDATE],
                                @EDUCATIONALHISTORY_ENDDATE = [EDUCATIONALHISTORY_ENDDATE],
                                @EDUCATIONALHISTORY_KNOWNNAME = [EDUCATIONALHISTORY_KNOWNNAME],
                                @EDUCATIONALHISTORY_FRATERNITY = [EDUCATIONALHISTORY_FRATERNITY],
                                @SPOUSEID = [SPOUSEID],
                                @SPOUSE_RELATIONSHIPTYPECODEID = [SPOUSE_RELATIONSHIPTYPECODEID],
                                @SPOUSE_RECIPROCALTYPECODEID = [SPOUSE_RECIPROCALTYPECODEID],
                                @SPOUSE_KEYNAME = [SPOUSE_KEYNAME],
                                @SPOUSE_FIRSTNAME = [SPOUSE_FIRSTNAME],
                                @SPOUSE_MIDDLENAME = [SPOUSE_MIDDLENAME],
                                @SPOUSE_MAIDENNAME = [SPOUSE_MAIDENNAME],
                                @SPOUSE_NICKNAME = [SPOUSE_NICKNAME],
                                @SPOUSE_TITLECODEID = [SPOUSE_TITLECODEID],
                                @SPOUSE_SUFFIXCODEID = [SPOUSE_SUFFIXCODEID],
                                @SPOUSE_GENDERCODE = [SPOUSE_GENDERCODE],
                                @SPOUSE_BIRTHDATE = [SPOUSE_BIRTHDATE],
                                @SPOUSE_EMAILADDRESS_EMAILADDRESSTYPECODEID = [SPOUSE_EMAILADDRESS_EMAILADDRESSTYPECODEID],
                                @SPOUSE_EMAILADDRESS_EMAILADDRESS = [SPOUSE_EMAILADDRESS_EMAILADDRESS],
                                @SPOUSE_COPY_ADDRESS = [SPOUSE_COPY_ADDRESS],
                                @SPOUSE_COPY_PHONENUMBER = [SPOUSE_COPY_PHONENUMBER],
                                @SPOUSE_COPY_EMAILADDRESS = [SPOUSE_COPY_EMAILADDRESS],
                                @PRIMARYBUSINESSID = [PRIMARYBUSINESSID],
                                @PRIMARYBUSINESS_RELATIONSHIPTYPECODEID = [PRIMARYBUSINESS_RELATIONSHIPTYPECODEID],
                                @PRIMARYBUSINESS_RECIPROCALTYPECODEID = [PRIMARYBUSINESS_RECIPROCALTYPECODEID],
                                @PRIMARYBUSINESS_KEYNAME = [PRIMARYBUSINESS_KEYNAME],
                                @PRIMARYBUSINESS_PHONE_PHONETYPECODEID = [PRIMARYBUSINESS_PHONE_PHONETYPECODEID],
                                @PRIMARYBUSINESS_PHONE_NUMBER = [PRIMARYBUSINESS_PHONE_NUMBER],
                                @PRIMARYBUSINESS_EMAILADDRESS_EMAILADDRESSTYPECODEID = [PRIMARYBUSINESS_EMAILADDRESS_EMAILADDRESSTYPECODEID],
                                @PRIMARYBUSINESS_EMAILADDRESS_EMAILADDRESS = [PRIMARYBUSINESS_EMAILADDRESS_EMAILADDRESS],
                                @PRIMARYBUSINESS_ADDRESS_ADDRESSTYPECODEID = [PRIMARYBUSINESS_ADDRESS_ADDRESSTYPECODEID],
                                @PRIMARYBUSINESS_ADDRESS_COUNTRYID = [PRIMARYBUSINESS_ADDRESS_COUNTRYID],
                                @PRIMARYBUSINESS_ADDRESS_ADDRESSBLOCK = [PRIMARYBUSINESS_ADDRESS_ADDRESSBLOCK],
                                @PRIMARYBUSINESS_ADDRESS_CITY = [PRIMARYBUSINESS_ADDRESS_CITY],
                                @PRIMARYBUSINESS_ADDRESS_STATEID = [PRIMARYBUSINESS_ADDRESS_STATEID],
                                @PRIMARYBUSINESS_ADDRESS_POSTCODE = [PRIMARYBUSINESS_ADDRESS_POSTCODE],
                                @PRIMARYBUSINESS_ADDRESS_CART = [PRIMARYBUSINESS_ADDRESS_CART],
                                @PRIMARYBUSINESS_ADDRESS_DPC = [PRIMARYBUSINESS_ADDRESS_DPC],
                                @PRIMARYBUSINESS_ADDRESS_LOT = [PRIMARYBUSINESS_ADDRESS_LOT],
                                @PRIMARYBUSINESS_ADDRESS_DONOTMAIL = [PRIMARYBUSINESS_ADDRESS_DONOTMAIL],
                                @PRIMARYBUSINESS_INDUSTRYCODEID = [PRIMARYBUSINESS_INDUSTRYCODEID],
                                @PRIMARYBUSINESS_NUMEMPLOYEES = [PRIMARYBUSINESS_NUMEMPLOYEES],
                                @PRIMARYBUSINESS_NUMSUBSIDIARIES = [PRIMARYBUSINESS_NUMSUBSIDIARIES],
                                @PRIMARYBUSINESS_WEBADDRESS = [PRIMARYBUSINESS_WEBADDRESS],
                                @PRIMARYBUSINESS_PARENTCORPID = [PRIMARYBUSINESS_PARENTCORPID],
                                @CONSTITUENCY = dbo.UFN_CONSTITUENTBATCH_GETCONSTITUENCIES_TOITEMLISTXML(ID),
                                @EDUCATIONALMAJOR = dbo.UFN_CONSTITUENTBATCH_GETEDUCATIONALMAJORS_TOITEMLISTXML(ID),
                                @EDUCATIONALMINOR = dbo.UFN_CONSTITUENTBATCH_GETEDUCATIONALMINORS_TOITEMLISTXML(ID),
                                @INTEREST = dbo.UFN_CONSTITUENTBATCH_GETINTERESTS_TOITEMLISTXML(ID),
                                @CONSTIT_SECURITY_ATTRIBUTEID = CONSTIT_SECURITY_ATTRIBUTEID,
                                @CUSTOMIDENTIFIER = [CUSTOMID],
                                @SEQUENCE = [SEQUENCE],
                                @TSLONG = [TSLONG],
                                @ADDRESS_COUNTYCODEID = [ADDRESS_COUNTYCODEID],
                                @ADDRESS_OMITFROMVALIDATION = [ADDRESS_OMITFROMVALIDATION],
                                @ADDRESS_CONGRESSIONALDISTRICTCODEID = [ADDRESS_CONGRESSIONALDISTRICTCODEID], 
                                @ADDRESS_STATEHOUSEDISTRICTCODEID = [ADDRESS_STATEHOUSEDISTRICTCODEID],
                                @ADDRESS_STATESENATEDISTRICTCODEID = [ADDRESS_STATESENATEDISTRICTCODEID],
                                @ADDRESS_LOCALPRECINCTCODEID = [ADDRESS_LOCALPRECINCTCODEID],
                                @ADDRESS_INFOSOURCECODEID = [ADDRESS_INFOSOURCECODEID],
                                @ADDRESS_REGIONCODEID = [ADDRESS_REGIONCODEID],
                                @ADDRESS_LASTVALIDATIONATTEMPTDATE = [ADDRESS_LASTVALIDATIONATTEMPTDATE],
                                @ADDRESS_VALIDATIONMESSAGE = [ADDRESS_VALIDATIONMESSAGE],
                                @ADDRESS_CERTIFICATIONDATA = [ADDRESS_CERTIFICATIONDATA]
                            from
                                dbo.BATCHCONSTITUENT
                            where
                                BATCHCONSTITUENT.ID = @ID;                            

                            return 0;