Data_Upload

	Data Update SQL QRY: Select * FROM Dim_MeterRechargeInvestigateActivityDashBoard WHERE PrincipalNumber='99887775'
		Today: 2026-04-01

List Database
ID	PRINCIPALKEY	PRINCIPALNAME	PRINCIPALNUMBER	LEVEL	METERSTOTAL	METERSDISPLAYED	METERSHIDDEN	ELECTRICITY	WATER	GAS	ALERTSCORE_0_0	ALERTSCORE_1_4	ALERTSCORE_5_8	ALERTSCORE_9_12	ALERTSCORE_13_16	ALERTSCORE_17_20	ALERTSCORE_21_1000	PUSHALERTS	DAYSSINCERECHARGEABOVE_7	DAYSSINCERECHARGEABOVE_14	DAYSSINCERECHARGEABOVE_21	DAYSSINCERECHARGEABOVE_30	DAYSSINCERECHARGEABOVE_45	DAYSSINCERECHARGEABOVE_60	DAYSSINCERECHARGEABOVE_90	DAYSSINCERECHARGEABOVE_0	COMMABSENCEDAYSABOVE_2	COMMABSENCEDAYSABOVE_3	COMMABSENCEDAYSABOVE_4	COMMABSENCEDAYSABOVE_5	COMMABSENCEDAYSABOVE_6	COMMABSENCEDAYSABOVE_7	METEREVENTSALERTAWAKE	METEREVENTSALERTNET	FLOWINTERRUPTED	FLOWNORMAL	LOGSCREATED_0_0	LOGSCREATED_1_1	LOGSCREATED_2_2	LOGSCREATED_3_3	LOGSCREATED_4_4	LOGSCREATED_5_5	LOGSCREATED_6_6	LOGSCREATED_7_29	LOGSCREATED_30_90	LOGSCLOSED_0_0	LOGSCLOSED_1_1	LOGSCLOSED_2_2	LOGSCLOSED_3_3	LOGSCLOSED_4_4	LOGSCLOSED_5_5	LOGSCLOSED_6_6	LOGSCLOSED_7_29	LOGSCLOSED_30_90	PRIORITY_0_0	PRIORITY_1_10	PRIORITY_11_20	PRIORITY_21_30	PRIORITY_31_40	PRIORITY_41_50	PRIORITY_51_60	PRIORITY_61_70	PRIORITY_71_80	PRIORITY_81_90	PRIORITY_91_100	FREQUENCYAUPDATED	FREQUENCYANEXTUPDATE	FREQUENCYBUPDATED	FREQUENCYBNEXTUPDATE	PRINCIPALBALANCE	TENANTBALANCE
	160824	Ideal Smart meters test	99887775	4	85	85	0	84	1	0	1	62	2	0	20	0	0	0	0	0	0	0	0	0	12	73	79	0	2	0	0	77	26	26	47	36	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	39	85	0	0	0	0	0	0	0	0	0	99	Apr 1 2026 4:03AM	Apr 2 2026 4:03AM	Apr 1 2026 4:03AM	Apr 2 2026 4:03AM

List Database