USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTUPDATEBATCHTEMPLATE

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.
@VALIDATEONLY	bit	IN	Validate only
@CONSTITUENTTYPECODE	tinyint	IN	Constituent type
@BIRTHDATE	UDT_FUZZYDATE	IN	Birth date
@FIRSTNAME	nvarchar(50)	IN	First name
@GENDERCODE	tinyint	IN	Gender
@GIVESANONYMOUSLY	bit	IN	Gives anonymously
@KEYNAME	nvarchar(100)	IN	Last name
@LOOKUPID	nvarchar(100)	IN	Lookup ID
@MAIDENNAME	nvarchar(100)	IN	Maiden name
@MIDDLENAME	nvarchar(50)	IN	Middle name
@NICKNAME	nvarchar(50)	IN	Nickname
@SUFFIXCODEID	uniqueidentifier	IN	Suffix
@TITLECODEID	uniqueidentifier	IN	Title
@WEBADDRESS	UDT_WEBADDRESS	IN	Website
@ALTERNATELOOKUPIDS	xml	IN	Alternate lookup IDs
@SECURITYATTRIBUTES	xml	IN	Security attributes
@DECEASED	bit	IN	Deceased
@DECEASEDDATE	UDT_FUZZYDATE	IN	Deceased date
@CONSTITUENT_SITEID	uniqueidentifier	IN	Constituent site
@INTERESTS	xml	IN	Interests
@PROSPECTMANAGERFUNDRAISERID	uniqueidentifier	IN	Prospect manager
@ADDRESSES	xml	IN	Addresses
@EMAILADDRESSES	xml	IN	Email addresses
@PHONES	xml	IN	Phones
@CONSTITUENCIES	xml	IN	Constituencies
@GROUPTYPEID	uniqueidentifier	IN	Group type
@GROUPDESCRIPTION	nvarchar(300)	IN	Group description
@GROUPSTARTDATE	date	IN	Group start date
@ORG_INDUSTRYCODEID	uniqueidentifier	IN	Constituent's industry
@ORG_NUMEMPLOYEES	int	IN	Number of employees
@ORG_NUMSUBSIDIARIES	int	IN	Number of subsidiaries
@ORG_PARENTCORPID	uniqueidentifier	IN	Parent corporation
@MARITALSTATUSCODEID	uniqueidentifier	IN	Marital status
@SPOUSE_ID	uniqueidentifier	IN	Spouse
@SPOUSE_BIRTHDATE	UDT_FUZZYDATE	IN	Spouse birth date
@SPOUSE_FIRSTNAME	nvarchar(50)	IN	Spouse first name
@SPOUSE_GENDERCODE	tinyint	IN	Spouse gender
@SPOUSE_LASTNAME	nvarchar(100)	IN	Spouse last name
@SPOUSE_LOOKUPID	nvarchar(100)	IN	Spouse lookup ID
@SPOUSE_MAIDENNAME	nvarchar(100)	IN	Spouse maiden name
@SPOUSE_MIDDLENAME	nvarchar(50)	IN	Spouse middle name
@SPOUSE_NICKNAME	nvarchar(50)	IN	Spouse nickname
@SPOUSE_SUFFIXCODEID	uniqueidentifier	IN	Spouse suffix
@SPOUSE_TITLECODEID	uniqueidentifier	IN	Spouse title
@SPOUSE_RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Relation to spouse
@SPOUSE_RECIPROCALTYPECODEID	uniqueidentifier	IN	Spouse's relation to constituent
@BUSINESS_ADDRESSBLOCK	nvarchar(150)	IN	Business address
@BUSINESS_ADDRESSTYPECODEID	uniqueidentifier	IN	Business address type
@BUSINESS_CART	nvarchar(10)	IN	Business CART
@BUSINESS_CITY	nvarchar(50)	IN	Business city
@BUSINESS_COUNTRYID	uniqueidentifier	IN	Business country
@BUSINESS_DONOTMAIL	bit	IN	Business do not mail
@BUSINESS_DONOTMAILREASONCODEID	uniqueidentifier	IN	Business do not mail reason
@BUSINESS_DPC	nvarchar(8)	IN	Business DPC
@BUSINESS_EMAILADDRESS	UDT_EMAILADDRESS	IN	Business email address
@BUSINESS_EMAILADDRESSTYPECODEID	uniqueidentifier	IN	Business email type
@BUSINESS_INDUSTRYCODEID	uniqueidentifier	IN	Industry
@BUSINESS_LOOKUPID	nvarchar(100)	IN	Business lookup ID
@BUSINESS_LOT	nvarchar(5)	IN	Business LOT
@BUSINESS_ID	uniqueidentifier	IN	Business
@BUSINESS_NAME	nvarchar(100)	IN	Business name
@BUSINESS_NUMEMPLOYEES	int	IN	Business number of employees
@BUSINESS_NUMSUBSIDIARIES	int	IN	Business number of subsidiaries
@BUSINESS_PARENTCORPID	uniqueidentifier	IN	Business parent organization
@BUSINESS_PHONENUMBER	nvarchar(100)	IN	Business phone number
@BUSINESS_PHONETYPECODEID	uniqueidentifier	IN	Business phone type
@BUSINESS_RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Relation to business
@BUSINESS_RECIPROCALTYPECODEID	uniqueidentifier	IN	Business's relation to constituent
@BUSINESS_STATEID	uniqueidentifier	IN	Business state
@BUSINESS_WEBADDRESS	UDT_WEBADDRESS	IN	Business website
@BUSINESS_POSTCODE	nvarchar(12)	IN	Business ZIP
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTUPDATEBATCHTEMPLATE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @VALIDATEONLY bit,
    @CONSTITUENTTYPECODE tinyint,
    @BIRTHDATE dbo.UDT_FUZZYDATE,
    @FIRSTNAME nvarchar(50),
    @GENDERCODE tinyint,
    @GIVESANONYMOUSLY bit,
    @KEYNAME nvarchar(100),
    @LOOKUPID 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,
    --@EDUCATIONALINVOLVEMENTS xml,

    @ADDRESSES xml,
    @EMAILADDRESSES xml,
    @PHONES xml,
    @CONSTITUENCIES xml,
    @GROUPTYPEID uniqueidentifier,
    @GROUPDESCRIPTION nvarchar(300),
    @GROUPSTARTDATE date,
    @ORG_INDUSTRYCODEID uniqueidentifier,
    @ORG_NUMEMPLOYEES int,
    @ORG_NUMSUBSIDIARIES int,
    @ORG_PARENTCORPID uniqueidentifier,
    @MARITALSTATUSCODEID uniqueidentifier,
    @SPOUSE_ID uniqueidentifier,
    @SPOUSE_BIRTHDATE dbo.UDT_FUZZYDATE,
    @SPOUSE_FIRSTNAME nvarchar(50),
    @SPOUSE_GENDERCODE tinyint,
    @SPOUSE_LASTNAME nvarchar(100),
    @SPOUSE_LOOKUPID nvarchar(100),
    @SPOUSE_MAIDENNAME nvarchar(100),
    @SPOUSE_MIDDLENAME nvarchar(50),
    @SPOUSE_NICKNAME nvarchar(50),
    @SPOUSE_SUFFIXCODEID uniqueidentifier,
    @SPOUSE_TITLECODEID uniqueidentifier,
    @SPOUSE_RELATIONSHIPTYPECODEID uniqueidentifier,
    @SPOUSE_RECIPROCALTYPECODEID 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_ID uniqueidentifier,
    @BUSINESS_NAME nvarchar(100),
    @BUSINESS_NUMEMPLOYEES int,
    @BUSINESS_NUMSUBSIDIARIES int,
    @BUSINESS_PARENTCORPID uniqueidentifier,
    @BUSINESS_PHONENUMBER nvarchar(100),
    @BUSINESS_PHONETYPECODEID uniqueidentifier,
    @BUSINESS_RELATIONSHIPTYPECODEID uniqueidentifier,
    @BUSINESS_RECIPROCALTYPECODEID uniqueidentifier,
    @BUSINESS_STATEID uniqueidentifier,
    @BUSINESS_WEBADDRESS dbo.UDT_WEBADDRESS,
    @BUSINESS_POSTCODE nvarchar(12),
    @CURRENTAPPUSERID uniqueidentifier
)

