| 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 |
|
ciqCompanyId |
long |
|
The unique entity identifier created by S&P Capital IQ. |
|
fileDate |
date |
|
Date of the incoming source file. |
|
salesParent |
string |
|
The company who owns the brand at the current point in time. Ownership is defined strictly as >50% of the company value, whether or not if publicly-traded or privately-held. |
|
timestamp |
dateTime |
|
UTC timestamp in which the record was inserted in the database |
|
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. |