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