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
2724804	2724804	CORPACTION	ADD	456837400	01	C	2017-10-16			2017-10-16															20171016.ifs	2017-10-16	2017-10-17
2724806	2724806	EQUITY	CHANGE	456837400	PERPTL DBT 6.2%	0	1	2003-10-17	?	4	no	no		no		2003-10-27	2003-11-19	?							20171016.ifs	2017-10-16	2017-10-17
2724808	2724807	EQUITY	CHANGE	456837400	PERPTL DBT 6.2%	C	1	2003-10-17	2017-10-16	4	no	no		no		2003-10-27	2017-10-16	?							20171016.ifs	2017-10-16	2017-10-17
2724830	2724830	CORPACTION	ADD	456837400	01	C	2017-10-16			2017-10-16															20171016.ifs	2017-10-16	2017-10-17
2724832	2724832	EQUITY	CHANGE	456837400	PERPTL DBT 6.2%	0	1	2003-10-17	?	4	no	no		no		2003-10-27	2003-11-19	?							20171016.ifs	2017-10-16	2017-10-17
2724834	2724833	EQUITY	CHANGE	456837400	PERPTL DBT 6.2%	C	1	2003-10-17	2017-10-16	4	no	no		no		2003-10-27	2017-10-16	?							20171016.ifs	2017-10-16	2017-10-17
2669496	2669496	DIVIDEND	ADD	456837400		0	0	C	0	25		12	?	?	2017-10-16	2017-09-13		0	?	2017-09-14	0				20170914.ifs	2017-09-14	2017-09-15
2669730	2669730	DIVIDEND	ADD	456837400		0	0	C	0	25		12	?	?	2017-10-16	2017-09-13		0	?	2017-09-14	0				20170914.ifs	2017-09-14	2017-09-15
2582491	2582491	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2017-12-28	2017-12-29	2018-01-16	2017-05-31		0	2017-06-01	?	2	0005443454			20170601.ifs	2017-06-01	2017-06-02
2582492	2582492	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2017-09-28	2017-09-29	2017-10-16	2017-05-31		0	2017-06-01	?	1	0005443453			20170601.ifs	2017-06-01	2017-06-02
2582493	2582493	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2017-06-28	2017-06-30	2017-07-17	2017-05-31		0	2017-06-01	?	0	0005443452			20170601.ifs	2017-06-01	2017-06-02
2439642	2439642	EQUITY	CHANGE	456837400	PERPTL DBT 6.2%	0	1	2003-10-17	?	0	no	no		no		2003-10-27	2003-11-19	?							20170123.ifs	2017-01-23	2017-01-24
2439643	2439642	EQUITY	CHANGE	456837400	PERPTL DBT 6.2%	0	1	2003-10-17	?	4	no	no		no		2003-10-27	2003-11-19	?							20170123.ifs	2017-01-23	2017-01-24
2423692	2423692	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2017-03-29	2017-04-01	2017-04-17	2017-01-09		0	2017-01-10	?	0	0005374089			20170110.ifs	2017-01-10	2017-01-11
2277977	2277977	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2016-12-28	2017-01-01	2017-01-17	2016-08-24		0	2016-08-26	?	1	0005269653			20160826.ifs	2016-08-26	2016-08-27
2277978	2277978	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2016-09-28	2016-10-01	2016-10-17	2016-08-24		0	2016-08-26	?	0	0005269652			20160826.ifs	2016-08-26	2016-08-27
2164207	2164207	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2016-06-29	2016-07-01	2016-07-15	2016-04-14		0	2016-04-14	?	0	0005205456			20160414.ifs	2016-04-14	2016-04-15
2116462	2116462	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2016-03-30	2016-04-01	2016-04-15	2016-02-22		0	2016-02-22	?	0	0005174391			20160222.ifs	2016-02-22	2016-02-23
2027915	2027915	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2015-12-29	2016-01-01	2016-01-15	2015-12-08		0	2015-12-08	?	0	0005107745			20151208.ifs	2015-12-08	2015-12-09
1966125	1966125	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2015-09-29	2015-10-01	2015-10-15	2015-09-15		0	2015-09-15	?	0	0005062290			20150915.ifs	2015-09-15	2015-09-16
1810132	1810132	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2015-06-29	2015-07-01	2015-07-15	2015-03-11		0	2015-03-11	?	0	0004967466			20150311.ifs	2015-03-11	2015-03-12
1808491	1808491	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2015-03-30	2015-04-01	2015-04-15	2015-03-09		0	2015-03-09	?	0	0004966740			20150309.ifs	2015-03-09	2015-03-10
1703166	1703166	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2014-12-29	2015-01-01	2015-01-15	2014-12-08		0	2014-12-08	?	0	0004886978			20141208.ifs	2014-12-08	2014-12-09
1613207	1613207	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2014-09-29	2014-10-01	2014-10-15	2014-08-25		0	2014-08-26	?	0	0004831596			20140826.ifs	2014-08-26	2014-08-27
1500572	1500572	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2014-06-27	2014-07-01	2014-07-15	2014-04-23		0	2014-04-23	?	0	0004770011			20140423.ifs	2014-04-23	2014-04-24
1369757	1369757	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2013-12-27	2014-01-01	2014-01-15	2013-12-13		0	2013-12-13	?	0	0004681247			20131213.ifs	2013-12-13	2013-12-14
1246794	1246794	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2013-09-27	2013-10-01	2013-10-15	2013-07-25		0	2013-07-25	?	0	0004604311			20130725.ifs	2013-07-25	2013-07-26
1110838	1110838	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2013-06-27	2013-07-01	2013-07-15	2013-02-07		0	2013-02-11	?	0	0004527396			20130211.ifs	2013-02-11	2013-02-12
1098074	1098074	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2013-03-27	2013-04-01	2013-04-15	2013-01-28		0	2013-01-29	?	0	0004518538			20130129.ifs	2013-01-29	2013-01-30
1011343	1011343	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2012-12-27	2013-01-01	2013-01-15	2012-11-16		0	2012-11-16	?	0	0004458952			20121116.ifs	2012-11-16	2012-11-17
953408	953408	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2012-09-27	2012-10-01	2012-10-15	2012-09-10		0	2012-09-10	?	0	0004427717			20120910.ifs	2012-09-10	2012-09-11
764069	764069	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2012-03-28	2012-03-30	2012-04-16	2012-01-27		0	2012-01-27	?	0	0004323498			20120127.ifs	2012-01-27	2012-01-28
639493	639493	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2011-09-28	2011-09-30	2011-10-17	2011-09-08		0	2011-09-08	?	0	0004241167			20110908.ifs	2011-09-08	2011-09-09
557786	557786	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2011-06-29	2011-07-01	2011-07-15	2011-06-10		0	2011-06-10	?	0	0004200286			20110610.ifs	2011-06-10	2011-06-11
472082	472082	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2011-03-30	2011-04-01	2011-04-15	2011-03-15		0	2011-03-15	?	0	0004159563			20110315.ifs	2011-03-15	2011-03-16
376953	376953	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2010-12-29	2010-12-31	2011-01-18	2010-12-14		0	2010-12-14	?	0	0004104711			20101214.ifs	2010-12-14	2010-12-15
293885	293885	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2010-09-29	2010-10-01	2010-10-15	2010-08-31		0	2010-08-31	?	0	0004052226			20100831.ifs	2010-08-31	2010-09-01
220416	220416	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2010-06-29	2010-07-01	2010-07-15	2010-06-16		0	2010-06-16	?	0	0004018727			20100616.ifs	2010-06-16	2010-06-17
132093	132093	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2010-03-30	2010-04-01	2010-04-15	2010-03-12		0	2010-03-12	?	0	0003977710			20100312.ifs	2010-03-12	2010-04-07
43960	43960	DIVIDEND	ADD	456837400		0	0	1	0	.3875		00	2009-12-29	2010-01-01	2010-01-15	2009-12-08		0	2009-12-08	?	0	0003921692			20091208.ifs	2009-12-08	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 = 145323
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