USP_DATAFORMTEMPLATE_EDITLOAD_BBNCPROFILEBATCHROW_3

The load procedure used by the edit dataform template "NetCommunity Profile Update Batch Row Edit Form 3"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@LINKID	uniqueidentifier	INOUT	Linked Constituent
@NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	INOUT	Processor
@BBNCID	int	INOUT	Blackbaud Internet Solutions ID
@BBNCTRANID	int	INOUT	Blackbaud Internet Solutions transaction ID
@CONSTITUENTNAME	nvarchar(154)	INOUT	Constituent name
@ADDEDBY	nvarchar(255)	INOUT	Added by hidden
@ADDEDBYFORDISPLAY	nvarchar(255)	INOUT	Added by
@ADDRESS	nvarchar(300)	INOUT	Address
@PRIMARYBUSINESS	xml	INOUT	Primary business
@PRIMARYBUSINESSUPDATE	bit	INOUT	Update the business address with the downloaded information
@PRIMARYBUSINESSADD	bit	INOUT	Add the downloaded information as the new business address for this constituent
@PRIMARYBUSINESSMAKEPRIMARY	bit	INOUT	Make the this new business address primary (deprecated)
@BIOGRAPHICAL	xml	INOUT	Biographical
@EDUCATION	xml	INOUT	Education
@PREFERREDADDRESS	xml	INOUT	Preferred address
@PREFERREDADDRESSUPDATE	bit	INOUT	Update the primary address with the downloaded information
@PREFERREDADDRESSADD	bit	INOUT	Add the downloaded information as a new address for this constituent
@PREFERREDADDRESSMAKEPRIMARY	bit	INOUT	Make this new address the primary address
@PREFERREDADDRESSTYPECODEID	uniqueidentifier	INOUT	Previous address type
@PHONETYPES	xml	INOUT	Phone type codes hidden
@SPOUSE	xml	INOUT	Spouse
@SPOUSEREMOVE	bit	INOUT	Change this constituent's current spouse relationship into a former spouse relationship
@SAMESPOUSE	bit	INOUT	Update the existing spouse with the downloaded information
@CONSTITUENTATTRIBUTES	xml	INOUT	Constituent attributes
@EDUCATIONATTRIBUTES	xml	INOUT	Education attributes
@SEQUENCE	int	INOUT	Sequence
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@PREFERREDADDRESSALLFIELDS	xml	INOUT	Preferred address all fields
@PRIMARYBUSINESSADDRESSTYPECODEID	uniqueidentifier	INOUT	Previous business address type
@PRIMARYBUSINESSALLFIELDS	xml	INOUT	Primary business all fields
@PRIMARYBUSINESSORGANIZATIONLINKID	uniqueidentifier	INOUT	Primary business organization
@SPOUSELINKID	uniqueidentifier	INOUT	Spouse
@SPOUSEOLDNAME	nvarchar(200)	INOUT	Previous spouse
@PRIMARYBUSINESSAUTOMATCH	nvarchar(255)	INOUT	Primary business auto-match
@SPOUSESECURITYID	uniqueidentifier	INOUT	Spouse constituent security group
@PRIMARYBUSINESSSECURITYID	uniqueidentifier	INOUT	Primary business constituent security group
@ISORGANIZATIONUPDATE	bit	INOUT	Is organization update
@SPOUSESITEID	uniqueidentifier	INOUT	Spouse site
@PRIMARYBUSINESSSITEID	uniqueidentifier	INOUT	Primary business site
@ADDITIONALADDRESSES	xml	INOUT	Additional addresses
@EMPLOYMENTHISTORY	xml	INOUT	Employment
@EDUCATIONALHISTORY	xml	INOUT	Educational history
@EDUCATIONALINVOLVEMENTS	xml	INOUT	Educational involvements
@ATTRIBUTECURRENCYID	uniqueidentifier	INOUT	Attribute currency
@PHONENUMBERS	xml	INOUT	Phone numbers
@EMAILADDRESSES	xml	INOUT	Email addresses
@ORGRELATIONSHIPS	xml	INOUT	Employment
@NAMEFORMATS	xml	INOUT	Name formats

Definition

