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 = ''
 WWID 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 = ''
 FULLNAME nvarchar(100)   Default = ''
 LINE1 nvarchar(4000)   Default = ''
 CITY nvarchar(4000)   Default = ''
 STATE nvarchar(4000)   Default = ''
 ZIP nvarchar(50)   Default = ''
 A2LINE1 nvarchar(4000)   Default = ''
 A2CITY nvarchar(4000)   Default = ''
 A2STATE nvarchar(4000)   Default = ''
 A2ZIP nvarchar(50)   Default = ''
 GENDERCODE tinyint   Default = 0 0=Unknown, 1=Male, 2=Female
 BIRTHDATE datetime
 CNOTES nvarchar(1024)   Default = ''
 BIRTHPLACE nvarchar(120)   Default = ''
 DECEASEDDATE UDT_FUZZYDATE   Default = '00000000'
 OCCUPATION nvarchar(4000)   Default = ''
 EDUCATION nvarchar(max)   Default = ''
 FAMILY nvarchar(max)   Default = ''
 POSITIONSHELD nvarchar(max)   Default = ''
 CERTIFICATIONS nvarchar(max)   Default = ''
 CAREER nvarchar(max)   Default = ''
 AWARDS nvarchar(max)   Default = ''
 MEMBERSHIPS nvarchar(max)   Default = ''
 RESEARCHINTERESTS nvarchar(max)   Default = ''
 POLITICALRELIGIOUSAFFILIATIONS nvarchar(max)   Default = ''
 CIVICMILITARYSERVICE nvarchar(max)   Default = ''
 THOUGHTSONLIFE nvarchar(max)   Default = ''
 LAW nvarchar(max)   Default = ''
 PERSONAL nvarchar(max)   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
 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_WPBIOGRAPHICAL_DATEADDED DATEADDED    
 IX_WPBIOGRAPHICAL_DATECHANGED DATECHANGED      
 IX_WPBIOGRAPHICAL_ID_WEALTHID ID, WEALTHID      
 IX_WPBIOGRAPHICAL_WEALTHID_FULLHASH WEALTHID, FULLHASH      
 IX_WPBIOGRAPHICAL_WEALTHID_PARTIALHASH WEALTHID, PARTIALHASH      
 PK_WPBIOGRAPHICAL ID  

Trigger Name Description
 TR_WPBIOGRAPHICAL_AUDIT_UPDATE
 TR_WPBIOGRAPHICAL_AUDIT_DELETE

Referenced by Field
 WPBIOGRAPHICALHISTORY WPBIOGRAPHICALID

Entity-Relationship diagram of this table