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
2389817	2389817	CORPACTION	DELETE	478366107	01	M	2016-09-02	G91442106	01	?															20161221.ifs	2016-12-21	2016-12-22
2289829	2289829	CORPACTION	ADD	478366107	01	M	2016-09-02	G91442106	01	?															20160908.ifs	2016-09-08	2016-09-09
2289830	2289830	EQUITY	CHANGE	478366107	COM	A	0	1974-12-02	2016-09-06	4	yes	no	G91442106	no		1999-06-22	2016-09-06	?							20160908.ifs	2016-09-08	2016-09-09
2289831	2289830	EQUITY	CHANGE	478366107	COM	M	0	1974-12-02	2016-09-02	4	yes	no	G91442106	no		1999-06-22	2016-09-08	?							20160908.ifs	2016-09-08	2016-09-09
2288690	2288690	CORPACTION	ADD	478366107	01	A	2016-09-06	G91442106	01	2016-09-06															20160906.ifs	2016-09-06	2016-09-07
2288691	2288691	EQUITY	CHANGE	478366107	COM	0	0	1974-12-02	?	4	yes	no		no		1999-06-22	2016-09-02	?							20160906.ifs	2016-09-06	2016-09-07
2288692	2288691	EQUITY	CHANGE	478366107	COM	A	0	1974-12-02	2016-09-06	4	yes	no	G91442106	no		1999-06-22	2016-09-06	?							20160906.ifs	2016-09-06	2016-09-07
2287483	2287483	CORPACTION	ADD	478366107	01	M	2016-09-02	G91442106	01	?															20160902.ifs	2016-09-02	2016-09-03
2287484	2287484	EQUITY	CHANGE	478366107	COM	0	0	1974-12-02	?	4	yes	no		no		1999-06-22	2007-07-30	?							20160902.ifs	2016-09-02	2016-09-03
2287485	2287484	EQUITY	CHANGE	478366107	COM	M	0	1974-12-02	2016-09-02	4	yes	no	G91442106	no		1999-06-22	2016-09-02	?							20160902.ifs	2016-09-02	2016-09-03
2287568	2287568	CORPACTION	DELETE	478366107	01	M	2016-09-02	G91442106	01	?															20160902.ifs	2016-09-02	2016-09-03
2287569	2287569	EQUITY	CHANGE	478366107	COM	M	0	1974-12-02	2016-09-02	4	yes	no	G91442106	no		1999-06-22	2016-09-02	?							20160902.ifs	2016-09-02	2016-09-03
2287570	2287569	EQUITY	CHANGE	478366107	COM	0	0	1974-12-02	?	4	yes	no		no		1999-06-22	2016-09-02	?							20160902.ifs	2016-09-02	2016-09-03
2287962	2287962	DIVIDEND	CHANGE	478366107		0	0	1	0	.29		00	2016-08-03	2016-08-05	2016-08-19	2016-07-20		1	2016-07-20	2016-08-18	0	0005252720			20160902.ifs	2016-09-02	2016-09-03
2287963	2287962	DIVIDEND	CHANGE	478366107		0	0	1	0	.29		00	2016-08-03	2016-08-05	2016-08-19	2016-07-20		2	2016-07-20	2016-09-02	0	0005252720			20160902.ifs	2016-09-02	2016-09-03
2272541	2272541	DIVIDEND	CHANGE	478366107		0	0	1	0	.29		00	2016-08-03	2016-08-05	2016-08-19	2016-07-20		0	2016-07-20	?	0	0005252720			20160818.ifs	2016-08-18	2016-08-19
2272542	2272541	DIVIDEND	CHANGE	478366107		0	0	1	0	.29		00	2016-08-03	2016-08-05	2016-08-19	2016-07-20		1	2016-07-20	2016-08-18	0	0005252720			20160818.ifs	2016-08-18	2016-08-19
2254126	2254126	DIVIDEND	ADD	478366107		0	0	1	0	.29		00	2016-08-03	2016-08-05	2016-08-19	2016-07-20		0	2016-07-20	?	0	0005252720			20160720.ifs	2016-07-20	2016-07-21
2198069	2198069	DIVIDEND	ADD	478366107		0	0	1	0	.29		00	2016-06-08	2016-06-10	2016-07-05	2016-05-17		0	2016-05-17	?	0	0005219613			20160517.ifs	2016-05-17	2016-05-18
2099141	2099141	DIVIDEND	CHANGE	478366107		0	0	1	0	.29		00	2016-03-09	2016-03-11	2016-04-04	2016-01-23		0	2016-01-25	?	0	0005161814			20160127.ifs	2016-01-27	2016-01-28
2099142	2099141	DIVIDEND	CHANGE	478366107		0	0	1	0	.29		00	2016-03-09	2016-03-11	2016-04-04	2016-01-23		1	2016-01-25	2016-01-27	0	0005161814			20160127.ifs	2016-01-27	2016-01-28
2097655	2097655	DIVIDEND	ADD	478366107		0	0	1	0	.29		00	2016-03-09	2016-03-11	2016-04-04	2016-01-23		0	2016-01-25	?	0	0005161814			20160125.ifs	2016-01-25	2016-01-26
2011178	2011178	DIVIDEND	ADD	478366107		0	0	1	0	.29		00	2015-12-09	2015-12-11	2016-01-05	2015-11-18		0	2015-11-18	?	0	0005094211			20151118.ifs	2015-11-18	2015-11-19
1920898	1920898	DIVIDEND	ADD	478366107		0	0	1	0	.26		00	2015-09-02	2015-09-04	2015-10-02	2015-07-22		0	2015-07-22	?	0	0005034660			20150722.ifs	2015-07-22	2015-07-23
1867122	1867122	DIVIDEND	ADD	478366107		0	0	1	0	.26		00	2015-06-03	2015-06-05	2015-07-02	2015-05-20		0	2015-05-20	?	0	0005001541			20150520.ifs	2015-05-20	2015-05-21
1776163	1776163	DIVIDEND	ADD	478366107		0	0	1	0	.26		00	2015-03-04	2015-03-06	2015-04-02	2015-01-28		0	2015-01-28	?	0	0004944416			20150128.ifs	2015-01-28	2015-01-29
1683887	1683887	DIVIDEND	ADD	478366107		0	0	1	0	.26		00	2014-12-10	2014-12-12	2015-01-05	2014-11-19		0	2014-11-19	?	0	0004873996			20141119.ifs	2014-11-19	2014-11-20
1585393	1585393	DIVIDEND	ADD	478366107		0	0	1	0	.22		00	2014-09-03	2014-09-05	2014-10-02	2014-07-23		0	2014-07-23	?	0	0004817012			20140723.ifs	2014-07-23	2014-07-24
1527694	1527694	DIVIDEND	ADD	478366107		0	0	1	0	.22		00	2014-06-04	2014-06-06	2014-07-02	2014-05-21		0	2014-05-21	?	0	0004783867			20140521.ifs	2014-05-21	2014-05-22
1429493	1429493	DIVIDEND	ADD	478366107		0	0	1	0	.22		00	2014-03-05	2014-03-07	2014-04-02	2014-01-29		0	2014-01-29	?	0	0004726729			20140129.ifs	2014-01-29	2014-01-30
1342845	1342845	DIVIDEND	ADD	478366107		0	0	1	0	.22		00	2013-12-12	2013-12-16	2014-01-06	2013-11-20		0	2013-11-20	?	0	0004659921			20131120.ifs	2013-11-20	2013-11-21
1245878	1245878	DIVIDEND	ADD	478366107		0	0	1	0	.19		00	2013-09-04	2013-09-06	2013-10-02	2013-07-24		0	2013-07-24	?	0	0004603740			20130724.ifs	2013-07-24	2013-07-25
1190863	1190863	DIVIDEND	ADD	478366107		0	0	1	0	.19		00	2013-06-05	2013-06-07	2013-07-02	2013-05-22		0	2013-05-22	?	0	0004572759			20130522.ifs	2013-05-22	2013-05-23
1094556	1094556	DIVIDEND	ADD	478366107		0	0	1	0	.19		00	2013-03-06	2013-03-08	2013-04-02	2013-01-23		0	2013-01-23	?	0	0004516726			20130123.ifs	2013-01-23	2013-01-24
1009806	1009806	DIVIDEND	ADD	478366107		0	0	1	0	.19		00	2012-12-05	2012-12-07	2012-12-28	2012-11-14		0	2012-11-14	?	0	0004457827			20121114.ifs	2012-11-14	2012-11-15
921250	921250	DIVIDEND	ADD	478366107		0	0	1	0	.18		00	2012-09-05	2012-09-07	2012-10-02	2012-07-25		0	2012-07-25	?	0	0004405059			20120725.ifs	2012-07-25	2012-07-26
866517	866517	DIVIDEND	ADD	478366107		0	0	1	0	.18		00	2012-06-06	2012-06-08	2012-07-03	2012-05-23		0	2012-05-23	?	0	0004376172			20120523.ifs	2012-05-23	2012-05-24
762429	762429	DIVIDEND	ADD	478366107		0	0	1	0	.18		00	2012-03-07	2012-03-09	2012-04-03	2012-01-25		0	2012-01-25	?	0	0004322825			20120125.ifs	2012-01-25	2012-01-26
695835	695835	DIVIDEND	ADD	478366107		0	0	1	0	.18		00	2011-12-07	2011-12-09	2012-01-03	2011-11-16		0	2011-11-16	?	0	0004270144			20111116.ifs	2011-11-16	2011-11-17
594130	594130	DIVIDEND	ADD	478366107		0	0	1	0	.16		00	2011-09-07	2011-09-09	2011-10-04	2011-07-27		0	2011-07-27	?	0	0004219699			20110727.ifs	2011-07-27	2011-07-28
535021	535021	DIVIDEND	ADD	478366107		0	0	1	0	.16		00	2011-06-08	2011-06-10	2011-07-05	2011-05-25		0	2011-05-25	?	0	0004190779			20110525.ifs	2011-05-25	2011-05-26
425998	425998	DIVIDEND	ADD	478366107		0	0	1	0	.16		00	2011-03-09	2011-03-11	2011-04-04	2011-01-26		0	2011-01-26	?	0	0004137317			20110126.ifs	2011-01-26	2011-01-27
356909	356909	DIVIDEND	ADD	478366107		0	0	1	0	.16		00	2010-12-08	2010-12-10	2011-01-04	2010-11-17		0	2010-11-17	?	0	0004088125			20101117.ifs	2010-11-17	2010-11-18
261201	261201	DIVIDEND	ADD	478366107		0	0	1	0	.13		00	2010-09-08	2010-09-10	2010-10-04	2010-07-28		0	2010-07-28	?	0	0004037135			20100728.ifs	2010-07-28	2010-07-29
194159	194159	DIVIDEND	ADD	478366107		0	0	1	0	.13		00	2010-06-09	2010-06-11	2010-07-02	2010-05-18		0	2010-05-18	?	0	0004006720			20100518.ifs	2010-05-18	2010-05-19
95303	95303	DIVIDEND	ADD	478366107		0	0	1	0	.13		00	2010-03-10	2010-03-12	2010-04-02	2010-01-27		0	2010-01-27	?	0	0003956242			20100127.ifs	2010-01-27	2010-04-07
25716	25716	DIVIDEND	ADD	478366107		0	0	1	0	.13		00	2009-12-09	2009-12-11	2010-01-04	2009-11-18		0	2009-11-18	?	0	0003908927			20091118.ifs	2009-11-18	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 = 130894
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