| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBalanced Scorecard |
| 1 | UMB_SC100 | Scorecard: Header Table | 27 | OWNTYPE | User Type | nvarchar | 1 | 0 | | |
| 2 | UMB_SC113 | Scorecard: Perspective Assignment (Time-Dependent) | 6 | OWNTYPE | User Type | nvarchar | 1 | 0 | | |
| 3 | UMB_SC120 | Scorecard: Strategy Assignment (Time-Dependent) | 6 | OWNTYPE | User Type | nvarchar | 1 | 0 | | |
| 4 | UMB_SC150 | Scorecard: Objective Assignment (Time-Dependent) | 6 | OWNTYPE | User Type | nvarchar | 1 | 0 | | |
| 5 | UMB_SC160 | Scorecard: Measure Assignment (Time-Dependent) | 6 | OWNTYPE | User Type | nvarchar | 1 | 0 | | |
| 6 | UMB_SC180 | Scorecard: Initiatives | 19 | OWNTYPE | User Type | nvarchar | 1 | 0 | | |
| 7 | UMB_SC300 | Owner Variable | 6 | OWNTYPE | User Type | nvarchar | 1 | 0 | | |
| 8 | UMB_WIZARD102 | Default Settings for Each User. Used by BSC Wizard | 6 | OWNTYPE | User Type | nvarchar | 1 | 0 | | |
| TOPCorporate Performance Monitor |
| 9 | UMV_TR106 | Value Driver Tree: Responsible Person | 6 | OWNTYPE | User Type | nvarchar | 1 | 0 | | |
| 10 | UMV_TR227 | Value Driver Tree: Responsible Persons for Measures | 7 | OWNTYPE | User Type | nvarchar | 1 | 0 | | |
