| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | SFTT_EQUIT | Equipment Operating Statuses | 4 | STXT | Operating Status Description | nvarchar | 30 | 0 | | |
2 | TTS_QUALT | Personnel qualification in TTS(Texts) | 4 | STXT | Descriptive Short Text | nvarchar | 40 | 0 | | |
3 | TTS_WCCST | TTS: Selection Fields for Data Transfer (Texts) | 4 | STXT | Descriptive Short Text | nvarchar | 40 | 0 | | |
TOPBalanced Scorecard |
4 | UMB_BC_OB101 | Strategy Elements: Texts (Business Content) | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
5 | UMB_BC_PE101 | Perspectives: Texts (Business Content) | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
6 | UMB_BC_ST101 | Strategies: Texts (Business Content) | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
7 | UMB_CI101 | General Initiatives: Texts | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
8 | UMB_CO101 | General Objectives: Texts | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
9 | UMB_CO103 | General Objectives: Measure Label Text | 7 | STXT | Short text | nvarchar | 15 | 0 | | |
10 | UMB_GS101 | Value Fields: Texts | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
11 | UMB_GS105T | Status: Texts | 4 | STXT | Short text | nvarchar | 15 | 0 | | |
12 | UMB_HI101 | Scorecard Hierarchy: Texts | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
13 | UMB_OB101 | Objectives: Texts | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
14 | UMB_PE101 | Perspectives : Texts | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
15 | UMB_SC101 | Scorecard: Texts | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
16 | UMB_SC181 | Scorecard: Texts for Initiatives | 7 | STXT | Short text | nvarchar | 15 | 0 | | |
17 | UMB_ST101 | Strategies: Texts | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
TOPClinical System |
18 | N1MEDS_DS01T | Medication: Text Table for Alternate Names for Search Fields | 4 | STXT | Medication: Character for Search Fields | nvarchar | 1 | 0 | | |
TOPCorporate Performance Monitor |
19 | UMC_GS120T | Assignment of Formula Result: Texts | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
20 | UMR_RI000T | Risk: Category Text Table | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
21 | UMR_RI010T | Risk: Group Text Table | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
22 | UMR_RI100T | Risk: Text Table | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
23 | UMR_RI140T | RMS: Risk-Reducing Activities (Text Table) | 8 | STXT | Short text | nvarchar | 15 | 0 | | |
24 | UMR_TL100T | Threat Level: Text Table | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
25 | UMV_HI101 | Value Driver Tree Hierarchy: Text Table | 4 | STXT | Short text | nvarchar | 15 | 0 | | |
26 | UMV_TR101 | Value Driver Tree: Text Table | 4 | STXT | Short text | nvarchar | 15 | 0 | | |
27 | UMV_VD101 | Obsolete: Value Drivers: Text Tables | 4 | STXT | Short text | nvarchar | 15 | 0 | | |
TOPIndustry-Specific Component Automotive |
28 | MGV_LAMASCRLAYOU | LAMA Screen Fields | 35 | STXT | Text | nvarchar | 132 | 0 | | |
TOPLogbook |
29 | DIACL_LOG_ENTRY | Logbook: log entry | 3 | STXT | Logbook: log entry short text | nvarchar | 40 | 0 | | |
TOPManagement Cockpit |
30 | UMM_CO103 | Cockpits: Texts | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
31 | UMM_CO105 | Cockpits: Texts for the Hierarchy Nodes | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
32 | UMM_FR103 | Frames: Texts | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
33 | UMM_LV102 | Logical Views: Texts | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
34 | UMM_VA101 | Variables: Texts | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
35 | UMM_WA102 | Walls: Texts | 6 | STXT | Short text | nvarchar | 15 | 0 | | |
TOPMedical Rounds |
36 | TN1BALANCETYPET | i.s.h.med: Fluid Balancing, Inflow/Outflow Types, Text Table | 4 | STXT | i.s.h.med: Balancing, Inflow/Outflow Type Short Name | nvarchar | 15 | 0 | | |
TOPMessages |
37 | DNOC_FUNC_PART | Partner func. | 5 | STXT | Partner Function Short Text | nvarchar | 20 | 0 | | |
38 | DNOC_PRIORITYT | Priority Texts | 5 | STXT | Priority Short Text | nvarchar | 20 | 0 | | |
39 | DNOC_TYPE_NOTET | Note Types: Texts | 4 | STXT | Note Type Short Text | nvarchar | 20 | 0 | | |
40 | DNOC_TYPE_PART | Partner Categories: Texts | 4 | STXT | Partner Types Short Text | nvarchar | 20 | 0 | | |
41 | DNOC_TYPE_TEXTT | Text Segment Types: Texts | 5 | STXT | Text Segment Type Short Text | nvarchar | 20 | 0 | | |
TOPProduction Allocation |
42 | GHO_SIMU_H_T | Simulation Header Language Dependent Texts | 5 | STXT | Simulation Description | nvarchar | 40 | 0 | | |
TOPWork Clearance Management |
43 | WCAAP | WCM: Application | 6 | STXT | Descriptive Short Text | nvarchar | 40 | 0 | | |
44 | WCACG | WCM: WCM Object <-> Catalog | 8 | STXT | Descriptive Short Text | nvarchar | 40 | 0 | | |
45 | WCACGQ | WCM: Log (WCM Object <-> Catalog) | 9 | STXT | Descriptive Short Text | nvarchar | 40 | 0 | | |
46 | WCAHE | WCM: Work Clearance Document (Header) | 6 | STXT | Descriptive Short Text | nvarchar | 40 | 0 | | |
47 | WCAIT | WCM: Work Clearance Document (Item) | 11 | STXT | Descriptive Short Text | nvarchar | 40 | 0 | | |
48 | WCAJ | WCM: Lineup | 4 | STXT | Descriptive Short Text | nvarchar | 40 | 0 | | |
49 | WCAK | WCM: Verification List (Header Data) | 5 | STXT | Descriptive Short Text | nvarchar | 40 | 0 | | |
50 | WCAME | WCM: (Temporary) Log of Operational Lists (Items) | 13 | STXT | Descriptive Short Text | nvarchar | 40 | 0 | | |
51 | WCAMI | WCM: Log of Operational Lists (Items) | 13 | STXT | Descriptive Short Text | nvarchar | 40 | 0 | | |
52 | WCAW | WCM: Work Approval | 5 | STXT | Descriptive Short Text | nvarchar | 40 | 0 | | |
53 | WCCLT | WCM: Print (Texts) | 6 | STXT | Descriptive Short Text | nvarchar | 40 | 0 | | |
54 | WCCOGT | WCM: WCM Object (General Texts) | 5 | STXT | Description of WCM Object | nvarchar | 40 | 0 | | |
55 | WCCOT | WCM: WCM Object (Texts) | 6 | STXT | Description of WCM Object | nvarchar | 40 | 0 | | |
56 | WCCST | WCM: Selection Fields for Data Transfer (Texts) | 4 | STXT | Descriptive Short Text | nvarchar | 40 | 0 | | |
57 | WCCUT | WCM: Use of Work Clearance Document (Texts) | 6 | STXT | Description of WCM Object | nvarchar | 40 | 0 | | |
58 | WCCXT | WCM: Use of Work Approval (Texts) | 6 | STXT | Description of WCM Object | nvarchar | 40 | 0 | | |
59 | WCCYT | WCM: Use of Application (Texts) | 6 | STXT | Description of WCM Object | nvarchar | 40 | 0 | | |