as
    set nocount on;

    declare @SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST uniqueidentifier;
    declare @SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST uniqueidentifier;
    declare @BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST uniqueidentifier;
    declare @BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST uniqueidentifier;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTUPDATEBATCHTEMPLATE
        @ID = @ID,
        @SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST = @SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST output,
        @SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST = @SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST output,
        @BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST = @BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST output,
        @BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST = @BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTUPDATEBATCHTEMPLATE_2
        @ID,
        @CHANGEAGENTID,
        @VALIDATEONLY,
        @CONSTITUENTTYPECODE,
        @BIRTHDATE,
        @FIRSTNAME,
        @GENDERCODE,
        @GIVESANONYMOUSLY,
        @KEYNAME,
        @LOOKUPID,
        @MAIDENNAME,
        @MIDDLENAME,
        @NICKNAME,
        @SUFFIXCODEID,
        @TITLECODEID,
        @WEBADDRESS,
        @ALTERNATELOOKUPIDS,
        @SECURITYATTRIBUTES,
        @DECEASED,
        @DECEASEDDATE,
        @CONSTITUENT_SITEID,
        @INTERESTS,
        @PROSPECTMANAGERFUNDRAISERID,
        --@EDUCATIONALINVOLVEMENTS,

        @ADDRESSES,
        @EMAILADDRESSES,
        @PHONES,
        @CONSTITUENCIES,
        @GROUPTYPEID,
        @GROUPDESCRIPTION,
        @GROUPSTARTDATE,
        @ORG_INDUSTRYCODEID,
        @ORG_NUMEMPLOYEES,
        @ORG_NUMSUBSIDIARIES,
        @ORG_PARENTCORPID,
        @MARITALSTATUSCODEID,
        @SPOUSE_ID,
        @SPOUSE_BIRTHDATE,
        @SPOUSE_FIRSTNAME,
        @SPOUSE_GENDERCODE,
        @SPOUSE_LASTNAME,
        @SPOUSE_LOOKUPID,
        @SPOUSE_MAIDENNAME,
        @SPOUSE_MIDDLENAME,
        @SPOUSE_NICKNAME,
        @SPOUSE_SUFFIXCODEID,
        @SPOUSE_TITLECODEID,
        @SPOUSE_RELATIONSHIPTYPECODEID,
        @SPOUSE_RECIPROCALTYPECODEID,
        @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_ID,
        @BUSINESS_NAME,
        @BUSINESS_NUMEMPLOYEES,
        @BUSINESS_NUMSUBSIDIARIES,
        @BUSINESS_PARENTCORPID,
        @BUSINESS_PHONENUMBER,
        @BUSINESS_PHONETYPECODEID,
        @BUSINESS_RELATIONSHIPTYPECODEID,
        @BUSINESS_RECIPROCALTYPECODEID,
        @BUSINESS_STATEID,
        @BUSINESS_WEBADDRESS,
        @BUSINESS_POSTCODE,
        @CURRENTAPPUSERID,
        @SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST,
        @SPOUSE_RECIPROCALTYPECODEIDSIMPLELIST,
        @BUSINESS_RELATIONSHIPTYPECODEIDSIMPLELIST,
        @BUSINESS_RECIPROCALTYPECODEIDSIMPLELIST

    return 0;