RiskGroupCounter

V8 Message Definiton

METADATA

Attribute	Value
Topic	4625-risk-counter
MLink Token	ClientTrading
Product	SRTrade
accessType	SELECT
MLink Endpoint	MLink-Order

Table Definition

Field	Type	Key	Default Value	Comment
riskGroupId	CHAR(19)	PRI	'0000-0000-0000-0000'
accnt	VARCHAR(16)	PRI	''
riskFirm	VARCHAR(16)	PRI	''
sysRealm	enum - SysRealm		'None'
sysEnvironment	enum - SysEnvironment		'None'	original source sys environment Stable Current etc
riskEngine	VARCHAR(32)		''	EE engine name
changeReason	enum - ChangeReason		'None'
optQtyBotIocFilled	FLOAT		0	fills IOC leaves
optQtySldIocFilled	FLOAT		0	fills IOC leaves
futQtyBotIocFilled	FLOAT		0	fills IOC leaves
futQtySldIocFilled	FLOAT		0	fills IOC leaves
ddBotIocFilled	FLOAT		0	fills IOC leaves
ddSldIocFilled	FLOAT		0	fills IOC leaves
veBotIocFilled	FLOAT		0	fills IOC leaves
veSldIocFilled	FLOAT		0	fills IOC leaves
wtVeBotIocFilled	FLOAT		0	fills IOC leaves
wtVeSldIocFilled	FLOAT		0	fills IOC leaves
nvBotIocFilled	FLOAT		0	fills IOC leaves notional value
nvSldIocFilled	FLOAT		0	fills IOC leaves notional value
rm1BotIocFilled	FLOAT		0	fills IOC leaves
rm1SldIocFilled	FLOAT		0	fills IOC leaves
rm2BotIocFilled	FLOAT		0	fills IOC leaves
rm2SldIocFilled	FLOAT		0	fills IOC leaves
rm3BotIocFilled	FLOAT		0	fills IOC leaves
rm3SldIocFilled	FLOAT		0	fills IOC leaves
rm4BotIocFilled	FLOAT		0	fills IOC leaves
rm4SldIocFilled	FLOAT		0	fills IOC leaves
rm5BotIocFilled	FLOAT		0	fills IOC leaves
rm5SldIocFilled	FLOAT		0	fills IOC leaves
rm6BotIocFilled	FLOAT		0	fills IOC leaves
rm6SldIocFilled	FLOAT		0	fills IOC leaves
rm7BotIocFilled	FLOAT		0	fills IOC leaves
rm7SldIocFilled	FLOAT		0	fills IOC leaves
counter	INT		0
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
riskGroupId	1
accnt	2
riskFirm	3

SELECT TABLE EXAMPLE QUERY

SELECT *
FROM `SRTrade`.`MsgRiskGroupCounter`
WHERE 
    /* Replace with a CHAR(19) */
    `riskGroupId` = 'Example_riskGroupId'
  AND
    /* Replace with a VARCHAR(16) */ 
    `accnt` = 'Example_accnt'
  AND
    /* Replace with a VARCHAR(16) */ 
    `riskFirm` = 'Example_riskFirm';

Doc Columns Query

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