| key |
id |
string(500)* |
= |
The id field uniquely identifies the entity record. |
| link |
batch |
Batch |
= |
The batch that provided the data |
| link |
batchRun |
BatchRun |
= |
The batchRun that provided the data |
| link |
company |
Company |
|
MMD Company id, foreign key that links to the Company entity. |
| link |
contact |
Contact |
|
Foreign key that links to the Contacts entity. |
|
contactId |
long |
|
MMD Contact Id. |
|
insertDate |
dateTime |
|
Contact insertion date on previous company record. |
| link |
priorCompany |
Company |
|
MMD company id of the prior firm where the contact worked at, this is a foreign key that links to the Company entity. |
|
priorCompanyName |
string(120) |
|
Firm Name of priorCompanyId |
|
title |
string(140) |
|
Person’s job title such as President, Chief Executive Officer, etc. |
|
updateDate |
dateTime |
|
Contact company relation record last updated on |
|
yearHired |
string(4) |
|
Year hired at prior company |
|
yearLeft |
string(4) |
|
Year left from prior company |