Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 SOURCE nvarchar(100)   Default = ''
 FULLHASH nvarchar(32)   Default = ''
 PARTIALHASH nvarchar(32)   Default = ''
 DEEDTYPE nvarchar(100)   Default = ''
 DOCUMENTNUMBER nvarchar(200)   Default = ''
 SALEPRICE money   Default = 0
 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 = ''
 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 = ''
 MARKETIMPROVEMENTVALUE money   Default = 0
 TOTALMARKETVALUE money   Default = 0
 MARKETLANDVALUE money   Default = 0
 MARKETVALUEYEAR UDT_YEAR   Default = ((0))
 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 = ''
 BORROWERS nvarchar(200)   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 = ''
 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.

Foreign Key Field Type Null Notes Description
 WPREALESTATEID uniqueidentifier   WPREALESTATE.ID FK to WPREALESTATE
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_WPREALESTATEHISTORY_DATEADDED DATEADDED    
 IX_WPREALESTATEHISTORY_DATECHANGED DATECHANGED      
 PK_WPREALESTATEHISTORY ID  

Trigger Name Description
 TR_WPREALESTATEHISTORY_AUDIT_UPDATE
 TR_WPREALESTATEHISTORY_AUDIT_DELETE

Entity-Relationship diagram of this table