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
3923841	3923841	DIVIDEND	ADD	009905100		0	0	E	0	0		58	?	?	2019-10-01	2019-09-13		0	2019-09-13	?	0	0005945176			20190913.ifs	2019-09-13	2019-09-14
3923917	3923917	DIVIDEND	ADD	009905100		0	0	E	0	0		58	?	?	2019-10-01	2019-09-13		0	2019-09-13	?	0	0005945176			20190913.ifs	2019-09-13	2019-09-14
3713816	3713816	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2019-06-18	2019-06-19	2019-07-03	2019-05-01		0	2019-05-01	?	0	0005880539			20190501.ifs	2019-05-01	2019-05-02
3713841	3713841	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2019-06-18	2019-06-19	2019-07-03	2019-05-01		0	2019-05-01	?	0	0005880539			20190501.ifs	2019-05-01	2019-05-02
3616540	3616540	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2019-03-14	2019-03-15	2019-04-02	2019-03-05		0	2019-03-05	?	0	0005850264			20190305.ifs	2019-03-05	2019-03-06
3616541	3616541	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2019-03-14	2019-03-15	2019-04-02	2019-03-05		0	2019-03-05	?	0	0005850264			20190305.ifs	2019-03-05	2019-03-06
3368161	3368161	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2018-12-13	2018-12-14	2019-01-04	2018-11-09		0	2018-11-09	?	0	0005753864			20181109.ifs	2018-11-09	2018-11-10
3368188	3368188	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2018-12-13	2018-12-14	2019-01-04	2018-11-09		0	2018-11-09	?	0	0005753864			20181109.ifs	2018-11-09	2018-11-10
3250316	3250316	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2018-09-14	2018-09-17	2018-10-01	2018-08-23		0	2018-08-24	?	0	0005711100			20180824.ifs	2018-08-24	2018-08-25
3250317	3250317	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2018-09-14	2018-09-17	2018-10-01	2018-08-23		0	2018-08-24	?	0	0005711100			20180824.ifs	2018-08-24	2018-08-25
3085939	3085939	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2018-06-15	2018-06-18	2018-07-02	2018-05-08		0	2018-05-09	?	0	0005659932			20180509.ifs	2018-05-09	2018-05-10
3085940	3085940	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2018-06-15	2018-06-18	2018-07-02	2018-05-08		0	2018-05-09	?	0	0005659932			20180509.ifs	2018-05-09	2018-05-10
2984738	2984738	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2018-03-15	2018-03-16	2018-04-03	2018-03-07		0	2018-03-07	?	0	0005627625			20180307.ifs	2018-03-07	2018-03-08
2984754	2984754	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2018-03-15	2018-03-16	2018-04-03	2018-03-07		0	2018-03-07	?	0	0005627625			20180307.ifs	2018-03-07	2018-03-08
2763175	2763175	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2017-12-14	2017-12-15	2018-01-05	2017-11-10		0	2017-11-10	?	0	0005529147			20171110.ifs	2017-11-10	2017-11-11
2763178	2763178	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2017-12-14	2017-12-15	2018-01-05	2017-11-10		0	2017-11-10	?	0	0005529147			20171110.ifs	2017-11-10	2017-11-11
2654468	2654468	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2017-09-15	2017-09-18	2017-10-02	2017-08-24		0	2017-08-24	?	0	0005485542			20170824.ifs	2017-08-24	2017-08-25
2564530	2564530	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2017-06-15	2017-06-19	2017-07-03	2017-05-09		0	2017-05-09	?	0	0005434240			20170509.ifs	2017-05-09	2017-05-10
2508289	2508289	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2017-03-15	2017-03-17	2017-04-03	2017-03-03		0	2017-03-06	?	0	0005400265			20170306.ifs	2017-03-06	2017-03-07
2342608	2342608	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2016-12-14	2016-12-16	2017-01-05	2016-11-11		0	2016-11-11	?	0	0005311015			20161111.ifs	2016-11-11	2016-11-12
2280030	2280030	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2016-09-15	2016-09-19	2016-10-03	2016-08-30		0	2016-08-30	?	0	0005270416			20160830.ifs	2016-08-30	2016-08-31
2194103	2194103	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2016-06-16	2016-06-20	2016-07-04	2016-05-10		0	2016-05-10	?	0	0005218045			20160510.ifs	2016-05-10	2016-05-11
2008995	2008995	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2015-12-15	2015-12-17	2016-01-04	2015-11-13		0	2015-11-13	?	0	0005093351			20151113.ifs	2015-11-13	2015-11-14
1925360	1925360	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2015-09-15	2015-09-17	2015-10-01	2015-07-29		0	2015-07-29	?	0	0005036453			20150729.ifs	2015-07-29	2015-07-30
1862942	1862942	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2015-06-16	2015-06-18	2015-07-02	2015-05-13		0	2015-05-13	?	0	0005000011			20150513.ifs	2015-05-13	2015-05-14
1805890	1805890	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2015-03-16	2015-03-18	2015-04-01	2015-03-04		0	2015-03-04	?	0	0004966085			20150304.ifs	2015-03-04	2015-03-05
1681486	1681486	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2014-12-17	2014-12-19	2015-01-02	2014-11-14		0	2014-11-14	?	0	0004873141			20141114.ifs	2014-11-14	2014-11-15
1578114	1578114	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2014-09-15	2014-09-17	2014-10-01	2014-07-10		0	2014-07-10	?	0	0004814486			20140710.ifs	2014-07-10	2014-07-11
1461111	1461111	DIVIDEND	ADD	009905100		A	0	2	0	.085		15	2014-03-14	2014-03-18	2014-04-01	2014-03-05		0	2014-03-05	?	0	0004748273			20140305.ifs	2014-03-05	2014-03-06
1339434	1339434	DIVIDEND	ADD	009905100		A	0	2	0	.08		15	2013-12-17	2013-12-19	2014-01-02	2013-11-13		0	2013-11-13	?	0	0004657702			20131113.ifs	2013-11-13	2013-11-14
1253425	1253425	DIVIDEND	ADD	009905100		A	0	2	0	.08		15	2013-08-15	2013-08-19	2013-09-02	2013-07-31		0	2013-07-31	?	0	0004606358			20130731.ifs	2013-07-31	2013-08-01
1186241	1186241	DIVIDEND	ADD	009905100		A	0	2	0	.08		15	2013-06-14	2013-06-18	2013-07-02	2013-05-15		0	2013-05-15	?	0	0004571510			20130515.ifs	2013-05-15	2013-05-16
1129716	1129716	DIVIDEND	ADD	009905100		A	0	2	0	.08		15	2013-03-14	2013-03-18	2013-04-01	2013-03-06		0	2013-03-06	?	0	0004539332			20130306.ifs	2013-03-06	2013-03-07
1007784	1007784	DIVIDEND	ADD	009905100		A	0	2	0	.07		15	2012-12-14	2012-12-18	2013-01-02	2012-11-08		0	2012-11-08	?	0	0004457130			20121108.ifs	2012-11-08	2012-11-09
941691	941691	DIVIDEND	ADD	009905100		A	0	2	0	.07		15	2012-09-13	2012-09-17	2012-10-01	2012-08-29		0	2012-08-29	?	0	0004419140			20120829.ifs	2012-08-29	2012-08-30
935196	935196	DIVIDEND	CHANGE	009905100		A	0	2	0	.07		15	2012-03-15	2012-03-19	2012-04-02	2012-03-13		1	2012-03-14	2012-03-15	0	0004345223			20120817.ifs	2012-08-17	2012-08-18
935197	935196	DIVIDEND	CHANGE	009905100		A	0	2	0	.07		15	2012-03-15	2012-03-19	2012-04-02	2012-03-13		2	2012-03-14	2012-08-17	0	0004345223			20120817.ifs	2012-08-17	2012-08-18
856598	856598	DIVIDEND	ADD	009905100		A	0	2	0	.07		15	2012-06-15	2012-06-19	2012-07-03	2012-05-07		0	2012-05-07	?	0	0004372864			20120507.ifs	2012-05-07	2012-05-08
803405	803405	DIVIDEND	DELETE	009905100		A	0	2	0	.07		15	?	2012-03-19	2012-04-02	2012-03-13		0	2012-03-14	?	0	0004345223			20120315.ifs	2012-03-15	2012-03-16
803406	803406	DIVIDEND	ADD	009905100		A	0	2	0	.07		15	2012-03-15	2012-03-19	2012-04-02	2012-03-13		1	2012-03-14	2012-03-15	0	0004345223			20120315.ifs	2012-03-15	2012-03-16
802273	802273	DIVIDEND	ADD	009905100		A	0	2	0	.07		15	?	2012-03-19	2012-04-02	2012-03-13		0	2012-03-14	?	0	0004345223			20120314.ifs	2012-03-14	2012-03-15
692018	692018	DIVIDEND	ADD	009905100		A	0	2	0	.07		15	2011-12-15	2011-12-19	2012-01-03	2011-11-08		0	2011-11-08	?	0	0004268907			20111108.ifs	2011-11-08	2011-11-09
631591	631591	DIVIDEND	ADD	009905100		A	0	2	0	.07		15	2011-09-15	2011-09-19	2011-10-03	2011-08-31		0	2011-08-31	?	0	0004234181			20110831.ifs	2011-08-31	2011-09-01
523169	523169	DIVIDEND	ADD	009905100		A	0	2	0	.07		15	2011-06-16	2011-06-20	2011-07-04	2011-05-09		0	2011-05-09	?	0	0004187145			20110509.ifs	2011-05-09	2011-05-10
475058	475058	DIVIDEND	ADD	009905100		A	0	2	0	.07		15	2011-03-24	2011-03-28	2011-04-04	2011-03-18		0	2011-03-18	?	0	0004161003			20110318.ifs	2011-03-18	2011-03-19
351736	351736	DIVIDEND	ADD	009905100		A	0	2	0	.07		15	2010-12-16	2010-12-20	2011-01-04	2010-11-08		0	2010-11-08	?	0	0004086047			20101108.ifs	2010-11-08	2010-11-09
314806	314806	DIVIDEND	ADD	009905100		A	0	2	0	.07		15	2010-10-04	2010-10-06	2010-10-15	2010-09-24		0	2010-09-24	?	0	0004063999			20100924.ifs	2010-09-24	2010-09-25
190085	190085	DIVIDEND	ADD	009905100		A	0	2	0	.07		15	2010-06-17	2010-06-21	2010-07-02	2010-05-11		0	2010-05-11	?	0	0004005348			20100511.ifs	2010-05-11	2010-05-12
139919	139919	DIVIDEND	ADD	009905100		A	0	2	0	.07		15	2010-03-30	2010-04-01	2010-04-08	2010-03-24		0	2010-03-24	?	0	0003982163			20100324.ifs	2010-03-24	2010-04-07
17813	17813	DIVIDEND	ADD	009905100		A	0	2	0	.07		15	2009-12-16	2009-12-18	2010-01-04	2009-11-03		0	2009-11-03	?	0	0003906258			20091103.ifs	2009-11-03	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 = 145429
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