Type FamilyOffice
Type category Entity
Description The Family Office table contains data for MMD family offices.
Fields
Name Type Filters Description
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.
32 rows of 32 total
API Open API Specification