Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 JOBID nvarchar(50)   Default = '' The job ID returned for this result from the Prospect Quick Search service.
 FIPSCODE nvarchar(5)   Default = '' The FIPS code of the real estate result.
 ASSESSORSPARCELNUMBER nvarchar(100)   Default = '' The assessor's parcel number of the real estate result.
 CONFIDENCE tinyint   Default = 0 The confidence of the real estate result.
 OWNERNAME nvarchar(300)   Default = '' The owner name for the real estate result.
 PROPERTYADDRESSBLOCK nvarchar(150)   Default = '' The property address block for the real estate result.
 PROPERTYUNITNUMBER nvarchar(25)   Default = '' The property unit number for the real estate result.
 PROPERTYCITY nvarchar(50)   Default = '' The property city for the real estate result.
 PROPERTYSTATE nvarchar(100)   Default = '' The property state for the real estate result.
 PROPERTYPOSTCODE nvarchar(10)   Default = '' The property postcode for the real estate result.
 MAILINGADDRESSBLOCK nvarchar(150)   Default = '' The mailing address block for the real estate result.
 MAILINGUNITNUMBER nvarchar(25)   Default = '' The mailing unit number for the real estate result.
 MAILINGCITY nvarchar(50)   Default = '' The mailing city for the real estate result.
 MAILINGSTATE nvarchar(100)   Default = '' The mailing state for the real estate result.
 MAILINGPOSTCODE nvarchar(10)   Default = '' The mailing postcode for the real estate result.
 MATCHTYPE nvarchar(300)   Default = '' The match type for the real estate result.
 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.
 FIRSTNAME nvarchar(50)   Default = '' First name chosen by user.
 KEYNAME nvarchar(100)   Default = '' Keyname chosen by user.
 MIDDLENAME nvarchar(50)   Default = '' Middle name chosen by user.
 SPOUSE_FIRSTNAME nvarchar(50)   Default = '' Spouse first name chosen by user.
 SPOUSE_KEYNAME nvarchar(100)   Default = '' Spouse keyname chosen by user.
 SPOUSE_MIDDLENAME nvarchar(50)   Default = '' Spouse middle name chosen by user.

Foreign Key Field Type Null Notes Description
 PARTIALINFORMATIONSEARCHCRITERIAID uniqueidentifier   PARTIALINFORMATIONSEARCHCRITERIA.ID The ID of the Prospect Quick Search criteria that returned the real estate result.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 SPOUSE_RELATIONSHIPTYPECODEID uniqueidentifier RELATIONSHIPTYPECODE.ID Spouse relationship type for the relationship record.
 SPOUSE_RECIPROCALTYPECODEID uniqueidentifier RELATIONSHIPTYPECODE.ID Spouse relationship type for the reciprocal relationship record.

Index Name Field(s) Unique Primary Clustered
 IX_PARTIALINFORMATIONSEARCHRESULT_REALESTATE_DATEADDED DATEADDED    
 IX_PARTIALINFORMATIONSEARCHRESULT_REALESTATE_DATECHANGED DATECHANGED      
 IX_PARTIALINFORMATIONSEARCHRESULT_REALESTATE_FIPSCODE_ASSESSORSPARCELNUMBER FIPSCODE, ASSESSORSPARCELNUMBER      
 IX_PARTIALINFORMATIONSEARCHRESULT_REALESTATE_PARTIALINFORMATIONSEARCHCRITERIAID PARTIALINFORMATIONSEARCHCRITERIAID      
 PK_PARTIALINFORMATIONSEARCHRESULT_REALESTATE ID  

Trigger Name Description
 TR_PARTIALINFORMATIONSEARCHRESULT_REALESTATE_AUDIT_UPDATE
 TR_PARTIALINFORMATIONSEARCHRESULT_REALESTATE_AUDIT_DELETE

Referenced by Field
 PARTIALINFORMATIONSEARCHRESULT_REALESTATEDETAIL PARTIALINFORMATIONSEARCHRESULT_REALESTATEID

Entity-Relationship diagram of this table