Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 CONFIRMED bit   Default = 0
 DATECONFIRMED datetime
 REJECTED bit   Default = 0
 DATEREJECTED datetime
 SOURCE nvarchar(100)   Default = ''
 LXID int   Default = 0
 REVISION int   Default = 0
 ORIGINALID int   Default = 0
 NEWROW bit   Default = 0
 CDATE datetime
 CVALUE money   Default = 0
 CNOTES nvarchar(1024)   Default = ''
 FULLHASH nvarchar(32)   Default = ''
 PARTIALHASH nvarchar(32)   Default = ''
 MC nvarchar(3)   Default = ''
 DEEDTYPE nvarchar(100)   Default = ''
 DOCUMENTNUMBER nvarchar(200)   Default = ''
 SALEPRICE money   Default = 0
 RECORDEDDATE nvarchar(200)   Default = ''
 SALEDATE datetime
 BUYERMAILINGADDRESS nvarchar(200)   Default = ''
 SELLERMAILINGADDRESS nvarchar(200)   Default = ''
 SELLER nvarchar(300)   Default = ''
 BUYER nvarchar(300)   Default = ''
 LEGALDESCRIPTION nvarchar(2000)   Default = ''
 PROPERTYUSE nvarchar(100)   Default = ''
 LOTSIZE nvarchar(50)   Default = ''
 ROOF nvarchar(30)   Default = ''
 FOUNDATION nvarchar(30)   Default = ''
 EXTERIORWALLS nvarchar(30)   Default = ''
 BASEMENT nvarchar(30)   Default = ''
 CONSTRUCTION nvarchar(30)   Default = ''
 HEATING nvarchar(30)   Default = ''
 AIRCONDITIONING nvarchar(30)   Default = ''
 STYLE nvarchar(30)   Default = ''
 ELEVATOR nvarchar(5)   Default = ''
 NOOFBUILDINGS nvarchar(5)   Default = ''
 BUILDINGAREA nvarchar(10)   Default = ''
 GARAGETYPE nvarchar(30)   Default = ''
 FIREPLACE nvarchar(5)   Default = ''
 TOTALROOMS nvarchar(5)   Default = ''
 PARTIALBATHS nvarchar(5)   Default = ''
 BATHS nvarchar(5)   Default = ''
 BEDROOMS nvarchar(5)   Default = ''
 UNITS nvarchar(10)   Default = ''
 STORIES nvarchar(50)   Default = ''
 POOLSPA nvarchar(30)   Default = ''
 YEARBUILT UDT_YEAR   Default = ((0))
 OWNER nvarchar(300)   Default = ''
 BB_COUNTY nvarchar(255)   Default = ''
 MAILINGADDRESS nvarchar(200)   Default = ''
 TITLECOMPANY nvarchar(50)   Default = ''
 TERM nvarchar(20)   Default = ''
 LOANAMOUNT money   Default = 0
 TYPEOFMORTGAGE nvarchar(100)   Default = ''
 LENDER nvarchar(100)   Default = ''
 LENDERTYPE nvarchar(50)   Default = ''
 LOANTYPE nvarchar(50)   Default = ''
 DUEDATE datetime
 ASSESSORSPARCELNUMBER nvarchar(100)   Default = ''
 LANDUSE nvarchar(100)   Default = ''
 TAXRATECODE nvarchar(50)   Default = ''
 MARKETIMPROVEMENTVALUE money   Default = 0
 TOTALMARKETVALUE money   Default = 0
 MARKETLANDVALUE money   Default = 0
 MARKETVALUEYEAR UDT_YEAR   Default = ((0))
 ASSESSEDMULTIPLIER nvarchar(5)   Default = ''
 ASSESSMENTYEAR UDT_YEAR   Default = ((0))
 ASSESSEDIMPROVEMENTVALUE money   Default = 0
 ASSESSEDTOTALVALUE money   Default = 0
 ASSESSEDLANDVALUE money   Default = 0
 PROPADDRESS nvarchar(150)   Default = ''
 PROPCITY nvarchar(50)   Default = ''
 PROPSTATE nvarchar(100)   Default = ''
 PROPZIP nvarchar(10)   Default = ''
 BB_VALUE money   Default = 0
 INPUT_BBAID nvarchar(100)   Default = ''
 PROPERTYRECORDFOR nvarchar(50)   Default = ''
 PROPERTYTRANSFERRECORDFOR nvarchar(50)   Default = ''
 BORROWERS nvarchar(200)   Default = ''
 MORTGAGERECORDFOR nvarchar(50)   Default = ''
 VALUE money (Computed)   case when (case when SALEPRICE>LOANAMOUNT then SALEPRICE else LOANAMOUNT end)>(case when TOTALMARKETVALUE>ASSESSEDTOTALVALUE then TOTALMARKETVALUE else ASSESSEDTOTALVALUE end) then (case when SALEPRICE>LOANAMOUNT then SALEPRICE else LOANAMOUNT end) else (case when TOTALMARKETVALUE>ASSESSEDTOTALVALUE then TOTALMARKETVALUE else ASSESSEDTOTALVALUE end) end This is calculated to be the maximum of four other fields: SALEPRICE, LOANAMOUNT, TOTALMARKETVALUE, ASSESSEDTOTALVALUE.
 VIEWED bit   Default = 0
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 RECURSIVEMATCH bit   Default = 0
 REPORTTYPE nvarchar(20)   Default = ''
 TAPECUTDATE UDT_FUZZYDATE   Default = '00000000'
 OWNERCAREOFNAME nvarchar(40)   Default = ''
 ASSESSEENAME nvarchar(80)   Default = ''
 ASSESSEENAME2 nvarchar(60)   Default = ''
 ASSESSEECAREOFNAME nvarchar(60)   Default = ''
 ASSESSEEMAILINGADDRESS nvarchar(200)   Default = ''
 ASSESSMENTRECORDINGDATE datetime
 DOCUMENTTYPE nvarchar(25)   Default = ''
 ASSESSMENTSALEPRICE money   Default = 0
 ASSESSMENTSALEPRICECODE nvarchar(130)   Default = ''
 LEGALLOTNUMBER nvarchar(7)   Default = ''
 LEGALBLOCK nvarchar(7)   Default = ''
 LEGALUNIT nvarchar(6)   Default = ''
 LEGALCITY nvarchar(30)   Default = ''
 LEGALSUBDIVISION nvarchar(40)   Default = ''
 LANDUSECODE nvarchar(4)   Default = ''
 PARKINGNUMBEROFCARS nvarchar(4)   Default = ''
 BUILDINGCLASS nvarchar(250)   Default = ''
 BUYER2 nvarchar(300)   Default = ''
 BUYERVESTING nvarchar(50)   Default = ''
 BUYERCAREOFNAME nvarchar(40)   Default = ''
 SELLER2 nvarchar(300)   Default = ''
 PROPUSECODE nvarchar(45)   Default = ''
 CONCURRENTLOANAMOUNT money   Default = 0
 CONCURRENTLOANTYPE nvarchar(35)   Default = ''
 CONCURRENTTYPEFINANCING nvarchar(30)   Default = ''
 CONCURRENTDUEDATE datetime
 CONCURRENTLENDERNAME nvarchar(40)   Default = ''
 DEEDTITLECOMPANY nvarchar(28)   Default = ''
 DEEDLEGALLOTCODE nvarchar(2)   Default = ''
 DEEDLEGALLOTNUMBER nvarchar(10)   Default = ''
 DEEDLEGALBLOCK nvarchar(7)   Default = ''
 DEEDLEGALUNIT nvarchar(6)   Default = ''
 DEEDLEGALCITY nvarchar(30)   Default = ''
 DEEDLEGALSUBDIVISION nvarchar(50)   Default = ''
 DEEDLEGALBRIEFDESCRIPTION nvarchar(100)   Default = ''
 DEEDRECORDINGDATE datetime
 MORTRECORDINGDATE datetime
 BORROWERS2 nvarchar(200)   Default = ''
 VESTINGCODE nvarchar(50)   Default = ''
 BORROWERMAILINGADDRESS nvarchar(200)   Default = ''
 ORIGINALCONTRACTDATE datetime
 MORT2_RECORDINGDATE datetime
 MORT2_BORROWERS nvarchar(200)   Default = ''
 MORT2_BORROWERS2 nvarchar(200)   Default = ''
 MORT2_VESTINGCODE nvarchar(50)   Default = ''
 MORT2_BORROWERMAILINGADDRESS nvarchar(200)   Default = ''
 MORT2_ORIGINALCONTRACTDATE datetime
 MORT2_LOANAMOUNT money   Default = 0
 MORT2_LOANTYPE nvarchar(50)   Default = ''
 MORT2_TYPEOFMORTGAGE nvarchar(100)   Default = ''
 MORT2_DUEDATE datetime
 MORT2_LENDER nvarchar(100)   Default = ''
 ESTIMATEDVALUE money   Default = 0
 ESTIMATEDVALUEDATE datetime
 CONFIDENCESCORE int   Default = -1
 SUMMARYSALESVALUE money   Default = 0
 SUMMARYSALESRECORDINGDATE datetime
 CONFIDENCESCOREDATE datetime
 PROPERTYVALUATION money   Default = 0
 FIPSCODE nvarchar(5)   Default = ''

Foreign Key Field Type Null Notes Description
 WEALTHID uniqueidentifier   WEALTH.ID FK to WEALTH
 CONFIRMEDBYAPPUSERID uniqueidentifier APPUSER.ID FK to APPUSER
 REJECTEDBYAPPUSERID uniqueidentifier APPUSER.ID FK to APPUSER
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_WPREALESTATE_DATEADDED DATEADDED    
 IX_WPREALESTATE_DATECHANGED DATECHANGED      
 IX_WPREALESTATE_WEALTHID WEALTHID      
 PK_WPREALESTATE ID  

Trigger Name Description
 TR_WPREALESTATE_AUDIT_UPDATE
 TR_WPREALESTATE_AUDIT_DELETE

Referenced by Field
 WPREALESTATEHISTORY WPREALESTATEID

Entity-Relationship diagram of this table