| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | N1PRPAT | IS-H*MED: PATREG: Patientenstammdatentabelle | 9 | VNAMS | IS-H: Standartlasmis ad | nvarchar | 80 | 0 | | |
| 2 | N1PRPIX | IS-H*MED: PATREG: Tabelle für phonetische Suche | 7 | VNAMS | IS-H: Standartlasmis ad | nvarchar | 80 | 0 | | |
| 3 | N1PRTMPPAT | IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle | 10 | VNAMS | IS-H: Standartlasmis ad | nvarchar | 80 | 0 | | |
| 4 | N1PRTMPPATLOC | IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal | 10 | VNAMS | IS-H: Standartlasmis ad | nvarchar | 80 | 0 | | |
| TOPPatient Management |
| 5 | NPAP | IS-H: Provisional Patient Master Data | 6 | VNAMS | Standardized First Name | nvarchar | 80 | 0 | | |
| 6 | NPAPIX | IS-H: Preregistered Patient Name Index | 7 | VNAMS | Standardized First Name | nvarchar | 80 | 0 | | |
| 7 | NPAT | IS-H: Patient Master Data (General) | 8 | VNAMS | Standardized First Name | nvarchar | 80 | 0 | | |
| 8 | NPIX | IS-H: Patient name index | 7 | VNAMS | Standardized First Name | nvarchar | 80 | 0 | | |
| 9 | NTMN | IS-H: Patient-Specific Appointments (Header Table for NAPP) | 18 | VNAMS | Standardized First Name | nvarchar | 80 | 0 | | |
| 10 | NWAN | IS-H: Bad Debt Parties | 7 | VNAMS | Standardized First Name | nvarchar | 80 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 11 | NPSPAT | IS-H: Pseudonymized Patient Master Data (General) | 7 | VNAMS | Standardized First Name | nvarchar | 80 | 0 | | |
| 12 | NPSPIX | IS-H: Index of Pseudonymized Patient Names | 7 | VNAMS | Standardized First Name | nvarchar | 80 | 0 | | |
