| key |
id |
string(100)* |
= |
The id field uniquely identifies the entity record. |
|
analystId |
RatingAnalyst[] |
|
Unique and proprietary S&P Global Ratings identifier for a Rating Analyst. |
|
cins |
string(10)[200] |
|
CUSIP International Numbering System identifier assigned by the CUSIP Global Services. |
|
ciqCompanyId |
long(10000000000) |
|
The value represents the unique identifier for a CIQ Compant ID |
|
companyId |
long(1000000) |
|
Unique and proprietary S&P Global Ratings identifier for each organization (issuer). |
|
countryCode |
string(3) |
|
The 3-digit ISO country code where the entity domicile of incorporation is located; links to the spRatingCountry table. |
|
countryCurrencyCode |
string(3) |
|
Currency Code of the Issuer's country. |
|
countryName |
string |
|
Name of the issuer's country. |
|
currencyName |
string(60) |
|
Name of the currency represented by 3 letter currency code. |
|
cusip |
string(6)[200] |
|
(CUSIP) Committee for Uniform Security Identification Procedures identifier assigned by CUSIP Global Services. |
|
entityLegalName |
string(450) |
|
The most recent legal entity name. |
|
entityName |
string(450) |
|
The most recent published entity name. |
|
entityShortName |
string(300) |
|
The short entity name. |
|
giFlag |
boolean |
|
Companies under Global Issuers |
|
gics |
string(8)[200] |
|
Identifier based on GICS which is a four-tiered, hierarchical industry classification system. The four tiers are: Sectors, Industry Groups, Industries and Sub-Industries. |
|
isActive |
boolean |
|
isActive |
|
keyInstn |
long(1000000000) |
|
The value represents the unique identifier for a MI company Id. |
|
lei |
string(20)[500] |
|
Legal Entity Identifier (LEI) code for the issuer. |
|
naic |
string(10)[200] |
|
North American Industry Classification System. This links to the spRatingNaicsCode reference table. |
|
parentEntityId |
long(1000000) |
|
The S&P Global Ratings Entity ID for the Parent Company of a Given Entity. |
|
parentEntityLegalName |
string(450) |
|
The latest published legal name of parent company. |
|
pfFlag |
boolean |
|
Companies under Public Finance |
|
primarySectorSubSector |
SectorSubSector[] |
|
Sector code refers to Primary the division of the market by type of issuer, for example, Corporates, Structured Finance, and Public Finance. Subsector code refers to the subdivision of the Corporates and Structured Finance sectors. Subsectors categorize the sector. For example, included under the Structured Finance sector, are the following subsectors: Asset-Backed Securities (ABS), Residential Mortgage-Backed Securities (RMBS), and Commercial Mortgage-Backed Securities (CMBS). |
|
region |
RegionMapping[] |
|
The region code where the entity domicile of incorporation is located; links to the spRatingRegion reference table. |
|
secondarySectorSubSector |
SectorSubSector[] |
|
Sector code refers to secondary the division of the market by type of issuer |
|
sfFlag |
boolean |
|
Companies under Structured Finance |
|
sic |
string(4)[200] |
|
Standard Industrial Classification (SIC) codes are four digit numerical codes assigned by the U.S. government that categorize the industries to which companies belong, while also organizing industries by their business activities. |
|
stateCode |
string(2) |
|
The state code for the entity primary headquarters; links to the spRatingState table. Note that the state is only available for entities in the U.S. and Canada. |
|
stateName |
string |
|
Name of the state code. |
|
ticker |
ExchangeTicker[] |
|
A ticker is a symbol, a unique combination of letters and numbers that represent a particular stock or security listed on an exchange. Stock exchange that the business is traded on. |
|
ultimateParentEntityId |
long(1000000) |
|
The S&P Global Ratings Entity ID for the Ultimate Parent Company of a Given Entity. |
|
ultimateParentEntityLegalName |
string(450) |
|
The latest published legal name of ultimate parent company. |