Navigation :
TRADEPNLS_VECTOR
The TRADEPNLS_VECTOR table contains the PnL vectors used as inputs for VaR and ES computations.
| Column Name |
Type |
Not Null |
Cube Field |
Description |
| VECTOR_INDEX |
INT |
Y |
|
Index in the PnL vector. |
| AS_OF_DATE |
DATE |
Y |
|
Timestamp (at close of business) for the data. |
| TRADE_KEY |
STRING |
Y |
|
The field contains the tradeID for full data or Book#VaR Inclusion for summary data. |
| SCENARIO_SET |
STRING |
Y |
Scenario Sets |
Name of the scenario set for the PnL vector. |
| CALCULATION_ID |
STRING |
Y |
CalculationIds |
Name of the PnL vector calculation run. There may be several runs per AsOfDate. |
| MARKET_DATA_SET |
STRING |
Y |
This field is not currently used |
The market data set that should be used when retrieving rates for FX conversion. |
| RISK_FACTOR |
STRING |
Y |
Risk Factors |
Underlying risk factor (may be more than one) of the risk class. |
| LIQUIDITY_HORIZON |
INT |
Y |
Liquidity Horizons |
The Liquidity Horizon in days. This field is optional. |
| PNL_VECTOR |
DOUBLE |
Y |
|
PnL value corresponding to the index. |
Unique Key
| Columns |
| VECTOR_INDEX |
| AS_OF_DATE |
| TRADE_KEY |
| SCENARIO_SET |
| CALCULATION_ID |
| MARKET_DATA_SET |
| RISK_FACTOR |
| LIQUIDITY_HORIZON |
Outgoing Joins
| Target Table |
Source Columns |
Target Columns |
| TRADEPNLS |
AS_OF_DATE
TRADE_KEY
SCENARIO_SET
CALCULATION_ID
MARKET_DATA_SET
RISK_FACTOR
LIQUIDITY_HORIZON
|
AS_OF_DATE
TRADE_KEY
SCENARIO_SET
CALCULATION_ID
MARKET_DATA_SET
RISK_FACTOR
LIQUIDITY_HORIZON
|