| key |
id |
string(50)* |
= |
Unique identifier for the source entity |
| timeline |
asOf |
date* |
=< >= |
Date to which company ref data belongs. (Date in the file name to be used for the ongoing data set. For correction files the ExtractionDate value from within the file to be used). |
| query_stats |
notificationDate |
date* |
|
Date from the filename (For both ongoing as well as correction data sets). |
| link |
batch |
Batch* |
= |
The Batch in which the entity is sent. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the entity is sent. |
|
bloombergGlobalCompositeId |
string(12) |
|
Twelve character, alphanumeric identifier. The first 2 characters are upper-case consonants (including "Y"), the third character is the upper-case "G", characters 4 -11 are any upper-case consonant (including "Y") or integer between 0 and 9, and the last character is a check-digit. The Composite level of assignment is provided in cases where there are multiple trading venues for the instrument within a single country or market. The Composite Financial Instrument Global Identifier (FIGI) enables users to link multiple FIGIs at the trading venue-level within the same country or market in order to obtain an aggregated view for that instrument within that country or market. (COMPOSITE_ID_BB_GLOBAL) |
|
bloombergGlobalId |
string(12) |
|
Twelve character, alphanumeric identifier. The first 2 characters are upper-case consonants (including "Y"), the third character is the upper-case "G", characters 4 -11 are any upper-case consonant (including "Y") or integer between 0 and 9, and the last character is a check-digit. An identifier is assigned to instruments of all asset classes, is unique to an individual instrument and once issued will not change for an instrument. For equity instruments an identifier is issued per instrument per trading venue. (ID_BB_GLOBAL) |
|
bloombergShareClassBbgid |
string(12) |
|
Twelve character, alphanumeric identifier. The first 2 characters are upper-case consonants (including "Y"), the third character is the upper-case "G", characters 4 -11 are any upper-case consonant (including "Y") or integer between 0 and 9, and the last character is a check-digit. A Share Class level Financial Instrument Global Identifier is assigned to an instrument that is traded in more than one country. This enables users to link multiple Composite FIGIs for the same instrument in order to obtain an aggregated view for that instrument across all countries globally. (ID_BB_GLOBAL_SHARE_CLASS_LEVEL) |
|
bloombergTicker |
string(30) |
|
Bloomberg ticker code. Ticker is a specific identifier for a financial instrument that reflects common usage. Tickers are not, however, unique to specific exchanges or specific pricing sources. Tickers may change in conjunction with Corporate Actions. |
|
bloombergTickerExchange |
string(20) |
|
Bloomberg ticker and exchange code |
|
bloombergUniqueId |
string(25) |
|
A legacy identifier assigned to all instruments. The construction and length of this identifier is different across asset classes. This identifier can also change as a result of corporate actions. (ID_BB_UNIQUE) |
|
companyType |
string(7) |
|
Company type field indicating whether the company is public or private |
|
complianceBase |
boolean |
|
Large, medium, and small-cap issuers of equity securities (and analogous fixed-income issues) in emerging and developing markets. |
|
complianceControversiesCategories4Or5 |
boolean |
|
All issuers showing at least one Category 4 or Category 5 Controversy, based on our review of the Compliance Universe and portfolio screenings. |
|
complianceGlobalStandardsScreeningWatchlistOrNonCompliant |
boolean |
|
All issuers with Non-compliant or Watchlist status for Global Standards Screening, based on our review of the Global Compliance Universe and portfolio screenings |
|
complianceNordics |
boolean |
|
Large and medium and small market cap investable issuers in Nordic Countries. |
|
complianceProductInvolvementInvolved |
boolean |
|
All issuers showing involvement in at least one area of Product Involvement, based on our review of the Compliance Universe and portfolio screenings |
|
complianceWeaponsInvolved |
boolean |
|
All issuers showing direct or indirect involvement in Controversial Weapons, based on our review of Global Compliance Universe and survey of global companies. |
|
country |
string(50) |
|
Country of domicile |
|
countryCode |
string(3) |
|
Three-letter country codes defined in ISO 3166-1 |
|
countryRatings |
string(100) |
|
Country Ratings universe contains the 172 countries covered by the Country Product offerings. |
|
cusip |
string(9) |
|
CUSIP market identifier code |
|
engagement360ReportingUniverse |
string(100) |
|
All issuers with a reportable Engagement case, based on our screening of the Global Compliance Universe and historical cases with activity. |
| filter_list |
entityId |
long* |
= |
ID to uniquely identify an entity |
| filter_list |
entityName |
string(200) |
= |
Entity name |
|
entityType |
string(8) |
|
Field indicating whether a company is a research entity or coverage entity |
|
exchange |
string(10) |
|
Exchange code |
|
exchangeTicker |
string(25) |
|
Combination of exchange and ticker code |
|
extractionDate |
date |
|
Extraction date field provides current date value at time of export. |
|
factsetEntityId |
string(100) |
|
Factset CompanyId (FSYM_ENTITY_ID). |
|
factsetSecurityId |
string(100) |
|
Factset SecurityId (FSYM_ID). |
|
globalComplianceBase |
boolean |
|
Large, medium- small-, and micro-cap issuers of equity securities (and analogous fixed-income issues) in emerging and developing markets. |
|
globalStandardsEngagementReporting |
boolean |
|
All issuers with a reportable Global Standards Engagement case, based on our screening of the Global Compliance Universe and historical cases with activity. |
|
incomeGroup |
string(50) |
|
The World Bank divides the world's economies into four income groups: high, upper-middle, lower-middle, and low. The income classification is based on a measure of national income per person, or GNI per capita, calculated using the Atlas method. |
|
industryGroup |
string(50) |
|
Name of the industry group that the research entity is classified into. |
|
isin |
string(12) |
|
ISIN market identifier code |
|
lastModifiedDateTime |
dateTime |
|
Date the record was uploaded in N6 system. |
|
legalEntityIdentifier |
string(20) |
|
Legal entity identifier (LEI) is a 20-character, alpha-numeric code, to uniquely identify legally distinct entities that engage in financial transactions |
|
marketCap |
decimal |
|
Market cap of the issuer in mn USD. |
|
materialRiskEngagementReporting |
boolean |
|
All issuers with a reportable Material Engagement case, based on our screening of the Ratings Universe and historical cases with activity. |
|
ratings |
boolean |
|
Large and medium market cap investable issuers in emerging and developed markets. Part of Standard RATINGS universe, as determined based on index constituents. |
|
ratingsAmericaDeveloped |
boolean |
|
Large and medium market cap issuers listed in North America. Part of Ratings universe, as determined based on index constituents. |
|
ratingsAmericaEmerging |
boolean |
|
Large and medium market cap issuers listed in South America. Part of Ratings universe. |
|
ratingsAmericaFull |
boolean |
|
Large and medium market cap issuers listed in North and South America. Part of Ratings universe, as determined based on index constituents. |
|
ratingsApacDeveloped |
boolean |
|
Large and medium market cap issuers listed in Asia-Pacific developed markets. Part of Ratings universe, as determined based on index constituents. |
|
ratingsApacEmerging |
boolean |
|
Large and medium market cap issuers listed in Asia-Pacific emerging markets. Part of Ratings universe. |
|
ratingsApacFull |
boolean |
|
Large and medium market cap issuers listed in Asia-Pacific. Part of Ratings universe, as determined based on index constituents. |
|
ratingsCanada |
boolean |
|
Large and medium market cap issuers listed in Canada. Part of Ratings universe, as determined based on index constituents. |
|
ratingsEmeaDeveloped |
boolean |
|
Large and medium market cap issuers listed in Europe and Middle East (developed). Part of Ratings universe, as determined based on index constituents. |
|
ratingsEmeaEmerging |
boolean |
|
Large and medium market cap issuers listed in Middle East (emerging) and Africa. Part of Ratings universe. |
|
ratingsEmeaFull |
boolean |
|
Large and medium market cap issuers listed in Europe, Middle East and Africa. Part of Ratings universe, as determined based on index constituents. |
|
ratingsGlobalDeveloped |
boolean |
|
Large and medium market cap investable issuers in developed markets. Part of Ratings universe, as determined based on index constituents. |
|
ratingsGlobalEmerging |
boolean |
|
Large and medium market cap investable issuers in emerging markets. Part of Ratings universe, as determined based on index constituents. |
|
ratingsJapan |
boolean |
|
Large and medium market cap issuers listed in Japan. Part of Ratings universe, as determined based on index constituents. |
|
ratingsLargeCap |
boolean |
|
Large market cap investable issuers in emerging and developed markets. Part of Ratings universe, as determined based on index constituents. |
|
ratingsNordics |
boolean |
|
Large and medium market cap issuers listed in Nordics. Part of Ratings universe, as determined based on index constituents. |
|
ratingsOceania |
boolean |
|
Large and medium market cap issuers listed in Oceania (curently Australia and New Zealand). Part of Ratings universe, as determined based on index constituents. |
|
ratingsPLUS |
boolean |
|
Large and medium and small market cap investable issuers in emerging and developed markets. |
|
ratingsPLUSAmericaDeveloped |
boolean |
|
Large and medium and small market cap issuers listed in North America. |
|
ratingsPLUSAmericaEmerging |
boolean |
|
Large and medium and small market cap issuers listed in South America. |
|
ratingsPLUSAmericaFull |
boolean |
|
Large and medium and small market cap issuers listed in North and South America. |
|
ratingsPLUSApacDeveloped |
boolean |
|
Large and medium and small market cap issuers listed in Asia-Pacific developed markets. |
|
ratingsPLUSApacEmerging |
boolean |
|
Large and medium and small market cap issuers listed in Asia-Pacific emerging markets. |
|
ratingsPLUSApacFull |
boolean |
|
Large and medium and small market cap issuers listed in Asia-Pacific. |
|
ratingsPLUSCanada |
boolean |
|
Large and medium and small market cap issuers listed in Canada. |
|
ratingsPLUSEmeaDeveloped |
boolean |
|
Large and medium and small market cap issuers listed in Europe and Middle East (developed). |
|
ratingsPLUSEmeaEmerging |
boolean |
|
Large and medium and small market cap issuers listed in Middle East (emerging) and Africa. |
|
ratingsPLUSEmeaFull |
boolean |
|
Large and medium and small market cap issuers listed in Europe, Middle East and Africa. |
|
ratingsPLUSGlobalDeveloped |
boolean |
|
Large and medium and small market cap investable issuers in developed markets. |
|
ratingsPLUSGlobalEmerging |
boolean |
|
Large and medium and small market cap investable issuers in emerging markets. |
|
ratingsPLUSJapan |
boolean |
|
Large and medium and small market cap issuers listed in Japan. |
|
ratingsPLUSNordics |
boolean |
|
Large and medium and small market cap issuers listed in Nordics. |
|
ratingsPLUSOceania |
boolean |
|
Large and medium and small market cap issuers listed in Oceania (currenty Australia and New Zealand). |
|
ratingsPLUSSwitzerland |
boolean |
|
Large and medium and small market cap issuers listed in Switzerland. |
|
ratingsPLUSUk |
boolean |
|
Large and medium and small market cap issuers listed in the United Kingdom. |
|
ratingsSwitzerland |
boolean |
|
Large and medium market cap issuers listed in Switzerland. Part of Ratings universe, as determined based on index constituents. |
|
ratingsUK |
boolean |
|
Large and medium market cap issuers listed in the United Kingdom. Part of Ratings universe, as determined based on index constituents. |
|
region |
string(100) |
|
Region of domicile |
|
researchEntityId |
long |
|
CompanyId of the research entity that the company is linked to. In case the company is a research entity, the research entity id will be equal to the companyid for the company. |
|
researchEntityName |
string(200) |
|
Company name of the research entity that the company is linked to. In case the company is a research entity, the Research Entity Name will be equal to the CompanyName for the company. |
|
researchType |
string(13) |
|
Field indicating the research type |
|
researchTypeRr |
string(13) |
|
Field indicating the research type |
|
sector |
string(50) |
|
Name of the sector that the research entity is classified into. |
|
sedol |
string(7) |
|
SEDOL market identifier code |
|
sovereignRegion |
string(100) |
|
Regions defined by World Bank used for sovereigns. |
|
subindustry |
string(100) |
|
Name of the subindustry that the research entity is classified into. |
|
sustainalyticsGlobalESGUniverse |
string(100) |
|
Large, medium, and small-cap issuers of equity securities (and analogous fixed-income issuers) in emerging and developing markets, excluding ineligible entities. |
|
ticker |
string(50) |
|
Ticker code |
|
usSubSovereignUniverse |
string(100) |
|
Governmental unit issuers of general obligation debt securities, where the issuer is below the national or federal level. The universe is comprised of states (plus the District of Columbia) plus cities, counties and school districts that meet a minimum population threshold. |