| 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. |