| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | N2N3AF01 | PDOK: N3AFRM01 HI: Ergotherapy | 13 | N3A_PATPLZ | Postal Code | nvarchar | 10 | 0 | | |
| 2 | N2N3AF02 | PDOK: N3AFRM02 HI: Medication Prescription ph Procedures | 13 | N3A_PATPLZ | Postal Code | nvarchar | 10 | 0 | | |
| 3 | N2N3AF03 | PDOK: N3AFRM03 HI: Work Incapacity Certificate | 22 | N3A_PATPLZ | Postal Code | nvarchar | 10 | 0 | | |
| 4 | N2N3AF04 | PDOK: N3AFRM04 HI: Emergency Substitution Certificate | 17 | N3A_PATPLZ | Postal Code | nvarchar | 10 | 0 | | |
| 5 | N2N3AF05 | PDOK: N3AFRM05 HI: Prescription (Health Insurance Fund) | 15 | N3A_PATPLZ | Postal Code | nvarchar | 10 | 0 | | |
| 6 | N2N3AF06 | PDOK: N3AFRM06 HI: Prescription (Private) | 13 | N3A_PATPLZ | Postal Code | nvarchar | 10 | 0 | | |
| 7 | N2N3AF07 | PDOK: N3AFRM07 HI: Referral Certificate | 24 | N3A_PATPLZ | Postal Code | nvarchar | 10 | 0 | | |
| 8 | N2N3AF08 | PDOK: N3AFRM08 HI: Referral Certificate for Lab | 13 | N3A_PATPLZ | Postal Code | nvarchar | 10 | 0 | | |
| 9 | N2N3AF09 | PDOK: N3AFRM09 HI: Prescription for Patient Transportation | 34 | N3A_PATPLZ | Postal Code | nvarchar | 10 | 0 | | |
| 10 | N2N3AF10 | PDOK: N3AFRM10 HI: Prescription for Home Nursing Care | 18 | N3A_PATPLZ | Postal Code | nvarchar | 10 | 0 | | |
| 11 | N2N3AF11 | PDOK: N3AFRM11 HI: Prescription for Hospital Treatment | 19 | N3A_PATPLZ | Postal Code | nvarchar | 10 | 0 | | |
| 12 | N2N3AF12 | PDOK: N3AFRM12 HI: Med. Cert. for Sick Pay in the Event of | 13 | N3A_PATPLZ | Postal Code | nvarchar | 10 | 0 | | |
