| key |
id |
string(100)* |
= |
A unique, system-generated identifier for each event record. Serves as the primary key for linking all related event information. This will be a combination of KeyDevId & recordEffectiveDate. |
|
announcementDateUTC |
dateTime |
|
The date and time of the event announcement, standardized to Coordinated Universal Time (UTC) for consistent cross-regional analysis. |
|
announcementLocalDate |
dateTime |
|
The date and time of the event announcement, recorded in the local timezone of the event. Use in conjunction with 'AnnouncementTimeZoneID'. |
|
dataEntryDateLocal |
dateTime |
|
The timestamp (in US Eastern Time) when the event was first recorded into the S&P Global system. Used for internal process tracking. |
|
dataEntryDateUTC |
dateTime |
|
The UTC timestamp of when the event was first entered into S&P Global's database. Crucial for data provenance and audit trails. |
|
eventHeadline |
string(500) |
|
A concise, summary title for the event, suitable for display in lists and notifications. |
|
eventOccurrenceDateUTC |
dateTime |
|
The primary date and time the event is scheduled to happen, standardized to UTC. This is the key date for calendars and financial modeling. |
|
eventSituationDetails |
string(65536) |
|
Provides supplementary context or background information about the event, offering more detail than the headline. |
|
keyDevId |
long(-2147483648,2147483647) |
|
A unique id representing a key development. |
|
lastModifiedDateLocal |
dateTime |
|
The timestamp (in US Eastern Time) of the most recent update to the event record by S&P Global. |
|
lastModifiedDateUTC |
dateTime |
|
The UTC timestamp of the most recent update to the event record. Ensures data freshness and supports compliance audits. |
|
recordEffectiveDate |
dateTime |
|
The timestamp indicating when this version of the event record became active in the system. Essential for data versioning and auditing. |
|
recordEndDate |
dateTime |
|
The timestamp indicating when this version of the event record was superseded by a new version. Used for tracking historical changes. |
| link |
timeZone |
TimeZone |
|
A numeric identifier that links to a reference table for time zone details, providing the context for 'AnnouncementLocalDate'. |