| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBalanced Scorecard |
1 | UMB_CO102 | General Objectives: Measure Label | 4 | VALID_FR | Start of Validity Period | nvarchar | 7 | 0 | | |
2 | UMB_HI110 | Scorecard Aggregation Hierarchy | 2 | VALID_FR | Start of Validity Period | nvarchar | 7 | 0 | | |
3 | UMB_SC113 | Scorecard: Perspective Assignment (Time-Dependent) | 4 | VALID_FR | Start of Validity Period | nvarchar | 7 | 0 | | |
4 | UMB_SC120 | Scorecard: Strategy Assignment (Time-Dependent) | 4 | VALID_FR | Start of Validity Period | nvarchar | 7 | 0 | | |
5 | UMB_SC140 | Scorecard: Objective Assignment (Time-Dependent) | 5 | VALID_FR | Start of Validity Period | nvarchar | 7 | 0 | | |
6 | UMB_SC142 | Scorecard: Cause-Effect Chain | 8 | VALID_FR | Start of Validity Period | nvarchar | 7 | 0 | | |
7 | UMB_SC150 | Scorecard: Objective Assignment (Time-Dependent) | 4 | VALID_FR | Start of Validity Period | nvarchar | 7 | 0 | | |
8 | UMB_SC160 | Scorecard: Measure Assignment (Time-Dependent) | 4 | VALID_FR | Start of Validity Period | nvarchar | 7 | 0 | | |
9 | UMB_SC162 | Objective: Measure Assignment (Time-Dependent) | 5 | VALID_FR | Start of Validity Period | nvarchar | 7 | 0 | | |
10 | UMB_SC170 | Scorecard: Weights for Status Calculation | 7 | VALID_FR | Start of Validity Period | nvarchar | 7 | 0 | | |
11 | UMB_SC182 | Objectives: Initiative Assignment (Time-Dependent) | 5 | VALID_FR | Start of Validity Period | nvarchar | 7 | 0 | | |
12 | UMB_SC183 | Scorecard: Assignment of General Initiatives to Objectives | 5 | VALID_FR | Start of Validity Period | nvarchar | 7 | 0 | | |
13 | UMB_SC300 | Owner Variable | 4 | VALID_FR | Start of Validity Period | nvarchar | 7 | 0 | | |
14 | UMB_SC301 | Selection of Scorecard Elements | 5 | VALID_FR | Start of Validity Period | nvarchar | 7 | 0 | | |
15 | UMB_WIZARD102 | Default Settings for Each User. Used by BSC Wizard | 3 | VALID_FR | Start of Validity Period | nvarchar | 7 | 0 | | |
TOPCorporate Performance Monitor |
16 | UMV_TR106 | Value Driver Tree: Responsible Person | 4 | VALID_FR | Start of Validity Period | nvarchar | 7 | 0 | | |
17 | UMV_TR227 | Value Driver Tree: Responsible Persons for Measures | 5 | VALID_FR | Start of Validity Period | nvarchar | 7 | 0 | | |
TOPMaintenance Orders |
18 | /MRSS/D_SQP_ESTR | Employee Profile - Structured Qualifications | 9 | VALID_FR | Valid from | nvarchar | 8 | 0 | | |
19 | /MRSS/D_SQP_EUST | Employee Profile : Unstructured Qualifications | 7 | VALID_FR | Valid from | nvarchar | 8 | 0 | | |