| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAnalyzer |
| 1 | JBRHISPHBAUMS | Tree Structure for Deactivated Portfolio Hierarchies | 18 | ADD_FLAG | General Flag | nvarchar | 1 | 0 | | |
| TOPMarket Risk Analyzer |
| 2 | JBRRHBAUM | Tree Structure of Risk Hierarchy | 17 | ADD_FLAG | General Flag | nvarchar | 1 | 0 | | |
| 3 | JBRRHBAUMH | Tree Structure of Risk Hierarchy (History) | 18 | ADD_FLAG | General Flag | nvarchar | 1 | 0 | | |
| 4 | JBRRHBAUM_BACK | Backup Table JBRRHBAUM (Required for Transport Imports) | 17 | ADD_FLAG | General Flag | nvarchar | 1 | 0 | | |
| TOPRisk Analysis |
| 5 | JBRPHBAUMS | Storage of Portfolio Hierarchy | 18 | ADD_FLAG | General Flag | nvarchar | 1 | 0 | | |
| 6 | JBRSVPHBAUM | RM: Portfolio Hierarchy for Saved Datasets (Backtesting) | 19 | ADD_FLAG | General Flag | nvarchar | 1 | 0 | | |
| TOPWorkforce Management Application |
| 7 | WFAFC_FIX_HIST | Fixed History - Obsolete as of 5.0 | 4 | ADD_FLAG | Add Days Flag | nvarchar | 2 | 0 | | |
| 8 | WFAFC_TAGDAY_LOC | Tag History - Location specific settings | 5 | ADD_FLAG | Add Days Flag | nvarchar | 2 | 0 | | |
| 9 | WFAFC_TAG_HIST | Tag History | 10 | ADD_FLAG | Add Days Flag | nvarchar | 2 | 0 | | |
| TOPWorkforce Management Core |
| 10 | WFMFC_FIX_HIST | Fixed History - Obsolete as of 5.0 | 4 | ADD_FLAG | Add Days Flag | nvarchar | 2 | 0 | | |
| 11 | WFMFC_TAGDAY_LOC | Tag History - Location specific settings | 5 | ADD_FLAG | Add Days Flag | nvarchar | 2 | 0 | | |
| 12 | WFMFC_TAG_HIST | Tag History | 10 | ADD_FLAG | Add Days Flag | nvarchar | 2 | 0 | | |
