Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = ''
 SOURCECODE tinyint   Default = 1
 SOURCE nvarchar(21) (Computed) CASE [SOURCECODE] WHEN 1 THEN N'Search in RE & RP' WHEN 2 THEN N'Search in RE only' WHEN 3 THEN N'Search in RP only' WHEN 4 THEN N'Search in TA Database' END
 SORTBYCODE tinyint   Default = 1
 NAMEORID nvarchar(500)   Default = ''
 LOCATION nvarchar(500)   Default = ''
 LASTNAME nvarchar(50)   Default = ''
 FIRSTNAME nvarchar(50)   Default = ''
 MIDDLENAME nvarchar(50)   Default = ''
 NICKNAME nvarchar(50)   Default = ''
 ADDRESSBLOCK nvarchar(100)   Default = ''
 CITY nvarchar(100)   Default = ''
 STATE nvarchar(3)   Default = ''
 POSTCODE nvarchar(12)   Default = ''
 INCLUDEDECEASED bit   Default = 0
 INCLUDEINACTIVE bit   Default = 0
 SPOUSELASTNAME nvarchar(50)   Default = ''
 SPOUSEFIRSTNAME nvarchar(50)   Default = ''
 AGEMIN int   Default = 0
 AGEMAX int   Default = 0
 BUSINESS nvarchar(50)   Default = ''
 CLASSYEAR UDT_YEAR   Default = ((0))
 DATEADDED datetime   Default = getdate()
 DATECHANGED datetime   Default = getdate()
 TS timestamp  
 TSLONG bigint (Computed) CONVERT(bigint, TS)
 RECORDTYPECODE tinyint   Default = 1
 RECORDTYPE nvarchar(13) (Computed) CASE [RECORDTYPECODE] WHEN 1 THEN N'All records' WHEN 2 THEN N'Individuals' WHEN 3 THEN N'Organizations' END
 EXACTMATCHONLY bit   Default = 0
 ISEXPORT bit   Default = 0
 RESEARCHRESULTS xml
 MAXROWS int   Default = 100
 SORTBY nvarchar(21) (Computed) CASE [SORTBYCODE] WHEN 1 THEN N'Full name' WHEN 2 THEN N'Last name, First name' WHEN 3 THEN N'Wealth ascending' WHEN 4 THEN N'Wealth descending' WHEN 5 THEN N'City, State' END
 EXPORTCACHEID nvarchar(100)   Default = ''

Foreign Key Field Type Null Notes Description
 OWNERID uniqueidentifier   APPUSER.ID
 STATEID uniqueidentifier STATE.LOCALID
 ESTIMATEDWEALTHMINID uniqueidentifier ESTIMATEDWEALTH.ID
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID
 OVERALLRATINGCODEID uniqueidentifier OVERALLRATINGCODE.ID

Index Name Field(s) Unique Primary Clustered
 IX_PROSPECTSEARCH_DATEADDED DATEADDED    
 IX_PROSPECTSEARCH_DATECHANGED DATECHANGED      
 PK_PROSPECTSEARCH ID  
 UIX_PROSPECTSEARCH_OWNERID_NAME OWNERID, NAME    

Trigger Name Description
 TR_PROSPECTSEARCH_AUDIT_UPDATE
 TR_PROSPECTSEARCH_AUDIT_DELETE

Entity-Relationship diagram of this table