Navigation :
SATradeDescription
Store Field |
Key |
CanBeNull |
Type (+Default Value - if applicable) |
Cube Field |
Description |
TradeId |
Y |
|
String |
See field in referencing store (TradeBase) |
(e.g. “IR_IRSWAP_LIBOR3M”, “EQ_12345677”, etc.) – if coming from multiple systems may need to prepend source system to the id for uniqueness. |
Notional |
|
|
Double |
[Booking].[TradeId] (This field is a measure) |
The Notional of the trade/position (used for RRAO and DRC). |
NotionalCcy |
|
|
String |
Trade Notional Currency |
The currency of the notional. |
PresentValue |
|
|
Double |
Trade PV (This field is a measure) |
The current present value of the trade/position (used in curvature and DRC). |
PVCcy |
|
|
String |
Trade PV Currency |
The currency of the present value. |
ResidualRisk |
|
|
String |
(This is an internal field) |
Indicates trade/position subject to residual risk add-on. |
ExoticUnderlying |
|
|
String |
Exotic Underlying |
If yes and residual risk, risk weight = 1% otherwise if residual risk, weight = .1%. |
OtherResidualRiskType |
|
|
String("DATAMEMBER")See knowledgebase |
Other Residual Risk type |
Optional data. Valid if ExoticUnderlying = ‘N’. Suggested valid values are “GAP”, “CORRELATION”,‘BEHAVIORIAL", “OTHER”. |
AsOfDate |
Y |
|
Date[yyyy-mm-dd] |
See field in referencing store (TradeBase) |
Timestamp (at close of business) for the data. |