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