Data_Upload

	Data Update SQL QRY: Select * FROM Dim_MeterRechargeInvestigateActivityDashBoard WHERE PrincipalNumber='99887775'
		Today: 2025-10-02

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	66	66	0	66	0	0	2	51	2	0	11	0	0	0	0	0	0	0	0	0	12	53	60	0	0	0	0	59	27	27	43	22	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	33	66	0	0	0	0	0	0	0	0	0	99	Oct 2 2025 3:29AM	Oct 3 2025 3:29AM	Oct 2 2025 3:29AM	Oct 3 2025 3:29AM

List Database