USP_WPLEXISNEXIS_ADD
Adds Prospect Wealth Real Estate information for a prospect.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | INOUT | |
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @WEALTHID | uniqueidentifier | IN | |
| @SOURCE | nvarchar(100) | IN | |
| @LXID | 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 | |
| @DEEDTYPE | nvarchar(100) | IN | |
| @DOCUMENTNUMBER | nvarchar(200) | IN | |
| @SALEPRICE | money | IN | |
| @RECORDEDDATE | nvarchar(200) | IN | |
| @SALEDATE | datetime | IN | |
| @BUYERMAILINGADDRESS | nvarchar(200) | IN | |
| @SELLERMAILINGADDRESS | nvarchar(200) | IN | |
| @SELLER | nvarchar(300) | IN | |
| @BUYER | nvarchar(300) | IN | |
| @LEGALDESCRIPTION | nvarchar(2000) | IN | |
| @PROPERTYUSE | nvarchar(100) | IN | |
| @LOTSIZE | nvarchar(50) | IN | |
| @ROOF | nvarchar(30) | IN | |
| @FOUNDATION | nvarchar(30) | IN | |
| @EXTERIORWALLS | nvarchar(30) | IN | |
| @BASEMENT | nvarchar(30) | IN | |
| @CONSTRUCTION | nvarchar(30) | IN | |
| @HEATING | nvarchar(1000) | IN | |
| @AIRCONDITIONING | nvarchar(30) | IN | |
| @STYLE | nvarchar(30) | IN | |
| @ELEVATOR | nvarchar(5) | IN | |
| @NOOFBUILDINGS | nvarchar(5) | IN | |
| @BUILDINGAREA | nvarchar(10) | IN | |
| @GARAGETYPE | nvarchar(30) | IN | |
| @FIREPLACE | nvarchar(5) | IN | |
| @TOTALROOMS | nvarchar(5) | IN | |
| @PARTIALBATHS | nvarchar(5) | IN | |
| @BATHS | nvarchar(5) | IN | |
| @BEDROOMS | nvarchar(5) | IN | |
| @UNITS | nvarchar(10) | IN | |
| @STORIES | nvarchar(50) | IN | |
| @POOLSPA | nvarchar(30) | IN | |
| @YEARBUILT | nvarchar(4) | IN | |
| @OWNER | nvarchar(300) | IN | |
| @BB_COUNTY | nvarchar(255) | IN | |
| @MAILINGADDRESS | nvarchar(200) | IN | |
| @TITLECOMPANY | nvarchar(50) | IN | |
| @TERM | nvarchar(20) | IN | |
| @LOANAMOUNT | money | IN | |
| @TYPEOFMORTGAGE | nvarchar(100) | IN | |
| @LENDER | nvarchar(100) | IN | |
| @LENDERTYPE | nvarchar(50) | IN | |
| @LOANTYPE | nvarchar(50) | IN | |
| @DUEDATE | datetime | IN | |
| @ASSESSORSPARCELNUMBER | nvarchar(100) | IN | |
| @LANDUSE | nvarchar(100) | IN | |
| @TAXRATECODE | nvarchar(50) | IN | |
| @MARKETIMPROVEMENTVALUE | money | IN | |
| @TOTALMARKETVALUE | money | IN | |
| @MARKETLANDVALUE | money | IN | |
| @MARKETVALUEYEAR | nvarchar(4) | IN | |
| @ASSESSEDMULTIPLIER | nvarchar(5) | IN | |
| @ASSESSMENTYEAR | nvarchar(4) | IN | |
| @ASSESSEDIMPROVEMENTVALUE | money | IN | |
| @ASSESSEDTOTALVALUE | money | IN | |
| @ASSESSEDLANDVALUE | money | IN | |
| @PROPADDRESS | nvarchar(150) | IN | |
| @PROPCITY | nvarchar(50) | IN | |
| @PROPSTATE | nvarchar(100) | IN | |
| @PROPZIP | nvarchar(10) | IN | |
| @BB_VALUE | money | IN | |
| @INPUT_BBAID | nvarchar(100) | IN | |
| @PROPERTYRECORDFOR | nvarchar(50) | IN | |
| @PROPERTYTRANSFERRECORDFOR | nvarchar(50) | IN | |
| @BORROWERS | nvarchar(200) | IN | |
| @MORTGAGERECORDFOR | nvarchar(50) | IN |
Definition
Copy
create procedure dbo.USP_WPLEXISNEXIS_ADD (
@ID uniqueidentifier = null output,
@CHANGEAGENTID uniqueidentifier = null,
@WEALTHID uniqueidentifier,
@SOURCE nvarchar(100),
@LXID 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) = '',
@DEEDTYPE nvarchar(100) = '',
@DOCUMENTNUMBER nvarchar(200) = '',
@SALEPRICE money = 0,
@RECORDEDDATE nvarchar(200) = '',
@SALEDATE datetime = null,
@BUYERMAILINGADDRESS nvarchar(200) = '',
@SELLERMAILINGADDRESS nvarchar(200) = '',
@SELLER nvarchar(300) = '',
@BUYER nvarchar(300) = '',
@LEGALDESCRIPTION nvarchar(2000) = '',
@PROPERTYUSE nvarchar(100) = '',
@LOTSIZE nvarchar(50) = '',
@ROOF nvarchar(30) = '',
@FOUNDATION nvarchar(30) = '',
@EXTERIORWALLS nvarchar(30) = '',
@BASEMENT nvarchar(30) = '',
@CONSTRUCTION nvarchar(30) = '',
@HEATING nvarchar(1000) = '',
@AIRCONDITIONING nvarchar(30) = '',
@STYLE nvarchar(30) = '',
@ELEVATOR nvarchar(5) = '',
@NOOFBUILDINGS nvarchar(5) = '',
@BUILDINGAREA nvarchar(10) = '',
@GARAGETYPE nvarchar(30) = '',
@FIREPLACE nvarchar(5) = '',
@TOTALROOMS nvarchar(5) = '',
@PARTIALBATHS nvarchar(5) = '',
@BATHS nvarchar(5) = '',
@BEDROOMS nvarchar(5) = '',
@UNITS nvarchar(10) = '',
@STORIES nvarchar(50) = '',
@POOLSPA nvarchar(30) = '',
@YEARBUILT nvarchar(4) = '',
@OWNER nvarchar(300) = '',
@BB_COUNTY nvarchar(255) = '',
@MAILINGADDRESS nvarchar(200) = '',
@TITLECOMPANY nvarchar(50) = '',
@TERM nvarchar(20) = '',
@LOANAMOUNT money = 0,
@TYPEOFMORTGAGE nvarchar(100) = '',
@LENDER nvarchar(100) = '',
@LENDERTYPE nvarchar(50) = '',
@LOANTYPE nvarchar(50) = '',
@DUEDATE datetime = null,
@ASSESSORSPARCELNUMBER nvarchar(100) = '',
@LANDUSE nvarchar(100) = '',
@TAXRATECODE nvarchar(50) = '',
@MARKETIMPROVEMENTVALUE money = 0,
@TOTALMARKETVALUE money = 0,
@MARKETLANDVALUE money = 0,
@MARKETVALUEYEAR nvarchar(4) = '',
@ASSESSEDMULTIPLIER nvarchar(5) = '',
@ASSESSMENTYEAR nvarchar(4) = '',
@ASSESSEDIMPROVEMENTVALUE money = 0,
@ASSESSEDTOTALVALUE money = 0,
@ASSESSEDLANDVALUE money = 0,
@PROPADDRESS nvarchar(150) = '',
@PROPCITY nvarchar(50) = '',
@PROPSTATE nvarchar(100) = '',
@PROPZIP nvarchar(10) = '',
@BB_VALUE money = null,
@INPUT_BBAID nvarchar(100) = '',
@PROPERTYRECORDFOR nvarchar(50) = '',
@PROPERTYTRANSFERRECORDFOR nvarchar(50) = '',
@BORROWERS nvarchar(200) = '',
@MORTGAGERECORDFOR nvarchar(50) = ''
) as begin
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output
begin try
if exists(select 1 from dbo.WPLEXISNEXIS where WEALTHID=@WEALTHID and FULLHASH=@FULLHASH)
set @ID = null
else begin
if @ID is null
set @ID = newid()
insert into dbo.WPLEXISNEXIS (
ID,ADDEDBYID,CHANGEDBYID,
WEALTHID,
SOURCE,
LXID,
REVISION,
ORIGINALID,
NEWROW,
LASTCHANGEDON,
ADDEDON,
CDATE,
CVALUE,
CNOTES,
FULLHASH,
PARTIALHASH,
MC,
DEEDTYPE,
DOCUMENTNUMBER,
SALEPRICE,
RECORDEDDATE,
SALEDATE,
BUYERMAILINGADDRESS,
SELLERMAILINGADDRESS,
SELLER,
BUYER,
LEGALDESCRIPTION,
PROPERTYUSE,
LOTSIZE,
ROOF,
FOUNDATION,
EXTERIORWALLS,
BASEMENT,
CONSTRUCTION,
HEATING,
AIRCONDITIONING,
STYLE,
ELEVATOR,
NOOFBUILDINGS,
BUILDINGAREA,
GARAGETYPE,
FIREPLACE,
TOTALROOMS,
PARTIALBATHS,
BATHS,
BEDROOMS,
UNITS,
STORIES,
POOLSPA,
YEARBUILT,
OWNER,
BB_COUNTY,
MAILINGADDRESS,
TITLECOMPANY,
TERM,
LOANAMOUNT,
TYPEOFMORTGAGE,
LENDER,
LENDERTYPE,
LOANTYPE,
DUEDATE,
ASSESSORSPARCELNUMBER,
LANDUSE,
TAXRATECODE,
MARKETIMPROVEMENTVALUE,
TOTALMARKETVALUE,
MARKETLANDVALUE,
MARKETVALUEYEAR,
ASSESSEDMULTIPLIER,
ASSESSMENTYEAR,
ASSESSEDIMPROVEMENTVALUE,
ASSESSEDTOTALVALUE,
ASSESSEDLANDVALUE,
PROPADDRESS,
PROPCITY,
PROPSTATE,
PROPZIP,
BB_VALUE,
INPUT_BBAID,
PROPERTYRECORDFOR,
PROPERTYTRANSFERRECORDFOR,
BORROWERS,
MORTGAGERECORDFOR
) values (
@ID,@CHANGEAGENTID,@CHANGEAGENTID,
@WEALTHID,
@SOURCE,
@LXID,
@REVISION,
@ORIGINALID,
@NEWROW,
@LASTCHANGEDON,
@ADDEDON,
@CDATE,
@CVALUE,
@CNOTES,
@FULLHASH,
@PARTIALHASH,
@MC,
@DEEDTYPE,
@DOCUMENTNUMBER,
@SALEPRICE,
@RECORDEDDATE,
@SALEDATE,
@BUYERMAILINGADDRESS,
@SELLERMAILINGADDRESS,
@SELLER,
@BUYER,
@LEGALDESCRIPTION,
@PROPERTYUSE,
@LOTSIZE,
@ROOF,
@FOUNDATION,
@EXTERIORWALLS,
@BASEMENT,
@CONSTRUCTION,
@HEATING,
@AIRCONDITIONING,
@STYLE,
@ELEVATOR,
@NOOFBUILDINGS,
@BUILDINGAREA,
@GARAGETYPE,
@FIREPLACE,
@TOTALROOMS,
@PARTIALBATHS,
@BATHS,
@BEDROOMS,
@UNITS,
@STORIES,
@POOLSPA,
@YEARBUILT,
@OWNER,
@BB_COUNTY,
@MAILINGADDRESS,
@TITLECOMPANY,
@TERM,
@LOANAMOUNT,
@TYPEOFMORTGAGE,
@LENDER,
@LENDERTYPE,
@LOANTYPE,
@DUEDATE,
@ASSESSORSPARCELNUMBER,
@LANDUSE,
@TAXRATECODE,
@MARKETIMPROVEMENTVALUE,
@TOTALMARKETVALUE,
@MARKETLANDVALUE,
@MARKETVALUEYEAR,
@ASSESSEDMULTIPLIER,
@ASSESSMENTYEAR,
@ASSESSEDIMPROVEMENTVALUE,
@ASSESSEDTOTALVALUE,
@ASSESSEDLANDVALUE,
@PROPADDRESS,
@PROPCITY,
@PROPSTATE,
@PROPZIP,
@BB_VALUE,
@INPUT_BBAID,
@PROPERTYRECORDFOR,
@PROPERTYTRANSFERRECORDFOR,
@BORROWERS,
@MORTGAGERECORDFOR
)
end
end try
begin catch
exec dbo.USP_RAISE_ERROR
end catch
return 0
end