Type IssuerAssesments
Type category Entity
Description This table contains information related to issuer credit assessments, including servicer evaluations, and other related metrics as performed by the S&P Global Ratings.
Timeseries key id, assessmentDateavailable from 1999-04-09
Fields
Name Type Filters Description
key id string(100)* = The id field uniquely identifies the entity record.
timeline assessmentDate dateTime =< >= Date the rating was assigned; time zone is in Eastern Time (ET) along with the timestamp.
assessmentActionWord string(50) Indicates if the rating action was disseminated through the feed due to a New Rating, Upgrade, or Downgrade rating.
assessmentDebtTypeCode string(10) Unique identifier of the rating organization debt type. Note that this only applies to entity ratings, and is Null for instrument and security ratings.
assessmentDebtTypeName string(60) Descriptive name for ratings debt type code.
assessmentSymbolValue string(20) Combines the rating symbol, rating qualifier, regulatory qualifier, and rating suffixes together in one field.
assessmentTypeCode string(10) Code identifying the type of ratings.
assessmentTypeName string(60) Descriptive name for ratings type.
companyId long Unique and proprietary S&P Global Ratings identifier for each organization (issuer).
creditWatch string(100) CreditWatch highlights S&P Global Ratings' opinion regarding the potential direction of a short-term or long-term rating. This field provides the current CreditWatch value.
creditWatchDate dateTime This field provides the date for when the Current CreditWatch value was assigned; time zone is in Eastern Time (ET along with the timestamp).
currentAssessmentSymbolValue string(50) This field provides the current rating for an entity, program, or security.
currentRatingIndicator long Indicator to denote current assessment record.
cwChangeFlag boolean This field flags when there is an update which reflects a change in the CreditWatch as it relates to the current rating.
lastReviewDate dateTime Last Review Date(Eastern Time (ET) timezone) indicates the date an Issue or Issuer Credit Rating was last formally reviewed within a twelve-month period or when a credit rating action was last published. For certain dependent instruments, the Last Review Date will only be updated in the event of a Credit Rating change of the linked organization along with the timestamp.
olChangeFlag boolean This field flags when there is an update which reflects a change in the Outlook as it relates to the current rating.
outlook string(100) An S&P Global Ratings Outlook assesses the potential direction of a long-term credit rating over the intermediate term (typically six months to two years). In determining a rating Outlook, consideration is given to any changes in the economic and/or fundamental business conditions. An Outlook is not necessarily a precursor of a rating change or future CreditWatch action. This field provides the current Outlook value.
outlookDate dateTime This field provides the date for when the Current Outlook value was assigned; time zone is in Eastern Time (ET) along with the timestamp.
priorAssessmentDate dateTime Date corresponding with the prior rating symbol value in spRatingData table or date corresponding with the prior assessment symbol value in spAssessmentData table along with the timestamp; time zone is in Eastern Time (ET).
priorAssessmentSymbolValue string(50) An S&P Global Ratings credit rating is a forward-looking opinion about the creditworthiness of an obligor. This field provides the most prior rating for an entity, program, or security.
priorCreditWatch string(100) CreditWatch highlights S&P Global Ratings' opinion regarding the potential direction of a short-term or long-term rating. This field provides the prior CreditWatch value.
priorCreditWatchDate dateTime Date corresponding with the prior CreditWatch value in spRatingData table or spAssessmentData table along with the timestamp; time zone is in Eastern Time (ET).
priorOutlook string(100) An S&P Global Ratings Outlook assesses the potential direction of a long-term credit rating over the intermediate term (typically six months to two years). In determining a rating Outlook, consideration is given to any changes in the economic and/or fundamental business conditions. An Outlook is not necessarily a precursor of a rating change or future CreditWatch action. This field provides the prior Outlook value.
priorOutlookDate dateTime Date corresponding with the prior Outlook value in spRatingData table or spAssessmentData table along with the timestamp; time zone is in Eastern Time (ET).
ratingDetailId long S&P unique identifier for a rating record. Uniqueness is determined using a combination of symbol value, org debt type, rating type, and rating/CreditWatch/Outlook date.
ratingQualifier string(30) The qualifier subscript for the rating, such as L, pi, etc. A rating may or may not have a qualifier. For a list of qualifiers and their meaning, see S&P Global Ratings' ratings definitions on www.standardandpoors.com.
regulatoryIndicator string(300) This field provides identifiers used for regulatory related purposes. For a list of regulatory identifiers, see section VII. OTHER IDENTIFIERS in S&P Global Ratings' ratings definitions on www.standardandpoors.com
regulatoryQualifier string(300) This field provides identifiers used for regulatory related purposes. For a list of regulatory qualifier, see section VII. OTHER IDENTIFIERS in S&P Global Ratings' ratings definitions on www.standardandpoors.com
28 rows of 28 total
API Open API Specification