| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClaims Management |
| 1 | ICLDIAGNOSIS | Diagnoses Made | 25 | GUARANTEE | Diagnostic Certainty | nvarchar | 1 | 0 | | |
| 2 | ICSDIAGNOSIS | Diagnoses | 25 | GUARANTEE | Diagnostic Certainty | nvarchar | 1 | 0 | | |
| 3 | TICL363 | Diagnostic Certainty | 2 | GUARANTEE | Diagnostic Certainty | nvarchar | 1 | 0 | | |
| 4 | TICL363T | Text for Diagnostic Certainty | 3 | GUARANTEE | Diagnostic Certainty | nvarchar | 1 | 0 | | |
| TOPTravel Planning |
| 5 | FTPT_CAR | Travel Request Item - Car Rental Service | 32 | GUARANTEE | Guarantee for rental care reservation at booking | nvarchar | 40 | 0 | | |
| 6 | FTPT_HOTEL | Travel Request Item - Hotel Service | 27 | GUARANTEE | Guarantee for room reservation at booking | nvarchar | 40 | 0 | | |
| 7 | TA20NH | Negotiated hotel rates (corporate nego rates) | 17 | GUARANTEE | Guarantee for room reservation at booking | nvarchar | 40 | 0 | | |
| 8 | TA20NHS | Negotiated Hotel Rates (Nego Rates) with Catalog Hotel | 15 | GUARANTEE | Guarantee for room reservation at booking | nvarchar | 40 | 0 | | |
