reportDate

ratio

endQuaterAffected

dayFrom

dayTo

Cusip

entryId	groupId	EQUITY	CHANGE	CUSIP	DESCRIPTION	ISSUE STATUS CODE	ISSUE TYPE CODE	ADD DATE	EXPIRATION DATE	PAYMENT FREQUENCY CODE	MARGIN FLAG	OPTION FLAG	CONVERTED CUSIP	NASDAQ MARKET CODE	INDEX ISSUER	CHANGE DATE	MERGENT CHANGE DATE	MATURE DATE	undefined1	undefined2	undefined3	undefined4	temp1	temp2	fileName	fileDate	processDate
5591345	5591345	DIVIDEND	DELETE	69367P106		B	0	1	5	.321876		39	2024-06-13	2024-06-13	2024-07-15	2024-06-03		0	2024-06-03	?	0	0006927674			20240701.ifs	2024-07-01	2024-07-02
5591346	5591346	DIVIDEND	ADD	69367P106		B	0	1	0	.318165		02	2024-06-13	2024-06-13	2024-07-15	2024-06-03		1	2024-06-03	2024-07-01	0	0006927674			20240701.ifs	2024-07-01	2024-07-02
5567852	5567852	DIVIDEND	ADD	69367P106		B	0	1	5	.321876		39	2024-06-13	2024-06-13	2024-07-15	2024-06-03		0	2024-06-03	?	0	0006927674			20240603.ifs	2024-06-03	2024-06-04
5327816	5327816	DIVIDEND	DELETE	69367P106		B	0	1	5	.328921		39	2023-06-14	2023-06-15	2023-07-13	2023-06-05		0	2023-06-05	?	0	0006736645			20230703.ifs	2023-07-03	2023-07-04
5327817	5327817	DIVIDEND	ADD	69367P106		B	0	1	0	.329466		02	2023-06-14	2023-06-15	2023-07-12	2023-06-05		1	2023-06-05	2023-07-03	0	0006736645			20230703.ifs	2023-07-03	2023-07-04
5306907	5306907	DIVIDEND	ADD	69367P106		B	0	1	5	.328921		39	2023-06-14	2023-06-15	2023-07-13	2023-06-05		0	2023-06-05	?	0	0006736645			20230605.ifs	2023-06-05	2023-06-06
5050374	5050374	DIVIDEND	DELETE	69367P106		B	0	1	5	.30253		39	2022-06-10	2022-06-13	2022-07-14	2022-06-02		0	2022-06-02	?	0	0006534670			20220701.ifs	2022-07-01	2022-07-02
5050375	5050375	DIVIDEND	ADD	69367P106		B	0	1	0	.294193		02	2022-06-10	2022-06-13	2022-07-14	2022-06-02		1	2022-06-02	2022-07-01	0	0006534670			20220701.ifs	2022-07-01	2022-07-02
5026378	5026378	DIVIDEND	ADD	69367P106		B	0	1	5	.30253		39	2022-06-10	2022-06-13	2022-07-14	2022-06-02		0	2022-06-02	?	0	0006534670			20220602.ifs	2022-06-02	2022-06-03
4401721	4401721	DIVIDEND	DELETE	69367P106		B	0	1	5	.092973		39	2020-06-05	2020-06-08	2020-07-02	2020-05-28		0	2020-05-28	?	0	0006102446			20200626.ifs	2020-06-26	2020-06-27
4401722	4401722	DIVIDEND	ADD	69367P106		B	0	1	0	.102088		02	2020-06-05	2020-06-08	2020-07-02	2020-05-28		1	2020-05-28	2020-06-26	0	0006102446			20200626.ifs	2020-06-26	2020-06-27
4351206	4351206	DIVIDEND	ADD	69367P106		B	0	1	5	.092973		39	2020-06-05	2020-06-08	2020-07-02	2020-05-28		0	2020-05-28	?	0	0006102446			20200528.ifs	2020-05-28	2020-05-29
4351219	4351219	DIVIDEND	ADD	69367P106		B	0	1	5	.092973		39	2020-06-05	2020-06-08	2020-07-02	2020-05-28		0	2020-05-28	?	0	0006102446			20200528.ifs	2020-05-28	2020-05-29
3740105	3740105	DIVIDEND	DELETE	69367P106		B	0	1	5	.140105		39	2019-05-09	2019-05-10	2019-06-11	2019-04-30		0	2019-04-30	?	0	0005875508			20190528.ifs	2019-05-28	2019-05-29
3740107	3740107	DIVIDEND	ADD	69367P106		B	0	1	0	.138112		02	2019-05-09	2019-05-10	2019-06-11	2019-04-30		1	2019-04-30	2019-05-28	0	0005875508			20190528.ifs	2019-05-28	2019-05-29
3740108	3740108	DIVIDEND	DELETE	69367P106		B	0	1	5	.140105		39	2019-05-09	2019-05-10	2019-06-11	2019-04-30		0	2019-04-30	?	0	0005875508			20190528.ifs	2019-05-28	2019-05-29
3740110	3740110	DIVIDEND	ADD	69367P106		B	0	1	0	.138112		02	2019-05-09	2019-05-10	2019-06-11	2019-04-30		1	2019-04-30	2019-05-28	0	0005875508			20190528.ifs	2019-05-28	2019-05-29
3701844	3701844	DIVIDEND	ADD	69367P106		B	0	1	5	.140105		39	2019-05-09	2019-05-10	2019-06-11	2019-04-30		0	2019-04-30	?	0	0005875508			20190430.ifs	2019-04-30	2019-05-01
3701845	3701845	DIVIDEND	ADD	69367P106		B	0	1	5	.140105		39	2019-05-09	2019-05-10	2019-06-11	2019-04-30		0	2019-04-30	?	0	0005875508			20190430.ifs	2019-04-30	2019-05-01
3126830	3126830	DIVIDEND	DELETE	69367P106		B	0	1	5	.067419		39	2018-05-18	2018-05-21	2018-06-05	2018-05-08		0	2018-05-08	?	0	0005659646			20180604.ifs	2018-06-04	2018-06-05
3126832	3126832	DIVIDEND	ADD	69367P106		B	0	1	0	.068262		02	2018-05-18	2018-05-21	2018-06-13	2018-05-08		1	2018-05-08	2018-06-04	0	0005659646			20180604.ifs	2018-06-04	2018-06-05
3126853	3126853	DIVIDEND	DELETE	69367P106		B	0	1	5	.067419		39	2018-05-18	2018-05-21	2018-06-05	2018-05-08		0	2018-05-08	?	0	0005659646			20180604.ifs	2018-06-04	2018-06-05
3126855	3126855	DIVIDEND	ADD	69367P106		B	0	1	0	.068262		02	2018-05-18	2018-05-21	2018-06-13	2018-05-08		1	2018-05-08	2018-06-04	0	0005659646			20180604.ifs	2018-06-04	2018-06-05
3083755	3083755	DIVIDEND	ADD	69367P106		B	0	1	5	.067419		39	2018-05-18	2018-05-21	2018-06-05	2018-05-08		0	2018-05-08	?	0	0005659646			20180508.ifs	2018-05-08	2018-05-09
3084000	3084000	DIVIDEND	ADD	69367P106		B	0	1	5	.067419		39	2018-05-18	2018-05-21	2018-06-05	2018-05-08		0	2018-05-08	?	0	0005659646			20180508.ifs	2018-05-08	2018-05-09
2588632	2588632	DIVIDEND	DELETE	69367P106		B	0	1	5	.199048		39	2017-05-16	2017-05-18	2017-06-22	2017-05-08		0	2017-05-08	?	0	0005433859			20170612.ifs	2017-06-12	2017-06-13
2588633	2588633	DIVIDEND	ADD	69367P106		B	0	1	0	.198932		02	2017-05-16	2017-05-18	2017-06-22	2017-05-08		1	2017-05-08	2017-06-12	0	0005433859			20170612.ifs	2017-06-12	2017-06-13
2563694	2563694	DIVIDEND	ADD	69367P106		B	0	1	5	.199048		39	2017-05-16	2017-05-18	2017-06-22	2017-05-08		0	2017-05-08	?	0	0005433859			20170508.ifs	2017-05-08	2017-05-09
2466043	2466043	EQUITY	CHANGE	69367P106	ADR REPSTG 50 CL B SHS	0	0	2009-02-23	?	0	no	no		no		2009-02-23	?	?							20170126.ifs	2017-01-26	2017-01-27
2466044	2466043	EQUITY	CHANGE	69367P106	ADR REPSTG 50 CL B SHS	0	0	2009-02-23	?	1	no	no		no		2009-02-23	?	?							20170126.ifs	2017-01-26	2017-01-27
2196446	2196446	DIVIDEND	DELETE	69367P106		B	0	1	5	.245108		39	2016-04-20	2016-04-22	2016-05-27	2016-04-12		2	2016-04-12	2016-04-14	0	0005205096			20160513.ifs	2016-05-13	2016-05-14
2196447	2196447	DIVIDEND	ADD	69367P106		B	0	1	0	.24129		02	2016-04-20	2016-04-22	2016-05-27	2016-04-12		3	2016-04-12	2016-05-13	0	0005205096			20160513.ifs	2016-05-13	2016-05-14
2164160	2164160	DIVIDEND	DELETE	69367P106		B	0	1	5	.245108		39	?	2016-04-22	2016-05-27	2016-04-12		1	2016-04-12	2016-04-13	0	0005205096			20160414.ifs	2016-04-14	2016-04-15
2164161	2164161	DIVIDEND	ADD	69367P106		B	0	1	5	.245108		39	2016-04-20	2016-04-22	2016-05-27	2016-04-12		2	2016-04-12	2016-04-14	0	0005205096			20160414.ifs	2016-04-14	2016-04-15
2163212	2163212	DIVIDEND	ADD	69367P106		B	0	1	5	.245108		39	?	2016-04-22	2016-05-27	2016-04-12		0	2016-04-12	?	0	0005205096			20160412.ifs	2016-04-12	2016-04-13
1861217	1861217	DIVIDEND	DELETE	69367P106		B	0	1	5	.393444	0	39	2015-04-16	2015-04-20	2015-05-26	2015-04-09		0	?	2015-04-10	0	0004985243			20150511.ifs	2015-05-11	2015-05-12
1861218	1861218	DIVIDEND	ADD	69367P106		B	0	1	0	.390519	0	02	2015-04-16	2015-04-20	2015-05-26	2015-04-09		0	?	2015-05-11	0	0004985243			20150511.ifs	2015-05-11	2015-05-12
1838197	1838197	DIVIDEND	DELETE	69367P106		B	0	1	5	.393444		39	?	2015-04-20	2015-05-26	2015-04-09		0	2015-04-09	?	0	0004985243			20150410.ifs	2015-04-10	2015-04-11
1838198	1838198	DIVIDEND	ADD	69367P106		B	0	1	5	.393444	0	39	2015-04-16	2015-04-20	2015-05-26	2015-04-09		0	?	2015-04-10	0	0004985243			20150410.ifs	2015-04-10	2015-04-11
1838614	1838614	DIVIDEND	CHANGE	69367P106		B	0	1	5	.393444	0	39	2015-04-16	2015-04-20	2015-05-26	2015-04-09		0	?	2015-04-10	0	0004985243			20150410.ifs	2015-04-10	2015-04-11
1838615	1838614	DIVIDEND	CHANGE	69367P106		B	0	1	5	.393444	0	39	2015-04-16	2015-04-20	2015-05-26	2015-04-09		0	?	2015-04-10	0	0004985243			20150410.ifs	2015-04-10	2015-04-11
1837915	1837915	DIVIDEND	ADD	69367P106		B	0	1	5	.393444		39	?	2015-04-20	2015-05-26	2015-04-09		0	2015-04-09	?	0	0004985243			20150409.ifs	2015-04-09	2015-04-10
1529621	1529621	DIVIDEND	DELETE	69367P106	Ex-date corresponds with foreign ex-date.	B	0	1	5	.693134	0	39	2014-04-29	2014-05-01	2014-06-03	2014-04-04		0	?	2014-04-08	0	0004766533			20140523.ifs	2014-05-23	2014-05-24
1529622	1529622	DIVIDEND	ADD	69367P106		B	0	1	0	.679668	0	02	2014-04-29	2014-05-01	2014-06-03	2014-04-04		0	?	2014-05-23	0	0004766533			20140523.ifs	2014-05-23	2014-05-24
1492883	1492883	DIVIDEND	CHANGE	69367P106		B	0	1	5	.693134	0	39	2014-04-29	2014-05-01	2014-06-03	2014-04-04		0	?	2014-04-07	0	0004766533			20140408.ifs	2014-04-08	2014-04-09
1492884	1492883	DIVIDEND	CHANGE	69367P106	Ex-date corresponds with foreign ex-date.	B	0	1	5	.693134	0	39	2014-04-29	2014-05-01	2014-06-03	2014-04-04		0	?	2014-04-08	0	0004766533			20140408.ifs	2014-04-08	2014-04-09
1492216	1492216	DIVIDEND	DELETE	69367P106		B	0	1	5	.693134		39	?	2014-05-01	2014-06-03	2014-04-04		0	2014-04-04	?	0	0004766533			20140407.ifs	2014-04-07	2014-04-08
1492217	1492217	DIVIDEND	ADD	69367P106		B	0	1	5	.693134	0	39	2014-04-29	2014-05-01	2014-06-03	2014-04-04		0	?	2014-04-07	0	0004766533			20140407.ifs	2014-04-07	2014-04-08
1492635	1492635	DIVIDEND	CHANGE	69367P106		B	0	1	5	.693134	0	39	2014-04-29	2014-05-01	2014-06-03	2014-04-04		0	?	2014-04-07	0	0004766533			20140407.ifs	2014-04-07	2014-04-08
1492636	1492635	DIVIDEND	CHANGE	69367P106		B	0	1	5	.693134	0	39	2014-04-29	2014-05-01	2014-06-03	2014-04-04		0	?	2014-04-07	0	0004766533			20140407.ifs	2014-04-07	2014-04-08
1491706	1491706	DIVIDEND	ADD	69367P106		B	0	1	5	.693134		39	?	2014-05-01	2014-06-03	2014-04-04		0	2014-04-04	?	0	0004766533			20140404.ifs	2014-04-04	2014-04-05
1491707	1491707	DIVIDEND	CHANGE	69367P106		B	0	1	0	.767192		02	2013-05-10	2013-05-14	2013-06-13	2013-04-22		2	2013-04-22	2013-06-03	0	0004559491			20140404.ifs	2014-04-04	2014-04-05
1491708	1491707	DIVIDEND	CHANGE	69367P106		B	0	1	0	.767192		02	2013-05-10	2013-05-14	2013-06-13	2013-04-22		3	2013-04-22	2014-04-04	0	0004559491			20140404.ifs	2014-04-04	2014-04-05
1200908	1200908	DIVIDEND	DELETE	69367P106		B	0	1	5	.784444		39	2013-05-10	2013-05-14	2013-06-13	2013-04-22		1	2013-04-22	2013-04-23	0	0004559491			20130603.ifs	2013-06-03	2013-06-04
1200909	1200909	DIVIDEND	ADD	69367P106		B	0	1	0	.767192		02	2013-05-10	2013-05-14	2013-06-13	2013-04-22		2	2013-04-22	2013-06-03	0	0004559491			20130603.ifs	2013-06-03	2013-06-04
1165118	1165118	DIVIDEND	DELETE	69367P106		B	0	1	5	.784444		39	?	2013-05-14	2013-06-13	2013-04-22		0	2013-04-22	?	0	0004559491			20130423.ifs	2013-04-23	2013-04-24
1165119	1165119	DIVIDEND	ADD	69367P106		B	0	1	5	.784444		39	2013-05-10	2013-05-14	2013-06-13	2013-04-22		1	2013-04-22	2013-04-23	0	0004559491			20130423.ifs	2013-04-23	2013-04-24
1164289	1164289	DIVIDEND	ADD	69367P106		B	0	1	5	.784444		39	?	2013-05-14	2013-06-13	2013-04-22		0	2013-04-22	?	0	0004559491			20130422.ifs	2013-04-22	2013-04-23
903520	903520	DIVIDEND	DELETE	69367P106		B	0	1	5	.475198		39	?	2012-06-14	2012-07-16	2012-05-30		0	2012-05-30	?	0	0004377441			20120702.ifs	2012-07-02	2012-07-03
903521	903521	DIVIDEND	ADD	69367P106		B	0	1	0	.474642		02	2012-06-12	2012-06-14	2012-07-16	2012-05-30		1	2012-05-30	2012-07-02	0	0004377441			20120702.ifs	2012-07-02	2012-07-03
869699	869699	DIVIDEND	CHANGE	69367P106		B	0	1	5	.475198		39	?	2012-06-14	2012-07-16	2012-05-30		0	2012-05-30	?	0	0004377441			20120531.ifs	2012-05-31	2012-06-01
869700	869699	DIVIDEND	CHANGE	69367P106		B	0	1	5	.475198		39	?	2012-06-14	2012-07-16	2012-05-30		0	2012-05-30	?	0	0004377441			20120531.ifs	2012-05-31	2012-06-01
867446	867446	DIVIDEND	ADD	69367P106		B	0	1	5	.475198		39	?	2012-06-14	2012-07-16	2012-05-30		0	2012-05-30	?	0	0004377441			20120530.ifs	2012-05-30	2012-05-31
730562	730562	DIVIDEND	DELETE	69367P106		B	0	1	5	.043717		39	2011-11-30	2011-12-02	2012-01-03	2011-11-15		1	2011-11-15	2011-11-16	0	0004269988			20111219.ifs	2011-12-19	2011-12-20
730563	730563	DIVIDEND	ADD	69367P106		B	0	1	0	.042806		02	2011-11-30	2011-12-02	2012-01-03	2011-11-15		2	2011-11-15	2011-12-19	0	0004269988			20111219.ifs	2011-12-19	2011-12-20
695785	695785	DIVIDEND	DELETE	69367P106		B	0	1	5	.043717		39	?	2011-12-02	2012-01-03	2011-11-15		0	2011-11-15	?	0	0004269988			20111116.ifs	2011-11-16	2011-11-17
695786	695786	DIVIDEND	ADD	69367P106		B	0	1	5	.043717		39	2011-11-30	2011-12-02	2012-01-03	2011-11-15		1	2011-11-15	2011-11-16	0	0004269988			20111116.ifs	2011-11-16	2011-11-17
695078	695078	DIVIDEND	ADD	69367P106		B	0	1	5	.043717		39	?	2011-12-02	2012-01-03	2011-11-15		0	2011-11-15	?	0	0004269988			20111115.ifs	2011-11-15	2011-11-16
606578	606578	DIVIDEND	DELETE	69367P106		B	0	1	5	.621469		39	2011-07-19	2011-07-21	2011-08-19	2011-07-07		1	2011-07-07	2011-07-08	0	0004215468			20110805.ifs	2011-08-05	2011-08-06
606579	606579	DIVIDEND	ADD	69367P106		B	0	1	0	.622878		02	2011-07-19	2011-07-21	2011-08-19	2011-07-07		2	2011-07-07	2011-08-05	0	0004215468			20110805.ifs	2011-08-05	2011-08-06
584727	584727	DIVIDEND	DELETE	69367P106		B	0	1	5	.621469		39	?	2011-07-21	2011-08-19	2011-07-07		0	2011-07-07	?	0	0004215468			20110708.ifs	2011-07-08	2011-07-09
584728	584728	DIVIDEND	ADD	69367P106		B	0	1	5	.621469		39	2011-07-19	2011-07-21	2011-08-19	2011-07-07		1	2011-07-07	2011-07-08	0	0004215468			20110708.ifs	2011-07-08	2011-07-09
413911	413911	DIVIDEND	DELETE	69367P106		B	0	1	5	.040472		39	2010-12-27	2010-12-29	2011-01-19	2010-12-09		1	2010-12-09	2010-12-10	0	0004100990			20110105.ifs	2011-01-05	2011-01-06
413912	413912	DIVIDEND	ADD	69367P106		B	0	1	0	.040358		02	2010-12-27	2010-12-29	2011-01-19	2010-12-09		2	2010-12-09	2011-01-05	0	0004100990			20110105.ifs	2011-01-05	2011-01-06
374895	374895	DIVIDEND	ADD	69367P106		B	0	1	5	.040472		39	?	2010-12-29	2011-01-19	2010-12-09		0	2010-12-09	?	0	0004100990			20101209.ifs	2010-12-09	2010-12-10
261148	261148	DIVIDEND	DELETE	69367P106		0	0	1	5	.79209		19	2010-07-08	2010-07-12	2010-08-11	2010-06-21		1	2010-06-21	2010-06-23	0	0004020777			20100728.ifs	2010-07-28	2010-07-29
261149	261149	DIVIDEND	ADD	69367P106		B	0	1	0	.61897		02	2010-07-08	2010-07-12	2010-08-11	2010-06-21		2	2010-06-21	2010-07-28	0	0004020777			20100728.ifs	2010-07-28	2010-07-29
226703	226703	DIVIDEND	DELETE	69367P106		0	0	1	5	.79209		19	?	2010-07-12	2010-08-11	2010-06-21		0	2010-06-21	?	0	0004020777			20100623.ifs	2010-06-23	2010-06-24
226704	226704	DIVIDEND	ADD	69367P106		0	0	1	5	.79209		19	2010-07-08	2010-07-12	2010-08-11	2010-06-21		1	2010-06-21	2010-06-23	0	0004020777			20100623.ifs	2010-06-23	2010-06-24
223993	223993	DIVIDEND	ADD	69367P106		0	0	1	5	.79209		19	?	2010-07-12	2010-08-11	2010-06-21		0	2010-06-21	?	0	0004020777			20100621.ifs	2010-06-21	2010-06-22
64409	64409	DIVIDEND	DELETE	69367P106		0	0	1	5	.0533		19	2009-12-08	2009-12-10	2010-01-08	2009-11-18		1	2009-11-18	2009-11-19	0	0003908990			20091223.ifs	2009-12-23	2010-04-07
64410	64410	DIVIDEND	ADD	69367P106		0	0	1	0	.05258		00	2009-12-08	2009-12-10	2010-01-08	2009-11-18		2	2009-11-18	2009-12-23	0	0003908990			20091223.ifs	2009-12-23	2010-04-07
26579	26579	DIVIDEND	DELETE	69367P106		0	0	1	5	.0533		19	?	2009-12-10	2010-01-08	2009-11-18		0	2009-11-18	?	0	0003908990			20091119.ifs	2009-11-19	2010-04-07
26580	26580	DIVIDEND	ADD	69367P106		0	0	1	5	.0533		19	2009-12-08	2009-12-10	2010-01-08	2009-11-18		1	2009-11-18	2009-11-19	0	0003908990			20091119.ifs	2009-11-19	2010-04-07
25692	25692	DIVIDEND	ADD	69367P106		0	0	1	5	.0533		19	?	2009-12-10	2010-01-08	2009-11-18		0	2009-11-18	?	0	0003908990			20091118.ifs	2009-11-18	2010-04-07

Old Cusip

entryId

groupId

EQUITY

CHANGE

CUSIP

DESCRIPTION

ISSUE STATUS CODE

ISSUE TYPE CODE

ADD DATE

EXPIRATION DATE

PAYMENT FREQUENCY CODE

MARGIN FLAG

OPTION FLAG

CONVERTED CUSIP

NASDAQ MARKET CODE

INDEX ISSUER

CHANGE DATE

MERGENT CHANGE DATE

MATURE DATE

undefined1

undefined2

undefined3

undefined4

temp1

temp2

fileName

fileDate

processDate

BACK UP Institutions before committing
SELECT institutionciklist.institutionid AS theinstitutionID, institutionciklist.institutionCik, institutionciklist.institutionName, institutionciklist.isGuru, all13ffilings. * , current13Fpositions. *
FROM current13Fpositions, all13ffilings, institutionciklist
WHERE current13Fpositions.compid = 159836
AND all13ffilings.entryId = current13Fpositions.linkID
AND all13ffilings.institutionid = institutionciklist.institutionid
AND institutionciklist.alive ='yes'
AND all13ffilings.done ='yes'
AND reportDate >='2012-06-30'
ORDER BY value ASC