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