USP_DATAFORMTEMPLATE_EDIT_BBNCPROFILEBATCHROW_3

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.
@LINKID	uniqueidentifier	IN	Linked Constituent
@NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	IN	Processor
@BBNCID	int	IN	NetCommunity ID
@BBNCTRANID	int	IN	NetCommunity transaction ID
@ADDEDBY	nvarchar(255)	IN	Added by hidden
@PRIMARYBUSINESS	xml	IN	Primary business
@PRIMARYBUSINESSUPDATE	bit	IN	Update the business address with the downloaded information
@PRIMARYBUSINESSADD	bit	IN	Add the downloaded information as the new business address for this constituent
@PRIMARYBUSINESSMAKEPRIMARY	bit	IN	Make the this new business address primary (deprecated)
@BIOGRAPHICAL	xml	IN	Biographical
@EDUCATION	xml	IN	Education
@PREFERREDADDRESS	xml	IN	Preferred address
@PREFERREDADDRESSUPDATE	bit	IN	Update the primary address with the downloaded information
@PREFERREDADDRESSADD	bit	IN	Add the downloaded information as a new address for this constituent
@PREFERREDADDRESSMAKEPRIMARY	bit	IN	Make this new address the primary address
@PREFERREDADDRESSTYPECODEID	uniqueidentifier	IN	Previous address type
@PHONETYPES	xml	IN	Phone type codes hidden
@SPOUSE	xml	IN	Spouse
@SPOUSEREMOVE	bit	IN	Change this constituent's current spouse relationship into a former spouse relationship
@SAMESPOUSE	bit	IN	Update the existing spouse with the downloaded information
@CONSTITUENTATTRIBUTES	xml	IN	Constituent attributes
@EDUCATIONATTRIBUTES	xml	IN	Education attributes
@SEQUENCE	int	IN	Sequence
@PREFERREDADDRESSALLFIELDS	xml	IN	Preferred address all fields
@PRIMARYBUSINESSADDRESSTYPECODEID	uniqueidentifier	IN	Previous business address type
@PRIMARYBUSINESSALLFIELDS	xml	IN	Primary business all fields
@PRIMARYBUSINESSORGANIZATIONLINKID	uniqueidentifier	IN	Primary business organization
@SPOUSELINKID	uniqueidentifier	IN	Spouse
@SPOUSEOLDNAME	nvarchar(200)	IN	Previous spouse
@PRIMARYBUSINESSAUTOMATCH	nvarchar(255)	IN	Primary business automatch
@SPOUSESECURITYID	uniqueidentifier	IN	Spouse constituent security group
@PRIMARYBUSINESSSECURITYID	uniqueidentifier	IN	Primary business constituent security group
@ISORGANIZATIONUPDATE	bit	IN	Is organization update
@SPOUSESITEID	uniqueidentifier	IN	Spouse site
@PRIMARYBUSINESSSITEID	uniqueidentifier	IN	Primary business site
@ADDITIONALADDRESSES	xml	IN	Additional addresses
@EMPLOYMENTHISTORY	xml	IN	Employment
@EDUCATIONALHISTORY	xml	IN	Educational history
@EDUCATIONALINVOLVEMENTS	xml	IN	Educational involvements
@ATTRIBUTECURRENCYID	uniqueidentifier	IN	Attribute currency
@PHONENUMBERS	xml	IN	Phone numbers
@EMAILADDRESSES	xml	IN	Email addresses
@ORGRELATIONSHIPS	xml	IN	Employment

Definition

