| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBalanced Scorecard |
1 | UMB_CM101 | Performance Overview: Item | 3 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
2 | UMB_HI100 | Scorecard Hierarchy: Header Table | 5 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
3 | UMB_MA_PE101 | Miniapp Personalization - Owner Filter | 3 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
4 | UMB_MA_PE102 | Miniapp Personalization - Status Filter | 3 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
5 | UMB_MC100 | Scorecard: Measure Value Fields | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
6 | UMB_MC101 | Scorecard: Characteristics for the Value Fields of a Measure | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
7 | UMB_MC102 | Scorecard: Graphics | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
8 | UMB_MC103 | Scorecard: Assignment of Columns to Graphics | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
9 | UMB_MC105 | Scorecard: Graphics: Texts | 3 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
10 | UMB_MC106 | Scorecard: BW Variables for the Value Fields of a Measure | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
11 | UMB_MC107 | Scorecard: BW Variables for the Value Fields of a Measure | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
12 | UMB_MC108 | Scorecard: Graphic - Setting in XML Format | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
13 | UMB_MC109 | Scorecard: Graphic - Setting in XML Format | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
14 | UMB_OFL_STATUS | Download Process Status | 5 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
15 | UMB_SC100 | Scorecard: Header Table | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
16 | UMB_SC101 | Scorecard: Texts | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
17 | UMB_SC102 | Scorecard: Value Definition of the CPM Variable | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
18 | UMB_SC103 | Scorecard: Measure Assignment | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
19 | UMB_SC104 | Scorecard: Strategy Assignment | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
20 | UMB_SC105 | Scorecard: Objective Assignment | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
21 | UMB_SC107 | Scorecard: BIC Selections | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
22 | UMB_SC108 | Scorecard: Perspectives : BIC Selections | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
23 | UMB_SC109 | Scorecard: Perspectives: Assigned BW Queries | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
24 | UMB_SC110 | Scorecard: Column Assignment | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
25 | UMB_SC111 | Scorecard: Assigned BW Queries | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
26 | UMB_SC112 | Scorecard: Perspective Assignment | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
27 | UMB_SC113 | Scorecard: Perspective Assignment (Time-Dependent) | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
28 | UMB_SC115 | Scorecard: View Assignment | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
29 | UMB_SC116 | Scorecard and BPS Web Interface | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
30 | UMB_SC120 | Scorecard: Strategy Assignment (Time-Dependent) | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
31 | UMB_SC121 | Scorecard: Strategy: BIC Selection | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
32 | UMB_SC122 | Scorecard: Strategies: Assigned BW Queries | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
33 | UMB_SC140 | Scorecard: Objective Assignment (Time-Dependent) | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
34 | UMB_SC142 | Scorecard: Cause-Effect Chain | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
35 | UMB_SC143 | Cause-Effect Chain: XML Document for Old Java Applets | 3 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
36 | UMB_SC145 | Cause-Effect Chain: XML Document for JNet Applets | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
37 | UMB_SC145C | Cause-Effect Chain: XML Document | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
38 | UMB_SC150 | Scorecard: Objective Assignment (Time-Dependent) | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
39 | UMB_SC151 | Scorecard: Objective Score, A&C, DBS, Doc Id | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
40 | UMB_SC152 | Scorecard: Objective: BIC Selections | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
41 | UMB_SC153 | Scorecard: Objective: Assigned BW Queries | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
42 | UMB_SC160 | Scorecard: Measure Assignment (Time-Dependent) | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
43 | UMB_SC161 | Scorecard: Measure Score, A&C, DBS, Doc Id | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
44 | UMB_SC162 | Objective: Measure Assignment (Time-Dependent) | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
45 | UMB_SC163 | Scorecard: Assignment of Formula Argument to Value Fields | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
46 | UMB_SC164 | Scorecard: Formula to Calculate the Status of a Measure | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
47 | UMB_SC165 | Scorecard: Assignment of Formula Value to Measure Status | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
48 | UMB_SC166 | Scorecard: Measures: BIC Selections | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
49 | UMB_SC167 | Scorecard: Measures: BPS Link | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
50 | UMB_SC168 | Scorecard: Measures: Assigned BW Queries | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
51 | UMB_SC170 | Scorecard: Weights for Status Calculation | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
52 | UMB_SC171 | Scorecard: BW Web Report (Obsolete) | 3 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
53 | UMB_SC172 | Scorecard: URL (Obsolete) | 3 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
54 | UMB_SC173 | Scorecard: BW Web Report | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
55 | UMB_SC173T | Scorecard: BW Web Report | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
56 | UMB_SC174 | Scorecard: URL | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
57 | UMB_SC174T | Scorecard: URL | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
58 | UMB_SC180 | Scorecard: Initiatives | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
59 | UMB_SC181 | Scorecard: Texts for Initiatives | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
60 | UMB_SC182 | Objectives: Initiative Assignment (Time-Dependent) | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
61 | UMB_SC183 | Scorecard: Assignment of General Initiatives to Objectives | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
62 | UMB_SC184 | Scorecard: Status of a General Initiative | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
63 | UMB_SC185 | Scorecard: Initiative Score, A&C, DBS, Doc Id | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
64 | UMB_SC186 | Scorecard: Initiative: Team Members | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
65 | UMB_SC187 | Scorecard: Initiative: Message for Team Members | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
66 | UMB_SC188 | Scorecard: Initiative: Benefits | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
67 | UMB_SC189 | Scorecard: Initiative: Benefits Text Table | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
68 | UMB_SC190 | Scorecard: Initiatives: BIC Selections | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
69 | UMB_SC191 | Scorecard: Initiatives: BPS Links | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
70 | UMB_SC192 | Scorecard: Initiatives: Assigned BW Queries | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
71 | UMB_SC193 | Scorecard: BW Key Figure Values of an Initiative | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
72 | UMB_SC194 | Scorecard: Characteristics for BW Key Figs of an Initiative | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
73 | UMB_SC195 | Scorecard: BW Variables for Value Fields of an Initiative | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
74 | UMB_SC196 | Scorecard: BW Variables for Value Fields of an Initiative | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
75 | UMB_SC197 | Scorecard: Initiative: Milestones | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
76 | UMB_SC198 | Scorecard: Initiative: Milestones (Text Table) | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
77 | UMB_SC199 | Scorecard: Assignment of Formula Argument to Value Fields | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
78 | UMB_SC201 | Scorecard: Perspective Score & A&C BDS Doc ID | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
79 | UMB_SC211 | Scorecard: Strategy Score & A&C BDS Doc ID | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
80 | UMB_SC221 | Scorecard: Score & A&C BDS Doc ID | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
81 | UMB_SC300 | Owner Variable | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
82 | UMB_SC301 | Selection of Scorecard Elements | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
83 | UMB_SG101 | Scorecard Group: Scorecard Assignment | 3 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
TOPCorporate Performance Monitor |
84 | UMR_EX100 | RMS: Measure Deviations for Risks | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
85 | UMR_EX110 | RMS: Measure Targets | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |
86 | UMR_EX120 | RMS: Measure Status & Risk Status | 2 | SCARD | Scorecard | nvarchar | 10 | 0 | | |