Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 CONFIRMED bit   Default = 0
 DATECONFIRMED datetime
 REJECTED bit   Default = 0
 DATEREJECTED datetime
 SOURCE nvarchar(100)   Default = ''
 LSID int   Default = 0
 REVISION int   Default = 0
 ORIGINALID int   Default = 0
 NEWROW bit   Default = 0
 FULLHASH nvarchar(32)   Default = ''
 PARTIALHASH nvarchar(32)   Default = ''
 MC nvarchar(3)   Default = ''
 PHONE nvarchar(20)   Default = ''
 GENDERCODE tinyint   Default = 0 0=Unknown, 1=Male, 2=Female
 MULTIMILLN nvarchar(25)   Default = ''
 WEALTHIND nvarchar(1000)   Default = ''
 RPASSETS money   Default = 0
 FULLNAME nvarchar(100)   Default = ''
 CNOTES nvarchar(1024)   Default = ''
 VIEWED bit   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.
 RECURSIVEMATCH bit   Default = 0
 ADDRESSTYPE nvarchar(25)   Default = ''
 LINE1 nvarchar(100)   Default = ''
 CITY nvarchar(25)   Default = ''
 STATE nvarchar(2)   Default = ''
 ZIP nvarchar(5)   Default = ''
 ZIP4 nvarchar(4)   Default = ''
 COUNTY nvarchar(20)   Default = ''
 TITLE nvarchar(50)   Default = ''
 COMPANY nvarchar(50)   Default = ''
 WEBSITE nvarchar(200)   Default = ''
 SALES money   Default = 0
 EMPLOYMENT int   Default = 0
 NAICS nvarchar(100)   Default = ''
 AGE nvarchar(7)   Default = ''
 DONOR nvarchar(250)   Default = ''
 HOMEOWNER nvarchar(25)   Default = ''
 MARITAL nvarchar(25)   Default = ''
 DWELLING nvarchar(35)   Default = ''
 LENGTHOFRESIDENCE nvarchar(35)   Default = ''
 CHILDRENINDICATOR nvarchar(200)   Default = ''
 INCOME nvarchar(25)   Default = ''
 NEWPROSPECT nvarchar(1)   Default = ''
 DONOTCALL nvarchar(25)   Default = ''
 METROPOLITANSTATISTICALAREA nvarchar(8)   Default = ''
 CONTRIBUTOR nvarchar(35)   Default = ''
 POLITICALAFFILIATION nvarchar(25)   Default = ''
 RELIGIOUSAFFILIATION nvarchar(25)   Default = ''
 ETHNIC nvarchar(50)   Default = ''
 GENDER nvarchar(7) (Computed) CASE [GENDERCODE] WHEN 0 THEN N'Unknown' WHEN 1 THEN N'Male' WHEN 2 THEN N'Female' END Provides a translation for the 'GENDERCODE' field.

Foreign Key Field Type Null Notes Description
 WEALTHID uniqueidentifier   WEALTH.ID FK to WEALTH
 CONFIRMEDBYAPPUSERID uniqueidentifier APPUSER.ID FK to APPUSER
 REJECTEDBYAPPUSERID uniqueidentifier APPUSER.ID FK to APPUSER
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_WPAFFLUENCEINDICATOR_DATEADDED DATEADDED    
 IX_WPAFFLUENCEINDICATOR_DATECHANGED DATECHANGED      
 IX_WPAFFLUENCEINDICATOR_WEALTHID WEALTHID      
 PK_WPAFFLUENCEINDICATOR ID  

Trigger Name Description
 TR_WPAFFLUENCEINDICATOR_AUDIT_UPDATE
 TR_WPAFFLUENCEINDICATOR_AUDIT_DELETE

Entity-Relationship diagram of this table