| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAnalyzer |
1 | AFWBM_ASS_TREE | TRM: Assignment of Benchmark ID to PH Nodes per Variant | 3 | PKNOTEN | Node in Portfolio Hierarchy | nvarchar | 6 | 0 | | |
2 | JBRHISPHBAUMS | Tree Structure for Deactivated Portfolio Hierarchies | 4 | PKNOTEN | Node in Portfolio Hierarchy | nvarchar | 6 | 0 | | |
TOPAssetLiability Management |
3 | JBALMDLGLOB | ALM: Higher-Level Data of Detailed Log | 5 | PKNOTEN | Node in Portfolio Hierarchy | nvarchar | 6 | 0 | | |
4 | JBALMDLLOC | ALM: Higher-Level Data of Detailed Log | 6 | PKNOTEN | Object name | nvarchar | 30 | 0 | | |
5 | JBASIMLZBSAVE | ALM: Maturity-Band-Dependent Parameters | 4 | PKNOTEN | Node in Portfolio Hierarchy | nvarchar | 6 | 0 | | |
6 | JBASIMPARASAVEDB | ALM: Additional Information when Saving Sim. Transactions | 4 | PKNOTEN | Node in Portfolio Hierarchy | nvarchar | 6 | 0 | | |
7 | JBRALMPARASAVE | ALM: Evaluation Parameters | 6 | PKNOTEN | Node in Portfolio Hierarchy | nvarchar | 6 | 0 | | |
8 | JBRSVGAPHD | RM: Header Data (Saved Gap Evaluation Results) | 7 | PKNOTEN | Node in Portfolio Hierarchy | nvarchar | 6 | 0 | | |
9 | JBRSVGAPHEAD | RM: Header Data (Saved Gap Evaluation Results) | 7 | PKNOTEN | Node in Portfolio Hierarchy | nvarchar | 6 | 0 | | |
TOPRisk Analysis |
10 | JBRBDSGUV | RM-BDS: P+L Distribution | 3 | PKNOTEN | Node in Portfolio Hierarchy | nvarchar | 6 | 0 | | |
11 | JBRBDSGUV10 | RM-BDS: P+L Distribution in Blocks of Ten | 3 | PKNOTEN | Node in Portfolio Hierarchy | nvarchar | 6 | 0 | | |
12 | JBRBDSLFN | RM-BDS: Run Number Definition | 8 | PKNOTEN | Node in Portfolio Hierarchy | nvarchar | 6 | 0 | | |
13 | JBRBDSLFNA | RM-BDS: Index for P+L Data in the Archive File | 3 | PKNOTEN | Node in Portfolio Hierarchy | nvarchar | 6 | 0 | | |
14 | JBRBDSVAR | RM-BDS: VaR Data | 3 | PKNOTEN | Node in Portfolio Hierarchy | nvarchar | 6 | 0 | | |
15 | JBRPHBAUMS | Storage of Portfolio Hierarchy | 4 | PKNOTEN | Node in Portfolio Hierarchy | nvarchar | 6 | 0 | | |
16 | JBRSVGAPHD2 | RM: Header Data (Saved Gap Evaluation Results) | 7 | PKNOTEN | Node in Portfolio Hierarchy | nvarchar | 6 | 0 | | |
17 | JBRSVKO | RM: Header Table of SDTFT for Saved Datasets | 16 | PKNOTEN | Node in Portfolio Hierarchy | nvarchar | 6 | 0 | | |
18 | JBRSVPHBAUM | RM: Portfolio Hierarchy for Saved Datasets (Backtesting) | 5 | PKNOTEN | Node in Portfolio Hierarchy | nvarchar | 6 | 0 | | |
19 | JBRSVSTATE | RM: Administration Table for Saved Datasets (Backtesting) | 6 | PKNOTEN | Node in Portfolio Hierarchy | nvarchar | 6 | 0 | | |