USP_DATAFORMTEMPLATE_VIEW_WPREALESTATE2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@CNOTES	nvarchar(1024)	INOUT
@CDATE	datetime	INOUT
@CVALUE	money	INOUT
@DEEDTYPE	nvarchar(100)	INOUT
@DOCUMENTNUMBER	nvarchar(200)	INOUT
@SALEPRICE	money	INOUT
@RECORDEDDATE	nvarchar(200)	INOUT
@SALEDATE	datetime	INOUT
@BUYERMAILINGADDRESS	nvarchar(200)	INOUT
@SELLERMAILINGADDRESS	nvarchar(200)	INOUT
@SELLER	nvarchar(300)	INOUT
@BUYER	nvarchar(300)	INOUT
@LEGALDESCRIPTION	nvarchar(2000)	INOUT
@PROPERTYUSE	nvarchar(100)	INOUT
@LOTSIZE	nvarchar(50)	INOUT
@ROOF	nvarchar(30)	INOUT
@FOUNDATION	nvarchar(30)	INOUT
@EXTERIORWALLS	nvarchar(30)	INOUT
@BASEMENT	nvarchar(30)	INOUT
@CONSTRUCTION	nvarchar(30)	INOUT
@HEATING	nvarchar(30)	INOUT
@AIRCONDITIONING	nvarchar(30)	INOUT
@STYLE	nvarchar(30)	INOUT
@ELEVATOR	nvarchar(5)	INOUT
@NOOFBUILDINGS	nvarchar(5)	INOUT
@BUILDINGAREA	nvarchar(10)	INOUT
@GARAGETYPE	nvarchar(30)	INOUT
@FIREPLACE	nvarchar(5)	INOUT
@TOTALROOMS	nvarchar(5)	INOUT
@PARTIALBATHS	nvarchar(5)	INOUT
@BATHS	nvarchar(5)	INOUT
@BEDROOMS	nvarchar(5)	INOUT
@UNITS	nvarchar(10)	INOUT
@STORIES	nvarchar(50)	INOUT
@POOLSPA	nvarchar(30)	INOUT
@YEARBUILT	UDT_YEAR	INOUT
@OWNER	nvarchar(300)	INOUT
@BB_COUNTY	nvarchar(255)	INOUT
@MAILINGADDRESS	nvarchar(200)	INOUT
@TITLECOMPANY	nvarchar(50)	INOUT
@TERM	nvarchar(20)	INOUT
@LOANAMOUNT	money	INOUT
@TYPEOFMORTGAGE	nvarchar(100)	INOUT
@LENDER	nvarchar(100)	INOUT
@LENDERTYPE	nvarchar(50)	INOUT
@LOANTYPE	nvarchar(50)	INOUT
@DUEDATE	datetime	INOUT
@ASSESSORSPARCELNUMBER	nvarchar(100)	INOUT
@LANDUSE	nvarchar(100)	INOUT
@TAXRATECODE	nvarchar(50)	INOUT
@MARKETIMPROVEMENTVALUE	money	INOUT
@TOTALMARKETVALUE	money	INOUT
@MARKETLANDVALUE	money	INOUT
@MARKETVALUEYEAR	UDT_YEAR	INOUT
@ASSESSEDMULTIPLIER	nvarchar(5)	INOUT
@ASSESSMENTYEAR	UDT_YEAR	INOUT
@ASSESSEDIMPROVEMENTVALUE	money	INOUT
@ASSESSEDTOTALVALUE	money	INOUT
@ASSESSEDLANDVALUE	money	INOUT
@PROPADDRESS	nvarchar(150)	INOUT
@PROPCITY	nvarchar(50)	INOUT
@PROPSTATE	nvarchar(100)	INOUT
@PROPZIP	nvarchar(10)	INOUT
@BB_VALUE	money	INOUT
@PROPERTYRECORDFOR	nvarchar(50)	INOUT
@PROPERTYTRANSFERRECORDFOR	nvarchar(50)	INOUT
@BORROWERS	nvarchar(200)	INOUT
@MORTGAGERECORDFOR	nvarchar(50)	INOUT
@VALUE	money	INOUT
@TAPECUTDATE	UDT_FUZZYDATE	INOUT
@OWNERCAREOFNAME	nvarchar(40)	INOUT
@ASSESSEENAME	nvarchar(80)	INOUT
@ASSESSEENAME2	nvarchar(60)	INOUT
@ASSESSEECAREOFNAME	nvarchar(60)	INOUT
@ASSESSEEMAILINGADDRESS	nvarchar(200)	INOUT
@ASSESSMENTRECORDINGDATE	datetime	INOUT
@DOCUMENTTYPE	nvarchar(25)	INOUT
@ASSESSMENTSALEPRICE	money	INOUT
@ASSESSMENTSALEPRICECODE	nvarchar(130)	INOUT
@LEGALLOTNUMBER	nvarchar(7)	INOUT
@LEGALBLOCK	nvarchar(7)	INOUT
@LEGALUNIT	nvarchar(6)	INOUT
@LEGALCITY	nvarchar(30)	INOUT
@LEGALSUBDIVISION	nvarchar(40)	INOUT
@LANDUSECODE	nvarchar(4)	INOUT
@PARKINGNUMBEROFCARS	nvarchar(5)	INOUT
@BUILDINGCLASS	nvarchar(250)	INOUT
@BUYER2	nvarchar(300)	INOUT
@BUYERVESTING	nvarchar(50)	INOUT
@BUYERCAREOFNAME	nvarchar(40)	INOUT
@SELLER2	nvarchar(300)	INOUT
@PROPUSECODE	nvarchar(45)	INOUT
@CONCURRENTLOANAMOUNT	money	INOUT
@CONCURRENTLOANTYPE	nvarchar(35)	INOUT
@CONCURRENTTYPEFINANCING	nvarchar(30)	INOUT
@CONCURRENTDUEDATE	datetime	INOUT
@CONCURRENTLENDERNAME	nvarchar(40)	INOUT
@DEEDTITLECOMPANY	nvarchar(28)	INOUT
@DEEDLEGALLOTCODE	nvarchar(2)	INOUT
@DEEDLEGALLOTNUMBER	nvarchar(10)	INOUT
@DEEDLEGALBLOCK	nvarchar(7)	INOUT
@DEEDLEGALUNIT	nvarchar(6)	INOUT
@DEEDLEGALCITY	nvarchar(30)	INOUT
@DEEDLEGALSUBDIVISION	nvarchar(50)	INOUT
@DEEDLEGALBRIEFDESCRIPTION	nvarchar(100)	INOUT
@DEEDRECORDINGDATE	datetime	INOUT
@MORTRECORDINGDATE	datetime	INOUT
@BORROWERS2	nvarchar(200)	INOUT
@VESTINGCODE	nvarchar(50)	INOUT
@BORROWERMAILINGADDRESS	nvarchar(200)	INOUT
@ORIGINALCONTRACTDATE	datetime	INOUT
@MORT2_RECORDINGDATE	datetime	INOUT
@MORT2_BORROWERS	nvarchar(200)	INOUT
@MORT2_BORROWERS2	nvarchar(200)	INOUT
@MORT2_VESTINGCODE	nvarchar(50)	INOUT
@MORT2_BORROWERMAILINGADDRESS	nvarchar(200)	INOUT
@MORT2_ORIGINALCONTRACTDATE	datetime	INOUT
@MORT2_LOANAMOUNT	money	INOUT
@MORT2_LOANTYPE	nvarchar(50)	INOUT
@MORT2_TYPEOFMORTGAGE	nvarchar(100)	INOUT
@MORT2_DUEDATE	datetime	INOUT
@MORT2_LENDER	nvarchar(100)	INOUT
@ESTIMATEDVALUE	money	INOUT
@ESTIMATEDVALUEDATE	datetime	INOUT
@CONFIDENCESCORE	int	INOUT
@CONFIDENCESCOREDATE	datetime	INOUT
@SUMMARYASSESSEDTOTALVALUE	money	INOUT
@SUMMARYASSESSMENTYEAR	UDT_YEAR	INOUT
@SUMMARYTOTALMARKETVALUE	money	INOUT
@SUMMARYMARKETVALUEYEAR	UDT_YEAR	INOUT
@SUMMARYSALESVALUE	money	INOUT
@SUMMARYSALESRECORDINGDATE	datetime	INOUT
@SUMMARYLOANAMOUNT	money	INOUT
@SUMMARYMORTRECORDINGDATE	datetime	INOUT
@SUMMARYMORT2_LOANAMOUNT	money	INOUT
@SUMMARYMORT2_RECORDINGDATE	datetime	INOUT
@PROPERTYVALUATION	money	INOUT
@SOURCE	nvarchar(100)	INOUT
@HASCONFIDENCESCORE	bit	INOUT
@MATCHCODE	nvarchar(100)	INOUT

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_WPREALESTATE2 (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @CNOTES nvarchar(1024) = null output,
                    @CDATE datetime = null output,
                    @CVALUE money = null output,
                    @DEEDTYPE nvarchar(100) = null output,
                    @DOCUMENTNUMBER nvarchar(200) = null output,
                    @SALEPRICE money = null output,
                    @RECORDEDDATE nvarchar(200) = null output,
                    @SALEDATE datetime = null output,
                    @BUYERMAILINGADDRESS nvarchar(200) = null output,
                    @SELLERMAILINGADDRESS nvarchar(200) = null output,
                    @SELLER nvarchar(300) = null output,
                    @BUYER nvarchar(300) = null output,
                    @LEGALDESCRIPTION nvarchar(2000) = null output,
                    @PROPERTYUSE nvarchar(100) = null output,
                    @LOTSIZE nvarchar(50) = null output,
                    @ROOF nvarchar(30) = null output,
                    @FOUNDATION nvarchar(30) = null output,
                    @EXTERIORWALLS nvarchar(30) = null output,
                    @BASEMENT nvarchar(30) = null output,
                    @CONSTRUCTION nvarchar(30) = null output,
                    @HEATING nvarchar(30) = null output,
                    @AIRCONDITIONING nvarchar(30) = null output,
                    @STYLE nvarchar(30) = null output,
                    @ELEVATOR nvarchar(5) = null output,
                    @NOOFBUILDINGS nvarchar(5) = null output,
                    @BUILDINGAREA nvarchar(10) = null output,
                    @GARAGETYPE nvarchar(30) = null output,
                    @FIREPLACE nvarchar(5) = null output,
                    @TOTALROOMS nvarchar(5) = null output,
                    @PARTIALBATHS nvarchar(5) = null output,
                    @BATHS nvarchar(5) = null output,
                    @BEDROOMS nvarchar(5) = null output,
                    @UNITS nvarchar(10) = null output,
                    @STORIES nvarchar(50) = null output,
                    @POOLSPA nvarchar(30) = null output,
                    @YEARBUILT dbo.UDT_YEAR = null output,
                    @OWNER nvarchar(300) = null output,
                    @BB_COUNTY nvarchar(255) = null output,
                    @MAILINGADDRESS nvarchar(200) = null output,
                    @TITLECOMPANY nvarchar(50) = null output,
                    @TERM nvarchar(20) = null output,
                    @LOANAMOUNT money = null output,
                    @TYPEOFMORTGAGE nvarchar(100) = null output,
                    @LENDER nvarchar(100) = null output,
                    @LENDERTYPE nvarchar(50) = null output,
                    @LOANTYPE nvarchar(50) = null output,
                    @DUEDATE datetime = null output,
                    @ASSESSORSPARCELNUMBER nvarchar(100) = null output,
                    @LANDUSE nvarchar(100) = null output,
                    @TAXRATECODE nvarchar(50) = null output,
                    @MARKETIMPROVEMENTVALUE money = null output,
                    @TOTALMARKETVALUE money = null output,
                    @MARKETLANDVALUE money = null output,
                    @MARKETVALUEYEAR dbo.UDT_YEAR = null output,
                    @ASSESSEDMULTIPLIER nvarchar(5) = null output,
                    @ASSESSMENTYEAR dbo.UDT_YEAR = null output,
                    @ASSESSEDIMPROVEMENTVALUE money = null output,
                    @ASSESSEDTOTALVALUE money = null output,
                    @ASSESSEDLANDVALUE money = null output,
                    @PROPADDRESS nvarchar(150) = null output,
                    @PROPCITY nvarchar(50) = null output,
                    @PROPSTATE nvarchar(100) = null output,
                    @PROPZIP nvarchar(10) = null output,
                    @BB_VALUE money = null output,
                    @PROPERTYRECORDFOR nvarchar(50) = null output,
                    @PROPERTYTRANSFERRECORDFOR nvarchar(50) = null output,
                    @BORROWERS nvarchar(200) = null output,
                    @MORTGAGERECORDFOR nvarchar(50) = null output,
                    @VALUE money = null output,
                    @TAPECUTDATE dbo.UDT_FUZZYDATE = null output,
                    @OWNERCAREOFNAME nvarchar(40) = null output,
                    @ASSESSEENAME nvarchar(80) = null output,
                    @ASSESSEENAME2 nvarchar(60) = null output,
                    @ASSESSEECAREOFNAME nvarchar(60) = null output,
                    @ASSESSEEMAILINGADDRESS nvarchar(200) = null output,
                    @ASSESSMENTRECORDINGDATE datetime = null output,
                    @DOCUMENTTYPE nvarchar(25) = null output,
                    @ASSESSMENTSALEPRICE money = null output,
                    @ASSESSMENTSALEPRICECODE nvarchar(130) = null output,
                    @LEGALLOTNUMBER nvarchar(7) = null output,
                    @LEGALBLOCK nvarchar(7) = null output,
                    @LEGALUNIT nvarchar(6) = null output,
                    @LEGALCITY nvarchar(30) = null output,
                    @LEGALSUBDIVISION nvarchar(40) = null output,
                    @LANDUSECODE nvarchar(4) = null  output,
                    @PARKINGNUMBEROFCARS nvarchar(5) = null output,
                    @BUILDINGCLASS nvarchar(250) = null output,
                    @BUYER2 nvarchar(300) = null output,
                    @BUYERVESTING nvarchar(50) = null output,
                    @BUYERCAREOFNAME nvarchar(40) = null output,
                    @SELLER2 nvarchar(300) = null output,
                    @PROPUSECODE nvarchar(45) = null output,
                    @CONCURRENTLOANAMOUNT money = null output,
                    @CONCURRENTLOANTYPE nvarchar(35) = null output,
                    @CONCURRENTTYPEFINANCING nvarchar(30) = null output,
                    @CONCURRENTDUEDATE datetime = null output,
                    @CONCURRENTLENDERNAME nvarchar(40) = null output,
                    @DEEDTITLECOMPANY nvarchar(28) = null output,
                    @DEEDLEGALLOTCODE nvarchar(2) = null output,
                    @DEEDLEGALLOTNUMBER nvarchar(10) = null output,
                    @DEEDLEGALBLOCK nvarchar(7) = null output,
                    @DEEDLEGALUNIT nvarchar(6) = null output,
                    @DEEDLEGALCITY nvarchar(30) = null output,
                    @DEEDLEGALSUBDIVISION nvarchar(50) = null output,
                    @DEEDLEGALBRIEFDESCRIPTION nvarchar(100) = null output,
                    @DEEDRECORDINGDATE datetime = null output,
                    @MORTRECORDINGDATE datetime = null output,
                    @BORROWERS2 nvarchar(200) = null output,
                    @VESTINGCODE nvarchar(50) = null output,
                    @BORROWERMAILINGADDRESS nvarchar(200) = null output,
                    @ORIGINALCONTRACTDATE datetime = null output,
                    @MORT2_RECORDINGDATE datetime = null output,
                    @MORT2_BORROWERS nvarchar(200) = null output,
                    @MORT2_BORROWERS2 nvarchar(200) = null output,
                    @MORT2_VESTINGCODE nvarchar(50) = null output,
                    @MORT2_BORROWERMAILINGADDRESS nvarchar(200) = null output,
                    @MORT2_ORIGINALCONTRACTDATE datetime = null output,
                    @MORT2_LOANAMOUNT money = null output,
                    @MORT2_LOANTYPE nvarchar(50) = null output,
                    @MORT2_TYPEOFMORTGAGE nvarchar(100) = null output,
                    @MORT2_DUEDATE datetime = null output,
                    @MORT2_LENDER nvarchar(100) = null output,
                    @ESTIMATEDVALUE money = null output,
                    @ESTIMATEDVALUEDATE datetime = null output,
                    @CONFIDENCESCORE int = null output,
                    @CONFIDENCESCOREDATE datetime = null output,
                    @SUMMARYASSESSEDTOTALVALUE money = null output,
                    @SUMMARYASSESSMENTYEAR dbo.UDT_YEAR = null output,
                    @SUMMARYTOTALMARKETVALUE money = null output,
                    @SUMMARYMARKETVALUEYEAR dbo.UDT_YEAR = null output,
                    @SUMMARYSALESVALUE money = null output,
                    @SUMMARYSALESRECORDINGDATE datetime = null output,
                    @SUMMARYLOANAMOUNT money = null output,
                    @SUMMARYMORTRECORDINGDATE datetime = null output,
                    @SUMMARYMORT2_LOANAMOUNT money = null output,
                    @SUMMARYMORT2_RECORDINGDATE datetime = null output,
                    @PROPERTYVALUATION money = null output,
                    @SOURCE nvarchar(100) = null output,
                    @HASCONFIDENCESCORE bit = null output,
                    @MATCHCODE nvarchar(100) = null output
                ) as begin

                    set nocount on;

                    set @DATALOADED = 0;

                    select 
                        @DATALOADED = 1,
                        @CDATE = CDATE,
                        @CVALUE = CVALUE,
                        @CNOTES = CNOTES,
                        @DEEDTYPE = DEEDTYPE,
                        @DOCUMENTNUMBER = DOCUMENTNUMBER,
                        @SALEPRICE = SALEPRICE,
                        @RECORDEDDATE = RECORDEDDATE,
                        @SALEDATE = SALEDATE,
                        @BUYERMAILINGADDRESS = BUYERMAILINGADDRESS,
                        @SELLERMAILINGADDRESS = SELLERMAILINGADDRESS,
                        @SELLER = SELLER,
                        @BUYER = BUYER,
                        @LEGALDESCRIPTION = LEGALDESCRIPTION,
                        @PROPERTYUSE = PROPERTYUSE,
                        @LOTSIZE = LOTSIZE,
                        @ROOF = ROOF,
                        @FOUNDATION = FOUNDATION,
                        @EXTERIORWALLS = EXTERIORWALLS,
                        @BASEMENT = BASEMENT,
                        @CONSTRUCTION = CONSTRUCTION,
                        @HEATING = HEATING,
                        @AIRCONDITIONING = AIRCONDITIONING,
                        @STYLE = STYLE,
                        @ELEVATOR = ELEVATOR,
                        @NOOFBUILDINGS = NOOFBUILDINGS,
                        @BUILDINGAREA = BUILDINGAREA,
                        @GARAGETYPE = GARAGETYPE,
                        @FIREPLACE = FIREPLACE,
                        @TOTALROOMS = TOTALROOMS,
                        @PARTIALBATHS = PARTIALBATHS,
                        @BATHS = BATHS,
                        @BEDROOMS = BEDROOMS,
                        @UNITS = UNITS,
                        @STORIES = STORIES,
                        @POOLSPA = POOLSPA,
                        @YEARBUILT = YEARBUILT,
                        @OWNER = OWNER,
                        @BB_COUNTY = BB_COUNTY,
                        @MAILINGADDRESS = MAILINGADDRESS,
                        @TITLECOMPANY = TITLECOMPANY,
                        @TERM = TERM,
                        @LOANAMOUNT = LOANAMOUNT,
                        @TYPEOFMORTGAGE = TYPEOFMORTGAGE,
                        @LENDER = LENDER,
                        @LENDERTYPE = LENDERTYPE,
                        @LOANTYPE = LOANTYPE,
                        @DUEDATE = DUEDATE,
                        @ASSESSORSPARCELNUMBER = ASSESSORSPARCELNUMBER,
                        @LANDUSE = LANDUSE,
                        @TAXRATECODE = TAXRATECODE,
                        @MARKETIMPROVEMENTVALUE = MARKETIMPROVEMENTVALUE,
                        @TOTALMARKETVALUE = TOTALMARKETVALUE,
                        @MARKETLANDVALUE = MARKETLANDVALUE,
                        @MARKETVALUEYEAR = MARKETVALUEYEAR,
                        @ASSESSEDMULTIPLIER = ASSESSEDMULTIPLIER,
                        @ASSESSMENTYEAR = ASSESSMENTYEAR,
                        @ASSESSEDIMPROVEMENTVALUE = ASSESSEDIMPROVEMENTVALUE,
                        @ASSESSEDTOTALVALUE = ASSESSEDTOTALVALUE,
                        @ASSESSEDLANDVALUE = ASSESSEDLANDVALUE,
                        @PROPADDRESS = PROPADDRESS,
                        @PROPCITY = PROPCITY,
                        @PROPSTATE = PROPSTATE,
                        @PROPZIP = PROPZIP,
                        @BB_VALUE = BB_VALUE,
                        @PROPERTYRECORDFOR = PROPERTYRECORDFOR,
                        @PROPERTYTRANSFERRECORDFOR = PROPERTYTRANSFERRECORDFOR,
                        @BORROWERS = BORROWERS,
                        @MORTGAGERECORDFOR = MORTGAGERECORDFOR,
                        @VALUE = VALUE,
                        @TAPECUTDATE = TAPECUTDATE,
                        @OWNERCAREOFNAME = OWNERCAREOFNAME,
                        @ASSESSEENAME = ASSESSEENAME,
                        @ASSESSEENAME2 = ASSESSEENAME2,
                        @ASSESSEECAREOFNAME = ASSESSEECAREOFNAME,
                        @ASSESSEEMAILINGADDRESS = ASSESSEEMAILINGADDRESS,
                        @ASSESSMENTRECORDINGDATE = ASSESSMENTRECORDINGDATE,
                        @DOCUMENTTYPE = DOCUMENTTYPE,
                        @ASSESSMENTSALEPRICE = ASSESSMENTSALEPRICE,
                        @ASSESSMENTSALEPRICECODE = ASSESSMENTSALEPRICECODE,
                        @LEGALLOTNUMBER = LEGALLOTNUMBER,
                        @LEGALBLOCK = LEGALBLOCK,
                        @LEGALUNIT = LEGALUNIT,
                        @LEGALCITY = LEGALCITY,
                        @LEGALSUBDIVISION = LEGALSUBDIVISION,
                        @LANDUSECODE = LANDUSECODE,
                        @PARKINGNUMBEROFCARS = PARKINGNUMBEROFCARS,
                        @BUILDINGCLASS = BUILDINGCLASS,
                        @BUYER2 = BUYER2,
                        @BUYERVESTING = BUYERVESTING,
                        @BUYERCAREOFNAME = BUYERCAREOFNAME,
                        @SELLER2 = SELLER2,
                        @PROPUSECODE = PROPUSECODE,
                        @CONCURRENTLOANAMOUNT = CONCURRENTLOANAMOUNT,
                        @CONCURRENTLOANTYPE = CONCURRENTLOANTYPE,
                        @CONCURRENTTYPEFINANCING = CONCURRENTTYPEFINANCING,
                        @CONCURRENTDUEDATE = CONCURRENTDUEDATE,
                        @CONCURRENTLENDERNAME = CONCURRENTLENDERNAME,
                        @DEEDTITLECOMPANY = DEEDTITLECOMPANY,
                        @DEEDLEGALLOTCODE = DEEDLEGALLOTCODE,
                        @DEEDLEGALLOTNUMBER = DEEDLEGALLOTNUMBER,
                        @DEEDLEGALBLOCK = DEEDLEGALBLOCK,
                        @DEEDLEGALUNIT = DEEDLEGALUNIT,
                        @DEEDLEGALCITY = DEEDLEGALCITY,
                        @DEEDLEGALSUBDIVISION = DEEDLEGALSUBDIVISION,
                        @DEEDLEGALBRIEFDESCRIPTION = DEEDLEGALBRIEFDESCRIPTION,
                        @DEEDRECORDINGDATE = DEEDRECORDINGDATE,
                        @MORTRECORDINGDATE = MORTRECORDINGDATE,
                        @BORROWERS2 = BORROWERS2,
                        @VESTINGCODE = VESTINGCODE,
                        @BORROWERMAILINGADDRESS = BORROWERMAILINGADDRESS,
                        @ORIGINALCONTRACTDATE = ORIGINALCONTRACTDATE,
                        @MORT2_RECORDINGDATE = MORT2_RECORDINGDATE,
                        @MORT2_BORROWERS = MORT2_BORROWERS,
                        @MORT2_BORROWERS2 = MORT2_BORROWERS2,
                        @MORT2_VESTINGCODE = MORT2_VESTINGCODE,
                        @MORT2_BORROWERMAILINGADDRESS = MORT2_BORROWERMAILINGADDRESS,
                        @MORT2_ORIGINALCONTRACTDATE = MORT2_ORIGINALCONTRACTDATE,
                        @MORT2_LOANAMOUNT = MORT2_LOANAMOUNT,
                        @MORT2_LOANTYPE = MORT2_LOANTYPE,
                        @MORT2_TYPEOFMORTGAGE = MORT2_TYPEOFMORTGAGE,
                        @MORT2_DUEDATE = MORT2_DUEDATE,
                        @MORT2_LENDER = MORT2_LENDER,
                        @ESTIMATEDVALUE = ESTIMATEDVALUE,
                        @ESTIMATEDVALUEDATE = ESTIMATEDVALUEDATE,
                        @CONFIDENCESCORE = nullif(CONFIDENCESCORE, -1),
                        @HASCONFIDENCESCORE = case when CONFIDENCESCORE = -1 then 0 else 1 end,
                        @CONFIDENCESCOREDATE = CONFIDENCESCOREDATE,
                        @SUMMARYASSESSEDTOTALVALUE = ASSESSEDTOTALVALUE,
                        @SUMMARYASSESSMENTYEAR = ASSESSMENTYEAR,
                        @SUMMARYTOTALMARKETVALUE = TOTALMARKETVALUE,
                        @SUMMARYMARKETVALUEYEAR = MARKETVALUEYEAR,
                        @SUMMARYSALESVALUE = SUMMARYSALESVALUE,
                        @SUMMARYSALESRECORDINGDATE = SUMMARYSALESRECORDINGDATE,
                        @SUMMARYLOANAMOUNT = LOANAMOUNT,
                        @SUMMARYMORTRECORDINGDATE = MORTRECORDINGDATE,
                        @SUMMARYMORT2_LOANAMOUNT = MORT2_LOANAMOUNT,
                        @SUMMARYMORT2_RECORDINGDATE = MORT2_RECORDINGDATE,
                        @PROPERTYVALUATION = PROPERTYVALUATION,
                        @SOURCE = SOURCE,
                        @MATCHCODE = MC + ' - ' + dbo.UFN_WPMATCHCODE_DESCRIPTION(MC)
                    from
                        dbo.WPREALESTATE
                    where
                        ID=@ID

            update WPREALESTATE set HISTORICCODE = 0 where @ID = ID and HISTORICCODE = 2

                    return 0


                end