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 Fitchs LT Instrument level rating converted to a number
ltInstrumentFitchSource string(50) Identifier 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 Moodys
ltInstrumentMoodyDate date Effective date when LT Instrument level rating was provided by Moodys
ltInstrumentMoodyNum long Moodys' LT Instrument level rating converted to a number
ltInstrumentMoodySource string(50) Identifier whether the LT Instrument level rating was explicitly provided by Moodys or converted
ltInstrumentMoodyType string(100) The matched LT instrument level rating from Moodys
ltInstrumentSnp string(50) LT Instrument level rating from SNP
ltInstrumentSnpDate date Effective date when LT Instrument level rating was provided by SNP
ltInstrumentSnpNum long SNP's LT Instrument level rating converted to a number
ltInstrumentSnpSource string(50) Identifier whether the ST Instrument level rating was explicitly provided by SNP or converted
ltInstrumentSnpType string(100) The matched LT instrument level rating from SNP
ltInstrumentStddev decimal The standard deviation of all non-null long term Instrument level rating values
ratingCategory string(40) Field define the rating category for e.g. 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 Fitchs ST Instrument level rating converted to a number
stInstrumentFitchSource string(50) Identifier 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 Moodys
stInstrumentMoodyDate date Effective date when ST Instrument level rating was provided by Moodys
stInstrumentMoodyNum long Moodys' ST Instrument level rating converted to a number
stInstrumentMoodySource string(50) Identifier whether the ST Instrument level rating was explicitly provided by Moodys or converted
stInstrumentMoodyType string(100) The matched ST Instrument level rating from Moodys
stInstrumentSnp string(50) ST Instrument level rating from SNP
stInstrumentSnpDate date Effective date when ST Instrument level rating was provided by SNP
stInstrumentSnpNum long SNP's ST Instrument level rating converted to a number
stInstrumentSnpSource string(50) Identifier whether the ST Instrument level rating was explicitly provided by SNP or converted
stInstrumentSnpType string(100) The matched ST Instrument level rating from SNP
stInstrumentStddev decimal The standard deviation of all non-null short term Instrument level rating values
56 rows of 56 total