USP_DATAFORMTEMPLATE_EDITLOAD_REVENUEBATCHDUPLICATEMATCH
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @DATALOADED | bit | INOUT | |
| @TSLONG | bigint | INOUT | |
| @LOOKUPID | nvarchar(50) | INOUT | |
| @FIRSTNAME | nvarchar(50) | INOUT | |
| @MIDDLENAME | nvarchar(50) | INOUT | |
| @LASTNAME | nvarchar(100) | INOUT | |
| @SUFFIXCODEID | uniqueidentifier | INOUT | |
| @TITLECODEID | uniqueidentifier | INOUT | |
| @MAIDENNAME | nvarchar(100) | INOUT | |
| @NICKNAME | nvarchar(50) | INOUT | |
| @GENDERCODE | tinyint | INOUT | |
| @BIRTHDATE | UDT_FUZZYDATE | INOUT | |
| @ADDRESSID | uniqueidentifier | INOUT | |
| @ADDRESSTYPECODEID | uniqueidentifier | INOUT | |
| @ADDRESS_ADDRESSBLOCK | nvarchar(150) | INOUT | |
| @ADDRESS_CITY | nvarchar(50) | INOUT | |
| @ADDRESS_STATEID | uniqueidentifier | INOUT | |
| @ADDRESS_POSTCODE | nvarchar(12) | INOUT | |
| @ADDRESS_COUNTRYID | uniqueidentifier | INOUT | |
| @PHONEID | uniqueidentifier | INOUT | |
| @PHONETYPECODEID | uniqueidentifier | INOUT | |
| @PHONENUMBER | nvarchar(100) | INOUT | |
| @EMAILID | uniqueidentifier | INOUT | |
| @EMAILADDRESSTYPECODEID | uniqueidentifier | INOUT | |
| @EMAILADDRESS | UDT_EMAILADDRESS | INOUT | |
| @CREATEDON | datetime | INOUT | |
| @DATECHANGED | datetime | INOUT | |
| @ADDRESSES | xml | INOUT | |
| @PHONES | xml | INOUT | |
| @EMAILADDRESSES | xml | INOUT | |
| @CONSTITUENTACTION | tinyint | INOUT | |
| @ADDRESSACTION | tinyint | INOUT | |
| @EMAILACTION | tinyint | INOUT | |
| @PHONEACTION | tinyint | INOUT | |
| @PRIMARYRECORDID | uniqueidentifier | INOUT | |
| @ERBCONSTITUENTID | uniqueidentifier | INOUT | |
| @EMAILISPRIMARY | bit | INOUT | |
| @PHONEISPRIMARY | bit | INOUT | |
| @ADDRESSISPRIMARY | bit | INOUT | |
| @CURRENTAPPUSERID | uniqueidentifier | IN | |
| @DECEASED | bit | INOUT | |
| @DECEASEDDATE | UDT_FUZZYDATE | INOUT | |
| @GIVESANONYMOUSLY | bit | INOUT | |
| @MARITALSTATUSCODEID | uniqueidentifier | INOUT | |
| @WEBADDRESS | UDT_WEBADDRESS | INOUT | |
| @ADDRESSHISTORICALSTARTDATE | date | INOUT | |
| @ADDRESSHISTORICALENDDATE | date | INOUT | |
| @ADDRESSDONOTMAIL | bit | INOUT | |
| @ADDRESSDONOTMAILREASONCODEID | uniqueidentifier | INOUT | |
| @ADDRESSSTARTDATE | UDT_MONTHDAY | INOUT | |
| @ADDRESSENDDATE | UDT_MONTHDAY | INOUT | |
| @ADDRESSDPC | nvarchar(max) | INOUT | |
| @ADDRESSCART | nvarchar(max) | INOUT | |
| @ADDRESSLOT | nvarchar(5) | INOUT | |
| @ADDRESSINFOSOURCECODEID | uniqueidentifier | INOUT | |
| @ADDRESSINFOSOURCECOMMENTS | nvarchar(256) | INOUT | |
| @ADDRESSCOUNTYCODEID | uniqueidentifier | INOUT | |
| @ADDRESSREGIONCODEID | uniqueidentifier | INOUT | |
| @ADDRESSCONGRESSIONALDISTRICTCODEID | uniqueidentifier | INOUT | |
| @ADDRESSSTATEHOUSEDISTRICTCODEID | uniqueidentifier | INOUT | |
| @ADDRESSSTATESENATEDISTRICTCODEID | uniqueidentifier | INOUT | |
| @ADDRESSLOCALPRECINCTCODEID | uniqueidentifier | INOUT | |
| @ADDRESSCERTIFICATIONDATA | int | INOUT | |
| @ADDRESSLASTVALIDATIONATTEMPTDATE | date | INOUT | |
| @ADDRESSOMITFROMVALIDATION | bit | INOUT | |
| @ADDRESSVALIDATIONMESSAGE | nvarchar(200) | INOUT | |
| @PHONEDONOTCALL | bit | INOUT | |
| @PHONESTARTTIME | UDT_HOURMINUTE | INOUT | |
| @PHONEENDTIME | UDT_HOURMINUTE | INOUT | |
| @PHONEINFOSOURCECODEID | uniqueidentifier | INOUT | |
| @PHONECOUNTRYID | uniqueidentifier | INOUT | |
| @PHONESTARTDATE | date | INOUT | |
| @PHONEENDDATE | date | INOUT | |
| @PHONESEASONALSTARTDATE | UDT_MONTHDAY | INOUT | |
| @PHONESEASONALENDDATE | UDT_MONTHDAY | INOUT | |
| @EMAILADDRESSDONOTEMAIL | bit | INOUT | |
| @EMAILADDRESSINFOSOURCECODEID | uniqueidentifier | INOUT | |
| @EMAILADDRESSSTARTDATE | date | INOUT | |
| @EMAILADDRESSENDDATE | date | INOUT | |
| @GENDERCODEID | uniqueidentifier | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REVENUEBATCHDUPLICATEMATCH(
@ID uniqueidentifier,
@DATALOADED bit = 0 output,
@TSLONG bigint = 0 output,
@LOOKUPID nvarchar(50) = null output,
@FIRSTNAME nvarchar(50) = null output,
@MIDDLENAME nvarchar(50) = null output,
@LASTNAME nvarchar(100) = null output, -- also used as ORGANIZATIONNAME
@SUFFIXCODEID uniqueidentifier = null output,
@TITLECODEID uniqueidentifier = null output,
@MAIDENNAME nvarchar(100) = null output,
@NICKNAME nvarchar(50) = null output,
@GENDERCODE tinyint = null output,
@BIRTHDATE dbo.UDT_FUZZYDATE = null output,
@ADDRESSID uniqueidentifier = null output,
@ADDRESSTYPECODEID uniqueidentifier = null output,
@ADDRESS_ADDRESSBLOCK nvarchar(150) = null output,
@ADDRESS_CITY nvarchar(50) = null output,
@ADDRESS_STATEID uniqueidentifier = null output,
@ADDRESS_POSTCODE nvarchar(12) = null output,
@ADDRESS_COUNTRYID uniqueidentifier = null output,
@PHONEID uniqueidentifier = null output,
@PHONETYPECODEID uniqueidentifier = null output,
@PHONENUMBER nvarchar(100) = null output,
@EMAILID uniqueidentifier = null output,
@EMAILADDRESSTYPECODEID uniqueidentifier = null output,
@EMAILADDRESS dbo.UDT_EMAILADDRESS = null output,
@CREATEDON datetime = null output,
@DATECHANGED datetime = null output,
@ADDRESSES xml = null output,
@PHONES xml = null output,
@EMAILADDRESSES xml = null output,
@CONSTITUENTACTION tinyint = null output,
@ADDRESSACTION tinyint = null output,
@EMAILACTION tinyint = null output,
@PHONEACTION tinyint = null output,
@PRIMARYRECORDID uniqueidentifier = null output,
@ERBCONSTITUENTID uniqueidentifier = null output,
@EMAILISPRIMARY bit = null output,
@PHONEISPRIMARY bit = null output,
@ADDRESSISPRIMARY bit = null output,
@CURRENTAPPUSERID uniqueidentifier,
@DECEASED bit = null output,
@DECEASEDDATE dbo.UDT_FUZZYDATE = null output,
@GIVESANONYMOUSLY bit = null output,
@MARITALSTATUSCODEID uniqueidentifier = null output,
@WEBADDRESS dbo.UDT_WEBADDRESS = null output,
@ADDRESSHISTORICALSTARTDATE date = null output,
@ADDRESSHISTORICALENDDATE date = null output,
@ADDRESSDONOTMAIL bit = null output,
@ADDRESSDONOTMAILREASONCODEID uniqueidentifier = null output,
@ADDRESSSTARTDATE dbo.UDT_MONTHDAY = null output,
@ADDRESSENDDATE dbo.UDT_MONTHDAY = null output,
@ADDRESSDPC nvarchar(max) = null output,
@ADDRESSCART nvarchar(max) = null output,
@ADDRESSLOT nvarchar(5) = null output,
@ADDRESSINFOSOURCECODEID uniqueidentifier = null output,
@ADDRESSINFOSOURCECOMMENTS nvarchar(256) = null output,
@ADDRESSCOUNTYCODEID uniqueidentifier = null output,
@ADDRESSREGIONCODEID uniqueidentifier = null output,
@ADDRESSCONGRESSIONALDISTRICTCODEID uniqueidentifier = null output,
@ADDRESSSTATEHOUSEDISTRICTCODEID uniqueidentifier = null output,
@ADDRESSSTATESENATEDISTRICTCODEID uniqueidentifier = null output,
@ADDRESSLOCALPRECINCTCODEID uniqueidentifier = null output,
@ADDRESSCERTIFICATIONDATA int = null output,
@ADDRESSLASTVALIDATIONATTEMPTDATE date = null output,
@ADDRESSOMITFROMVALIDATION bit = null output,
@ADDRESSVALIDATIONMESSAGE nvarchar(200) = null output,
@PHONEDONOTCALL bit = null output,
@PHONESTARTTIME dbo.UDT_HOURMINUTE = null output,
@PHONEENDTIME dbo.UDT_HOURMINUTE = null output,
@PHONEINFOSOURCECODEID uniqueidentifier = null output,
@PHONECOUNTRYID uniqueidentifier = null output,
@PHONESTARTDATE date = null output,
@PHONEENDDATE date = null output,
@PHONESEASONALSTARTDATE dbo.UDT_MONTHDAY = null output,
@PHONESEASONALENDDATE dbo.UDT_MONTHDAY = null output,
@EMAILADDRESSDONOTEMAIL bit = null output,
@EMAILADDRESSINFOSOURCECODEID uniqueidentifier = null output,
@EMAILADDRESSSTARTDATE date = null output,
@EMAILADDRESSENDDATE date = null output,
@GENDERCODEID uniqueidentifier = null output
)
as
set nocount on;
-- be sure to set these, in case the select returns no rows
set @DATALOADED = 0
set @TSLONG = 0
select
@DATALOADED = 1,
@TSLONG = TSLONG
from dbo.BATCHREVENUE
where ID = @ID
return 0;