This is an old revision of the document!
| Field number | Field Name | Description | Type | Length | Index |
| 4 | end_date | Date that the breach ended | Date | | |
| 5 | end_time | Time in seconds since midnight that the breach ended | Time | | |
| 1 | ID | Unique ID of this record | Alpha | | Y |
| 6 | location_ID | | Alpha | | |
| 2 | start_date | Date that the breach started | Date | | |
| 3 | start_time | Time in seconds since midnight that the breach started | Time | | |
| 7 | store_ID | The ID of the store (facility) | Alpha | | |
| 8 | temperature_breach_config_ID | The id of the temperature_breach_config record that applied | Alpha | | |
| Field number | Field Name | Description | Type | Length | Index |
| 5 | colour | | Alpha | | |
| 6 | description | | Alpha | | |
| 4 | duration | How long (in minutes) out of temperature range before it is considered a breach | Long Integer | | |
| 1 | ID | | Alpha | | Y |
| 2 | maximum_temperature | Maximum acceptable temperature in degrees Celcius | Real | | |
| 3 | minimum_temperature | Minimum acceptable temperature in degrees Celcius | Real | | |
| Field number | Field Name | Description | Type | Length | Index |
| 3 | date | | Date | | |
| 1 | ID | | Alpha | | Y |
| 5 | location_ID | | Alpha | | |
| 7 | store_ID | | Alpha | | |
| 2 | temperature | | Real | | Y |
| 6 | temperature_breach_ID | | Alpha | | |
| 4 | time | | Time | | |
| Field number | Field Name | Description | Type | Length | Index |
| 3 | code | | Alpha | | |
| 2 | description | | Alpha | | |
| 1 | ID | | Alpha | | Y |
| 5 | is_active | | Boolean | | |
| 4 | level | | Long Integer | | |
| Field number | Field Name | Description | Type | Length | Index |
| 3 | date | | Date | | |
| 1 | ID | | Alpha | | Y |
| 5 | item_line_ID | | Alpha | | |
| 2 | status_ID | | Alpha | | |
| 6 | store_ID | | Alpha | | |
| 4 | time | | Time | | |