| 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 | 12 | YEAR_SHIFT | Fiscal Year Offset | int | 10 | 0 | | |
2 | UMB_MC107 | Scorecard: BW Variables for the Value Fields of a Measure | 12 | YEAR_SHIFT | Fiscal Year Offset | int | 10 | 0 | | |
3 | UMB_SC196 | Scorecard: BW Variables for Value Fields of an Initiative | 12 | YEAR_SHIFT | Fiscal Year Offset | int | 10 | 0 | | |
TOPCorporate Performance Monitor |
4 | UMC_TM100 | Time Variable | 7 | YEAR_SHIFT | Fiscal Year Offset | int | 10 | 0 | | |
5 | UMR_RF101 | RMS: Measure-Risk Value Fields Selection Criteria | 15 | YEAR_SHIFT | Fiscal Year Offset | int | 10 | 0 | | |
6 | UMR_RF103 | RMS: Measure-Risk Value Fields BW Variables | 15 | YEAR_SHIFT | Fiscal Year Offset | int | 10 | 0 | | |
7 | UMR_RI117 | RMS: Measure Weight Data Selection - Selections - NOT USED | 12 | YEAR_SHIFT | Fiscal Year Offset | int | 10 | 0 | | |
8 | UMV_TR113 | Obsolete: Value Driver Tree: Selections for the Value Fields | 12 | YEAR_SHIFT | Fiscal Year Offset | int | 10 | 0 | | |
9 | UMV_TR213 | Value Driver Tree: Selections for the Value Fields | 12 | YEAR_SHIFT | Fiscal Year Offset | int | 10 | 0 | | |
TOPManagement Cockpit |
10 | UMM_FR115 | Frame: Replacement of BW Variables | 11 | YEAR_SHIFT | Fiscal Year Offset | int | 10 | 0 | | |