| key |
id |
string* |
= |
An auto generated sequential number by S&P Global Mobility to uniquely identify a company. |
| timeline |
fromDbDate |
dateTime |
=< >= |
When the record was created in the source table - UTC datetime. This field is maintained on a go-forward basis starting Q3 2023. |
| link |
batch |
Batch* |
= |
The batch that provided the data |
| link |
batchRun |
BatchRun* |
= |
The batchRun that provided the data |
|
brand |
string |
|
Brand name under which a vehicle is sold. |
|
ciqCompanyId |
long |
|
The unique entity identifier created by S&P Capital IQ. |
|
fileDate |
date |
|
Date of the incoming source file. |
|
strategicGroup |
string |
|
Categories of brands based on ownership, strategic partnership, or alliance, including 'part ownership' and 'management control'. |
|
timestamp |
dateTime |
|
Date the company record was last updated. |
|
toDbDate |
dateTime |
|
The end datetime (UTC) of the record in the database. This date is when the value changes and the record is closed; it can be used to track history of changes. In most cases, the toDBDate field is NULL, meaning the record is current. This field is maintained on a go-forward basis starting Q3 2023. |