Tide Data-set fields can be one of nine different Data Types. These Data Types automatically drive what Data Type Validation occurs during Transformation.
The table below lists out the different Data Types, alongside a description and how they are held within the Tide Data Warehouse.
| Data Type | Description | Data Warehouse SQL Data Type |
| String | General text. No specific limitation on data length. | NVARCHAR(MAX) |
| Integer | Whole number. Can be positive or negative, however some Data Fields will have range restrictions (e.g. 0 < Signed Line >= 100). | INTEGER |
| Money | A monetary amount, expressed without Currency symbol. 2 decimal place precision. | MONEY |
| Decimal | A decimal amount. Up-to 5 decimal places. | DECIMAL(18,5) |
| Percentage | A decimal amount. Up-to 5 decimal places. | DECIMAL(18,7) |
| Boolean | A boolean value, standardised to a True or False position (although the on-screen display may show Y/N, True/False, 1/0 depending on the Data Field). Boolean fields in Tide are treated as Reference Data, visit Data Validation - Boolean Data Type for further details. | BOOLEAN |
| Date | A date value without a time component. Tide will convert any valid representation of date and time (e.g. UK vs US) into a standard date and time format. | DATETIME2 |
| DateTime | A date value with a time component. Tide will convert any valid representation of date (e.g. UK vs US) into a standard date format. | DATETIME2 |
| Reference | A reference data value with a prescribed set of values. | NVARCHAR(MAX) |