Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 SEARCHDATE datetime The date of the most recent search by the application user with this criteria.
 KEYNAME nvarchar(100)   Default = '' The key name to include in the search criteria.
 FIRSTNAME nvarchar(100)   Default = '' The first name to include in the search criteria.
 NICKNAME nvarchar(100)   Default = '' The nickname to include in the search criteria.
 ADDRESSBLOCK nvarchar(150)   Default = '' The address block to include in the search criteria.
 UNITNUMBER nvarchar(25)   Default = '' The address unit number to include in the search criteria.
 CITY nvarchar(50)   Default = '' The address city to include in the search criteria.
 POSTCODE nvarchar(10)   Default = '' The address postcode to include in the search criteria.
 COMPANYNAME nvarchar(100)   Default = '' The name of the company to include in the search criteria.
 PHONENUMBER nvarchar(100)   Default = '' The phone number to use in the searh criteria.
 REALESTATESEARCH bit   Default = 1 Indicates whether real estate should be searched.
 REALESTATEADDRESSSEARCHTYPECODE tinyint   Default = 0 The type of real estate address search to perform.
 REALESTATEADDRESSSEARCHTYPE nvarchar(18) (Computed) CASE [REALESTATEADDRESSSEARCHTYPECODE] WHEN 0 THEN N'All addresses' WHEN 1 THEN N'Selected addresses' END Provides a translation for the 'REALESTATEADDRESSSEARCHTYPECODE' field.
 REALESTATESEARCHPROPERTYADDRESS bit   Default = 0 Indicates that the property address should be search, if REALESTATEADDRESSSEARCHTYPECODE is set to selected addresses.
 REALESTATESEARCHMAILINGADDRESS bit   Default = 0 Indicates that the property address should be search, if REALESTATEADDRESSSEARCHTYPECODE is set to selected addresses.
 REALESTATESEARCHBUYERADDRESS bit   Default = 0 Indicates that the property address should be search, if REALESTATEADDRESSSEARCHTYPECODE is set to selected addresses.
 REALESTATESEARCHASSESSEEADDRESS bit   Default = 0 Indicates that the property address should be search, if REALESTATEADDRESSSEARCHTYPECODE is set to selected addresses.
 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.
 BUSINESSOWNERSHIPSEARCH bit   Default = 1 Indicates whether business ownership should be searched.
 DATASOURCESEARCHTYPECODE tinyint   Default = 0 Which data sources to search.
 DATASOURCESEARCHTYPE nvarchar(21) (Computed) CASE [DATASOURCESEARCHTYPECODE] WHEN 0 THEN N'All data sources' WHEN 1 THEN N'Selected data sources' END Provides a translation for the 'DATASOURCESEARCHTYPECODE' field.

Foreign Key Field Type Null Notes Description
 APPUSERID uniqueidentifier   APPUSER.ID The ID of the Application User who is performing the search.
 STATEID uniqueidentifier STATE.LOCALID The ID of the address state to include in the search criteria.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_PARTIALINFORMATIONSEARCHCRITERIA_APPUSERID APPUSERID      
 IX_PARTIALINFORMATIONSEARCHCRITERIA_DATEADDED DATEADDED    
 IX_PARTIALINFORMATIONSEARCHCRITERIA_DATECHANGED DATECHANGED      
 IX_PARTIALINFORMATIONSEARCHCRITERIA_SEARCHDATE SEARCHDATE      
 PK_PARTIALINFORMATIONSEARCHCRITERIA ID  

Trigger Name Description
 TR_PARTIALINFORMATIONSEARCHCRITERIA_AUDIT_UPDATE
 TR_PARTIALINFORMATIONSEARCHCRITERIA_AUDIT_DELETE

Referenced by Field
 PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIP PARTIALINFORMATIONSEARCHCRITERIAID
 PARTIALINFORMATIONSEARCHRESULT_REALESTATE PARTIALINFORMATIONSEARCHCRITERIAID

Entity-Relationship diagram of this table