| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPPatient Accounting |
| 1 | NCIR | IS-H: Insurance Relationships of a Case | 22 | VERNN | Last Name of Insured Person | nvarchar | 30 | 0 | | |
| 2 | NPIR | IS-H: Insurance Relationship Proposal Pool | 21 | VERNN | Last Name of Insured Person | nvarchar | 30 | 0 | | |
| TOPPatient Management |
| 3 | NVVP | IS-H: Patient-related insurance relationship | 12 | VERNN | Last Name of Insured Person | nvarchar | 30 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 4 | NWATKSAHV | IS-H AT: Erweiterung NKSA um Hauptversichertendaten | 4 | VERNN | IS-H: Nachname des Versicherten | nvarchar | 30 | 0 | | |
| 5 | NWAT_GIN_STATIR | IS-H AT: Versicherungsstatus des Patienten | 12 | VERNN | IS-H: Nachname des Versicherten | nvarchar | 30 | 0 | | |
| 6 | NWAT_GIN_STATIR2 | IS-H AT: Versicherungsstatus Familienmitglieder | 7 | VERNN | IS-H: Nachname des Versicherten | nvarchar | 30 | 0 | | |
