USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTBATCHROW_5

The save procedure used by the edit dataform template "Constituent Batch Row Edit Form 5".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@ISORGANIZATION	tinyint	IN	Constituent type
@KEYNAME	nvarchar(100)	IN	Last/org/group/household name
@FIRSTNAME	nvarchar(50)	IN	First name
@MIDDLENAME	nvarchar(50)	IN	Middle name
@MAIDENNAME	nvarchar(100)	IN	Maiden name
@NICKNAME	nvarchar(50)	IN	Nickname
@TITLECODEID	uniqueidentifier	IN	Title
@SUFFIXCODEID	uniqueidentifier	IN	Suffix
@BIRTHDATE	UDT_FUZZYDATE	IN	Birth date
@GENDERCODE	tinyint	IN	Gender
@WEBADDRESS	UDT_WEBADDRESS	IN	Web site address
@INDUSTRYCODEID	uniqueidentifier	IN	Industry
@PARENTCORPID	uniqueidentifier	IN	Parent org
@NUMEMPLOYEES	int	IN	No. of employees
@NUMSUBSIDIARIES	int	IN	No. of subsidiary orgs
@ADDRESS_ADDRESSTYPECODEID	uniqueidentifier	IN	Address type
@ADDRESS_COUNTRYID	uniqueidentifier	IN	Country
@ADDRESS_ADDRESSBLOCK	nvarchar(150)	IN	Address
@ADDRESS_CITY	nvarchar(50)	IN	City
@ADDRESS_STATEID	uniqueidentifier	IN	State
@ADDRESS_POSTCODE	nvarchar(12)	IN	ZIP
@ADDRESS_DONOTMAIL	bit	IN	Do not send mail to this address
@PHONES	xml	IN	Phones
@EMAILADDRESS_EMAILADDRESSTYPECODEID	uniqueidentifier	IN	Email type
@EMAILADDRESS_EMAILADDRESS	UDT_EMAILADDRESS	IN	Email address
@CUSTOMIDENTIFIER	nvarchar(100)	IN	Lookup ID
@SEQUENCE	int	IN	Sequence
@ADDRESS_CART	nvarchar(10)	IN	CART
@ADDRESS_DPC	nvarchar(8)	IN	DPC
@ADDRESS_LOT	nvarchar(5)	IN	LOT
@ADDRESS_STARTDATE	UDT_MONTHDAY	IN	Address start date
@ADDRESS_ENDDATE	UDT_MONTHDAY	IN	Address end date
@PRIMARYADDRESSEE_NAMEFORMATTYPECODEID	uniqueidentifier	IN	Addressee type
@PRIMARYADDRESSEE_NAMEFORMATFUNCTIONID	uniqueidentifier	IN	Addressee name format
@PRIMARYSALUTATION_NAMEFORMATTYPECODEID	uniqueidentifier	IN	Salutation type
@PRIMARYSALUTATION_NAMEFORMATFUNCTIONID	uniqueidentifier	IN	Salutation name format
@ISDECEASED	bit	IN	Is deceased
@DECEASEDDATE	UDT_FUZZYDATE	IN	Deceased date
@EDUCATIONALHISTORY_EDUCATIONALINSTITUTIONID	uniqueidentifier	IN	Educational institution
@EDUCATIONALHISTORY_ISPRIMARYRECORD	bit	IN	Educational is primary
@EDUCATIONALHISTORY_CONSTITUENCYSTATUSCODE	tinyint	IN	Educational status
@EDUCATIONALHISTORY_CLASSOF	UDT_YEAR	IN	Class year
@EDUCATIONALHISTORY_EDUCATIONALDEGREECODEID	uniqueidentifier	IN	Educational degree
@EDUCATIONALHISTORY_STARTDATE	UDT_FUZZYDATE	IN	Educational start date
@SPOUSEID	uniqueidentifier	IN	Spouse
@SPOUSE_RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Spouse relationship type
@SPOUSE_RECIPROCALTYPECODEID	uniqueidentifier	IN	Spouse reciprocal type
@SPOUSE_KEYNAME	nvarchar(100)	IN	Spouse last name
@SPOUSE_FIRSTNAME	nvarchar(50)	IN	Spouse first name
@SPOUSE_MIDDLENAME	nvarchar(50)	IN	Spouse middle name
@SPOUSE_MAIDENNAME	nvarchar(100)	IN	Spouse maiden name
@SPOUSE_NICKNAME	nvarchar(50)	IN	Spouse nickname
@SPOUSE_TITLECODEID	uniqueidentifier	IN	Spouse title
@SPOUSE_SUFFIXCODEID	uniqueidentifier	IN	Spouse suffix
@SPOUSE_GENDERCODE	tinyint	IN	Spouse gender
@SPOUSE_BIRTHDATE	UDT_FUZZYDATE	IN	Spouse birth date
@SPOUSE_EMAILADDRESS_EMAILADDRESSTYPECODEID	uniqueidentifier	IN	Spouse email address type
@SPOUSE_EMAILADDRESS_EMAILADDRESS	UDT_EMAILADDRESS	IN	Spouse email address
@PRIMARYBUSINESSID	uniqueidentifier	IN	Business
@PRIMARYBUSINESS_RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Business relationship type
@PRIMARYBUSINESS_RECIPROCALTYPECODEID	uniqueidentifier	IN	Business reciprocal type
@PRIMARYBUSINESS_KEYNAME	nvarchar(100)	IN	Business name
@PRIMARYBUSINESS_PHONE_PHONETYPECODEID	uniqueidentifier	IN	Business phone type
@PRIMARYBUSINESS_PHONE_NUMBER	nvarchar(100)	IN	Business phone number
@PRIMARYBUSINESS_EMAILADDRESS_EMAILADDRESSTYPECODEID	uniqueidentifier	IN	Business email type
@PRIMARYBUSINESS_EMAILADDRESS_EMAILADDRESS	UDT_EMAILADDRESS	IN	Business email address
@PRIMARYBUSINESS_ADDRESS_ADDRESSTYPECODEID	uniqueidentifier	IN	Business address type
@PRIMARYBUSINESS_ADDRESS_COUNTRYID	uniqueidentifier	IN	Business country
@PRIMARYBUSINESS_ADDRESS_ADDRESSBLOCK	nvarchar(150)	IN	Business address
@PRIMARYBUSINESS_ADDRESS_CITY	nvarchar(50)	IN	Business city
@PRIMARYBUSINESS_ADDRESS_STATEID	uniqueidentifier	IN	Business state
@PRIMARYBUSINESS_ADDRESS_POSTCODE	nvarchar(12)	IN	Business ZIP
@PRIMARYBUSINESS_ADDRESS_CART	nvarchar(10)	IN	Business CART
@PRIMARYBUSINESS_ADDRESS_DPC	nvarchar(8)	IN	Business DPC
@PRIMARYBUSINESS_ADDRESS_LOT	nvarchar(5)	IN	Business LOT
@PRIMARYBUSINESS_ADDRESS_DONOTMAIL	bit	IN	Business do not mail
@PRIMARYBUSINESS_INDUSTRYCODEID	uniqueidentifier	IN	Business industry
@PRIMARYBUSINESS_NUMEMPLOYEES	int	IN	Business no. of employees
@PRIMARYBUSINESS_NUMSUBSIDIARIES	int	IN	Business no. of subsidiary orgs
@PRIMARYBUSINESS_WEBADDRESS	UDT_WEBADDRESS	IN	Business web site address
@PRIMARYBUSINESS_PARENTCORPID	uniqueidentifier	IN	Business parent org
@CONSTITUENCY	xml	IN	User defined constituencies
@INTEREST	xml	IN	Interests
@SPOUSE_COPY_ADDRESS	bit	IN	Spouse copy address
@SPOUSE_COPY_PHONENUMBER	bit	IN	Spouse copy phone number
@SPOUSE_COPY_EMAILADDRESS	bit	IN	Spouse copy email address
@CONSTIT_SECURITY_ATTRIBUTEID	uniqueidentifier	IN	Constituent security attribute
@ADDRESS_COUNTYCODEID	uniqueidentifier	IN	County
@ADDRESS_OMITFROMVALIDATION	bit	IN	Omit from validation
@ADDRESS_CONGRESSIONALDISTRICTCODEID	uniqueidentifier	IN	Congressional district
@ADDRESS_STATEHOUSEDISTRICTCODEID	uniqueidentifier	IN	State house district
@ADDRESS_STATESENATEDISTRICTCODEID	uniqueidentifier	IN	State senate district
@ADDRESS_LOCALPRECINCTCODEID	uniqueidentifier	IN	Local precinct
@ADDRESS_INFOSOURCECODEID	uniqueidentifier	IN	Info source
@ADDRESS_REGIONCODEID	uniqueidentifier	IN	Region
@ADDRESS_LASTVALIDATIONATTEMPTDATE	datetime	IN	Last validation attempt date
@ADDRESS_VALIDATIONMESSAGE	nvarchar(200)	IN	Validation message
@ADDRESS_CERTIFICATIONDATA	int	IN	Certification data
@GROUPTYPEID	uniqueidentifier	IN	Group type
@GROUPSTARTDATE	datetime	IN	Group start date
@GROUPDESCRIPTION	nvarchar(300)	IN	Group description
@GROUPMEMBERS	xml	IN	Group members
@ADDRESS_DONOTMAILREASONCODEID	uniqueidentifier	IN	Do not mail reason
@PRIMARYBUSINESS_ADDRESS_DONOTMAILREASONCODEID	uniqueidentifier	IN	Business do not mail reason
@EDUCATIONALHISTORY_ACADEMICCATALOGPROGRAMID	uniqueidentifier	IN	Academic catalog program
@EDUCATIONALHISTORY_EDUCATIONALPROGRAMCODEID	uniqueidentifier	IN	Educational program
@EDUCATIONALHISTORY_ACADEMICCATALOGDEGREEID	uniqueidentifier	IN	Academic catalog degree
@EDUCATIONALHISTORY_EDUCATIONALAWARDCODEID	uniqueidentifier	IN	Awarded
@EDUCATIONALHISTORY_PREFERREDCLASSYEAR	UDT_YEAR	IN	Preferred class year
@EDUCATIONALHISTORY_EDUCATIONALSOURCECODEID	uniqueidentifier	IN	Source
@EDUCATIONALHISTORY_EDUCATIONALSOURCEDATE	UDT_FUZZYDATE	IN	Source date
@EDUCATIONALHISTORY_COMMENT	nvarchar(500)	IN	Comment
@AFFILIATEDADDITIONALINFORMATION	xml	IN	Affiliated additional information
@UNAFFILIATEDADDITIONALINFORMATION	xml	IN	Unaffiliated additional information
@EDUCATIONALINVOLVEMENT	xml	IN	Involvement
@ALTERNATELOOKUPIDS	xml	IN	Alternate lookup IDs
@EDUCATIONALHISTORY_DATEGRADUATED	UDT_FUZZYDATE	IN	Date graduated
@EDUCATIONALHISTORY_DATELEFT	UDT_FUZZYDATE	IN	Date left
@EDUCATIONALHISTORY_LEVELCODEID	uniqueidentifier	IN	Level
@EDUCATIONALHISTORY_REASONCODEID	uniqueidentifier	IN	Reason

