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
2323184	2323184	DIVIDEND	DELETE	29364N835		0	0	1	6	0		08	?	?	2016-10-17	2016-09-15		0	2016-09-15	?	0	0005280807			20161019.ifs	2016-10-19	2016-10-20
2323185	2323185	DIVIDEND	ADD	29364N835		0	0	1	0	.316667		00	?	?	2016-10-17	2016-09-15		1	2016-09-15	2016-10-19	0	0005280807			20161019.ifs	2016-10-19	2016-10-20
2321485	2321485	CORPACTION	ADD	29364N835	01	C	2016-10-17			?															20161017.ifs	2016-10-17	2016-10-18
2321486	2321486	EQUITY	CHANGE	29364N835	1ST MTG BD	0	1	2011-04-19	?	0	no	no		no		2011-04-19	?	?							20161017.ifs	2016-10-17	2016-10-18
2321487	2321486	EQUITY	CHANGE	29364N835	1ST MTG BD	C	1	2011-04-19	2016-10-17	0	no	no		no		2011-04-19	2016-10-17	?							20161017.ifs	2016-10-17	2016-10-18
2294996	2294996	DIVIDEND	ADD	29364N835		0	0	C	0	0		12	?	?	2016-10-17	2016-09-15		0	?	2016-09-16	0				20160916.ifs	2016-09-16	2016-09-17
2294695	2294695	DIVIDEND	ADD	29364N835		0	0	1	6	0		08	?	?	2016-10-17	2016-09-15		0	2016-09-15	?	0	0005280807			20160915.ifs	2016-09-15	2016-09-16
2248699	2248699	DIVIDEND	ADD	29364N835		0	0	1	0	.375		00	2016-07-27	2016-07-29	2016-08-01	2016-07-08		0	2016-07-08	?	0	0005250606			20160708.ifs	2016-07-08	2016-07-09
2145363	2145363	DIVIDEND	ADD	29364N835		0	0	1	0	.375		00	2016-04-27	2016-04-29	2016-05-02	2016-03-29		0	2016-03-29	?	0	0005192788			20160329.ifs	2016-03-29	2016-03-30
2012123	2012123	DIVIDEND	ADD	29364N835		0	0	1	0	.375		00	2016-01-27	2016-01-29	2016-02-01	2015-11-18		0	2015-11-19	?	0	0005094672			20151119.ifs	2015-11-19	2015-11-20
1987833	1987833	DIVIDEND	ADD	29364N835		0	0	1	0	.375		00	2015-10-28	2015-10-30	2015-11-02	2015-10-07		0	2015-10-07	?	0	0005078693			20151007.ifs	2015-10-07	2015-10-08
1810890	1810890	DIVIDEND	ADD	29364N835		0	0	1	0	.375		00	2015-04-28	2015-04-30	2015-05-01	2015-03-11		0	2015-03-12	?	0	0004967666			20150312.ifs	2015-03-12	2015-03-13
1766112	1766112	DIVIDEND	ADD	29364N835		0	0	1	0	.375		00	2015-01-28	2015-01-30	2015-02-02	2015-01-07		0	2015-01-07	?	0	0004940759			20150107.ifs	2015-01-07	2015-01-08
1605179	1605179	DIVIDEND	ADD	29364N835		0	0	1	0	.375		00	2014-10-29	2014-10-31	2014-11-01	2014-08-12		0	2014-08-12	?	0	0004828276			20140812.ifs	2014-08-12	2014-08-13
1525345	1525345	DIVIDEND	ADD	29364N835		0	0	1	0	.375		00	2014-07-29	2014-07-31	2014-08-01	2014-05-15		0	2014-05-16	?	0	0004783011			20140516.ifs	2014-05-16	2014-05-17
1465925	1465925	DIVIDEND	ADD	29364N835		0	0	1	0	.375		00	2014-04-28	2014-04-30	2014-05-01	2014-03-13		0	2014-03-13	?	0	0004749999			20140313.ifs	2014-03-13	2014-03-14
1419707	1419707	DIVIDEND	ADD	29364N835		0	0	1	0	.375		00	2014-01-29	2014-01-31	2014-02-03	2014-01-08		0	2014-01-08	?	0	0004722806			20140108.ifs	2014-01-08	2014-01-09
1247936	1247936	DIVIDEND	ADD	29364N835		0	0	1	0	.375		00	2013-10-29	2013-10-31	2013-11-01	2013-07-25		0	2013-07-26	?	0	0004604725			20130726.ifs	2013-07-26	2013-07-27
1219308	1219308	DIVIDEND	ADD	29364N835		0	0	1	0	.375		00	2013-07-29	2013-07-31	2013-08-01	2013-06-25		0	2013-06-26	?	0	0004589462			20130626.ifs	2013-06-26	2013-06-27
1108485	1108485	DIVIDEND	ADD	29364N835		0	0	1	0	.375		00	2013-04-26	2013-04-30	2013-05-01	2013-02-05		0	2013-02-05	?	0	0004526354			20130205.ifs	2013-02-05	2013-02-06
1064951	1064951	DIVIDEND	ADD	29364N835		0	0	1	0	.375		00	2013-01-29	2013-01-31	2013-02-01	2012-12-27		0	2012-12-27	?	0	0004496268			20121227.ifs	2012-12-27	2012-12-28
964519	964519	DIVIDEND	ADD	29364N835		0	0	1	0	.375		00	2012-10-29	2012-10-31	2012-11-01	2012-09-25		0	2012-09-25	?	0	0004433757			20120925.ifs	2012-09-25	2012-09-26
895801	895801	DIVIDEND	ADD	29364N835		0	0	1	0	.375		00	2012-07-27	2012-07-31	2012-08-01	2012-06-27		0	2012-06-27	?	0	0004392320			20120627.ifs	2012-06-27	2012-06-28
809605	809605	DIVIDEND	ADD	29364N835		0	0	1	0	.375		00	2012-04-26	2012-04-30	2012-05-01	2012-03-23		0	2012-03-23	?	0	0004349495			20120323.ifs	2012-03-23	2012-03-24
671515	671515	DIVIDEND	ADD	29364N835		0	0	1	0	.375		00	2011-10-27	2011-10-31	2011-11-01	2011-10-12		0	2011-10-12	?	0	0004257007			20111012.ifs	2011-10-12	2011-10-13
575822	575822	DIVIDEND	ADD	29364N835		0	0	1	4	.44167		00	2011-07-27	2011-07-29	2011-08-01	2011-06-30		0	2011-06-30	?	0	0004210179			20110630.ifs	2011-06-30	2011-07-01
504352	504352	EQUITY	ADD	29364N835	1ST MTG BD	N	1	2011-04-19	?	0	no	no		no		2011-04-19	?	?							20110419.ifs	2011-04-19	2011-04-20
504353	504353	EXCHANGE	ADD	29364N835	01	2011-04-19	2011-04-19	EMZ	0	1	2011-04-19	?													20110419.ifs	2011-04-19	2011-04-20
504567	504567	EQUITY	CHANGE	29364N835	1ST MTG BD	N	1	2011-04-19	?	0	no	no		no		2011-04-19	?	?							20110419.ifs	2011-04-19	2011-04-20
504568	504567	EQUITY	CHANGE	29364N835	1ST MTG BD	0	1	2011-04-19	?	0	no	no		no		2011-04-19	?	?							20110419.ifs	2011-04-19	2011-04-20

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