Type InvestmentManager
Type category Entity
Description The InvestmentManager table contains data for MMD Investment Managers.
Fields
Name Type Filters Description
key id string(500)* = The id field uniquely identifies the entity record.
advOther string(500) Additional advisor program listed here if not applicable with advisor program field.
advisorProgram string(150) Name of the Advisor Program.
assetValuationDate date Valuation date for total assets of an investment manager.
assetsUnderManagement long Total assets under management listed for those organizations that manage assets, in USD. Blank if zero or not provided.
assetsUnderManagementLoc long Total assets under management listed for those organizations that manage assets, in local currency. Blank if zero or not provided.
associationMemberships string(1200) Associations the investment advisor is a member of.
bankAccountsCount long Number of Client Accounts for Bank Retirement Plans.
bankClientsCount long Number of Clients for Banks.
link batch Batch = The batch that provided the data
link batchRun BatchRun = The batchRun that provided the data
brokerDealersCount long Number of Broker/Dealers used regularly.
clientsCount long Number of Clients.
commingledPct decimal Percentage of total managed assets that are commingled (combines with previous field to total 100%).
link company Company MMD Company id, foreign key that links to the Company entity.
corpAccountsCount long Number of Client Accounts for Corporate Retirement Plans.
corpClientsCount long Number of Clients for Corporate Retirement Plans.
currencyCode string(3) Local currency conversion code.
discretionaryPct decimal Percentage of total managed assets that are discretionary (combines with following field to total 100%).
endowmentAccountsCount long Number of Client Accounts for Endowment Retirement Plans.
endowmentClientsCount long Number of Clients for Endowments.
externallyManagedPct decimal Percentage of total assets externally managed.
fees string(2000) FEE Schedule Text - This text describes the “fee schedule” of the management firm.
foundationAccountsCount long Number of Client Accounts for Foundation Retirement Plans.
foundationClientsCount long Number of Clients for Foundations.
hedgeFundAssets long Total value of Hedge Fund Assets in USD.
hedgeFundAssetsLoc long Total value of Hedge Fund Assets in local currency.
individuallyManagedPct decimal Percentage of total managed assets (see above) that are individually managed (combines with the commingledPct field to total 100%).
insuranceAccountsCount long Number of Client Accounts for Insurance Retirement Plans.
insuranceClientsCount long Number of Clients for Insurance Companies.
internallyManagedPct decimal Percentage of total assets internally managed.
investmentStyleDescription string(4000) This text describes the “investment style/strategy” of the manager..
isAdvisoryPublications boolean Indicates if organizations primary service is publishing a newsletter.
isAlternativeManager boolean Indicates if advisors are alternative asset managers.
isAssetAllocationAnalysis boolean Indicates if organization provides asset allocation analysis for Defined Contribution / 401(k) Plans.
isAssetManager boolean Indicates if advisors are asset managers.
isBankAffiliate boolean Indicates if the company is a Bank Affiliate.
isBrokerAffiliate boolean Indicates if the company is a Broker Affiliate.
isCarriesLiabilityInsurance boolean Indicates if organization carries liability insurance.
isEmployeeCommuncations boolean Indicates if organization provides employee communications for Defined Contribution / 401(k) Plans.
isEmployeeEducation boolean Indicates if organization provides employee education for Defined Contribution / 401(k) Plans.
isEquityManager boolean Indicates if advisors are equity asset managers.
isFeeOnlyAdvisor boolean Indicates if organization is a fee-only Advisor.
isFinancialAdvisor boolean Indicates if the company is a Financial Advisor.
isFinancialPlanner boolean Indicates if advisors are financial planners.
isFirmDirects529 boolean Indicates if firm directs client assets to 529 plans.
isFixedIncomeManager boolean Indicates if advisors are fixed asset managers.
isFundOfFundsManager boolean Indicates if the company is a Fund of Funds Manager.
isGipsCompliant boolean Indicates if organization in compliance with Global Investment Performance Standards.
isHedgeFundManager boolean Indicates if the company is a Hedge Fund Manager.
isIndependentAdvisor boolean Indicates if the company is a Sponsored Retail Managed Accounts Program.
isInstitutionalMoneyManager boolean Indicates if the company is an Institutional Money Manager.
isInsuranceBroker boolean Indicates if advisors who are insurance brokers.
isInsuranceCompanyAffiliate boolean Indicates if the company is an Insurance Company Affiliate.
isInvestmentManagement boolean Indicates if organization provides investment management for Defined Contribution / 401(k) Plans.
isManageHedgeFunds boolean Indicates if firm manages hedge funds.
isManagerOfManagers boolean Indicates if advisors who are managers of managers.
isMutualFundLoad boolean Indicates if the firm uses LOAD mutual funds.
isMutualFundNoLoad boolean Indicates if the firm uses NO LOAD mutual funds.
isOfferFundOfFunds boolean Indicates if the firm offers fund of funds.
isOffersCommissionBasedFees boolean Indicates if organization offers commission-based fees.
isOffersPerformanceBasedFees boolean Indicates if organization offers performance-based fees.
isOffersSoftDollarFees boolean Indicates if organization offers soft dollar fees.
isOnlyStateRegistered boolean Indicates that the firm is only state registered.
isPensionConsulant boolean Indicates if advisors are Pension Consultants.
isPlanDesign boolean Indicates if organization provides plan design for Defined Contribution / 401(k) Plans.
isPrivateEquityManager boolean Indicates if the company is a Private Equity Manager.
isProvideOtherService boolean Indicates if that the advisors provides additional services.
isRealEstateManager boolean Indicates if the company is a Real Estate Manager.
isRecordKeepingAdmin boolean Indicates if organization provides recordkeeping/administration for Defined Contribution / 401(k) Plans.
isSecRegistered boolean Indicates that the firm is SEC registered.
isSecuritiesBrokerDealer boolean Indicates if advisors who are securities brokers/dealers.
isSelectionOfOtherAdvisors boolean Indicates if advisors participate in the selection of other advisors.
isSells401k boolean Indicates if firm sells a bundled DC/401(k) plan through an affiliate of a broker/dealer or fund company.
isSeperatelyManaged boolean Firm seeks to manage retail assets in Separately Managed Account Programs sponsored by Broker Dealers.
isSocialScreening boolean Indicates if the organization socially screens investments.
isSponsoredProgram boolean Sponsored Retail Managed Accounts Program.
isSuggestsBrokers boolean Inidcates if brokers suggested to clients.
managedTaxBank long Total value of Managed Taxable Assets for Banks in USD.
managedTaxBankLoc long Total value of Managed Taxable Assets for Banks in local currency.
managedTaxExemptCorp long Total value of Managed Tax-Exempt Assets for Corporate Retirement Plans in USD.
managedTaxExemptCorpLoc long Total value of Managed Tax-Exempt Assets for Corporate Retirement Plans in local currency.
managedTaxExemptEndowments long Total value of Managed Tax-Exempt Assets for Endowments in USD.
managedTaxExemptEndowmentsLoc long Total value of Managed Taxable Assets for Banks in local currency.
managedTaxExemptFoundation long Total value of Managed Tax-Exempt Assets for Foundations in USD.
managedTaxExemptFoundationLoc long Total value of Managed Tax-Exempt Assets for Foundations in local currency.
managedTaxExemptIndividual long Total value of Managed Tax-Exempt Assets for Individuals in USD.
managedTaxExemptIndividualLoc long Total value of Managed Tax-Exempt Assets for Individuals in local currency.
managedTaxExemptNonprofit long Total value of Managed Tax-Exempt Assets for Not for Profits in USD.
managedTaxExemptNonprofitLoc long Total value of Managed Tax-Exempt Assets for Not for Profits in local currency.
managedTaxExemptPublic long Total value of Managed Tax-Exempt Assets for Public Retirement Plans in USD.
managedTaxExemptPublicLoc long Total value of Managed Tax-Exempt Assets for Public Retirement Plans in local currency.
managedTaxExemptUnion long Total value of Managed Tax-Exempt Assets for Union Retirement Plans in USD.
managedTaxExemptUnionLoc long Total value of Managed Tax-Exempt Assets for Union Retirement Plans in local currency.
managedTaxIndividual long Total value of Managed Taxable Assets for Individuals in USD.
managedTaxIndividualLoc long Total value of Managed Taxable Assets for Individuals in local currency.
managedTaxInsurance long Total value of Managed Taxable Assets for Insurance Companies in USD.
managedTaxInsuranceLoc long Total value of Managed Taxable Assets for Insurance Companies in local currency.
managedTaxMutualFund long Total value of Managed Taxable Assets for Mutual Funds in USD.
managedTaxMutualFundLoc long Total value of Managed Taxable Assets for Mutual Funds in local currency.
minimumAccountText string(500) Minimum Size of Account accepted by company..
mutualFundAccountsCount long Number of Client Accounts for Mutual Fund Retirement Plans.
mutualFundAssets long Total value of Mutual Fund Assets in USD.
mutualFundAssetsLoc long Total value of Mutual Fund Assets in local currency.
mutualFundBalancedPct decimal % of Mutual Funds allocated to Balanced Funds.
mutualFundBondPct decimal % of Mutual Funds allocated to Bond Funds.
mutualFundClientsCount long Number of Clients for Mutual Funds.
mutualFundEquityPct decimal % of Mutual Funds allocated to Equity Funds.
mutualFundOtherPct decimal % of Mutual Funds allocated to Other Funds.
nonDiscretionaryPct decimal Percentage of total managed assets that are non-discretionary (combines with discretionaryPct to total 100%)
nonprofitAccountsCount long Number of Client Accounts for Not for Profit Retirement Plans.
nonprofitClientsCount long Number of Clients for Not for Profits.
otherResearchSourceText string(120) Description of other research sources.
otherServicesText string(200) Description of the additional services.
primaryCustodian string(500) Firm’s Primary Custodian.
primaryLiabilityInsurance string(240) Primary Liability Insurance Company Name.
professionalEmployeesCount long Number of professional employees at this organization..
publicAccountsCount long Number of Client Accounts for Public Retirement Plans.
publicClientsCount long Number of Clients for Public Retirement Plans.
registrationNumber string(40) SEC File Number - Company’s SEC registration number.
researchConsultantsPct decimal Percentage of Research from Consultants.
researchInHousePct decimal Percentage of Research from In-House Sources.
researchOtherSourcePct decimal Percentage of Research from Other Sources.
researchStreetSourcePct decimal Percentage of Research from Street Sources.
secRegistrationDate date SEC Registration Date that the investment advisory organization became registered with the Securities and Exchange Commission.
socialScreeningText string(500) Social Restrictions Text.
taxExemptAUMLoc long Total tax-exempt assets under management in local currency if applicable. Blank when zero or if not provided.
taxExemptAccountsCount long Number of accounts of Tax-Exempt Clients.
taxExemptAssets long Tax-Exempt Assets managed by the organization in USD.
taxExemptAssetsUnderManagement long Total tax-exempt assets under management in USD if applicable. Blank when zero or if not provided.
taxExemptClientsCount long Number of Tax-Exempt Clients.
taxExemptTotalAssets long Total value of other tax-exempt assets in USD.
taxableAUMLoc long Total value of taxable assets under management in local currency if applicable. Blank when zero or not provided.
taxableAccountsCount long Number of accounts of Taxable Clients.
taxableAssets long Taxable Assets managed by the organization in USD.
taxableAssetsUnderManagement long Total value of taxable assets under management in USD if applicable. Blank when zero or not provided.
taxableClientsCount long Number of Taxable Clients.
thirdPartyClearingService string(250) Organization’s third party for clearing services.
unionAccountsCount long Number of Client Accounts for Union Retirement Plans.
unionClientsCount long Number of Clients for Union Retirement (Taft-Hartley) Plans.
updateDate dateTime Date the organization’s record last updated on.
141 rows of 141 total
API Open API Specification