USP_WPMARKETGUIDE_ADD
Adds Prospect Wealth Income/Compensation information for a prospect.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | INOUT | |
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @WEALTHID | uniqueidentifier | IN | |
| @SOURCE | nvarchar(100) | IN | |
| @MGID | 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 | |
| @BB_FULLNAME | nvarchar(100) | IN | |
| @COMPANY | nvarchar(100) | IN | |
| @LONGTITLE | nvarchar(100) | IN | |
| @TICKER | nvarchar(6) | IN | |
| @AGE | int | IN | |
| @BIOGRAPHY | nvarchar(1500) | IN | |
| @OFFICER_DIRECTORFLAG | nvarchar(35) | IN | |
| @OFFSTARTY | nvarchar(4) | IN | |
| @DIRSTARTY | nvarchar(4) | IN | |
| @LATESTCOMPENSATIONYEAR | int | IN | |
| @LATESTFISCALYEARSALARY | money | IN | |
| @LATESTFISCALYEARBONUS | money | IN | |
| @LATESTFISCALYEAROTHERSHORTTERMCOMPENSATION | money | IN | |
| @VALUEOFOPTIONSEXERCISED | money | IN | |
| @VALUEOFOPTIONSUNEXERCISED_EXERCISABLE | money | IN | |
| @VALUEOFOPTIONSUNEXERCISED_UNEXERCISABLE | money | IN | |
| @LATESTFISCALYEAROTHERLONGTERMCOMPENSATION | money | IN |
Definition
Copy
create procedure dbo.USP_WPMARKETGUIDE_ADD (
@ID uniqueidentifier = null output,
@CHANGEAGENTID uniqueidentifier = null,
@WEALTHID uniqueidentifier,
@SOURCE nvarchar(100),
@MGID 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) = '',
@BB_FULLNAME nvarchar(100) = '',
@COMPANY nvarchar(100) = '',
@LONGTITLE nvarchar(100) = '',
@TICKER nvarchar(6) = '',
@AGE int = 0,
@BIOGRAPHY nvarchar(1500) = '',
@OFFICER_DIRECTORFLAG nvarchar(35) = '',
@OFFSTARTY nvarchar(4) = '',
@DIRSTARTY nvarchar(4) = '',
@LATESTCOMPENSATIONYEAR int = 0,
@LATESTFISCALYEARSALARY money = 0,
@LATESTFISCALYEARBONUS money = 0,
@LATESTFISCALYEAROTHERSHORTTERMCOMPENSATION money = 0,
@VALUEOFOPTIONSEXERCISED money = 0,
@VALUEOFOPTIONSUNEXERCISED_EXERCISABLE money = 0,
@VALUEOFOPTIONSUNEXERCISED_UNEXERCISABLE money = 0,
@LATESTFISCALYEAROTHERLONGTERMCOMPENSATION money = 0
) as begin
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output
begin try
if exists(select 1 from dbo.WPMARKETGUIDE where WEALTHID=@WEALTHID and FULLHASH=@FULLHASH)
set @ID = null
else begin
if @ID is null
set @ID = newid()
insert into dbo.WPMARKETGUIDE (
ID,ADDEDBYID,CHANGEDBYID,
WEALTHID,
SOURCE,
MGID,
REVISION,
ORIGINALID,
NEWROW,
LASTCHANGEDON,
ADDEDON,
CDATE,
CVALUE,
CNOTES,
FULLHASH,
PARTIALHASH,
MC,
BB_FULLNAME,
COMPANY,
LONGTITLE,
TICKER,
AGE,
BIOGRAPHY,
OFFICER_DIRECTORFLAG,
OFFSTARTY,
DIRSTARTY,
LATESTCOMPENSATIONYEAR,
LATESTFISCALYEARSALARY,
LATESTFISCALYEARBONUS,
LATESTFISCALYEAROTHERSHORTTERMCOMPENSATION,
VALUEOFOPTIONSEXERCISED,
VALUEOFOPTIONSUNEXERCISED_EXERCISABLE,
VALUEOFOPTIONSUNEXERCISED_UNEXERCISABLE,
LATESTFISCALYEAROTHERLONGTERMCOMPENSATION
) values (
@ID,@CHANGEAGENTID,@CHANGEAGENTID,
@WEALTHID,
@SOURCE,
@MGID,
@REVISION,
@ORIGINALID,
@NEWROW,
@LASTCHANGEDON,
@ADDEDON,
@CDATE,
@CVALUE,
@CNOTES,
@FULLHASH,
@PARTIALHASH,
@MC,
@BB_FULLNAME,
@COMPANY,
@LONGTITLE,
@TICKER,
@AGE,
@BIOGRAPHY,
@OFFICER_DIRECTORFLAG,
@OFFSTARTY,
@DIRSTARTY,
@LATESTCOMPENSATIONYEAR,
@LATESTFISCALYEARSALARY,
@LATESTFISCALYEARBONUS,
@LATESTFISCALYEAROTHERSHORTTERMCOMPENSATION,
@VALUEOFOPTIONSEXERCISED,
@VALUEOFOPTIONSUNEXERCISED_EXERCISABLE,
@VALUEOFOPTIONSUNEXERCISED_UNEXERCISABLE,
@LATESTFISCALYEAROTHERLONGTERMCOMPENSATION
)
end
end try
begin catch
exec dbo.USP_RAISE_ERROR
end catch
return 0
end