WPBUSINESSOWNERSHIPHISTORY
Contains WealthPoint Business Ownership history data.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| 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) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| HELD |
nvarchar(7) (Computed) |
yes |
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) |
yes |
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 Keys
| 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. |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_WPBUSINESSOWNERSHIPHISTORY_DATEADDED |
DATEADDED |
|
|
yes |
| IX_WPBUSINESSOWNERSHIPHISTORY_DATECHANGED |
DATECHANGED |
|
|
|
| IX_WPBUSINESSOWNERSHIPHISTORY_WPBUSINESSOWNERSHIPID |
WPBUSINESSOWNERSHIPID |
|
|
|
| PK_WPBUSINESSOWNERSHIPHISTORY |
ID |
yes |
yes |
|
Triggers
Referenced by