Skip to main content
Version: Staging

SpdrStripeTrigger

V8 Message Definiton

SpdrStripeTrigger records are used to allocate sweep risk and trigger cross stripe release of parent orders submitted with startType=WaitTrigger. These records are published by a SR Strategy Server if/when a SpdrReleaseWaitTrigger message is received.

METADATA

AttributeValue
Topic3985-parent-orders
MLink TokenSystemData
ProductSRTrade
accessTypeSELECT

Table Definition

FieldTypeKeyDefault ValueComment
accntVARCHAR(16)PRI''
triggerGroupIdBIGINTPRI0
clientFirmVARCHAR(16)PRI''SR client firm
netTimestampBIGINT0
timestampDATETIME(6)'1900-01-01 00:00:00.000000'

PRIMARY KEY DEFINITION (Unique)

FieldSequence
accnt1
triggerGroupId2
clientFirm3

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRTrade`.`MsgSRStripeTrigger` (
`accnt` VARCHAR(16) NOT NULL DEFAULT '',
`triggerGroupId` BIGINT NOT NULL DEFAULT 0,
`clientFirm` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'SR client firm',
`netTimestamp` BIGINT NOT NULL DEFAULT 0,
`timestamp` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000',
PRIMARY KEY USING HASH (`accnt`,`triggerGroupId`,`clientFirm`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='SpdrStripeTrigger records are used to allocate sweep risk and trigger cross stripe release of parent orders submitted with startType=WaitTrigger. These records are published by a SR Strategy Server if/when a SpdrReleaseWaitTrigger message is received.';

SELECT TABLE EXAMPLE QUERY

SELECT
`accnt`,
`triggerGroupId`,
`clientFirm`,
`netTimestamp`,
`timestamp`
FROM `SRTrade`.`MsgSRStripeTrigger`
WHERE
/* Replace with a VARCHAR(16) */
`accnt` = 'Example_accnt'
AND
/* Replace with a BIGINT */
`triggerGroupId` = 1234567890
AND
/* Replace with a VARCHAR(16) */
`clientFirm` = 'Example_clientFirm';

Doc Columns Query

SELECT * FROM SRTrade.doccolumns WHERE TABLE_NAME='SpdrStripeTrigger' ORDER BY ordinal_position ASC;