USP_DATAFORMTEMPLATE_EDITLOAD_WPREALESTATE_3

The load procedure used by the edit dataform template "WealthPoint Real Estate Edit Form 3"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@SOURCE	nvarchar(100)	INOUT	Source
@CNOTES	nvarchar(1024)	INOUT	Notes
@DEEDTYPE	nvarchar(100)	INOUT	Document type
@SALEPRICE	money	INOUT	Sales price
@SALEDATE	datetime	INOUT	Date of contract
@BUYERMAILINGADDRESS	nvarchar(200)	INOUT	Buyer address
@SELLERMAILINGADDRESS	nvarchar(200)	INOUT	Seller address
@SELLER	nvarchar(300)	INOUT	Seller #1 name
@BUYER	nvarchar(300)	INOUT	Buyer #1 name
@LEGALDESCRIPTION	nvarchar(2000)	INOUT	Brief description
@PROPERTYUSE	nvarchar(100)	INOUT	County description
@LOTSIZE	nvarchar(50)	INOUT	Lot-size or area
@ROOF	nvarchar(30)	INOUT	Roof cover
@FOUNDATION	nvarchar(30)	INOUT	Foundation
@EXTERIORWALLS	nvarchar(30)	INOUT	Exterior walls
@BASEMENT	nvarchar(30)	INOUT	Basement
@CONSTRUCTION	nvarchar(30)	INOUT	Construction
@HEATING	nvarchar(30)	INOUT	Heating
@AIRCONDITIONING	nvarchar(30)	INOUT	Air conditioning
@STYLE	nvarchar(30)	INOUT	Style
@ELEVATOR	nvarchar(5)	INOUT	Elevator
@NOOFBUILDINGS	nvarchar(5)	INOUT	No. buildings
@BUILDINGAREA	nvarchar(10)	INOUT	Building area
@GARAGETYPE	nvarchar(30)	INOUT	Garage type
@FIREPLACE	nvarchar(5)	INOUT	Fireplace
@TOTALROOMS	nvarchar(5)	INOUT	Total # rooms
@PARTIALBATHS	nvarchar(5)	INOUT	Partial baths
@BATHS	nvarchar(5)	INOUT	No. baths
@BEDROOMS	nvarchar(5)	INOUT	No. of bedrooms
@UNITS	nvarchar(10)	INOUT	No. of units
@STORIES	nvarchar(50)	INOUT	No. of stories
@POOLSPA	nvarchar(30)	INOUT	Pool
@YEARBUILT	UDT_YEAR	INOUT	Year built
@OWNER	nvarchar(300)	INOUT	Owner
@BB_COUNTY	nvarchar(255)	INOUT	County
@MAILINGADDRESS	nvarchar(200)	INOUT	Mailing address
@LOANAMOUNT	money	INOUT	Loan amount
@TYPEOFMORTGAGE	nvarchar(100)	INOUT	Type of financing
@LENDER	nvarchar(100)	INOUT	Lender name
@LOANTYPE	nvarchar(50)	INOUT	Loan type
@DUEDATE	datetime	INOUT	Due date
@ASSESSORSPARCELNUMBER	nvarchar(100)	INOUT	APN
@LANDUSE	nvarchar(100)	INOUT	County code
@MARKETIMPROVEMENTVALUE	money	INOUT	Market improvement value
@TOTALMARKETVALUE	money	INOUT	Total market value
@MARKETLANDVALUE	money	INOUT	Market land value
@MARKETVALUEYEAR	UDT_YEAR	INOUT	Market value year
@ASSESSMENTYEAR	UDT_YEAR	INOUT	Assessed value year
@ASSESSEDIMPROVEMENTVALUE	money	INOUT	Assessed improvement value
@ASSESSEDTOTALVALUE	money	INOUT	Total assessed value
@ASSESSEDLANDVALUE	money	INOUT	Assessed land value
@PROPADDRESS	nvarchar(150)	INOUT	Address
@PROPCITY	nvarchar(50)	INOUT	City
@PROPSTATE	nvarchar(100)	INOUT	State
@PROPZIP	nvarchar(10)	INOUT	ZIP
@BORROWERS	nvarchar(200)	INOUT	Borrower #1 name
@TAPECUTDATE	UDT_FUZZYDATE	INOUT	Tape cut date
@OWNERCAREOFNAME	nvarchar(40)	INOUT	Care of name
@ASSESSEENAME	nvarchar(80)	INOUT	Assessee #1 name
@ASSESSEENAME2	nvarchar(60)	INOUT	Assessee #2 name
@ASSESSEECAREOFNAME	nvarchar(60)	INOUT	Care of name
@ASSESSEEMAILINGADDRESS	nvarchar(200)	INOUT	Assessee address
@ASSESSMENTRECORDINGDATE	datetime	INOUT	Recording date
@DOCUMENTTYPE	nvarchar(25)	INOUT	Document type
@ASSESSMENTSALEPRICE	money	INOUT	Sales price
@ASSESSMENTSALEPRICECODE	nvarchar(130)	INOUT	Sales price indicator
@LEGALLOTNUMBER	nvarchar(7)	INOUT	Lot number
@LEGALBLOCK	nvarchar(7)	INOUT	Block
@LEGALUNIT	nvarchar(6)	INOUT	Unit
@LEGALCITY	nvarchar(30)	INOUT	City/township
@LEGALSUBDIVISION	nvarchar(40)	INOUT	Subdivision name
@LANDUSECODE	nvarchar(4)	INOUT	Standardized code
@PARKINGNUMBEROFCARS	nvarchar(5)	INOUT	Parking # of cars
@BUILDINGCLASS	nvarchar(250)	INOUT	Building class
@BUYER2	nvarchar(300)	INOUT	Buyer #2 name
@BUYERVESTING	nvarchar(50)	INOUT	Buyer vesting
@BUYERCAREOFNAME	nvarchar(40)	INOUT	Care of name
@SELLER2	nvarchar(300)	INOUT	Seller #2 name
@PROPUSECODE	nvarchar(45)	INOUT	Property use
@CONCURRENTLOANAMOUNT	money	INOUT	Loan amount
@CONCURRENTLOANTYPE	nvarchar(35)	INOUT	Loan type
@CONCURRENTTYPEFINANCING	nvarchar(30)	INOUT	Type of financing
@CONCURRENTDUEDATE	datetime	INOUT	Due date
@CONCURRENTLENDERNAME	nvarchar(40)	INOUT	Lender name
@DEEDTITLECOMPANY	nvarchar(28)	INOUT	Title company
@DEEDLEGALLOTCODE	nvarchar(2)	INOUT	Lot code
@DEEDLEGALLOTNUMBER	nvarchar(10)	INOUT	Lot number
@DEEDLEGALBLOCK	nvarchar(7)	INOUT	Block
@DEEDLEGALUNIT	nvarchar(6)	INOUT	Unit
@DEEDLEGALCITY	nvarchar(30)	INOUT	City/township
@DEEDLEGALSUBDIVISION	nvarchar(50)	INOUT	Subdivision
@DEEDLEGALBRIEFDESCRIPTION	nvarchar(100)	INOUT	Brief description
@DEEDRECORDINGDATE	datetime	INOUT	Recording date
@MORTRECORDINGDATE	datetime	INOUT	Recording date
@BORROWERS2	nvarchar(200)	INOUT	Borrower #2 name
@VESTINGCODE	nvarchar(50)	INOUT	Borrower vesting
@BORROWERMAILINGADDRESS	nvarchar(200)	INOUT	Borrower address
@ORIGINALCONTRACTDATE	datetime	INOUT	Date of contract
@MORT2_RECORDINGDATE	datetime	INOUT	Recording date
@MORT2_BORROWERS	nvarchar(200)	INOUT	Borrower #1 name
@MORT2_BORROWERS2	nvarchar(200)	INOUT	Borrower #2 name
@MORT2_VESTINGCODE	nvarchar(50)	INOUT	Borrower vesting
@MORT2_BORROWERMAILINGADDRESS	nvarchar(200)	INOUT	Borrower address
@MORT2_ORIGINALCONTRACTDATE	datetime	INOUT	Date of contract
@MORT2_LOANAMOUNT	money	INOUT	Loan amount
@MORT2_LOANTYPE	nvarchar(50)	INOUT	Loan type
@MORT2_TYPEOFMORTGAGE	nvarchar(100)	INOUT	Type of financing
@MORT2_DUEDATE	datetime	INOUT	Due date
@MORT2_LENDER	nvarchar(100)	INOUT	Lender name
@SUMMARYSALESVALUE	money	INOUT	Sales amount
@SUMMARYSALESRECORDINGDATE	datetime	INOUT	Reported date
@PROPERTYVALUATION	money	INOUT	Property valuation
@ISBUILTIN	bit	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_WPREALESTATE_3 (
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,
                        @SOURCE nvarchar(100) = null output,
                        @CNOTES nvarchar(1024) = null output,
                        @DEEDTYPE nvarchar(100) = null output,
                        @SALEPRICE money = 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,
                        @LOANAMOUNT money = null output,
                        @TYPEOFMORTGAGE nvarchar(100) = null output,
                        @LENDER nvarchar(100) = null output,
                        @LOANTYPE nvarchar(50) = null output,
                        @DUEDATE datetime = null output,
                        @ASSESSORSPARCELNUMBER nvarchar(100) = null output,
                        @LANDUSE nvarchar(100) = null output,
                        @MARKETIMPROVEMENTVALUE money = null output,
                        @TOTALMARKETVALUE money = null output,
                        @MARKETLANDVALUE money = null output,
                        @MARKETVALUEYEAR dbo.UDT_YEAR = 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,
                        @BORROWERS nvarchar(200) = 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,
                        @SUMMARYSALESVALUE money = null output,
                        @SUMMARYSALESRECORDINGDATE datetime = null output,
                        @PROPERTYVALUATION money = null output,
                        @ISBUILTIN bit = null output

                    ) as begin

                        set nocount on;

                        set @DATALOADED = 0;
                        set @TSLONG = 0;

                        select 
                            @DATALOADED = 1,
                            @TSLONG = TSLONG,
                            @SOURCE = SOURCE,
                            @CNOTES = CNOTES,
                            @DEEDTYPE = DEEDTYPE,
                            @SALEPRICE = SALEPRICE,
                            @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,
                            @LOANAMOUNT = LOANAMOUNT,
                            @TYPEOFMORTGAGE = TYPEOFMORTGAGE,
                            @LENDER = LENDER,
                            @LOANTYPE = LOANTYPE,
                            @DUEDATE = DUEDATE,
                            @ASSESSORSPARCELNUMBER = ASSESSORSPARCELNUMBER,
                            @LANDUSE = LANDUSE,
                            @MARKETIMPROVEMENTVALUE = MARKETIMPROVEMENTVALUE,
                            @TOTALMARKETVALUE = TOTALMARKETVALUE,
                            @MARKETLANDVALUE = MARKETLANDVALUE,
                            @MARKETVALUEYEAR = MARKETVALUEYEAR,
                            @ASSESSMENTYEAR = ASSESSMENTYEAR,
                            @ASSESSEDIMPROVEMENTVALUE = ASSESSEDIMPROVEMENTVALUE,
                            @ASSESSEDTOTALVALUE = ASSESSEDTOTALVALUE,
                            @ASSESSEDLANDVALUE = ASSESSEDLANDVALUE,
                            @PROPADDRESS = PROPADDRESS,
                            @PROPCITY = PROPCITY,
                            @PROPSTATE = PROPSTATE,
                            @PROPZIP = PROPZIP,
                            @BORROWERS = BORROWERS,
                            @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,
                            @SUMMARYSALESVALUE = SUMMARYSALESVALUE,
                            @SUMMARYSALESRECORDINGDATE = SUMMARYSALESRECORDINGDATE,
                            @PROPERTYVALUATION = PROPERTYVALUATION
                        from
                            dbo.WPREALESTATE
                        where
                            ID=@ID

                        exec @ISBUILTIN = UFN_ISBUILTIN_WEALTHSOURCE @SOURCE;

                        return 0

                    end