| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMarket Risk Analyzer |
1 | AFWKFRA_KG1 | Key Figures: P&L Delta/Gamma | 14 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
2 | AFWKFRA_KG1_H | Key Figures: P+L Delta/Gamma | 15 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
3 | AFWKFRA_KVK | Key Figures: Value at Risk with Parameters | 6 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
4 | AFWKFRA_KVK1 | Key Figures: Value at Risk with Parameters | 7 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
5 | AFWKFRA_KVK1_H | Key Figures: Value-at-Risk with Parameters | 8 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
6 | AFWKFRA_KVK2 | Key Figures: Marginal Value at Risk with Parameters | 7 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
7 | AFWKFRA_KVK2_H | Key Figures: Marginal Value-at-Risk with Parameters / AT | 8 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
8 | AFWKFRA_KVK_H | Key Figures: Value-at-Risk with Parameters | 7 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
9 | ATRFVO | Risk factor volatilities | 2 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
10 | ATRFVOLA | Descriptions of Risk Factors for Volatility Names | 3 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
11 | JBRREGW | Rules for multi-dimensional risk factor shift | 19 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
12 | JBRRHBLATT | End Node Structure of a Risk Hierarchy | 19 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
13 | JBRRHBLATTH | End-Node Structure of a Risk Hierarchy (History) | 20 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
14 | JBRRHBLATT_BACK | Backup Table JBRRHBLATT (Required for Transport Imports) | 19 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
15 | VTVSZCTV | Scenario Database: Commodity Volatilities | 6 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
16 | VTVSZIDXVO | Scenario Database: Index Volatilities | 4 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
17 | VTVSZIVO | Scenario database: interest volatilities | 3 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
18 | VTVSZWPKUV | Scenario Database: Security Price Volatilities | 7 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
TOPRisk Analysis |
19 | JBRRHBLT | End-Node Structure of a Risk Hierarchy (Risk Factors) | 15 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
TOPTransaction Manager |
20 | VTVSZCVO | Scenario database: exchange rate volatilities | 5 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
TOPTreasury |
21 | ATCOVO | Commodity Price Volatilities | 2 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
22 | ATCVO | Exchange Rate Volatilities | 2 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
23 | ATIVO | Reference interest rate volatilities | 2 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
24 | ATVO1 | Volatility Types 1 | 2 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
25 | ATVO2 | Descriptions of Volatility Types | 3 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
26 | ATVO5 | Volatilities - Flow Data | 3 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
27 | ATWVO | Security price volatilities | 2 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
28 | ATXVO | Security Index Volatilities | 2 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
29 | ATZVO | Reference Int. Rate Volatilities with Curve Info. | 2 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |
30 | MDUVV | Mkt Data: Assign New Key for Volatil. Type | 4 | VOLART | Volatility Type | nvarchar | 3 | 0 | | |