| key |
id |
string(500)* |
= |
Unique identifier of the contact associated with a company. This is a concatenation of MMD contact id and company id, seperated by dash. |
| timeline |
updateDate |
dateTime* |
=< >= |
Contact record last updated on |
|
address1 |
string(80) |
|
This is the contact's mailing address line 1. |
|
address2 |
string(50) |
|
This is the contact's mailing address line 2. |
| link |
batch |
Batch |
= |
The batch that provided the data |
| link |
batchRun |
BatchRun |
= |
The batchRun that provided the data |
|
biography |
string(10000) |
|
Biography of the contact |
|
brokerName |
string(120) |
|
Broker Dealer firm name associated with contact. This field is only applicable to the InvestmentManager dataset. |
|
city |
string(50) |
|
City - Text field for city location |
| link |
company |
Company |
|
MMD Company id, foreign key that links to the Company entity. |
|
companyName |
string(120) |
|
Contact's company name |
|
consultantSpecialty |
string(200)[100] |
|
Specialty of the consultant contact and only applies to the Consultant dataset. |
|
contactId |
long |
|
MMD Contact Id. |
|
country |
string(50) |
|
Country |
|
countryCode |
string(2) |
|
Abbreviated Name of Country. |
|
datasetName |
string(50) |
|
Name of the dataset for the entity. |
|
email |
string(120) |
|
Email |
|
firstName |
string(30) |
|
Contact's first name |
|
isBank |
boolean |
|
Indicates if the contact is in charge of business development for a Bank (applies to job code 76). This field is only applicalbe to Investment Manager contacts. |
|
isBroker |
boolean |
|
Indicates if the contact is in charge of business development for a Broker Dealer (applies to job code 76). This field is only applicable to the Investment Manager contacts. |
|
isInsurer |
boolean |
|
Indicates if the contact is in charge of business development for an Insurance Company (applies to job code 76). This field is only applicable to the Investment Manager contacts. |
|
isMutualFund |
boolean |
|
Indicates if the contact is in charge of business development for a Mutual Fund Company (applies to job code 76). This field is only applicable to the Investment Manager contacts. |
|
isOther |
boolean |
|
Indicates if the contact is in charge of business development for "other" firm types (applies to job code 76). |
|
isRegisteredInvestmentAdvisor |
boolean |
|
Indicates if the contact is in charge of business development for an Investment Advisor (applies to job code 76). This field is only applicable to the Investment Manager contacts. |
|
isRegisteredRep |
boolean |
|
Indicates if the contact is a registered rep of a Broker/Dealer. This field is only applicalbe to Investment Manager contacts. |
|
jobTitle |
string(140) |
|
Contact's job title |
|
keyPersonId |
long |
|
This is the unique ID for the contact in CIQ Pro. |
|
lastName |
string(30) |
|
Contact's last name |
|
linkedIn |
string(300) |
|
LinkedIn url |
|
middleName |
string(30) |
|
Contact's middle name |
|
mktSpec1 |
string(4) |
|
If a client contact-marketing officer (applies to job code 30), their marketing focus1. This field is only applicable to the Investment Manager contacts. |
|
mktSpec2 |
string(4) |
|
If a client contact-marketing officer (applies to job code 30), their marketing focus1. This field is only applicable to the Investment Manager contacts. |
|
mktSpec3 |
string(4) |
|
If a client contact-marketing officer (applies to job code 30), their marketing focus1. This field is only applicable to the Investment Manager contacts. |
|
mktSpec4 |
string(4) |
|
If a client contact-marketing officer (applies to job code 30), their marketing focus1. This field is only applicable to the Investment Manager contacts. |
|
mktSpec5 |
string(4) |
|
If a client contact-marketing officer (applies to job code 30), their marketing focus1. This field is only applicable to the Investment Manager contacts. |
|
otherDescription |
string(60) |
|
Other Firm type Description. This field is only applicable to the Investment Managers dataset. |
|
personTitle |
string(10) |
|
Contact title |
|
phone |
string(80) |
|
Telephone Number for contact |
|
sex |
string(1) |
|
Contact's sex |
|
specialties |
string(50)[100] |
|
Portfolio Manager/Research Analyst Specialty Codes. Applies only to InvestmentManager dataset. |
|
stateProvince |
string(70) |
|
State or Province - Official Post Office abbreviation for state where the organization is located. |
|
suffix |
string(15) |
|
Contact's suffix |
|
yearHired |
string(4) |
|
Year hired |
|
yearsConsult |
long |
|
Years contact has been in consulting business. This field only applies to the Consultant dataset. |
|
zip |
string(12) |
|
Zip Code - Zip or mailing code |