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
4004204	4004204	CORPACTION	ADD	860326107	60	A	2019-11-01	197641103	60	2019-11-04															20191104.ifs	2019-11-04	2019-11-05
4004205	4004205	EQUITY	CHANGE	860326107	COM	0	0	1997-10-21	?	4	no	no		no		1999-12-16	?	?							20191104.ifs	2019-11-04	2019-11-05
4004206	4004205	EQUITY	CHANGE	860326107	COM	A	0	1997-10-21	2019-11-01	4	no	no	197641103	no		1999-12-16	2019-11-04	?							20191104.ifs	2019-11-04	2019-11-05
4004248	4004248	CORPACTION	ADD	860326107	60	A	2019-11-01	197641103	60	2019-11-04															20191104.ifs	2019-11-04	2019-11-05
4004250	4004250	EQUITY	CHANGE	860326107	COM	0	0	1997-10-21	?	4	no	no		no		1999-12-16	?	?							20191104.ifs	2019-11-04	2019-11-05
4004252	4004251	EQUITY	CHANGE	860326107	COM	A	0	1997-10-21	2019-11-01	4	no	no	197641103	no		1999-12-16	2019-11-04	?							20191104.ifs	2019-11-04	2019-11-05
3997762	3997762	DIVIDEND	CHANGE	860326107		0	0	1	0	.03		00	2019-07-31	2019-08-01	2019-08-15	2019-07-18		0	2019-07-18	?	0	0005917551			20191101.ifs	2019-11-01	2019-11-02
3997763	3997763	DIVIDEND	CHANGE	860326107		0	0	1	0	.03		00	2019-07-31	2019-08-01	2019-08-15	2019-07-18		0	2019-07-18	?	0	0005917551			20191101.ifs	2019-11-01	2019-11-02
3997764	3997763	DIVIDEND	CHANGE	860326107		0	0	1	0	.03		00	2019-07-31	2019-08-01	2019-08-15	2019-07-18		1	2019-07-18	2019-11-01	0	0005917551			20191101.ifs	2019-11-01	2019-11-02
3997765	3997764	DIVIDEND	CHANGE	860326107		0	0	1	0	.03		00	2019-07-31	2019-08-01	2019-08-15	2019-07-18		1	2019-07-18	2019-11-01	0	0005917551			20191101.ifs	2019-11-01	2019-11-02
3839102	3839102	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2019-07-31	2019-08-01	2019-08-15	2019-07-18		0	2019-07-18	?	0	0005917551			20190718.ifs	2019-07-18	2019-07-19
3839103	3839103	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2019-07-31	2019-08-01	2019-08-15	2019-07-18		0	2019-07-18	?	0	0005917551			20190718.ifs	2019-07-18	2019-07-19
3686459	3686459	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2019-04-30	2019-05-01	2019-05-15	2019-04-17		0	2019-04-17	?	0	0005871261			20190417.ifs	2019-04-17	2019-04-18
3686462	3686462	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2019-04-30	2019-05-01	2019-05-15	2019-04-17		0	2019-04-17	?	0	0005871261			20190417.ifs	2019-04-17	2019-04-18
3552030	3552030	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2019-01-31	2019-02-01	2019-02-15	2019-01-16		0	2019-01-16	?	0	0005826396			20190116.ifs	2019-01-16	2019-01-17
3552053	3552053	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2019-01-31	2019-02-01	2019-02-15	2019-01-16		0	2019-01-16	?	0	0005826396			20190116.ifs	2019-01-16	2019-01-17
3331490	3331490	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2018-10-31	2018-11-01	2018-11-15	2018-10-17		0	2018-10-17	?	0	0005741461			20181017.ifs	2018-10-17	2018-10-18
3331491	3331491	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2018-10-31	2018-11-01	2018-11-15	2018-10-17		0	2018-10-17	?	0	0005741461			20181017.ifs	2018-10-17	2018-10-18
3197532	3197532	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2018-07-31	2018-08-01	2018-08-15	2018-07-18		0	2018-07-18	?	0	0005694867			20180718.ifs	2018-07-18	2018-07-19
3197533	3197533	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2018-07-31	2018-08-01	2018-08-15	2018-07-18		0	2018-07-18	?	0	0005694867			20180718.ifs	2018-07-18	2018-07-19
3042111	3042111	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2018-04-30	2018-05-01	2018-05-15	2018-04-18		0	2018-04-18	?	0	0005648015			20180418.ifs	2018-04-18	2018-04-19
3042134	3042134	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2018-04-30	2018-05-01	2018-05-15	2018-04-18		0	2018-04-18	?	0	0005648015			20180418.ifs	2018-04-18	2018-04-19
2920339	2920339	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2018-01-31	2018-02-01	2018-02-15	2018-01-17		0	2018-01-17	?	0	0005602110			20180117.ifs	2018-01-17	2018-01-18
2920340	2920340	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2018-01-31	2018-02-01	2018-02-15	2018-01-17		0	2018-01-17	?	0	0005602110			20180117.ifs	2018-01-17	2018-01-18
2727456	2727456	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2017-10-31	2017-11-01	2017-11-15	2017-10-18		0	2017-10-18	?	0	0005515640			20171018.ifs	2017-10-18	2017-10-19
2625714	2625714	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2017-07-28	2017-08-01	2017-08-15	2017-07-19		0	2017-07-19	?	0	0005469480			20170719.ifs	2017-07-19	2017-07-20
2544143	2544143	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2017-04-27	2017-05-01	2017-05-15	2017-04-19		0	2017-04-19	?	0	0005422136			20170419.ifs	2017-04-19	2017-04-20
2428430	2428430	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2017-01-30	2017-02-01	2017-02-15	2017-01-19		0	2017-01-19	?	0	0005376235			20170119.ifs	2017-01-19	2017-01-20
2322970	2322970	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2016-10-28	2016-11-01	2016-11-15	2016-10-19		0	2016-10-19	?	0	0005299228			20161019.ifs	2016-10-19	2016-10-20
2254026	2254026	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2016-07-28	2016-08-01	2016-08-15	2016-07-20		0	2016-07-20	?	0	0005252831			20160720.ifs	2016-07-20	2016-07-21
2167637	2167637	DIVIDEND	ADD	860326107		0	0	1	0	.03		00	2016-04-28	2016-05-02	2016-05-16	2016-04-20		0	2016-04-20	?	0	0005206773			20160420.ifs	2016-04-20	2016-04-21
2095464	2095464	DIVIDEND	ADD	860326107		0	0	1	0	.02		00	2016-01-28	2016-02-01	2016-02-16	2016-01-20		0	2016-01-20	?	0	0005161162			20160120.ifs	2016-01-20	2016-01-21
1994081	1994081	DIVIDEND	ADD	860326107		0	0	1	0	.02		00	2015-10-29	2015-11-02	2015-11-16	2015-10-21		0	2015-10-21	?	0	0005081146			20151021.ifs	2015-10-21	2015-10-22
1920783	1920783	DIVIDEND	ADD	860326107		0	0	1	0	.02		00	2015-07-30	2015-08-03	2015-08-17	2015-07-22		0	2015-07-22	?	0	0005034765			20150722.ifs	2015-07-22	2015-07-23
1845212	1845212	DIVIDEND	ADD	860326107		0	0	1	0	.02		00	2015-04-29	2015-05-01	2015-05-15	2015-04-22		0	2015-04-22	?	0	0004988205			20150422.ifs	2015-04-22	2015-04-23
1772334	1772334	DIVIDEND	ADD	860326107		0	0	1	0	.02		00	2015-01-29	2015-02-02	2015-02-16	2015-01-21		0	2015-01-21	?	0	0004942874			20150121.ifs	2015-01-21	2015-01-22
1661118	1661118	DIVIDEND	ADD	860326107		0	0	1	0	.02		00	2014-10-30	2014-11-03	2014-11-17	2014-10-22		0	2014-10-22	?	0	0004861319			20141022.ifs	2014-10-22	2014-10-23
1580884	1580884	DIVIDEND	ADD	860326107		0	0	1	0	.01		00	2014-07-30	2014-08-01	2014-08-15	2014-07-16		0	2014-07-16	?	0	0004815481			20140716.ifs	2014-07-16	2014-07-17
1496804	1496804	DIVIDEND	ADD	860326107		0	0	1	0	.01		00	2014-04-29	2014-05-01	2014-05-15	2014-04-16		0	2014-04-16	?	0	0004768574			20140416.ifs	2014-04-16	2014-04-17
1426313	1426313	DIVIDEND	ADD	860326107		0	0	1	0	.01		00	2014-02-06	2014-02-10	2014-02-19	2014-01-23		0	2014-01-23	?	0	0004725694			20140123.ifs	2014-01-23	2014-01-24
1316943	1316943	DIVIDEND	ADD	860326107		0	0	1	0	.01		00	2013-10-30	2013-11-01	2013-11-15	2013-10-16		0	2013-10-16	?	0	0004645719			20131016.ifs	2013-10-16	2013-10-17
1241777	1241777	DIVIDEND	ADD	860326107		0	0	1	0	.01		00	2013-07-30	2013-08-01	2013-08-15	2013-07-17		0	2013-07-17	?	0	0004602234			20130717.ifs	2013-07-17	2013-07-18
1162313	1162313	DIVIDEND	ADD	860326107		0	0	1	0	.01		00	2013-04-29	2013-05-01	2013-05-15	2013-04-18		0	2013-04-18	?	0	0004558858			20130418.ifs	2013-04-18	2013-04-19
1091186	1091186	DIVIDEND	ADD	860326107		0	0	1	0	.01		00	2013-01-30	2013-02-01	2013-02-15	2013-01-16		0	2013-01-16	?	0	0004515492			20130116.ifs	2013-01-16	2013-01-17
994104	994104	DIVIDEND	DELETE	860326107		0	0	1	0	.02		00	2012-10-30	2012-11-01	2012-11-15	2012-10-17		0	2012-10-17	?	0	0004445951			20121029.ifs	2012-10-29	2012-10-30
994105	994105	DIVIDEND	ADD	860326107		0	0	1	0	.02		00	2012-10-31	2012-11-01	2012-11-15	2012-10-17		1	2012-10-17	2012-10-29	0	0004445951			20121029.ifs	2012-10-29	2012-10-30
987662	987662	DIVIDEND	ADD	860326107		0	0	1	0	.02		00	2012-10-30	2012-11-01	2012-11-15	2012-10-17		0	2012-10-17	?	0	0004445951			20121017.ifs	2012-10-17	2012-10-18
914563	914563	DIVIDEND	ADD	860326107		0	0	1	0	.04		00	2012-07-30	2012-08-01	2012-08-15	2012-07-19		0	2012-07-19	?	0	0004403710			20120719.ifs	2012-07-19	2012-07-20
837336	837336	DIVIDEND	ADD	860326107		0	0	1	0	.04		00	2012-04-27	2012-05-01	2012-05-15	2012-04-18		0	2012-04-18	?	0	0004362295			20120418.ifs	2012-04-18	2012-04-19
721488	721488	DIVIDEND	ADD	860326107		0	0	1	0	.05		00	2012-01-11	2012-01-13	2012-02-01	2011-12-14		0	2011-12-14	?	0	0004287697			20111214.ifs	2011-12-14	2011-12-15
649324	649324	DIVIDEND	ADD	860326107		0	0	1	0	.05		00	2011-10-12	2011-10-14	2011-11-01	2011-09-21		0	2011-09-21	?	0	0004245028			20110921.ifs	2011-09-21	2011-09-22
566984	566984	DIVIDEND	ADD	860326107		0	0	1	0	.05		00	2011-07-13	2011-07-15	2011-08-01	2011-06-22		0	2011-06-22	?	0	0004204369			20110622.ifs	2011-06-22	2011-06-23
379975	379975	DIVIDEND	ADD	860326107		0	0	1	0	.05		00	2011-01-12	2011-01-14	2011-02-01	2010-12-16		0	2010-12-16	?	0	0004106056			20101216.ifs	2010-12-16	2010-12-17
220302	220302	DIVIDEND	ADD	860326107		0	0	1	0	.05		00	2010-07-13	2010-07-15	2010-08-02	2010-06-16		0	2010-06-16	?	0	0004018912			20100616.ifs	2010-06-16	2010-06-17
133890	133890	DIVIDEND	ADD	860326107		0	0	1	0	.09		00	2010-04-13	2010-04-15	2010-05-03	2010-03-17		0	2010-03-17	?	0	0003978550			20100317.ifs	2010-03-17	2010-04-07
51226	51226	DIVIDEND	ADD	860326107		0	0	1	0	.09		35	2010-01-13	2010-01-15	2010-02-01	2009-12-16		0	2009-12-16	?	0	0003927695			20091216.ifs	2009-12-16	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 = 130721
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