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
5543414	5543414	DIVIDEND	ADD	48203R104		0	0	1	0	.22		00	2024-06-03	2024-06-03	2024-06-24	2024-04-25		0	2024-04-25	?	0	0006909230			20240425.ifs	2024-04-25	2024-04-26
5486746	5486746	DIVIDEND	ADD	48203R104		0	0	1	0	.22		00	2024-02-29	2024-03-01	2024-03-22	2024-01-30		0	2024-01-30	?	0	0006867911			20240130.ifs	2024-01-30	2024-01-31
5400704	5400704	DIVIDEND	ADD	48203R104		0	0	1	0	.22		00	2023-11-30	2023-12-01	2023-12-22	2023-10-26		0	2023-10-26	?	0	0006802135			20231026.ifs	2023-10-26	2023-10-27
5340501	5340501	DIVIDEND	ADD	48203R104		0	0	1	0	.22		00	2023-08-31	2023-09-01	2023-09-22	2023-07-27		0	2023-07-27	?	0	0006759442			20230727.ifs	2023-07-27	2023-07-28
5276765	5276765	DIVIDEND	ADD	48203R104		0	0	1	0	.22		00	2023-05-31	2023-06-01	2023-06-22	2023-04-25		0	2023-04-25	?	0	0006715227			20230425.ifs	2023-04-25	2023-04-26
5220074	5220074	DIVIDEND	ADD	48203R104		0	0	1	0	.22		00	2023-02-28	2023-03-01	2023-03-22	2023-01-31		0	2023-01-31	?	0	0006674419			20230131.ifs	2023-01-31	2023-02-01
5125071	5125071	DIVIDEND	ADD	48203R104		0	0	1	0	.21		00	2022-11-30	2022-12-01	2022-12-22	2022-10-25		0	2022-10-25	?	0	0006602247			20221025.ifs	2022-10-25	2022-10-26
5063646	5063646	DIVIDEND	ADD	48203R104		0	0	1	0	.21		00	2022-08-31	2022-09-01	2022-09-22	2022-07-26		0	2022-07-26	?	0	0006558750			20220726.ifs	2022-07-26	2022-07-27
4998078	4998078	DIVIDEND	ADD	48203R104		0	0	1	0	.21		00	2022-05-31	2022-06-01	2022-06-22	2022-04-26		0	2022-04-26	?	0	0006513575			20220426.ifs	2022-04-26	2022-04-27
4940211	4940211	DIVIDEND	ADD	48203R104		0	0	1	0	.21		00	2022-02-28	2022-03-01	2022-03-22	2022-01-27		0	2022-01-27	?	0	0006471282			20220127.ifs	2022-01-27	2022-01-28
4832021	4832021	DIVIDEND	ADD	48203R104		0	0	1	0	.2		00	2021-11-30	2021-12-01	2021-12-22	2021-10-26		0	2021-10-26	?	0	0006386445			20211026.ifs	2021-10-26	2021-10-27
4765461	4765461	DIVIDEND	ADD	48203R104		0	0	1	0	.2		00	2021-08-31	2021-09-01	2021-09-22	2021-07-27		0	2021-07-27	?	0	0006342669			20210727.ifs	2021-07-27	2021-07-28
4689031	4689031	DIVIDEND	ADD	48203R104		0	0	1	0	.2		00	2021-05-28	2021-06-01	2021-06-22	2021-04-27		0	2021-04-27	?	0	0006297431			20210427.ifs	2021-04-27	2021-04-28
4613604	4613604	DIVIDEND	ADD	48203R104		0	0	1	0	.2		00	2021-02-26	2021-03-01	2021-03-22	2021-01-28		0	2021-01-28	?	0	0006255002			20210128.ifs	2021-01-28	2021-01-29
4491928	4491928	DIVIDEND	ADD	48203R104		0	0	1	0	.2		00	2020-11-30	2020-12-01	2020-12-22	2020-10-27		0	2020-10-27	?	0	0006178109			20201027.ifs	2020-10-27	2020-10-28
4425327	4425327	DIVIDEND	ADD	48203R104		0	0	1	0	.2		00	2020-08-31	2020-09-01	2020-09-22	2020-07-28		0	2020-07-28	?	0	0006133590			20200728.ifs	2020-07-28	2020-07-29
4303977	4303977	DIVIDEND	ADD	48203R104		0	0	1	0	.2		00	2020-05-29	2020-06-01	2020-06-22	2020-04-28		0	2020-04-28	?	0	0006088966			20200428.ifs	2020-04-28	2020-04-29
4303978	4303978	DIVIDEND	ADD	48203R104		0	0	1	0	.2		00	2020-05-29	2020-06-01	2020-06-22	2020-04-28		0	2020-04-28	?	0	0006088966			20200428.ifs	2020-04-28	2020-04-29
4179005	4179005	DIVIDEND	ADD	48203R104		0	0	1	0	.2		00	2020-02-28	2020-03-02	2020-03-23	2020-01-27		0	2020-01-27	?	0	0006045232			20200127.ifs	2020-01-27	2020-01-28
4179006	4179006	DIVIDEND	ADD	48203R104		0	0	1	0	.2		00	2020-02-28	2020-03-02	2020-03-23	2020-01-27		0	2020-01-27	?	0	0006045232			20200127.ifs	2020-01-27	2020-01-28
3982799	3982799	DIVIDEND	ADD	48203R104		0	0	1	0	.19		00	2019-11-29	2019-12-02	2019-12-23	2019-10-24		0	2019-10-24	?	0	0005964962			20191024.ifs	2019-10-24	2019-10-25
3982888	3982888	DIVIDEND	ADD	48203R104		0	0	1	0	.19		00	2019-11-29	2019-12-02	2019-12-23	2019-10-24		0	2019-10-24	?	0	0005964962			20191024.ifs	2019-10-24	2019-10-25
3849845	3849845	DIVIDEND	ADD	48203R104		0	0	1	0	.19		00	2019-09-03	2019-09-04	2019-09-25	2019-07-25		0	2019-07-26	?	0	0005919736			20190726.ifs	2019-07-26	2019-07-27
3849853	3849853	DIVIDEND	ADD	48203R104		0	0	1	0	.19		00	2019-09-03	2019-09-04	2019-09-25	2019-07-25		0	2019-07-26	?	0	0005919736			20190726.ifs	2019-07-26	2019-07-27
3694534	3694534	DIVIDEND	ADD	48203R104		0	0	1	0	.19		00	2019-05-31	2019-06-03	2019-06-24	2019-04-25		0	2019-04-25	?	0	0005873274			20190425.ifs	2019-04-25	2019-04-26
3694535	3694535	DIVIDEND	ADD	48203R104		0	0	1	0	.19		00	2019-05-31	2019-06-03	2019-06-24	2019-04-25		0	2019-04-25	?	0	0005873274			20190425.ifs	2019-04-25	2019-04-26
3564501	3564501	DIVIDEND	ADD	48203R104		0	0	1	0	.19		00	2019-02-28	2019-03-01	2019-03-22	2019-01-29		0	2019-01-29	?	0	0005829286			20190129.ifs	2019-01-29	2019-01-30
3564502	3564502	DIVIDEND	ADD	48203R104		0	0	1	0	.19		00	2019-02-28	2019-03-01	2019-03-22	2019-01-29		0	2019-01-29	?	0	0005829286			20190129.ifs	2019-01-29	2019-01-30
3336935	3336935	DIVIDEND	ADD	48203R104		0	0	1	0	.18		00	2018-12-04	2018-12-05	2018-12-26	2018-10-23		0	2018-10-23	?	0	0005742989			20181023.ifs	2018-10-23	2018-10-24
3336938	3336938	DIVIDEND	ADD	48203R104		0	0	1	0	.18		00	2018-12-04	2018-12-05	2018-12-26	2018-10-23		0	2018-10-23	?	0	0005742989			20181023.ifs	2018-10-23	2018-10-24
3206823	3206823	DIVIDEND	ADD	48203R104		0	0	1	0	.18		00	2018-08-31	2018-09-04	2018-09-25	2018-07-26		0	2018-07-26	?	0	0005697430			20180726.ifs	2018-07-26	2018-07-27
3206830	3206830	DIVIDEND	ADD	48203R104		0	0	1	0	.18		00	2018-08-31	2018-09-04	2018-09-25	2018-07-26		0	2018-07-26	?	0	0005697430			20180726.ifs	2018-07-26	2018-07-27
3075787	3075787	DIVIDEND	ADD	48203R104		0	0	1	0	.18		00	2018-05-31	2018-06-01	2018-06-22	2018-05-02		0	2018-05-02	?	0	0005658456			20180502.ifs	2018-05-02	2018-05-03
3075795	3075795	DIVIDEND	ADD	48203R104		0	0	1	0	.18		00	2018-05-31	2018-06-01	2018-06-22	2018-05-02		0	2018-05-02	?	0	0005658456			20180502.ifs	2018-05-02	2018-05-03
2934033	2934033	DIVIDEND	ADD	48203R104		0	0	1	0	.18		00	2018-02-28	2018-03-01	2018-03-22	2018-01-30		0	2018-01-30	?	0	0005605733			20180130.ifs	2018-01-30	2018-01-31
2934989	2934989	DIVIDEND	ADD	48203R104		0	0	1	0	.18		00	2018-02-28	2018-03-01	2018-03-22	2018-01-30		0	2018-01-30	?	0	0005605733			20180130.ifs	2018-01-30	2018-01-31
2733644	2733644	DIVIDEND	ADD	48203R104		0	0	1	0	.1		00	2017-11-30	2017-12-01	2017-12-22	2017-10-24		0	2017-10-24	?	0	0005517925			20171024.ifs	2017-10-24	2017-10-25
2733672	2733672	DIVIDEND	ADD	48203R104		0	0	1	0	.1		00	2017-11-30	2017-12-01	2017-12-22	2017-10-24		0	2017-10-24	?	0	0005517925			20171024.ifs	2017-10-24	2017-10-25
2630827	2630827	DIVIDEND	ADD	48203R104		0	0	1	0	.1		00	2017-08-30	2017-09-01	2017-09-22	2017-07-25		0	2017-07-25	?	0	0005471212			20170725.ifs	2017-07-25	2017-07-26
2547308	2547308	DIVIDEND	ADD	48203R104		0	0	1	0	.1		00	2017-05-30	2017-06-01	2017-06-22	2017-04-25		0	2017-04-25	?	0	0005423688			20170425.ifs	2017-04-25	2017-04-26
2473639	2473639	DIVIDEND	ADD	48203R104		0	0	1	0	.1		00	2017-02-27	2017-03-01	2017-03-22	2017-01-26		0	2017-01-26	?	0	0005378196			20170126.ifs	2017-01-26	2017-01-27
2440878	2440878	EQUITY	CHANGE	48203R104	COM	0	0	1999-04-23	?	8	yes	yes		no		1999-11-16	2009-10-29	?							20170123.ifs	2017-01-23	2017-01-24
2440879	2440878	EQUITY	CHANGE	48203R104	COM	0	0	1999-04-23	?	4	yes	yes		no		1999-11-16	2009-10-29	?							20170123.ifs	2017-01-23	2017-01-24
2326121	2326121	DIVIDEND	ADD	48203R104		0	0	1	0	.1		00	2016-11-29	2016-12-01	2016-12-22	2016-10-25		0	2016-10-25	?	0	0005300728			20161025.ifs	2016-10-25	2016-10-26
2257218	2257218	DIVIDEND	ADD	48203R104		0	0	1	0	.1		00	2016-08-30	2016-09-01	2016-09-22	2016-07-26		0	2016-07-26	?	0	0005254230			20160726.ifs	2016-07-26	2016-07-27
2181202	2181202	DIVIDEND	ADD	48203R104		0	0	1	0	.1		00	2016-05-27	2016-06-01	2016-06-22	2016-04-28		0	2016-04-28	?	0	0005209462			20160428.ifs	2016-04-28	2016-04-29
2099137	2099137	DIVIDEND	ADD	48203R104		0	0	1	0	.1		00	2016-02-26	2016-03-01	2016-03-22	2016-01-27		0	2016-01-27	?	0	0005162840			20160127.ifs	2016-01-27	2016-01-28
1995066	1995066	DIVIDEND	ADD	48203R104		0	0	1	0	.1		00	2015-11-27	2015-12-01	2015-12-22	2015-10-22		0	2015-10-22	?	0	0005081639			20151022.ifs	2015-10-22	2015-10-23
1922706	1922706	DIVIDEND	ADD	48203R104		0	0	1	0	.1		00	2015-08-28	2015-09-01	2015-09-22	2015-07-23		0	2015-07-24	?	0	0005035329			20150724.ifs	2015-07-24	2015-07-25
1846131	1846131	DIVIDEND	ADD	48203R104		0	0	1	0	.1		00	2015-05-29	2015-06-02	2015-06-23	2015-04-23		0	2015-04-23	?	0	0004988792			20150423.ifs	2015-04-23	2015-04-24
1775277	1775277	DIVIDEND	ADD	48203R104		0	0	1	0	.1		00	2015-02-27	2015-03-03	2015-03-24	2015-01-27		0	2015-01-27	?	0	0004944275			20150127.ifs	2015-01-27	2015-01-28
1662149	1662149	DIVIDEND	ADD	48203R104		0	0	1	0	.1		00	2014-11-28	2014-12-02	2014-12-23	2014-10-23		0	2014-10-23	?	0	0004861687			20141023.ifs	2014-10-23	2014-10-24
1585392	1585392	DIVIDEND	ADD	48203R104		0	0	1	4	.1		35	2014-08-28	2014-09-02	2014-09-23	2014-07-22		0	2014-07-23	?	0	0004817076			20140723.ifs	2014-07-23	2014-07-24
9337	9337	CORPACTION	ADD	48203R104	60	X	2009-10-29	48203R104	01	?															20091029.ifs	2009-10-29	2010-04-07
9338	9338	EXCHANGE	ADD	48203R104	01	2009-10-29	2009-10-29	JNPR	0	0	2009-10-29	?													20091029.ifs	2009-10-29	2010-04-07
9339	9339	EQUITY	CHANGE	48203R104	COM	0	0	1999-04-23	?	8	yes	yes		yes		1999-11-16	1999-10-11	?							20091029.ifs	2009-10-29	2010-04-07
9340	9339	EQUITY	CHANGE	48203R104	COM	0	0	1999-04-23	?	8	yes	yes		no		1999-11-16	2009-10-29	?							20091029.ifs	2009-10-29	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 = 130853
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