Subject: Database Compare Log
From: [email-masked]
To: [email-masked]
Date: Thu, 27 Oct 2016 12:28:56 +0800

[2016-10-27 12:28:48]	INFO	db4- dsn:mysql:host=localhost;dbname=grandtag_i;charset:utf8;[2016-10-27 12:28:48]	INFO	MIGA_i- dsn:mysql:host=172.16.10.9;dbname=grandtag_i;charset:utf8;[2016-10-27 12:28:48]	INFO	 sale_figure_ap (db4)  Versus  sale_figure_ap (MIGA_i)[2016-10-27 12:28:48]	WARNING	PK(ref 7) FK() "written_case": 4 | 3[2016-10-27 12:28:48]	WARNING	PK(ref 7) FK() "written_premium": 24000.00 | 12000.00[2016-10-27 12:28:48]	WARNING	PK(ref 7) FK() "written_ytd_case": 32 | 31[2016-10-27 12:28:48]	WARNING	PK(ref 7) FK() "written_ytd_premium": 152250.00 | 140250.00[2016-10-27 12:28:48]	WARNING	PK(ref 7) FK() "submit_ytd_case": 33 | 32[2016-10-27 12:28:48]	WARNING	PK(ref 7) FK() "submit_ytd_premium": 154650.00 | 142650.00[2016-10-27 12:28:48]	WARNING	PK(ref 284) FK() "submit_case": 4 | 5[2016-10-27 12:28:48]	WARNING	PK(ref 284) FK() "submit_premium": 59589.77 | 69589.82[2016-10-27 12:28:48]	WARNING	PK(ref 308) FK() "written_ytd_premium": 302716.41 | 302716.40[2016-10-27 12:28:48]	WARNING	PK(ref 322) FK() "written_premium": 52500.00 | 52499.99[2016-10-27 12:28:48]	WARNING	PK(ref 322) FK() "pending_premium": 52500.00 | 52499.99[2016-10-27 12:28:48]	WARNING	PK(ref 356) FK() "written_ytd_premium": 46359.39 | 46359.40[2016-10-27 12:28:48]	WARNING	PK(ref 390) FK() "written_premium": 15553.76 | 15553.77[2016-10-27 12:28:48]	WARNING	PK(ref 390) FK() "written_ytd_premium": 147613.21 | 147613.22[2016-10-27 12:28:48]	WARNING	PK(ref 409) FK() "written_case": 58 | 55[2016-10-27 12:28:48]	WARNING	PK(ref 409) FK() "written_premium": 558529.30 | 512529.10[2016-10-27 12:28:48]	WARNING	PK(ref 409) FK() "written_ytd_case": 100 | 97[2016-10-27 12:28:48]	WARNING	PK(ref 409) FK() "written_ytd_premium": 1242614.67 | 1196614.46[2016-10-27 12:28:48]	WARNING	PK(ref 409) FK() "pending_case": 100 | 97[2016-10-27 12:28:48]	WARNING	PK(ref 409) FK() "pending_premium": 1242614.67 | 1196614.46[2016-10-27 12:28:48]	WARNING	PK(ref 413) FK() "written_ytd_premium": 114076.96 | 114076.97[2016-10-27 12:28:48]	WARNING	PK(ref 413) FK() "last2_mtd": 59494.86 | 59494.87[2016-10-27 12:28:48]	WARNING	PK(ref 902) FK() "written_ytd_premium": 24837.12 | 24837.11[2016-10-27 12:28:48]	WARNING	PK(ref 902) FK() "submit_ytd_premium": 24837.12 | 24837.11[2016-10-27 12:28:48]	WARNING	PK(ref 1098) FK() "written_case": 5 | 4[2016-10-27 12:28:48]	WARNING	PK(ref 1098) FK() "written_premium": 36000.00 | 30000.00[2016-10-27 12:28:48]	WARNING	PK(ref 1098) FK() "written_ytd_case": 8 | 7[2016-10-27 12:28:48]	WARNING	PK(ref 1098) FK() "written_ytd_premium": 50400.00 | 44400.00[2016-10-27 12:28:48]	WARNING	PK(ref 1098) FK() "pending_case": 1 | 0[2016-10-27 12:28:48]	WARNING	PK(ref 1098) FK() "pending_premium": 6000.00 | 0.00[2016-10-27 12:28:48]	WARNING	PK(ref 1340) FK() "submit_ytd_premium": 133729.48 | 133729.49[2016-10-27 12:28:48]	INFO	Excluded Fields: update_time,update_date[2016-10-27 12:28:48]	INFO	No Of Records:[2016-10-27 12:28:48]	INFO	Range From:[2016-10-27 12:28:48]	INFO	Range To:[2016-10-27 12:28:48]	INFO	Total Compared Record Count: 1369[2016-10-27 12:28:48]	INFO	Status: Complete with Record Difference[2016-10-27 12:28:48]	INFO	Total Data Mismatch Count: 31