| key |
id |
string(100)* |
= |
The unique identifier for the segment classification. |
| timeline |
updDate |
dateTime* |
=< >= |
Last modification date and time of a physical row |
|
companyId |
long(-2147483648,2147483647) |
|
The unique identifier assigned to each company in the S&P Capital IQ database. |
|
dateAddedOn |
dateTime |
|
Represents the date and time when segment was added. Time zone is ET. |
|
documentId |
long(-2147483648,2147483647) |
|
A unique identifier that identifies the source document used for this update. |
| link |
segment |
Segment |
|
The unique identifier for the segment. |
|
segmentClassificationId |
long(-2147483648,2147483647)* |
|
Numeric identifier for the segment classification record. |
| link |
segmentClassificationType |
SegmentClassificationType |
|
The numerical Id for the segment classification type, with a value of 1-6. |
|
segmentClassificationTypeId |
long(-2147483648,2147483647) |
|
The numerical Id for the segment classification type, with a value of 1-6. |
|
segmentId |
long(-2147483648,2147483647) |
|
The unique identifier for the segment. |
| link |
subType |
SubType |
|
This is the primary identifier for the industries, geographies and other types of characteristics. |
|
subTypeId |
long(-2147483648,2147483647) |
|
This is the primary identifier for the industries, geographies and other types of characteristics. |
|
updOperation |
long(0,2) |
|
Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted |