USP_DATAFORMTEMPLATE_ADDSAVE_WPREALESTATE_4
The save procedure used by the add dataform template "WealthPoint Real Estate Add Form 4".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | INOUT | The output parameter indicating the ID of the record added. |
| @WEALTHID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @SOURCE | nvarchar(100) | IN | Source |
| @CNOTES | nvarchar(1024) | IN | Notes |
| @DEEDTYPE | nvarchar(100) | IN | Document type |
| @SALEPRICE | money | IN | Sales price |
| @SALEDATE | datetime | IN | Date of contract |
| @BUYERMAILINGADDRESS | nvarchar(200) | IN | Buyer address |
| @SELLERMAILINGADDRESS | nvarchar(200) | IN | Seller address |
| @SELLER | nvarchar(300) | IN | Seller #1 name |
| @BUYER | nvarchar(300) | IN | Buyer #1 name |
| @LEGALDESCRIPTION | nvarchar(2000) | IN | Brief description |
| @PROPERTYUSE | nvarchar(100) | IN | County description |
| @LOTSIZE | nvarchar(50) | IN | Lot-size or area |
| @ROOF | nvarchar(30) | IN | Roof cover |
| @FOUNDATION | nvarchar(30) | IN | Foundation |
| @EXTERIORWALLS | nvarchar(30) | IN | Exterior walls |
| @BASEMENT | nvarchar(30) | IN | Basement |
| @CONSTRUCTION | nvarchar(30) | IN | Construction |
| @HEATING | nvarchar(30) | IN | Heating |
| @AIRCONDITIONING | nvarchar(30) | IN | Air conditioning |
| @STYLE | nvarchar(30) | IN | Style |
| @ELEVATOR | nvarchar(5) | IN | Elevator |
| @NOOFBUILDINGS | nvarchar(5) | IN | No. buildings |
| @BUILDINGAREA | nvarchar(10) | IN | Building area |
| @GARAGETYPE | nvarchar(30) | IN | Garage type |
| @FIREPLACE | nvarchar(5) | IN | Fireplace |
| @TOTALROOMS | nvarchar(5) | IN | Total # rooms |
| @PARTIALBATHS | nvarchar(5) | IN | Partial baths |
| @BATHS | nvarchar(5) | IN | No. baths |
| @BEDROOMS | nvarchar(5) | IN | No. of bedrooms |
| @UNITS | nvarchar(10) | IN | No. of units |
| @STORIES | nvarchar(50) | IN | No. of stories |
| @POOLSPA | nvarchar(30) | IN | Pool |
| @YEARBUILT | UDT_YEAR | IN | Year built |
| @OWNER | nvarchar(300) | IN | Owner |
| @BB_COUNTY | nvarchar(255) | IN | County |
| @MAILINGADDRESS | nvarchar(200) | IN | Mailing address |
| @LOANAMOUNT | money | IN | Loan amount |
| @TYPEOFMORTGAGE | nvarchar(100) | IN | Type of financing |
| @LENDER | nvarchar(100) | IN | Lender name |
| @LOANTYPE | nvarchar(50) | IN | Loan type |
| @DUEDATE | datetime | IN | Due date |
| @ASSESSORSPARCELNUMBER | nvarchar(100) | IN | APN |
| @LANDUSE | nvarchar(100) | IN | County code |
| @MARKETIMPROVEMENTVALUE | money | IN | Market improvement value |
| @TOTALMARKETVALUE | money | IN | Total market value |
| @MARKETLANDVALUE | money | IN | Market land value |
| @MARKETVALUEYEAR | UDT_YEAR | IN | Market value year |
| @ASSESSMENTYEAR | UDT_YEAR | IN | Assessed value year |
| @ASSESSEDIMPROVEMENTVALUE | money | IN | Assessed improvement value |
| @ASSESSEDTOTALVALUE | money | IN | Total assessed value |
| @ASSESSEDLANDVALUE | money | IN | Assessed land value |
| @PROPADDRESS | nvarchar(150) | IN | Address |
| @PROPCITY | nvarchar(50) | IN | City |
| @PROPSTATE | nvarchar(100) | IN | State |
| @PROPZIP | nvarchar(10) | IN | ZIP |
| @BORROWERS | nvarchar(200) | IN | Borrower #1 name |
| @TAPECUTDATE | UDT_FUZZYDATE | IN | Tape cut date |
| @OWNERCAREOFNAME | nvarchar(40) | IN | Care of name |
| @ASSESSEENAME | nvarchar(80) | IN | Assessee #1 name |
| @ASSESSEENAME2 | nvarchar(60) | IN | Assessee #2 name |
| @ASSESSEECAREOFNAME | nvarchar(60) | IN | Care of name |
| @ASSESSEEMAILINGADDRESS | nvarchar(200) | IN | Assessee address |
| @ASSESSMENTRECORDINGDATE | datetime | IN | Recording date |
| @DOCUMENTTYPE | nvarchar(25) | IN | Document type |
| @ASSESSMENTSALEPRICE | money | IN | Sales price |
| @ASSESSMENTSALEPRICECODE | nvarchar(130) | IN | Sales price indicator |
| @LEGALLOTNUMBER | nvarchar(7) | IN | Lot number |
| @LEGALBLOCK | nvarchar(7) | IN | Block |
| @LEGALUNIT | nvarchar(6) | IN | Unit |
| @LEGALCITY | nvarchar(30) | IN | City/township |
| @LEGALSUBDIVISION | nvarchar(40) | IN | Subdivision name |
| @LANDUSECODE | nvarchar(4) | IN | Standardized code |
| @PARKINGNUMBEROFCARS | nvarchar(5) | IN | Parking # of cars |
| @BUILDINGCLASS | nvarchar(250) | IN | Building class |
| @BUYER2 | nvarchar(300) | IN | Buyer #2 name |
| @BUYERVESTING | nvarchar(50) | IN | Buyer vesting |
| @BUYERCAREOFNAME | nvarchar(40) | IN | Care of name |
| @SELLER2 | nvarchar(300) | IN | Seller #2 name |
| @PROPUSECODE | nvarchar(45) | IN | Property use |
| @CONCURRENTLOANAMOUNT | money | IN | Loan amount |
| @CONCURRENTLOANTYPE | nvarchar(35) | IN | Loan type |
| @CONCURRENTTYPEFINANCING | nvarchar(30) | IN | Type of financing |
| @CONCURRENTDUEDATE | datetime | IN | Due date |
| @CONCURRENTLENDERNAME | nvarchar(40) | IN | Lender name |
| @DEEDTITLECOMPANY | nvarchar(28) | IN | Title company |
| @DEEDLEGALLOTCODE | nvarchar(2) | IN | Lot code |
| @DEEDLEGALLOTNUMBER | nvarchar(10) | IN | Lot number |
| @DEEDLEGALBLOCK | nvarchar(7) | IN | Block |
| @DEEDLEGALUNIT | nvarchar(6) | IN | Unit |
| @DEEDLEGALCITY | nvarchar(30) | IN | City/township |
| @DEEDLEGALSUBDIVISION | nvarchar(50) | IN | Subdivision |
| @DEEDLEGALBRIEFDESCRIPTION | nvarchar(100) | IN | Brief description |
| @DEEDRECORDINGDATE | datetime | IN | Recording date |
| @MORTRECORDINGDATE | datetime | IN | Recording date |
| @BORROWERS2 | nvarchar(200) | IN | Borrower #2 name |
| @VESTINGCODE | nvarchar(50) | IN | Borrower vesting |
| @BORROWERMAILINGADDRESS | nvarchar(200) | IN | Borrower address |
| @ORIGINALCONTRACTDATE | datetime | IN | Date of contract |
| @MORT2_RECORDINGDATE | datetime | IN | Recording date |
| @MORT2_BORROWERS | nvarchar(200) | IN | Borrower #1 name |
| @MORT2_BORROWERS2 | nvarchar(200) | IN | Borrower #2 name |
| @MORT2_VESTINGCODE | nvarchar(50) | IN | Borrower vesting |
| @MORT2_BORROWERMAILINGADDRESS | nvarchar(200) | IN | Borrower address |
| @MORT2_ORIGINALCONTRACTDATE | datetime | IN | Date of contract |
| @MORT2_LOANAMOUNT | money | IN | Loan amount |
| @MORT2_LOANTYPE | nvarchar(50) | IN | Loan type |
| @MORT2_TYPEOFMORTGAGE | nvarchar(100) | IN | Type of financing |
| @MORT2_DUEDATE | datetime | IN | Due date |
| @MORT2_LENDER | nvarchar(100) | IN | Lender name |
| @SUMMARYSALESVALUE | money | IN | Sales amount |
| @SUMMARYSALESRECORDINGDATE | datetime | IN | Reported date |
| @PROPERTYVALUATION | money | IN | Property valuation |
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADDSAVE_WPREALESTATE_4(
@ID uniqueidentifier = null output,
@WEALTHID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@SOURCE nvarchar(100),
@CNOTES nvarchar(1024) = '',
@DEEDTYPE nvarchar(100) = '',
@SALEPRICE money = 0,
@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(30) = '',
@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 dbo.UDT_YEAR = 0,
@OWNER nvarchar(300) = '',
@BB_COUNTY nvarchar(255) = '',
@MAILINGADDRESS nvarchar(200) = '',
@LOANAMOUNT money = 0,
@TYPEOFMORTGAGE nvarchar(100) = '',
@LENDER nvarchar(100) = '',
@LOANTYPE nvarchar(50) = '',
@DUEDATE datetime = null,
@ASSESSORSPARCELNUMBER nvarchar(100) = '',
@LANDUSE nvarchar(100) = '',
@MARKETIMPROVEMENTVALUE money = 0,
@TOTALMARKETVALUE money = 0,
@MARKETLANDVALUE money = 0,
@MARKETVALUEYEAR dbo.UDT_YEAR = 0,
@ASSESSMENTYEAR dbo.UDT_YEAR = 0,
@ASSESSEDIMPROVEMENTVALUE money = 0,
@ASSESSEDTOTALVALUE money = 0,
@ASSESSEDLANDVALUE money = 0,
@PROPADDRESS nvarchar(150) = '',
@PROPCITY nvarchar(50) = '',
@PROPSTATE nvarchar(100) = '',
@PROPZIP nvarchar(10) = '',
@BORROWERS nvarchar(200) = '',
@TAPECUTDATE dbo.UDT_FUZZYDATE = '00000000',
@OWNERCAREOFNAME nvarchar(40) = '',
@ASSESSEENAME nvarchar(80) = '',
@ASSESSEENAME2 nvarchar(60) = '',
@ASSESSEECAREOFNAME nvarchar(60) = '',
@ASSESSEEMAILINGADDRESS nvarchar(200) = '',
@ASSESSMENTRECORDINGDATE datetime = null,
@DOCUMENTTYPE nvarchar(25) = '',
@ASSESSMENTSALEPRICE money = 0,
@ASSESSMENTSALEPRICECODE nvarchar(130) = '',
@LEGALLOTNUMBER nvarchar(7) = '',
@LEGALBLOCK nvarchar(7) = '',
@LEGALUNIT nvarchar(6) = '',
@LEGALCITY nvarchar(30) = '',
@LEGALSUBDIVISION nvarchar(40) = '',
@LANDUSECODE nvarchar(4) = '',
@PARKINGNUMBEROFCARS nvarchar(5) = '',
@BUILDINGCLASS nvarchar(250) = '',
@BUYER2 nvarchar(300) = '',
@BUYERVESTING nvarchar(50) = '',
@BUYERCAREOFNAME nvarchar(40) = '',
@SELLER2 nvarchar(300) = '',
@PROPUSECODE nvarchar(45) = '',
@CONCURRENTLOANAMOUNT money = 0,
@CONCURRENTLOANTYPE nvarchar(35) = '',
@CONCURRENTTYPEFINANCING nvarchar(30) = '',
@CONCURRENTDUEDATE datetime = '',
@CONCURRENTLENDERNAME nvarchar(40) = '',
@DEEDTITLECOMPANY nvarchar(28) = '',
@DEEDLEGALLOTCODE nvarchar(2) = '',
@DEEDLEGALLOTNUMBER nvarchar(10) = '',
@DEEDLEGALBLOCK nvarchar(7) = '',
@DEEDLEGALUNIT nvarchar(6) = '',
@DEEDLEGALCITY nvarchar(30) = '',
@DEEDLEGALSUBDIVISION nvarchar(50) = '',
@DEEDLEGALBRIEFDESCRIPTION nvarchar(100) = '',
@DEEDRECORDINGDATE datetime = null,
@MORTRECORDINGDATE datetime = null,
@BORROWERS2 nvarchar(200) = '',
@VESTINGCODE nvarchar(50) = '',
@BORROWERMAILINGADDRESS nvarchar(200) = '',
@ORIGINALCONTRACTDATE datetime = null,
@MORT2_RECORDINGDATE datetime = null,
@MORT2_BORROWERS nvarchar(200) = '',
@MORT2_BORROWERS2 nvarchar(200) = '',
@MORT2_VESTINGCODE nvarchar(50) = '',
@MORT2_BORROWERMAILINGADDRESS nvarchar(200) = '',
@MORT2_ORIGINALCONTRACTDATE datetime = null,
@MORT2_LOANAMOUNT money = 0,
@MORT2_LOANTYPE nvarchar(50) = '',
@MORT2_TYPEOFMORTGAGE nvarchar(100) = '',
@MORT2_DUEDATE datetime = null,
@MORT2_LENDER nvarchar(100) = '',
@SUMMARYSALESVALUE money = 0,
@SUMMARYSALESRECORDINGDATE datetime = null,
@PROPERTYVALUATION money = 0,
@CURRENTAPPUSERID uniqueidentifier
) as begin
set nocount on;
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
if @ID is null
set @ID = newid();
exec dbo.USP_WEALTH_CREATE @WEALTHID, @CHANGEAGENTID;
declare @CURRENTDATE datetime;
set @CURRENTDATE = getdate();
declare @CONFIRMED bit;
declare @CONFIRMEDBYAPPUSERID uniqueidentifier;
declare @DATECONFIRMED datetime;
declare @REJECTED bit;
declare @REJECTEDBYAPPUSERID uniqueidentifier;
declare @DATEREJECTED datetime;
set @CONFIRMED = 0;
set @REJECTED = 0;
if @CURRENTAPPUSERID is not null
begin
select
@REJECTED = case MANUALCONFIDENCE
when 5 then 0
when 0 then 1
end,
@DATEREJECTED = case MANUALCONFIDENCE
when 5 then NULL
when 0 then @CURRENTDATE
end,
@REJECTEDBYAPPUSERID = case MANUALCONFIDENCE
when 5 then NULL
when 0 then @CURRENTAPPUSERID
end,
@CONFIRMED = case MANUALCONFIDENCE
when 5 then 1
when 0 then 0
end,
@DATECONFIRMED = case MANUALCONFIDENCE
when 5 then @CURRENTDATE
when 0 then NULL
end,
@CONFIRMEDBYAPPUSERID = case MANUALCONFIDENCE
when 5 then @CURRENTAPPUSERID
when 0 then NULL
end
from
dbo.WEALTHPOINTCONFIGURATION
where
MANUALCONFIDENCE in (0,5)
end
--wealth source updates
if(select
count(WEALTHSOURCE.SOURCE)
from
dbo.WEALTHSOURCE
where SOURCE = @SOURCE
) = 0
begin
insert into dbo.WEALTHSOURCE (
[SOURCE],
[ISBUILTIN],
[ADDEDBYID],
[CHANGEDBYID]
)values(
@SOURCE,
0,
@CHANGEAGENTID,
@CHANGEAGENTID
);
end
if(
not exists (select top 1 1 from dbo.WEALTHCAPACITYFORMULAREALESTATESOURCE where SOURCE = @SOURCE)
and
not exists (select top 1 1 from dbo.WPREALESTATE where SOURCE = @SOURCE)
)
begin
insert into WEALTHCAPACITYFORMULAREALESTATESOURCE(
WEALTHCAPACITYFORMULAID,
[SOURCE],
[ADDEDBYID],
[CHANGEDBYID],
[DATEADDED],
[DATECHANGED]
)
select
ID,
@SOURCE,
@CHANGEAGENTID,
@CHANGEAGENTID,
@CURRENTDATE,
@CURRENTDATE
from WEALTHCAPACITYFORMULA;
end
insert into dbo.WPREALESTATE (
ID,
WEALTHID,
CHANGEDBYID,
ADDEDBYID,
SOURCE,
CNOTES,
DEEDTYPE,
SALEPRICE,
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,
LOANAMOUNT,
TYPEOFMORTGAGE,
LENDER,
LOANTYPE,
DUEDATE,
ASSESSORSPARCELNUMBER,
LANDUSE,
MARKETIMPROVEMENTVALUE,
TOTALMARKETVALUE,
MARKETLANDVALUE,
MARKETVALUEYEAR,
ASSESSMENTYEAR,
ASSESSEDIMPROVEMENTVALUE,
ASSESSEDTOTALVALUE,
ASSESSEDLANDVALUE,
PROPADDRESS,
PROPCITY,
PROPSTATE,
PROPZIP,
BORROWERS,
TAPECUTDATE,
OWNERCAREOFNAME,
ASSESSEENAME,
ASSESSEENAME2,
ASSESSEECAREOFNAME,
ASSESSEEMAILINGADDRESS,
ASSESSMENTRECORDINGDATE,
DOCUMENTTYPE,
ASSESSMENTSALEPRICE,
ASSESSMENTSALEPRICECODE,
LEGALLOTNUMBER,
LEGALBLOCK,
LEGALUNIT,
LEGALCITY,
LEGALSUBDIVISION,
LANDUSECODE,
PARKINGNUMBEROFCARS,
BUILDINGCLASS,
BUYER2,
BUYERVESTING,
BUYERCAREOFNAME,
SELLER2,
PROPUSECODE,
CONCURRENTLOANAMOUNT,
CONCURRENTLOANTYPE,
CONCURRENTTYPEFINANCING,
CONCURRENTDUEDATE,
CONCURRENTLENDERNAME,
DEEDTITLECOMPANY,
DEEDLEGALLOTCODE,
DEEDLEGALLOTNUMBER,
DEEDLEGALBLOCK,
DEEDLEGALUNIT,
DEEDLEGALCITY,
DEEDLEGALSUBDIVISION,
DEEDLEGALBRIEFDESCRIPTION,
DEEDRECORDINGDATE,
MORTRECORDINGDATE,
BORROWERS2,
VESTINGCODE,
BORROWERMAILINGADDRESS,
ORIGINALCONTRACTDATE,
MORT2_RECORDINGDATE,
MORT2_BORROWERS,
MORT2_BORROWERS2,
MORT2_VESTINGCODE,
MORT2_BORROWERMAILINGADDRESS,
MORT2_ORIGINALCONTRACTDATE,
MORT2_LOANAMOUNT,
MORT2_LOANTYPE,
MORT2_TYPEOFMORTGAGE,
MORT2_DUEDATE,
MORT2_LENDER,
SUMMARYSALESVALUE,
SUMMARYSALESRECORDINGDATE,
PROPERTYVALUATION,
CONFIRMED,
CONFIRMEDBYAPPUSERID,
DATECONFIRMED,
REJECTED,
REJECTEDBYAPPUSERID,
DATEREJECTED,
HISTORICSET
) values (
@ID,
@WEALTHID,
@CHANGEAGENTID,
@CHANGEAGENTID,
@SOURCE,
@CNOTES,
@DEEDTYPE,
@SALEPRICE,
@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,
@LOANAMOUNT,
@TYPEOFMORTGAGE,
@LENDER,
@LOANTYPE,
@DUEDATE,
@ASSESSORSPARCELNUMBER,
@LANDUSE,
@MARKETIMPROVEMENTVALUE,
@TOTALMARKETVALUE,
@MARKETLANDVALUE,
@MARKETVALUEYEAR,
@ASSESSMENTYEAR,
@ASSESSEDIMPROVEMENTVALUE,
@ASSESSEDTOTALVALUE,
@ASSESSEDLANDVALUE,
@PROPADDRESS,
@PROPCITY,
@PROPSTATE,
@PROPZIP,
@BORROWERS,
@TAPECUTDATE,
@OWNERCAREOFNAME,
@ASSESSEENAME,
@ASSESSEENAME2,
@ASSESSEECAREOFNAME,
@ASSESSEEMAILINGADDRESS,
@ASSESSMENTRECORDINGDATE,
@DOCUMENTTYPE,
@ASSESSMENTSALEPRICE,
@ASSESSMENTSALEPRICECODE,
@LEGALLOTNUMBER,
@LEGALBLOCK,
@LEGALUNIT,
@LEGALCITY,
@LEGALSUBDIVISION,
@LANDUSECODE,
@PARKINGNUMBEROFCARS,
@BUILDINGCLASS,
@BUYER2,
@BUYERVESTING,
@BUYERCAREOFNAME,
@SELLER2,
@PROPUSECODE,
@CONCURRENTLOANAMOUNT,
@CONCURRENTLOANTYPE,
@CONCURRENTTYPEFINANCING,
@CONCURRENTDUEDATE,
@CONCURRENTLENDERNAME,
@DEEDTITLECOMPANY,
@DEEDLEGALLOTCODE,
@DEEDLEGALLOTNUMBER,
@DEEDLEGALBLOCK,
@DEEDLEGALUNIT,
@DEEDLEGALCITY,
@DEEDLEGALSUBDIVISION,
@DEEDLEGALBRIEFDESCRIPTION,
@DEEDRECORDINGDATE,
@MORTRECORDINGDATE,
@BORROWERS2,
@VESTINGCODE,
@BORROWERMAILINGADDRESS,
@ORIGINALCONTRACTDATE,
@MORT2_RECORDINGDATE,
@MORT2_BORROWERS,
@MORT2_BORROWERS2,
@MORT2_VESTINGCODE,
@MORT2_BORROWERMAILINGADDRESS,
@MORT2_ORIGINALCONTRACTDATE,
@MORT2_LOANAMOUNT,
@MORT2_LOANTYPE,
@MORT2_TYPEOFMORTGAGE,
@MORT2_DUEDATE,
@MORT2_LENDER,
@SUMMARYSALESVALUE,
@SUMMARYSALESRECORDINGDATE,
@PROPERTYVALUATION,
@CONFIRMED,
@CONFIRMEDBYAPPUSERID,
@DATECONFIRMED,
@REJECTED,
@REJECTEDBYAPPUSERID,
@DATEREJECTED,
1
);
exec dbo.USP_WEALTHPOINT_UPDATEWEALTHSUMMARY_REALESTATE @WEALTHID, @CHANGEAGENTID;
exec dbo.USP_WEALTHCAPACITY_UPDATE @WEALTHID, @CHANGEAGENTID;
return 0;
end;