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 = ''
 DBID int   Default = 0
 REVISION int   Default = 0
 ORIGINALID int   Default = 0
 NEWROW bit   Default = 0
 CDATE datetime
 CVALUE money   Default = 0
 CNOTES nvarchar(1024)   Default = ''
 FULLHASH nvarchar(32)   Default = ''
 PARTIALHASH nvarchar(32)   Default = ''
 MC nvarchar(3)   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 = ''
 DUNS nvarchar(10)   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
 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
 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
 OWNERSHIPVALUEOVERRIDE money   Default = 0 User-entered value to use for OWNERSHIPVALUE.
 OWNERSHIPVALUEOVERRIDDEN bit   Default = 0 Indicates whether the ownership value should be overridden by the user-entered value in OWNERSHIPVALUEOVERRIDE.
 OWNERSHIPVALUE numeric(38, 6) (Computed) case when OWNERSHIPVALUEOVERRIDDEN=1 then OWNERSHIPVALUEOVERRIDE else case when HELDCODE=1 then VALUATION*(PERCENTAGE/100.0) else 0 end end
 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
 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.
 WPRELATIONSHIP_BO_ID uniqueidentifier WPRELATIONSHIP_BO.ID FK to WPRELATIONSHIP_BO

Index Name Field(s) Unique Primary Clustered
 IX_WPBUSINESSOWNERSHIP_DATEADDED DATEADDED    
 IX_WPBUSINESSOWNERSHIP_DATECHANGED DATECHANGED      
 IX_WPBUSINESSOWNERSHIP_ID ID      
 IX_WPBUSINESSOWNERSHIP_WEALTHID WEALTHID      
 IX_WPBUSINESSOWNERSHIP_WEALTHID_FULLHASH WEALTHID, FULLHASH      
 IX_WPBUSINESSOWNERSHIP_WEALTHID_PARTIALHASH WEALTHID, PARTIALHASH      
 IX_WPBUSINESSOWNERSHIP_WPRELATIONSHIP_BO_ID WPRELATIONSHIP_BO_ID      
 PK_WPBUSINESSOWNERSHIP ID  

Trigger Name Description
 TR_WPBUSINESSOWNERSHIP_AUDIT_UPDATE
 TR_WPBUSINESSOWNERSHIP_AUDIT_DELETE

Referenced by Field
 WPBUSINESSOWNERSHIPBIOS WPBUSINESSOWNERSHIPID
 WPBUSINESSOWNERSHIPHISTORY WPBUSINESSOWNERSHIPID
 WPBUSINESSOWNERSHIPOWNERSHIP WPBUSINESSOWNERSHIPID

Entity-Relationship diagram of this table