Copy



        CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCPROFILEBATCHROW_3
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @LINKID uniqueidentifier,
                @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
                @BBNCID int,
                @BBNCTRANID int,
                @ADDEDBY nvarchar(255),
                @PRIMARYBUSINESS xml,
                @PRIMARYBUSINESSUPDATE bit,
                @PRIMARYBUSINESSADD bit,
                @PRIMARYBUSINESSMAKEPRIMARY bit,
                @BIOGRAPHICAL xml,
                @EDUCATION xml,
                @PREFERREDADDRESS xml,
                @PREFERREDADDRESSUPDATE bit,
                @PREFERREDADDRESSADD bit,
                @PREFERREDADDRESSMAKEPRIMARY bit,
                @PREFERREDADDRESSTYPECODEID uniqueidentifier,
                @PHONETYPES xml,
                @SPOUSE xml,
                @SPOUSEREMOVE bit,
                @SAMESPOUSE bit,
                @CONSTITUENTATTRIBUTES xml,
                @EDUCATIONATTRIBUTES xml,
                @SEQUENCE int,
                @PREFERREDADDRESSALLFIELDS xml,
                @PRIMARYBUSINESSADDRESSTYPECODEID uniqueidentifier,
                @PRIMARYBUSINESSALLFIELDS xml,
                @PRIMARYBUSINESSORGANIZATIONLINKID uniqueidentifier,
                @SPOUSELINKID uniqueidentifier,
                @SPOUSEOLDNAME nvarchar(200),
                @PRIMARYBUSINESSAUTOMATCH nvarchar(255),
                @SPOUSESECURITYID uniqueidentifier,
                @PRIMARYBUSINESSSECURITYID uniqueidentifier,
                @ISORGANIZATIONUPDATE bit,
                @SPOUSESITEID uniqueidentifier,
                @PRIMARYBUSINESSSITEID uniqueidentifier,
                @ADDITIONALADDRESSES xml,
                @EMPLOYMENTHISTORY xml,
                @EDUCATIONALHISTORY xml,
                @EDUCATIONALINVOLVEMENTS xml,
                @ATTRIBUTECURRENCYID uniqueidentifier,
                @PHONENUMBERS xml,
                @EMAILADDRESSES xml,
                @ORGRELATIONSHIPS xml
            ) as
                set nocount on;

                declare @NAMEFORMATS xml = null;

                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BBNCPROFILEBATCHROW_3
                    @ID = @ID,
                    @NAMEFORMATS = @NAMEFORMATS output;

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCPROFILEBATCHROW_4
                    @ID,
                    @CHANGEAGENTID,
                    @LINKID,
                    @NETCOMMUNITYTRANSACTIONPROCESSORID,
                    @BBNCID,
                    @BBNCTRANID,
                    @ADDEDBY,
                    @PRIMARYBUSINESS,
                    @PRIMARYBUSINESSUPDATE,
                    @PRIMARYBUSINESSADD,
                    @PRIMARYBUSINESSMAKEPRIMARY,
                    @BIOGRAPHICAL,
                    @EDUCATION,
                    @PREFERREDADDRESS,
                    @PREFERREDADDRESSUPDATE,
                    @PREFERREDADDRESSADD,
                    @PREFERREDADDRESSMAKEPRIMARY,
                    @PREFERREDADDRESSTYPECODEID,
                    @PHONETYPES,
                    @SPOUSE,
                    @SPOUSEREMOVE,
                    @SAMESPOUSE,
                    @CONSTITUENTATTRIBUTES,
                    @EDUCATIONATTRIBUTES,
                    @SEQUENCE,
                    @PREFERREDADDRESSALLFIELDS,
                    @PRIMARYBUSINESSADDRESSTYPECODEID,
                    @PRIMARYBUSINESSALLFIELDS,
                    @PRIMARYBUSINESSORGANIZATIONLINKID,
                    @SPOUSELINKID,
                    @SPOUSEOLDNAME,
                    @PRIMARYBUSINESSAUTOMATCH,
                    @SPOUSESECURITYID,
                    @PRIMARYBUSINESSSECURITYID,
                    @ISORGANIZATIONUPDATE,
                    @SPOUSESITEID,
                    @PRIMARYBUSINESSSITEID,
                    @ADDITIONALADDRESSES,
                    @EMPLOYMENTHISTORY,
                    @EDUCATIONALHISTORY,
                    @EDUCATIONALINVOLVEMENTS,
                    @ATTRIBUTECURRENCYID,
                    @PHONENUMBERS,
                    @EMAILADDRESSES,
                    @ORGRELATIONSHIPS,
                    @NAMEFORMATS

                return 0;