| key |
id |
string(500)* |
= |
The id field uniquely identifies the entity record. |
|
assetRange |
string(8) |
|
Asset range. |
| link |
batch |
Batch |
= |
The batch that provided the data |
| link |
batchRun |
BatchRun |
= |
The batchRun that provided the data |
| link |
company |
Company |
|
MMD Company id, foreign key that links to the Company entity. |
|
description |
string(4000) |
|
Business Descripton of Firm. |
|
familyAssets |
long |
|
Family Office asset total (in 000’s) in local currency. |
|
familyAssetsCurrencyCode |
string(3) |
|
Family Office asset reporting currency. |
|
familyAssetsValidDate |
date |
|
Date at which Family Office asset total is valid. |
|
imParentAssetMixPct |
decimal |
|
Provides running total of Asset Mix % from RIA_FO_AMIX. |
|
imParentAssets |
long |
|
Assets from referral investment manager in local currency. |
|
imParentAssetsCurrencyCode |
string(3) |
|
Assets from referral investment manager reporting currency. |
|
imParentAssetsValidDate |
date |
|
Date at which asset range is valid. |
|
isCliHigh |
boolean |
|
Indicates if the firm's current clients have assets within a range of $100 million-$500 million AUM. |
|
isCliLow |
boolean |
|
Indicates if the firm's current clients have assets within a range of $25 million-$50 million AUM. |
|
isCliMid |
boolean |
|
Indicates if the firm's current clients have assets within a range of $50 million-$100 million AUM. |
|
isCliVeryHigh |
boolean |
|
Indicates if the firm's current clients have assets within a range of $500 million-$1 billion AUM. |
|
isCliVeryLow |
boolean |
|
Indicates if the firm's current clients have assets within a range of $5 million-$25 million AUM. |
|
isCliVeryVeryHigh |
boolean |
|
Indicates if the firm's current clients have assets over Over $1 billion AUM. |
|
isCliVeryVeryLow |
boolean |
|
Indicates if the firm's current clients have assets within a range of $1 million-$5 million AUM. |
|
isFamilyOffice |
boolean |
|
Indicates if the firm is a Single Family Office. |
|
isFamilyOfficeServiceProvider |
boolean |
|
Indicates if the firm is a Family Office Service Provider. |
|
isMultiFamilyOffice |
boolean |
|
Indicates if the firm is a Multi-Family Office. |
|
isPrivateBank |
boolean |
|
Indicates if the firm is a Private Bank. |
|
isProvidesServices |
boolean |
|
Indicates if the firm provides services to Family Offices. |
|
isWealthManager |
boolean |
|
Indicates if the firm is a Wealth Manager. |
|
managedExternallyPct |
decimal |
|
% of Family Office assets managed externally. |
|
managedInternallyPct |
decimal |
|
% of Family Office assets managed internally. |
|
minimumAccount |
long |
|
Smallest size of account accepted. |
|
numberOfFOClients |
long |
|
Number of Family Office Clients. |
|
totalClientsCount |
long |
|
Number of Total Clients from referral investment manager, |
|
updateDate |
dateTime |
|
Date the Family Office record was last updated on. |