| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAnalyzer |
| 1 | AFWBM_ASS | TRM: Assignment of Benchmarks to Portfolio per Variant | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 2 | AFWBM_ASS_BMPH | TRM: Assignment of Benchmarks to Portfolio per Variant | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 3 | AFWBM_ASS_T | TRM: Text Table for Assignment Variants | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 4 | AFWBM_PH_EVALP | TRM: Definition of Exception Handling for PH Variant | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 5 | AFWCH_PHDEFALT | Alternative Portfolio Hierarchy Definition | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 6 | AFWGO_EPROCK | Evaluation Procedure: Key Figure Assignment Transport Table | 8 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 7 | AFWGO_EPROCK_H | Eval. Proc.: Key Fig. Assignment / Attribute Table Time-Dep. | 8 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 8 | AFWGO_EVALPROC2P | Evaluation Procedure Fin. Results Records: PH Assignment | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 9 | AFWGO_EVALPROC2Q | Evaluation Procedure Fin. Results Records: PH Assignment | 4 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 10 | JBRHISPHBAUMS | Tree Structure for Deactivated Portfolio Hierarchies | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 11 | JBRHISPHTEXT | RM: Portfolio Texts for Deactivated Portfolio Hierachy | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 12 | JBRHISPHZUORDN | RM Deactivated PH: Assign Base Portfolios to End Nodes | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| TOPAssetLiability Management |
| 13 | JBAMPGPAR | ALM Market Price Weighting: Parameters | 4 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 14 | JBAPHKMERK | ALM Assignment of Characteristics to PH Nodes | 4 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 15 | JBAPLANPAR | ALM Assignment of Planning Parameters to Planning Variant | 4 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 16 | JBAPLANPARLZB | ALM Assignment of Planning Parameters to Planning Variant | 4 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 17 | JBAPLANV | ALM Planning Variant | 4 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 18 | JBAPLANVT | ALM Planning Variant: Text Table | 5 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 19 | JBASIMPARASAVEDB | ALM: Additional Information when Saving Sim. Transactions | 16 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 20 | JBRALMPARASAVE | ALM: Evaluation Parameters | 5 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 21 | JBRSVGAPHD | RM: Header Data (Saved Gap Evaluation Results) | 6 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 22 | JBRSVGAPHEAD | RM: Header Data (Saved Gap Evaluation Results) | 6 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| TOPPayroll General Parts |
| 23 | DSYS_DOCU_SEARCH | Attributes for HR Documentation Search | 14 | PHID | Physical document | nvarchar | 32 | 0 | | |
| TOPPortfolio Analyzer |
| 24 | BMA_BMLAYER | OLD CFM Benchmarking: Benchmark Layer | 4 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 25 | BMA_BMLAYERDET | OLD CFM Benchmarking: Benchmark Layer | 4 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 26 | BMA_BMLAYERT | OLD CFM Benchmarking: Benchmark Layer (TEXTS) | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| TOPRisk Analysis |
| 27 | JBRBDSLFN | RM-BDS: Run Number Definition | 7 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 28 | JBRNODETXT | All Information for Display of Hierarchies | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 29 | JBRPH | Portfolio hierarchy | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 30 | JBRPHARC | RM: Archiving Data for Portfolio Hierarchies | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 31 | JBRPHBAUMS | Storage of Portfolio Hierarchy | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 32 | JBRPHDEF | Definitions Used to Derive Portfolio Hierarchy | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 33 | JBRPHDEFBK | RM: Backup for Table JBRPHDEF | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 34 | JBRPHGE | RM: Portfolio Hierarchy: Generation Data | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 35 | JBRPHT | Portfolio hierarchy | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 36 | JBRSVGAPHD2 | RM: Header Data (Saved Gap Evaluation Results) | 6 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 37 | JBRSVKO | RM: Header Table of SDTFT for Saved Datasets | 15 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 38 | JBRSVPHBAUM | RM: Portfolio Hierarchy for Saved Datasets (Backtesting) | 4 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 39 | JBRSVPHZUORDN | RM: Assignment of PH->BP for Saved Datasets (Backtesting) | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 40 | JBRSVSTATE | RM: Administration Table for Saved Datasets (Backtesting) | 5 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 41 | JBRTKCHABK | RM: Backup Table for Characteristic Hierarchies | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
| 42 | JBRZUORDNT | RM: Assignment of Base Portfolios to PH End Nodes | 3 | PHID | Portfolio Hierarchy | nvarchar | 3 | 0 | | |
