USP_DATAFORMTEMPLATE_EDIT_BATCHCONSTITUENTUPDATEBATCHROW_8

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SEQUENCE	int	IN
@PRIMARYRECORDID	uniqueidentifier	IN
@CONSTITUENTTYPECODE	tinyint	IN
@BIRTHDATE	UDT_FUZZYDATE	IN
@FIRSTNAME	nvarchar(50)	IN
@GENDERCODE	tinyint	IN
@GIVESANONYMOUSLY	bit	IN
@KEYNAME	nvarchar(100)	IN
@LOOKUP_ID	nvarchar(100)	IN
@MAIDENNAME	nvarchar(100)	IN
@MIDDLENAME	nvarchar(50)	IN
@NICKNAME	nvarchar(50)	IN
@SUFFIXCODEID	uniqueidentifier	IN
@TITLECODEID	uniqueidentifier	IN
@WEBADDRESS	UDT_WEBADDRESS	IN
@ALTERNATELOOKUPIDS	xml	IN
@SECURITYATTRIBUTES	xml	IN
@DECEASED	bit	IN
@DECEASEDDATE	UDT_FUZZYDATE	IN
@CONSTITUENT_SITEID	uniqueidentifier	IN
@INTERESTS	xml	IN
@PROSPECTMANAGERFUNDRAISERID	uniqueidentifier	IN
@ADDRESSES	xml	IN
@PHONES	xml	IN
@EMAILADDRESSES	xml	IN
@CONSTITUENCIES	xml	IN
@GROUPTYPEID	uniqueidentifier	IN
@GROUPDESCRIPTION	nvarchar(300)	IN
@GROUPSTARTDATE	datetime	IN
@ORG_INDUSTRYCODEID	uniqueidentifier	IN
@ORG_NUMEMPLOYEES	int	IN
@ORG_NUMSUBSIDIARIES	int	IN
@ORG_PARENTCORPID	uniqueidentifier	IN
@MARITALSTATUSCODEID	uniqueidentifier	IN
@SPOUSE_ID	uniqueidentifier	IN
@SPOUSE_TITLECODEID	uniqueidentifier	IN
@SPOUSE_FIRSTNAME	nvarchar(50)	IN
@SPOUSE_NICKNAME	nvarchar(50)	IN
@SPOUSE_MIDDLENAME	nvarchar(50)	IN
@SPOUSE_MAIDENNAME	nvarchar(100)	IN
@SPOUSE_LASTNAME	nvarchar(100)	IN
@SPOUSE_SUFFIXCODEID	uniqueidentifier	IN
@SPOUSE_BIRTHDATE	UDT_FUZZYDATE	IN
@SPOUSE_GENDERCODE	tinyint	IN
@SPOUSE_LOOKUPID	nvarchar(100)	IN
@SPOUSE_RELATIONSHIPTYPECODEID	uniqueidentifier	IN
@SPOUSE_RECIPROCALTYPECODEID	uniqueidentifier	IN
@BUSINESS_ID	uniqueidentifier	IN
@BUSINESS_ADDRESSBLOCK	nvarchar(150)	IN
@BUSINESS_ADDRESSTYPECODEID	uniqueidentifier	IN
@BUSINESS_CART	nvarchar(10)	IN
@BUSINESS_CITY	nvarchar(50)	IN
@BUSINESS_COUNTRYID	uniqueidentifier	IN
@BUSINESS_DONOTMAIL	bit	IN
@BUSINESS_DONOTMAILREASONCODEID	uniqueidentifier	IN
@BUSINESS_DPC	nvarchar(8)	IN
@BUSINESS_EMAILADDRESS	UDT_EMAILADDRESS	IN
@BUSINESS_EMAILADDRESSTYPECODEID	uniqueidentifier	IN
@BUSINESS_INDUSTRYCODEID	uniqueidentifier	IN
@BUSINESS_LOOKUPID	nvarchar(100)	IN
@BUSINESS_LOT	nvarchar(5)	IN
@BUSINESS_NAME	nvarchar(100)	IN
@BUSINESS_NUMEMPLOYEES	int	IN
@BUSINESS_NUMSUBSIDIARIES	int	IN
@BUSINESS_PARENTCORPID	uniqueidentifier	IN
@BUSINESS_PHONENUMBER	nvarchar(100)	IN
@BUSINESS_PHONE_COUNTRYID	uniqueidentifier	IN
@BUSINESS_PHONETYPECODEID	uniqueidentifier	IN
@BUSINESS_RELATIONSHIPTYPECODEID	uniqueidentifier	IN
@BUSINESS_RECIPROCALTYPECODEID	uniqueidentifier	IN
@BUSINESS_STATEID	uniqueidentifier	IN
@BUSINESS_WEBADDRESS	UDT_WEBADDRESS	IN
@BUSINESS_POSTCODE	nvarchar(12)	IN
@SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST	uniqueidentifier	IN
@SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST	uniqueidentifier	IN
@BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST	uniqueidentifier	IN
@BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST	uniqueidentifier	IN
@BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS	bit	IN
@BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN
@BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS	bit	IN
@BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN
@BUSINESS_PRIMARYRECOGNITIONTYPECODEID	uniqueidentifier	IN
@BUSINESS_RECIPROCALRECOGNITIONTYPECODEID	uniqueidentifier	IN
@BUSINESS_EMAILADDRESSSTARTDATE	date	IN
@SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS	bit	IN
@SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN
@SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS	bit	IN
@SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN
@SPOUSE_PRIMARYRECOGNITIONTYPECODEID	uniqueidentifier	IN
@SPOUSE_RECIPROCALRECOGNITIONTYPECODEID	uniqueidentifier	IN
@CONSTITUENT_SITES	xml	IN
@SPOUSE_ALTERNATELOOKUPIDS	xml	IN
@SPOUSE_IMPORTLOOKUPID	nvarchar(100)	IN
@ROWFROMBATCHUI	bit	IN
@BBNCTRANID	int	IN

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHCONSTITUENTUPDATEBATCHROW_8
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @SEQUENCE int,
                @PRIMARYRECORDID uniqueidentifier, 
                @CONSTITUENTTYPECODE tinyint,
                @BIRTHDATE dbo.UDT_FUZZYDATE,
                @FIRSTNAME nvarchar(50),
                @GENDERCODE tinyint,
                @GIVESANONYMOUSLY bit,
                @KEYNAME nvarchar(100),
                @LOOKUP_ID nvarchar(100),
                @MAIDENNAME nvarchar(100),
                @MIDDLENAME nvarchar(50),
                @NICKNAME nvarchar(50),
                @SUFFIXCODEID uniqueidentifier,
                @TITLECODEID uniqueidentifier,
                @WEBADDRESS dbo.UDT_WEBADDRESS,
                @ALTERNATELOOKUPIDS xml,
                @SECURITYATTRIBUTES xml,
                @DECEASED bit,
                @DECEASEDDATE dbo.UDT_FUZZYDATE,
                @CONSTITUENT_SITEID uniqueidentifier,
                @INTERESTS xml,
                @PROSPECTMANAGERFUNDRAISERID uniqueidentifier,
                @ADDRESSES xml,
                @PHONES xml,
                @EMAILADDRESSES xml,
                @CONSTITUENCIES xml,
                @GROUPTYPEID uniqueidentifier,
                @GROUPDESCRIPTION nvarchar(300),
                @GROUPSTARTDATE datetime,
                @ORG_INDUSTRYCODEID uniqueidentifier,
                @ORG_NUMEMPLOYEES int,
                @ORG_NUMSUBSIDIARIES int,
                @ORG_PARENTCORPID uniqueidentifier,
                @MARITALSTATUSCODEID uniqueidentifier,
                @SPOUSE_ID uniqueidentifier,
                @SPOUSE_TITLECODEID uniqueidentifier,
                @SPOUSE_FIRSTNAME nvarchar(50),
                @SPOUSE_NICKNAME nvarchar(50),
                @SPOUSE_MIDDLENAME nvarchar(50),
                @SPOUSE_MAIDENNAME nvarchar(100),
                @SPOUSE_LASTNAME nvarchar(100),
                @SPOUSE_SUFFIXCODEID uniqueidentifier,
                @SPOUSE_BIRTHDATE dbo.UDT_FUZZYDATE,
                @SPOUSE_GENDERCODE tinyint,
                @SPOUSE_LOOKUPID nvarchar(100),
                @SPOUSE_RELATIONSHIPTYPECODEID uniqueidentifier,
                @SPOUSE_RECIPROCALTYPECODEID uniqueidentifier,
                @BUSINESS_ID uniqueidentifier,
                @BUSINESS_ADDRESSBLOCK nvarchar(150),
                @BUSINESS_ADDRESSTYPECODEID uniqueidentifier,
                @BUSINESS_CART nvarchar(10),
                @BUSINESS_CITY nvarchar(50),
                @BUSINESS_COUNTRYID uniqueidentifier,
                @BUSINESS_DONOTMAIL bit,
                @BUSINESS_DONOTMAILREASONCODEID uniqueidentifier,
                @BUSINESS_DPC nvarchar(8),
                @BUSINESS_EMAILADDRESS dbo.UDT_EMAILADDRESS,
                @BUSINESS_EMAILADDRESSTYPECODEID uniqueidentifier,
                @BUSINESS_INDUSTRYCODEID uniqueidentifier,
                @BUSINESS_LOOKUPID nvarchar(100),
                @BUSINESS_LOT nvarchar(5),
                @BUSINESS_NAME nvarchar(100),
                @BUSINESS_NUMEMPLOYEES int,
                @BUSINESS_NUMSUBSIDIARIES int,
                @BUSINESS_PARENTCORPID uniqueidentifier,
                @BUSINESS_PHONENUMBER nvarchar(100),
                @BUSINESS_PHONE_COUNTRYID uniqueidentifier,
                @BUSINESS_PHONETYPECODEID uniqueidentifier,
                @BUSINESS_RELATIONSHIPTYPECODEID uniqueidentifier,
                @BUSINESS_RECIPROCALTYPECODEID uniqueidentifier,
                @BUSINESS_STATEID uniqueidentifier,
                @BUSINESS_WEBADDRESS dbo.UDT_WEBADDRESS, 
                @BUSINESS_POSTCODE nvarchar(12),
                @SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST uniqueidentifier,
                @SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST uniqueidentifier,
                @BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST uniqueidentifier,
                @BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST uniqueidentifier,
                @BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit,
                @BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR decimal(5,2),
                @BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit,
                @BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR decimal(5,2),
                @BUSINESS_PRIMARYRECOGNITIONTYPECODEID uniqueidentifier,
                @BUSINESS_RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier,
                @BUSINESS_EMAILADDRESSSTARTDATE date,
                @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit,
                @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR decimal(5,2),
                @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit,
                @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR decimal(5,2),
                @SPOUSE_PRIMARYRECOGNITIONTYPECODEID uniqueidentifier,
                @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier,
                @CONSTITUENT_SITES xml,
                @SPOUSE_ALTERNATELOOKUPIDS xml,
                @SPOUSE_IMPORTLOOKUPID nvarchar(100),
        @ROWFROMBATCHUI bit,
        @BBNCTRANID int
)

