Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 MANUALCONFIDENCE int   Default = 0
 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.
 WEALTHPOINTURL UDT_WEBADDRESS   Default = '' URL on the WealthPoint Web Service.
 DATAREFRESHENABLED bit   Default = 0 Flag indicating if any jobs are scheduled for the Data Refresh business process.
 REGISTERED bit   Default = 0 Indicates whether the application has registered the WealthPoint Web Service.
 ACCOUNTTYPECODE tinyint   Default = 0 0=Unknown, 1=Gold, 2=Silver, 3=Bronze
 ACCOUNTTYPE nvarchar(12) (Computed) CASE [ACCOUNTTYPECODE] WHEN 0 THEN N'Unknown' WHEN 1 THEN N'Gold' WHEN 2 THEN N'Silver' WHEN 3 THEN N'Bronze' WHEN 4 THEN N'Crystal' WHEN 5 THEN N'Starter' WHEN 6 THEN N'Essentials' WHEN 7 THEN N'Professional' END
 PARALLELSEARCHLIMIT int   Default = 25
 BBWSURL UDT_WEBADDRESS   Default = ''
 BBWSUSERNAME nvarchar(4000)   Default = ''
 BBWSPASSWORD nvarchar(4000)   Default = ''
 LOGERRORS bit   Default = 0
 TURBOPARSECHECKED datetime
 NUMADDRESSES int   Default = 5

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_WEALTHPOINTCONFIGURATION_DATEADDED DATEADDED    
 IX_WEALTHPOINTCONFIGURATION_DATECHANGED DATECHANGED      
 PK_WEALTHPOINTCONFIGURATION ID  

Trigger Name Description
 TR_WEALTHPOINTCONFIGURATION_AUDIT_UPDATE
 TR_WEALTHPOINTCONFIGURATION_AUDIT_DELETE