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
1984654	1984654	CORPACTION	ADD	293649307	66	C	2015-10-02			?															20151002.ifs	2015-10-02	2015-10-03
1984655	1984655	EQUITY	CHANGE	293649307	CUM PFD MEMBERSHIP INT SER A	0	1	2010-01-21	?	0	no	no		no		2010-01-21	?	?							20151002.ifs	2015-10-02	2015-10-03
1984656	1984655	EQUITY	CHANGE	293649307	CUM PFD MEMBERSHIP INT SER A	C	1	2010-01-21	2015-10-02	0	no	no		no		2010-01-21	2015-10-02	?							20151002.ifs	2015-10-02	2015-10-03
1984754	1984754	EXCHANGE	CHANGE	293649307	66	2010-01-21	2015-09-23	ELUOP	0	1	2010-01-21	2010-03-19													20151002.ifs	2015-10-02	2015-10-03
1984755	1984754	EXCHANGE	CHANGE	293649307	66	2010-01-21	2015-10-01	ELUOP	0	1	2010-01-21	2015-10-02													20151002.ifs	2015-10-02	2015-10-03
1945241	1945241	DIVIDEND	DELETE	293649307		0	0	1	0	1.7375		00	2015-08-26	2015-08-28	2015-09-15	2015-08-18		0	2015-08-18	?	0	0005048002			20150821.ifs	2015-08-21	2015-08-22
1945242	1945242	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2015-08-26	2015-08-28	2015-09-15	2015-08-18		1	2015-08-18	2015-08-21	0	0005048002			20150821.ifs	2015-08-21	2015-08-22
1942795	1942795	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2015-08-26	2015-08-28	2015-09-15	2015-08-18		0	2015-08-18	?	0	0005048002			20150818.ifs	2015-08-18	2015-08-19
1869249	1869249	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2015-06-02	2015-06-04	2015-06-15	2015-05-22		0	2015-05-22	?	0	0005002722			20150522.ifs	2015-05-22	2015-05-23
1789628	1789628	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2015-02-26	2015-03-02	2015-03-15	2015-02-11		0	2015-02-11	?	0	0004954131			20150211.ifs	2015-02-11	2015-02-12
1686016	1686016	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2014-12-03	2014-12-05	2014-12-15	2014-11-17		0	2014-11-21	?	0	0004875039			20141121.ifs	2014-11-21	2014-11-22
1609299	1609299	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2014-08-27	2014-08-29	2014-09-15	2014-08-18		0	2014-08-19	?	0	0004830102			20140819.ifs	2014-08-19	2014-08-20
1526954	1526954	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2014-05-28	2014-05-30	2014-06-15	2014-05-13		0	2014-05-20	?	0	0004783513			20140520.ifs	2014-05-20	2014-05-21
1444293	1444293	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2014-02-25	2014-02-27	2014-03-15	2014-02-12		0	2014-02-14	?	0	0004736654			20140214.ifs	2014-02-14	2014-02-15
1343666	1343666	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2013-11-27	2013-12-02	2013-12-16	2013-11-19		0	2013-11-21	?	0	0004660276			20131121.ifs	2013-11-21	2013-11-22
1267042	1267042	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2013-08-28	2013-08-30	2013-09-15	2013-08-14		0	2013-08-19	?	0	0004616300			20130819.ifs	2013-08-19	2013-08-20
1188039	1188039	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2013-05-29	2013-05-31	2013-06-15	2013-05-16		0	2013-05-17	?	0	0004571980			20130517.ifs	2013-05-17	2013-05-18
1117140	1117140	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2013-03-05	2013-03-07	2013-03-15	2013-02-22		0	2013-02-25	?	0	0004530260			20130225.ifs	2013-02-25	2013-02-26
1014142	1014142	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2012-11-28	2012-11-30	2012-12-17	2012-11-19		0	2012-11-21	?	0	0004460207			20121121.ifs	2012-11-21	2012-11-22
865152	865152	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2012-05-29	2012-05-31	2012-06-15	2012-05-14		0	2012-05-21	?	0	0004375670			20120521.ifs	2012-05-21	2012-05-22
784101	784101	DIVIDEND	DELETE	293649307		0	0	1	0	1.7375		00	2012-02-27	2012-02-29	2012-03-15	2012-02-22		0	2012-02-22	?	0	0004334565			20120223.ifs	2012-02-23	2012-02-24
784102	784102	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2012-02-27	2012-02-29	2012-03-15	2012-02-13		1	2012-02-22	2012-02-23	0	0004334565			20120223.ifs	2012-02-23	2012-02-24
783253	783253	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2012-02-27	2012-02-29	2012-03-15	2012-02-22		0	2012-02-22	?	0	0004334565			20120222.ifs	2012-02-22	2012-02-23
698300	698300	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2011-11-28	2011-11-30	2011-12-15	2011-11-09		0	2011-11-21	?	0	0004271476			20111121.ifs	2011-11-21	2011-11-22
623092	623092	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2011-08-29	2011-08-31	2011-09-15	2011-08-11		0	2011-08-19	?	0	0004230501			20110819.ifs	2011-08-19	2011-08-20
536725	536725	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2011-06-03	2011-06-07	2011-06-15	2011-05-17		0	2011-05-26	?	0	0004191374			20110526.ifs	2011-05-26	2011-05-27
434481	434481	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2011-02-24	2011-02-28	2011-03-15	2011-01-27		0	2011-02-01	?	0	0004142249			20110201.ifs	2011-02-01	2011-02-02
346455	346455	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2010-11-26	2010-11-30	2010-12-15	2010-10-19		0	2010-10-29	?	0	0004078714			20101029.ifs	2010-10-29	2010-10-30
265578	265578	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2010-08-27	2010-08-31	2010-09-15	2010-07-26		0	2010-07-30	?	0	0004038520			20100730.ifs	2010-07-30	2010-07-31
192850	192850	CORPACTION	DELETE	293649307	66	X	2010-03-19	293649307	01	?															20100517.ifs	2010-05-17	2010-05-18
192859	192859	EXCHANGE	DELETE	293649307	01	2010-03-19	2010-05-14	ELB	0	1	2010-03-19	?													20100517.ifs	2010-05-17	2010-05-18
192538	192538	DIVIDEND	ADD	293649307		0	0	1	0	1.7375		00	2010-05-26	2010-05-31	2010-06-15	2010-05-10		0	2010-05-14	?	1	0004006007			20100514.ifs	2010-05-14	2010-05-15
135468	135468	CORPACTION	ADD	293649307	66	X	2010-03-19	293649307	01	?															20100319.ifs	2010-03-19	2010-04-07
135469	135469	EXCHANGE	ADD	293649307	01	2010-03-19	2010-03-19	ELB	0	1	2010-03-19	?													20100319.ifs	2010-03-19	2010-04-07
135470	135470	EXCHANGE	CHANGE	293649307	66	2010-01-21	?	ELUOP	0	1	2010-01-21	?													20100319.ifs	2010-03-19	2010-04-07
135471	135470	EXCHANGE	CHANGE	293649307	66	2010-01-21	2010-03-18	ELUOP	0	1	2010-01-21	2010-03-19													20100319.ifs	2010-03-19	2010-04-07
136162	136162	EQUITY	CHANGE	293649307	CUM PFD MEMBERSHIP INT SER A	N	1	2010-01-21	?	0	no	no		no		2010-01-21	?	?							20100319.ifs	2010-03-19	2010-04-07
136163	136162	EQUITY	CHANGE	293649307	CUM PFD MEMBERSHIP INT SER A	0	1	2010-01-21	?	0	no	no		no		2010-01-21	?	?							20100319.ifs	2010-03-19	2010-04-07
111045	111045	DIVIDEND	ADD	293649307		0	0	1	4	1.7375		00	2010-02-24	2010-02-28	2010-03-15	2010-02-16		0	2010-02-16	?	0	0003965504			20100216.ifs	2010-02-16	2010-04-07
91370	91370	EQUITY	ADD	293649307	CUM PFD MEMBERSHIP INT SER A	N	1	2010-01-21	?	0	no	no		no		2010-01-21	?	?							20100121.ifs	2010-01-21	2010-04-07
91371	91371	EXCHANGE	ADD	293649307	66	2010-01-21	?	ELUOP	0	1	2010-01-21	?													20100121.ifs	2010-01-21	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 = 159700
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