USP_WPDUNANDBRADSTREET_ADD
Adds Prospect Wealth Business information for a prospect.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | INOUT | |
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @WEALTHID | uniqueidentifier | IN | |
| @SOURCE | nvarchar(100) | IN | |
| @DBID | int | IN | |
| @REVISION | int | IN | |
| @ORIGINALID | int | IN | |
| @NEWROW | bit | IN | |
| @LASTCHANGEDON | datetime | IN | |
| @ADDEDON | datetime | IN | |
| @CDATE | datetime | IN | |
| @CVALUE | money | IN | |
| @CNOTES | nvarchar(1024) | IN | |
| @FULLHASH | nvarchar(32) | IN | |
| @PARTIALHASH | nvarchar(32) | IN | |
| @MC | nvarchar(2) | IN | |
| @FULLNAME | nvarchar(100) | IN | |
| @TITLE | nvarchar(100) | IN | |
| @LINE1 | nvarchar(150) | IN | |
| @CITY | nvarchar(30) | IN | |
| @STATE | nvarchar(100) | IN | |
| @ZIP | nvarchar(10) | IN | |
| @BIO | nvarchar(1500) | IN | |
| @HELDCODE | tinyint | IN | |
| @COMPANY | nvarchar(100) | IN | |
| @PHONE | nvarchar(20) | IN | |
| @LINE_OF_BUSINESS_DESCRIPTION | nvarchar(50) | IN | |
| @SALES_VOLUME | money | IN | |
| @YEAR_STARTED | int | IN | |
| @EMPLOYEES_TOTAL | int | IN | |
| @SIC_CODE | nvarchar(4) | IN | |
| @DUNS | nvarchar(10) | IN | |
| @PERCENTAGE | decimal(20, 4) | IN | |
| @VALUATION | money | IN | |
| @SPOUSEIND | tinyint | IN |
Definition
Copy
create procedure dbo.USP_WPDUNANDBRADSTREET_ADD (
@ID uniqueidentifier = null output,
@CHANGEAGENTID uniqueidentifier = null,
@WEALTHID uniqueidentifier,
@SOURCE nvarchar(100),
@DBID int = 0,
@REVISION int = 0,
@ORIGINALID int = 0,
@NEWROW bit = 0,
@LASTCHANGEDON datetime = null,
@ADDEDON datetime = null,
@CDATE datetime = null,
@CVALUE money = 0,
@CNOTES nvarchar(1024) = '',
@FULLHASH nvarchar(32) = '',
@PARTIALHASH nvarchar(32) = '',
@MC nvarchar(2) = '',
@FULLNAME nvarchar(100) = '',
@TITLE nvarchar(100) = '',
@LINE1 nvarchar(150) = '',
@CITY nvarchar(30) = '',
@STATE nvarchar(100) = '',
@ZIP nvarchar(10) = '',
@BIO nvarchar(1500) = '',
@HELDCODE tinyint = 2,
@COMPANY nvarchar(100) = '',
@PHONE nvarchar(20) = '',
@LINE_OF_BUSINESS_DESCRIPTION nvarchar(50) = '',
@SALES_VOLUME money = 0,
@YEAR_STARTED int = 0,
@EMPLOYEES_TOTAL int = 0,
@SIC_CODE nvarchar(4) = '',
@DUNS nvarchar(10) = '',
@PERCENTAGE decimal(20,4) = 0,
@VALUATION money = 0,
@SPOUSEIND tinyint = 0
) as begin
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output
begin try
if exists(select 1 from dbo.WPDUNANDBRADSTREET where WEALTHID=@WEALTHID and FULLHASH=@FULLHASH)
set @ID = null
else begin
if @ID is null
set @ID = newid()
insert into dbo.WPDUNANDBRADSTREET (
ID,ADDEDBYID,CHANGEDBYID,
WEALTHID,
SOURCE,
DBID,
REVISION,
ORIGINALID,
NEWROW,
LASTCHANGEDON,
ADDEDON,
CDATE,
CVALUE,
CNOTES,
FULLHASH,
PARTIALHASH,
MC,
FULLNAME,
TITLE,
LINE1,
CITY,
STATE,
ZIP,
BIO,
HELDCODE,
COMPANY,
PHONE,
LINE_OF_BUSINESS_DESCRIPTION,
SALES_VOLUME,
YEAR_STARTED,
EMPLOYEES_TOTAL,
SIC_CODE,
DUNS,
PERCENTAGE,
VALUATION,
SPOUSEIND
) values (
@ID,@CHANGEAGENTID,@CHANGEAGENTID,
@WEALTHID,
@SOURCE,
@DBID,
@REVISION,
@ORIGINALID,
@NEWROW,
@LASTCHANGEDON,
@ADDEDON,
@CDATE,
@CVALUE,
@CNOTES,
@FULLHASH,
@PARTIALHASH,
@MC,
@FULLNAME,
@TITLE,
@LINE1,
@CITY,
@STATE,
@ZIP,
@BIO,
@HELDCODE,
@COMPANY,
@PHONE,
@LINE_OF_BUSINESS_DESCRIPTION,
@SALES_VOLUME,
@YEAR_STARTED,
@EMPLOYEES_TOTAL,
@SIC_CODE,
@DUNS,
@PERCENTAGE,
@VALUATION,
@SPOUSEIND
)
end
end try
begin catch
exec dbo.USP_RAISE_ERROR
end catch
return 0
end