| key |
id |
string(36)* |
= |
The primary key, represented as a globally unique identifier (GUID), uniquely identifying each topic tag record for a company-industry relationship. |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The batchRun that provided the data. |
|
companyId |
long(-2147483648,2147483647)* |
|
The S&P Cap IQ Company ID for the company to which this topic tag is assigned. This links to the company foundation data. |
| link |
companyIndustryStatus |
CompanyIndustryStatus |
|
Reference to the CompanyIndustryStatus entity, indicating the temporal validity of the industry classification. |
| link |
companyIndustryTopicTagInputSource |
CompanyIndustryTopicTagInputSource |
|
Reference to the CompanyIndustryTopicTagInputSource entity, identifying the source system or methodology used to generate or assign this topic tag. |
|
companyIndustryTopicTagRank |
long(0,255) |
|
The relative ranking of this topic tag among all tags assigned to the company, with lower numbers (1, 2, 3...) indicating higher priority or relevance. Rank 1 represents the most relevant tag. |
|
companyIndustryTopicTagScore |
decimal{5,4} |
|
The confidence score assigned to the topic tag for the company, ranging from 0 to 1, indicating the strength and relevance of the industry relationship. Higher scores indicate a stronger association. |
| link |
industryRelationshipLevel |
IndustryRelationshipLevel |
|
Reference to the IndustryRelationshipLevel entity, defining the strength of association between the company and the topic tag. |
| link |
industryTopicTagSourced |
IndustryTopicTagSourced |
|
Reference to the sourced industry topic tag entity, providing the original classification from various namespace sources before standardization. |
|
isDeleted |
boolean* |
|
Indicates that this record has been logically deleted and should no longer be considered active. |
|
keyCompanyIndustryTopicTag |
string(36)* |
|
The legacy primary key, represented as a globally unique identifier (GUID), uniquely identifying each topic tag record for a company-industry relationship. |
|
keyInstn |
long(-2147483648,2147483647) |
|
The S&P Cap IQ unique institution identifier. This is the domain-specific identifier that maps to the S&P Cap IQ Company ID, linking to institutional data. |
|
lastModifiedDate |
dateTime* |
|
The date and time when this record was last updated or modified in the source system. |
|
topicTagAddedManually |
boolean* |
|
Indicates whether the topic tag was manually assigned by a data analyst (true) or automatically generated by a system or model (false). |