Type SecurityProfile
Type category Entity
Description This table describes details about securities with unique proprietary ID assigned by the S&P Global Ratings and its T&Cs .
Fields
Name Type Filters Description
key id string(100)* = The id field uniquely identifies the entity record.
collateralTypeCode string(20) Unique identifier of the collateral type that links to the spRatingCollateralType table. Note that a security can have more than one collateral type.
collateralTypeCodeDesc string(60) Description of the Collateral Type Code
couponRate decimal{23,8} The annual rate of interest payable on the instrument, in basis points.
couponTypeCode string(1) Single-character code used to denote a type of coupon payment method. This links to the spRatingCouponType reference table.
couponTypeCodeDesc string(100) Description of the Coupon type code
currencyCode string(3) Unique identifier of the currency that links to the spRatingCurrencyType table.
currentAmount decimal{23,8} Current amount(in millions) outstanding on a debt obligation (maturity or program).
datedDate dateTime The date when interest begins to accrue on a newly issued bond along with the timestamp; time zone is in Eastern Time (ET).
instrumentId long(10000000) 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(25) 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.
maturityDate dateTime Date on which the principal amount of a debt security becomes due and payable along with the timestamp; time zone is in Eastern Time (ET).
maturityYear long(10000) Year in which the principal amount of a debt security becomes due and payable.
originalAmount decimal{24,8} Original amount(in millions) outstanding at the instrument level for Programs.
privatePlacementCode string(20) Unique identifier of the private placement that links to the Private Placement Description.
privatePlacementDesc string(1000) Description of the Private Placement
securityId long(10000000) Unique and proprietary S&P Global Ratings identifier for each security.
17 rows of 17 total
API Open API Specification