USP_WPFOUNDATIONASSETS_ADD
Adds Prospect Wealth Private Foundations information for a prospect.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | INOUT | |
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @WEALTHID | uniqueidentifier | IN | |
| @SOURCE | nvarchar(100) | IN | |
| @FAID | 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 | |
| @RULING_YEAR | int | IN | |
| @YEAR_ENDING | datetime | IN | |
| @EIN | nvarchar(30) | IN | |
| @COMPANY | nvarchar(150) | IN | |
| @LINE1 | nvarchar(150) | IN | |
| @CITY | nvarchar(30) | IN | |
| @STATE | nvarchar(100) | IN | |
| @ZIP | nvarchar(10) | IN | |
| @PHONE | nvarchar(25) | IN | |
| @DESCRIPTION | nvarchar(150) | IN | |
| @TOTALASSETS_FMV | money | IN | |
| @FULLNAME | nvarchar(150) | IN | |
| @TITLE | nvarchar(30) | IN | |
| @COMP | money | IN |
Definition
Copy
create procedure dbo.USP_WPFOUNDATIONASSETS_ADD (
@ID uniqueidentifier = null output,
@CHANGEAGENTID uniqueidentifier = null,
@WEALTHID uniqueidentifier,
@SOURCE nvarchar(100),
@FAID 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) = '',
@RULING_YEAR int = 0,
@YEAR_ENDING datetime = null,
@EIN nvarchar(30) = '',
@COMPANY nvarchar(150) = '',
@LINE1 nvarchar(150) = '',
@CITY nvarchar(30) = '',
@STATE nvarchar(100) = '',
@ZIP nvarchar(10) = '',
@PHONE nvarchar(25) = '',
@DESCRIPTION nvarchar(150) = '',
@TOTALASSETS_FMV money = 0,
@FULLNAME nvarchar(150) = '',
@TITLE nvarchar(30) = '',
@COMP money = 0
) as begin
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output
begin try
if exists(select 1 from dbo.WPFOUNDATIONASSETS where WEALTHID=@WEALTHID and FULLHASH=@FULLHASH)
set @ID = null
else begin
if @ID is null
set @ID = newid()
insert into dbo.WPFOUNDATIONASSETS (
ID,ADDEDBYID,CHANGEDBYID,
WEALTHID,
SOURCE,
FAID,
REVISION,
ORIGINALID,
NEWROW,
LASTCHANGEDON,
ADDEDON,
CDATE,
CVALUE,
CNOTES,
FULLHASH,
PARTIALHASH,
MC,
RULING_YEAR,
YEAR_ENDING,
EIN,
COMPANY,
LINE1,
CITY,
STATE,
ZIP,
PHONE,
DESCRIPTION,
TOTALASSETS_FMV,
FULLNAME,
TITLE,
COMP
) values (
@ID,@CHANGEAGENTID,@CHANGEAGENTID,
@WEALTHID,
@SOURCE,
@FAID,
@REVISION,
@ORIGINALID,
@NEWROW,
@LASTCHANGEDON,
@ADDEDON,
@CDATE,
@CVALUE,
@CNOTES,
@FULLHASH,
@PARTIALHASH,
@MC,
@RULING_YEAR,
@YEAR_ENDING,
@EIN,
@COMPANY,
@LINE1,
@CITY,
@STATE,
@ZIP,
@PHONE,
@DESCRIPTION,
@TOTALASSETS_FMV,
@FULLNAME,
@TITLE,
@COMP
)
end
end try
begin catch
exec dbo.USP_RAISE_ERROR
end catch
return 0
end