| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBalanced Scorecard |
| 1 | UMB_SC109 | Scorecard: Perspectives: Assigned BW Queries | 5 | ISWORKBOOK | Indicator for Workbook | nvarchar | 1 | 0 | | |
| 2 | UMB_SC111 | Scorecard: Assigned BW Queries | 4 | ISWORKBOOK | Indicator for Workbook | nvarchar | 1 | 0 | | |
| 3 | UMB_SC122 | Scorecard: Strategies: Assigned BW Queries | 5 | ISWORKBOOK | Indicator for Workbook | nvarchar | 1 | 0 | | |
| 4 | UMB_SC153 | Scorecard: Objective: Assigned BW Queries | 5 | ISWORKBOOK | Indicator for Workbook | nvarchar | 1 | 0 | | |
| 5 | UMB_SC168 | Scorecard: Measures: Assigned BW Queries | 5 | ISWORKBOOK | Indicator for Workbook | nvarchar | 1 | 0 | | |
| 6 | UMB_SC192 | Scorecard: Initiatives: Assigned BW Queries | 5 | ISWORKBOOK | Indicator for Workbook | nvarchar | 1 | 0 | | |
| TOPCorporate Performance Monitor |
| 7 | UMR_RI200 | RMS: Assigned BW Queries | 8 | ISWORKBOOK | Indicator for Workbook | nvarchar | 1 | 0 | | |
| 8 | UMV_TR115 | Obsolete:Val.Driver Tree:BW Queries and Workbooks of Drivers | 5 | ISWORKBOOK | Indicator for Workbook | nvarchar | 1 | 0 | | |
| 9 | UMV_TR215 | Value Driver Tree: BW Queries and Workbooks for Measures | 5 | ISWORKBOOK | Indicator for Workbook | nvarchar | 1 | 0 | | |
| TOPManagement Cockpit |
| 10 | UMM_FR113 | Frame: Workbooks and Queries | 4 | ISWORKBOOK | Indicator for Workbook | nvarchar | 1 | 0 | | |
| 11 | UMM_LN101 | Cockpit Objects: Links and Reports | 12 | ISWORKBOOK | Indicator for Workbook | nvarchar | 1 | 0 | | |
