| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | RDBRA_NSUM_CFAR | RA: Final Results for Cash Flow at Risk | 16 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
2 | RDBRA_NSUM_CFP | RA: Final Results Positions (Delta/Gamma) of Cashflows | 16 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
3 | RDBRA_NSUM_CFPL | RA: Final Results for P&L Distributions of Cashflows | 26 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
4 | RDBRA_SUM_CF | RA RDB: Final Results for Cashflows in Evaluation Currency | 13 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
TOPAnalyzer |
5 | AFWBM_ASS_BMPH | TRM: Assignment of Benchmarks to Portfolio per Variant | 6 | UPTSTP | Time Stamp | nvarchar | 14 | 0 | | |
6 | AFWBM_ATT_BM | TRM: Key Table for Benchmark Master Data(General Attributes) | 13 | UPTSTP | Time Stamp | nvarchar | 14 | 0 | | |
7 | AFWBM_BASIC | TRM: Additional Attributes of a Basic Benchmark | 4 | UPTSTP | Time Stamp | nvarchar | 14 | 0 | | |
8 | AFWBM_COMP | TRM: Additional Attributes of a Composite Benchmark | 4 | UPTSTP | Time Stamp | nvarchar | 14 | 0 | | |
9 | AFWBM_PH_EVALP | TRM: Definition of Exception Handling for PH Variant | 5 | UPTSTP | Time Stamp | nvarchar | 14 | 0 | | |
10 | AFWCH_FL | AFWCH: Filter List | 12 | UPTSTP | Time Stamp | nvarchar | 14 | 0 | | |
11 | AFWCH_FL_BK | AFWCH: Header Data for Filter History | 18 | UPTSTP | Time Stamp | nvarchar | 14 | 0 | | |
12 | AFWGO_EVALPROC1 | Evaluation Procedure for Single Records: Definition | 10 | UPTSTP | Time Stamp | nvarchar | 14 | 0 | | |
13 | AFWGO_EVALPROC2 | Evaluation Procedure Final Results Records: Definition | 8 | UPTSTP | Time Stamp | nvarchar | 14 | 0 | | |
14 | AFWKF_DEFIN | Key Figure Definition (General Part) | 9 | UPTSTP | Time Stamp | nvarchar | 14 | 0 | | |
15 | RDBAA_REC_HEADER | Single Record Header for Accounting Analyzer | 15 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
16 | RDBAA_SUM_CURR | Final Results for Additive Key Figures in Currency: TRM-AA | 13 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
17 | RDBAA_SUM_GEN | Final Results for Additive Generic Key Figures: TRM-AA | 12 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
18 | RDB_NSUM_CURR | Final Results for Non-Add. Key Figures in Crcy (Template) | 14 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
19 | RDB_NSUM_GEN | Final Results for Non-Add. Generic Key Figures (Template) | 13 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
20 | RDB_REC_HEADER | Single Record Header (Template) | 15 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
21 | RDB_SUM_CURR | Final Results: Additive Key Figures in Currency (Template) | 13 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
22 | RDB_SUM_GEN | Final Results: Additive Generic Key Figures (Template) | 12 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
23 | RDB_SUM_NSUM_TEM | Specific Final Results (Template) | 15 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
TOPMarket Risk Analyzer |
24 | RDBRA_NSUM_CURR | CFM-RA: Final Results for Non-Additive Key Figures in Crcy | 14 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
25 | RDBRA_NSUM_GEN | CFM-RA: Final Results for Non-Additive Generic Key Figures | 13 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
26 | RDBRA_NSUM_TBG | RA: Final Results for P&L Distributions | 24 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
27 | RDBRA_NSUM_TBP | RA: Final Results Positions (Delta/Gamma) | 15 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
28 | RDBRA_NSUM_TVK | RA: Final Results for Value at Risk | 14 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
29 | RDBRA_REC_HEADER | RA RDB: Single Record Header Table | 15 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
30 | RDBRA_SUM_CURR | CFM-RA: Final Results for Additive Key Figures in Currency | 13 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
31 | RDBRA_SUM_GEN | CFM-RA: Final Results for Additive Generic Key Figures | 12 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
32 | RDBRA_SUM_TBE | RA RDB: Final Results for Key Figure Category BE | 14 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
TOPPortfolio Analyzer |
33 | BMA_BM | OLD CFM Benchmarking: BM Central Master Data | 7 | UPTSTP | Time Stamp | nvarchar | 14 | 0 | | |
34 | BMA_BMBM | OLD CFM Benchmarking: Benchmark Relationships | 9 | UPTSTP | Time Stamp | nvarchar | 14 | 0 | | |
35 | BMA_CH | OLD CFM Benchmarking: Characteristics | 3 | UPTSTP | Time Stamp | nvarchar | 14 | 0 | | |
36 | BMA_CHVAL | OLD CFM Benchmarking: Characteristic Values | 4 | UPTSTP | Time Stamp | nvarchar | 14 | 0 | | |
37 | RDBPA_NSUM_CURR | Final Results for Non-Additive Key Figures in Crcy: TRM-PA | 14 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
38 | RDBPA_NSUM_GEN | Final Results for Non-Additive Generic Key Figures: TRM-PA | 13 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
39 | RDBPA_NSUM_GEN_R | Final Results for Ratio BM Key Figures: TRM-PA | 15 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
40 | RDBPA_REC_HEADER | Single Record Header | 15 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
41 | RDBPA_SUM_CURR | Final Results for Additive Key Figures in Currency: TRM-PA | 13 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
42 | RDBPA_SUM_FLW | Key Figure Values FLW: Totals Records with Currency | 14 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
43 | RDBPA_SUM_FLWCC | Key Figure Values FLW: Totals Records w/o Currency | 13 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
44 | RDBPA_SUM_GEN | Final Results for Additive Generic Key Figures: TRM-PA | 12 | UPTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |