| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RU_GRORD | Payroll Results: Garnishment for US Order | 33 | YTD | Year to date | decimal | 11 | 2 | | |
2 | P2RU_GRREC | Payroll Results: Garnishment for US Record | 17 | YTD | Year to date | decimal | 11 | 2 | | |
TOPBalanced Scorecard |
3 | UMB_MC100 | Scorecard: Measure Value Fields | 15 | YTD | Aggregation | nvarchar | 1 | 0 | | |
4 | UMB_MC101 | Scorecard: Characteristics for the Value Fields of a Measure | 14 | YTD | Aggregation | nvarchar | 1 | 0 | | |
5 | UMB_SC193 | Scorecard: BW Key Figure Values of an Initiative | 10 | YTD | Aggregation | nvarchar | 1 | 0 | | |
6 | UMB_SC194 | Scorecard: Characteristics for BW Key Figs of an Initiative | 12 | YTD | Aggregation | nvarchar | 1 | 0 | | |
TOPCorporate Performance Monitor |
7 | UMR_RF100 | RMS: Measure-Risk Value Fields | 17 | YTD | Aggregation | nvarchar | 1 | 0 | | |
8 | UMR_RF101 | RMS: Measure-Risk Value Fields Selection Criteria | 17 | YTD | Aggregation | nvarchar | 1 | 0 | | |
9 | UMR_RI116 | RMS: Measure Weight Data Selection - NOT USED | 13 | YTD | Aggregation | nvarchar | 1 | 0 | | |
10 | UMR_RI117 | RMS: Measure Weight Data Selection - Selections - NOT USED | 14 | YTD | Aggregation | nvarchar | 1 | 0 | | |
11 | UMV_TR112 | Obsolete: Value Driver Tree: Value Fields of a Value Driver | 13 | YTD | Aggregation | nvarchar | 1 | 0 | | |
12 | UMV_TR113 | Obsolete: Value Driver Tree: Selections for the Value Fields | 14 | YTD | Aggregation | nvarchar | 1 | 0 | | |
13 | UMV_TR212 | Value Driver Tree: Value Fields or Measure | 13 | YTD | Aggregation | nvarchar | 1 | 0 | | |
14 | UMV_TR213 | Value Driver Tree: Selections for the Value Fields | 14 | YTD | Aggregation | nvarchar | 1 | 0 | | |
TOPManagement Cockpit |
15 | UMM_BU101 | Obsolete: Buffer of Transaction Data | 11 | YTD | Aggregation | nvarchar | 1 | 0 | | |
16 | UMM_BU102 | Obsolete: Buffer of Transaction Data | 8 | YTD | Aggregation | nvarchar | 1 | 0 | | |
17 | UMM_BU105 | Buffer of Transaction Data | 8 | YTD | Aggregation | nvarchar | 1 | 0 | | |
18 | UMM_CO102 | Cockpits: Assignment of Variables with Selection Conditions | 10 | YTD | Aggregation | nvarchar | 1 | 0 | | |
19 | UMM_FR101 | Frames: Dimensions | 12 | YTD | Aggregation | nvarchar | 1 | 0 | | |
20 | UMM_FR107 | Frames: Graphic - Legend | 11 | YTD | Aggregation | nvarchar | 1 | 0 | | |
21 | UMM_FR110 | Frames:Graphics Assignment | 11 | YTD | Aggregation | nvarchar | 1 | 0 | | |