| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPGreat Britain |
| 1 | T5G40 | National Insurance Earnings Ranges (obsolete: old NI) | 6 | EARNR | NIC Earnings Range | nvarchar | 3 | 0 | | |
| 2 | T5G41 | National Insurance Percentage Rates (obsolete: old NI) | 2 | EARNR | NIC Earnings Range | nvarchar | 3 | 0 | | |
| TOPPatient Management |
| 3 | N1VKG | IS-H: Item of Clinical Order (Preregistration) | 15 | EARNR | IS-H: Referring Physician | nvarchar | 10 | 0 | | |
| 4 | NPAT | IS-H: Patient Master Data (General) | 91 | EARNR | IS-H: Personnel Number of Referring Physician | nvarchar | 10 | 0 | | |
