USP_DATAFORMTEMPLATE_ADD_CONSTITUENTADDRESSUPDATEBATCHROW
The save procedure used by the add dataform template "Constituent Address 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. |
| @ADDRESSID | uniqueidentifier | IN | Constituent address |
| @ADDRESSTYPECODEID | uniqueidentifier | IN | Address type |
| @COUNTRYID | uniqueidentifier | IN | Country |
| @ADDRESSBLOCK | nvarchar(150) | IN | Address |
| @CITY | nvarchar(50) | IN | City |
| @STATEID | uniqueidentifier | IN | State |
| @POSTCODE | nvarchar(12) | IN | ZIP |
| @ISPRIMARY | bit | IN | Set as primary address |
| @DONOTMAIL | bit | IN | Do not send mail to this address |
| @UPDATEMATCHINGSPOUSEADDRESSES | bit | IN | Update spouse address |
| @SEQUENCE | int | IN | Sequence |
| @CART | nvarchar(10) | IN | CART |
| @DPC | nvarchar(8) | IN | DPC |
| @LOT | nvarchar(5) | IN | LOT |
| @COUNTYCODEID | uniqueidentifier | IN | County |
| @OMITFROMVALIDATION | bit | IN | Omit from validation |
| @CONGRESSIONALDISTRICTCODEID | uniqueidentifier | IN | Congressional district |
| @STATEHOUSEDISTRICTCODEID | uniqueidentifier | IN | State house district |
| @STATESENATEDISTRICTCODEID | uniqueidentifier | IN | State senate district |
| @LOCALPRECINCTCODEID | uniqueidentifier | IN | Local precinct |
| @INFOSOURCECODEID | uniqueidentifier | IN | Information source |
| @REGIONCODEID | uniqueidentifier | IN | Region |
| @LASTVALIDATIONATTEMPTDATE | datetime | IN | Last validation attempt date |
| @VALIDATIONMESSAGE | nvarchar(200) | IN | Validation message |
| @CERTIFICATIONDATA | int | IN | Certification data |
| @STARTDATE | UDT_MONTHDAY | IN | Start date |
| @ENDDATE | UDT_MONTHDAY | IN | End date |
| @DONOTMAILREASONCODEID | uniqueidentifier | IN | Do not mail reason |
| @UPDATEMATCHINGHOUSEHOLDADDRESSES | bit | IN | Update matching addresses in household |
| @HASMATCHINGADDRESSES | bit | IN | Has matching addresses |
| @INFOSOURCECOMMENTS | nvarchar(256) | IN |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_CONSTITUENTADDRESSUPDATEBATCHROW
(
@ID uniqueidentifier = null output,
@BATCHID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier,
@ADDRESSID uniqueidentifier,
@ADDRESSTYPECODEID uniqueidentifier = null,
@COUNTRYID uniqueidentifier,
@ADDRESSBLOCK nvarchar(150) = '',
@CITY nvarchar(50) = '',
@STATEID uniqueidentifier = null,
@POSTCODE nvarchar(12) = '',
@ISPRIMARY bit = 0,
@DONOTMAIL bit = 0,
@UPDATEMATCHINGSPOUSEADDRESSES bit = 0,
@SEQUENCE int,
@CART nvarchar(10) = '',
@DPC nvarchar(8) = '',
@LOT nvarchar(5) = '',
@COUNTYCODEID uniqueidentifier = null,
@OMITFROMVALIDATION bit = 0,
@CONGRESSIONALDISTRICTCODEID uniqueidentifier = null,
@STATEHOUSEDISTRICTCODEID uniqueidentifier = null,
@STATESENATEDISTRICTCODEID uniqueidentifier = null,
@LOCALPRECINCTCODEID uniqueidentifier = null,
@INFOSOURCECODEID uniqueidentifier = null,
@REGIONCODEID uniqueidentifier = null,
@LASTVALIDATIONATTEMPTDATE datetime = null,
@VALIDATIONMESSAGE nvarchar(200) = '',
@CERTIFICATIONDATA int = 0,
@STARTDATE dbo.UDT_MONTHDAY = '0000',
@ENDDATE dbo.UDT_MONTHDAY = '0000',
@DONOTMAILREASONCODEID uniqueidentifier = null,
@UPDATEMATCHINGHOUSEHOLDADDRESSES bit = 0,
@HASMATCHINGADDRESSES bit = 0,
@INFOSOURCECOMMENTS nvarchar(256) = ''
) as
set nocount on;
if @STARTDATE = '0000' and not @ENDDATE = '0000'
raiserror ('BBERR_STARTDATE_REQUIRED',13,1);
if @ENDDATE = '0000' and not @STARTDATE = '0000'
raiserror ('BBERR_ENDDATE_REQUIRED',13,1);
declare @CURRENTDATE datetime;
if @ID is null
set @ID = newid();
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
set @CURRENTDATE = getdate();
-- THM 03/07/2008 CR295315-030708 & CR295291-030608 set default values if null
if @CERTIFICATIONDATA is null
set @CERTIFICATIONDATA = 0
if @OMITFROMVALIDATION is null
set @OMITFROMVALIDATION = 0
if @DONOTMAIL = 0
set @DONOTMAILREASONCODEID = null
if exists(select COUNT(1) from dbo.[IMPORTPROCESSBATCH] where BATCHID = @BATCHID) begin
select
@ADDRESSBLOCK = coalesce (nullif(@ADDRESSBLOCK, ''), ADDRESS.[ADDRESSBLOCK]),
@CITY = coalesce (nullif(@CITY, ''), ADDRESS.[CITY]),
@CART = coalesce (nullif(@CART, ''), ADDRESS.[CART]),
@DPC = coalesce (nullif(@DPC, ''), ADDRESS.[DPC]),
@LOT = coalesce (nullif(@LOT, ''), ADDRESS.[LOT])
from
dbo.[ADDRESS] where ADDRESS.[ID] = @ADDRESSID;
end
begin try
insert into dbo.BATCHCONSTITUENTADDRESSUPDATE
(
[ID],
[BATCHID],
[ADDRESSID],
[ADDRESSTYPECODEID],
[COUNTRYID],
[ADDRESSBLOCK],
[CITY],
[STATEID],
[POSTCODE],
[ISPRIMARY],
[DONOTMAIL],
[UPDATEMATCHINGSPOUSEADDRESSES],
[SEQUENCE],
[ADDEDBYID],
[CHANGEDBYID],
[DATEADDED],
[DATECHANGED],
[CART],
[DPC],
[LOT],
[COUNTYCODEID],
[OMITFROMVALIDATION],
[CONGRESSIONALDISTRICTCODEID],
[STATEHOUSEDISTRICTCODEID],
[STATESENATEDISTRICTCODEID],
[LOCALPRECINCTCODEID],
[INFOSOURCECODEID],
[REGIONCODEID],
[LASTVALIDATIONATTEMPTDATE],
[VALIDATIONMESSAGE],
[CERTIFICATIONDATA],
[STARTDATE],
[ENDDATE],
[DONOTMAILREASONCODEID],
[UPDATEMATCHINGHOUSEHOLDADDRESSES],
[INFOSOURCECOMMENTS]
)
values
(
@ID,
@BATCHID,
@ADDRESSID,
@ADDRESSTYPECODEID,
@COUNTRYID,
@ADDRESSBLOCK,
@CITY,
@STATEID,
@POSTCODE,
@ISPRIMARY,
@DONOTMAIL,
@UPDATEMATCHINGSPOUSEADDRESSES,
@SEQUENCE,
@CHANGEAGENTID,
@CHANGEAGENTID,
@CURRENTDATE,
@CURRENTDATE,
@CART,
@DPC,
@LOT,
@COUNTYCODEID,
@OMITFROMVALIDATION,
@CONGRESSIONALDISTRICTCODEID,
@STATEHOUSEDISTRICTCODEID,
@STATESENATEDISTRICTCODEID,
@LOCALPRECINCTCODEID,
@INFOSOURCECODEID,
@REGIONCODEID,
@LASTVALIDATIONATTEMPTDATE,
@VALIDATIONMESSAGE,
@CERTIFICATIONDATA,
@STARTDATE,
@ENDDATE,
@DONOTMAILREASONCODEID,
@UPDATEMATCHINGHOUSEHOLDADDRESSES,
@INFOSOURCECOMMENTS
);
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch
return 0;