Disclaimer

This is a documentation of the internal LaMPS SQL database. The database structure may be subject to change without prior announcement.

Vendor-specific details follow the notation #<communication object no>[.<bit position>]. Please consult technical product documentation for details.

Table lamps_test_result_latest

Common fields

col#	name	description
1	id	test result id
2	date	timestamp of receiving the result
3	test_id	FK to lamps_test
4	device_id	FK to lamps_device
5	test_type	0: regular DALI test 1: function test 2: part. duration test 3: duration test 4: battery test 255: not supported

Fields related to regular DALI tests

col#	name	description	ABB DG/S 1.1	ABB DG/Sx.64.1.1	ABB DGN/S1.16.1	EAE, Legrand, DA 110	Insta, Gira, Hager, Jung, Eelectron	HDL	Ipas, MDT, Merten, Schneider, B.E.G.	Siemens N 141/02	Siemens N 141/03, /21, /31, Legrand	Zennio
6	test_succeeded	the gateway responded within the configured device time				#3.8 or gw timeout
7	fault_ballast		#16	#21.9	#20.9	#3.9	#1544.9	non-disclosed	#ES.7	#11.7	#37.9	#11.9
8	fault_lamp		#15	#21.8	#20.8	#3.10	#1544.8	non-disclosed	#ES.6	#11.6	#37.8	#11.8
11	fault_converter		N/A	#21.10	#20.10	N/A	#1544.10	N/A	N/A	N/A	#37.10	N/A

#ES: Error status communication object. Refer to documentation of the used gateway version for the specific CO#.

Fields related to DALI emergency test

col#	name	description	ABB DG/Sx.64.1.1	ABB DGN/S1.16.1	EAE, Legrand, DA 110	Insta, Gira, Hager, Jung, Eelectron	Ipas, MDT, Merten, Schneider, B.E.G.	Siemens N 141/02	Siemens N 141/03, /21, /31, Legrand
9	test_fault	emergency test failed	#42.11	#33.11	N/A	#432.3	#CTR.3	#147.3	#608.3
10	fault_battery		#42.17	#33.17	#3.14	#432.9	#CTR.9	#147.9	#608.9
11	fault_converter		#42.16	#33.16	#3.16	#432.8	#CTR.8	#147.8	#608.8
12	fault_emergency_light		#42.19	#33.19	N/A	#432.11	#CTR.11	#147.11	#608.11
13	battery_defect		#42.18	#33.18	#3.15	#432.10	#CTR.10	#147.10	#608.10
14	function_test_failed		#42.22	#33.22	#3.17	#432.14	#CTR.14	#147.14	#608.14
15	duration_test_failed		#42.23	#33.23	#3.18	#432.15	#CTR.15	#147.15	#608.15
16	max_time_function_test_exceeded		#42.20	#33.20	N/A	#432.12	#CTR.12	#147.12	#608.12
17	max_time_duration_test_exceeded		#42.21	#33.21	N/A	#432.13	#CTR.13	#147.13	#608.13
18	value	quantitative test result	#42.24-31	#33.24-31	N/A	#432.16-23	#CTR.16-23	#147.16-23	#608.16-23

#CTR: Converter test result communication object. Refer to documentation of the used gateway version for the specific CO#.

Browser not supported