WPBUSINESSOWNERSHIP
Contains WealthPoint Business Ownership data.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| CONFIRMED |
bit |
|
Default = 0 |
|
| DATECONFIRMED |
datetime |
yes |
|
|
| REJECTED |
bit |
|
Default = 0 |
|
| DATEREJECTED |
datetime |
yes |
|
|
| SOURCE |
nvarchar(100) |
|
Default = '' |
|
| DBID |
int |
|
Default = 0 |
|
| REVISION |
int |
|
Default = 0 |
|
| ORIGINALID |
int |
|
Default = 0 |
|
| NEWROW |
bit |
|
Default = 0 |
|
| CDATE |
datetime |
yes |
|
|
| 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) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| RECURSIVEMATCH |
bit |
|
Default = 0 |
|
| 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 |
|
| 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) |
yes |
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 Keys
| Foreign Key |
Field Type |
Null |
Notes |
Description |
| WEALTHID |
uniqueidentifier |
|
WEALTH.ID
|
FK to WEALTH |
| CONFIRMEDBYAPPUSERID |
uniqueidentifier |
yes |
APPUSER.ID
|
FK to APPUSER |
| REJECTEDBYAPPUSERID |
uniqueidentifier |
yes |
APPUSER.ID
|
FK to APPUSER |
| ADDEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT. |
| CHANGEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT. |
| WPRELATIONSHIP_BO_ID |
uniqueidentifier |
yes |
WPRELATIONSHIP_BO.ID
|
FK to WPRELATIONSHIP_BO |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_WPBUSINESSOWNERSHIP_DATEADDED |
DATEADDED |
|
|
yes |
| 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 |
yes |
yes |
|
Triggers
Referenced by