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
4335858	4335858	DIVIDEND	ADD	863111100		0	0	E	0	0		58	?	?	2020-06-26	2020-05-14		0	2020-05-14	?	0	0006099276			20200514.ifs	2020-05-14	2020-05-15
4335905	4335905	DIVIDEND	ADD	863111100		0	0	E	0	0		58	?	?	2020-06-26	2020-05-14		0	2020-05-14	?	0	0006099276			20200514.ifs	2020-05-14	2020-05-15
4216439	4216439	DIVIDEND	ADD	863111100		0	0	1	0	.14		00	2020-03-12	2020-03-13	2020-03-27	2020-02-25		0	2020-02-26	?	0	0006058532			20200226.ifs	2020-02-26	2020-02-27
4216440	4216440	DIVIDEND	ADD	863111100		0	0	1	0	.14		00	2020-03-12	2020-03-13	2020-03-27	2020-02-25		0	2020-02-26	?	0	0006058532			20200226.ifs	2020-02-26	2020-02-27
3884542	3884542	DIVIDEND	ADD	863111100		0	0	1	0	.14		00	2019-09-12	2019-09-13	2019-09-27	2019-08-21		0	2019-08-21	?	0	0005931751			20190821.ifs	2019-08-21	2019-08-22
3884551	3884551	DIVIDEND	ADD	863111100		0	0	1	0	.14		00	2019-09-12	2019-09-13	2019-09-27	2019-08-21		0	2019-08-21	?	0	0005931751			20190821.ifs	2019-08-21	2019-08-22
3728770	3728770	DIVIDEND	ADD	863111100		0	0	1	0	.14		00	2019-06-13	2019-06-14	2019-06-28	2019-05-14		0	2019-05-15	?	0	0005884478			20190515.ifs	2019-05-15	2019-05-16
3728783	3728783	DIVIDEND	ADD	863111100		0	0	1	0	.14		00	2019-06-13	2019-06-14	2019-06-28	2019-05-14		0	2019-05-15	?	0	0005884478			20190515.ifs	2019-05-15	2019-05-16
3594099	3594099	DIVIDEND	ADD	863111100		0	0	1	0	.14		00	2019-03-14	2019-03-15	2019-03-29	2019-02-26		0	2019-02-26	?	0	0005841723			20190226.ifs	2019-02-26	2019-02-27
3594105	3594105	DIVIDEND	ADD	863111100		0	0	1	0	.14		00	2019-03-14	2019-03-15	2019-03-29	2019-02-26		0	2019-02-26	?	0	0005841723			20190226.ifs	2019-02-26	2019-02-27
3405046	3405046	DIVIDEND	ADD	863111100		0	0	1	0	.14		00	2018-12-17	2018-12-18	2018-12-28	2018-12-05		0	2018-12-05	?	0	0005766449			20181206.ifs	2018-12-06	2018-12-07
3405050	3405050	DIVIDEND	ADD	863111100		0	0	1	0	.14		00	2018-12-17	2018-12-18	2018-12-28	2018-12-05		0	2018-12-05	?	0	0005766449			20181206.ifs	2018-12-06	2018-12-07
3090707	3090707	DIVIDEND	ADD	863111100		0	0	1	0	.14		00	2018-06-14	2018-06-15	2018-06-29	2018-05-15		0	2018-05-15	?	0	0005661642			20180515.ifs	2018-05-15	2018-05-16
3090708	3090708	DIVIDEND	ADD	863111100		0	0	1	0	.14		00	2018-06-14	2018-06-15	2018-06-29	2018-05-15		0	2018-05-15	?	0	0005661642			20180515.ifs	2018-05-15	2018-05-16
2958043	2958043	DIVIDEND	ADD	863111100		0	0	1	0	.14		00	2018-03-15	2018-03-16	2018-03-30	2018-02-20		0	2018-02-20	?	0	0005616512			20180220.ifs	2018-02-20	2018-02-21
2958060	2958060	DIVIDEND	ADD	863111100		0	0	1	0	.14		00	2018-03-15	2018-03-16	2018-03-30	2018-02-20		0	2018-02-20	?	0	0005616512			20180220.ifs	2018-02-20	2018-02-21
2719973	2719973	DIVIDEND	ADD	863111100		0	0	1	0	.14		00	2017-12-14	2017-12-15	2017-12-29	2017-10-10		0	2017-10-10	?	0	0005513959			20171010.ifs	2017-10-10	2017-10-11
2653288	2653288	DIVIDEND	ADD	863111100		0	0	1	0	.14		00	2017-09-14	2017-09-15	2017-09-29	2017-08-23		0	2017-08-23	?	0	0005484925			20170823.ifs	2017-08-23	2017-08-24
2568158	2568158	DIVIDEND	ADD	863111100		0	0	1	0	.14		00	2017-06-14	2017-06-16	2017-06-30	2017-05-16		0	2017-05-16	?	0	0005435652			20170516.ifs	2017-05-16	2017-05-17
2489951	2489951	DIVIDEND	ADD	863111100		0	0	1	0	.14		00	2017-03-15	2017-03-17	2017-03-31	2017-02-14		0	2017-02-14	?	0	0005388233			20170214.ifs	2017-02-14	2017-02-15
2445686	2445686	EQUITY	CHANGE	863111100	COM	0	0	1995-02-28	?	9	yes	no		yes		1996-12-18	?	?							20170123.ifs	2017-01-23	2017-01-24
2445687	2445686	EQUITY	CHANGE	863111100	COM	0	0	1995-02-28	?	4	yes	no		yes		1996-12-18	?	?							20170123.ifs	2017-01-23	2017-01-24
2319611	2319611	DIVIDEND	ADD	863111100		0	0	1	0	.14		00	2016-12-14	2016-12-16	2016-12-30	2016-10-11		0	2016-10-11	?	0	0005297574			20161011.ifs	2016-10-11	2016-10-12
2276593	2276593	DIVIDEND	ADD	863111100		0	0	1	0	.14		00	2016-09-14	2016-09-16	2016-09-30	2016-08-24		0	2016-08-25	?	0	0005269325			20160825.ifs	2016-08-25	2016-08-26
2197971	2197971	DIVIDEND	ADD	863111100		0	0	1	0	.13		00	2016-06-08	2016-06-10	2016-06-24	2016-05-17		0	2016-05-17	?	0	0005219724			20160517.ifs	2016-05-17	2016-05-18
2115685	2115685	DIVIDEND	ADD	863111100		0	0	1	0	.13		00	2016-03-09	2016-03-11	2016-03-25	2016-02-19		0	2016-02-19	?	0	0005174156			20160219.ifs	2016-02-19	2016-02-20
1987061	1987061	DIVIDEND	ADD	863111100		0	0	1	0	.13		00	2015-12-07	2015-12-09	2015-12-23	2015-10-06		0	2015-10-06	?	0	0005078497			20151006.ifs	2015-10-06	2015-10-07
1944972	1944972	DIVIDEND	ADD	863111100		0	0	1	0	.13		00	2015-09-09	2015-09-11	2015-09-25	2015-08-21		0	2015-08-21	?	0	0005049144			20150821.ifs	2015-08-21	2015-08-22
1866979	1866979	DIVIDEND	ADD	863111100		0	0	1	0	.12		00	2015-06-10	2015-06-12	2015-06-26	2015-05-19		0	2015-05-20	?	0	0005001668			20150520.ifs	2015-05-20	2015-05-21
1794908	1794908	DIVIDEND	ADD	863111100		0	0	1	0	.12		00	2015-03-11	2015-03-13	2015-03-27	2015-02-25		0	2015-02-25	?	0	0004957489			20150225.ifs	2015-02-25	2015-02-26
1654077	1654077	DIVIDEND	ADD	863111100		0	0	1	0	.12		00	2014-12-10	2014-12-12	2014-12-26	2014-10-07		0	2014-10-07	?	0	0004858744			20141007.ifs	2014-10-07	2014-10-08
1610664	1610664	DIVIDEND	ADD	863111100		0	0	1	0	.12		00	2014-09-10	2014-09-12	2014-09-26	2014-08-21		0	2014-08-21	?	0	0004830697			20140821.ifs	2014-08-21	2014-08-22
1527523	1527523	DIVIDEND	ADD	863111100		0	0	1	0	.11		00	2014-06-11	2014-06-13	2014-06-27	2014-05-20		0	2014-05-21	?	0	0004783895			20140521.ifs	2014-05-21	2014-05-22
1446057	1446057	DIVIDEND	ADD	863111100		0	0	1	0	.11		00	2014-03-12	2014-03-14	2014-03-28	2014-02-17		0	2014-02-19	?	0	0004737806			20140219.ifs	2014-02-19	2014-02-20
1313755	1313755	DIVIDEND	ADD	863111100		0	0	1	0	.11		00	2013-12-11	2013-12-13	2013-12-27	2013-10-09		0	2013-10-09	?	0	0004644871			20131009.ifs	2013-10-09	2013-10-10
1270245	1270245	DIVIDEND	ADD	863111100		0	0	1	0	.11		00	2013-09-11	2013-09-13	2013-09-27	2013-08-22		0	2013-08-23	?	0	0004617629			20130823.ifs	2013-08-23	2013-08-24
1038000	1038000	DIVIDEND	ADD	863111100		0	0	1	0	.2		00	2012-12-19	2012-12-21	2012-12-31	2012-12-13		0	2012-12-13	?	0	0004477943			20121213.ifs	2012-12-13	2012-12-14
982882	982882	DIVIDEND	ADD	863111100		0	0	1	0	.1		00	2012-12-12	2012-12-14	2012-12-28	2012-10-09		0	2012-10-09	?	0	0004444786			20121009.ifs	2012-10-09	2012-10-10
936423	936423	DIVIDEND	ADD	863111100		0	0	1	0	.1		00	2012-09-12	2012-09-14	2012-09-28	2012-08-21		0	2012-08-21	?	0	0004417512			20120821.ifs	2012-08-21	2012-08-22
865659	865659	DIVIDEND	ADD	863111100		0	0	1	0	.1		00	2012-06-13	2012-06-15	2012-06-29	2012-05-22		0	2012-05-22	?	0	0004375867			20120522.ifs	2012-05-22	2012-05-23
783077	783077	DIVIDEND	ADD	863111100		0	0	1	0	.1		00	2012-03-14	2012-03-16	2012-03-30	2012-02-22		0	2012-02-22	?	0	0004334708			20120222.ifs	2012-02-22	2012-02-23
720332	720332	DIVIDEND	ADD	863111100		0	0	1	0	.1		00	2011-12-14	2011-12-16	2011-12-30	2011-12-13		0	2011-12-13	?	0	0004286994			20111213.ifs	2011-12-13	2011-12-14
624346	624346	DIVIDEND	ADD	863111100		0	0	1	0	.1		00	2011-09-13	2011-09-15	2011-09-30	2011-08-23		0	2011-08-23	?	0	0004231471			20110823.ifs	2011-08-23	2011-08-24
283244	283244	DIVIDEND	ADD	863111100		0	0	1	9	1.2		03	2010-10-06	2010-10-08	2010-10-29	2010-08-04		0	2010-08-23	?	0	0004048888			20100823.ifs	2010-08-23	2010-08-24

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