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