Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 REQUESTID int   Default = 0 Indicates the WealthPoint Search Request ID.
 DATESUBMITTED datetime Date request was submitted to WealthPoint.
 DATESTARTED datetime Date WealthPoint Search was started.
 DATEREADY datetime Date WealthPoint Search results were ready.
 DATERETRIEVED datetime Indicates the date when the results of the WealthPoint Search have been retrieved from WealthPoint
 STATUSCODE tinyint   Default = 0 Status of the WealthPoint Search request.
 STATUSDETAILS nvarchar(500)   Default = '' Details of the status of the WealthPoint search request.
 PARSING bit   Default = 0 Indicates that a WealthPoint search request is being parsed.
 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.
 JOBID nvarchar(50)   Default = '' Indicates the WealthPoint Search Job ID.
 SEARCHTYPECODE tinyint   Default = 0 Used to indicate the type of search.
 SEARCHTYPE nvarchar(14) (Computed) CASE [SEARCHTYPECODE] WHEN 0 THEN N'Constituent' WHEN 1 THEN N'Research Group' WHEN 2 THEN N'Rescreen' END Provides a translation for the 'SEARCHTYPECODE' field.
 RECORDCOUNT int   Default = 0 Number of records in search
 STATUS nvarchar(13) (Computed) CASE [STATUSCODE] WHEN 0 THEN N'Created' WHEN 1 THEN N'Pending' WHEN 2 THEN N'Results ready' WHEN 3 THEN N'Completed' WHEN 4 THEN N'Failed' WHEN 5 THEN N'Canceled' END Provides a translation for the 'STATUSCODE' field.
 SECURITIES_REFRESHDATE datetime
 NPA_REFRESHDATE datetime
 PF_REFRESHDATE datetime
 BO_REFRESHDATE datetime
 BIO_REFRESHDATE datetime

Foreign Key Field Type Null Notes Description
 APPUSERID uniqueidentifier   APPUSER.ID AppUser ID for the user who initiated the WealthPoint Search.
 CONSTITUENTID uniqueidentifier CONSTITUENT.LOCALID ID of the individual constituent being searched on.
 RESEARCHGROUPID uniqueidentifier RESEARCHGROUP.ID ID of the research group being searched on.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_WPSEARCHHISTORY_CONSTITUENTID CONSTITUENTID      
 IX_WPSEARCHHISTORY_DATEADDED DATEADDED    
 IX_WPSEARCHHISTORY_DATECHANGED DATECHANGED      
 PK_WPSEARCHHISTORY ID  

Trigger Name Description
 TR_WPSEARCHHISTORY_AUDIT_UPDATE
 TR_WPSEARCHHISTORY_AUDIT_DELETE

Referenced by Field
 WPPARSINGERROR WPSEARCHHISTORYID

Entity-Relationship diagram of this table