| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBalanced Scorecard |
1 | UMB_MC101 | Scorecard: Characteristics for the Value Fields of a Measure | 9 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
2 | UMB_MC107 | Scorecard: BW Variables for the Value Fields of a Measure | 9 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
3 | UMB_SC102 | Scorecard: Value Definition of the CPM Variable | 3 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
4 | UMB_SC107 | Scorecard: BIC Selections | 9 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
5 | UMB_SC108 | Scorecard: Perspectives : BIC Selections | 10 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
6 | UMB_SC121 | Scorecard: Strategy: BIC Selection | 10 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
7 | UMB_SC152 | Scorecard: Objective: BIC Selections | 10 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
8 | UMB_SC166 | Scorecard: Measures: BIC Selections | 10 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
9 | UMB_SC190 | Scorecard: Initiatives: BIC Selections | 10 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
10 | UMB_SC194 | Scorecard: Characteristics for BW Key Figs of an Initiative | 9 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
11 | UMB_SC196 | Scorecard: BW Variables for Value Fields of an Initiative | 9 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
TOPCorporate Performance Monitor |
12 | UMR_RF101 | RMS: Measure-Risk Value Fields Selection Criteria | 12 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
13 | UMR_RF103 | RMS: Measure-Risk Value Fields BW Variables | 12 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
14 | UMR_RI117 | RMS: Measure Weight Data Selection - Selections - NOT USED | 9 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
15 | UMV_TR102 | Value Driver Tree: Selections of the CPM Variables | 3 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
16 | UMV_TR103 | Value Driver Tree: Runtime Variables Used | 3 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
17 | UMV_TR104 | Value Driver Tree: Value Combinations of Runtime Variables | 4 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
18 | UMV_TR113 | Obsolete: Value Driver Tree: Selections for the Value Fields | 9 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
19 | UMV_TR114 | Obsolete:Value Driver Tree: BIC Selections for Value Drivers | 10 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
20 | UMV_TR117 | Obsolete: Value Driver Tree: BW Variables for Value Fields | 9 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
21 | UMV_TR213 | Value Driver Tree: Selections for the Value Fields | 9 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
22 | UMV_TR214 | Value Driver Tree: BIC Selections for Measures | 10 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
23 | UMV_TR217 | Value Driver Tree: BW Variables for Value Fields | 9 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
TOPManagement Cockpit |
24 | UMM_FR115 | Frame: Replacement of BW Variables | 8 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |
25 | UMM_FR118 | Frame: BIC Selections | 9 | CPM_VAR | Technical Name of a CPM Variable | nvarchar | 15 | 0 | | |