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
3171867	3171867	CORPACTION	ADD	494580103	01	A	2018-07-02			?															20180702.ifs	2018-07-02	2018-07-03
3171868	3171868	EQUITY	CHANGE	494580103	COM	0	0	2001-03-14	?	4	yes	yes		no		2004-10-27	2002-03-12	?							20180702.ifs	2018-07-02	2018-07-03
3171869	3171868	EQUITY	CHANGE	494580103	COM	A	0	2001-03-14	2018-07-02	4	yes	yes		no		2004-10-27	2018-07-02	?							20180702.ifs	2018-07-02	2018-07-03
3172830	3172830	CORPACTION	ADD	494580103	01	A	2018-07-02			?															20180702.ifs	2018-07-02	2018-07-03
3172832	3172832	EQUITY	CHANGE	494580103	COM	0	0	2001-03-14	?	4	yes	yes		no		2004-10-27	2002-03-12	?							20180702.ifs	2018-07-02	2018-07-03
3172834	3172833	EQUITY	CHANGE	494580103	COM	A	0	2001-03-14	2018-07-02	4	yes	yes		no		2004-10-27	2018-07-02	?							20180702.ifs	2018-07-02	2018-07-03
2887012	2887012	DIVIDEND	CHANGE	494580103		0	0	E	0	0		58	?	?	2017-06-30	2017-02-27		0	2017-02-27	?	1	0005392118			20171228.ifs	2017-12-28	2017-12-29
2887014	2887013	DIVIDEND	CHANGE	494580103		0	0	E	0	0		58	?	?	2017-06-30	2017-02-27		1	2017-02-27	2017-12-28	1	0005392118			20171228.ifs	2017-12-28	2017-12-29
2888130	2888130	DIVIDEND	CHANGE	494580103		0	0	E	0	0		58	?	?	2017-06-30	2017-02-27		0	2017-02-27	?	1	0005392118			20171228.ifs	2017-12-28	2017-12-29
2888132	2888131	DIVIDEND	CHANGE	494580103		0	0	E	0	0		58	?	?	2017-06-30	2017-02-27		1	2017-02-27	2017-12-28	1	0005392118			20171228.ifs	2017-12-28	2017-12-29
2496627	2496627	DIVIDEND	ADD	494580103		0	0	E	0	0		58	?	?	2017-06-30	2017-02-27		0	2017-02-27	?	1	0005392118			20170227.ifs	2017-02-27	2017-02-28
2496628	2496628	DIVIDEND	ADD	494580103		0	0	1	0	.12		00	2017-03-09	2017-03-13	2017-03-31	2017-02-27		0	2017-02-27	?	0	0005392116			20170227.ifs	2017-02-27	2017-02-28
2440970	2440970	EQUITY	CHANGE	494580103	COM	0	0	2001-03-14	?	0	yes	yes		no		2004-10-27	2002-03-12	?							20170123.ifs	2017-01-23	2017-01-24
2440971	2440970	EQUITY	CHANGE	494580103	COM	0	0	2001-03-14	?	4	yes	yes		no		2004-10-27	2002-03-12	?							20170123.ifs	2017-01-23	2017-01-24
2340313	2340313	DIVIDEND	ADD	494580103		0	0	1	0	.12		00	2016-11-17	2016-11-21	2016-12-09	2016-11-07		0	2016-11-07	?	0	0005310245			20161107.ifs	2016-11-07	2016-11-08
2266782	2266782	DIVIDEND	ADD	494580103		0	0	1	0	.12		00	2016-08-16	2016-08-18	2016-09-02	2016-08-04		0	2016-08-04	?	0	0005263936			20160804.ifs	2016-08-04	2016-08-05
2191237	2191237	DIVIDEND	ADD	494580103		0	0	1	0	.12		00	2016-05-16	2016-05-18	2016-06-10	2016-05-04		0	2016-05-04	?	0	0005216990			20160504.ifs	2016-05-04	2016-05-05
2119097	2119097	DIVIDEND	ADD	494580103		0	0	1	0	.12		00	2016-03-08	2016-03-10	2016-04-01	2016-02-25		0	2016-02-25	?	0	0005176015			20160225.ifs	2016-02-25	2016-02-26
2003826	2003826	DIVIDEND	ADD	494580103		0	0	1	0	.12		00	2015-11-16	2015-11-18	2015-12-11	2015-11-04		0	2015-11-04	?	0	0005090830			20151104.ifs	2015-11-04	2015-11-05
1937094	1937094	DIVIDEND	ADD	494580103		0	0	1	0	.12		00	2015-08-17	2015-08-19	2015-09-04	2015-08-05		0	2015-08-05	?	0	0005045554			20150805.ifs	2015-08-05	2015-08-06
1858856	1858856	DIVIDEND	ADD	494580103		0	0	1	0	.12		00	2015-05-18	2015-05-20	2015-06-10	2015-05-06		0	2015-05-06	?	0	0004998573			20150506.ifs	2015-05-06	2015-05-07
1796417	1796417	DIVIDEND	ADD	494580103		0	0	1	0	.12		00	2015-03-09	2015-03-11	2015-04-01	2015-02-26		0	2015-02-26	?	0	0004958423			20150226.ifs	2015-02-26	2015-02-27
1677077	1677077	DIVIDEND	ADD	494580103		0	0	1	0	.12		00	2014-11-14	2014-11-18	2014-12-09	2014-11-05		0	2014-11-06	?	0	0004871265			20141106.ifs	2014-11-06	2014-11-07
1600717	1600717	DIVIDEND	ADD	494580103		0	0	1	0	.12		00	2014-08-18	2014-08-20	2014-09-10	2014-08-06		0	2014-08-06	?	0	0004827259			20140806.ifs	2014-08-06	2014-08-07
1520808	1520808	DIVIDEND	ADD	494580103		0	0	1	0	.12		00	2014-05-19	2014-05-21	2014-06-11	2014-05-07		0	2014-05-07	?	0	0004781238			20140507.ifs	2014-05-07	2014-05-08
1446959	1446959	DIVIDEND	ADD	494580103		0	0	1	0	.12		00	2014-03-04	2014-03-06	2014-03-27	2014-02-20		0	2014-02-20	?	0	0004738367			20140220.ifs	2014-02-20	2014-02-21
1335588	1335588	DIVIDEND	ADD	494580103		0	0	1	0	.12		00	2013-11-14	2013-11-18	2013-12-09	2013-11-05		0	2013-11-05	?	0	0004656494			20131105.ifs	2013-11-05	2013-11-06
1259570	1259570	DIVIDEND	ADD	494580103		0	0	1	0	.12		00	2013-08-15	2013-08-19	2013-09-09	2013-08-05		0	2013-08-05	?	0	0004613513			20130805.ifs	2013-08-05	2013-08-06

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