AtsDegrossRevConResult

V8 Message Definiton

Published by the degrossing execution engine: Received on order arrival, then per-auction results after each event in the day's sequence (Trial 9:55 CST, Real 10:00/10:05/10:10/10:15; see AtsDegrossAuctionSchedule (2358)), Final after the order's last event. The WTS merges per-(ticker, expiry) results into LiveGridBasketDegrossDetail (6912) rows; per-auction rollups drive the Basket Manager summary boxes.

METADATA

Attribute	Value
Topic	2270-execution-engine
MLink Token	ClientTrading
Product	SRTrade
accessType	SELECT
MLink Endpoint	MLink-Live

Table Definition

Field	Type	Key	Default Value	Comment
ticker_at	enum - AssetType	PRI	'None'	underlier ticker
ticker_ts	enum - TickerSrc	PRI	'None'	underlier ticker
ticker_tk	VARCHAR(12)	PRI	''	underlier ticker
expiry	DATE	PRI	'1900-01-01'	flex option expiry date
accnt	VARCHAR(16)	PRI	''	SR trading account
side	enum - BuySell	PRI	'None'	Buy reversal lend Sell conversion borrow
clientFirm	VARCHAR(16)	PRI	''
auctionDttm	DATETIME(6)	PRI	'1900-01-01 00:00:00.000000'	auction cycle timestamp identifies which specific auction multiple per day
parentNumber	BIGINT	PRI	0	parent order reference two sameside parents on one accnt ticker expiry never alias
eventNum	INT	PRI	0	auction sequence index AtsDegrossAuctionSchedule 2358 auctionNumber 1 Trial 25 Real 0 preauction Received One row per event the Received audit row is never overwritten
resultStatus	enum - AtsDegrossResultStatus		'None'
submittedSize	INT		0	original order size
effectiveRate	DOUBLE		0	SR reference rate used
effectiveSDiv	DOUBLE		0	SR reference sdiv used
refUPrc	DOUBLE		0	reference underlier price used
strike	DOUBLE		0	SRchosen strike
iDays	INT		0	interest days to expiry
limitPrice	DOUBLE		0	computed limit price for this order
clearingPrice	DOUBLE		0	single clearing price for this ticker expiry at this event
srClearingSDiv	DOUBLE		0	clearing SDIV using SR rate SR ddiv 0 with stateUnavailable inversion failed
clientClearingSDiv	DOUBLE		0	unused 0 client pricing components retired from the gateway
matchSize	INT		0	size matched to this order at this event
matchStatus	enum - AtsRevConFillStatus		'None'
withdrawReason	TINYTEXT		''	reserved reason an order was withdrawn unused in 21
srClearingSDivState	enum - DegrossRateState		'None'	None no cross Ok valid a true 0 included Unavailable the clearing price has no admissible rate
fillSize	INT		0	exchangeconfirmed fill size at this event
numCrosses	INT		0	bilateral crosses this order participated in at this event
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
ticker_tk	1
ticker_at	2
ticker_ts	3
expiry	4
accnt	5
side	6
clientFirm	7
auctionDttm	8
parentNumber	9
eventNum	10

SELECT TABLE EXAMPLE QUERY

SELECT *
FROM `SRTrade`.`MsgAtsDegrossRevConResult`
WHERE 
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */ 
    `ticker_at` = 'None'
  AND
    /* 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') */ 
    `ticker_ts` = 'None'
  AND
    /* Replace with a VARCHAR(12) */ 
    `ticker_tk` = 'Example_ticker_tk'
  AND
    /* Replace with a DATE */
    `expiry` = '2022-01-01'
  AND
    /* Replace with a VARCHAR(16) */ 
    `accnt` = 'Example_accnt'
  AND
    /* Replace with a ENUM('None','Buy','Sell') */ 
    `side` = 'None'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm'
  AND
    /* Replace with a DATETIME(6) */
    `auctionDttm` = '2022-01-01 12:34:56.000000'
  AND
    /* Replace with a BIGINT */ 
    `parentNumber` = 1234567890
  AND
    /* Replace with a INT */ 
    `eventNum` = 5;

Doc Columns Query

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