| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBalanced Scorecard |
1 | UMB_MC100 | Scorecard: Measure Value Fields | 9 | IQUERY | BW Report (BW Internal Display) | nvarchar | 30 | 0 | | |
2 | UMB_SC109 | Scorecard: Perspectives: Assigned BW Queries | 7 | IQUERY | BW Report (BW Internal Display) | nvarchar | 30 | 0 | | |
3 | UMB_SC111 | Scorecard: Assigned BW Queries | 6 | IQUERY | BW Report (BW Internal Display) | nvarchar | 30 | 0 | | |
4 | UMB_SC122 | Scorecard: Strategies: Assigned BW Queries | 7 | IQUERY | BW Report (BW Internal Display) | nvarchar | 30 | 0 | | |
5 | UMB_SC153 | Scorecard: Objective: Assigned BW Queries | 7 | IQUERY | BW Report (BW Internal Display) | nvarchar | 30 | 0 | | |
6 | UMB_SC168 | Scorecard: Measures: Assigned BW Queries | 7 | IQUERY | BW Report (BW Internal Display) | nvarchar | 30 | 0 | | |
7 | UMB_SC180 | Scorecard: Initiatives | 13 | IQUERY | BW Report (BW Internal Display) | nvarchar | 30 | 0 | | |
8 | UMB_SC192 | Scorecard: Initiatives: Assigned BW Queries | 7 | IQUERY | BW Report (BW Internal Display) | nvarchar | 30 | 0 | | |
TOPCorporate Performance Monitor |
9 | UMR_RF100 | RMS: Measure-Risk Value Fields | 11 | IQUERY | BW Report (BW Internal Display) | nvarchar | 30 | 0 | | |
10 | UMR_RI116 | RMS: Measure Weight Data Selection - NOT USED | 8 | IQUERY | BW Report (BW Internal Display) | nvarchar | 30 | 0 | | |
11 | UMR_RI200 | RMS: Assigned BW Queries | 10 | IQUERY | BW Report (BW Internal Display) | nvarchar | 30 | 0 | | |
12 | UMV_TR112 | Obsolete: Value Driver Tree: Value Fields of a Value Driver | 8 | IQUERY | BW Report (BW Internal Display) | nvarchar | 30 | 0 | | |
13 | UMV_TR115 | Obsolete:Val.Driver Tree:BW Queries and Workbooks of Drivers | 7 | IQUERY | BW Report (BW Internal Display) | nvarchar | 30 | 0 | | |
14 | UMV_TR212 | Value Driver Tree: Value Fields or Measure | 8 | IQUERY | BW Report (BW Internal Display) | nvarchar | 30 | 0 | | |
15 | UMV_TR215 | Value Driver Tree: BW Queries and Workbooks for Measures | 7 | IQUERY | BW Report (BW Internal Display) | nvarchar | 30 | 0 | | |
TOPManagement Cockpit |
16 | UMM_FR100 | Frames: Header Table | 10 | IQUERY | BW Report (BW Internal Display) | nvarchar | 30 | 0 | | |
17 | UMM_FR113 | Frame: Workbooks and Queries | 6 | IQUERY | BW Report (BW Internal Display) | nvarchar | 30 | 0 | | |
18 | UMM_LN101 | Cockpit Objects: Links and Reports | 15 | IQUERY | BW Report (BW Internal Display) | nvarchar | 30 | 0 | | |