azq_global_element_info_list

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	//SQLite data types: https://www.sqlite.org/datatype3.html
2	//wget -O azq_global_element_info_list.csv https://docs.google.com/spreadsheets/d/1ddl-g_qyoMYLF8PMkjrYPrpXusdinTZxsWLQOzJ6xu8/export?format=csv
3	id	var_name	csharp_oldname	db_table	var_type	db_type	val_min	val_max	n_arg_max	name	expiry (millis)	definition	category	omit_param_check

4	1	general_time		general_time	DateTime		0	0	1	Time			Other
5	2	mos_score		mos_score	Double	double	0	5	1	legacy MOS Score			Voice
6	3	polqa_delay_variance_millis		mos_score	Double	double	0	2000	1	legacy POLQA Delay Variance (ms.)			Voice
7	10	polqa_mos		polqa_mos	Double	double	1	4.5	1	POLQA MOS score for voice calls	13000	POLQA voice call mean opinion score	Voice
8	4	visqol_mos		polqa_mos	Double	double	0	5	1	ViSQOL MOS Score for voice calls		https://github.com/google/visqol	Voice
9	11	polqa_output_filename		polqa_mos	String	text				voice mos output or degraded wav filename			Voice
10	12	polqa_output_text		polqa_mos	String	text				voice mos full text output			Voice
11	5	ott_voice_mos_downlink		ott_voice_mos	Double	double	0	5		MOS Score for ott voice/audio downlink			ott
12	6	ott_voice_mos_downlink_details		ott_voice_mos	String	text				MOS Score details for ott voice/audio downlink			ott
13	7	ott_voice_mos_uplink		ott_voice_mos	Double	double	0	5		MOS Score for ott voice/audio uplink			ott
14	8	ott_voice_mos_uplink_details		ott_voice_mos	String	text				MOS Score details for ott voice/audio uplink			ott
15	101	internal_messageinfo		azq_internal_types	String	text	0	0	1	Message Info			Other
16	102	device_timestamp		azq_internal_types	QCDateTime		0	0	1	Device Time Stamp			Other
17	103	raw_layer_msg		azq_internal_types	QCDiagPkt		0	0	1	Raw/binary Layer-3 message			Other
18	104	processed_event		detected_radio_event	String	text							Other
19	105	azq_db_calls_row_meta_id		voicecall	String	text	0	0	1	Azq DB Calls Row Meta id		CSV of a completed voice call stats	Voice
20	106	raw_pkt_backup		azq_internal_types	QCDiagPktBackup								Other
21	107	l3_msg_desc		azq_internal_types	L3MsgDesc		0	0	1	l3_msg_desc			Other
22	108	unused_legacy_l3_msg_string		azq_internal_types	String	text							Other
23	109	azqgui_meta_cmd		azq_internal_types	String	text							Other
24	110	azqgui_meta_cmd_resp		azq_internal_types	String	text							Other
25	111	azqml_file_pos_info		azq_internal_types	Double	double							Other
26	112	unused_legacy_l3_cc_disconnect_info		azq_internal_types	String	text							Other
27	113	internal_crop_indoor_map		log_info	Integer	smallint	0	0	1	Crop Indoor Map			Test Log Information
28	114	internal_time_shift		log_info	Integer	smallint	0	0	1	Internal_Time_Shift			Test Log Information
29	115	atrl3_decoded_txt		azq_internal_types	QCDiagPkt	text				atrl3_txt_desc			Other
30	116	floor_name		log_info	String	text	0	0	1	Floor_name			Test Log Information
31	117	questionnaire		azq_internal_types	String	text	0	0	1	Questionnaire			Other
32	118	modem_timestamp		azq_internal_types	QCDateTime								Other
33	119	os_timestamp		azq_internal_types	QCDateTime								Other
34	120	msg_code		log_decode_message	String	text			1				Other
35	121	msg_name		log_decode_message	String	text			1				Other
36	122	msg_version		log_decode_message	Integer	int			1				Other
37	123	msg_id_code		log_decode_message	Integer	int			1				Other
38	124	msg_id_ver		log_decode_message	Integer	int			1				Other
39	201	point_name		location	String	text	0	0	1	Point_Name		The name of point user input while marking an indoor gps.	Location
40	202	script_name		log_info	String	varchar(255)	0	0	1	Script_Name		Script name of current test.	Test Log Information
41	203	distance		location	Double	double	0	10000	1	Distance		Sum of distance during the test. Calculated from gps. (km)	Location
42	204	operator_name		android_info_2sec	String	varchar(32)	0	0	1	Operator Name		Operator name sim card connected to.	Other
43	205	script		log_info	String	text	0	0	1	Script		The script used in the test (in XML format).	Test Log Information
44	206	phonemodel		log_info	String	varchar(255)	0	0	1	Phone Model		Model name of testing devices.	Test Log Information
45	207	gladiator_dtconfig		gladiator	String	text	0	0	1	Gladiator DTConfig			Other
46	208	mobile_ip		android_info_2sec	String	text	0	0	1	Mobile IP			Other
47	209	signal_strength_api		signal_strength_api	Integer	smallint	-140	0	1	Signal Strength API			Other
48	210	line_id_detail		line	String	text	0	0	1	LINE ID Detail			Other
49	211	http_dl_all_session_throughput_avg		unused_for_phone_live_display_only	Double	double	0	3000000	1	HTTP DL Throughput Avg			HTTP
50	212	http_ul_all_session_throughput_avg		unused_for_phone_live_display_only	Double	double	0	3000000	1	HTTP UL Throughput Avg			HTTP
51	213	ftp_dl_all_session_throughput_avg		unused_for_phone_live_display_only	Double	double	0	3000000	1	FTP DL Throughput Avg			FTP
52	214	ftp_ul_all_session_throughput_avg		unused_for_phone_live_display_only	Double	double	0	3000000	1	FTP UL Throughput Avg			FTP
53	215	browse_all_session_throughput_avg		unused_for_phone_live_display_only	Double	double	0	3000000	1	Browse Throughput Avg			Browse
54	216	statement_number		statement	Integer	smallint	0	1000	1	Statement Nubmer			Other
55	217	battery_mah_remaining		android_info_1sec	Double	double	0	50000	1	Battery mAh Remaining			Other
56	218	mtu_size		log_info	Integer	smallint	0	5000	1	MTU Size			Test Log Information
57	219	tablet_uuid		log_info	String	text	0	0	1	Tablet UUID			Test Log Information
58	220	tablet_mac_address		log_info	String	text	0	0	1	Tablet MAC Address			Test Log Information
59	221	tablet_start_script_time		log_info	DateTime	datetime	0	0	1	Tablet Start Script Time			Test Log Information
60	222	speedtest_download_throughput		speedtest	Double	double	0	3000000		Speedtest Download Throughput
61	223	speedtest_upload_throughput		speedtest	Double	double	0	3000000		Speedtest Upload Throughput
62	224	speedtest_max_download_throughput		speedtest	Double	double	0	3000000		Speedtest Max Download Throughput
63	225	speedtest_max_upload_throughput		speedtest	Double	double	0	3000000		Speedtest Max Upload Throughput
64	226	mobile_ip_v6		android_info_2sec	String	text	0	0	1	Mobile IPv6			Other
65	227	speedtest_jitter		speedtest	Double	double	0	1000		Speedtest Jitter
66	228	speedtest_latency		speedtest	Double	double	1	10000		Speedtest Latency
67	251	speedtest_server_id		speedtest	Integer	smallint				speedtest_server_id
68	252	speedtest_server_name		speedtest	String	text				speedtest_server_name
69	253	speedtest_internal_ip		speedtest	String	text				speedtest_internal_ip
70	254	speedtest_external_ip		speedtest	String	text				speedtest_external_ip
71	255	speedtest_version		speedtest	String	text				speedtest_version
72	256	speedtest_session_id		speedtest	String	text	0	0	1	speedtest_session_id		Unique session id for testing speedtestcum at https://azenqos.speedtestcustom.com/	Application test
73	257	speedtest_connection_mode		speedtest	String	text				speedtest_connection_mode
74	258	speedtest_test_id		speedtest	String	text				speedtest_test_id
75	232	log_start_time		logs	DateTime								Test Log Information
76	233	log_end_time		logs	DateTime								Test Log Information
77	234	log_tag		logs	String								Test Log Information
78	235	log_ori_file_name		logs	String								Test Log Information
79	236	log_app_version		logs	String								Test Log Information
80	237	log_license_edition		logs	String								Test Log Information
81	238	log_required_pc_version		logs	String								Test Log Information
82	239	log_timezone_offset		logs	String								Test Log Information
83
84
85
86
87
88
89	261	line_session_id		line	String	text	0	0	1	line_session_id			Other
90	262	roaming_status		android_info_2sec	Integer	smallint	0	1	1	Android Roaming Status			Other
91	263	radio_param_technology		android_info_2sec	String	text				Radio Param Technology			Other
92	301	ambient_temperature		environment	Double	double			1	Ambient air temperature			Sensor
93	302	Illuminance		environment	Double	double			1	Illuminance			Sensor
94	303	ambient_air_pressure		environment	Double	double			1	Ambient air pressure			Sensor
95	304	ambient_relative_humidity		environment	Double	double			1	Ambient relative humidity			Sensor
96	305	device_temperature		environment	Double	double			1	Device temperature (Deprecated)			Sensor
97	306	thermal_zone_temperature		environment	Double	double			8	Thermal zone temperature			Sensor
98	307	thermal_zone_average		environment	Double	double			1	Average thermal zone temperature			Sensor
99	311	acceleration_x		motion	Double	double			1	Acceleration force along the x axis			Sensor
100	312	acceleration_y		motion	Double	double			1	Acceleration force along the y axis			Sensor