MaterialEventOccurrenceV3

V8 Message Definiton

one dated instance of a series. The pkey is DELIBERATELY date-free: the date is the field that MOVES (estimate -> published), so identity survives the Forecast -> Announced migration and a firmed-up date is a state change, never a delete/insert

METADATA

Attribute	Value
Topic	9000-product-def-authority
MLink Token	ClientLive
Product	SRReference
accessType	SELECT
MLink Endpoint	MLink-Live

Table Definition

Field	Type	Key	Default Value	Comment
seriesKey	VARCHAR(24)	PRI	''	the event series this occurrence belongs to MaterialEventSeriesV3 9042
occurrenceId	VARCHAR(16)	PRI	''	the series own period label 2026Q4 202609 MTG202607 NEVER the date
eventStatus	enum - MaterialEventStatus		'None'	Forecast Announced Occurred Cancelled LITE eventDefsts timingkind
eventDate	DATE		'1900-01-01'	Forecast the ESTIMATE Announced the published date LITE eventDefsts timingdate
eventTime	INT		0	milliseconds since midnight in the series tz zero time not yet known LITE eventDefsts timingtimeET
windowDays	INT		0	Forecast error bars days around eventDate zero exact LITE eventDefsts timingwindowDays
likelihood	DOUBLE		0	Forecast probability it occurs in the window 10 once Announced LITE eventDefsts timinglikelihood
announceDate	DATE		'1900-01-01'	when the source published the migration date empty while Forecast
detailNote	TINYTEXT		''	10Y New 91282CRF0 Decision SEP press conference LITE eventDefsts detail
pendingDelete	enum - YesNo		'None'	Yes queued for removal stop resolving against this row
v3Source	enum - V3Source		'None'	Bridge projected from a legacy record Loader written natively None reads as Loader
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'	when this row was last written

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
seriesKey	1
occurrenceId	2

SELECT TABLE EXAMPLE QUERY

SELECT *
FROM `SRReference`.`MsgMaterialEventOccurrenceV3`
WHERE 
    /* Replace with a VARCHAR(24) */ 
    `seriesKey` = 'Example_seriesKey'
  AND
    /* Replace with a VARCHAR(16) */ 
    `occurrenceId` = 'Example_occurrenceId';

Doc Columns Query

SELECT * FROM SRReference.doccolumns WHERE TABLE_NAME='MaterialEventOccurrenceV3' ORDER BY ordinal_position ASC;