USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTBATCHROW_16

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

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	Seasonal start date
@ADDRESS_ENDDATE	UDT_MONTHDAY	IN	Seasonal 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 of
@EDUCATIONALHISTORY_EDUCATIONALDEGREECODEID	uniqueidentifier	IN	Educational degree
@EDUCATIONALHISTORY_STARTDATE	UDT_FUZZYDATE	IN	Educational date from
@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_PHONE_COUNTRYID	uniqueidentifier	IN	Business phone country
@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	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	Constituent information 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 consolidation 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	Honor awarded
@EDUCATIONALHISTORY_PREFERREDCLASSYEAR	UDT_YEAR	IN	Preferred class of
@EDUCATIONALHISTORY_EDUCATIONALSOURCECODEID	uniqueidentifier	IN	Information source
@EDUCATIONALHISTORY_EDUCATIONALSOURCEDATE	UDT_FUZZYDATE	IN	Source date
@EDUCATIONALHISTORY_COMMENT	nvarchar(500)	IN	Comments
@AFFILIATEDADDITIONALINFORMATION	xml	IN	Academic catalog additional information
@UNAFFILIATEDADDITIONALINFORMATION	xml	IN	Educational 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
@ISPRIMARYORGANIZATION	bit	IN	Is primary org
@PRIMARYBUSINESS_ISPRIMARYORGANIZATION	bit	IN	Business is primary org
@CONSTITUENT_SITEID	uniqueidentifier	IN	Constituent site
@TAXDECLARATIONS	xml	IN	Declarations
@ADDRESS_HISTORICALSTARTDATE	date	IN	Address start date
@PRIMARYMEMBER_COPYCONTACTINFO	bit	IN	Use primary member contact info
@PRIMARYBUSINESS_JOBTITLE	nvarchar(100)	IN	Business job title
@PRIMARYBUSINESS_JOBCATEGORYCODEID	uniqueidentifier	IN	Business job category
@PRIMARYBUSINESS_CAREERLEVELCODEID	uniqueidentifier	IN	Business career level
@PRIMARYBUSINESS_ADDRESS_INFOSOURCECODEID	uniqueidentifier	IN	Business information source
@TITLE2CODEID	uniqueidentifier	IN	Title 2
@SUFFIX2CODEID	uniqueidentifier	IN	Suffix 2
@SPOUSE_TITLE2CODEID	uniqueidentifier	IN	Spouse title 2
@SPOUSE_SUFFIX2CODEID	uniqueidentifier	IN	Spouse suffix 2
@SOLICITCODES	xml	IN	Solicit codes
@PRIMARYBUSINESS_JOBDIVISION	nvarchar(100)	IN	Business job division
@PRIMARYBUSINESS_JOBDEPARTMENT	nvarchar(100)	IN	Business job department
@PRIMARYBUSINESS_JOBSCHEDULECODEID	uniqueidentifier	IN	Business job schedule
@SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST	uniqueidentifier	IN	Spouse relationship type
@SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST	uniqueidentifier	IN	Spouse reciprocal type
@PRIMARYBUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST	uniqueidentifier	IN	Business relationship type
@PRIMARYBUSINESS_RECIPROCALTYPECODEIDSIMPLELIST	uniqueidentifier	IN	Business reciprocal type
@ETHNICITYCODEID	uniqueidentifier	IN	Ethnicity
@RELIGIONCODEID	uniqueidentifier	IN	Religion
@TARGETCODEID	uniqueidentifier	IN	Target
@INCOMECODEID	uniqueidentifier	IN	Income
@BIRTHPLACE	nvarchar(50)	IN	Birthplace
@PRIMARYBUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS	bit	IN	Apply recognition from business
@PRIMARYBUSINESS_PRIMARYSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN	Recognition from business match percent
@PRIMARYBUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS	bit	IN	Apply recognition to business
@PRIMARYBUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN	Recognition to business match percent
@PRIMARYBUSINESS_PRIMARYRECOGNITIONTYPECODEID	uniqueidentifier	IN	Recognition from business type
@PRIMARYBUSINESS_RECIPROCALRECOGNITIONTYPECODEID	uniqueidentifier	IN	Recognition to business type
@EMAILADDRESS_STARTDATE	date	IN	Email address start date
@SPOUSE_EMAILADDRESS_STARTDATE	date	IN	Spouse email address start date
@PRIMARYBUSINESS_EMAILADDRESS_STARTDATE	date	IN	Business email address start date
@SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS	bit	IN	Apply recognition from spouse
@SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN	Recognition from spouse match percent
@SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS	bit	IN	Apply recognition to spouse
@SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN	Recognition to spouse match percent
@SPOUSE_PRIMARYRECOGNITIONTYPECODEID	uniqueidentifier	IN	Recognition from spouse type
@SPOUSE_RECIPROCALRECOGNITIONTYPECODEID	uniqueidentifier	IN	Recognition to spouse type

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTBATCHROW_16
(
    @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_PHONE_COUNTRYID uniqueidentifier,
    @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,
    @ISPRIMARYORGANIZATION bit,
    @PRIMARYBUSINESS_ISPRIMARYORGANIZATION bit,
    @CONSTITUENT_SITEID uniqueidentifier,
    @TAXDECLARATIONS xml,
    @ADDRESS_HISTORICALSTARTDATE date,
    @PRIMARYMEMBER_COPYCONTACTINFO bit,
    @PRIMARYBUSINESS_JOBTITLE nvarchar(100),
    @PRIMARYBUSINESS_JOBCATEGORYCODEID uniqueidentifier,
    @PRIMARYBUSINESS_CAREERLEVELCODEID uniqueidentifier,
    @PRIMARYBUSINESS_ADDRESS_INFOSOURCECODEID uniqueidentifier,
    @TITLE2CODEID uniqueidentifier,
    @SUFFIX2CODEID uniqueidentifier,
    @SPOUSE_TITLE2CODEID uniqueidentifier,
    @SPOUSE_SUFFIX2CODEID uniqueidentifier,
    @SOLICITCODES xml,
    @PRIMARYBUSINESS_JOBDIVISION nvarchar(100),
    @PRIMARYBUSINESS_JOBDEPARTMENT nvarchar(100),
    @PRIMARYBUSINESS_JOBSCHEDULECODEID uniqueidentifier,
    @SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST uniqueidentifier,
    @SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST uniqueidentifier,
    @PRIMARYBUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST uniqueidentifier,
    @PRIMARYBUSINESS_RECIPROCALTYPECODEIDSIMPLELIST uniqueidentifier,
    @ETHNICITYCODEID uniqueidentifier,
    @RELIGIONCODEID uniqueidentifier,
    @TARGETCODEID uniqueidentifier,
    @INCOMECODEID uniqueidentifier,
    @BIRTHPLACE nvarchar(50),
    @PRIMARYBUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit,
    @PRIMARYBUSINESS_PRIMARYSOFTCREDITMATCHFACTOR decimal(5,2),
    @PRIMARYBUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit,
    @PRIMARYBUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR decimal(5,2),
    @PRIMARYBUSINESS_PRIMARYRECOGNITIONTYPECODEID uniqueidentifier,
    @PRIMARYBUSINESS_RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier,
    @EMAILADDRESS_STARTDATE date,
    @SPOUSE_EMAILADDRESS_STARTDATE date,
    @PRIMARYBUSINESS_EMAILADDRESS_STARTDATE date,
    @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit,
    @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR decimal(5,2),
    @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit,
    @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR decimal(5,2),
    @SPOUSE_PRIMARYRECOGNITIONTYPECODEID uniqueidentifier,
    @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier
) as
begin
    set nocount on;

    declare @PRIMARYBUSINESS_STARTDATE date;
    declare @SPOUSE_STARTDATE date;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTBATCHROW_10
        @ID = @ID,
        @PRIMARYBUSINESS_STARTDATE = @PRIMARYBUSINESS_STARTDATE output, 
        @SPOUSE_STARTDATE = @SPOUSE_STARTDATE output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTBATCHROW_17
        @ID,
        @CHANGEAGENTID,
        @ISORGANIZATION,
        @KEYNAME,
        @FIRSTNAME,
        @MIDDLENAME,
        @MAIDENNAME,
        @NICKNAME,
        @TITLECODEID,
        @SUFFIXCODEID,
        @BIRTHDATE,
        @GENDERCODE,
        @WEBADDRESS,
        @INDUSTRYCODEID,
        @PARENTCORPID,
        @NUMEMPLOYEES,
        @NUMSUBSIDIARIES,
        @ADDRESS_ADDRESSTYPECODEID,
        @ADDRESS_COUNTRYID,
        @ADDRESS_ADDRESSBLOCK,
        @ADDRESS_CITY,
        @ADDRESS_STATEID,
        @ADDRESS_POSTCODE,
        @ADDRESS_DONOTMAIL,
        @PHONES,
        @EMAILADDRESS_EMAILADDRESSTYPECODEID,
        @EMAILADDRESS_EMAILADDRESS,
        @CUSTOMIDENTIFIER,
        @SEQUENCE,
        @ADDRESS_CART,
        @ADDRESS_DPC,
        @ADDRESS_LOT,
        @ADDRESS_STARTDATE,
        @ADDRESS_ENDDATE,
        @PRIMARYADDRESSEE_NAMEFORMATTYPECODEID,
        @PRIMARYADDRESSEE_NAMEFORMATFUNCTIONID,
        @PRIMARYSALUTATION_NAMEFORMATTYPECODEID,
        @PRIMARYSALUTATION_NAMEFORMATFUNCTIONID,
        @ISDECEASED,
        @DECEASEDDATE,
        @EDUCATIONALHISTORY_EDUCATIONALINSTITUTIONID,
        @EDUCATIONALHISTORY_ISPRIMARYRECORD,
        @EDUCATIONALHISTORY_CONSTITUENCYSTATUSCODE,
        @EDUCATIONALHISTORY_CLASSOF,
        @EDUCATIONALHISTORY_EDUCATIONALDEGREECODEID,
        @EDUCATIONALHISTORY_STARTDATE,
        @SPOUSEID,
        @SPOUSE_RELATIONSHIPTYPECODEID,
        @SPOUSE_RECIPROCALTYPECODEID,
        @SPOUSE_KEYNAME,
        @SPOUSE_FIRSTNAME,
        @SPOUSE_MIDDLENAME,
        @SPOUSE_MAIDENNAME,
        @SPOUSE_NICKNAME,
        @SPOUSE_TITLECODEID,
        @SPOUSE_SUFFIXCODEID,
        @SPOUSE_GENDERCODE,
        @SPOUSE_BIRTHDATE,
        @SPOUSE_EMAILADDRESS_EMAILADDRESSTYPECODEID,
        @SPOUSE_EMAILADDRESS_EMAILADDRESS,
        @PRIMARYBUSINESSID,
        @PRIMARYBUSINESS_RELATIONSHIPTYPECODEID,
        @PRIMARYBUSINESS_RECIPROCALTYPECODEID,
        @PRIMARYBUSINESS_KEYNAME,
        @PRIMARYBUSINESS_PHONE_PHONETYPECODEID,
        @PRIMARYBUSINESS_PHONE_NUMBER,
        @PRIMARYBUSINESS_PHONE_COUNTRYID,
        @PRIMARYBUSINESS_EMAILADDRESS_EMAILADDRESSTYPECODEID,
        @PRIMARYBUSINESS_EMAILADDRESS_EMAILADDRESS,
        @PRIMARYBUSINESS_ADDRESS_ADDRESSTYPECODEID,
        @PRIMARYBUSINESS_ADDRESS_COUNTRYID,
        @PRIMARYBUSINESS_ADDRESS_ADDRESSBLOCK,
        @PRIMARYBUSINESS_ADDRESS_CITY,
        @PRIMARYBUSINESS_ADDRESS_STATEID,
        @PRIMARYBUSINESS_ADDRESS_POSTCODE,
        @PRIMARYBUSINESS_ADDRESS_CART,
        @PRIMARYBUSINESS_ADDRESS_DPC,
        @PRIMARYBUSINESS_ADDRESS_LOT,
        @PRIMARYBUSINESS_ADDRESS_DONOTMAIL,
        @PRIMARYBUSINESS_INDUSTRYCODEID,
        @PRIMARYBUSINESS_NUMEMPLOYEES,
        @PRIMARYBUSINESS_NUMSUBSIDIARIES,
        @PRIMARYBUSINESS_WEBADDRESS,
        @PRIMARYBUSINESS_PARENTCORPID,
        @CONSTITUENCY,
        @INTEREST,
        @SPOUSE_COPY_ADDRESS,
        @SPOUSE_COPY_PHONENUMBER,
        @SPOUSE_COPY_EMAILADDRESS,
        @CONSTIT_SECURITY_ATTRIBUTEID,
        @ADDRESS_COUNTYCODEID,
        @ADDRESS_OMITFROMVALIDATION,
        @ADDRESS_CONGRESSIONALDISTRICTCODEID,
        @ADDRESS_STATEHOUSEDISTRICTCODEID,
        @ADDRESS_STATESENATEDISTRICTCODEID,
        @ADDRESS_LOCALPRECINCTCODEID,
        @ADDRESS_INFOSOURCECODEID,
        @ADDRESS_REGIONCODEID,
        @ADDRESS_LASTVALIDATIONATTEMPTDATE,
        @ADDRESS_VALIDATIONMESSAGE,
        @ADDRESS_CERTIFICATIONDATA,
        @GROUPTYPEID,
        @GROUPSTARTDATE,
        @GROUPDESCRIPTION,
        @GROUPMEMBERS,
        @ADDRESS_DONOTMAILREASONCODEID,
        @PRIMARYBUSINESS_ADDRESS_DONOTMAILREASONCODEID,
        @EDUCATIONALHISTORY_ACADEMICCATALOGPROGRAMID,
        @EDUCATIONALHISTORY_EDUCATIONALPROGRAMCODEID,
        @EDUCATIONALHISTORY_ACADEMICCATALOGDEGREEID,
        @EDUCATIONALHISTORY_EDUCATIONALAWARDCODEID,
        @EDUCATIONALHISTORY_PREFERREDCLASSYEAR,
        @EDUCATIONALHISTORY_EDUCATIONALSOURCECODEID,
        @EDUCATIONALHISTORY_EDUCATIONALSOURCEDATE,
        @EDUCATIONALHISTORY_COMMENT,
        @AFFILIATEDADDITIONALINFORMATION,
        @UNAFFILIATEDADDITIONALINFORMATION,
        @EDUCATIONALINVOLVEMENT,
        @ALTERNATELOOKUPIDS,
        @EDUCATIONALHISTORY_DATEGRADUATED,
        @EDUCATIONALHISTORY_DATELEFT,
        @EDUCATIONALHISTORY_LEVELCODEID,
        @EDUCATIONALHISTORY_REASONCODEID,
        @ISPRIMARYORGANIZATION,
        @PRIMARYBUSINESS_ISPRIMARYORGANIZATION,
        @CONSTITUENT_SITEID,
        @TAXDECLARATIONS,
        @ADDRESS_HISTORICALSTARTDATE,
        @PRIMARYMEMBER_COPYCONTACTINFO,
        @PRIMARYBUSINESS_JOBTITLE,
        @PRIMARYBUSINESS_JOBCATEGORYCODEID,
        @PRIMARYBUSINESS_CAREERLEVELCODEID,
        @PRIMARYBUSINESS_ADDRESS_INFOSOURCECODEID,
        @TITLE2CODEID,
        @SUFFIX2CODEID,
        @SPOUSE_TITLE2CODEID,
        @SPOUSE_SUFFIX2CODEID,
        @SOLICITCODES,
        @PRIMARYBUSINESS_JOBDIVISION,
        @PRIMARYBUSINESS_JOBDEPARTMENT,
        @PRIMARYBUSINESS_JOBSCHEDULECODEID,
        @SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST,
        @SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST,
        @PRIMARYBUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST,
        @PRIMARYBUSINESS_RECIPROCALTYPECODEIDSIMPLELIST,
        @ETHNICITYCODEID,
        @RELIGIONCODEID,
        @TARGETCODEID,
        @INCOMECODEID,
        @BIRTHPLACE,
        @PRIMARYBUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
        @PRIMARYBUSINESS_PRIMARYSOFTCREDITMATCHFACTOR,
        @PRIMARYBUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
        @PRIMARYBUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR,
        @PRIMARYBUSINESS_PRIMARYRECOGNITIONTYPECODEID,
        @PRIMARYBUSINESS_RECIPROCALRECOGNITIONTYPECODEID,
        @EMAILADDRESS_STARTDATE,
        @SPOUSE_EMAILADDRESS_STARTDATE,
        @PRIMARYBUSINESS_EMAILADDRESS_STARTDATE,
        @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
        @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR,
        @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
        @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR,
        @SPOUSE_PRIMARYRECOGNITIONTYPECODEID,
        @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID,
        @PRIMARYBUSINESS_STARTDATE,
        @SPOUSE_STARTDATE

        return 0;
end