Type ContactCompanyRelations
Type category Entity
Description The ContactCompanyRelations table contains data for MMD contact company relations.
Fields
Name Type Filters Description
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
13 rows of 13 total
API Open API Specification