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
5559427	5559427	DIVIDEND	CHANGE	502117203		0	0	1	0	1.408775		00	2024-04-24	2024-04-25	2024-05-21	2024-02-09		2	2024-02-09	2024-05-16	0	0006876133			20240517.ifs	2024-05-17	2024-05-18
5559428	5559427	DIVIDEND	CHANGE	502117203		0	0	1	0	1.408775		00	2024-04-24	2024-04-25	2024-05-21	2024-02-09		3	2024-02-09	2024-05-17	0	0006876133			20240517.ifs	2024-05-17	2024-05-18
5558964	5558964	DIVIDEND	DELETE	502117203		0	0	1	5	1.421904		19	2024-04-24	2024-04-25	2024-05-21	2024-02-09		1	2024-02-09	2024-04-19	0	0006876133			20240516.ifs	2024-05-16	2024-05-17
5558965	5558965	DIVIDEND	ADD	502117203		0	0	1	0	1.408775		00	2024-04-24	2024-04-25	2024-05-21	2024-02-09		2	2024-02-09	2024-05-16	0	0006876133			20240516.ifs	2024-05-16	2024-05-17
5540494	5540494	DIVIDEND	CHANGE	502117203		0	0	1	5	1.421904		19	2024-04-24	2024-04-25	2024-05-21	2024-02-09		0	2024-02-09	?	0	0006876133			20240419.ifs	2024-04-19	2024-04-20
5540495	5540494	DIVIDEND	CHANGE	502117203		0	0	1	5	1.421904		19	2024-04-24	2024-04-25	2024-05-21	2024-02-09		1	2024-02-09	2024-04-19	0	0006876133			20240419.ifs	2024-04-19	2024-04-20
5497328	5497328	DIVIDEND	ADD	502117203		0	0	1	5	1.421904		19	2024-04-24	2024-04-25	2024-05-21	2024-02-09		0	2024-02-09	?	0	0006876133			20240209.ifs	2024-02-09	2024-02-10
5289427	5289427	DIVIDEND	DELETE	502117203		0	0	1	5	1.28298		19	2023-04-24	2023-04-25	2023-05-19	2023-02-21		0	2023-02-21	?	0	0006683983			20230510.ifs	2023-05-10	2023-05-11
5289428	5289428	DIVIDEND	ADD	502117203		0	0	1	0	1.317843		00	2023-04-24	2023-04-25	2023-05-19	2023-02-21		1	2023-02-21	2023-05-10	0	0006683983			20230510.ifs	2023-05-10	2023-05-11
5232743	5232743	DIVIDEND	ADD	502117203		0	0	1	5	1.28298		19	2023-04-24	2023-04-25	2023-05-19	2023-02-21		0	2023-02-21	?	0	0006683983			20230221.ifs	2023-02-21	2023-02-22
5009211	5009211	DIVIDEND	DELETE	502117203		0	0	1	5	1.089504		19	2022-04-25	2022-04-26	2022-05-20	2022-02-11		0	2022-02-11	?	0	0006480654			20220506.ifs	2022-05-06	2022-05-07
5009212	5009212	DIVIDEND	ADD	502117203		0	0	1	0	1.007775		00	2022-04-25	2022-04-26	2022-05-20	2022-02-11		1	2022-02-11	2022-05-06	0	0006480654			20220506.ifs	2022-05-06	2022-05-07
4952626	4952626	DIVIDEND	ADD	502117203		0	0	1	5	1.089504		19	2022-04-25	2022-04-26	2022-05-20	2022-02-11		0	2022-02-11	?	0	0006480654			20220211.ifs	2022-02-11	2022-02-12
4701845	4701845	DIVIDEND	DELETE	502117203		0	0	1	5	.952896		19	2021-04-23	2021-04-26	2021-05-20	2021-03-08		0	2021-03-08	?	0	0006276001			20210507.ifs	2021-05-07	2021-05-08
4701846	4701846	DIVIDEND	ADD	502117203		0	0	1	0	.967048		00	2021-04-23	2021-04-26	2021-05-20	2021-03-08		1	2021-03-08	2021-05-07	0	0006276001			20210507.ifs	2021-05-07	2021-05-08
4649503	4649503	DIVIDEND	ADD	502117203		0	0	1	5	.952896		19	2021-04-23	2021-04-26	2021-05-20	2021-03-08		0	2021-03-08	?	0	0006276001			20210308.ifs	2021-03-08	2021-03-09
4509401	4509401	DIVIDEND	ADD	502117203	$0.008982 represents the tax refund for those holders who electe	6	0	1	0	0		36	?	2020-07-02	2020-07-31	2020-11-17		0	?	2020-11-19	0	0006188626			20201119.ifs	2020-11-19	2020-11-20
4422602	4422602	DIVIDEND	DELETE	502117203		0	0	1	5	.859936		19	2020-07-01	2020-07-02	2020-07-31	2020-06-03		0	2020-06-03	?	0	0006109725			20200722.ifs	2020-07-22	2020-07-23
4422603	4422603	DIVIDEND	ADD	502117203		0	0	1	0	.866817		00	2020-07-01	2020-07-02	2020-07-31	2020-06-03		1	2020-06-03	2020-07-22	0	0006109725			20200722.ifs	2020-07-22	2020-07-23
4385541	4385541	DIVIDEND	ADD	502117203		0	0	1	5	.859936		19	2020-07-01	2020-07-02	2020-07-31	2020-06-03		0	2020-06-03	?	0	0006109725			20200603.ifs	2020-06-03	2020-06-04
4386038	4386038	DIVIDEND	ADD	502117203		0	0	1	5	.859936		19	2020-07-01	2020-07-02	2020-07-31	2020-06-03		0	2020-06-03	?	0	0006109725			20200603.ifs	2020-06-03	2020-06-04
3726201	3726201	DIVIDEND	DELETE	502117203		0	0	1	5	.868945		19	2019-04-24	2019-04-25	2019-05-28	2019-03-14		0	2019-03-14	?	0	0005852100			20190513.ifs	2019-05-13	2019-05-14
3726203	3726203	DIVIDEND	ADD	502117203		0	0	1	0	.862143		00	2019-04-24	2019-04-25	2019-05-28	2019-03-14		1	2019-03-14	2019-05-13	0	0005852100			20190513.ifs	2019-05-13	2019-05-14
3726204	3726204	DIVIDEND	DELETE	502117203		0	0	1	5	.868945		19	2019-04-24	2019-04-25	2019-05-28	2019-03-14		0	2019-03-14	?	0	0005852100			20190513.ifs	2019-05-13	2019-05-14
3726206	3726206	DIVIDEND	ADD	502117203		0	0	1	0	.862143		00	2019-04-24	2019-04-25	2019-05-28	2019-03-14		1	2019-03-14	2019-05-13	0	0005852100			20190513.ifs	2019-05-13	2019-05-14
3627158	3627158	DIVIDEND	ADD	502117203		0	0	1	5	.868945		19	2019-04-24	2019-04-25	2019-05-28	2019-03-14		0	2019-03-14	?	0	0005852100			20190314.ifs	2019-03-14	2019-03-15
3627159	3627159	DIVIDEND	ADD	502117203		0	0	1	5	.868945		19	2019-04-24	2019-04-25	2019-05-28	2019-03-14		0	2019-03-14	?	0	0005852100			20190314.ifs	2019-03-14	2019-03-15
3082566	3082566	DIVIDEND	DELETE	502117203		0	0	1	5	.873442		19	2018-04-23	2018-04-24	2018-05-24	2018-03-16		0	2018-03-16	?	0	0005630238			20180507.ifs	2018-05-07	2018-05-08
3082568	3082568	DIVIDEND	ADD	502117203		0	0	1	0	.856851		00	2018-04-23	2018-04-24	2018-05-24	2018-03-16		1	2018-03-16	2018-05-07	0	0005630238			20180507.ifs	2018-05-07	2018-05-08
3082569	3082569	DIVIDEND	DELETE	502117203		0	0	1	5	.873442		19	2018-04-23	2018-04-24	2018-05-24	2018-03-16		0	2018-03-16	?	0	0005630238			20180507.ifs	2018-05-07	2018-05-08
3082571	3082571	DIVIDEND	ADD	502117203		0	0	1	0	.856851		00	2018-04-23	2018-04-24	2018-05-24	2018-03-16		1	2018-03-16	2018-05-07	0	0005630238			20180507.ifs	2018-05-07	2018-05-08
2995303	2995303	DIVIDEND	ADD	502117203		0	0	1	5	.873442		19	2018-04-23	2018-04-24	2018-05-24	2018-03-16		0	2018-03-16	?	0	0005630238			20180316.ifs	2018-03-16	2018-03-17
2995304	2995304	DIVIDEND	ADD	502117203		0	0	1	5	.873442		19	2018-04-23	2018-04-24	2018-05-24	2018-03-16		0	2018-03-16	?	0	0005630238			20180316.ifs	2018-03-16	2018-03-17
2565887	2565887	DIVIDEND	DELETE	502117203		0	0	1	5	.700062		19	2017-04-25	2017-04-27	2017-05-26	2017-02-28		0	2017-02-28	?	0	0005392950			20170511.ifs	2017-05-11	2017-05-12
2565888	2565888	DIVIDEND	ADD	502117203		0	0	1	0	.718776		00	2017-04-25	2017-04-27	2017-05-26	2017-02-28		1	2017-02-28	2017-05-11	0	0005392950			20170511.ifs	2017-05-11	2017-05-12
2499271	2499271	DIVIDEND	ADD	502117203		0	0	1	5	.700062		19	2017-04-25	2017-04-27	2017-05-26	2017-02-28		0	2017-02-28	?	0	0005392950			20170228.ifs	2017-02-28	2017-03-01
2493184	2493184	DIVIDEND	CHANGE	502117203	$0.007978 represents the tax refund for those holders who electe	6	1	1	0	.01649	0	36	?	2016-04-28	2017-03-02	2017-02-16		0	2017-02-16	2017-02-22	0	0005389078			20170222.ifs	2017-02-22	2017-02-23
2493185	2493184	DIVIDEND	CHANGE	502117203	$0.007978 represents the tax refund for those holders who electe	6	1	1	0	0	0	36	?	2016-04-28	2017-03-02	2017-02-16		0	2017-02-16	2017-02-22	0	0005389078			20170222.ifs	2017-02-22	2017-02-23
2491486	2491486	DIVIDEND	ADD	502117203		6	1	1	0	.01649		36	?	2016-04-28	2017-03-02	2017-02-16		0	2017-02-16	?	0	0005389078			20170216.ifs	2017-02-16	2017-02-17
2462887	2462887	EQUITY	CHANGE	502117203	ADR	0	0	1995-10-31	?	8	no	no		no		2000-02-25	2000-04-11	?							20170126.ifs	2017-01-26	2017-01-27
2462888	2462887	EQUITY	CHANGE	502117203	ADR	0	0	1995-10-31	?	1	no	no		no		2000-02-25	2000-04-11	?							20170126.ifs	2017-01-26	2017-01-27
2196487	2196487	DIVIDEND	DELETE	502117203		0	0	1	5	.693222		19	2016-04-26	2016-04-28	2016-05-26	2016-03-23		1	2016-03-23	2016-03-24	0	0005191267			20160513.ifs	2016-05-13	2016-05-14
2196488	2196488	DIVIDEND	ADD	502117203		0	0	1	0	.712506		00	2016-04-26	2016-04-28	2016-05-26	2016-03-23		2	2016-03-23	2016-05-13	0	0005191267			20160513.ifs	2016-05-13	2016-05-14
2142842	2142842	DIVIDEND	DELETE	502117203		0	0	1	5	.693222		19	?	2016-04-28	2016-05-26	2016-03-23		0	2016-03-23	?	0	0005191267			20160324.ifs	2016-03-24	2016-03-25
2142843	2142843	DIVIDEND	ADD	502117203		0	0	1	5	.693222		19	2016-04-26	2016-04-28	2016-05-26	2016-03-23		1	2016-03-23	2016-03-24	0	0005191267			20160324.ifs	2016-03-24	2016-03-25
2141607	2141607	DIVIDEND	ADD	502117203		0	0	1	5	.693222		19	?	2016-04-28	2016-05-26	2016-03-23		0	2016-03-23	?	0	0005191267			20160323.ifs	2016-03-23	2016-03-24
1868090	1868090	DIVIDEND	DELETE	502117203		0	0	1	5	.61479	0	19	2015-04-30	2015-05-04	?	2015-02-19		0	?	2015-02-20	0	0004956097			20150521.ifs	2015-05-21	2015-05-22
1868091	1868091	DIVIDEND	ADD	502117203		0	0	1	0	.60406	0	00	2015-04-30	2015-05-04	2015-05-29	2015-02-19		0	?	2015-05-21	0	0004956097			20150521.ifs	2015-05-21	2015-05-22
1792846	1792846	DIVIDEND	DELETE	502117203		0	0	1	5	.61479		19	?	2015-05-04	?	2015-02-19		0	2015-02-19	?	0	0004956097			20150220.ifs	2015-02-20	2015-02-21
1792847	1792847	DIVIDEND	ADD	502117203		0	0	1	5	.61479	0	19	2015-04-30	2015-05-04	?	2015-02-19		0	?	2015-02-20	0	0004956097			20150220.ifs	2015-02-20	2015-02-21
1793172	1793172	DIVIDEND	CHANGE	502117203		0	0	1	5	.61479	0	19	2015-04-30	2015-05-04	?	2015-02-19		0	?	2015-02-20	0	0004956097			20150220.ifs	2015-02-20	2015-02-21
1793173	1793172	DIVIDEND	CHANGE	502117203		0	0	1	5	.61479	0	19	2015-04-30	2015-05-04	?	2015-02-19		0	?	2015-02-20	0	0004956097			20150220.ifs	2015-02-20	2015-02-21
1524368	1524368	DIVIDEND	DELETE	502117203		0	0	1	5	.69565		19	2014-04-24	2014-04-28	?	2014-03-18		0	2014-03-18	?	0	0004751310			20140515.ifs	2014-05-15	2014-05-16
1524369	1524369	DIVIDEND	ADD	502117203		0	0	1	0	.692371		00	2014-04-24	2014-04-28	2014-05-22	2014-03-18		1	2014-03-18	2014-05-15	0	0004751310			20140515.ifs	2014-05-15	2014-05-16
1469728	1469728	DIVIDEND	ADD	502117203		0	0	1	5	.69565		19	2014-04-24	2014-04-28	?	2014-03-18		0	2014-03-18	?	0	0004751310			20140318.ifs	2014-03-18	2014-03-19
1193483	1193483	DIVIDEND	DELETE	502117203		0	0	1	5	.620034		19	2013-05-02	2013-05-06	?	2013-02-13		2	2013-02-13	2013-03-26	0	0004527737			20130528.ifs	2013-05-28	2013-05-29
1193484	1193484	DIVIDEND	ADD	502117203		0	0	1	0	.596464		00	2013-05-02	2013-05-06	2013-06-04	2013-02-13		3	2013-02-13	2013-05-28	0	0004527737			20130528.ifs	2013-05-28	2013-05-29
1112402	1112402	DIVIDEND	DELETE	502117203		0	0	1	5	.620034		19	?	2013-05-06	?	2013-02-13		0	2013-02-13	?	0	0004527737			20130214.ifs	2013-02-14	2013-02-15
1112403	1112403	DIVIDEND	ADD	502117203		0	0	1	5	.620034		19	2013-05-02	2013-05-06	?	2013-02-13		1	2013-02-13	2013-02-14	0	0004527737			20130214.ifs	2013-02-14	2013-02-15
1111936	1111936	DIVIDEND	ADD	502117203		0	0	1	5	.620034		19	?	2013-05-06	?	2013-02-13		0	2013-02-13	?	0	0004527737			20130213.ifs	2013-02-13	2013-02-14
863146	863146	DIVIDEND	CHANGE	502117203		0	0	1	0	.524264		00	2012-04-24	2012-04-26	2012-05-24	2012-02-16		2	2012-02-16	2012-05-10	0	0004333567			20120517.ifs	2012-05-17	2012-05-18
863147	863146	DIVIDEND	CHANGE	502117203		0	0	1	0	.524264		00	2012-04-24	2012-04-26	2012-05-24	2012-02-16		3	2012-02-16	2012-05-17	0	0004333567			20120517.ifs	2012-05-17	2012-05-18
859197	859197	DIVIDEND	DELETE	502117203		0	0	1	5	.52192		19	2012-04-24	2012-04-26	2012-05-24	2012-02-16		1	2012-02-16	2012-02-17	0	0004333567			20120510.ifs	2012-05-10	2012-05-11
859198	859198	DIVIDEND	ADD	502117203		0	0	1	0	.524264		00	2012-04-24	2012-04-26	2012-05-24	2012-02-16		2	2012-02-16	2012-05-10	0	0004333567			20120510.ifs	2012-05-10	2012-05-11
781552	781552	DIVIDEND	DELETE	502117203		0	0	1	5	.52192		19	?	2012-04-26	2012-05-24	2012-02-16		0	2012-02-16	?	0	0004333567			20120217.ifs	2012-02-17	2012-02-18
781553	781553	DIVIDEND	ADD	502117203		0	0	1	5	.52192		19	2012-04-24	2012-04-26	2012-05-24	2012-02-16		1	2012-02-16	2012-02-17	0	0004333567			20120217.ifs	2012-02-17	2012-02-18
780670	780670	DIVIDEND	ADD	502117203		0	0	1	5	.52192		19	?	2012-04-26	2012-05-24	2012-02-16		0	2012-02-16	?	0	0004333567			20120216.ifs	2012-02-16	2012-02-17
524363	524363	DIVIDEND	CHANGE	502117203		0	0	1	0	.533768		00	2011-04-26	2011-04-28	2011-05-23	2011-03-08		2	2011-03-08	2011-05-10	0	0004158157			20110511.ifs	2011-05-11	2011-05-12
524364	524363	DIVIDEND	CHANGE	502117203		0	0	1	0	.533768		00	2011-04-26	2011-04-28	2011-05-23	2011-03-08		3	2011-03-08	2011-05-11	0	0004158157			20110511.ifs	2011-05-11	2011-05-12
523626	523626	DIVIDEND	DELETE	502117203		0	0	1	5	.497916		19	2011-04-26	2011-04-28	2011-05-23	2011-03-08		1	2011-03-08	2011-03-14	0	0004158157			20110510.ifs	2011-05-10	2011-05-11
523627	523627	DIVIDEND	ADD	502117203		0	0	1	0	.533768		00	2011-04-26	2011-04-28	2011-05-23	2011-03-08		2	2011-03-08	2011-05-10	0	0004158157			20110510.ifs	2011-05-10	2011-05-11
471125	471125	DIVIDEND	DELETE	502117203		B	0	1	5	.343437		39	2011-04-26	2011-04-28	2011-05-23	2011-03-08		0	2011-03-08	?	0	0004158157			20110314.ifs	2011-03-14	2011-03-15
471126	471126	DIVIDEND	ADD	502117203		0	0	1	5	.497916		19	2011-04-26	2011-04-28	2011-05-23	2011-03-08		1	2011-03-08	2011-03-14	0	0004158157			20110314.ifs	2011-03-14	2011-03-15
467686	467686	DIVIDEND	ADD	502117203		B	0	1	5	.343437		39	2011-04-26	2011-04-28	2011-05-23	2011-03-08		0	2011-03-08	?	0	0004158157			20110308.ifs	2011-03-08	2011-03-09
236347	236347	DIVIDEND	DELETE	502117203		0		1	0	.38088		00	2010-04-27	2010-04-29	2010-05-26	?		0	2010-05-14	?	0	0003965921			20100701.ifs	2010-07-01	2010-07-02
236348	236348	DIVIDEND	ADD	502117203		0	0	1	0	.38088	0	00	2010-04-27	2010-04-29	2010-05-26	2010-02-16		0	?	2010-07-01	0	0003965921			20100701.ifs	2010-07-01	2010-07-02
234592	234592	DIVIDEND	ADD	502117203		6	1	1	0	.00585		36	?	2010-04-29	2010-07-06	2010-06-30		0	2010-06-30	?	0	0004024812			20100630.ifs	2010-06-30	2010-07-01
192426	192426	DIVIDEND	ADD	502117203		0		1	0	.38088		00	2010-04-27	2010-04-29	2010-05-26	?		0	2010-05-14	?	0	0003965921			20100514.ifs	2010-05-14	2010-05-15
111953	111953	DIVIDEND	DELETE	502117203		0	0	1	5	.41187		19	?	2010-04-29	?	2010-02-17		0	2010-02-17	?	0	0003965921			20100218.ifs	2010-02-18	2010-04-07
111749	111749	DIVIDEND	ADD	502117203		0	0	1	5	.41187		19	?	2010-04-29	?	2010-02-17		0	2010-02-17	?	0	0003965921			20100217.ifs	2010-02-17	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 = 142480
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