Type InstrumentProfile
Type category Entity
Description This table provides detailed information linked to unique proprietary ID assigned by the S&P Global Ratings to describe each program.
Fields
Name Type Filters Description
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
21 rows of 21 total
API Open API Specification