| 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 | 14 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
2 | RDBRA_NSUM_CFP | RA: Final Results Positions (Delta/Gamma) of Cashflows | 14 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
3 | RDBRA_NSUM_CFPL | RA: Final Results for P&L Distributions of Cashflows | 24 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
4 | RDBRA_SUM_CF | RA RDB: Final Results for Cashflows in Evaluation Currency | 11 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
5 | RSOADSO | Datastore Object | 11 | CRTSTP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
6 | RSOADSOCONV | ADSO: Pending conversions (must be identical to RSOADSO) | 11 | CRTSTP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
7 | RSOHCPR | HanaCompositeProvider | 13 | CRTSTP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
TOPAnalyzer |
8 | AFWBM_ASS_BMPH | TRM: Assignment of Benchmarks to Portfolio per Variant | 12 | CRTSTP | Time Stamp | nvarchar | 14 | 0 | | |
9 | AFWBM_ATT_BM | TRM: Key Table for Benchmark Master Data(General Attributes) | 11 | CRTSTP | Time Stamp | nvarchar | 14 | 0 | | |
10 | AFWCH_FL | AFWCH: Filter List | 10 | CRTSTP | Time Stamp | nvarchar | 14 | 0 | | |
11 | AFWCH_FL_BK | AFWCH: Header Data for Filter History | 16 | CRTSTP | Time Stamp | nvarchar | 14 | 0 | | |
12 | AFWGO_EVALPROC1 | Evaluation Procedure for Single Records: Definition | 8 | CRTSTP | Time Stamp | nvarchar | 14 | 0 | | |
13 | AFWGO_EVALPROC2 | Evaluation Procedure Final Results Records: Definition | 6 | CRTSTP | Time Stamp | nvarchar | 14 | 0 | | |
14 | AFWKF_DEFIN | Key Figure Definition (General Part) | 7 | CRTSTP | Time Stamp | nvarchar | 14 | 0 | | |
15 | RDBAA_REC_HEADER | Single Record Header for Accounting Analyzer | 13 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
16 | RDBAA_SUM_CURR | Final Results for Additive Key Figures in Currency: TRM-AA | 11 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
17 | RDBAA_SUM_GEN | Final Results for Additive Generic Key Figures: TRM-AA | 10 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
18 | RDB_NSUM_CURR | Final Results for Non-Add. Key Figures in Crcy (Template) | 12 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
19 | RDB_NSUM_GEN | Final Results for Non-Add. Generic Key Figures (Template) | 11 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
20 | RDB_REC_HEADER | Single Record Header (Template) | 13 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
21 | RDB_SUM_CURR | Final Results: Additive Key Figures in Currency (Template) | 11 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
22 | RDB_SUM_GEN | Final Results: Additive Generic Key Figures (Template) | 10 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
23 | RDB_SUM_NSUM_TEM | Specific Final Results (Template) | 13 | CRTSTP | 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 | 12 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
25 | RDBRA_NSUM_GEN | CFM-RA: Final Results for Non-Additive Generic Key Figures | 11 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
26 | RDBRA_NSUM_TBG | RA: Final Results for P&L Distributions | 22 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
27 | RDBRA_NSUM_TBP | RA: Final Results Positions (Delta/Gamma) | 13 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
28 | RDBRA_NSUM_TVK | RA: Final Results for Value at Risk | 12 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
29 | RDBRA_REC_HEADER | RA RDB: Single Record Header Table | 13 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
30 | RDBRA_SUM_CURR | CFM-RA: Final Results for Additive Key Figures in Currency | 11 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
31 | RDBRA_SUM_GEN | CFM-RA: Final Results for Additive Generic Key Figures | 10 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
32 | RDBRA_SUM_TBE | RA RDB: Final Results for Key Figure Category BE | 12 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
TOPMetadata Repository |
33 | RSQISET | Directory of all InfoSets | 14 | CRTSTP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
TOPPlanning |
34 | RSISISV | Services: Catalog | 7 | CRTSTP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
35 | RSPLS_ALVL | Planning: Primary Table for Aggregation Levels | 13 | CRTSTP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
TOPPortfolio Analyzer |
36 | BMA_BM | OLD CFM Benchmarking: BM Central Master Data | 9 | CRTSTP | Time Stamp | nvarchar | 14 | 0 | | |
37 | BMA_BMBM | OLD CFM Benchmarking: Benchmark Relationships | 11 | CRTSTP | Time Stamp | nvarchar | 14 | 0 | | |
38 | BMA_CH | OLD CFM Benchmarking: Characteristics | 5 | CRTSTP | Time Stamp | nvarchar | 14 | 0 | | |
39 | BMA_CHVAL | OLD CFM Benchmarking: Characteristic Values | 6 | CRTSTP | Time Stamp | nvarchar | 14 | 0 | | |
40 | RDBPA_NSUM_CURR | Final Results for Non-Additive Key Figures in Crcy: TRM-PA | 12 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
41 | RDBPA_NSUM_GEN | Final Results for Non-Additive Generic Key Figures: TRM-PA | 11 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
42 | RDBPA_NSUM_GEN_R | Final Results for Ratio BM Key Figures: TRM-PA | 13 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
43 | RDBPA_REC_HEADER | Single Record Header | 13 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
44 | RDBPA_SUM_CURR | Final Results for Additive Key Figures in Currency: TRM-PA | 11 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
45 | RDBPA_SUM_FLW | Key Figure Values FLW: Totals Records with Currency | 12 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
46 | RDBPA_SUM_FLWCC | Key Figure Values FLW: Totals Records w/o Currency | 11 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |
47 | RDBPA_SUM_GEN | Final Results for Additive Generic Key Figures: TRM-PA | 10 | CRTSTP | Time Stamp in Results Databases | nvarchar | 14 | 0 | | |