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
3324318	3324318	CORPACTION	ADD	212485106	01	M	2018-10-05	87162W100	01	2018-10-05															20181005.ifs	2018-10-05	2018-10-06
3324320	3324320	EQUITY	CHANGE	212485106	COM	0	0	1998-07-13	?	4	yes	yes		no		1998-11-19	2001-06-22	?							20181005.ifs	2018-10-05	2018-10-06
3324322	3324321	EQUITY	CHANGE	212485106	COM	M	0	1998-07-13	2018-10-05	4	yes	yes	87162W100	no		1998-11-19	2018-10-05	?							20181005.ifs	2018-10-05	2018-10-06
3324375	3324375	CORPACTION	ADD	212485106	01	M	2018-10-05	87162W100	01	2018-10-05															20181005.ifs	2018-10-05	2018-10-06
3324377	3324377	EQUITY	CHANGE	212485106	COM	0	0	1998-07-13	?	4	yes	yes		no		1998-11-19	2001-06-22	?							20181005.ifs	2018-10-05	2018-10-06
3324379	3324378	EQUITY	CHANGE	212485106	COM	M	0	1998-07-13	2018-10-05	4	yes	yes	87162W100	no		1998-11-19	2018-10-05	?							20181005.ifs	2018-10-05	2018-10-06
3322903	3322903	DIVIDEND	CHANGE	212485106		0	0	1	0	.11		00	2018-09-20	2018-09-21	2018-10-02	2018-09-05		1	2018-09-05	2018-10-02	0	0005720160			20181004.ifs	2018-10-04	2018-10-05
3322905	3322904	DIVIDEND	CHANGE	212485106		0	0	1	0	.11		00	2018-09-20	2018-09-21	2018-10-02	2018-09-05		2	2018-09-05	2018-10-04	0	0005720160			20181004.ifs	2018-10-04	2018-10-05
3323188	3323188	DIVIDEND	CHANGE	212485106		0	0	1	0	.11		00	2018-09-20	2018-09-21	2018-10-02	2018-09-05		1	2018-09-05	2018-10-02	0	0005720160			20181004.ifs	2018-10-04	2018-10-05
3323190	3323189	DIVIDEND	CHANGE	212485106		0	0	1	0	.11		00	2018-09-20	2018-09-21	2018-10-02	2018-09-05		2	2018-09-05	2018-10-04	0	0005720160			20181004.ifs	2018-10-04	2018-10-05
3270525	3270525	DIVIDEND	ADD	212485106		0	0	1	0	.11		00	2018-09-20	2018-09-21	2018-10-02	2018-09-05		0	2018-09-05	?	0	0005720160			20180905.ifs	2018-09-05	2018-09-06
3270691	3270691	DIVIDEND	ADD	212485106		0	0	1	0	.11		00	2018-09-20	2018-09-21	2018-10-02	2018-09-05		0	2018-09-05	?	0	0005720160			20180905.ifs	2018-09-05	2018-09-06
3178844	3178844	DIVIDEND	CHANGE	212485106		0	0	1	0	.11		00	2018-06-21	2018-06-22	2018-07-06	2018-05-08		0	2018-05-09	?	0	0005659916			20180702.ifs	2018-07-02	2018-07-03
3178845	3178844	DIVIDEND	CHANGE	212485106		0	0	1	0	.11		00	2018-06-21	2018-06-22	2018-07-06	2018-05-08		1	2018-05-09	2018-07-02	0	0005659916			20180702.ifs	2018-07-02	2018-07-03
3179986	3179986	DIVIDEND	CHANGE	212485106		0	0	1	0	.11		00	2018-06-21	2018-06-22	2018-07-06	2018-05-08		0	2018-05-09	?	0	0005659916			20180702.ifs	2018-07-02	2018-07-03
3179987	3179986	DIVIDEND	CHANGE	212485106		0	0	1	0	.11		00	2018-06-21	2018-06-22	2018-07-06	2018-05-08		1	2018-05-09	2018-07-02	0	0005659916			20180702.ifs	2018-07-02	2018-07-03
3085381	3085381	DIVIDEND	ADD	212485106		0	0	1	0	.11		00	2018-06-21	2018-06-22	2018-07-06	2018-05-08		0	2018-05-09	?	0	0005659916			20180509.ifs	2018-05-09	2018-05-10
3085382	3085382	DIVIDEND	ADD	212485106		0	0	1	0	.11		00	2018-06-21	2018-06-22	2018-07-06	2018-05-08		0	2018-05-09	?	0	0005659916			20180509.ifs	2018-05-09	2018-05-10
2961513	2961513	DIVIDEND	ADD	212485106		0	0	1	0	.1		00	2018-03-22	2018-03-23	2018-04-06	2018-02-21		0	2018-02-22	?	0	0005617291			20180222.ifs	2018-02-22	2018-02-23
2961518	2961518	DIVIDEND	ADD	212485106		0	0	1	0	.1		00	2018-03-22	2018-03-23	2018-04-06	2018-02-21		0	2018-02-22	?	0	0005617291			20180222.ifs	2018-02-22	2018-02-23
2760674	2760674	DIVIDEND	ADD	212485106		0	0	1	0	.1		00	2017-12-21	2017-12-22	2018-01-05	2017-11-07		0	2017-11-08	?	0	0005528167			20171108.ifs	2017-11-08	2017-11-09
2760721	2760721	DIVIDEND	ADD	212485106		0	0	1	0	.1		00	2017-12-21	2017-12-22	2018-01-05	2017-11-07		0	2017-11-08	?	0	0005528167			20171108.ifs	2017-11-08	2017-11-09
2646744	2646744	DIVIDEND	ADD	212485106		0	0	1	0	.1		00	2017-09-21	2017-09-22	2017-10-06	2017-08-08		0	2017-08-09	?	0	0005481907			20170809.ifs	2017-08-09	2017-08-10
2563834	2563834	DIVIDEND	ADD	212485106		0	0	1	0	.1		00	2017-06-21	2017-06-23	2017-07-07	2017-05-08		0	2017-05-08	?	0	0005433911			20170508.ifs	2017-05-08	2017-05-09
2495921	2495921	DIVIDEND	ADD	212485106		0	0	1	0	.09		00	2017-03-22	2017-03-24	2017-04-07	2017-02-21		0	2017-02-24	?	0	0005391195			20170224.ifs	2017-02-24	2017-02-25
2436516	2436516	EQUITY	CHANGE	212485106	COM	0	0	1998-07-13	?	8	yes	yes		no		1998-11-19	2001-06-22	?							20170123.ifs	2017-01-23	2017-01-24
2436517	2436516	EQUITY	CHANGE	212485106	COM	0	0	1998-07-13	?	4	yes	yes		no		1998-11-19	2001-06-22	?							20170123.ifs	2017-01-23	2017-01-24
2340950	2340950	DIVIDEND	ADD	212485106		0	0	1	0	.09		00	2016-12-21	2016-12-23	2017-01-06	2016-11-08		0	2016-11-08	?	0	0005310408			20161108.ifs	2016-11-08	2016-11-09
2268095	2268095	DIVIDEND	ADD	212485106		0	0	1	0	.09		00	2016-09-21	2016-09-23	2016-10-07	2016-08-08		0	2016-08-08	?	0	0005264484			20160808.ifs	2016-08-08	2016-08-09
2193214	2193214	DIVIDEND	ADD	212485106		0	0	1	0	.09		00	2016-06-22	2016-06-24	2016-07-08	2016-05-09		0	2016-05-09	?	0	0005217827			20160509.ifs	2016-05-09	2016-05-10
2117414	2117414	DIVIDEND	ADD	212485106		0	0	1	0	.08		00	2016-03-22	2016-03-24	2016-04-08	2016-02-23		0	2016-02-23	?	0	0005174887			20160223.ifs	2016-02-23	2016-02-24
2004626	2004626	DIVIDEND	ADD	212485106		0	0	1	0	.08		00	2015-12-22	2015-12-24	2016-01-08	2015-11-04		0	2015-11-05	?	0	0005091342			20151105.ifs	2015-11-05	2015-11-06
1936401	1936401	DIVIDEND	ADD	212485106		0	0	1	0	.08		00	2015-09-16	2015-09-18	2015-10-02	2015-08-04		0	2015-08-04	?	0	0005045050			20150804.ifs	2015-08-04	2015-08-05
1792627	1792627	DIVIDEND	ADD	212485106		0	0	1	0	.07		00	2015-03-18	2015-03-20	2015-04-03	2015-02-18		0	2015-02-18	?	0	0004955665			20150218.ifs	2015-02-18	2015-02-19
1676216	1676216	DIVIDEND	ADD	212485106		0	0	1	0	.07		00	2014-12-23	2014-12-26	2015-01-09	2014-11-04		0	2014-11-05	?	0	0004871167			20141105.ifs	2014-11-05	2014-11-06
1604314	1604314	DIVIDEND	ADD	212485106		0	0	1	0	.07		00	2014-09-17	2014-09-19	2014-10-03	2014-08-11		0	2014-08-11	?	0	0004828133			20140811.ifs	2014-08-11	2014-08-12
1522826	1522826	DIVIDEND	ADD	212485106		0	0	1	0	.07		00	2014-06-17	2014-06-19	2014-07-03	2014-05-12		0	2014-05-12	?	0	0004781893			20140512.ifs	2014-05-12	2014-05-13
1439672	1439672	DIVIDEND	ADD	212485106		0	0	1	0	.06		00	2014-03-19	2014-03-21	2014-04-04	2014-02-05		0	2014-02-05	?	0	0004734665			20140205.ifs	2014-02-05	2014-02-06
1336477	1336477	DIVIDEND	ADD	212485106		0	0	1	0	.06		00	2013-12-24	2013-12-27	2014-01-10	2013-11-06		0	2013-11-06	?	0	0004656691			20131106.ifs	2013-11-06	2013-11-07
1313870	1313870	DIVIDEND	CHANGE	212485106		0	0	1	0	.06		00	2013-09-18	2013-09-20	2013-10-04	2013-07-29		0	2013-07-29	?	0	0004604965			20131009.ifs	2013-10-09	2013-10-10
1313871	1313870	DIVIDEND	CHANGE	212485106		0	0	1	0	.06		00	2013-09-18	2013-09-20	2013-10-04	2013-07-29		1	2013-07-29	2013-10-09	0	0004604965			20131009.ifs	2013-10-09	2013-10-10
1248854	1248854	DIVIDEND	ADD	212485106		0	0	1	0	.06		00	2013-09-18	2013-09-20	2013-10-04	2013-07-29		0	2013-07-29	?	0	0004604965			20130729.ifs	2013-07-29	2013-07-30
1172954	1172954	DIVIDEND	ADD	212485106		0	0	1	0	.06		00	2013-06-19	2013-06-21	2013-07-05	2013-04-30		0	2013-04-30	?	0	0004562241			20130430.ifs	2013-04-30	2013-05-01
1109670	1109670	DIVIDEND	ADD	212485106		0	0	1	0	.06		00	2013-03-20	2013-03-22	2013-04-05	2013-02-07		0	2013-02-07	?	0	0004526661			20130207.ifs	2013-02-07	2013-02-08
991314	991314	DIVIDEND	ADD	212485106		0	0	1	0	.05		00	2012-12-19	2012-12-21	2013-01-04	2012-10-23		0	2012-10-23	?	0	0004447377			20121023.ifs	2012-10-23	2012-10-24
922080	922080	DIVIDEND	ADD	212485106		0	0	1	0	.05		00	2012-09-19	2012-09-21	2012-10-05	2012-07-26		0	2012-07-26	?	0	0004405622			20120726.ifs	2012-07-26	2012-07-27
857203	857203	DIVIDEND	ADD	212485106		0	0	1	0	.05		00	2012-06-20	2012-06-22	2012-07-06	2012-05-08		0	2012-05-08	?	0	0004373058			20120508.ifs	2012-05-08	2012-05-09

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