| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | N2N3AF01 | PDOK: N3AFRM01 HI: Ergotherapy | 8 | N3A_KKNUM | Health Insurer No. | nvarchar | 15 | 0 | | |
| 2 | N2N3AF02 | PDOK: N3AFRM02 HI: Medication Prescription ph Procedures | 8 | N3A_KKNUM | Health Insurer No. | nvarchar | 15 | 0 | | |
| 3 | N2N3AF03 | PDOK: N3AFRM03 HI: Work Incapacity Certificate | 9 | N3A_KKNUM | Health Insurer No. | nvarchar | 15 | 0 | | |
| 4 | N2N3AF04 | PDOK: N3AFRM04 HI: Emergency Substitution Certificate | 12 | N3A_KKNUM | Health Insurer No. | nvarchar | 15 | 0 | | |
| 5 | N2N3AF05 | PDOK: N3AFRM05 HI: Prescription (Health Insurance Fund) | 8 | N3A_KKNUM | Health Insurer No. | nvarchar | 15 | 0 | | |
| 6 | N2N3AF06 | PDOK: N3AFRM06 HI: Prescription (Private) | 30 | N3A_KKNUM | Health Insurer No. | nvarchar | 15 | 0 | | |
| 7 | N2N3AF07 | PDOK: N3AFRM07 HI: Referral Certificate | 15 | N3A_KKNUM | Health Insurer No. | nvarchar | 15 | 0 | | |
| 8 | N2N3AF08 | PDOK: N3AFRM08 HI: Referral Certificate for Lab | 8 | N3A_KKNUM | Health Insurer No. | nvarchar | 15 | 0 | | |
| 9 | N2N3AF09 | PDOK: N3AFRM09 HI: Prescription for Patient Transportation | 29 | N3A_KKNUM | Health Insurer No. | nvarchar | 15 | 0 | | |
| 10 | N2N3AF10 | PDOK: N3AFRM10 HI: Prescription for Home Nursing Care | 12 | N3A_KKNUM | Health Insurer No. | nvarchar | 15 | 0 | | |
| 11 | N2N3AF11 | PDOK: N3AFRM11 HI: Prescription for Hospital Treatment | 12 | N3A_KKNUM | Health Insurer No. | nvarchar | 15 | 0 | | |
| 12 | N2N3AF12 | PDOK: N3AFRM12 HI: Med. Cert. for Sick Pay in the Event of | 8 | N3A_KKNUM | Health Insurer No. | nvarchar | 15 | 0 | | |
| 13 | N3KVKO | PMD: N3KV:KOPF KV: für Druck der Kopfdaten ins Formular | 8 | N3A_KKNUM | Krankenkassennummer | nvarchar | 15 | 0 | | |
| 14 | N3KVM01 | PMD: N3KVFRM01 KV: Arbeitsunfähigkeitsbescheinigung | 8 | N3A_KKNUM | Krankenkassennummer | nvarchar | 15 | 0 | | |
| 15 | N3KVM02 | PMD: N3KVMST02 KV: Verordnung von Krankenhausbehandlung | 10 | N3A_KKNUM | Krankenkassennummer | nvarchar | 15 | 0 | | |
| 16 | N3KVM04 | PMD: N3KVMST04 KV: Verordnung e. Krankenbeförderung (M4) | 9 | N3A_KKNUM | Krankenkassennummer | nvarchar | 15 | 0 | | |
| 17 | N3KVM06 | PMD: N3KVMST06 KV: Überweisungsschein Muster 06 | 9 | N3A_KKNUM | Krankenkassennummer | nvarchar | 15 | 0 | | |
| 18 | N3KVM10 | PMD: N3KVMST10 KV: Überweisungsschein Labor Muster 10 | 9 | N3A_KKNUM | Krankenkassennummer | nvarchar | 15 | 0 | | |
| 19 | N3KVM12 | PMD: N3KVMST12 KV: Verordnung häuslicher Krankenpflege M12 | 8 | N3A_KKNUM | Krankenkassennummer | nvarchar | 15 | 0 | | |
| 20 | N3KVM13 | PMD: N3KVMST13 KV:Heilmittelver. physikal. + podol. Ther | 8 | N3A_KKNUM | Krankenkassennummer | nvarchar | 15 | 0 | | |
| 21 | N3KVM16 | PMD: N3KVFRM16 KV: Rezept Verordnung Kasse | 9 | N3A_KKNUM | Krankenkassennummer | nvarchar | 15 | 0 | | |
| 22 | N3KVM18 | PMD: N3KVMST18 KV:Heilmittelver. Ergotherapieherapie KV | 8 | N3A_KKNUM | Krankenkassennummer | nvarchar | 15 | 0 | | |
| 23 | N3KVM19 | PMD: N3KVMST19 KV: Notfallvertretungsschein | 11 | N3A_KKNUM | Krankenkassennummer | nvarchar | 15 | 0 | | |
| 24 | N3KVM21 | PMD: N3KVMST21 KV: Ärztliche Besch. Krankengeld Kind | 8 | N3A_KKNUM | Krankenkassennummer | nvarchar | 15 | 0 | | |
| 25 | N3KVMPR | PMD: N3KVMSTPR KV: Rezept KV Muster priv | 8 | N3A_KKNUM | Krankenkassennummer | nvarchar | 15 | 0 | | |
