TRADEPNLS
The TRADEPNLS table contains some of the attributes of the PnL data used as inputs for VaR and ES computations. The PnL vectors are present in the TRADEPNLS_VECTOR table.
| Column Name | Type | Not Null | Cube Field | Description |
|---|---|---|---|---|
| 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. |
|
| TRADE_ID | STRING | Y | [Booking].[Trades] | If TradeId comes from multiple systems you may need to prepend source system to the ID for uniqueness. Note that in certain cases, the TradeId could be for adjustment purposes. In such cases we might only have one PnL vector per Book or desk. The TradeId should contain this information clearly (ADDON or ADJ). Example: “IR_IRSWAP_LIBOR3M”, “EQ_12345677”, etc. |
| SCENARIO_SET | STRING | Y | [Risk].[Scenario Sets] | Name of the scenario set for the PnL vector. |
| CALCULATION_ID | STRING | Y | [Risk].[CalculationIds] | Name of the PnL vector calculation run. There may be several runs per AsOfDate. |
| RISK_FACTOR | STRING | Y | [Risk].[Risk Factors] | Underlying risk factor (may be more than one) of the risk class. |
| RISK_CLASS | STRING | Y | [Risk].[Risk Classes] | Defines the risk class that the PnL vector is computed for. |
| SENSITIVITY_NAME | STRING | Y | Name of the sensitivity that the PnL is attributed to. | |
| LIQUIDITY_HORIZON | INT | Y | [Risk].[Liquidity Horizons] | The Liquidity Horizon in days. This field is optional. |
| CCY | STRING | Y | [Currencies].[Currencies] | Currency in which the PnL values are expressed. |
| MTM | DOUBLE | The mark-to-market value of the trade. |
Unique Key
| Columns |
|---|
| AS_OF_DATE |
| TRADE_KEY |
| SCENARIO_SET |
| CALCULATION_ID |
| RISK_FACTOR |
| LIQUIDITY_HORIZON |
Incoming Joins
| Target Table | Source Columns | Target Columns |
|---|---|---|
| TRADEPNLS_VECTOR | AS_OF_DATE TRADE_KEY SCENARIO_SET CALCULATION_ID RISK_FACTOR LIQUIDITY_HORIZON |
AS_OF_DATE TRADE_KEY SCENARIO_SET CALCULATION_ID RISK_FACTOR LIQUIDITY_HORIZON |
Outgoing Joins
| Target Table | Source Columns | Target Columns |
|---|---|---|
| TRADE_ATTRIBUTES | AS_OF_DATE TRADE_KEY |
AS_OF_DATE TRADE_KEY |
| RISK_FACTORS_CATALOGUE | AS_OF_DATE RISK_FACTOR |
AS_OF_DATE RISK_FACTOR_ID |