| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBalanced Scorecard |
| 1 | UMB_BC_OB100 | Strategy Elements: Header Table (Business Content) | 4 | PERS | Technical Name of Perspective | nvarchar | 10 | 0 | | |
| 2 | UMB_BC_PE100 | Perspectives: Header Table (Business Content) | 2 | PERS | Technical Name of Perspective | nvarchar | 10 | 0 | | |
| 3 | UMB_BC_PE101 | Perspectives: Texts (Business Content) | 3 | PERS | Technical Name of Perspective | nvarchar | 10 | 0 | | |
| 4 | UMB_CO100 | General Objectives: Header Table | 5 | PERS | Technical Name of Perspective | nvarchar | 10 | 0 | | |
| 5 | UMB_OB100 | Objectives: Header Table | 4 | PERS | Technical Name of Perspective | nvarchar | 10 | 0 | | |
| 6 | UMB_PE100 | Perspectives: Header Table | 2 | PERS | Technical Name of Perspective | nvarchar | 10 | 0 | | |
| 7 | UMB_PE101 | Perspectives : Texts | 3 | PERS | Technical Name of Perspective | nvarchar | 10 | 0 | | |
| 8 | UMB_SC108 | Scorecard: Perspectives : BIC Selections | 3 | PERS | Technical Name of Perspective | nvarchar | 10 | 0 | | |
| 9 | UMB_SC109 | Scorecard: Perspectives: Assigned BW Queries | 3 | PERS | Technical Name of Perspective | nvarchar | 10 | 0 | | |
| 10 | UMB_SC112 | Scorecard: Perspective Assignment | 3 | PERS | Technical Name of Perspective | nvarchar | 10 | 0 | | |
| 11 | UMB_SC113 | Scorecard: Perspective Assignment (Time-Dependent) | 3 | PERS | Technical Name of Perspective | nvarchar | 10 | 0 | | |
| 12 | UMB_SC201 | Scorecard: Perspective Score & A&C BDS Doc ID | 3 | PERS | Technical Name of Perspective | nvarchar | 10 | 0 | | |
| TOPBasic Data |
| 13 | NGPA | IS-H: Business Partners | 41 | PERS | IS-H: Text Designating the EMPLOYEE Function | nvarchar | 1 | 0 | | |
