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
1594553	1594553	CORPACTION	ADD	203233507	01	Q	2014-08-01	294628300	01	?															20140801.ifs	2014-08-01	2014-08-02
1594555	1594555	EQUITY	CHANGE	203233507	SR NT	0	1	2010-06-30	?	0	no	no		no		2010-07-01	?	?							20140801.ifs	2014-08-01	2014-08-02
1594556	1594555	EQUITY	CHANGE	203233507	SR NT	Q	1	2010-06-30	2014-08-01	0	no	no	294628300	no		2010-07-01	2014-08-01	?							20140801.ifs	2014-08-01	2014-08-02
1525356	1525356	DIVIDEND	ADD	203233507		0	0	1	0	.375		00	2014-07-30	2014-08-01	2014-08-15	2014-05-15		0	2014-05-16	?	0	0004783008			20140516.ifs	2014-05-16	2014-05-17
1465946	1465946	DIVIDEND	ADD	203233507		0	0	1	0	.375		00	2014-04-29	2014-05-01	2014-05-15	2014-03-13		0	2014-03-13	?	0	0004749996			20140313.ifs	2014-03-13	2014-03-14
1419755	1419755	DIVIDEND	ADD	203233507		0	0	1	0	.375		00	2014-01-29	2014-02-01	2014-02-15	2014-01-08		0	2014-01-08	?	0	0004722802			20140108.ifs	2014-01-08	2014-01-09
1247968	1247968	DIVIDEND	ADD	203233507		0	0	1	0	.375		00	2013-10-30	2013-11-01	2013-11-15	2013-07-25		0	2013-07-26	?	0	0004604722			20130726.ifs	2013-07-26	2013-07-27
1219347	1219347	DIVIDEND	ADD	203233507		0	0	1	0	.375		00	2013-07-30	2013-08-01	2013-08-15	2013-06-25		0	2013-06-26	?	0	0004589444			20130626.ifs	2013-06-26	2013-06-27
1108526	1108526	DIVIDEND	ADD	203233507		0	0	1	0	.375		00	2013-04-29	2013-05-01	2013-05-15	2013-02-05		0	2013-02-05	?	0	0004526332			20130205.ifs	2013-02-05	2013-02-06
1065172	1065172	DIVIDEND	ADD	203233507		0	0	1	0	.375		00	2013-01-30	2013-02-01	2013-02-15	2012-12-27		0	2012-12-27	?	0	0004496265			20121227.ifs	2012-12-27	2012-12-28
994315	994315	DIVIDEND	DELETE	203233507		0	0	1	0	.375		00	2012-10-30	2012-11-01	2012-11-15	2012-09-25		0	2012-09-25	?	0	0004433747			20121029.ifs	2012-10-29	2012-10-30
994316	994316	DIVIDEND	ADD	203233507		0	0	1	0	.375		00	2012-10-31	2012-11-01	2012-11-15	2012-09-25		1	2012-09-25	2012-10-29	0	0004433747			20121029.ifs	2012-10-29	2012-10-30
964534	964534	DIVIDEND	ADD	203233507		0	0	1	0	.375		00	2012-10-30	2012-11-01	2012-11-15	2012-09-25		0	2012-09-25	?	0	0004433747			20120925.ifs	2012-09-25	2012-09-26
895842	895842	DIVIDEND	ADD	203233507		0	0	1	0	.375		00	2012-07-30	2012-08-01	2012-08-15	2012-06-27		0	2012-06-27	?	0	0004392312			20120627.ifs	2012-06-27	2012-06-28
809779	809779	DIVIDEND	ADD	203233507		0	0	1	0	.375		00	2012-04-27	2012-05-01	2012-05-15	2012-03-23		0	2012-03-23	?	0	0004349493			20120323.ifs	2012-03-23	2012-03-24
671537	671537	DIVIDEND	ADD	203233507		0	0	1	0	.375		00	2011-10-28	2011-11-01	2011-11-15	2011-10-12		0	2011-10-12	?	0	0004257001			20111012.ifs	2011-10-12	2011-10-13
576302	576302	DIVIDEND	ADD	203233507		0	0	1	0	.375		00	2011-07-28	2011-08-01	2011-08-15	2011-06-30		0	2011-06-30	?	0	0004210075			20110630.ifs	2011-06-30	2011-07-01
503235	503235	DIVIDEND	ADD	203233507		0	0	1	0	.375		00	2011-04-28	2011-05-02	2011-05-16	2011-04-15		0	2011-04-15	?	0	0004175788			20110415.ifs	2011-04-15	2011-04-16
417238	417238	DIVIDEND	ADD	203233507		0	0	1	0	.375		00	2011-01-28	2011-02-01	2011-02-15	2011-01-11		0	2011-01-11	?	0	0004134330			20110111.ifs	2011-01-11	2011-01-12
335960	335960	DIVIDEND	ADD	203233507		0	0	1	0	.375		00	2010-10-28	2010-11-01	2010-11-15	2010-10-15		0	2010-10-15	?	0	0004075068			20101015.ifs	2010-10-15	2010-10-16
250427	250427	DIVIDEND	ADD	203233507		0	0	1	0	.375		00	2010-07-29	2010-08-02	2010-08-16	2010-07-14		0	2010-07-14	?	0	0004033754			20100714.ifs	2010-07-14	2010-07-15
236609	236609	EQUITY	ADD	203233507	SR NT	0	1	2010-06-30	?	0	no	no		no		2010-07-01	?	?							20100701.ifs	2010-07-01	2010-07-02
236744	236744	EXCHANGE	ADD	203233507	01	2010-07-01	?	CWHN	0	1	2010-07-01	?													20100701.ifs	2010-07-01	2010-07-02

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