| 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 | | |