Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 SOURCE nvarchar(100)   Default = ''
 FULLHASH nvarchar(32)   Default = ''
 PARTIALHASH nvarchar(32)   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
 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 = ''
 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.
 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
 WPBIOGRAPHICALID uniqueidentifier   WPBIOGRAPHICAL.ID FK to WPBIOGRAPHICAL
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_WPBIOGRAPHICALHISTORY_DATEADDED DATEADDED    
 IX_WPBIOGRAPHICALHISTORY_DATECHANGED DATECHANGED      
 IX_WPBIOGRAPHICALHISTORY_WPBIOGRAPHICALID WPBIOGRAPHICALID      
 PK_WPBIOGRAPHICALHISTORY ID  

Trigger Name Description
 TR_WPBIOGRAPHICALHISTORY_AUDIT_UPDATE
 TR_WPBIOGRAPHICALHISTORY_AUDIT_DELETE

Entity-Relationship diagram of this table