| REQUESTID |
int |
|
Default = 0 |
Indicates the WealthPoint Search Request ID. |
| DATESUBMITTED |
datetime |
yes |
|
Date request was submitted to WealthPoint. |
| DATESTARTED |
datetime |
yes |
|
Date WealthPoint Search was started. |
| DATEREADY |
datetime |
yes |
|
Date WealthPoint Search results were ready. |
| DATERETRIEVED |
datetime |
yes |
|
Indicates the date when the results of the WealthPoint Search have been retrieved from WealthPoint |
| STATUSCODE |
tinyint |
|
Default = 0 |
Status of the WealthPoint Search request. |
| STATUSDETAILS |
nvarchar(500) |
|
Default = '' |
Details of the status of the WealthPoint search request. |
| PARSING |
bit |
|
Default = 0 |
Indicates that a WealthPoint search request is being parsed. |
| 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. |
| JOBID |
nvarchar(50) |
|
Default = '' |
Indicates the WealthPoint Search Job ID. |
| SEARCHTYPECODE |
tinyint |
|
Default = 0 |
Used to indicate the type of search. |
| RECORDCOUNT |
int |
|
Default = 0 |
Number of records in search |
| STATUS |
nvarchar(13) (Computed) |
yes |
CASE [STATUSCODE] WHEN 0 THEN N'Created' WHEN 1 THEN N'Pending' WHEN 2 THEN N'Results ready' WHEN 3 THEN N'Completed' WHEN 4 THEN N'Failed' WHEN 5 THEN N'Canceled' END |
Provides a translation for the 'STATUSCODE' field. |
| SECURITIES_REFRESHDATE |
datetime |
yes |
|
As of this search, the last time that Thomson Financial was refreshed. |
| NPA_REFRESHDATE |
datetime |
yes |
|
As of this search, the last time that Guidestar was refreshed. |
| PF_REFRESHDATE |
datetime |
yes |
|
As of this search, the last time that Guidestar was refreshed. |
| BO_REFRESHDATE |
datetime |
yes |
|
As of this search, the last time that Dun and Bradstreet was refreshed. |
| BIO_REFRESHDATE |
datetime |
yes |
|
The last time that Marquis Who's Who was refreshed. |
| SEARCHTYPE |
nvarchar(21) (Computed) |
yes |
CASE [SEARCHTYPECODE] WHEN 0 THEN N'Constituent' WHEN 1 THEN N'Research Group' WHEN 2 THEN N'Rescreen' WHEN 3 THEN N'Selected Constituents' END |
|
| REQUESTEDDATASOURCES |
nvarchar(250) |
|
Default = '' |
|