| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | T7RUDOMA | KLADR: Houses | 3 | KNAME | KLADR: House Name | nvarchar | 40 | 0 | | |
| 2 | T7RUKLADR | KLADR.DBF | 3 | KNAME | Character field of length 40 | nvarchar | 40 | 0 | | |
| 3 | T7RUSTREET | KLADR: Streets (buffer) | 3 | KNAME | Character field of length 40 | nvarchar | 40 | 0 | | |
| TOPActivation Program, Conversion Program, DB Utility, MC, SPDD |
| 4 | UKURS | Courses | 4 | KNAME | Course title | nvarchar | 30 | 0 | | |
| TOPBasic Data |
| 5 | NGPA | IS-H: Business Partners | 9 | KNAME | IS-H: Short Name of Business Partner | nvarchar | 12 | 0 | | |
| TOPPatient Management |
| 6 | NIPP | IS-H: Provisional Insurance Relationship of Preregistration | 7 | KNAME | IS-H: Insurance Relationship - Name of Health Insurer | nvarchar | 70 | 0 | | |
| TOPPayroll |
| 7 | T7TRG01 | General information about company. | 43 | KNAME | | nvarchar | 15 | 0 | | |
| TOPSAP Ambulatory Care Management |
| 8 | NKTR_KV | IS-H: Ins. Prov. Master acc. to Fed. PPA from PPA Bill.Syst. | 6 | KNAME | IS-H: Healthcare Smart Card - Health Insurer Name | nvarchar | 28 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 9 | NWAT_GIN_STATIR | IS-H AT: Versicherungsstatus des Patienten | 9 | KNAME | IS-H: Name des Kostenträgers | nvarchar | 100 | 0 | | |
| 10 | NWAT_GIN_STATIR2 | IS-H AT: Versicherungsstatus Familienmitglieder | 15 | KNAME | IS-H: Name des Kostenträgers | nvarchar | 100 | 0 | | |
| TOPSecure Network Communications |
| 11 | SNCSYSACL | SNC Access Control List (ACL): Systems | 21 | KNAME | SNC: Canonical name | varbinary | 1024 | 0 | | |
| 12 | USRACL | SNC Access Control List (ACL): User | 17 | KNAME | SNC: Canonical name | varbinary | 1024 | 0 | | |
| 13 | USRACLEXT | Extended SNC Access Control List (ACL) for Users | 17 | KNAME | SNC: Canonical name | varbinary | 1024 | 0 | | |
