| key |
id |
string(100)* |
= |
The id field uniquely identifies the entity record. |
|
currencyCode |
string(3) |
|
Unique identifier of the currency that links to the spRatingCurrencyType table. |
|
currentAmount |
decimal |
|
Current amount(in millions) outstanding at the instrument level for Instrument/Programs. |
|
instrumentDesc |
string(1050) |
|
Instrument name. For abbreviations used in the instrument name, see the Acronyms and Abbreviations spreadsheet. |
|
instrumentId |
long |
|
Unique and proprietary S&P Global Ratings identifier for each Instrument. This ID has a one-to-one relationship with and serves the same purpose as Source Instrument ID. |
|
instrumentSeries |
string(100) |
|
Descriptive data used to distinguish a specific series within an instrument's maturity schedule. Generally, a program series designation is listed in the Instrument Name field. |
|
instrumentTypeCode |
string(10) |
|
A unique code that identifies the characteristics of the instrument, such as IRBUNSECRD (Unsecured Industrial Revenue Bond). This links to the spRatingInstrumentType reference table. |
|
instrumentTypeDesc |
string(50) |
|
Description for abbriviation of IntrumentType. |
|
issuer |
long |
|
Entity Id for Issuer of Debt |
|
municipalCategoryCode |
string(10) |
|
Municipal Category Code that classifies the type of debt on a particular security, such as General Obligation or Revenue bonds. |
|
municipalCategoryCodeDesc |
string(50) |
|
Description of municipalCategoryCodeDesc |
|
municipalSecurityCode |
string(10) |
|
Code used to identify a type of Public Finance security (i.e. Toll Road, School District). |
|
municipalSecurityCodeDesc |
string(50) |
|
Description of municipal Security Code Desc |
|
originalAmount |
decimal |
|
Original amount(in millions) outstanding at the instrument level for Instrument/Programs. |
|
participant |
Participant[] |
|
This struct provides detailed information about the parties involved in a transaction, specifying the role each organization played and the effective date of that role. |
|
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). |
|
programTypeCode |
string(10) |
|
A unique code used to denote a type of program (i.e., Euro-commercial paper program). This links to the spRatingProgramType reference table. |
|
programTypeDesc |
string(50) |
|
Description for abbriviation of ProgramType. |
|
ratingDebtTypeCode |
string(10) |
|
Code that identifies the debt classification, such as SUBOR (subordinate), JRSUBOR (Junior subordinate), and PREFDSTK (Preferred Stock). This links to the spRatingDebtType reference table. |
|
ratingDebtTypeName |
string(60) |
|
Descriptive name for Ratings debt type. |
|
secondarySectorSubSector |
SectorSubSector[] |
|
Sector code refers to Secondary the division of the market by type of issuer |