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 = ''
 TITLE nvarchar(100)   Default = ''
 LINE1 nvarchar(150)   Default = ''
 CITY nvarchar(30)   Default = ''
 STATE nvarchar(100)   Default = ''
 ZIP nvarchar(10)   Default = ''
 BIO nvarchar(1500)   Default = ''
 COMPANY nvarchar(100)   Default = ''
 PHONE nvarchar(20)   Default = ''
 LINE_OF_BUSINESS_DESCRIPTION nvarchar(50)   Default = ''
 SALES_VOLUME money   Default = 0
 YEAR_STARTED UDT_YEAR   Default = ((0))
 EMPLOYEES_TOTAL int   Default = 0
 SIC_CODE nvarchar(4)   Default = ''
 PERCENTAGE decimal(20, 4)   Default = 0
 VALUATION money   Default = 0
 SPOUSEIND int   Default = 0
 HELDCODE tinyint   Default = 2 0=Public, 1=Private, 2=Unknown
 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.
 HELD nvarchar(7) (Computed) CASE [HELDCODE] WHEN 0 THEN N'Public' WHEN 1 THEN N'Private' WHEN 2 THEN N'Unknown' END Provides a translation for the 'HELDCODE' field.
 MAILINGLINE1 nvarchar(150)   Default = ''
 MAILINGCITY nvarchar(30)   Default = ''
 MAILINGSTATE nvarchar(100)   Default = ''
 MAILINGZIP nvarchar(10)   Default = ''
 HOMELINE1 nvarchar(150)   Default = ''
 HOMECITY nvarchar(30)   Default = ''
 HOMESTATE nvarchar(100)   Default = ''
 HOMEZIP nvarchar(10)   Default = ''
 SICNAME nvarchar(100)   Default = ''
 YEAROFBIRTH UDT_YEAR   Default = ((0))
 GENDERCODE tinyint   Default = 0 0=Unknown, 1=Male, 2=Female
 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.
 RATIO decimal(20, 4)   Default = 0
 SIC_CODE1 nvarchar(4)   Default = ''
 SIC_CODE2 nvarchar(4)   Default = ''
 SIC_CODE3 nvarchar(4)   Default = ''
 SIC_CODE4 nvarchar(4)   Default = ''
 SIC_CODE5 nvarchar(4)   Default = ''
 SIC_CODE6 nvarchar(4)   Default = ''
 RATIO1 decimal(20, 4)   Default = 0
 RATIO2 decimal(20, 4)   Default = 0
 RATIO3 decimal(20, 4)   Default = 0
 RATIO4 decimal(20, 4)   Default = 0
 RATIO5 decimal(20, 4)   Default = 0
 RATIO6 decimal(20, 4)   Default = 0

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

Index Name Field(s) Unique Primary Clustered
 IX_WPBUSINESSOWNERSHIPHISTORY_DATEADDED DATEADDED    
 IX_WPBUSINESSOWNERSHIPHISTORY_DATECHANGED DATECHANGED      
 IX_WPBUSINESSOWNERSHIPHISTORY_WPBUSINESSOWNERSHIPID WPBUSINESSOWNERSHIPID      
 PK_WPBUSINESSOWNERSHIPHISTORY ID  

Trigger Name Description
 TR_WPBUSINESSOWNERSHIPHISTORY_AUDIT_UPDATE
 TR_WPBUSINESSOWNERSHIPHISTORY_AUDIT_DELETE

Referenced by Field
 WPBUSINESSOWNERSHIPBIOSHISTORY WPBUSINESSOWNERSHIPHISTORYID
 WPBUSINESSOWNERSHIPOWNERSHIPHISTORY WPBUSINESSOWNERSHIPHISTORYID

Entity-Relationship diagram of this table