| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBalanced Scorecard |
1 | UMB_MC100 | Scorecard: Measure Value Fields | 16 | YTD_PERIODICITY | Time Period for the Aggregation | nvarchar | 4 | 0 | | |
2 | UMB_SC193 | Scorecard: BW Key Figure Values of an Initiative | 11 | YTD_PERIODICITY | Time Period for the Aggregation | nvarchar | 4 | 0 | | |
TOPCorporate Performance Monitor |
3 | UMR_RF100 | RMS: Measure-Risk Value Fields | 18 | YTD_PERIODICITY | Time Period for the Aggregation | nvarchar | 4 | 0 | | |
4 | UMR_RI116 | RMS: Measure Weight Data Selection - NOT USED | 14 | YTD_PERIODICITY | Time Period for the Aggregation | nvarchar | 4 | 0 | | |
5 | UMV_TR112 | Obsolete: Value Driver Tree: Value Fields of a Value Driver | 14 | YTD_PERIODICITY | Time Period for the Aggregation | nvarchar | 4 | 0 | | |
6 | UMV_TR212 | Value Driver Tree: Value Fields or Measure | 14 | YTD_PERIODICITY | Time Period for the Aggregation | nvarchar | 4 | 0 | | |
TOPManagement Cockpit |
7 | UMM_BU101 | Obsolete: Buffer of Transaction Data | 12 | YTD_PERIODICITY | Time Period for the Aggregation | nvarchar | 4 | 0 | | |
8 | UMM_BU102 | Obsolete: Buffer of Transaction Data | 9 | YTD_PERIODICITY | Time Period for the Aggregation | nvarchar | 4 | 0 | | |
9 | UMM_BU105 | Buffer of Transaction Data | 9 | YTD_PERIODICITY | Time Period for the Aggregation | nvarchar | 4 | 0 | | |
10 | UMM_FR107 | Frames: Graphic - Legend | 12 | YTD_PERIODICITY | Time Period for the Aggregation | nvarchar | 4 | 0 | | |
11 | UMM_FR110 | Frames:Graphics Assignment | 12 | YTD_PERIODICITY | Time Period for the Aggregation | nvarchar | 4 | 0 | | |