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
2505916	2505916	CORPACTION	ADD	294752100	01	M	2017-03-02	758849103	01	2017-03-02															20170302.ifs	2017-03-02	2017-03-03
2505917	2505917	EQUITY	CHANGE	294752100	COM	0	0	1998-05-14	?	4	yes	no		no		1998-06-18	2017-03-01	?							20170302.ifs	2017-03-02	2017-03-03
2505918	2505917	EQUITY	CHANGE	294752100	COM	M	0	1998-05-14	2017-03-02	4	yes	no	758849103	no		1998-06-18	2017-03-02	?							20170302.ifs	2017-03-02	2017-03-03
2501509	2501509	CORPACTION	ADD	294752100	01	M	2017-03-01	758849103	01	?															20170301.ifs	2017-03-01	2017-03-02
2501510	2501510	EQUITY	CHANGE	294752100	COM	0	0	1998-05-14	?	4	yes	no		no		1998-06-18	?	?							20170301.ifs	2017-03-01	2017-03-02
2501511	2501510	EQUITY	CHANGE	294752100	COM	M	0	1998-05-14	2017-03-01	4	yes	no	758849103	no		1998-06-18	2017-03-01	?							20170301.ifs	2017-03-01	2017-03-02
2501977	2501977	CORPACTION	DELETE	294752100	01	M	2017-03-01	758849103	01	?															20170301.ifs	2017-03-01	2017-03-02
2501978	2501978	EQUITY	CHANGE	294752100	COM	M	0	1998-05-14	2017-03-01	4	yes	no	758849103	no		1998-06-18	2017-03-01	?							20170301.ifs	2017-03-01	2017-03-02
2501979	2501978	EQUITY	CHANGE	294752100	COM	0	0	1998-05-14	?	4	yes	no		no		1998-06-18	2017-03-01	?							20170301.ifs	2017-03-01	2017-03-02
2504838	2504838	DIVIDEND	CHANGE	294752100		0	0	1	0	.18089		00	2017-02-22	2017-02-24	2017-02-28	2017-02-13		1	2017-02-14	2017-02-15	0	0005388192			20170301.ifs	2017-03-01	2017-03-02
2504839	2504838	DIVIDEND	CHANGE	294752100		0	0	1	0	.18089		00	2017-02-22	2017-02-24	2017-02-28	2017-02-13		2	2017-02-14	2017-03-01	0	0005388192			20170301.ifs	2017-03-01	2017-03-02
2490827	2490827	DIVIDEND	CHANGE	294752100		0	0	1	0	.18089		00	2017-02-22	2017-02-24	2017-02-28	2017-02-13		0	2017-02-14	?	0	0005388192			20170215.ifs	2017-02-15	2017-02-16
2490828	2490827	DIVIDEND	CHANGE	294752100		0	0	1	0	.18089		00	2017-02-22	2017-02-24	2017-02-28	2017-02-13		1	2017-02-14	2017-02-15	0	0005388192			20170215.ifs	2017-02-15	2017-02-16
2490106	2490106	DIVIDEND	ADD	294752100		0	0	1	0	.18089		00	2017-02-22	2017-02-24	2017-02-28	2017-02-13		0	2017-02-14	?	0	0005388192			20170214.ifs	2017-02-14	2017-02-15
2344450	2344450	DIVIDEND	CHANGE	294752100		0	0	1	0	.22		00	2016-12-14	2016-12-16	2016-12-30	2016-11-04		0	2016-11-04	?	0	0005310028			20161116.ifs	2016-11-16	2016-11-17
2344451	2344450	DIVIDEND	CHANGE	294752100		0	0	1	0	.22		00	2016-12-14	2016-12-16	2016-12-30	2016-11-04		1	2016-11-04	2016-11-16	0	0005310028			20161116.ifs	2016-11-16	2016-11-17
2339504	2339504	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2016-12-14	2016-12-16	2016-12-30	2016-11-04		0	2016-11-04	?	0	0005310028			20161104.ifs	2016-11-04	2016-11-05
2270368	2270368	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2016-09-14	2016-09-16	2016-09-30	2016-08-12		0	2016-08-12	?	0	0005265437			20160812.ifs	2016-08-12	2016-08-13
2196907	2196907	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2016-06-14	2016-06-16	2016-06-30	2016-05-13		0	2016-05-13	?	0	0005218768			20160513.ifs	2016-05-13	2016-05-14
2123127	2123127	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2016-03-15	2016-03-17	2016-03-31	2016-02-29		0	2016-02-29	?	0	0005177792			20160229.ifs	2016-02-29	2016-03-01
2025372	2025372	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2015-12-15	2015-12-17	2015-12-31	2015-12-04		0	2015-12-04	?	0	0005105957			20151204.ifs	2015-12-04	2015-12-05
1860668	1860668	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2015-06-12	2015-06-16	2015-06-30	2015-05-08		0	2015-05-08	?	0	0004999172			20150508.ifs	2015-05-08	2015-05-09
1807242	1807242	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2015-03-13	2015-03-17	2015-03-31	2015-03-06		0	2015-03-06	?	0	0004966598			20150306.ifs	2015-03-06	2015-03-07
1682941	1682941	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2014-12-15	2014-12-17	2014-12-31	2014-11-18		0	2014-11-18	?	0	0004873781			20141118.ifs	2014-11-18	2014-11-19
1605175	1605175	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2014-09-12	2014-09-16	2014-09-30	2014-08-12		0	2014-08-12	?	0	0004828362			20140812.ifs	2014-08-12	2014-08-13
1522820	1522820	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2014-06-12	2014-06-16	2014-06-30	2014-05-12		0	2014-05-12	?	0	0004781894			20140512.ifs	2014-05-12	2014-05-13
1461063	1461063	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2014-03-13	2014-03-17	2014-03-31	2014-03-05		0	2014-03-05	?	0	0004748171			20140305.ifs	2014-03-05	2014-03-06
1342947	1342947	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2013-12-13	2013-12-17	2013-12-31	2013-11-20		0	2013-11-20	?	0	0004659843			20131120.ifs	2013-11-20	2013-11-21
1264265	1264265	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2013-09-12	2013-09-16	2013-09-30	2013-08-14		0	2013-08-14	?	0	0004615488			20130814.ifs	2013-08-14	2013-08-15
1183910	1183910	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2013-06-12	2013-06-14	2013-06-28	2013-05-10		0	2013-05-10	?	0	0004570609			20130510.ifs	2013-05-10	2013-05-11
1115004	1115004	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2013-03-13	2013-03-15	2013-03-29	2013-02-18		0	2013-02-20	?	0	0004529393			20130220.ifs	2013-02-20	2013-02-21
1014139	1014139	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2012-12-13	2012-12-17	2012-12-31	2012-11-21		0	2012-11-21	?	0	0004460458			20121121.ifs	2012-11-21	2012-11-22
862511	862511	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2012-06-13	2012-06-15	2012-06-29	2012-05-16		0	2012-05-16	?	0	0004374501			20120516.ifs	2012-05-16	2012-05-17
784095	784095	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2012-03-14	2012-03-16	2012-03-30	2012-02-20		0	2012-02-23	?	0	0004334849			20120223.ifs	2012-02-23	2012-02-24
709547	709547	DIVIDEND	DELETE	294752100		0	0	1	0	.22		00	2011-12-14	2011-12-16	2011-12-31	2011-11-02		0	2011-11-03	?	0	0004268022			20111201.ifs	2011-12-01	2011-12-02
709548	709548	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2011-12-14	2011-12-16	2011-12-30	2011-11-02		1	2011-11-03	2011-12-01	0	0004268022			20111201.ifs	2011-12-01	2011-12-02
689949	689949	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2011-12-14	2011-12-16	2011-12-31	2011-11-02		0	2011-11-03	?	0	0004268022			20111103.ifs	2011-11-03	2011-11-04
604989	604989	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2011-09-13	2011-09-15	2011-09-30	2011-08-02		0	2011-08-03	?	0	0004227455			20110803.ifs	2011-08-03	2011-08-04
520277	520277	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2011-06-13	2011-06-15	2011-06-30	2011-05-02		0	2011-05-04	?	0	0004186226			20110504.ifs	2011-05-04	2011-05-05
450318	450318	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2011-03-11	2011-03-15	2011-03-31	2011-02-22		0	2011-02-23	?	0	0004149332			20110223.ifs	2011-02-23	2011-02-24
349319	349319	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2010-12-15	2010-12-17	2010-12-31	2010-11-02		0	2010-11-03	?	0	0004085059			20101103.ifs	2010-11-03	2010-11-04
272414	272414	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2010-09-13	2010-09-15	2010-09-30	2010-08-03		0	2010-08-04	?	0	0004045308			20100804.ifs	2010-08-04	2010-08-05
185286	185286	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2010-06-11	2010-06-15	2010-06-30	2010-05-04		0	2010-05-05	?	0	0004004046			20100505.ifs	2010-05-05	2010-05-06
127721	127721	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2010-03-11	2010-03-15	2010-03-31	2010-03-02		0	2010-03-04	?	0	0003975967			20100304.ifs	2010-03-04	2010-04-07
18423	18423	DIVIDEND	ADD	294752100		0	0	1	0	.22		00	2009-12-11	2009-12-15	2009-12-31	2009-11-04		0	2009-11-04	?	0	0003906578			20091104.ifs	2009-11-04	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 = 130850
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