ScheduleDefinitionV3

V8 Message Definiton

The trading schedule that applies to a group of products: which holiday calendar it keeps, which rotation window sets its trade-date boundary, and which venue lists it. One row per (ticker source, product family, product group). MarketHoursV3 (9142) holds the per-date session times for the same three-part key. RESOLUTION: look up the product's exact scheduleGroup; if there is no row, fall back to scheduleGroup '*'. THREE SOURCES, ONE LADDER. Every source publishes its own row and the reader takes the best one present: Manual beats Loader beats Bridge; a deleted or pending-delete row is that source declining. A Manual row that names a corrected HolidayCalendarV3 (9012) content key is how a late announcement lands without displacing the loader's row; withdrawing it falls back to the loader. An empty key means the group keeps the compiled default calendar for its source.

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
tickerSrc	enum - TickerSrc	PRI	'None'	the products ticker source
tickerClass	enum - TickerClass	PRI	'None'	product family Ticker cash CCode futures Root options
scheduleGroup	VARCHAR(6)	PRI	''	product group within the source covers every group not named
v3Source	enum - V3Source	PRI	'None'	which source wrote this row the reader takes the highest present
description	VARCHAR(48)		''	human label CBOT grains NMS equities
calendarKey_ct	enum - ContentKeyType		'None'	HolidayCalendarV3 9012 by content key None the compiled default for the source
calendarKey_id	VARCHAR(37)		''	HolidayCalendarV3 9012 by content key None the compiled default for the source
tradingPeriod	enum - TradingPeriod		'None'	TradingPeriodDefinitionV3 9015 the rotation window
mic	VARCHAR(4)		''	VenueDefinitionV3 9027 empty when no single venue lists the group
statusFlag	enum - TkStatusFlag		'None'	Active or Delisted A delisted row stays resolvable and is never deleted
pendingDelete	enum - YesNo		'None'	Yes queued for removal stop resolving against this row
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'	when this row was last written

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
tickerSrc	1
tickerClass	2
scheduleGroup	3
v3Source	4

SELECT TABLE EXAMPLE QUERY

SELECT *
FROM `SRReference`.`MsgScheduleDefinitionV3`
WHERE 
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX','CRCY','CMDY','DTI','SOVN','SR_US','SR_EU','SR_AP','SR_UK','USD','EUR','GBP','CHF','JPY','CAD','AUD','HKD','KRW','INR','SGD','TWD','CNY','CNH','BRL','MXN','ZAR','SEK','NOK','DKK','PLN','ILS','TRY','NZD','THB','MYR','IDR','PHP','CZK','HUF','SAR','AED','CLP','COP') */ 
    `tickerSrc` = 'NONE'
  AND
    /* Replace with a ENUM('None','Ticker','CCode','Root') */ 
    `tickerClass` = 'NONE'
  AND
    /* Replace with a VARCHAR(6) */ 
    `scheduleGroup` = 'Example_scheduleGroup'
  AND
    /* Replace with a ENUM('None','HardCode','Bridge','Loader','Manual') */ 
    `v3Source` = 'NONE';

Doc Columns Query

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