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
2575451	2575451	CORPACTION	ADD	47102X105	01	M	2017-05-30	G4474Y214	01	2017-05-30															20170530.ifs	2017-05-30	2017-05-31
2575452	2575452	EQUITY	CHANGE	47102X105	COM	0	0	2002-12-13	?	4	yes	yes		no		2003-02-03	2003-01-03	?							20170530.ifs	2017-05-30	2017-05-31
2575453	2575452	EQUITY	CHANGE	47102X105	COM	M	0	2002-12-13	2017-05-30	4	yes	yes	G4474Y214	no		2003-02-03	2017-05-30	?							20170530.ifs	2017-05-30	2017-05-31
2549419	2549419	DIVIDEND	CHANGE	47102X105		0	0	1	0	.11		00	2017-05-03	2017-05-05	2017-05-19	2017-04-18		0	2017-04-20	?	0	0005422337			20170427.ifs	2017-04-27	2017-04-28
2549420	2549419	DIVIDEND	CHANGE	47102X105		0	0	1	0	.11		00	2017-05-03	2017-05-05	2017-05-19	2017-04-18		1	2017-04-20	2017-04-27	0	0005422337			20170427.ifs	2017-04-27	2017-04-28
2545078	2545078	DIVIDEND	ADD	47102X105		0	0	1	0	.11		00	2017-05-03	2017-05-05	2017-05-19	2017-04-18		0	2017-04-20	?	0	0005422337			20170420.ifs	2017-04-20	2017-04-21
2454506	2454506	DIVIDEND	ADD	47102X105		0	0	1	0	.11		00	2017-02-02	2017-02-06	2017-02-17	2017-01-19		0	2017-01-24	?	0	0005377187			20170124.ifs	2017-01-24	2017-01-25
2440330	2440330	EQUITY	CHANGE	47102X105	COM	0	0	2002-12-13	?	1	yes	yes		no		2003-02-03	2003-01-03	?							20170123.ifs	2017-01-23	2017-01-24
2440331	2440330	EQUITY	CHANGE	47102X105	COM	0	0	2002-12-13	?	4	yes	yes		no		2003-02-03	2003-01-03	?							20170123.ifs	2017-01-23	2017-01-24
2326122	2326122	DIVIDEND	ADD	47102X105		0	0	1	0	.11		00	2016-11-03	2016-11-07	2016-11-18	2016-10-20		0	2016-10-25	?	0	0005300823			20161025.ifs	2016-10-25	2016-10-26
2317146	2317146	DIVIDEND	CHANGE	47102X105		0	0	1	0	.11		00	2016-08-04	2016-08-08	2016-08-19	2016-07-21		0	2016-07-26	?	0	0005254063			20161005.ifs	2016-10-05	2016-10-06
2317147	2317146	DIVIDEND	CHANGE	47102X105		0	0	1	0	.11		00	2016-08-04	2016-08-08	2016-08-19	2016-07-21		1	2016-07-26	2016-10-05	0	0005254063			20161005.ifs	2016-10-05	2016-10-06
2257219	2257219	DIVIDEND	ADD	47102X105		0	0	1	0	.11		00	2016-08-04	2016-08-08	2016-08-19	2016-07-21		0	2016-07-26	?	0	0005254063			20160726.ifs	2016-07-26	2016-07-27
2178982	2178982	DIVIDEND	ADD	47102X105		0	0	1	0	.11		00	2016-05-05	2016-05-09	2016-05-20	2016-04-26		0	2016-04-26	?	0	0005208011			20160426.ifs	2016-04-26	2016-04-27
2098468	2098468	DIVIDEND	ADD	47102X105		0	0	1	0	.09		00	2016-02-10	2016-02-12	2016-02-25	2016-01-19		0	2016-01-26	?	0	0005162212			20160126.ifs	2016-01-26	2016-01-27
1995068	1995068	DIVIDEND	ADD	47102X105		0	0	1	0	.09		00	2015-11-04	2015-11-06	2015-11-20	2015-10-15		0	2015-10-22	?	0	0005081332			20151022.ifs	2015-10-22	2015-10-23
1921839	1921839	DIVIDEND	ADD	47102X105		0	0	1	0	.09		00	2015-08-05	2015-08-07	2015-08-21	2015-07-16		0	2015-07-23	?	0	0005034853			20150723.ifs	2015-07-23	2015-07-24
1846136	1846136	DIVIDEND	ADD	47102X105		0	0	1	0	.09		00	2015-05-06	2015-05-08	2015-05-22	2015-04-16		0	2015-04-23	?	0	0004988630			20150423.ifs	2015-04-23	2015-04-24
1773142	1773142	DIVIDEND	ADD	47102X105		0	0	1	0	.08		00	2015-02-11	2015-02-13	2015-02-27	2015-01-15		0	2015-01-22	?	0	0004943081			20150122.ifs	2015-01-22	2015-01-23
1662155	1662155	DIVIDEND	ADD	47102X105		0	0	1	0	.08		00	2014-11-05	2014-11-07	2014-11-21	2014-10-20		0	2014-10-23	?	0	0004861488			20141023.ifs	2014-10-23	2014-10-24
1586097	1586097	DIVIDEND	ADD	47102X105		0	0	1	0	.08		00	2014-08-06	2014-08-08	2014-08-22	2014-07-23		0	2014-07-24	?	0	0004817271			20140724.ifs	2014-07-24	2014-07-25
1499645	1499645	DIVIDEND	ADD	47102X105		0	0	1	0	.08		00	2014-05-07	2014-05-09	2014-05-23	2014-04-17		0	2014-04-22	?	0	0004769516			20140422.ifs	2014-04-22	2014-04-23
1426407	1426407	DIVIDEND	ADD	47102X105		0	0	1	0	.07		00	2014-02-05	2014-02-07	2014-02-21	2014-01-21		0	2014-01-23	?	0	0004725505			20140123.ifs	2014-01-23	2014-01-24
1322454	1322454	DIVIDEND	ADD	47102X105		0	0	1	0	.07		00	2013-11-06	2013-11-08	2013-11-22	2013-10-21		0	2013-10-24	?	0	0004647377			20131024.ifs	2013-10-24	2013-10-25
1246778	1246778	DIVIDEND	ADD	47102X105		0	0	1	0	.07		00	2013-08-07	2013-08-09	2013-08-23	2013-07-22		0	2013-07-25	?	0	0004604050			20130725.ifs	2013-07-25	2013-07-26
1165220	1165220	DIVIDEND	ADD	47102X105		0	0	1	0	.07		00	2013-05-08	2013-05-10	2013-05-24	2013-04-18		0	2013-04-23	?	0	0004559581			20130423.ifs	2013-04-23	2013-04-24
1034246	1034246	DIVIDEND	ADD	47102X105		0	0	1	0	.06		00	2012-12-19	2012-12-21	2012-12-31	2012-12-10		0	2012-12-10	?	0	0004474186			20121210.ifs	2012-12-10	2012-12-11
992726	992726	DIVIDEND	ADD	47102X105		0	0	1	0	.06		00	2012-11-01	2012-11-05	2012-11-19	2012-10-23		0	2012-10-25	?	0	0004447843			20121025.ifs	2012-10-25	2012-10-26
921978	921978	DIVIDEND	ADD	47102X105		0	0	1	0	.06		00	2012-08-02	2012-08-06	2012-08-20	2012-07-24		0	2012-07-26	?	0	0004405371			20120726.ifs	2012-07-26	2012-07-27
841917	841917	DIVIDEND	ADD	47102X105		0	0	1	0	.06		00	2012-05-03	2012-05-07	2012-05-21	2012-04-19		0	2012-04-24	?	0	0004363563			20120424.ifs	2012-04-24	2012-04-25
763269	763269	DIVIDEND	ADD	47102X105		0	0	1	0	.05		00	2012-02-02	2012-02-06	2012-02-21	2012-01-24		0	2012-01-26	?	0	0004323251			20120126.ifs	2012-01-26	2012-01-27
676035	676035	DIVIDEND	ADD	47102X105		0	0	1	0	.05		00	2011-10-27	2011-10-31	2011-11-14	2011-10-18		0	2011-10-20	?	0	0004258460			20111020.ifs	2011-10-20	2011-10-21
590464	590464	DIVIDEND	ADD	47102X105		0	0	1	0	.05		00	2011-07-27	2011-07-29	2011-08-12	2011-07-19		0	2011-07-19	?	0	0004217913			20110719.ifs	2011-07-19	2011-07-20
507027	507027	DIVIDEND	ADD	47102X105		0	0	1	0	.05		00	2011-04-28	2011-05-02	2011-05-13	2011-04-21		0	2011-04-21	?	0	0004176896			20110421.ifs	2011-04-21	2011-04-22
172351	172351	DIVIDEND	ADD	47102X105		0	0	1	0	.04		00	2010-05-12	2010-05-14	2010-05-28	2010-04-29		0	2010-04-29	?	0	0003997341			20100429.ifs	2010-04-29	2010-04-30

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