| 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. |