Contains Prospect Quick Search real estate results.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| 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) |
yes |
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 Keys
| 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 |
yes |
RELATIONSHIPTYPECODE.ID
|
Spouse relationship type for the relationship record. |
| SPOUSE_RECIPROCALTYPECODEID |
uniqueidentifier |
yes |
RELATIONSHIPTYPECODE.ID
|
Spouse relationship type for the reciprocal relationship record. |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_PARTIALINFORMATIONSEARCHRESULT_REALESTATE_DATEADDED |
DATEADDED |
|
|
yes |
| IX_PARTIALINFORMATIONSEARCHRESULT_REALESTATE_DATECHANGED |
DATECHANGED |
|
|
|
| IX_PARTIALINFORMATIONSEARCHRESULT_REALESTATE_FIPSCODE_ASSESSORSPARCELNUMBER |
FIPSCODE, ASSESSORSPARCELNUMBER |
|
|
|
| IX_PARTIALINFORMATIONSEARCHRESULT_REALESTATE_PARTIALINFORMATIONSEARCHCRITERIAID |
PARTIALINFORMATIONSEARCHCRITERIAID |
|
|
|
| PK_PARTIALINFORMATIONSEARCHRESULT_REALESTATE |
ID |
yes |
yes |
|
Triggers
Referenced by