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
5579407	5579407	DIVIDEND	ADD	247361702		0	0	1	0	.15		00	2024-07-30	2024-07-30	2024-08-20	2024-06-20		0	2024-06-20	?	0	0006934852			20240620.ifs	2024-06-20	2024-06-21
5543605	5543605	DIVIDEND	ADD	247361702		0	0	1	0	.1		00	2024-05-13	2024-05-14	2024-06-04	2024-04-25		0	2024-04-25	?	0	0006909173			20240425.ifs	2024-04-25	2024-04-26
5496812	5496812	DIVIDEND	ADD	247361702		0	0	1	0	.1		00	2024-02-23	2024-02-26	2024-03-18	2024-02-08		0	2024-02-08	?	0	0006875802			20240208.ifs	2024-02-08	2024-02-09
5383187	5383187	DIVIDEND	ADD	247361702		0	0	1	0	.1		00	2023-10-11	2023-10-12	2023-11-02	2023-09-28		0	2023-09-28	?	0	0006789574			20230928.ifs	2023-09-28	2023-09-29
5312185	5312185	DIVIDEND	ADD	247361702		0	0	1	0	.1		00	2023-07-14	2023-07-17	2023-08-07	2023-06-15		0	2023-06-15	?	0	0006738808			20230615.ifs	2023-06-15	2023-06-16
4518501	4518501	DIVIDEND	CHANGE	247361702		0	0	E	0	0		58	?	?	2020-06-12	2020-04-15		0	2020-04-15	?	0	0006085315			20201130.ifs	2020-11-30	2020-12-01
4518502	4518501	DIVIDEND	CHANGE	247361702		0	0	E	0	0		58	?	?	2020-06-12	2020-04-15		1	2020-04-15	2020-11-30	0	0006085315			20201130.ifs	2020-11-30	2020-12-01
4289158	4289158	DIVIDEND	ADD	247361702		0	0	E	0	0		58	?	?	2020-06-12	2020-04-15		0	2020-04-15	?	0	0006085315			20200415.ifs	2020-04-15	2020-04-16
4289161	4289161	DIVIDEND	ADD	247361702		0	0	E	0	0		58	?	?	2020-06-12	2020-04-15		0	2020-04-15	?	0	0006085315			20200415.ifs	2020-04-15	2020-04-16
4200188	4200188	DIVIDEND	ADD	247361702		0	0	1	0	.4025		00	2020-02-19	2020-02-20	2020-03-12	2020-02-06		0	2020-02-06	?	0	0006053614			20200206.ifs	2020-02-06	2020-02-07
4200235	4200235	DIVIDEND	ADD	247361702		0	0	1	0	.4025		00	2020-02-19	2020-02-20	2020-03-12	2020-02-06		0	2020-02-06	?	0	0006053614			20200206.ifs	2020-02-06	2020-02-07
3970930	3970930	DIVIDEND	ADD	247361702		0	0	1	0	.4025		00	2019-10-23	2019-10-24	2019-11-14	2019-10-09		0	2019-10-10	?	0	0005961817			20191010.ifs	2019-10-10	2019-10-11
3970931	3970931	DIVIDEND	ADD	247361702		0	0	1	0	.4025		00	2019-10-23	2019-10-24	2019-11-14	2019-10-09		0	2019-10-10	?	0	0005961817			20191010.ifs	2019-10-10	2019-10-11
3833441	3833441	DIVIDEND	ADD	247361702		0	0	1	0	.4025		00	2019-07-24	2019-07-25	2019-08-15	2019-07-11		0	2019-07-11	?	0	0005915818			20190711.ifs	2019-07-11	2019-07-12
3833584	3833584	DIVIDEND	ADD	247361702		0	0	1	0	.4025		00	2019-07-24	2019-07-25	2019-08-15	2019-07-11		0	2019-07-11	?	0	0005915818			20190711.ifs	2019-07-11	2019-07-12
3688715	3688715	DIVIDEND	ADD	247361702		0	0	1	0	.35		00	2019-05-01	2019-05-02	2019-05-23	2019-04-18		0	2019-04-18	?	0	0005871517			20190418.ifs	2019-04-18	2019-04-19
3688718	3688718	DIVIDEND	ADD	247361702		0	0	1	0	.35		00	2019-05-01	2019-05-02	2019-05-23	2019-04-18		0	2019-04-18	?	0	0005871517			20190418.ifs	2019-04-18	2019-04-19
3577627	3577627	DIVIDEND	ADD	247361702		0	0	1	0	.35		00	2019-02-28	2019-03-01	2019-03-22	2019-02-07		0	2019-02-07	?	0	0005836995			20190207.ifs	2019-02-07	2019-02-08
3577628	3577628	DIVIDEND	ADD	247361702		0	0	1	0	.35		00	2019-02-28	2019-03-01	2019-03-22	2019-02-07		0	2019-02-07	?	0	0005836995			20190207.ifs	2019-02-07	2019-02-08
3338418	3338418	DIVIDEND	ADD	247361702		0	0	1	0	.35		00	2018-11-06	2018-11-07	2018-11-28	2018-10-24		0	2018-10-24	?	0	0005743330			20181024.ifs	2018-10-24	2018-10-25
3338419	3338419	DIVIDEND	ADD	247361702		0	0	1	0	.35		00	2018-11-06	2018-11-07	2018-11-28	2018-10-24		0	2018-10-24	?	0	0005743330			20181024.ifs	2018-10-24	2018-10-25
3192762	3192762	DIVIDEND	ADD	247361702		0	0	1	0	.35		00	2018-07-25	2018-07-26	2018-08-16	2018-07-12		0	2018-07-12	?	0	0005693418			20180712.ifs	2018-07-12	2018-07-13
3192763	3192763	DIVIDEND	ADD	247361702		0	0	1	0	.35		00	2018-07-25	2018-07-26	2018-08-16	2018-07-12		0	2018-07-12	?	0	0005693418			20180712.ifs	2018-07-12	2018-07-13
3058118	3058118	DIVIDEND	ADD	247361702		0	0	1	0	.305		00	2018-05-10	2018-05-11	2018-06-01	2018-04-27		0	2018-04-27	?	0	0005651468			20180427.ifs	2018-04-27	2018-04-28
3058119	3058119	DIVIDEND	ADD	247361702		0	0	1	0	.305		00	2018-05-10	2018-05-11	2018-06-01	2018-04-27		0	2018-04-27	?	0	0005651468			20180427.ifs	2018-04-27	2018-04-28
2950598	2950598	DIVIDEND	ADD	247361702		0	0	1	0	.305		00	2018-02-22	2018-02-23	2018-03-16	2018-02-09		0	2018-02-09	?	0	0005614077			20180209.ifs	2018-02-09	2018-02-10
2950613	2950613	DIVIDEND	ADD	247361702		0	0	1	0	.305		00	2018-02-22	2018-02-23	2018-03-16	2018-02-09		0	2018-02-09	?	0	0005614077			20180209.ifs	2018-02-09	2018-02-10
2756742	2756742	DIVIDEND	ADD	247361702		0	0	1	0	.305		00	2017-11-16	2017-11-17	2017-12-08	2017-11-03		0	2017-11-03	?	0	0005527555			20171103.ifs	2017-11-03	2017-11-04
2756743	2756743	DIVIDEND	ADD	247361702		0	0	1	0	.305		00	2017-11-16	2017-11-17	2017-12-08	2017-11-03		0	2017-11-03	?	0	0005527555			20171103.ifs	2017-11-03	2017-11-04
2646738	2646738	DIVIDEND	ADD	247361702		0	0	1	0	.305		00	2017-08-21	2017-08-23	2017-09-13	2017-08-09		0	2017-08-09	?	0	0005481971			20170809.ifs	2017-08-09	2017-08-10
2562774	2562774	DIVIDEND	ADD	247361702		0	0	1	0	.2025		00	2017-05-17	2017-05-19	2017-06-09	2017-05-05		0	2017-05-05	?	0	0005433451			20170505.ifs	2017-05-05	2017-05-06
2488891	2488891	DIVIDEND	ADD	247361702		0	0	1	0	.2025		00	2017-02-22	2017-02-24	2017-03-17	2017-02-10		0	2017-02-10	?	0	0005387521			20170210.ifs	2017-02-10	2017-02-11
2329346	2329346	DIVIDEND	ADD	247361702		0	0	1	0	.2025		00	2016-11-08	2016-11-11	2016-12-02	2016-10-28		0	2016-10-28	?	0	0005302082			20161028.ifs	2016-10-28	2016-10-29
2262145	2262145	DIVIDEND	ADD	247361702		0	0	1	0	.2025		00	2016-08-10	2016-08-12	2016-09-02	2016-07-29		0	2016-07-29	?	0	0005256390			20160729.ifs	2016-07-29	2016-07-30
2180384	2180384	DIVIDEND	ADD	247361702		0	0	1	0	.135		00	2016-05-09	2016-05-11	2016-06-01	2016-04-27		0	2016-04-27	?	0	0005208753			20160427.ifs	2016-04-27	2016-04-28
2109047	2109047	DIVIDEND	ADD	247361702		0	0	1	0	.135		00	2016-02-12	2016-02-17	2016-03-09	2016-02-03		0	2016-02-03	?	0	0005170630			20160203.ifs	2016-02-03	2016-02-04
1995739	1995739	DIVIDEND	ADD	247361702		0	0	1	0	.135		00	2015-11-04	2015-11-06	2015-11-30	2015-10-23		0	2015-10-23	?	0	0005081833			20151023.ifs	2015-10-23	2015-10-24
1922827	1922827	DIVIDEND	ADD	247361702		0	0	1	0	.135		00	2015-08-05	2015-08-07	2015-08-28	2015-07-24		0	2015-07-24	?	0	0005035542			20150724.ifs	2015-07-24	2015-07-25
1847262	1847262	DIVIDEND	ADD	247361702		0	0	1	0	.09		00	2015-05-06	2015-05-08	2015-05-29	2015-04-24		0	2015-04-24	?	0	0004989137			20150424.ifs	2015-04-24	2015-04-25
1787875	1787875	DIVIDEND	ADD	247361702		0	0	1	0	.09		00	2015-02-18	2015-02-20	2015-03-13	2015-02-06		0	2015-02-06	?	0	0004953242			20150206.ifs	2015-02-06	2015-02-07
1662972	1662972	DIVIDEND	ADD	247361702		0	0	1	0	.09		00	2014-11-05	2014-11-07	2014-12-01	2014-10-24		0	2014-10-24	?	0	0004862003			20141024.ifs	2014-10-24	2014-10-25
1586918	1586918	DIVIDEND	ADD	247361702		0	0	1	0	.09		00	2014-08-06	2014-08-08	2014-08-29	2014-07-25		0	2014-07-25	?	0	0004817655			20140725.ifs	2014-07-25	2014-07-26
1586919	1586919	DIVIDEND	CHANGE	247361702		0	0	1	0	.06		00	2014-05-07	2014-05-09	2014-05-30	2014-04-25		0	2014-04-25	?	0	0004771356			20140725.ifs	2014-07-25	2014-07-26
1586920	1586919	DIVIDEND	CHANGE	247361702		0	0	1	0	.06		00	2014-05-07	2014-05-09	2014-05-30	2014-04-25		1	2014-04-25	2014-07-25	0	0004771356			20140725.ifs	2014-07-25	2014-07-26
1586921	1586921	DIVIDEND	CHANGE	247361702		0	0	1	0	.06		00	2014-02-19	2014-02-21	2014-03-14	2014-02-07		0	2014-02-07	?	0	0004735262			20140725.ifs	2014-07-25	2014-07-26
1586922	1586921	DIVIDEND	CHANGE	247361702		0	0	1	0	.06		00	2014-02-19	2014-02-21	2014-03-14	2014-02-07		1	2014-02-07	2014-07-25	0	0004735262			20140725.ifs	2014-07-25	2014-07-26
1586923	1586923	DIVIDEND	CHANGE	247361702		0	0	1	0	.06		00	2013-11-04	2013-11-06	2013-11-26	2013-10-25		0	2013-10-25	?	0	0004647752			20140725.ifs	2014-07-25	2014-07-26
1586924	1586923	DIVIDEND	CHANGE	247361702		0	0	1	0	.06		00	2013-11-04	2013-11-06	2013-11-26	2013-10-25		1	2013-10-25	2014-07-25	0	0004647752			20140725.ifs	2014-07-25	2014-07-26
1586925	1586925	DIVIDEND	CHANGE	247361702		0	0	1	4	.06		00	2013-08-07	2013-08-09	2013-09-10	2013-05-08		0	2013-07-17	?	0	0004602177			20140725.ifs	2014-07-25	2014-07-26
1586926	1586925	DIVIDEND	CHANGE	247361702		0	0	1	0	.06		00	2013-08-07	2013-08-09	2013-09-10	2013-05-08		1	2013-07-17	2014-07-25	0	0004602177			20140725.ifs	2014-07-25	2014-07-26
1502471	1502471	DIVIDEND	ADD	247361702		0	0	1	0	.06		00	2014-05-07	2014-05-09	2014-05-30	2014-04-25		0	2014-04-25	?	0	0004771356			20140425.ifs	2014-04-25	2014-04-26
1441024	1441024	DIVIDEND	ADD	247361702		0	0	1	0	.06		00	2014-02-19	2014-02-21	2014-03-14	2014-02-07		0	2014-02-07	?	0	0004735262			20140207.ifs	2014-02-07	2014-02-08
1323424	1323424	DIVIDEND	ADD	247361702		0	0	1	0	.06		00	2013-11-04	2013-11-06	2013-11-26	2013-10-25		0	2013-10-25	?	0	0004647752			20131025.ifs	2013-10-25	2013-10-26
1241903	1241903	DIVIDEND	ADD	247361702		0	0	1	4	.06		00	2013-08-07	2013-08-09	2013-09-10	2013-05-08		0	2013-07-17	?	0	0004602177			20130717.ifs	2013-07-17	2013-07-18

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 = 149958
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