Temperature & VVM

temperature_breach

Field number	Field Name	Description	Type	Length	Index
4	end_date	Date
5	end_time	Time
1	ID	Alpha	Y
6	location_ID	Alpha
2	start_date	Date
3	start_time	Time
7	store_ID	Alpha
8	temperature_breach_config_ID	Alpha

temperature_breach_config

Field number	Field Name	Description	Type	Length	Index
5	colour	Alpha
6	description	Alpha
4	duration	Long Integer
1	ID	Alpha	Y
2	maximum_temperature	Real
3	minimum_temperature	Real

temperature_log

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

vaccine_vial_monitor_status

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

vaccine_vial_monitor_status_log

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