| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBalanced Scorecard |
| 1 | UMB_BU100 | BW Buffer (Cross-Application) | 5 | CASENO | BW Generation tool: GUID in compressed form (CHAR25) | nvarchar | 25 | 0 | | |
| TOPCorporate Performance Monitor |
| 2 | UMV_TR104 | Value Driver Tree: Value Combinations of Runtime Variables | 3 | CASENO | BW Generation tool: GUID in compressed form (CHAR25) | nvarchar | 25 | 0 | | |
| 3 | UMV_TR106 | Value Driver Tree: Responsible Person | 3 | CASENO | BW Generation tool: GUID in compressed form (CHAR25) | nvarchar | 25 | 0 | | |
| 4 | UMV_TR227 | Value Driver Tree: Responsible Persons for Measures | 3 | CASENO | BW Generation tool: GUID in compressed form (CHAR25) | nvarchar | 25 | 0 | | |
| 5 | UMV_TR231 | Value Driver Tree: Status, Assessments and Comments | 3 | CASENO | BW Generation tool: GUID in compressed form (CHAR25) | nvarchar | 25 | 0 | | |
| 6 | UMV_TR301 | Value Driver Tree: Default Values for Runtime Variables | 4 | CASENO | BW Generation tool: GUID in compressed form (CHAR25) | nvarchar | 25 | 0 | | |
| TOPManagement Cockpit |
| 7 | UMM_BU100 | Obsolete: Selections for Buffer of Transaction Data | 3 | CASENO | Counter | nvarchar | 6 | 0 | | |
| 8 | UMM_BU101 | Obsolete: Buffer of Transaction Data | 3 | CASENO | Counter | nvarchar | 6 | 0 | | |
| 9 | UMM_BU102 | Obsolete: Buffer of Transaction Data | 4 | CASENO | Counter | nvarchar | 6 | 0 | | |
| 10 | UMM_BU103 | Obsolete: Selections for Buffer of Transaction Data | 3 | CASENO | Counter | nvarchar | 6 | 0 | | |
| 11 | UMM_BU105 | Buffer of Transaction Data | 3 | CASENO | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
| 12 | UMM_BU106 | Selections for Buffer of Transaction Data | 3 | CASENO | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
| 13 | UMM_COBUF | Cockpit BW Buffer Case Number (For Runtime Variable) | 3 | CASENO | Counter | nvarchar | 6 | 0 | | |
| 14 | UMM_DFT_BICDATA | Default BIC Data for Frame | 6 | CASENO | Counter | nvarchar | 6 | 0 | | |
| 15 | UMM_DFT_CHART | Default BW Data for Cockpit Frame | 6 | CASENO | Counter | nvarchar | 6 | 0 | | |
| 16 | UMM_DFT_ERRMSG | Default Error Message for Frame | 6 | CASENO | Counter | nvarchar | 6 | 0 | | |
| 17 | UMM_DFT_LABEL | Default Chart Unit for Frame Graphics | 6 | CASENO | Counter | nvarchar | 6 | 0 | | |
| 18 | UMM_DFT_LEGDATA | Default Legacy Data for Frame BW Data | 6 | CASENO | Counter | nvarchar | 6 | 0 | | |
| 19 | UMM_DFT_LEGSTUC | Table: Default Legacy Structure for Cockpit | 6 | CASENO | Counter | nvarchar | 6 | 0 | | |
| 20 | UMM_DFT_Q_RANGE | Default Value Range for 4 Quadrants | 6 | CASENO | Counter | nvarchar | 6 | 0 | | |
| 21 | UMM_DFT_T_RANGE | Default Value Range for Tachometer | 6 | CASENO | Counter | nvarchar | 6 | 0 | | |
| 22 | UMM_ST100 | Status of the Frames in the Cockpits | 4 | CASENO | Counter | nvarchar | 6 | 0 | | |
| 23 | UMM_ST101 | Selections for Status of the Frames in the Cockpits | 4 | CASENO | Counter | nvarchar | 6 | 0 | | |
| 24 | UMM_ST102 | Status of the Frames in the Cockpits | 3 | CASENO | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 25 | NWCHLS_NFAL | IS-H CH: ALIS-Fehlerhandlung - Falldaten (für Fall-API) | 3 | CASENO | IS-H: numero episodio | nvarchar | 10 | 0 | | |
| 26 | NWCHLS_RETURN | IS-H CH: ALIS-Fehlerhandlung - Fehlermeldungen von APIs | 3 | CASENO | IS-H: numero episodio | nvarchar | 10 | 0 | | |
| 27 | NWCHLS_RNDIAFLAG | IS-H CH: ALIS-Fehlerhandlung - Diagnose zum Fall (RNDIAFLAG) | 3 | CASENO | IS-H: numero episodio | nvarchar | 10 | 0 | | |
| 28 | NWCHLS_RNLRG | IS-H CH: ALIS-Fehlerhandlung - Arztzuordnungen (RNLRG) | 3 | CASENO | IS-H: numero episodio | nvarchar | 10 | 0 | | |
| 29 | NWCHLS_RNLRZ | IS-H CH: ALIS-Fehlerhandlung - Leistungszuordnungen (RNLRZ) | 3 | CASENO | IS-H: numero episodio | nvarchar | 10 | 0 | | |
| 30 | NWCHLS_RNLRZE | IS-H CH: ALIS-Fehlerhandlung - externes System (RNLRZE_CH) | 3 | CASENO | IS-H: numero episodio | nvarchar | 10 | 0 | | |
| 31 | NWCHLS_RNLRZM | IS-H CH: ALIS-Fehlerhandlung - Zeitmarken (RNLRZM) | 3 | CASENO | IS-H: numero episodio | nvarchar | 10 | 0 | | |
| 32 | NWCHLS_RNLSR | IS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR) | 3 | CASENO | IS-H: numero episodio | nvarchar | 10 | 0 | | |
