| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2RB_NAME | Payroll Results: Name of Employee | 9 | GBNAM | Second Name | nvarchar | 40 | 0 | | |
| 2 | P2RD_NAME | Payroll Results: Name of Employee | 9 | GBNAM | Second Name | nvarchar | 40 | 0 | | |
| TOPClinical System |
| 3 | N1PRPAT | IS-H*MED: PATREG: Patientenstammdatentabelle | 15 | GBNAM | IS-H: Kizlik soyadi | nvarchar | 30 | 0 | | |
| 4 | N1PRTMPPAT | IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle | 16 | GBNAM | IS-H: Kizlik soyadi | nvarchar | 30 | 0 | | |
| 5 | N1PRTMPPATLOC | IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal | 16 | GBNAM | IS-H: Kizlik soyadi | nvarchar | 30 | 0 | | |
| TOPPatient Accounting |
| 6 | NEHC_PAT | IS-H: Health Insurance Card (Patient Data) | 35 | GBNAM | IS-H: Birthname | nvarchar | 30 | 0 | | |
| TOPPatient Management |
| 7 | NPAP | IS-H: Provisional Patient Master Data | 7 | GBNAM | IS-H: Birthname | nvarchar | 30 | 0 | | |
| 8 | NPAT | IS-H: Patient Master Data (General) | 14 | GBNAM | IS-H: Birthname | nvarchar | 30 | 0 | | |
| 9 | NTMN | IS-H: Patient-Specific Appointments (Header Table for NAPP) | 22 | GBNAM | IS-H: Birthname | nvarchar | 30 | 0 | | |
| 10 | NWAN | IS-H: Bad Debt Parties | 9 | GBNAM | IS-H: Birthname | nvarchar | 30 | 0 | | |
| TOPSAP Ambulatory Care Management |
| 11 | NREDOMA | IS-H: Table Renewable Documents - Header Data | 32 | GBNAM | IS-H: Birthname | nvarchar | 30 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 12 | NPSPAT | IS-H: Pseudonymized Patient Master Data (General) | 13 | GBNAM | IS-H: Birthname | nvarchar | 30 | 0 | | |
