| 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 | 6 | SELNO | Selection number | nvarchar | 2 | 0 | | |
2 | UMB_MC107 | Scorecard: BW Variables for the Value Fields of a Measure | 7 | SELNO | Selection number | nvarchar | 2 | 0 | | |
3 | UMB_SC102 | Scorecard: Value Definition of the CPM Variable | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
4 | UMB_SC107 | Scorecard: BIC Selections | 3 | SELNO | Selection number | nvarchar | 2 | 0 | | |
5 | UMB_SC108 | Scorecard: Perspectives : BIC Selections | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
6 | UMB_SC109 | Scorecard: Perspectives: Assigned BW Queries | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
7 | UMB_SC111 | Scorecard: Assigned BW Queries | 3 | SELNO | Selection number | nvarchar | 2 | 0 | | |
8 | UMB_SC121 | Scorecard: Strategy: BIC Selection | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
9 | UMB_SC122 | Scorecard: Strategies: Assigned BW Queries | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
10 | UMB_SC152 | Scorecard: Objective: BIC Selections | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
11 | UMB_SC153 | Scorecard: Objective: Assigned BW Queries | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
12 | UMB_SC166 | Scorecard: Measures: BIC Selections | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
13 | UMB_SC167 | Scorecard: Measures: BPS Link | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
14 | UMB_SC168 | Scorecard: Measures: Assigned BW Queries | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
15 | UMB_SC171 | Scorecard: BW Web Report (Obsolete) | 6 | SELNO | Selection number | nvarchar | 2 | 0 | | |
16 | UMB_SC172 | Scorecard: URL (Obsolete) | 6 | SELNO | Selection number | nvarchar | 2 | 0 | | |
17 | UMB_SC173 | Scorecard: BW Web Report | 6 | SELNO | Selection number | nvarchar | 2 | 0 | | |
18 | UMB_SC174 | Scorecard: URL | 6 | SELNO | Selection number | nvarchar | 2 | 0 | | |
19 | UMB_SC190 | Scorecard: Initiatives: BIC Selections | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
20 | UMB_SC191 | Scorecard: Initiatives: BPS Links | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
21 | UMB_SC192 | Scorecard: Initiatives: Assigned BW Queries | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
22 | UMB_SC194 | Scorecard: Characteristics for BW Key Figs of an Initiative | 6 | SELNO | Selection number | nvarchar | 2 | 0 | | |
23 | UMB_SC196 | Scorecard: BW Variables for Value Fields of an Initiative | 7 | SELNO | Selection number | nvarchar | 2 | 0 | | |
TOPCorporate Performance Monitor |
24 | UMC_RSTRCT | Restrictions | 3 | SELNO | Selection number | nvarchar | 2 | 0 | | |
25 | UMK_BU101 | Total Float | 3 | SELNO | Selection number | nvarchar | 2 | 0 | | |
26 | UMK_MB140 | URL Assignment | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
27 | UMR_RF101 | RMS: Measure-Risk Value Fields Selection Criteria | 9 | SELNO | Selection number | nvarchar | 2 | 0 | | |
28 | UMR_RF103 | RMS: Measure-Risk Value Fields BW Variables | 10 | SELNO | Selection number | nvarchar | 2 | 0 | | |
29 | UMR_RI117 | RMS: Measure Weight Data Selection - Selections - NOT USED | 6 | SELNO | Selection number | nvarchar | 2 | 0 | | |
30 | UMR_RI200 | RMS: Assigned BW Queries | 7 | SELNO | Selection number | nvarchar | 2 | 0 | | |
31 | UMR_RI201 | RMS: BW Web Report | 7 | SELNO | Selection number | nvarchar | 2 | 0 | | |
32 | UMR_RI202 | RMS: URL | 7 | SELNO | Selection number | nvarchar | 2 | 0 | | |
33 | UMV_TR102 | Value Driver Tree: Selections of the CPM Variables | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
34 | UMV_TR104 | Value Driver Tree: Value Combinations of Runtime Variables | 5 | SELNO | Selection number | nvarchar | 2 | 0 | | |
35 | UMV_TR105 | Value Driver Tree: Assignment of BPS Characteristics | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
36 | UMV_TR108 | Value Driver Tree: Versions of Value Fields for Simulation | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
37 | UMV_TR113 | Obsolete: Value Driver Tree: Selections for the Value Fields | 6 | SELNO | Selection number | nvarchar | 2 | 0 | | |
38 | UMV_TR114 | Obsolete:Value Driver Tree: BIC Selections for Value Drivers | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
39 | UMV_TR115 | Obsolete:Val.Driver Tree:BW Queries and Workbooks of Drivers | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
40 | UMV_TR117 | Obsolete: Value Driver Tree: BW Variables for Value Fields | 7 | SELNO | Selection number | nvarchar | 2 | 0 | | |
41 | UMV_TR125 | Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers | 5 | SELNO | Selection number | nvarchar | 2 | 0 | | |
42 | UMV_TR126 | Obsolete: Frame: URL | 5 | SELNO | Selection number | nvarchar | 2 | 0 | | |
43 | UMV_TR213 | Value Driver Tree: Selections for the Value Fields | 6 | SELNO | Selection number | nvarchar | 2 | 0 | | |
44 | UMV_TR214 | Value Driver Tree: BIC Selections for Measures | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
45 | UMV_TR215 | Value Driver Tree: BW Queries and Workbooks for Measures | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
46 | UMV_TR217 | Value Driver Tree: BW Variables for Value Fields | 7 | SELNO | Selection number | nvarchar | 2 | 0 | | |
47 | UMV_TR218 | Value Driver Tree: Assignment of BPS Functions to Measures | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
48 | UMV_TR225 | Value Driver Tree: Assignment of web Reports to Measures | 5 | SELNO | Selection number | nvarchar | 2 | 0 | | |
49 | UMV_TR226 | Value Driver Tree: Assignment of URLs to Measures | 5 | SELNO | Selection number | nvarchar | 2 | 0 | | |
TOPManagement Cockpit |
50 | UMM_BU100 | Obsolete: Selections for Buffer of Transaction Data | 5 | SELNO | Selection number | nvarchar | 2 | 0 | | |
51 | UMM_BU103 | Obsolete: Selections for Buffer of Transaction Data | 5 | SELNO | Selection number | nvarchar | 2 | 0 | | |
52 | UMM_BU106 | Selections for Buffer of Transaction Data | 5 | SELNO | Selection number | nvarchar | 2 | 0 | | |
53 | UMM_CO102 | Cockpits: Assignment of Variables with Selection Conditions | 7 | SELNO | Selection number | nvarchar | 2 | 0 | | |
54 | UMM_DFT_BICDATA | Default BIC Data for Frame | 7 | SELNO | Count parameters | nvarchar | 4 | 0 | | |
55 | UMM_DFT_CHART | Default BW Data for Cockpit Frame | 7 | SELNO | Count parameters | nvarchar | 4 | 0 | | |
56 | UMM_DFT_LABEL | Default Chart Unit for Frame Graphics | 7 | SELNO | Count parameters | nvarchar | 4 | 0 | | |
57 | UMM_DFT_LEGDATA | Default Legacy Data for Frame BW Data | 7 | SELNO | Count parameters | nvarchar | 4 | 0 | | |
58 | UMM_DFT_LEGSTUC | Table: Default Legacy Structure for Cockpit | 7 | SELNO | Count parameters | nvarchar | 4 | 0 | | |
59 | UMM_DFT_Q_RANGE | Default Value Range for 4 Quadrants | 7 | SELNO | Count parameters | nvarchar | 4 | 0 | | |
60 | UMM_DFT_T_RANGE | Default Value Range for Tachometer | 7 | SELNO | Count parameters | nvarchar | 4 | 0 | | |
61 | UMM_FR101 | Frames: Dimensions | 5 | SELNO | Selection number | nvarchar | 2 | 0 | | |
62 | UMM_FR115 | Frame: Replacement of BW Variables | 6 | SELNO | Selection number | nvarchar | 2 | 0 | | |
63 | UMM_FR116 | Frame Web Report | 3 | SELNO | Selection number | nvarchar | 2 | 0 | | |
64 | UMM_FR118 | Frame: BIC Selections | 3 | SELNO | Selection number | nvarchar | 2 | 0 | | |
65 | UMM_FR121 | Frame: URL | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
66 | UMM_LG100 | Selections for Log of Transaction Data Buffer | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |
67 | UMM_ST101 | Selections for Status of the Frames in the Cockpits | 7 | SELNO | Selection number | nvarchar | 2 | 0 | | |
68 | UMM_VA103 | Variables: Proposed Selections | 4 | SELNO | Selection number | nvarchar | 2 | 0 | | |