| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClinical System |
1 | N1MEALERT | i.s.h.med: Drug Alerts | 31 | STTIM | IS-H: Cancellation Time | nvarchar | 6 | 0 | | |
2 | N1MEOACT | i.s.h.med: Medication, Order Activities | 23 | STTIM | IS-H: Cancellation Time | nvarchar | 6 | 0 | | |
3 | N1TMSTPDUR | i.s.h..med: Duration for Time Stamps | 18 | STTIM | Time of Cancellation | nvarchar | 6 | 0 | | |
4 | N1TPGCLA | i.s.h. med: Medication: Template Group - Classif. Code Asgmt | 15 | STTIM | IS-H: Cancellation Time | nvarchar | 6 | 0 | | |
5 | N1TPGDIAGA | i.s.h.med: Medication: Template Group - Diagnosis Assignment | 16 | STTIM | IS-H: Cancellation Time | nvarchar | 6 | 0 | | |
6 | N1TPGROUP | Medication: Order Template Group | 20 | STTIM | IS-H: Cancellation Time | nvarchar | 6 | 0 | | |
7 | N1TPGSTRUCA | i.s.h.med: Medication Template Group - Problem Assignment | 15 | STTIM | IS-H: Cancellation Time | nvarchar | 6 | 0 | | |
8 | N1TPMEORDER | IS-H*MED: Medication, Medication Order Template | 62 | STTIM | IS-H: Cancellation Time | nvarchar | 6 | 0 | | |
9 | N1TPODRUG | IS-H*MED: Medication, Drugs of Templates | 42 | STTIM | IS-H: Cancellation Time | nvarchar | 6 | 0 | | |
10 | N1TPORATE | IS-H*MED: Dosage Quantities of Template | 34 | STTIM | IS-H: Cancellation Time | nvarchar | 6 | 0 | | |
11 | N1TPTPGRA | IS-H*MED: Template - Template Group Assignment | 13 | STTIM | IS-H: Cancellation Time | nvarchar | 6 | 0 | | |
12 | N2CA_CORD_CARD | ISHMED: Data for Cardiology Order Component | 22 | STTIM | Deletion Time | nvarchar | 6 | 0 | | |
13 | N2CA_CORD_ECG | ISHMED: Data for ECG Order Component | 23 | STTIM | Deletion Time | nvarchar | 6 | 0 | | |
14 | N2CA_CORD_HCAT | ISHMED: Data for Cardiac Catheter Order Component | 33 | STTIM | Deletion Time | nvarchar | 6 | 0 | | |
15 | N2CA_CORD_HCAT_I | ISHMED: Interventions for Cardiac Catheter Order Component | 14 | STTIM | Deletion Time | nvarchar | 6 | 0 | | |
16 | N2CLIM_OBSVS | Vital Signs: Examination | 32 | STTIM | IS-H: Cancellation Time | nvarchar | 6 | 0 | | |
17 | N2CLIM_PLDVS | Vital Signs: Definite Planned Measurement (with Time) | 25 | STTIM | IS-H: Cancellation Time | nvarchar | 6 | 0 | | |
18 | N2CLIM_SDLVS | Vital Signs: Measurement Plan for Patient (Cycles) | 25 | STTIM | IS-H: Cancellation Time | nvarchar | 6 | 0 | | |
19 | N2CLIM_VALVS | Vital Signs: Measured Values | 38 | STTIM | IS-H: Cancellation Time | nvarchar | 6 | 0 | | |
20 | N2MV_ADRART | Address Type Control Table | 14 | STTIM | Deletion Time | nvarchar | 6 | 0 | | |
21 | N2MV_EMTYP | Recipient Type Control Table | 15 | STTIM | Deletion Time | nvarchar | 6 | 0 | | |
22 | N2MV_SCRMOD | Field Control Control Table | 43 | STTIM | Deletion Time | nvarchar | 6 | 0 | | |
23 | N2MV_VSDAT | Recipient Data Table | 51 | STTIM | Deletion Time | nvarchar | 6 | 0 | | |
24 | N2MV_VSVOR | Presetting Control Table | 24 | STTIM | Deletion Time | nvarchar | 6 | 0 | | |
25 | N2MV_VSWEG | Dispatch Route Control Table | 15 | STTIM | Deletion Time | nvarchar | 6 | 0 | | |
TOPGermany |
26 | T5D4X_STAT | Status - Admin. Contrib. Statmt Certificates E-Mail Proc. | 9 | STTIM | Last Changed At | nvarchar | 6 | 0 | | |
TOPGlobal Trade Services |
27 | /SAPSLL/CORSTH | Chronological Status of a Document | 9 | STTIM | Status Time | nvarchar | 6 | 0 | | |
TOPPatient Management |
28 | N1VKG | IS-H: Item of Clinical Order (Preregistration) | 81 | STTIM | Time of Cancellation | nvarchar | 6 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
29 | NWAT_EDI_KOM | IS-H AT: EDI Kommentar (K12) | 30 | STTIM | IS-H AT: EDI Stornozeit | nvarchar | 6 | 0 | | |
30 | NWAT_SCO_WIKRAF | IS-H AT: Scoring - manuelle Eingabe der V01-Daten | 17 | STTIM | Uhrzeit der Stornierung | nvarchar | 6 | 0 | | |