Type Company
Type category Entity
Description The Entity table contains data for MMD companies.
Fields
Name Type Filters Description
key id string(500)* = The id field uniquely identifies the entity record. MMD company id - This max 10-Digit number is unique to this organization and references all subsidiary records.
address string(252) Street Address - Text field for physical location of organization.
affiliate string(120) Affiliate, Subsidiary - Text field indicating the organization's relationship to another organization.
link batch Batch = The batch that provided the data
link batchRun BatchRun = The batchRun that provided the data
categoryCode long Category Code - Identifies type of organization.
filter_list categoryName string(150) = Category name of the Firm.
ciqCompanyId long Used to map an MMD entity to corresponding data in other SP Global datasets. Field length up to 12 digits. NULL value indicates no mapping available.
city string(50) City - Text field for city location.
companyNameTranslated string(240) Translated name for non-U.S. Companies.
consultantsCount long Number of consultant firms consulting on the firm's selection of investment manager firms. Duplications (the same consultant listed under several plans) have been eliminated.
filter_list country string(50) = ShortName of a country.
countryCode string(2) Abbreviated Name of Country.
currencyCode string(3) Local currency conversion code.
filter_list datasetName string(50) = Name of the dataset for the entity.
ein string(9) Employer Identification Number (EIN #).
email string(320) Firm's email address, including the domain as reported by SME.
employeesCount long Number of employees in consulting firm.
fax string(30) Fax number for company.
firmAssets long Firm assets in USD.
firmAssetsLoc long Firm assets in local currency.
iardCrd string(20) Firm's IARD / CRD Number.
internationalProvinceCode string(200) International State and/or Province Code.
investmentManagerAccountsCount long Number of accounts of all clients.
isInvestmentManagerAffiliate boolean Indicates if the company is a Investment Manager Affiliate.
isMinorityOwned boolean Indicates if the company is a Minority owned Firm.
isPublic boolean Indicates if the firm's stock is publicly held.
isWomanOwned boolean Indicates if the company is a Woman-Owned Firm.
mailAddress string(114) Mailing Address - This is the preferred mailing address for firm.
metro string(38) State and City Standard Metropolitan Area.
minorityOwnedPct decimal Percentage Minority owned.
name string(120) Company Name - Organization's name.
phone string(30) Telephone number for company.
referenceId long This 7-Digit number is the permanent ID of the organization used to create original profile.
registrationNumber string(30) Registration Number of International Companies.
sortName string(120) Name of organization used for alphabetizing if COMPANY-NAME is inappropriate for this purpose.
stateCode string(10) State or Province - Official Post Office abbreviation for state/province where the organization is located in North America (i.e. US-CA).
status string(1) Indicates whether the entity is active, inactive or under review (A,I or X).
symbols string(10)[100] Stock Exchanges that the organization's stocks are traded on.
ticker string(10) Ticker symbol of organization stock.
updateDate dateTime Allocation record last updated on.
websiteUrl string(500) World Wide Web Address of firm.
womanOwnedPct decimal Percentage Woman owned.
yearFounded long Date the company was founded.
zip string(12) Zip Code - Zip or mailing code.
45 rows of 45 total
API Open API Specification