Copy



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

                            set @DATALOADED = 0;
                            set @TSLONG = 0; 

                            select
                                @DATALOADED = 1,
                                @LINKID = [LINKID],
                                @NETCOMMUNITYTRANSACTIONPROCESSORID = [NETCOMMUNITYTRANSACTIONPROCESSORID],
                                @BBNCID = [BBNCID],
                                @BBNCTRANID = [BBNCTRANID],
                                @CONSTITUENTNAME = dbo.UFN_CONSTITUENT_BUILDNAME([LINKID]),
                                @ADDEDBY = [ADDEDBY],
                                @ADDEDBYFORDISPLAY = [ADDEDBY],
                                @ADDRESS = dbo.UFN_BUILDFULLADDRESS(ADDRESS.ID, ADDRESS.ADDRESSBLOCK, ADDRESS.CITY, ADDRESS.STATEID, ADDRESS.POSTCODE, ADDRESS.COUNTRYID),
                                @PRIMARYBUSINESS = [PRIMARYBUSINESS],
                                @PRIMARYBUSINESSALLFIELDS = [PRIMARYBUSINESSALLFIELDS],
                                @PRIMARYBUSINESSORGANIZATIONLINKID = [PRIMARYBUSINESSORGANIZATIONLINKID],
                                @PRIMARYBUSINESSUPDATE = [PRIMARYBUSINESSUPDATE],
                                @PRIMARYBUSINESSADD = [PRIMARYBUSINESSADD],
                                @PRIMARYBUSINESSMAKEPRIMARY = [PRIMARYBUSINESSMAKEPRIMARY],
                                @PRIMARYBUSINESSADDRESSTYPECODEID = [PRIMARYBUSINESSADDRESSTYPECODEID],
                                @BIOGRAPHICAL = [BIOGRAPHICAL],
                                @EDUCATION = [EDUCATION],
                                @PREFERREDADDRESS = [PREFERREDADDRESS],
                                @PREFERREDADDRESSALLFIELDS = [PREFERREDADDRESSALLFIELDS],
                                @PREFERREDADDRESSUPDATE = [PREFERREDADDRESSUPDATE],
                                @PREFERREDADDRESSADD = [PREFERREDADDRESSADD],
                                @PREFERREDADDRESSMAKEPRIMARY = [PREFERREDADDRESSMAKEPRIMARY],
                                @PREFERREDADDRESSTYPECODEID = [PREFERREDADDRESSTYPECODEID],
                                @PHONETYPES = [PHONETYPES],
                                @SPOUSE = [SPOUSE],
                                @SPOUSEREMOVE = [SPOUSEREMOVE],
                                @SAMESPOUSE = [SAMESPOUSE],
                                @SPOUSELINKID = [SPOUSELINKID],
                                @SPOUSEOLDNAME = [SPOUSEOLDNAME],
                                @CONSTITUENTATTRIBUTES = [CONSTITUENTATTRIBUTES],
                                @EDUCATIONATTRIBUTES = [EDUCATIONATTRIBUTES],
                                @PRIMARYBUSINESSAUTOMATCH = [PRIMARYBUSINESSAUTOMATCH],
                                @SPOUSESECURITYID = [SPOUSESECURITYID],
                                @PRIMARYBUSINESSSECURITYID = [PRIMARYBUSINESSSECURITYID],
                                @ISORGANIZATIONUPDATE = [ISORGANIZATIONUPDATE],
                                @SPOUSESITEID = [SPOUSESITEID],
                                @PRIMARYBUSINESSSITEID = [PRIMARYBUSINESSSITEID],
                                @ADDITIONALADDRESSES = [ADDITIONALADDRESSES],
                                @EMPLOYMENTHISTORY = [EMPLOYMENTHISTORY],
                                @EDUCATIONALHISTORY = [EDUCATIONALHISTORY],
                                @EDUCATIONALINVOLVEMENTS = [EDUCATIONALINVOLVEMENTS],
                                @ATTRIBUTECURRENCYID = [ATTRIBUTECURRENCYID],
                @PHONENUMBERS = [PHONENUMBERS],
                @EMAILADDRESSES = [EMAILADDRESSES],
                @ORGRELATIONSHIPS = [ORGRELATIONSHIPS],
                @NAMEFORMATS = [NAMEFORMATS],
                                @SEQUENCE = [BATCHBBNCPROFILE].[SEQUENCE],
                                @TSLONG = [BATCHBBNCPROFILE].[TSLONG]
                            from
                                dbo.BATCHBBNCPROFILE
                            left join 
                                dbo.ADDRESS on BATCHBBNCPROFILE.LINKID = ADDRESS.CONSTITUENTID and ADDRESS.ISPRIMARY = 1
                            where
                                BATCHBBNCPROFILE.ID = @ID;                            

                            return 0;