Definition

Copy



                        CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTBATCHROW_5
                        (
                            @ID uniqueidentifier,
                            @CHANGEAGENTID uniqueidentifier,
                            @ISORGANIZATION tinyint,
                            @KEYNAME nvarchar(100),
                            @FIRSTNAME nvarchar(50),
                            @MIDDLENAME nvarchar(50),
                            @MAIDENNAME nvarchar(100),
                            @NICKNAME nvarchar(50),
                            @TITLECODEID uniqueidentifier,
                            @SUFFIXCODEID uniqueidentifier,
                            @BIRTHDATE dbo.UDT_FUZZYDATE,
                            @GENDERCODE tinyint,
                            @WEBADDRESS dbo.UDT_WEBADDRESS,
                            @INDUSTRYCODEID uniqueidentifier,
                            @PARENTCORPID uniqueidentifier,
                            @NUMEMPLOYEES int,
                            @NUMSUBSIDIARIES int,
                            @ADDRESS_ADDRESSTYPECODEID uniqueidentifier,
                            @ADDRESS_COUNTRYID uniqueidentifier,
                            @ADDRESS_ADDRESSBLOCK nvarchar(150),
                            @ADDRESS_CITY nvarchar(50),
                            @ADDRESS_STATEID uniqueidentifier,
                            @ADDRESS_POSTCODE nvarchar(12),
                            @ADDRESS_DONOTMAIL bit,
                            @PHONES xml,
                            @EMAILADDRESS_EMAILADDRESSTYPECODEID uniqueidentifier,
                            @EMAILADDRESS_EMAILADDRESS dbo.UDT_EMAILADDRESS,
                            @CUSTOMIDENTIFIER nvarchar(100),
                            @SEQUENCE int,
                            @ADDRESS_CART nvarchar(10),
                            @ADDRESS_DPC nvarchar(8),
                            @ADDRESS_LOT nvarchar(5),
                            @ADDRESS_STARTDATE dbo.UDT_MONTHDAY,
                            @ADDRESS_ENDDATE dbo.UDT_MONTHDAY,
                            @PRIMARYADDRESSEE_NAMEFORMATTYPECODEID uniqueidentifier,
                            @PRIMARYADDRESSEE_NAMEFORMATFUNCTIONID uniqueidentifier,
                            @PRIMARYSALUTATION_NAMEFORMATTYPECODEID uniqueidentifier,
                            @PRIMARYSALUTATION_NAMEFORMATFUNCTIONID uniqueidentifier,
                            @ISDECEASED bit,
                            @DECEASEDDATE dbo.UDT_FUZZYDATE,
                            @EDUCATIONALHISTORY_EDUCATIONALINSTITUTIONID uniqueidentifier,
                            @EDUCATIONALHISTORY_ISPRIMARYRECORD bit,
                            @EDUCATIONALHISTORY_CONSTITUENCYSTATUSCODE tinyint,
                            @EDUCATIONALHISTORY_CLASSOF dbo.UDT_YEAR,
                            @EDUCATIONALHISTORY_EDUCATIONALDEGREECODEID uniqueidentifier,
                            @EDUCATIONALHISTORY_STARTDATE dbo.UDT_FUZZYDATE,
                            @SPOUSEID uniqueidentifier,
                            @SPOUSE_RELATIONSHIPTYPECODEID uniqueidentifier,
                            @SPOUSE_RECIPROCALTYPECODEID uniqueidentifier,
                            @SPOUSE_KEYNAME nvarchar(100),
                            @SPOUSE_FIRSTNAME nvarchar(50),
                            @SPOUSE_MIDDLENAME nvarchar(50),
                            @SPOUSE_MAIDENNAME nvarchar(100),
                            @SPOUSE_NICKNAME nvarchar(50),
                            @SPOUSE_TITLECODEID uniqueidentifier,
                            @SPOUSE_SUFFIXCODEID uniqueidentifier,
                            @SPOUSE_GENDERCODE tinyint,
                            @SPOUSE_BIRTHDATE dbo.UDT_FUZZYDATE,
                            @SPOUSE_EMAILADDRESS_EMAILADDRESSTYPECODEID uniqueidentifier,
                            @SPOUSE_EMAILADDRESS_EMAILADDRESS dbo.UDT_EMAILADDRESS,
                            @PRIMARYBUSINESSID uniqueidentifier,
                            @PRIMARYBUSINESS_RELATIONSHIPTYPECODEID uniqueidentifier,
                            @PRIMARYBUSINESS_RECIPROCALTYPECODEID uniqueidentifier,
                            @PRIMARYBUSINESS_KEYNAME nvarchar(100),
                            @PRIMARYBUSINESS_PHONE_PHONETYPECODEID uniqueidentifier,
                            @PRIMARYBUSINESS_PHONE_NUMBER nvarchar(100),
                            @PRIMARYBUSINESS_EMAILADDRESS_EMAILADDRESSTYPECODEID uniqueidentifier,
                            @PRIMARYBUSINESS_EMAILADDRESS_EMAILADDRESS dbo.UDT_EMAILADDRESS,
                            @PRIMARYBUSINESS_ADDRESS_ADDRESSTYPECODEID uniqueidentifier,
                            @PRIMARYBUSINESS_ADDRESS_COUNTRYID uniqueidentifier,
                            @PRIMARYBUSINESS_ADDRESS_ADDRESSBLOCK nvarchar(150),
                            @PRIMARYBUSINESS_ADDRESS_CITY nvarchar(50),
                            @PRIMARYBUSINESS_ADDRESS_STATEID uniqueidentifier,
                            @PRIMARYBUSINESS_ADDRESS_POSTCODE nvarchar(12),
                            @PRIMARYBUSINESS_ADDRESS_CART nvarchar(10),
                            @PRIMARYBUSINESS_ADDRESS_DPC nvarchar(8),
                            @PRIMARYBUSINESS_ADDRESS_LOT nvarchar(5),
                            @PRIMARYBUSINESS_ADDRESS_DONOTMAIL bit,
                            @PRIMARYBUSINESS_INDUSTRYCODEID uniqueidentifier,
                            @PRIMARYBUSINESS_NUMEMPLOYEES int,
                            @PRIMARYBUSINESS_NUMSUBSIDIARIES int,
                            @PRIMARYBUSINESS_WEBADDRESS dbo.UDT_WEBADDRESS,
                            @PRIMARYBUSINESS_PARENTCORPID uniqueidentifier,
                            @CONSTITUENCY xml,
                            @INTEREST xml,
                            @SPOUSE_COPY_ADDRESS bit,
                            @SPOUSE_COPY_PHONENUMBER bit,
                            @SPOUSE_COPY_EMAILADDRESS bit,
                            @CONSTIT_SECURITY_ATTRIBUTEID uniqueidentifier,
                            @ADDRESS_COUNTYCODEID uniqueidentifier,
                            @ADDRESS_OMITFROMVALIDATION bit,
                            @ADDRESS_CONGRESSIONALDISTRICTCODEID uniqueidentifier,
                            @ADDRESS_STATEHOUSEDISTRICTCODEID uniqueidentifier,
                            @ADDRESS_STATESENATEDISTRICTCODEID uniqueidentifier,
                            @ADDRESS_LOCALPRECINCTCODEID uniqueidentifier,
                            @ADDRESS_INFOSOURCECODEID uniqueidentifier,
                            @ADDRESS_REGIONCODEID uniqueidentifier,
                            @ADDRESS_LASTVALIDATIONATTEMPTDATE datetime,
                            @ADDRESS_VALIDATIONMESSAGE nvarchar(200),
                            @ADDRESS_CERTIFICATIONDATA int,
                            @GROUPTYPEID uniqueidentifier,
                            @GROUPSTARTDATE datetime,
                            @GROUPDESCRIPTION nvarchar(300),
                            @GROUPMEMBERS xml,
                            @ADDRESS_DONOTMAILREASONCODEID uniqueidentifier,
                            @PRIMARYBUSINESS_ADDRESS_DONOTMAILREASONCODEID uniqueidentifier,
                            @EDUCATIONALHISTORY_ACADEMICCATALOGPROGRAMID uniqueidentifier,
                            @EDUCATIONALHISTORY_EDUCATIONALPROGRAMCODEID uniqueidentifier,
                            @EDUCATIONALHISTORY_ACADEMICCATALOGDEGREEID uniqueidentifier,
                            @EDUCATIONALHISTORY_EDUCATIONALAWARDCODEID uniqueidentifier,
                            @EDUCATIONALHISTORY_PREFERREDCLASSYEAR dbo.UDT_YEAR,
                            @EDUCATIONALHISTORY_EDUCATIONALSOURCECODEID uniqueidentifier,
                            @EDUCATIONALHISTORY_EDUCATIONALSOURCEDATE dbo.UDT_FUZZYDATE,
                            @EDUCATIONALHISTORY_COMMENT nvarchar(500),
                            @AFFILIATEDADDITIONALINFORMATION xml,
                            @UNAFFILIATEDADDITIONALINFORMATION xml,
                            @EDUCATIONALINVOLVEMENT xml,
                            @ALTERNATELOOKUPIDS xml ,
                            @EDUCATIONALHISTORY_DATEGRADUATED dbo.UDT_FUZZYDATE,
                            @EDUCATIONALHISTORY_DATELEFT dbo.UDT_FUZZYDATE,
                            @EDUCATIONALHISTORY_LEVELCODEID uniqueidentifier,
                            @EDUCATIONALHISTORY_REASONCODEID uniqueidentifier
                        ) as
                            set nocount on;

                            declare @CURRENTDATE datetime;

                            if @CHANGEAGENTID is null
                                exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                            set @CURRENTDATE = getdate();

                            if @BIRTHDATE is null
                            set @BIRTHDATE = '00000000';

                            if @GENDERCODE is null
                                set @GENDERCODE = 0;

                            if @NUMEMPLOYEES is null
                                set @NUMEMPLOYEES = 0;

                            if @NUMSUBSIDIARIES is null
                                set @NUMSUBSIDIARIES = 0;

                            if @EDUCATIONALHISTORY_CONSTITUENCYSTATUSCODE is null
                                set @EDUCATIONALHISTORY_CONSTITUENCYSTATUSCODE = 0;

                            if @EDUCATIONALHISTORY_CLASSOF is null
                                set @EDUCATIONALHISTORY_CLASSOF = 0;

                            if @SPOUSE_GENDERCODE is null
                                set @SPOUSE_GENDERCODE = 0;

                            if @PRIMARYBUSINESS_NUMEMPLOYEES is null
                                set @PRIMARYBUSINESS_NUMEMPLOYEES = 0;

                            if @PRIMARYBUSINESS_NUMSUBSIDIARIES is null
                                set @PRIMARYBUSINESS_NUMSUBSIDIARIES = 0;

                            if ((@ADDRESS_ADDRESSTYPECODEID is not null) or (@ADDRESS_STATEID is not null) or
                                    (coalesce(@ADDRESS_ADDRESSBLOCK,'') <> '') or (coalesce(@ADDRESS_CITY,'') <> '') or
                                    (coalesce(@ADDRESS_POSTCODE,'') <> '')) and @ADDRESS_COUNTRYID is null
                                exec @ADDRESS_COUNTRYID = dbo.UFN_COUNTRY_GETDEFAULT;

                            if ((@PRIMARYBUSINESS_ADDRESS_ADDRESSTYPECODEID is not null) or (@PRIMARYBUSINESS_ADDRESS_STATEID is not null) or
                                    (coalesce(@PRIMARYBUSINESS_ADDRESS_ADDRESSBLOCK,'') <> '') or (coalesce(@PRIMARYBUSINESS_ADDRESS_CITY,'') <> '') or
                                    (coalesce(@PRIMARYBUSINESS_ADDRESS_POSTCODE,'') <> '')) and @PRIMARYBUSINESS_ADDRESS_COUNTRYID is null
                                exec @PRIMARYBUSINESS_ADDRESS_COUNTRYID = dbo.UFN_COUNTRY_GETDEFAULT;

                            if @ADDRESS_DONOTMAIL = 0
                                set @ADDRESS_DONOTMAILREASONCODEID = null

                            if @PRIMARYBUSINESS_ADDRESS_DONOTMAIL = 0
                                set @PRIMARYBUSINESS_ADDRESS_DONOTMAILREASONCODEID = null

                            if @EDUCATIONALHISTORY_COMMENT is null
                                set @EDUCATIONALHISTORY_COMMENT = '';

                            if @EDUCATIONALHISTORY_PREFERREDCLASSYEAR is null
                                set @EDUCATIONALHISTORY_PREFERREDCLASSYEAR = 0;

                            if @EDUCATIONALHISTORY_EDUCATIONALSOURCEDATE is null
                                set @EDUCATIONALHISTORY_EDUCATIONALSOURCEDATE = '00000000';

                            if @EDUCATIONALHISTORY_DATEGRADUATED is null
                                set @EDUCATIONALHISTORY_DATEGRADUATED = '00000000';

                            if @EDUCATIONALHISTORY_DATELEFT is null
                                set @EDUCATIONALHISTORY_DATELEFT = '00000000';

                            begin try                                
                                update
                                    dbo.BATCHCONSTITUENT 
                                set
                                    [ISORGANIZATION] = case when @ISORGANIZATION = 1 then 1 else 0 end,
                                    [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,
                                    [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_CONSTITUENCYSTATUSCODE] = @EDUCATIONALHISTORY_CONSTITUENCYSTATUSCODE,
                                    [EDUCATIONALHISTORY_CLASSOF] = @EDUCATIONALHISTORY_CLASSOF,
                                    [EDUCATIONALHISTORY_EDUCATIONALDEGREECODEID] = @EDUCATIONALHISTORY_EDUCATIONALDEGREECODEID,
                                    [EDUCATIONALHISTORY_STARTDATE] = @EDUCATIONALHISTORY_STARTDATE,
                                    [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,
                                    [CONSTIT_SECURITY_ATTRIBUTEID] = @CONSTIT_SECURITY_ATTRIBUTEID,
                                    [CUSTOMID] = @CUSTOMIDENTIFIER,
                                    -- ISORGANIZATION = {0 => Individual, 1 => Organization, 2 => Household, 3 => Custom group}

                                      [GROUPTYPECODE] = case 
                                      when @ISORGANIZATION = 2 then 0
                                      when @ISORGANIZATION = 3 then 1
                                      else 0
                                    end,
                                    [GROUPTYPEID] = @GROUPTYPEID,
                                    [GROUPSTARTDATE] = @GROUPSTARTDATE,
                                    [GROUPDESCRIPTION] = @GROUPDESCRIPTION,
                                    [SEQUENCE] = @SEQUENCE,
                                    [CHANGEDBYID] = @CHANGEAGENTID,
                                    [DATECHANGED] = @CURRENTDATE,
                                    [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,
                                    [ADDRESS_DONOTMAILREASONCODEID] = @ADDRESS_DONOTMAILREASONCODEID,
                                    [PRIMARYBUSINESS_ADDRESS_DONOTMAILREASONCODEID] = @PRIMARYBUSINESS_ADDRESS_DONOTMAILREASONCODEID,
                                    [EDUCATIONALHISTORY_ACADEMICCATALOGPROGRAMID] = @EDUCATIONALHISTORY_ACADEMICCATALOGPROGRAMID,
                                    [EDUCATIONALHISTORY_EDUCATIONALPROGRAMCODEID] = @EDUCATIONALHISTORY_EDUCATIONALPROGRAMCODEID,
                                    [EDUCATIONALHISTORY_ACADEMICCATALOGDEGREEID] = @EDUCATIONALHISTORY_ACADEMICCATALOGDEGREEID,
                                    [EDUCATIONALHISTORY_EDUCATIONALAWARDCODEID] = @EDUCATIONALHISTORY_EDUCATIONALAWARDCODEID,
                                    [EDUCATIONALHISTORY_PREFERREDCLASSYEAR] = @EDUCATIONALHISTORY_PREFERREDCLASSYEAR,
                                    [EDUCATIONALHISTORY_EDUCATIONALSOURCECODEID] = @EDUCATIONALHISTORY_EDUCATIONALSOURCECODEID,
                                    [EDUCATIONALHISTORY_EDUCATIONALSOURCEDATE] = @EDUCATIONALHISTORY_EDUCATIONALSOURCEDATE,
                                    [EDUCATIONALHISTORY_COMMENT] = @EDUCATIONALHISTORY_COMMENT,
                                    [EDUCATIONALHISTORY_DATEGRADUATED] = @EDUCATIONALHISTORY_DATEGRADUATED,
                                    [EDUCATIONALHISTORY_DATELEFT] = @EDUCATIONALHISTORY_DATELEFT,
                                    [EDUCATIONALHISTORY_LEVELCODEID] = @EDUCATIONALHISTORY_LEVELCODEID,
                                    [EDUCATIONALHISTORY_REASONCODEID] = @EDUCATIONALHISTORY_REASONCODEID
                                where ID = @ID;

                                exec dbo.USP_CONSTITUENTBATCH_GETPHONES_UPDATEFROMXML @ID, @PHONES, @CHANGEAGENTID;
                                exec dbo.USP_CONSTITUENTBATCH_GETCONSTITUENCIES_UPDATEFROMXML @ID, @CONSTITUENCY, @CHANGEAGENTID;
                                exec dbo.USP_CONSTITUENTBATCH_GETINTERESTS_UPDATEFROMXML @ID, @INTEREST, @CHANGEAGENTID;
                                exec dbo.USP_CONSTITUENTBATCH_GETGROUPMEMBERS_UPDATEFROMXML @ID, @GROUPMEMBERS, @CHANGEAGENTID;
                                exec dbo.USP_CONSTITUENTBATCH_GETEDUCATIONAFFILIATEDADDITIONALINFORMATION_UPDATEFROMXML @ID, @AFFILIATEDADDITIONALINFORMATION, @CHANGEAGENTID;
                                exec dbo.USP_CONSTITUENTBATCH_GETEDUCATIONUNAFFILIATEDADDITIONALINFORMATION_UPDATEFROMXML @ID, @UNAFFILIATEDADDITIONALINFORMATION, @CHANGEAGENTID;
                                exec dbo.USP_CONSTITUENTBATCH_GETEDUCATIONALINVOLVEMENT_UPDATEFROMXML @ID, @EDUCATIONALINVOLVEMENT, @CHANGEAGENTID;
                                exec dbo.USP_CONSTITUENTBATCH_GETBATCHALTERNATELOOKUPIDS_UPDATEFROMXML @ID, @ALTERNATELOOKUPIDS, @CHANGEAGENTID;
                            end try
                            begin catch
                                exec dbo.USP_RAISE_ERROR;
                                return 1;
                            end catch

                            return 0;