IndustryRiskRecordV5

V8 Message Definiton

IndustryRiskRecords contain account level position and risk summary detail. These records are published by AggRiskServers throughout the day approximately once per minute.

METADATA

Attribute	Value
Topic	4740-risk-v5
MLink Token	SystemData
Product	SRRisk
accessType	SELECT

Table Definition

Field	Type	Key	Default Value	Comment
accnt	VARCHAR(16)	PRI	''
currency	enum - Currency	PRI	'None'
code	VARCHAR(16)	PRI	''
clientFirm	VARCHAR(16)	PRI	''	SR assigned client firm
vegaLong	FLOAT		0	sum of long vega symbol positionssumsrsvega if srsvega 0
vegaShort	FLOAT		0	sum of short vega symbol positions sumsrsvega if srsvega 0
wVegaLong	FLOAT		0	sum of long weighted vega symbol positionssumsrswVega if srswVega 0
wVegaShort	FLOAT		0	sum of short weighted vega symbol positions sumsrswVega if srswVega 0
wtVegaLong	FLOAT		0	sum of long time weighted vega symbol positionssumsrswtVega if srswtVega 0
wtVegaShort	FLOAT		0	sum of short time weighted vega symbol positions sumsrswtVega if srswtVega 0
thetaLong	FLOAT		0	sum of long vega symbol positionssumsrstheta if srstheta 0
thetaShort	FLOAT		0	sum of short vega symbol positions sumsrstheta if srstheta 0
rhoLong	FLOAT		0	sum of long rho symbol positionssumsrsrho if srsrho 0
rhoShort	FLOAT		0	sum of short rho symbol positions sumsrsrho if srsrho 0
ivolLn	FLOAT		0	vega weighted average symbol ivol where srsvega 0
ivolSh	FLOAT		0	vega weighted average symbol ivol where srsvega 0
wtVeDd	FLOAT		0	Aggregate Dd Time Weighted VegasumwtVega if oprxde 030
wtVeDn	FLOAT		0	Aggregate Dn Time Weighted VegasumwtVega if 030 oprxde 010
wtVeAt	FLOAT		0	Aggregate At Time Weighted VegasumwtVega if absoprxde 010
wtVeUp	FLOAT		0	Aggregate Up Time Weighted VegasumwtVega if 010 oprxde 030
wtVeDu	FLOAT		0	Aggregate Du Time Weighted VegasumwtVega if 030 oprxde
wtVeM1	FLOAT		0	Aggregate M1 Time Weighted VegasumwtVega if days 10
wtVeM2	FLOAT		0	Aggregate M2 Time Weighted VegasumwtVega if 10 days 25
wtVeM3	FLOAT		0	Aggregate M3 Time Weighted VegasumwtVega if 25 days 65
wtVeM4	FLOAT		0	Aggregate M4 Time Weighted VegasumwtVega if 65 days 130
wtVeM5	FLOAT		0	Aggregate M5 Time Weighted VegasumwtVega if 130 days
ddelta	FLOAT		0	net deltasumsrsddelta
numSymbols	INT		0	count of srs records being aggregated
absCurSh	INT		0	absolute number of account shares CLR tradessumsrsopShAbsCur
absCurCn	INT		0	absolute number of account option contracts CLR tradessumsrsopCnAbsCur
premOvPar	FLOAT		0	aggregate premium over parity for the option positionsumsrspremOvPar
stPnlMid	FLOAT		0	stock pnl using SR marks
stPnlClr	FLOAT		0	stock pnl using CLR marks
opPnlVol	FLOAT		0	options pnl using SR vol marks
opPnlMid	FLOAT		0	options pnl using SR mid marks
opPnlClr	FLOAT		0	options pnl using CLR mid marks
opDayVega	FLOAT		0	option vega traded today
opDayWVega	FLOAT		0	option vol weighted vega traded today
opDayTVega	FLOAT		0	option time weighted vega traded today
opDayWtVega	FLOAT		0	option vol time weighted vega traded today
opDayTheta	FLOAT		0	option theta traded today
opEdgeOpened	FLOAT		0	option theo edge opened today
opEdgeClosed	FLOAT		0	option theo edge closed today
pnlDn	FLOAT		0	option delta neutral pnlsumsrspnlDn
pnlDe	FLOAT		0	option delta pnlsumsrspnlDe
pnlSl	FLOAT		0	option vegadelta pnlsumsrspnlSl
pnlGa	FLOAT		0	option gamma pnlsumsrspnlGa
pnlTh	FLOAT		0	option theta pnlsumsrspnlTh
pnlVe	FLOAT		0	option vega pnlsumsrspnlVe
pnlVo	FLOAT		0	option volga pnlsumsrspnlVo
pnlVa	FLOAT		0	option vanna pnlsumsrspnlVa
pnlDDiv	FLOAT		0	option DDiv pnlsumsrspnlDDiv
pnlSDiv	FLOAT		0	option SDiv pnlsumsrspnlSDiv
pnlRate	FLOAT		0	option Rate pnlsumsrspnlRate
pnlErr	FLOAT		0	option unexplained error pnlsumsrspnlErr
pnlTe	FLOAT		0	option theo edge pnlsumsrspnlTe
pnlLn	FLOAT		0	option pnl from symbol positions with vega
pnlSh	FLOAT		0	option pnl from symbol positions with vega
tEdge	FLOAT		0	aggregate option theo edgesumsrstEdge
tEdgeMult	FLOAT		0	denominator for computing edge per unitsumsrstEdgeMult
tEdgePr	FLOAT		0	aggregate option theo edge prior periodsumsrstEdgePr
tEdgeMultPr	FLOAT		0	enominator for computing edge per unit prior periodsumsrstEdgeMultPr
posTEdgePnl	FLOAT		0	aggregate pnl positive edge symbolssumsrsposTEdgePnl
negTEdgePnl	FLOAT		0	aggregate pnl negative edge symbolssumsrsnegTEdgePnl
badTEdgePnl	FLOAT		0	aggregate pnl no theo edge symbolssumsrsbadTEdgePnl
VaRsu90	FLOAT		0	Aggregate RiskSlide uPrc up 90 vol unchanged newUPrc uPrc MathExp090
VaRsd90	FLOAT		0	Aggregate RiskSlide uPrc dn 90 vol unchanged newUPrc uPrc MathExp090
VaRsu50	FLOAT		0	Aggregate RiskSlide uPrc up 50 vol unchanged newUPrc uPrc MathExp050
VaRsd50	FLOAT		0	Aggregate RiskSlide uPrc dn 50 vol unchanged newUPrc uPrc MathExp050
VaRsu15	FLOAT		0	Aggregate RiskSlide uPrc up 15 vol unchanged newUPrc uPrc MathExp015
VaRsd15	FLOAT		0	Aggregate RiskSlide uPrc dn 15 vol unchanged newUPrc uPrc MathExp015
VaRsu10	FLOAT		0	Aggregate RiskSlide uPrc up 10 vol unchanged newUPrc uPrc MathExp010
VaRsd10	FLOAT		0	Aggregate RiskSlide uPrc dn 10 vol unchanged newUPrc uPrc MathExp010
VaRsu05	FLOAT		0	Aggregate RiskSlide uPrc up 5 vol unchanged newUPrc uPrc MathExp005
VaRsd05	FLOAT		0	Aggregate RiskSlide uPrc dn 5 vol unchanged newUPrc uPrc MathExp005
VaRsu1e	FLOAT		0	Aggregate RiskSlide uPrc up 1x implied earn move vol ramp out
VaRsd1e	FLOAT		0	Aggregate RiskSlide uPrc dn 1x implied earn move vol ramp out
VaRsu2e	FLOAT		0	Aggregate RiskSlide uPrc up 2x implied earn move vol ramp out
VaRsd2e	FLOAT		0	Aggregate RiskSlide uPrc dn 2x implied earn move vol ramp out
VaRearn	FLOAT		0	Aggregate RiskSlide vol earn ramp out no uPrc move
VaRcash	FLOAT		0	Aggregate RiskSlide uPrc up 30 vol 001 6mn deal close delta neutral
hcCnt	FLOAT		0	count of haircut 00 symbols
haircut25	FLOAT		0	haircut 25 minimumcn act basis
haircut37	FLOAT		0	haircut 37 minimumcn act basis
lastActivity	DATETIME(6)		'1900-01-01 00:00:00.000000'
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
accnt	1
currency	2
code	3
clientFirm	4

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRRisk`.`MsgIndustryRiskRecordV5` (
    `accnt` VARCHAR(16) NOT NULL DEFAULT '',
    `currency` ENUM('None','AUD','BRL','CAD','CHF','CNH','CNY','EUR','GBP','JPY','KRW','MXN','MYR','NOK','NZD','SEK','TRY','USD','USDCents','CZK','ZAR','HUF','USX','GBX') NOT NULL DEFAULT 'None',
    `code` VARCHAR(16) NOT NULL DEFAULT '',
    `clientFirm` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'SR assigned client firm',
    `vegaLong` FLOAT NOT NULL DEFAULT 0 COMMENT 'sum of long vega symbol positions;=sum(+srs.vega) if srs.vega > 0',
    `vegaShort` FLOAT NOT NULL DEFAULT 0 COMMENT 'sum of short vega symbol positions;= sum(-srs.vega) if srs.vega < 0',
    `wVegaLong` FLOAT NOT NULL DEFAULT 0 COMMENT 'sum of long weighted vega symbol positions;=sum(+srs.wVega) if srs.wVega > 0',
    `wVegaShort` FLOAT NOT NULL DEFAULT 0 COMMENT 'sum of short weighted vega symbol positions;= sum(-srs.wVega) if srs.wVega < 0',
    `wtVegaLong` FLOAT NOT NULL DEFAULT 0 COMMENT 'sum of long time weighted vega symbol positions;=sum(+srs.wtVega) if srs.wtVega > 0',
    `wtVegaShort` FLOAT NOT NULL DEFAULT 0 COMMENT 'sum of short time weighted vega symbol positions;= sum(-srs.wtVega) if srs.wtVega < 0',
    `thetaLong` FLOAT NOT NULL DEFAULT 0 COMMENT 'sum of long vega symbol positions;=sum(+srs.theta) if srs.theta > 0',
    `thetaShort` FLOAT NOT NULL DEFAULT 0 COMMENT 'sum of short vega symbol positions;= sum(-srs.theta) if srs.theta < 0',
    `rhoLong` FLOAT NOT NULL DEFAULT 0 COMMENT 'sum of long rho symbol positions;=sum(+srs.rho) if srs.rho > 0',
    `rhoShort` FLOAT NOT NULL DEFAULT 0 COMMENT 'sum of short rho symbol positions;= sum(-srs.rho) if srs.rho < 0',
    `ivolLn` FLOAT NOT NULL DEFAULT 0 COMMENT 'vega weighted average symbol ivol where srs.vega > 0',
    `ivolSh` FLOAT NOT NULL DEFAULT 0 COMMENT 'vega weighted average symbol ivol where srs.vega < 0',
    `wtVeDd` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate Dd Time Weighted Vega;=sum[wtVega] if opr.xde < -0.30',
    `wtVeDn` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate Dn Time Weighted Vega;=sum[wtVega] if -0.30 <= opr.xde < -0.10',
    `wtVeAt` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate At Time Weighted Vega;=sum[wtVega] if abs(opr.xde) <= 0.10',
    `wtVeUp` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate Up Time Weighted Vega;=sum[wtVega] if +0.10 < opr.xde <= +0.30',
    `wtVeDu` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate Du Time Weighted Vega;=sum[wtVega] if +0.30 < opr.xde',
    `wtVeM1` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate M1 Time Weighted Vega;=sum[wtVega] if days < 10',
    `wtVeM2` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate M2 Time Weighted Vega;=sum[wtVega] if 10 < days < 25',
    `wtVeM3` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate M3 Time Weighted Vega;=sum[wtVega] if 25 < days < 65',
    `wtVeM4` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate M4 Time Weighted Vega;=sum[wtVega] if 65 < days < 130',
    `wtVeM5` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate M5 Time Weighted Vega;=sum[wtVega] if 130 < days',
    `ddelta` FLOAT NOT NULL DEFAULT 0 COMMENT 'net $delta;=sum(srs.ddelta)',
    `numSymbols` INT NOT NULL DEFAULT 0 COMMENT 'count of srs records being aggregated',
    `absCurSh` INT NOT NULL DEFAULT 0 COMMENT 'absolute number of account shares (CLR + trades);=sum(srs.opShAbsCur)',
    `absCurCn` INT NOT NULL DEFAULT 0 COMMENT 'absolute number of account option contracts (CLR + trades);=sum(srs.opCnAbsCur)',
    `premOvPar` FLOAT NOT NULL DEFAULT 0 COMMENT 'aggregate premium over parity for the option position;=sum(srs.premOvPar)',
    `stPnlMid` FLOAT NOT NULL DEFAULT 0 COMMENT 'stock pnl (using SR marks)',
    `stPnlClr` FLOAT NOT NULL DEFAULT 0 COMMENT 'stock pnl (using CLR marks)',
    `opPnlVol` FLOAT NOT NULL DEFAULT 0 COMMENT 'options pnl (using SR vol marks)',
    `opPnlMid` FLOAT NOT NULL DEFAULT 0 COMMENT 'options pnl (using SR mid marks)',
    `opPnlClr` FLOAT NOT NULL DEFAULT 0 COMMENT 'options pnl (using CLR mid marks)',
    `opDayVega` FLOAT NOT NULL DEFAULT 0 COMMENT 'option vega traded today',
    `opDayWVega` FLOAT NOT NULL DEFAULT 0 COMMENT 'option (vol weighted) vega traded today',
    `opDayTVega` FLOAT NOT NULL DEFAULT 0 COMMENT 'option (time weighted) vega traded today',
    `opDayWtVega` FLOAT NOT NULL DEFAULT 0 COMMENT 'option (vol time weighted) vega traded today',
    `opDayTheta` FLOAT NOT NULL DEFAULT 0 COMMENT 'option theta traded today',
    `opEdgeOpened` FLOAT NOT NULL DEFAULT 0 COMMENT 'option theo edge opened today',
    `opEdgeClosed` FLOAT NOT NULL DEFAULT 0 COMMENT 'option theo edge closed today',
    `pnlDn` FLOAT NOT NULL DEFAULT 0 COMMENT 'option delta neutral pnl;=sum(srs.pnlDn)',
    `pnlDe` FLOAT NOT NULL DEFAULT 0 COMMENT 'option delta pnl;=sum(srs.pnlDe)',
    `pnlSl` FLOAT NOT NULL DEFAULT 0 COMMENT 'option vega/delta pnl;=sum(srs.pnlSl)',
    `pnlGa` FLOAT NOT NULL DEFAULT 0 COMMENT 'option gamma pnl;=sum(srs.pnlGa)',
    `pnlTh` FLOAT NOT NULL DEFAULT 0 COMMENT 'option theta pnl;=sum(srs.pnlTh)',
    `pnlVe` FLOAT NOT NULL DEFAULT 0 COMMENT 'option vega pnl;=sum(srs.pnlVe)',
    `pnlVo` FLOAT NOT NULL DEFAULT 0 COMMENT 'option volga pnl;=sum(srs.pnlVo)',
    `pnlVa` FLOAT NOT NULL DEFAULT 0 COMMENT 'option vanna pnl;=sum(srs.pnlVa)',
    `pnlDDiv` FLOAT NOT NULL DEFAULT 0 COMMENT 'option DDiv pnl;=sum(srs.pnlDDiv)',
    `pnlSDiv` FLOAT NOT NULL DEFAULT 0 COMMENT 'option SDiv pnl;=sum(srs.pnlSDiv)',
    `pnlRate` FLOAT NOT NULL DEFAULT 0 COMMENT 'option Rate pnl;=sum(srs.pnlRate)',
    `pnlErr` FLOAT NOT NULL DEFAULT 0 COMMENT 'option unexplained (error) pnl;=sum(srs.pnlErr)',
    `pnlTe` FLOAT NOT NULL DEFAULT 0 COMMENT 'option theo edge pnl;=sum(srs.pnlTe)',
    `pnlLn` FLOAT NOT NULL DEFAULT 0 COMMENT 'option pnl from symbol positions with +vega',
    `pnlSh` FLOAT NOT NULL DEFAULT 0 COMMENT 'option pnl from symbol positions with -vega',
    `tEdge` FLOAT NOT NULL DEFAULT 0 COMMENT 'aggregate option theo edge;=sum(srs.tEdge)',
    `tEdgeMult` FLOAT NOT NULL DEFAULT 0 COMMENT 'denominator for computing edge per unit;=sum(srs.tEdgeMult)',
    `tEdgePr` FLOAT NOT NULL DEFAULT 0 COMMENT 'aggregate option theo edge (prior period);=sum(srs.tEdgePr)',
    `tEdgeMultPr` FLOAT NOT NULL DEFAULT 0 COMMENT 'enominator for computing edge per unit (prior period);=sum(srs.tEdgeMultPr)',
    `posTEdgePnl` FLOAT NOT NULL DEFAULT 0 COMMENT 'aggregate pnl (positive edge symbols);=sum(srs.posTEdgePnl)',
    `negTEdgePnl` FLOAT NOT NULL DEFAULT 0 COMMENT 'aggregate pnl (negative edge symbols);=sum(srs.negTEdgePnl)',
    `badTEdgePnl` FLOAT NOT NULL DEFAULT 0 COMMENT 'aggregate pnl (no theo edge symbols);=sum(srs.badTEdgePnl)',
    `VaRsu90` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate RiskSlide: uPrc up 90%, vol unchanged (newUPrc = uPrc * Math.Exp(+0.90))',
    `VaRsd90` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate RiskSlide: uPrc dn 90%, vol unchanged (newUPrc = uPrc * Math.Exp(-0.90))',
    `VaRsu50` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate RiskSlide: uPrc up 50%, vol unchanged (newUPrc = uPrc * Math.Exp(+0.50))',
    `VaRsd50` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate RiskSlide: uPrc dn 50%, vol unchanged (newUPrc = uPrc * Math.Exp(-0.50))',
    `VaRsu15` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate RiskSlide: uPrc up 15%, vol unchanged (newUPrc = uPrc * Math.Exp(+0.15))',
    `VaRsd15` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate RiskSlide: uPrc dn 15%, vol unchanged (newUPrc = uPrc * Math.Exp(-0.15))',
    `VaRsu10` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate RiskSlide: uPrc up 10%, vol unchanged (newUPrc = uPrc * Math.Exp(+0.10))',
    `VaRsd10` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate RiskSlide: uPrc dn 10%, vol unchanged (newUPrc = uPrc * Math.Exp(-0.10))',
    `VaRsu05` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate RiskSlide: uPrc up 5%, vol unchanged (newUPrc = uPrc * Math.Exp(+0.05))',
    `VaRsd05` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate RiskSlide: uPrc dn 5%, vol unchanged (newUPrc = uPrc * Math.Exp(-0.05))',
    `VaRsu1e` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate RiskSlide: uPrc up 1x implied earn move, vol ramp out',
    `VaRsd1e` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate RiskSlide: uPrc dn 1x implied earn move, vol ramp out',
    `VaRsu2e` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate RiskSlide: uPrc up 2x implied earn move, vol ramp out',
    `VaRsd2e` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate RiskSlide: uPrc dn 2x implied earn move, vol ramp out',
    `VaRearn` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate RiskSlide: vol earn ramp out (no uPrc move)',
    `VaRcash` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate RiskSlide: uPrc up 30%, vol = 0.01, 6mn deal close (delta neutral)',
    `hcCnt` FLOAT NOT NULL DEFAULT 0 COMMENT 'count of haircut > $0.0 symbols',
    `haircut25` FLOAT NOT NULL DEFAULT 0 COMMENT 'haircut ($25 minimum/cn) [act basis]',
    `haircut37` FLOAT NOT NULL DEFAULT 0 COMMENT 'haircut ($37 minimum/cn) [act basis]',
    `lastActivity` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000',
    `timestamp` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000',
    PRIMARY KEY USING HASH (`accnt`,`currency`,`code`,`clientFirm`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='IndustryRiskRecords contain account level position and risk summary detail. These records are published by AggRiskServers throughout the day approximately once per minute.';

SELECT TABLE EXAMPLE QUERY

SELECT
    `accnt`,
    `currency`,
    `code`,
    `clientFirm`,
    `vegaLong`,
    `vegaShort`,
    `wVegaLong`,
    `wVegaShort`,
    `wtVegaLong`,
    `wtVegaShort`,
    `thetaLong`,
    `thetaShort`,
    `rhoLong`,
    `rhoShort`,
    `ivolLn`,
    `ivolSh`,
    `wtVeDd`,
    `wtVeDn`,
    `wtVeAt`,
    `wtVeUp`,
    `wtVeDu`,
    `wtVeM1`,
    `wtVeM2`,
    `wtVeM3`,
    `wtVeM4`,
    `wtVeM5`,
    `ddelta`,
    `numSymbols`,
    `absCurSh`,
    `absCurCn`,
    `premOvPar`,
    `stPnlMid`,
    `stPnlClr`,
    `opPnlVol`,
    `opPnlMid`,
    `opPnlClr`,
    `opDayVega`,
    `opDayWVega`,
    `opDayTVega`,
    `opDayWtVega`,
    `opDayTheta`,
    `opEdgeOpened`,
    `opEdgeClosed`,
    `pnlDn`,
    `pnlDe`,
    `pnlSl`,
    `pnlGa`,
    `pnlTh`,
    `pnlVe`,
    `pnlVo`,
    `pnlVa`,
    `pnlDDiv`,
    `pnlSDiv`,
    `pnlRate`,
    `pnlErr`,
    `pnlTe`,
    `pnlLn`,
    `pnlSh`,
    `tEdge`,
    `tEdgeMult`,
    `tEdgePr`,
    `tEdgeMultPr`,
    `posTEdgePnl`,
    `negTEdgePnl`,
    `badTEdgePnl`,
    `VaRsu90`,
    `VaRsd90`,
    `VaRsu50`,
    `VaRsd50`,
    `VaRsu15`,
    `VaRsd15`,
    `VaRsu10`,
    `VaRsd10`,
    `VaRsu05`,
    `VaRsd05`,
    `VaRsu1e`,
    `VaRsd1e`,
    `VaRsu2e`,
    `VaRsd2e`,
    `VaRearn`,
    `VaRcash`,
    `hcCnt`,
    `haircut25`,
    `haircut37`,
    `lastActivity`,
    `timestamp`
FROM `SRRisk`.`MsgIndustryRiskRecordV5`
WHERE 
    /* Replace with a VARCHAR(16) */ 
    `accnt` = 'Example_accnt'
  AND
    /* Replace with a ENUM('None','AUD','BRL','CAD','CHF','CNH','CNY','EUR','GBP','JPY','KRW','MXN','MYR','NOK','NZD','SEK','TRY','USD','USDCents','CZK','ZAR','HUF','USX','GBX') */ 
    `currency` = 'None'
  AND
    /* Replace with a VARCHAR(16) */ 
    `code` = 'Example_code'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

Doc Columns Query

SELECT * FROM SRRisk.doccolumns WHERE TABLE_NAME='IndustryRiskRecordV5' ORDER BY ordinal_position ASC;