USP_DATAFORMTEMPLATE_ADD_UPDATEMULTIPLECONSTITUENTSFROMMFO_BATCHROW
The save procedure used by the add dataform template "Update Constituents From MatchFinder Online 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. |
| @ORGANIZATIONID | uniqueidentifier | IN | Linked constituent |
| @MATCHFINDERRECORDID | int | IN | MatchFinder record id |
| @UPDATEORGNAME | bit | IN | |
| @MFORGNAME | nvarchar(100) | IN | MF org name |
| @UPDATEALIAS | bit | IN | |
| @MFALIAS | nvarchar(100) | IN | MF alias |
| @UPDATEINDUSTRY | bit | IN | |
| @MFINDUSTRY | nvarchar(100) | IN | MF industry |
| @UPDATEADDRESS | bit | IN | |
| @MFADDRESSBLOCK | nvarchar(150) | IN | MF address block |
| @MFCITY | nvarchar(50) | IN | MF city |
| @MFSTATE | nvarchar(100) | IN | MF state |
| @MFSTATEID | uniqueidentifier | IN | MF state ID |
| @MFCOUNTRY | nvarchar(100) | IN | MF country |
| @MFCOUNTRYID | uniqueidentifier | IN | MF country ID |
| @MFPOSTCODE | nvarchar(12) | IN | MF postcode |
| @UPDATEPHONE | bit | IN | |
| @MFPHONE | nvarchar(100) | IN | MF phone number |
| @UPDATEFAX | bit | IN | |
| @MFFAX | nvarchar(100) | IN | MF fax number |
| @UPDATEWEBADDRESS | bit | IN | |
| @MFWEBADDRESS | nvarchar(2047) | IN | MF web address |
| @CREATENEWCONTACT | bit | IN | |
| @UPDATECONTACT | bit | IN | |
| @CONTACTLINKID | uniqueidentifier | IN | |
| @UPDATECONTACTNAME | bit | IN | |
| @MFCONTACTNAME | nvarchar(350) | IN | |
| @MFCONTACTFIRSTNAME | nvarchar(100) | IN | |
| @MFCONTACTLASTNAME | nvarchar(100) | IN | |
| @UPDATECONTACTEMAIL | bit | IN | |
| @MFCONTACTEMAIL | nvarchar(100) | IN | |
| @UPDATEMATCHINGFACTOR | bit | IN | |
| @MFMATCHINGFACTOR | decimal(5, 2) | IN | MF matching factor |
| @UPDATEMINMATCHPERGIFT | bit | IN | |
| @MFMINMATCHPERGIFT | money | IN | MF min match per gift |
| @UPDATEMAXMATCHPERGIFT | bit | IN | |
| @MFMAXMATCHPERGIFT | money | IN | MF max match per gift |
| @UPDATEMAXMATCHANNUAL | bit | IN | |
| @MFMAXMATCHANNUAL | money | IN | MF max match per year |
| @UPDATEMAXMATCHTOTAL | bit | IN | |
| @MFMAXMATCHTOTAL | money | IN | MF max match total |
| @UPDATEMATCHNOTES | bit | IN | |
| @MFMATCHNOTES | nvarchar(max) | IN | MF match notes |
| @SEQUENCE | int | IN | Sequence |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_UPDATEMULTIPLECONSTITUENTSFROMMFO_BATCHROW
(
@ID uniqueidentifier = null output,
@BATCHID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier,
@ORGANIZATIONID uniqueidentifier,
@MATCHFINDERRECORDID int,
@UPDATEORGNAME bit = 0,
@MFORGNAME nvarchar(100) = '',
@UPDATEALIAS bit = 0,
@MFALIAS nvarchar(100) = '',
@UPDATEINDUSTRY bit = 0,
@MFINDUSTRY nvarchar(100) = '',
@UPDATEADDRESS bit = 0,
@MFADDRESSBLOCK nvarchar(150) = '',
@MFCITY nvarchar(50) = '',
@MFSTATE nvarchar(100) = '',
@MFSTATEID uniqueidentifier = null,
@MFCOUNTRY nvarchar(100) = '',
@MFCOUNTRYID uniqueidentifier = null,
@MFPOSTCODE nvarchar(12) = '',
@UPDATEPHONE bit = 0,
@MFPHONE nvarchar(100) = '',
@UPDATEFAX bit = 0,
@MFFAX nvarchar(100) = '',
@UPDATEWEBADDRESS bit = 0,
@MFWEBADDRESS nvarchar(2047) = '',
@CREATENEWCONTACT bit = 0,
@UPDATECONTACT bit = 0,
@CONTACTLINKID uniqueidentifier = null,
@UPDATECONTACTNAME bit = 0,
@MFCONTACTNAME nvarchar(350) = '',
@MFCONTACTFIRSTNAME nvarchar(100) = '',
@MFCONTACTLASTNAME nvarchar(100) = '',
@UPDATECONTACTEMAIL bit = 0,
@MFCONTACTEMAIL nvarchar(100) = '',
@UPDATEMATCHINGFACTOR bit = 0,
@MFMATCHINGFACTOR decimal(5,2) = 0.0,
@UPDATEMINMATCHPERGIFT bit = 0,
@MFMINMATCHPERGIFT money = 0,
@UPDATEMAXMATCHPERGIFT bit = 0,
@MFMAXMATCHPERGIFT money = 0,
@UPDATEMAXMATCHANNUAL bit = 0,
@MFMAXMATCHANNUAL money = 0,
@UPDATEMAXMATCHTOTAL bit = 0,
@MFMAXMATCHTOTAL money = 0,
@UPDATEMATCHNOTES bit = 0,
@MFMATCHNOTES nvarchar(max) = '',
@SEQUENCE int
)
as
set nocount on;
begin try
if @ID is null
set @ID = NewID();
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
declare @CHANGEDATE datetime;
set @CHANGEDATE = getdate();
insert into dbo.UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH
(
ID,
BATCHID,
CONSTITUENTID,
MATCHFINDERRECORDID,
UPDATEORGNAME,
MFORGNAME,
UPDATEALIAS,
MFALIAS,
UPDATEINDUSTRY,
MFINDUSTRY,
UPDATEADDRESS,
MFADDRESSBLOCK,
MFCITY,
MFSTATE,
MFSTATEID,
MFCOUNTRY,
MFCOUNTRYID,
MFPOSTCODE,
UPDATEPHONE,
MFPHONE,
UPDATEFAX,
MFFAX,
UPDATEWEBADDRESS,
MFWEBADDRESS,
UPDATEMATCHINGFACTOR,
MFMATCHINGFACTOR,
UPDATEMINMATCHPERGIFT,
MFMINMATCHPERGIFT,
UPDATEMAXMATCHPERGIFT,
MFMAXMATCHPERGIFT,
UPDATEMAXMATCHANNUAL,
MFMAXMATCHANNUAL,
UPDATEMAXMATCHTOTAL,
MFMAXMATCHTOTAL,
UPDATEMATCHNOTES,
MFMATCHNOTES,
CREATENEWCONTACT,
UPDATECONTACT,
CONTACTLINKID,
UPDATECONTACTNAME,
MFCONTACTFULLNAME,
MFCONTACTFIRSTNAME,
MFCONTACTLASTNAME,
UPDATECONTACTEMAIL,
MFCONTACTEMAIL,
SEQUENCE,
ADDEDBYID,
CHANGEDBYID,
DATEADDED,
DATECHANGED
) values (
@ID,
@BATCHID,
@ORGANIZATIONID,
@MATCHFINDERRECORDID,
@UPDATEORGNAME,
@MFORGNAME,
@UPDATEALIAS,
@MFALIAS,
@UPDATEINDUSTRY,
@MFINDUSTRY,
@UPDATEADDRESS,
@MFADDRESSBLOCK,
@MFCITY,
@MFSTATE,
@MFSTATEID,
@MFCOUNTRY,
@MFCOUNTRYID,
@MFPOSTCODE,
@UPDATEPHONE,
@MFPHONE,
@UPDATEFAX,
@MFFAX,
@UPDATEWEBADDRESS,
@MFWEBADDRESS,
@UPDATEMATCHINGFACTOR,
@MFMATCHINGFACTOR,
@UPDATEMINMATCHPERGIFT,
@MFMINMATCHPERGIFT,
@UPDATEMAXMATCHPERGIFT,
@MFMAXMATCHPERGIFT,
@UPDATEMAXMATCHANNUAL,
@MFMAXMATCHANNUAL,
@UPDATEMAXMATCHTOTAL,
@MFMAXMATCHTOTAL,
@UPDATEMATCHNOTES,
@MFMATCHNOTES,
@CREATENEWCONTACT,
@UPDATECONTACT,
@CONTACTLINKID,
@UPDATECONTACTNAME,
@MFCONTACTNAME,
@MFCONTACTFIRSTNAME,
@MFCONTACTLASTNAME,
@UPDATECONTACTEMAIL,
@MFCONTACTEMAIL,
@SEQUENCE,
@CHANGEAGENTID,
@CHANGEAGENTID,
@CHANGEDATE,
@CHANGEDATE
);
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch
return 0;