| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | N1PRPAT | IS-H*MED: PATREG: Patientenstammdatentabelle | 84 | PASSNR | IS-H: Kimlik belgesi no. | nvarchar | 15 | 0 | | |
| 2 | N1PRTMPPAT | IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle | 85 | PASSNR | IS-H: Kimlik belgesi no. | nvarchar | 15 | 0 | | |
| 3 | N1PRTMPPATLOC | IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal | 85 | PASSNR | IS-H: Kimlik belgesi no. | nvarchar | 15 | 0 | | |
| TOPPatient Accounting |
| 4 | NEHC_PAT | IS-H: Health Insurance Card (Patient Data) | 52 | PASSNR | IS-H: Identification Document Number | nvarchar | 15 | 0 | | |
| TOPPatient Management |
| 5 | NPAP | IS-H: Provisional Patient Master Data | 18 | PASSNR | IS-H: Identification Document Number | nvarchar | 15 | 0 | | |
| 6 | NPAT | IS-H: Patient Master Data (General) | 96 | PASSNR | IS-H: Identification Document Number | nvarchar | 15 | 0 | | |