as
 set nocount on;

            declare @REMOVESPOUSE bit;
            exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCHCONSTITUENTUPDATEBATCHROW
                @ID = @ID,
                @REMOVESPOUSE = @REMOVESPOUSE output

      exec dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHCONSTITUENTUPDATEBATCHROW_9
                @ID,
                @CHANGEAGENTID,
                @SEQUENCE,
                @PRIMARYRECORDID,
                @CONSTITUENTTYPECODE,
                @BIRTHDATE,
                @FIRSTNAME,
                @GENDERCODE,
                @GIVESANONYMOUSLY,
                @KEYNAME,
                @LOOKUP_ID,
                @MAIDENNAME,
                @MIDDLENAME,
                @NICKNAME,
                @SUFFIXCODEID,
                @TITLECODEID,
                @WEBADDRESS,
                @ALTERNATELOOKUPIDS,
                @SECURITYATTRIBUTES,
                @DECEASED,
                @DECEASEDDATE,
                @CONSTITUENT_SITEID,
                @INTERESTS,
                @PROSPECTMANAGERFUNDRAISERID,
                @ADDRESSES,
                @PHONES,
                @EMAILADDRESSES,
                @CONSTITUENCIES,
                @GROUPTYPEID,
                @GROUPDESCRIPTION,
                @GROUPSTARTDATE,
                @ORG_INDUSTRYCODEID,
                @ORG_NUMEMPLOYEES,
                @ORG_NUMSUBSIDIARIES,
                @ORG_PARENTCORPID,
                @MARITALSTATUSCODEID,
                @SPOUSE_ID,
                @SPOUSE_TITLECODEID,
                @SPOUSE_FIRSTNAME,
                @SPOUSE_NICKNAME,
                @SPOUSE_MIDDLENAME,
                @SPOUSE_MAIDENNAME,
                @SPOUSE_LASTNAME,
                @SPOUSE_SUFFIXCODEID,
                @SPOUSE_BIRTHDATE,
                @SPOUSE_GENDERCODE,
                @SPOUSE_LOOKUPID,
                @SPOUSE_RELATIONSHIPTYPECODEID,
                @SPOUSE_RECIPROCALTYPECODEID,
                @BUSINESS_ID,
                @BUSINESS_ADDRESSBLOCK,
                @BUSINESS_ADDRESSTYPECODEID,
                @BUSINESS_CART,
                @BUSINESS_CITY,
                @BUSINESS_COUNTRYID,
                @BUSINESS_DONOTMAIL,
                @BUSINESS_DONOTMAILREASONCODEID,
                @BUSINESS_DPC,
                @BUSINESS_EMAILADDRESS,
                @BUSINESS_EMAILADDRESSTYPECODEID,
                @BUSINESS_INDUSTRYCODEID,
                @BUSINESS_LOOKUPID,
                @BUSINESS_LOT,
                @BUSINESS_NAME,
                @BUSINESS_NUMEMPLOYEES,
                @BUSINESS_NUMSUBSIDIARIES,
                @BUSINESS_PARENTCORPID,
                @BUSINESS_PHONENUMBER,
                @BUSINESS_PHONE_COUNTRYID,
                @BUSINESS_PHONETYPECODEID,
                @BUSINESS_RELATIONSHIPTYPECODEID,
                @BUSINESS_RECIPROCALTYPECODEID,
                @BUSINESS_STATEID,
                @BUSINESS_WEBADDRESS,
                @BUSINESS_POSTCODE,
                @SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST,
                @SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST,
                @BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST,
                @BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST,
                @BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
                @BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR,
                @BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
                @BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR,
                @BUSINESS_PRIMARYRECOGNITIONTYPECODEID,
                @BUSINESS_RECIPROCALRECOGNITIONTYPECODEID,
                @BUSINESS_EMAILADDRESSSTARTDATE,
                @SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
                @SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR,
                @SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
                @SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR,
                @SPOUSE_PRIMARYRECOGNITIONTYPECODEID,
                @SPOUSE_RECIPROCALRECOGNITIONTYPECODEID,
                @CONSTITUENT_SITES,
                @SPOUSE_ALTERNATELOOKUPIDS,
                @SPOUSE_IMPORTLOOKUPID,
                @ROWFROMBATCHUI,
        @BBNCTRANID,
        @REMOVESPOUSE