| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBasic Data |
| 1 | NGPA | IS-H: Business Partners | 24 | ORT2 | District of Business Partner | nvarchar | 25 | 0 | | |
| 2 | TN01 | IS-H: Institutions | 10 | ORT2 | IS-H: District of the Institution's Address | nvarchar | 25 | 0 | | |
| TOPClinical System |
| 3 | N1PRPAT | IS-H*MED: PATREG: Patientenstammdatentabelle | 40 | ORT2 | IS-H: Semt | nvarchar | 40 | 0 | | |
| 4 | N1PRTMPPAT | IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle | 41 | ORT2 | IS-H: Semt | nvarchar | 40 | 0 | | |
| 5 | N1PRTMPPATLOC | IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal | 41 | ORT2 | IS-H: Semt | nvarchar | 40 | 0 | | |
| TOPPatient Management |
| 6 | NADR | IS-H: Addresses (Central Address Management) | 8 | ORT2 | IS-H: District | nvarchar | 40 | 0 | | |
| 7 | NPAT | IS-H: Patient Master Data (General) | 31 | ORT2 | Patient District | nvarchar | 25 | 0 | | |
| 8 | NWAN | IS-H: Bad Debt Parties | 15 | ORT2 | IS-H: District of bad debt party | nvarchar | 25 | 0 | | |
