SRParentReviewRequest

V8 Message Definiton

SpdrParentReviewRequest records created when a parent order is submitted with StageType=StageReview. These records indicate that an external review of the parent order has been requested.

METADATA

Attribute	Value
Topic	4195-parent-review
MLink Token	ClientTrading
Product	SRTrade
accessType	SELECT
MLink Endpoint	MLink-Order

Table Definition

Field	Type	Key	Default Value	Comment
parentNumber	CHAR(19)	PRI	'0000-0000-0000-0000'	SPDR order number
sysEnvironment	enum - SysEnvironment		'None'	original source sys environment Stable Current etc
runStatus	enum - RunStatus		'None'	original source run status ProdBeta
parentShape	enum - SpdrOrderShape		'None'	Parent Shape Single Cross MLeg MLegCross
altOrderId	VARCHAR(24)		''	alternate order ID usually clOrdId from client
altPrevOrderId	VARCHAR(24)		''	alternate prev order ID usually origClOrdId from client during cxlreplace
altAccnt	VARCHAR(32)		''	alternate client assigned long account string optional used to map between client and SR account strings
altUserName	VARCHAR(24)		''	alternate client assigned user name optional used to map between client and SR account strings
secKey_at	enum - AssetType		'None'	Composite Security Key
secKey_ts	enum - TickerSrc		'None'	Composite Security Key
secKey_tk	VARCHAR(12)		''	Composite Security Key
secKey_yr	SMALLINT UNSIGNED		0	Composite Security Key
secKey_mn	TINYINT UNSIGNED		0	Composite Security Key
secKey_dy	TINYINT UNSIGNED		0	Composite Security Key
secKey_xx	DOUBLE		0	Composite Security Key
secKey_cp	enum - CallPut		'Call'	Composite Security Key
secType	enum - SpdrKeyType		'None'	Security Type Stock Future Option
securityDesc	TINYTEXT		''	additional security description
accnt	VARCHAR(16)		''	SR trading account
clientFirm	VARCHAR(16)		''	SR client firm
spdrSource	enum - SpdrSource		'None'	from original parent order
groupingCode	CHAR(19)		'0000-0000-0000-0000'	from original parent order
strategy	VARCHAR(36)		''	clientsupplied strategy stringvisible on SpiderRock GUI tools and other order reports
userName	VARCHAR(24)		''	name of the user entering the order
orderSide	enum - BuySell		'None'
orderSize	INT		0	maximum fill size contracts
firmType	enum - FirmType		'None'	used to override firmType in account config
orderCapacity	enum - OrderCapacity		'None'
positionType	enum - PositionType		'None'
ssaleFlag	enum - ShortSaleFlag		'None'	used to determine stock autohedge flags
locateQuan	INT		0	available locate quantity if selling short
locateFirm	VARCHAR(6)		''	firm granting the locate also locate firm used on street FIX orders
locatePool	VARCHAR(16)		''	locate pool firm granting the locate
noCrossGroup	VARCHAR(16)		''
exchTraderId	VARCHAR(16)		''
largeTraderId	VARCHAR(16)		''
tradingLocation	VARCHAR(16)		''
hedgeSecKey_at	enum - AssetType		'None'
hedgeSecKey_ts	enum - TickerSrc		'None'
hedgeSecKey_tk	VARCHAR(12)		''
hedgeSecKey_yr	SMALLINT UNSIGNED		0
hedgeSecKey_mn	TINYINT UNSIGNED		0
hedgeSecKey_dy	TINYINT UNSIGNED		0
hedgeSecType	enum - SpdrKeyType		'None'
hedgeUnits	FLOAT		0
userData1	TINYTEXT		''	client supplied data field passes through to parent and child executions and reports as well as FIX drops
userData2	TINYTEXT		''	client supplied data field passes through to parent and child executions and reports as well as FIX drops
childData	TINYTEXT		''	client supplied data field passes through to down stream child orders
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'
OrderLegsList	JSON		'JSON_ARRAY()'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
parentNumber	1

JSON Block (OrderLegsList)

Field	Type	Comment
ticker	enum - ticker	stock ticker
stockSide	enum - BuySell	Buy Sell None
stockShares	enum - stockShares	number of shares included zero if none
stockLegId	enum - stockLegId	SR stock leg ID
altStkLegId	enum - altStkLegId	client stock leg ID usually from a FIX order
ssaleFlag	enum - ShortSaleFlag	stock short sale flag
numLegs	enum - numLegs	number of valid legs below
secKey1	enum - secKey1	leg 1
secType1	enum - SpdrKeyType
mult1	enum - mult1
side1	enum - BuySell
legId1	enum - legId1	SR leg Id
altLegId1	enum - altLegId1	client leg Id usually from a FIX order
posType1	enum - PositionType
ssaleFlag1	enum - ShortSaleFlag
secKey2	enum - secKey2	leg 2
secType2	enum - SpdrKeyType
mult2	enum - mult2
side2	enum - BuySell
legId2	enum - legId2	SR leg Id
altLegId2	enum - altLegId2	client leg Id usually from a FIX order
posType2	enum - PositionType
ssaleFlag2	enum - ShortSaleFlag
secKey3	enum - secKey3	leg 3
secType3	enum - SpdrKeyType
mult3	enum - mult3
side3	enum - BuySell
legId3	enum - legId3	SR leg Id
altLegId3	enum - altLegId3	client leg Id usually from a FIX order
posType3	enum - PositionType
ssaleFlag3	enum - ShortSaleFlag
secKey4	enum - secKey4	leg 4
secType4	enum - SpdrKeyType
mult4	enum - mult4
side4	enum - BuySell
legId4	enum - legId4	SR leg Id
altLegId4	enum - altLegId4	client leg Id usually from a FIX order
posType4	enum - PositionType
ssaleFlag4	enum - ShortSaleFlag
secKey5	enum - secKey5	leg 5
secType5	enum - SpdrKeyType
mult5	enum - mult5
side5	enum - BuySell
legId5	enum - legId5	SR leg Id
altLegId5	enum - altLegId5	client leg Id usually from a FIX order
posType5	enum - PositionType
ssaleFlag5	enum - ShortSaleFlag
secKey6	enum - secKey6	leg 6
secType6	enum - SpdrKeyType
mult6	enum - mult6
side6	enum - BuySell
legId6	enum - legId6	SR leg Id
altLegId6	enum - altLegId6	client leg Id usually from a FIX order
posType6	enum - PositionType
ssaleFlag6	enum - ShortSaleFlag

SELECT TABLE EXAMPLE QUERY

SELECT *
FROM `SRTrade`.`MsgSRParentReviewRequest`
WHERE 
    /* Replace with a CHAR(19) */
    `parentNumber` = 'Example_parentNumber';

Doc Columns Query

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