| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBasic Data |
| 1 | TNKFA | IS-H: Code Specialties | 9 | UNQCD | IS-H: Unique Code for Assigning External Codes | nvarchar | 3 | 0 | | |
| TOPPatient Management |
| 2 | TN14B | IS-H: Movement types | 25 | UNQCD | IS-H: Unique Code for Assigning External Codes | nvarchar | 3 | 0 | | |
| 3 | TN14G | IS-H: Movement Reasons (EDI) | 5 | UNQCD | IS-H: Unique Code for Assigning External Codes | nvarchar | 3 | 0 | | |
| 4 | TN14H | IS-H: Referral Types | 5 | UNQCD | IS-H: Unique Code for Assigning External Codes | nvarchar | 3 | 0 | | |
| 5 | TN14M | IS-H: Treatment Program | 4 | UNQCD | IS-H: Unique Code for Assigning External Codes | nvarchar | 3 | 0 | | |
| 6 | TN14O | IS-H: Surgery Types | 4 | UNQCD | IS-H: Unique Code for Assigning External Codes | nvarchar | 3 | 0 | | |
| 7 | TN15D | IS-H: Case End Data | 4 | UNQCD | IS-H: Unique Code for Assigning External Codes | nvarchar | 3 | 0 | | |
| 8 | TN15H | IS-H: Choice of Ward Class | 4 | UNQCD | IS-H: Unique Code for Assigning External Codes | nvarchar | 3 | 0 | | |
