USP_DATAFORMTEMPLATE_ADD_BBNCPROFILEBATCHROW
The save procedure used by the add dataform template "NetCommunity Profile Update Batch Row Add Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | INOUT | The output parameter indicating the ID of the record added. |
| @BATCHID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @LINKID | uniqueidentifier | IN | Linked Constituent |
| @NETCOMMUNITYTRANSACTIONPROCESSORID | uniqueidentifier | IN | Processor |
| @BBNCTRANID | int | IN | Blackbaud Internet Solutions 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 auto-match |
| @BBNCID | int | IN | Blackbaud Internet Solutions ID |
| @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 |
| @NAMEFORMATS | xml | IN | Name formats |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_BBNCPROFILEBATCHROW
(
@ID uniqueidentifier = null output,
@BATCHID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier,
@LINKID uniqueidentifier = null,
@NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
@BBNCTRANID int,
@ADDEDBY nvarchar(255),
@PRIMARYBUSINESS xml = null,
@PRIMARYBUSINESSUPDATE bit = 1,
@PRIMARYBUSINESSADD bit = 0,
@PRIMARYBUSINESSMAKEPRIMARY bit = 0,
@BIOGRAPHICAL xml = null,
@EDUCATION xml = null,
@PREFERREDADDRESS xml = null,
@PREFERREDADDRESSUPDATE bit = 1,
@PREFERREDADDRESSADD bit = 0,
@PREFERREDADDRESSMAKEPRIMARY bit = 0,
@PREFERREDADDRESSTYPECODEID uniqueidentifier = null,
@PHONETYPES xml = null,
@SPOUSE xml = null,
@SPOUSEREMOVE bit = 0,
@SAMESPOUSE bit = 1,
@CONSTITUENTATTRIBUTES xml = null,
@EDUCATIONATTRIBUTES xml = null,
@SEQUENCE int,
--New fields for v1.1
@PREFERREDADDRESSALLFIELDS xml = null,
@PRIMARYBUSINESSADDRESSTYPECODEID uniqueidentifier = null,
@PRIMARYBUSINESSALLFIELDS xml = null,
@PRIMARYBUSINESSORGANIZATIONLINKID uniqueidentifier = null,
@SPOUSELINKID uniqueidentifier = null,
@SPOUSEOLDNAME nvarchar(200) = null,
@PRIMARYBUSINESSAUTOMATCH nvarchar(255) = null,
@BBNCID int = 0,
@SPOUSESECURITYID uniqueidentifier = null,
@PRIMARYBUSINESSSECURITYID uniqueidentifier = null,
@ISORGANIZATIONUPDATE bit = 0,
@SPOUSESITEID uniqueidentifier = null,
@PRIMARYBUSINESSSITEID uniqueidentifier = null,
@ADDITIONALADDRESSES xml = null ,
@EMPLOYMENTHISTORY xml = null,
@EDUCATIONALHISTORY xml = null,
@EDUCATIONALINVOLVEMENTS xml = null,
@ATTRIBUTECURRENCYID uniqueidentifier = null,
@PHONENUMBERS xml = null,
@EMAILADDRESSES xml = null,
@ORGRELATIONSHIPS xml = null,
@NAMEFORMATS xml = null
) as
set nocount on;
declare @CURRENTDATE datetime;
if @ID is null
set @ID = newid();
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
set @CURRENTDATE = getdate();
begin try
insert into dbo.BBNCDOWNLOADEDTRANSACTION
(
[ID]
)
values
(
@BBNCID
);
if @PRIMARYBUSINESSAUTOMATCH is null
set @PRIMARYBUSINESSAUTOMATCH = N'';
insert into dbo.BATCHBBNCPROFILE
(
[ID],
[BATCHID],
[LINKID],
[NETCOMMUNITYTRANSACTIONPROCESSORID],
[BBNCID],
[BBNCTRANID],
[ADDEDBY],
[PRIMARYBUSINESS],
[PRIMARYBUSINESSALLFIELDS],
[PRIMARYBUSINESSORGANIZATIONLINKID],
[PRIMARYBUSINESSUPDATE],
[PRIMARYBUSINESSADD],
[PRIMARYBUSINESSMAKEPRIMARY],
[PRIMARYBUSINESSADDRESSTYPECODEID],
[BIOGRAPHICAL],
[EDUCATION],
[PREFERREDADDRESS],
[PREFERREDADDRESSALLFIELDS],
[PREFERREDADDRESSUPDATE],
[PREFERREDADDRESSADD],
[PREFERREDADDRESSMAKEPRIMARY],
[PREFERREDADDRESSTYPECODEID],
[PHONETYPES],
[SPOUSE],
[SPOUSEREMOVE],
[SAMESPOUSE],
[SPOUSELINKID],
[SPOUSEOLDNAME],
[CONSTITUENTATTRIBUTES],
[EDUCATIONATTRIBUTES],
[PRIMARYBUSINESSAUTOMATCH],
[SPOUSESECURITYID],
[PRIMARYBUSINESSSECURITYID],
[ISORGANIZATIONUPDATE],
[SPOUSESITEID],
[PRIMARYBUSINESSSITEID],
[ADDITIONALADDRESSES],
[EMPLOYMENTHISTORY],
[EDUCATIONALHISTORY],
[EDUCATIONALINVOLVEMENTS],
[ATTRIBUTECURRENCYID],
[PHONENUMBERS],
[EMAILADDRESSES],
[ORGRELATIONSHIPS],
[NAMEFORMATS],
[SEQUENCE],
[ADDEDBYID],
[CHANGEDBYID],
[DATEADDED],
[DATECHANGED]
)
values
(
@ID,
@BATCHID,
@LINKID,
@NETCOMMUNITYTRANSACTIONPROCESSORID,
@BBNCID,
@BBNCTRANID,
@ADDEDBY,
@PRIMARYBUSINESS,
@PRIMARYBUSINESSALLFIELDS,
@PRIMARYBUSINESSORGANIZATIONLINKID,
@PRIMARYBUSINESSUPDATE,
@PRIMARYBUSINESSADD,
@PRIMARYBUSINESSMAKEPRIMARY,
@PRIMARYBUSINESSADDRESSTYPECODEID,
@BIOGRAPHICAL,
@EDUCATION,
@PREFERREDADDRESS,
@PREFERREDADDRESSALLFIELDS,
@PREFERREDADDRESSUPDATE,
@PREFERREDADDRESSADD,
@PREFERREDADDRESSMAKEPRIMARY,
@PREFERREDADDRESSTYPECODEID,
@PHONETYPES,
@SPOUSE,
@SPOUSEREMOVE,
@SAMESPOUSE,
@SPOUSELINKID,
@SPOUSEOLDNAME,
@CONSTITUENTATTRIBUTES,
@EDUCATIONATTRIBUTES,
@PRIMARYBUSINESSAUTOMATCH,
@SPOUSESECURITYID,
@PRIMARYBUSINESSSECURITYID,
@ISORGANIZATIONUPDATE,
@SPOUSESITEID,
@PRIMARYBUSINESSSITEID,
@ADDITIONALADDRESSES,
@EMPLOYMENTHISTORY,
@EDUCATIONALHISTORY,
@EDUCATIONALINVOLVEMENTS,
@ATTRIBUTECURRENCYID,
@PHONENUMBERS,
@EMAILADDRESSES,
@ORGRELATIONSHIPS,
@NAMEFORMATS,
@SEQUENCE,
@CHANGEAGENTID,
@CHANGEAGENTID,
@CURRENTDATE,
@CURRENTDATE
);
delete from dbo.BBNCUNSUCCESSFULDOWNLOADTRANSACTION
where
ID = @BBNCID;
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch
return 0;