Type DerivedRating
Type category Struct
Description This entity provides the derived ratings for an instrument.
Fields
Name Type Filters Description
ltInstrumentAvg string(50) The average long term Instrument rating type
ltInstrumentAvgNum long Average numbered value, rounded up for the long term Instrument level ratings
ltInstrumentBest string(50) The best numbered value for the long term Instrument level ratings
ltInstrumentBestNum long The best numbered value for the long term Instrument level ratings
ltInstrumentBestProvider string(50) The best provider name(s) for the long term Instrument level ratings
ltInstrumentCount long The count of all non-null long term Instrument level rating values
ltInstrumentFitch string(50) LT Instrument level rating from Fitch
ltInstrumentFitchDate date Effective date when LT Instrument level rating was provided by Fitch
ltInstrumentFitchNum long Fitch LT Instrument level rating converted to a number
ltInstrumentFitchSource string(50) Identifies whether the LT Instrument level rating was explicitly provided by Fitch or converted
ltInstrumentFitchType string(100) The matched LT Instrument level rating from Fitch
ltInstrumentLatestDate date The latest long term Instrument level rating from all the providers
ltInstrumentLatestNum string(100) The latest long term Instrument level rating from all the providers converted to a number
ltInstrumentLatestProvider string(50) Provider with the latest effective date
ltInstrumentLatestValue string(50) The latest long term Instrument level rating from all the providers
ltInstrumentMoody string(50) LT Instrument level rating from Moody's
ltInstrumentMoodyDate date Effective date when LT Instrument level rating was provided by Moody's
ltInstrumentMoodyNum long Moody's' LT Instrument level rating converted to a number
ltInstrumentMoodySource string(50) Identifies whether the LT Instrument level rating was explicitly provided by Moody's or converted
ltInstrumentMoodyType string(100) The matched LT instrument level rating from Moody's
ltInstrumentNormalizedFitch string(50) LT Instrument level normalized rating from Fitch.
ltInstrumentNormalizedMoody string(50) LT Instrument level normalized rating from Moody's.
ltInstrumentNormalizedSnp string(50) LT Instrument level normalized rating from S&P.
ltInstrumentSnp string(50) LT Instrument level rating from S&P
ltInstrumentSnpDate date Effective date when LT Instrument level rating was provided by S&P
ltInstrumentSnpNum long S&P's LT Instrument level rating converted to a number
ltInstrumentSnpSource string(50) Identifies whether the LT Instrument level rating was explicitly provided by S&P or converted
ltInstrumentSnpType string(100) The matched LT instrument level rating from S&P
ltInstrumentStddev decimal The standard deviation of all non-null long term Instrument level rating values
ratingCategory string(40) Defines the rating category for example IG, HY, Split and Unrated.
ratingTypeUsed string(100) Identifies whether the rating used was a long term or short term
ratingUsed string(50) The actual Rating that will be used
ratingUsedNum long The actual Rating that is used converted back to a numbered value
stInstrumentAvg string(50) The average short term Instrument rating type
stInstrumentAvgNum long Average numbered value, rounded up for the short term Instrument level ratings
stInstrumentBest string(50) The best numbered value for the short term Instrument level ratings
stInstrumentBestNum long The best numbered value for the short term Instrument level ratings
stInstrumentBestProvider string(50) The best provider name(s) for the short term Instrument level ratings
stInstrumentCount long The count of all non-null short term Instrument level rating values
stInstrumentFitch string(50) ST Instrument level rating from Fitch
stInstrumentFitchDate date Effective date when ST Instrument level rating was provided by Fitch
stInstrumentFitchNum long Fitch ST Instrument level rating converted to a number
stInstrumentFitchSource string(50) Identifies whether the ST Instrument level rating was explicitly provided by Fitch or converted
stInstrumentFitchType string(100) The matched ST Instrument level rating from Fitch
stInstrumentLatestDate date The latest short term Instrument level rating from all the providers
stInstrumentLatestNum string(100) The latest short term Instrument level rating from all the providers converted to a number
stInstrumentLatestProvider string(50) Provider with the latest effective date
stInstrumentLatestValue string(50) The latest short term Instrument level rating from all the providers
stInstrumentMoody string(50) ST Instrument level rating from Moody's
stInstrumentMoodyDate date Effective date when ST Instrument level rating was provided by Moody's
stInstrumentMoodyNum long Moody's' ST Instrument level rating converted to a number
stInstrumentMoodySource string(50) Identifies whether the ST Instrument level rating was explicitly provided by Moody's or converted
stInstrumentMoodyType string(100) The matched ST Instrument level rating from Moody's
stInstrumentNormalizedFitch string(50) ST Instrument level normalized rating from Fitch.
stInstrumentNormalizedMoody string(50) ST Instrument level normalized rating from Moody's.
stInstrumentNormalizedSnp string(50) ST Instrument level normalized rating from S&P.
stInstrumentSnp string(50) ST Instrument level rating from S&P
stInstrumentSnpDate date Effective date when ST Instrument level rating was provided by S&P
stInstrumentSnpNum long S&P's ST Instrument level rating converted to a number
stInstrumentSnpSource string(50) Identifies whether the ST Instrument level rating was explicitly provided by S&P or converted
stInstrumentSnpType string(100) The matched ST Instrument level rating from S&P
stInstrumentStddev decimal The standard deviation of all non-null short term Instrument level rating values
62 rows of 62 total