Type Consultant
Type category Entity
Description The Consultant table contains data for MMD consultants.
Fields
Name Type Filters Description
key id string(500)* = The id field uniquely identifies the entity record.
assetValuationDate date Valuation date for total assets of a consulting firm.
link batch Batch = The batch that provided the data
link batchRun BatchRun = The batchRun that provided the data
clientsCount long Total Number of Current Clients (retainer & active).
link company Company MMD Company id, foreign key that links to the Company entity.
corporationAssetsPlaced long Corporations Assets Placed.
corporationLarge long Amount of Clients for Corporations Corporations $50-100 million.
corporationMedium long Amount of Clients for Corporations Corporations $10-50 million.
corporationSmall long Amount of Clients for Corporations <$10 million.
corporationVeryLarge long Amount of Clients for Corporations Corporations >$100 million.
dbPlanSpecifications string(500) Defined Benefit plan specifications.
dcPlanSpecifications string(500) Defined Contribution plan specifications.
endowmentAssetsPlaced long Endowments Assets Placed.
endowmentLarge long Amount of Clients for Endowments $50-100 million.
endowmentMedium long Amount of Clients for Endowments $10-50 million.
endowmentSmall long Amount of Clients for Endowments <$10 million.
endowmentSpecifications string(500) Endowment specifications.
endowmentVeryLarge long Amount of Clients for Endowments >$100 million.
familyOfficeSpecifications string(500) Family Offices / Trusts specifications.
financialInstitutionLarge long Amount of Clients for Financial Institutions $50-100 million.
financialInstitutionMedium long Amount of Clients for Financial Institutions $10-50 million.
financialInstitutionSmall long Amount of Clients for Financial Institutions <$10 million.
financialInstitutionSpecs string(500) Financial Institution specifications.
financialInstitutionVeryLarge long Amount of Clients for Financial Institutions >$100 million.
financialInstnAssetsPlaced long Financial Institutions Assets Placed.
foundationAssetsPlaced long Foundations Assets Placed.
foundationLarge long Amount of Clients for Foundations $50-100 million.
foundationMedium long Amount of Clients for Foundations $10-50 million.
foundationSmall long Amount of Clients for Foundations <$10 million.
foundationSpecifications string(500) Foundation specifications.
foundationVeryLarge long Amount of Clients for Foundations >$100 million.
governmentAssetsPlaced long Amount of Clients for Governments Assets Placed.
governmentLarge long Amount of Clients for Governments $50-100 million.
governmentMedium long Amount of Clients for Governments $10-50 million.
governmentPlanSpecifications string(500) Government plan specifications.
governmentSmall long Amount of Clients for Governments <$10 million.
governmentVeryLarge long Amount of Clients for Governments >$100 million.
hospitalAssetsPlaced long Hospitals Assets Placed.
hospitalLarge long Amount of Clients for Hospitals $50-100 million.
hospitalMedium long Amount of Clients for Hospitals $10-50 million.
hospitalSmall long Amount of Clients for Hospitals <$10 million.
hospitalSpecifications string(500) Hospital specifications.
hospitalVeryLarge long Amount of Clients for Hospitals >$100 million.
individualAssetsPlaced long Individuals Assets Placed.
individualLarge long Amount of Clients for Individuals $50-100 million.
individualMedium long Amount of Clients for Individuals $10-50 million.
individualSmall long Amount of Clients for Individuals <$10 million.
individualSpecifications string(500) Individual specifications.
individualVeryLarge long Amount of Clients for Individuals >$100 million.
isCorpDefinedContribution boolean Indicates market focus for Corporate Defined Contribution plans.
isDefinedBenefitPlans boolean Indicates market focus for Corporate Defined Benefit plans.
isEndowment boolean Indicates market focus for Endowments.
isFamilyOffice boolean Indicates market focus for Family Offices / Trusts.
isFinancialInstitution boolean Indicates market focus for Financial Institutions.
isForInvestmentProducts boolean Indicates if consultant collects fees for For Investment Products (includes Wrap).
isFoundation boolean Indicates market focus for Foundations.
isFromManager boolean Indicates if consultant collects fees for From any Manager.
isGovernmentPlan boolean Indicates market focus for Government plans.
isHardDollar boolean Indicates if consultant collects fees for Hard-Dollar.
isHospital boolean Indicates market focus for Hospitals.
isIndividual boolean Indicates market focus for Individuals.
isOther boolean Indicates market focus for a separate type.
isOtherAdditional boolean Indicates market focus for a separate type.
isPerformanceIncentive boolean Indicates if consultant collects fees for Performance Incentive.
isProjectBasis boolean Indicates if consultant collects fees for Project Basis.
isRetainerBasis boolean Indicates if consultant collects fees for Retainer Basis.
isSaleSoftwareResearch boolean Indicates if consultant collects fees for Sale of Software/Research Products.
isSoftDollar boolean Indicates if consultant collects fees for Soft-Dollar.
isUnionPlan boolean Indicates market focus for Union plans.
notForProfitAssetsPlaced long Not for Profits Assets Placed.
notForProfitLarge long Amount of Clients for Not for Profits $50-100 million.
notForProfitMedium long Amount of Clients for Not for Profits $10-50 million.
notForProfitSmall long Amount of Clients for Not for Profits <$10 million.
notForProfitVeryLarge long Amount of Clients for Not for Profits >$100 million.
otherAdditionalAssetsPlaced long Additional Assets Placed.
otherAdditionalLarge long Amount of Clients for Additional Client Type $50-100 million.
otherAdditionalMedium long Amount of Clients for Additional Client Type $10-50 million.
otherAdditionalSmall long Amount of Clients for Additional Client Type <$10 million.
otherAdditionalSpecifications string(500) Additional Market Focus specifications.
otherAdditionalVeryLarge long Amount of Clients for Additional Client Type >$100 million.
otherAddtlClientDescription string(240) Additional Client Type description.
otherAddtlFocusDescription string(240) Additional Market Focus description..
otherAssetsPlaced long Other Client Type Assets Placed.
otherClientDescription string(240) Other Client Type Description.
otherLarge long Amount of Clients for Additional Client Type $50-100 million.
otherMarketFocusDescription string(240) Other market focus description.
otherMedium long Amount of Clients for Client Type $10-50 million.
otherSmall long Amount of Clients for Client Type <$10 million.
otherSpecifications string(500) Other Market Focus Specifications.
otherVeryLarge long Amount of Clients for Client Type >$100 million.
unionAssetsPlaced long Unions Assets Placed.
unionLarge long Amount of Clients for Unions $50-100 million.
unionMedium long Amount of Clients for Unions $10-50 million.
unionPlanSpecifications string(500) Union plan specifications.
unionSmall long Amount of Clients for Unions <$10 million.
unionVeryLarge long Amount of Clients for Unions >$100 million.
updateDate dateTime Date the organization’s record was last updated on.
98 rows of 98 total
API Open API Specification