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
3593722	3593722	EQUITY	CHANGE	61744G107	COM	M	7	1991-10-25	2019-02-25	2	yes	no	61744J820	no		2003-04-08	2019-02-25	?							20190226.ifs	2019-02-26	2019-02-27
3593724	3593723	EQUITY	CHANGE	61744G107	COM	M	7	1991-10-25	2019-02-25	2	yes	no	61744J820	no		2003-04-08	2019-02-26	?							20190226.ifs	2019-02-26	2019-02-27
3593727	3593727	EQUITY	CHANGE	61744G107	COM	M	7	1991-10-25	2019-02-25	2	yes	no	61744J820	no		2003-04-08	2019-02-25	?							20190226.ifs	2019-02-26	2019-02-27
3593729	3593728	EQUITY	CHANGE	61744G107	COM	M	7	1991-10-25	2019-02-25	2	yes	no	61744J820	no		2003-04-08	2019-02-26	?							20190226.ifs	2019-02-26	2019-02-27
3592600	3592600	CORPACTION	ADD	61744G107	01	M	2019-02-25	61744J820	40	?															20190225.ifs	2019-02-25	2019-02-26
3592601	3592601	CORPACTION	ADD	61744G107	01	M	2019-02-25	61744J820	40	?															20190225.ifs	2019-02-25	2019-02-26
3592602	3592602	EQUITY	CHANGE	61744G107	COM	0	7	1991-10-25	?	2	yes	no		no		2003-04-08	2011-06-21	?							20190225.ifs	2019-02-25	2019-02-26
3592603	3592603	EQUITY	CHANGE	61744G107	COM	0	7	1991-10-25	?	2	yes	no		no		2003-04-08	2011-06-21	?							20190225.ifs	2019-02-25	2019-02-26
3592604	3592603	EQUITY	CHANGE	61744G107	COM	M	7	1991-10-25	2019-02-25	2	yes	no	61744J820	no		2003-04-08	2019-02-25	?							20190225.ifs	2019-02-25	2019-02-26
3592605	3592604	EQUITY	CHANGE	61744G107	COM	M	7	1991-10-25	2019-02-25	2	yes	no	61744J820	no		2003-04-08	2019-02-25	?							20190225.ifs	2019-02-25	2019-02-26
3593067	3593067	DIVIDEND	CHANGE	61744G107		8	0	1	9	1.191471		96	2019-02-08	2019-02-11	2019-02-13	2019-02-01		1	2019-02-01	2019-02-22	0	0005834795			20190225.ifs	2019-02-25	2019-02-26
3593069	3593068	DIVIDEND	CHANGE	61744G107		8	0	1	9	1.191471		96	2019-02-08	2019-02-11	2019-02-13	2019-02-01		2	2019-02-01	2019-02-25	0	0005834795			20190225.ifs	2019-02-25	2019-02-26
3593070	3593070	DIVIDEND	CHANGE	61744G107		8	0	1	9	1.191471		96	2019-02-08	2019-02-11	2019-02-13	2019-02-01		1	2019-02-01	2019-02-22	0	0005834795			20190225.ifs	2019-02-25	2019-02-26
3593072	3593071	DIVIDEND	CHANGE	61744G107		8	0	1	9	1.191471		96	2019-02-08	2019-02-11	2019-02-13	2019-02-01		2	2019-02-01	2019-02-25	0	0005834795			20190225.ifs	2019-02-25	2019-02-26
3591736	3591736	DIVIDEND	CHANGE	61744G107		8	0	1	9	1.191471		96	2019-02-08	2019-02-11	2019-02-13	2019-02-01		0	2019-02-01	?	0	0005834795			20190222.ifs	2019-02-22	2019-02-23
3591737	3591737	DIVIDEND	CHANGE	61744G107		8	0	1	9	1.191471		96	2019-02-08	2019-02-11	2019-02-13	2019-02-01		0	2019-02-01	?	0	0005834795			20190222.ifs	2019-02-22	2019-02-23
3591738	3591737	DIVIDEND	CHANGE	61744G107		8	0	1	9	1.191471		96	2019-02-08	2019-02-11	2019-02-13	2019-02-01		1	2019-02-01	2019-02-22	0	0005834795			20190222.ifs	2019-02-22	2019-02-23
3591739	3591738	DIVIDEND	CHANGE	61744G107		8	0	1	9	1.191471		96	2019-02-08	2019-02-11	2019-02-13	2019-02-01		1	2019-02-01	2019-02-22	0	0005834795			20190222.ifs	2019-02-22	2019-02-23
3544846	3544846	DIVIDEND	CHANGE	61744G107		0	0	1	0	.148934		00	2018-12-20	2018-12-21	2019-01-15	2018-12-11		0	2018-12-11	?	0	0005772322			20190108.ifs	2019-01-08	2019-01-09
3544848	3544847	DIVIDEND	CHANGE	61744G107		0	0	1	0	.148934		00	2018-12-20	2018-12-21	2019-01-15	2018-12-11		1	2018-12-11	2019-01-08	0	0005772322			20190108.ifs	2019-01-08	2019-01-09
3544869	3544869	DIVIDEND	CHANGE	61744G107		0	0	1	0	.148934		00	2018-12-20	2018-12-21	2019-01-15	2018-12-11		0	2018-12-11	?	0	0005772322			20190108.ifs	2019-01-08	2019-01-09
3544871	3544870	DIVIDEND	CHANGE	61744G107		0	0	1	0	.148934		00	2018-12-20	2018-12-21	2019-01-15	2018-12-11		1	2018-12-11	2019-01-08	0	0005772322			20190108.ifs	2019-01-08	2019-01-09
3421087	3421087	DIVIDEND	ADD	61744G107		0	0	1	0	.148934		00	2018-12-20	2018-12-21	2019-01-15	2018-12-11		0	2018-12-11	?	0	0005772322			20181211.ifs	2018-12-11	2018-12-12
3421088	3421088	DIVIDEND	ADD	61744G107		0	0	1	0	.148934		00	2018-12-20	2018-12-21	2019-01-15	2018-12-11		0	2018-12-11	?	0	0005772322			20181211.ifs	2018-12-11	2018-12-12
2822524	2822524	DIVIDEND	ADD	61744G107		0	0	1	0	.03215		00	2017-12-21	2017-12-22	2018-01-10	2017-12-12		0	2017-12-12	?	0	0005549377			20171212.ifs	2017-12-12	2017-12-13
2595928	2595928	DIVIDEND	ADD	61744G107		0	0	1	0	.025437		00	2017-06-28	2017-06-30	2017-07-14	2017-06-20		0	2017-06-20	?	0	0005451955			20170620.ifs	2017-06-20	2017-06-21
2451808	2451808	EQUITY	CHANGE	61744G107	COM	0	7	1991-10-25	?	1	yes	no		no		2003-04-08	2011-06-21	?							20170124.ifs	2017-01-24	2017-01-25
2451809	2451808	EQUITY	CHANGE	61744G107	COM	0	7	1991-10-25	?	2	yes	no		no		2003-04-08	2011-06-21	?							20170124.ifs	2017-01-24	2017-01-25
2370907	2370907	DIVIDEND	ADD	61744G107		0	0	1	0	.065918		00	2016-12-21	2016-12-23	2017-01-13	2016-12-13		0	2016-12-13	?	0	0005331268			20161213.ifs	2016-12-13	2016-12-14
2225219	2225219	DIVIDEND	ADD	61744G107		0	0	1	0	.027655		00	2016-06-28	2016-06-30	2016-07-15	2016-06-20		0	2016-06-20	?	0	0005235407			20160620.ifs	2016-06-20	2016-06-21
2027868	2027868	DIVIDEND	ADD	61744G107		0	0	1	0	.013793		00	2015-12-16	2015-12-18	2016-01-15	2015-12-08		0	2015-12-08	?	0	0005108064			20151208.ifs	2015-12-08	2015-12-09
1893551	1893551	DIVIDEND	DELETE	61744G107		0	0	1	0	.035911		00	2015-06-26	2015-06-30	2016-07-15	2015-06-19		0	2015-06-19	?	0	0005016799			20150623.ifs	2015-06-23	2015-06-24
1893552	1893552	DIVIDEND	ADD	61744G107		0	0	1	0	.035911		00	2015-06-26	2015-06-30	2015-07-15	2015-06-19		1	2015-06-19	2015-06-23	0	0005016799			20150623.ifs	2015-06-23	2015-06-24
1891118	1891118	DIVIDEND	ADD	61744G107		0	0	1	0	.035911		00	2015-06-26	2015-06-30	2016-07-15	2015-06-19		0	2015-06-19	?	0	0005016799			20150619.ifs	2015-06-19	2015-06-20
1704231	1704231	DIVIDEND	ADD	61744G107		0	0	1	0	.061849		00	2014-12-17	2014-12-19	2015-01-15	2014-12-09		0	2014-12-09	?	0	0004888456			20141209.ifs	2014-12-09	2014-12-10
1555665	1555665	DIVIDEND	ADD	61744G107		0	0	1	0	.054113		00	2014-06-26	2014-06-30	2014-07-15	2014-06-20		0	2014-06-20	?	0	0004799820			20140620.ifs	2014-06-20	2014-06-21
1211866	1211866	DIVIDEND	ADD	61744G107		0	0	1	0	.05258		00	2013-06-26	2013-06-28	2013-07-15	2013-06-18		0	2013-06-18	?	0	0004585169			20130618.ifs	2013-06-18	2013-06-19
1035441	1035441	DIVIDEND	ADD	61744G107		0	0	1	0	.082102		00	2012-12-19	2012-12-21	2013-01-04	2012-12-11		0	2012-12-11	?	0	0004475150			20121211.ifs	2012-12-11	2012-12-12
755686	755686	DIVIDEND	ADD	61744G107		0	0	E	0	0		58	?	?	2012-01-06	2012-01-12		0	2012-01-12	?	0	0004320298			20120112.ifs	2012-01-12	2012-01-13
565060	565060	EQUITY	CHANGE	61744G107	COM	0	0	1991-10-25	?	1	yes	no		no		2003-04-08	2008-07-22	?							20110621.ifs	2011-06-21	2011-06-22
565061	565060	EQUITY	CHANGE	61744G107	COM	0	7	1991-10-25	?	1	yes	no		no		2003-04-08	2011-06-21	?							20110621.ifs	2011-06-21	2011-06-22
222658	222658	DIVIDEND	ADD	61744G107		0	0	1	9	.0037		03	2010-06-28	2010-06-30	2010-07-15	2010-06-18		0	2010-06-18	?	0	0004020242			20100618.ifs	2010-06-18	2010-06-19
48388	48388	DIVIDEND	ADD	61744G107		0	0	1	0	.1865		00	2009-12-22	2009-12-24	2010-01-08	2009-12-14		0	2009-12-14	?	0	0003926008			20091214.ifs	2009-12-14	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 = 130772
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