| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | TNNL_HT_THESAURS | Diagnose Thesaurus Diagnose Konzepte | 3 | BEGINDATE | Beginndatum | nvarchar | 8 | 0 | | |
| 2 | TNNL_KT_DBC | Diagnose Thesaurus Beziehung DBC Kode | 4 | BEGINDATE | Beginndatum | nvarchar | 8 | 0 | | |
| 3 | TNNL_KT_DOMEINEN | Domänen | 4 | BEGINDATE | Beginndatum | nvarchar | 8 | 0 | | |
| 4 | TNNL_KT_ICD10 | Diagnose Thesaurus Beziehung ICD10 Kode | 4 | BEGINDATE | Beginndatum | nvarchar | 8 | 0 | | |
| 5 | TNNL_RT_DBC | Diagnose Thesaurus Beziehung DBC | 4 | BEGINDATE | Beginndatum | nvarchar | 8 | 0 | | |
| 6 | TNNL_RT_ICD10 | Diagnose Thesaurus Beziehung ICD10 | 3 | BEGINDATE | Beginndatum | nvarchar | 8 | 0 | | |
| 7 | T7PIQ_NL_ADMREQ | Admission Requirements | 7 | BEGINDATE | Start Date | nvarchar | 8 | 0 | | |
| 8 | T7PIQ_NL_EDUC | Education Details | 3 | BEGINDATE | Start Date | nvarchar | 8 | 0 | | |
| 9 | T7PIQ_NL_EDUPGM | Educational Program Details | 8 | BEGINDATE | Start Date | nvarchar | 8 | 0 | | |
| 10 | T7PIQ_NL_INSBRIN | BRIN Number of the Institute | 4 | BEGINDATE | Start Date | nvarchar | 8 | 0 | | |
| 11 | T7PIQ_NL_INSTIT | Institutes and Education Details | 4 | BEGINDATE | Start Date | nvarchar | 8 | 0 | | |
| 12 | T7PIQ_NL_LOTDRAW | Application period second lottery drawing | 6 | BEGINDATE | Start Date | nvarchar | 8 | 0 | | |
| 13 | T7PIQ_NL_PREEDUC | Previous Education Details | 3 | BEGINDATE | Start Date | nvarchar | 8 | 0 | | |
| 14 | T7PIQ_NL_SUB | Subjects | 4 | BEGINDATE | Start Date | nvarchar | 8 | 0 | | |
| TOPScripting |
| 15 | CRMD_IC_SCRATTR | Script/Survey attributes (Interactive Script Editor) | 5 | BEGINDATE | Date | nvarchar | 8 | 0 | | |
