| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClaims Management |
1 | ICLLITITEM | Litigation Level | 15 | EXTREF | External Reference of a Litigation Level | nvarchar | 20 | 0 | | |
2 | ICSLITITEM | Litigation Levels | 15 | EXTREF | External Reference of a Litigation Level | nvarchar | 20 | 0 | | |
TOPClinical System |
3 | N1FORMULARYXML | i.s.h.med: Medication; XML Sections for Drug | 9 | EXTREF | Medication: Key in External Catalog | nvarchar | 40 | 0 | | |
4 | N1MEIMPORT | i.s.h.med: Medication, Master Data Import Table | 10 | EXTREF | Medication: Key in External Catalog | nvarchar | 40 | 0 | | |
5 | TN1DEVICE | Medication: Administration Devices | 4 | EXTREF | Medication: ID in Referenced External Catalog - OBSOLETE | nvarchar | 40 | 0 | | |
6 | TN1DEVICEEXT | Medication: Administration Device External Key | 4 | EXTREF | Medication: Key in External Catalog | nvarchar | 40 | 0 | | |
7 | TN1EXTFAILURE | i.s.h.med: Medication; External Key for Import Error | 8 | EXTREF | Medication: Key in External Catalog | nvarchar | 40 | 0 | | |
8 | TN1EXTREF | i.s.h.med: Medication; External Key for Medication Data | 7 | EXTREF | Medication: Key in External Catalog | nvarchar | 40 | 0 | | |
9 | TN1FORMTYPE | IS-H*MED: Drug Types | 3 | EXTREF | Medication: Key in External Catalog | nvarchar | 40 | 0 | | |
10 | TN1LINTYP | IS-H*MED: Line Type | 3 | EXTREF | Medication: Key in External Catalog | nvarchar | 40 | 0 | | |
11 | TN1MELOC | IS-H*MED: Localization for Medication | 3 | EXTREF | Medication: ID in Referenced External Catalog - OBSOLETE | nvarchar | 40 | 0 | | |
12 | TN1MELOCEXT | i.s.h.med: Medication; Localization External Key | 4 | EXTREF | Medication: Key in External Catalog | nvarchar | 40 | 0 | | |
13 | TN1PHFORM | Medication: Dosage Form | 3 | EXTREF | Medication: ID in Referenced External Catalog - OBSOLETE | nvarchar | 40 | 0 | | |
14 | TN1PHFORMEXT | Medication: Dosage Form External Key | 4 | EXTREF | Medication: Key in External Catalog | nvarchar | 40 | 0 | | |
15 | TN1ROUTE | Medication: Administration Routes | 3 | EXTREF | Medication: ID in Referenced External Catalog - OBSOLETE | nvarchar | 40 | 0 | | |
16 | TN1ROUTEEXT | Medication: Administration Route External Key | 4 | EXTREF | Medication: Key in External Catalog | nvarchar | 40 | 0 | | |
TOPMaintenance Orders |
17 | T352R | Maintenance revisions | 26 | EXTREF | External Reference to Revision | nvarchar | 20 | 0 | | |