| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | NNL_ZH308_V9_R02 | ZH308 V09 Record02 Soll Daten | 14 | NNAMS | | nvarchar | 25 | 0 | | |
| TOPClinical System |
| 2 | N1PRPAT | IS-H*MED: PATREG: Patientenstammdatentabelle | 7 | NNAMS | IS-H: Standartlasmis soyad | nvarchar | 80 | 0 | | |
| 3 | N1PRPIX | IS-H*MED: PATREG: Tabelle für phonetische Suche | 3 | NNAMS | IS-H: Standartlasmis soyad | nvarchar | 80 | 0 | | |
| 4 | N1PRTMPPAT | IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle | 8 | NNAMS | IS-H: Standartlasmis soyad | nvarchar | 80 | 0 | | |
| 5 | N1PRTMPPATLOC | IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal | 8 | NNAMS | IS-H: Standartlasmis soyad | nvarchar | 80 | 0 | | |
| TOPPatient Management |
| 6 | NPAP | IS-H: Provisional Patient Master Data | 4 | NNAMS | IS-H: Standardized Last Name | nvarchar | 80 | 0 | | |
| 7 | NPAPIX | IS-H: Preregistered Patient Name Index | 2 | NNAMS | IS-H: Standardized Last Name | nvarchar | 80 | 0 | | |
| 8 | NPAT | IS-H: Patient Master Data (General) | 6 | NNAMS | IS-H: Standardized Last Name | nvarchar | 80 | 0 | | |
| 9 | NPIX | IS-H: Patient name index | 2 | NNAMS | IS-H: Standardized Last Name | nvarchar | 80 | 0 | | |
| 10 | NTMN | IS-H: Patient-Specific Appointments (Header Table for NAPP) | 17 | NNAMS | IS-H: Standardized Last Name | nvarchar | 80 | 0 | | |
| 11 | NWAN | IS-H: Bad Debt Parties | 5 | NNAMS | IS-H: Standardized Last Name | nvarchar | 80 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 12 | NLVERZF_010 | Aufmachung patient name in Vektis format | 3 | NNAMS | IS-H: Gestandaardiseerde achternaam | nvarchar | 1 | 0 | | |
| 13 | NPSPAT | IS-H: Pseudonymized Patient Master Data (General) | 5 | NNAMS | IS-H: Standardized Last Name | nvarchar | 80 | 0 | | |
| 14 | NPSPIX | IS-H: Index of Pseudonymized Patient Names | 2 | NNAMS | IS-H: Standardized Last Name | nvarchar | 80 | 0 | | |
