Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(60)   The unique name of this search list
 DESCRIPTION nvarchar(1000)   Default = '' Description of this search list
 IMPLEMENTATIONTYPE tinyint   Default = 0 0 - SP search list, 1 - CLR search list
 IMPLEMENTATIONTYPENAME varchar(3) (Computed)   Provides the translation for the IMPLEMENTATIONTYPE column
 PROCEDURENAME nvarchar(128)   Default = '' The name of the stored procedure used to return the search list results
 ASSEMBLYNAME nvarchar(128)   Default = '' The name of the CLR assembly used to return the search list results
 CLASSNAME nvarchar(128)   Default = '' The name of the class in the CLR assemby used to return the search list results
 FILTERFORMDEFINITION xml   Contains the filter form definition xml
 OUTPUTDEFINITION xml   Contains the output definition xml
 STATICPARAMETERDEFINITION xml Contains the static parameter definition xml
 SEARCHLISTSPEC xml   Contains the spec xml used to create this search list
 QUICKFINDFIELD nvarchar(128)   Default = '' The name of the search criteria field that will be used for quick finds
 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
 SECURITYUIFOLDER nvarchar(255)   Default = '' The folder path where the search list will be displayed in the security tree view.
 SPECUINAME nvarchar(60)   Default = '' Presentation name of the search list used to override the search list name for display in the application.
 UINAME nvarchar(60) (Computed)   case when len(SPECUINAME) = 0 then NAME else SPECUINAME end Name of the search list for display in the application.

Foreign Key Field Type Null Notes Description
 RECORDTYPEID uniqueidentifier   RECORDTYPE.ID FK to RECORDTYPE
 TRANSLATIONFUNCTIONCATALOGID uniqueidentifier   TRANSLATIONFUNCTIONCATALOG.ID FK to TRANSLATIONFUNCTIONCATALOG
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT

Index Name Field(s) Unique Primary Clustered
 IX_SEARCHLISTCATALOG_DATEADDED DATEADDED    
 PK_SEARCHLISTCATALOG ID  
 UC_SEARCHLISTCATALOG_NAME NAME    
 UIX_SEARCHLISTCATALOG_UINAME UINAME    

Trigger Name Description
 TR_SEARCHLISTCATALOG_AUDIT_UPDATE
 TR_SEARCHLISTCATALOG_AUDIT_DELETE

Referenced by Field
 ATTRIBUTECATEGORY CONSTITUENTSEARCHLISTCATALOGID
 MAPENTITYCATALOG SEARCHLISTID
 MKTAPPEALRECORDSOURCE SEARCHLISTCATALOGID
 RECORDTYPE DEFAULTSEARCHLISTID
 SEARCHLISTSETTINGS ID
 SEARCHLISTSETTINGS REPLACEMENTSEARCHLISTID
 SYSTEMROLEPERM_SEARCHLIST SEARCHLISTCATALOGID
 USERSETTINGSSEARCHLIST SEARCHLISTCATALOGID
 USERSETTINGSSEARCHLISTTASKHISTORY SEARCHLISTCATALOGID
 WEBDASHBOARDPAGE CONTEXTRECORDSEARCHLISTCATALOGID
 WEBDASHBOARDPAGECATALOG CONTEXTRECORDSEARCHLISTCATALOGID

Entity-Relationship diagram of this table