| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBalanced Scorecard |
1 | UMB_SC100 | Scorecard: Header Table | 9 | STATGEN | Type of Status Determination | nvarchar | 1 | 0 | | |
2 | UMB_SC103 | Scorecard: Measure Assignment | 5 | STATGEN | Type of Status Determination | nvarchar | 1 | 0 | | |
3 | UMB_SC104 | Scorecard: Strategy Assignment | 4 | STATGEN | Type of Status Determination | nvarchar | 1 | 0 | | |
4 | UMB_SC105 | Scorecard: Objective Assignment | 5 | STATGEN | Type of Status Determination | nvarchar | 1 | 0 | | |
5 | UMB_SC112 | Scorecard: Perspective Assignment | 6 | STATGEN | Type of Status Determination | nvarchar | 1 | 0 | | |
6 | UMB_SC180 | Scorecard: Initiatives | 24 | STATGEN | Type of Status Determination | nvarchar | 1 | 0 | | |
7 | UMB_WIZARD102 | Default Settings for Each User. Used by BSC Wizard | 12 | STATGEN | Type of Status Determination | nvarchar | 1 | 0 | | |
TOPCorporate Performance Monitor |
8 | UMV_TR210 | Value Driver Tree: Used Measures | 6 | STATGEN | Type of Status Determination | nvarchar | 1 | 0 | | |