USP_DATAFORMTEMPLATE_EDITLOAD_WPREALESTATE_2

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

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	Deed type
@DOCUMENTNUMBER	nvarchar(200)	INOUT	Document number
@SALEPRICE	money	INOUT	Sale price
@RECORDEDDATE	nvarchar(200)	INOUT	Recorded date
@SALEDATE	datetime	INOUT	Sale date
@BUYERMAILINGADDRESS	nvarchar(200)	INOUT	Buyer mailing address
@SELLERMAILINGADDRESS	nvarchar(200)	INOUT	Seller mailing address
@SELLER	nvarchar(300)	INOUT	Seller
@BUYER	nvarchar(300)	INOUT	Buyer
@LEGALDESCRIPTION	nvarchar(2000)	INOUT	Legal description
@PROPERTYUSE	nvarchar(100)	INOUT	Property use
@LOTSIZE	nvarchar(50)	INOUT	Lot size
@ROOF	nvarchar(30)	INOUT	Roof
@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. of 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	Baths
@BEDROOMS	nvarchar(5)	INOUT	Bedrooms
@UNITS	nvarchar(10)	INOUT	Units
@STORIES	nvarchar(50)	INOUT	Stories
@POOLSPA	nvarchar(30)	INOUT	Pool/Spa
@YEARBUILT	UDT_YEAR	INOUT	Year built
@OWNER	nvarchar(300)	INOUT	Owner
@BB_COUNTY	nvarchar(255)	INOUT	County
@MAILINGADDRESS	nvarchar(200)	INOUT	Mailing address
@TITLECOMPANY	nvarchar(50)	INOUT	Title company
@TERM	nvarchar(20)	INOUT	Term
@LOANAMOUNT	money	INOUT	Loan amount
@TYPEOFMORTGAGE	nvarchar(100)	INOUT	Mortgage type
@LENDER	nvarchar(100)	INOUT	Lender
@LENDERTYPE	nvarchar(50)	INOUT	Lender type
@LOANTYPE	nvarchar(50)	INOUT	Loan type
@DUEDATE	datetime	INOUT	Due date
@ASSESSORSPARCELNUMBER	nvarchar(100)	INOUT	Assessor's parcel number
@LANDUSE	nvarchar(100)	INOUT	Land use
@TAXRATECODE	nvarchar(50)	INOUT	Tax rate 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
@ASSESSEDMULTIPLIER	nvarchar(5)	INOUT	Assessed multiplier
@ASSESSMENTYEAR	UDT_YEAR	INOUT	Assessed value year
@ASSESSEDIMPROVEMENTVALUE	money	INOUT	Assessed improvement value
@ASSESSEDTOTALVALUE	money	INOUT	Assessed total 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(s)
@ISBUILTIN	bit	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_WPREALESTATE_2 (
                        @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,
                        @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,
                        @BORROWERS nvarchar(200) = 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,
                            @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,
                            @BORROWERS = BORROWERS
                        from
                            dbo.WPREALESTATE
                        where
                            ID=@ID

                        exec @ISBUILTIN = UFN_ISBUILTIN_WEALTHSOURCE @SOURCE;

                        return 0

                    end