AwayStockLocate

V8 Message Definiton

AwayStockLocate records state locate quantities a client has sourced away from SpiderRock (directly from a locate desk or clearing firm). They are commands, not accounting truth: execution engines fold them into LocateFragment/AvailableStockLocates records and enforce the consumed floor there. noticeID 0 is the rolling statement row, updated in place with the CUMULATIVE stated quantity for the pool; non-zero noticeIDs carry per-line statements. Replaces the ClientStockLocate write path.

METADATA

Attribute	Value
Topic	1725-client-borrow
MLink Token	ClientControl
Product	SRControl
accessType	SELECT
MLink Endpoint	MLink-Order

Table Definition

Field	Type	Key	Default Value	Comment
ticker_at	enum - AssetType	PRI	'None'
ticker_ts	enum - TickerSrc	PRI	'None'
ticker_tk	VARCHAR(12)	PRI	''
coreClientFirm	VARCHAR(16)	PRI	''
locateFirm	VARCHAR(6)	PRI	''	typically a clearing firm or 3rd party locate desk
locatePool	VARCHAR(16)	PRI	''	locate pool firm granting the locate
lane	enum - ProdTest	PRI	'None'	stamped at origin propagated never recomputed
tradeDate	DATE	PRI	'1900-01-01'
noticeID	CHAR(19)	PRI	'0000-0000-0000-0000'	0 rolling cumulative statement for the pool nonzero perline statement
locateQuan	INT		0	cumulative stated quantity noticeID 0 or line quantity
isLocateExempt	enum - YesNo		'None'	Yes ticker is locate exempt only allowed for market makers
locateSource	enum - LocateSource		'None'	channel that wrote the statement
altSecurityId	VARCHAR(20)		''	An alternative securityID can be cusip or other
modifiedBy	VARCHAR(24)		''	user who last modified this record
modifiedIn	enum - SysEnvironment		'None'
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'	timestamp of last modification

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
ticker_tk	1
ticker_at	2
ticker_ts	3
coreClientFirm	4
locateFirm	5
locatePool	6
lane	7
tradeDate	8
noticeID	9

SELECT TABLE EXAMPLE QUERY

SELECT *
FROM `SRControl`.`MsgAwayStockLocate`
WHERE 
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE','CRDT','GCR','SWAP','ENT','MBS','SET','LOAN') */ 
    `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','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') */ 
    `ticker_ts` = 'NONE'
  AND
    /* Replace with a VARCHAR(12) */ 
    `ticker_tk` = 'Example_ticker_tk'
  AND
    /* Replace with a VARCHAR(16) */ 
    `coreClientFirm` = 'Example_coreClientFirm'
  AND
    /* Replace with a VARCHAR(6) */ 
    `locateFirm` = 'Example_locateFirm'
  AND
    /* Replace with a VARCHAR(16) */ 
    `locatePool` = 'Example_locatePool'
  AND
    /* Replace with a ENUM('None','Prod','Test') */ 
    `lane` = 'NONE'
  AND
    /* Replace with a DATE */
    `tradeDate` = '2022-01-01'
  AND
    /* Replace with a CHAR(19) */
    `noticeID` = 'Example_noticeID';

Doc Columns Query

SELECT * FROM SRControl.doccolumns WHERE TABLE_NAME='AwayStockLocate' ORDER BY ordinal_position ASC;