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
5555635	5555635	DIVIDEND	ADD	00927V200		A	0	2	0	.035		15	2024-06-28	2024-06-28	2024-07-15	2024-05-08		0	2024-05-08	?	0	0006918254			20240508.ifs	2024-05-08	2024-05-09
5514394	5514394	DIVIDEND	DELETE	00927V200		A	0	2	0	.07		15	2024-03-27	2024-03-29	2024-04-15	2024-03-06		0	2024-03-06	?	0	0006888327			20240308.ifs	2024-03-08	2024-03-09
5514395	5514395	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2024-03-27	2024-03-28	2024-04-15	2024-03-06		1	2024-03-06	2024-03-08	0	0006888327			20240308.ifs	2024-03-08	2024-03-09
5513581	5513581	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2024-03-27	2024-03-29	2024-04-15	2024-03-06		0	2024-03-06	?	0	0006888327			20240306.ifs	2024-03-06	2024-03-07
5417527	5417527	DIVIDEND	CHANGE	00927V200		A	0	2	0	.1		15	2023-12-28	2023-12-29	2024-01-15	2023-11-08		0	2023-11-09	?	0	0006810955			20231121.ifs	2023-11-21	2023-11-22
5417528	5417527	DIVIDEND	CHANGE	00927V200		A	0	2	0	.07		15	2023-12-28	2023-12-29	2024-01-15	2023-11-08		1	2023-11-09	2023-11-21	0	0006810955			20231121.ifs	2023-11-21	2023-11-22
5412930	5412930	DIVIDEND	ADD	00927V200		A	0	2	0	.1		15	2023-12-28	2023-12-29	2024-01-15	2023-11-08		0	2023-11-09	?	0	0006810955			20231109.ifs	2023-11-09	2023-11-10
5352782	5352782	DIVIDEND	ADD	00927V200		A	0	2	0	.1		15	2023-09-28	2023-09-30	2023-10-16	2023-08-09		0	2023-08-09	?	0	0006768787			20230809.ifs	2023-08-09	2023-08-10
5289052	5289052	DIVIDEND	ADD	00927V200		A	0	2	0	.1		15	2023-06-29	2023-06-30	2023-07-17	2023-05-09		0	2023-05-09	?	0	0006724502			20230509.ifs	2023-05-09	2023-05-10
5247375	5247375	DIVIDEND	ADD	00927V200		A	0	2	0	.1		15	2023-03-30	2023-03-31	2023-04-17	2023-03-09		0	2023-03-10	?	0	0006694632			20230310.ifs	2023-03-10	2023-03-11
5137473	5137473	DIVIDEND	ADD	00927V200		A	0	2	0	.1		15	2022-12-29	2022-12-30	2023-01-16	2022-11-08		0	2022-11-08	?	0	0006611690			20221108.ifs	2022-11-08	2022-11-09
5077686	5077686	DIVIDEND	DELETE	00927V200		A	0	2	0	.1		15	2022-09-29	2022-09-30	2022-10-17	2022-08-04		0	2022-08-04	?	0	0006568150			20220811.ifs	2022-08-11	2022-08-12
5077687	5077687	DIVIDEND	ADD	00927V200		A	0	2	0	.1		15	2022-09-28	2022-09-30	2022-10-17	2022-08-04		1	2022-08-04	2022-08-11	0	0006568150			20220811.ifs	2022-08-11	2022-08-12
5075114	5075114	DIVIDEND	ADD	00927V200		A	0	2	0	.1		15	2022-09-29	2022-09-30	2022-10-17	2022-08-04		0	2022-08-04	?	0	0006568150			20220804.ifs	2022-08-04	2022-08-05
5010733	5010733	DIVIDEND	ADD	00927V200		A	0	2	0	.1		15	2022-06-29	2022-06-30	2022-07-15	2022-05-11		0	2022-05-11	?	0	0006523243			20220511.ifs	2022-05-11	2022-05-12
4967330	4967330	DIVIDEND	ADD	00927V200		A	0	2	0	.1		15	2022-03-30	2022-03-31	2022-04-15	2022-03-08		0	2022-03-08	?	0	0006491954			20220308.ifs	2022-03-08	2022-03-09
4848980	4848980	DIVIDEND	ADD	00927V200		A	0	2	0	.1		15	2021-12-30	2021-12-31	2022-01-17	2021-11-15		0	2021-11-16	?	0	0006396734			20211116.ifs	2021-11-16	2021-11-17
4784173	4784173	DIVIDEND	DELETE	00927V200		A	0	2	0	.1		15	2021-09-29	2021-09-30	2021-10-15	2021-08-10		0	2021-08-10	?	0	0006353208			20210819.ifs	2021-08-19	2021-08-20
4784174	4784174	DIVIDEND	ADD	00927V200		A	0	2	0	.1		15	2021-09-28	2021-09-30	2021-10-15	2021-08-10		1	2021-08-10	2021-08-19	0	0006353208			20210819.ifs	2021-08-19	2021-08-20
4780031	4780031	DIVIDEND	ADD	00927V200		A	0	2	0	.1		15	2021-09-29	2021-09-30	2021-10-15	2021-08-10		0	2021-08-10	?	0	0006353208			20210810.ifs	2021-08-10	2021-08-11
4704287	4704287	DIVIDEND	ADD	00927V200		A	0	2	0	.1		15	2021-06-29	2021-06-30	2021-07-15	2021-05-12		0	2021-05-12	?	0	0006307688			20210512.ifs	2021-05-12	2021-05-13
4651909	4651909	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2021-03-30	2021-03-31	2021-04-15	2021-03-10		0	2021-03-11	?	0	0006276367			20210311.ifs	2021-03-11	2021-03-12
4507122	4507122	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2020-12-30	2020-12-31	2021-01-15	2020-11-12		0	2020-11-13	?	0	0006188080			20201113.ifs	2020-11-13	2020-11-14
4461089	4461089	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2020-09-29	2020-09-30	2020-10-15	2020-09-10		0	2020-09-11	?	0	0006158029			20200911.ifs	2020-09-11	2020-09-12
4341587	4341587	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2020-06-29	2020-06-30	2020-07-15	2020-05-15		0	2020-05-19	?	0	0006100034			20200519.ifs	2020-05-19	2020-05-20
4341601	4341601	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2020-06-29	2020-06-30	2020-07-15	2020-05-15		0	2020-05-19	?	0	0006100034			20200519.ifs	2020-05-19	2020-05-20
4237318	4237318	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2020-03-30	2020-03-31	2020-04-15	2020-03-10		0	2020-03-10	?	0	0006067939			20200310.ifs	2020-03-10	2020-03-11
4237325	4237325	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2020-03-30	2020-03-31	2020-04-15	2020-03-10		0	2020-03-10	?	0	0006067939			20200310.ifs	2020-03-10	2020-03-11
4007924	4007924	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2019-12-30	2019-12-31	2020-01-15	2019-11-06		0	2019-11-06	?	0	0005974038			20191106.ifs	2019-11-06	2019-11-07
4007925	4007925	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2019-12-30	2019-12-31	2020-01-15	2019-11-06		0	2019-11-06	?	0	0005974038			20191106.ifs	2019-11-06	2019-11-07
3878809	3878809	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2019-09-27	2019-09-30	2019-10-15	2019-08-13		0	2019-08-13	?	0	0005930256			20190813.ifs	2019-08-13	2019-08-14
3878812	3878812	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2019-09-27	2019-09-30	2019-10-15	2019-08-13		0	2019-08-13	?	0	0005930256			20190813.ifs	2019-08-13	2019-08-14
3782234	3782234	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2019-06-27	2019-06-28	2019-07-15	2019-06-13		0	2019-06-14	?	0	0005898074			20190614.ifs	2019-06-14	2019-06-15
3782255	3782255	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2019-06-27	2019-06-28	2019-07-15	2019-06-13		0	2019-06-14	?	0	0005898074			20190614.ifs	2019-06-14	2019-06-15
3624732	3624732	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2019-03-28	2019-03-29	2019-04-15	2019-03-12		0	2019-03-12	?	0	0005851623			20190312.ifs	2019-03-12	2019-03-13
3624750	3624750	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2019-03-28	2019-03-29	2019-04-15	2019-03-12		0	2019-03-12	?	0	0005851623			20190312.ifs	2019-03-12	2019-03-13
3366301	3366301	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2018-12-27	2018-12-28	2019-01-15	2018-11-07		0	2018-11-07	?	0	0005753363			20181107.ifs	2018-11-07	2018-11-08
3366308	3366308	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2018-12-27	2018-12-28	2019-01-15	2018-11-07		0	2018-11-07	?	0	0005753363			20181107.ifs	2018-11-07	2018-11-08
3237632	3237632	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2018-09-27	2018-09-28	2018-10-15	2018-08-13		0	2018-08-13	?	0	0005707972			20180813.ifs	2018-08-13	2018-08-14
3238225	3238225	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2018-09-27	2018-09-28	2018-10-15	2018-08-13		0	2018-08-13	?	0	0005707972			20180813.ifs	2018-08-13	2018-08-14
3085941	3085941	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2018-06-28	2018-06-30	2018-07-16	2018-05-09		0	2018-05-09	?	0	0005660158			20180509.ifs	2018-05-09	2018-05-10
3085942	3085942	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2018-06-28	2018-06-30	2018-07-16	2018-05-09		0	2018-05-09	?	0	0005660158			20180509.ifs	2018-05-09	2018-05-10
2991195	2991195	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2018-03-28	2018-03-31	2018-04-16	2018-03-14		0	2018-03-14	?	0	0005629117			20180314.ifs	2018-03-14	2018-03-15
2991499	2991499	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2018-03-28	2018-03-31	2018-04-16	2018-03-14		0	2018-03-14	?	0	0005629117			20180314.ifs	2018-03-14	2018-03-15
2763856	2763856	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2017-12-28	2017-12-29	2018-01-15	2017-11-10		0	2017-11-13	?	0	0005529262			20171113.ifs	2017-11-13	2017-11-14
2764342	2764342	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2017-12-28	2017-12-29	2018-01-15	2017-11-10		0	2017-11-13	?	0	0005529262			20171113.ifs	2017-11-13	2017-11-14
2646195	2646195	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2017-09-28	2017-09-29	2017-10-13	2017-08-08		0	2017-08-08	?	0	0005481857			20170808.ifs	2017-08-08	2017-08-09
2564531	2564531	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2017-06-28	2017-06-30	2017-07-14	2017-05-09		0	2017-05-09	?	0	0005434201			20170509.ifs	2017-05-09	2017-05-10
2514622	2514622	DIVIDEND	ADD	00927V200		A	0	2	0	.07		15	2017-03-29	2017-03-31	2017-04-14	2017-03-16		0	2017-03-16	?	0	0005403294			20170316.ifs	2017-03-16	2017-03-17
2433712	2433712	EQUITY	CHANGE	00927V200	COM NEW	0	0	1998-06-16	?	0	no	no		no		2000-04-04	2007-07-27	?							20170123.ifs	2017-01-23	2017-01-24
2433713	2433712	EQUITY	CHANGE	00927V200	COM NEW	0	0	1998-06-16	?	4	no	no		no		2000-04-04	2007-07-27	?							20170123.ifs	2017-01-23	2017-01-24
2343128	2343128	DIVIDEND	ADD	00927V200		A	0	2	0	.065		15	2016-12-28	2016-12-31	2017-01-12	2016-11-14		0	2016-11-14	?	0	0005311258			20161114.ifs	2016-11-14	2016-11-15
2268558	2268558	DIVIDEND	ADD	00927V200		A	0	2	0	.065		15	2016-09-28	2016-09-30	2016-10-14	2016-08-09		0	2016-08-09	?	0	0005264665			20160809.ifs	2016-08-09	2016-08-10
2194104	2194104	DIVIDEND	ADD	00927V200		A	0	2	0	.065		15	2016-06-28	2016-06-30	2016-07-14	2016-05-10		0	2016-05-10	?	0	0005217947			20160510.ifs	2016-05-10	2016-05-11
2135754	2135754	DIVIDEND	ADD	00927V200		A	0	2	0	.06		15	2016-03-29	2016-03-31	2016-04-14	2016-03-15		0	2016-03-15	?	0	0005186735			20160315.ifs	2016-03-15	2016-03-16
2003978	2003978	DIVIDEND	ADD	00927V200		A	0	2	0	.06		15	2015-12-29	2015-12-31	2016-01-14	2015-11-04		0	2015-11-04	?	0	0005090748			20151104.ifs	2015-11-04	2015-11-05
1939543	1939543	DIVIDEND	ADD	00927V200		A	0	2	0	.06		15	2015-09-28	2015-09-30	2015-10-15	2015-08-11		0	2015-08-11	?	0	0005046544			20150811.ifs	2015-08-11	2015-08-12
1862943	1862943	DIVIDEND	ADD	00927V200		A	0	2	0	.06		15	2015-06-26	2015-06-30	2015-07-16	2015-05-13		0	2015-05-13	?	0	0004999960			20150513.ifs	2015-05-13	2015-05-14
1815241	1815241	DIVIDEND	ADD	00927V200		A	0	2	0	.06		15	2015-03-31	2015-04-02	2015-04-16	2015-03-18		0	2015-03-18	?	0	0004969623			20150318.ifs	2015-03-18	2015-03-19
1676266	1676266	DIVIDEND	ADD	00927V200		A	0	2	0	.05		15	2014-12-29	2014-12-31	2015-01-15	2014-11-05		0	2014-11-05	?	0	0004871086			20141105.ifs	2014-11-05	2014-11-06
1604342	1604342	DIVIDEND	ADD	00927V200		A	0	2	0	.05		15	2014-09-24	2014-09-26	2014-10-16	2014-08-11		0	2014-08-11	?	0	0004828040			20140811.ifs	2014-08-11	2014-08-12
1521081	1521081	DIVIDEND	ADD	00927V200		A	0	2	0	.05		15	2014-06-25	2014-06-27	2014-07-17	2014-05-07		0	2014-05-07	?	0	0004781140			20140507.ifs	2014-05-07	2014-05-08
1471037	1471037	DIVIDEND	ADD	00927V200		A	0	2	0	.05		15	2014-04-01	2014-04-03	2014-04-17	2014-03-19		0	2014-03-19	?	0	0004752105			20140319.ifs	2014-03-19	2014-03-20
1339435	1339435	DIVIDEND	ADD	00927V200		A	0	2	0	.05		15	2013-12-27	2013-12-31	2014-01-16	2013-11-13		0	2013-11-13	?	0	0004657757			20131113.ifs	2013-11-13	2013-11-14
1261139	1261139	DIVIDEND	ADD	00927V200		A	0	2	0	.05		15	2013-09-26	2013-09-30	2013-10-17	2013-08-07		0	2013-08-07	?	0	0004614217			20130807.ifs	2013-08-07	2013-08-08
1181559	1181559	DIVIDEND	ADD	00927V200		A	0	2	0	.05		15	2013-06-26	2013-06-28	2013-07-18	2013-05-07		0	2013-05-07	?	0	0004569952			20130507.ifs	2013-05-07	2013-05-08
1138035	1138035	DIVIDEND	ADD	00927V200		A	0	2	0	.05		15	2013-04-01	2013-04-03	2013-04-18	2013-03-20		0	2013-03-20	?	0	0004543359			20130320.ifs	2013-03-20	2013-03-21
1007039	1007039	DIVIDEND	ADD	00927V200		A	0	2	0	.05		15	2012-12-27	2012-12-31	2013-01-17	2012-11-07		0	2012-11-07	?	0	0004456766			20121107.ifs	2012-11-07	2012-11-08
931253	931253	DIVIDEND	ADD	00927V200		A	0	2	0	.05		15	2012-09-26	2012-09-28	2012-10-18	2012-08-08		0	2012-08-08	?	0	0004414692			20120808.ifs	2012-08-08	2012-08-09
858648	858648	DIVIDEND	ADD	00927V200		A	0	2	0	.05		15	2012-06-27	2012-06-29	2012-07-19	2012-05-09		0	2012-05-09	?	0	0004373218			20120509.ifs	2012-05-09	2012-05-10
807363	807363	DIVIDEND	ADD	00927V200		A	0	2	0	.0375		15	2012-03-28	2012-03-30	2012-04-19	2012-03-21		0	2012-03-21	?	0	0004348018			20120321.ifs	2012-03-21	2012-03-22
692667	692667	DIVIDEND	ADD	00927V200		A	0	2	0	.0375		15	2011-12-28	2011-12-31	2012-01-19	2011-11-09		0	2011-11-09	?	0	0004269011			20111109.ifs	2011-11-09	2011-11-10
612616	612616	DIVIDEND	ADD	00927V200		A	0	2	0	.0375		15	2011-09-28	2011-09-30	2011-10-19	2011-08-10		0	2011-08-10	?	0	0004228809			20110810.ifs	2011-08-10	2011-08-11
524560	524560	DIVIDEND	ADD	00927V200		A	0	2	0	.0375		15	2011-06-28	2011-06-30	2011-07-20	2011-05-11		0	2011-05-11	?	0	0004187558			20110511.ifs	2011-05-11	2011-05-12
478781	478781	DIVIDEND	ADD	00927V200		A	0	2	0	.03		15	2011-03-29	2011-03-31	2011-04-20	2011-03-22		0	2011-03-23	?	0	0004162793			20110323.ifs	2011-03-23	2011-03-24
353243	353243	DIVIDEND	ADD	00927V200		A	0	2	0	.03		15	2010-12-29	2010-12-31	2011-01-20	2010-11-10		0	2010-11-10	?	0	0004086545			20101110.ifs	2010-11-10	2010-11-11
277428	277428	DIVIDEND	ADD	00927V200		A	0	2	0	.03		15	2010-09-28	2010-09-30	2010-10-21	2010-08-11		0	2010-08-11	?	0	0004046491			20100811.ifs	2010-08-11	2010-08-12
190733	190733	DIVIDEND	ADD	00927V200		A	0	2	0	.03		15	2010-06-28	2010-06-30	2010-07-22	2010-05-12		0	2010-05-12	?	0	0004005388			20100512.ifs	2010-05-12	2010-05-13
133508	133508	DIVIDEND	ADD	00927V200		A	0	2	0	.02		15	2010-03-29	2010-03-31	2010-04-21	2010-03-16		0	2010-03-16	?	0	0003978251			20100316.ifs	2010-03-16	2010-04-07
21391	21391	DIVIDEND	ADD	00927V200		A	0	2	0	.04		15	2009-12-29	2009-12-31	2010-01-21	2009-11-10		0	2009-11-10	?	0	0003907448			20091110.ifs	2009-11-10	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 = 145358
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