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
4288607	4288607	CORPACTION	ADD	456837509	01	C	2020-04-15			?															20200415.ifs	2020-04-15	2020-04-16
4288608	4288608	CORPACTION	ADD	456837509	01	C	2020-04-15			?															20200415.ifs	2020-04-15	2020-04-16
4288609	4288609	EQUITY	CHANGE	456837509	PERPETUAL DENT SECS %	0	1	2005-09-12	?	4	no	no		no		2005-09-22	2006-12-08	?							20200415.ifs	2020-04-15	2020-04-16
4288610	4288610	EQUITY	CHANGE	456837509	PERPETUAL DENT SECS %	0	1	2005-09-12	?	4	no	no		no		2005-09-22	2006-12-08	?							20200415.ifs	2020-04-15	2020-04-16
4288611	4288610	EQUITY	CHANGE	456837509	PERPETUAL DENT SECS %	C	1	2005-09-12	2020-04-15	4	no	no		no		2005-09-22	2020-04-15	?							20200415.ifs	2020-04-15	2020-04-16
4288612	4288611	EQUITY	CHANGE	456837509	PERPETUAL DENT SECS %	C	1	2005-09-12	2020-04-15	4	no	no		no		2005-09-22	2020-04-15	?							20200415.ifs	2020-04-15	2020-04-16
4242163	4242163	DIVIDEND	ADD	456837509		0	0	C	0	25		12	?	?	2020-04-15	2020-03-16		0	?	2020-03-17	0				20200317.ifs	2020-03-17	2020-03-18
4242164	4242164	DIVIDEND	ADD	456837509		0	0	C	0	25		12	?	?	2020-04-15	2020-03-16		0	?	2020-03-17	0				20200317.ifs	2020-03-17	2020-03-18
4241479	4241479	DIVIDEND	CHANGE	456837509		0	0	1	0	.382812		00	2020-03-31	2020-04-01	2020-04-15	2019-12-13		0	2019-12-13	?	1	0005999223			20200316.ifs	2020-03-16	2020-03-17
4241481	4241480	DIVIDEND	CHANGE	456837509		0	0	1	0	.382812		00	2020-03-31	2020-04-01	2020-04-15	2019-12-13		1	2019-12-13	2020-03-16	1	0005999223			20200316.ifs	2020-03-16	2020-03-17
4241627	4241627	DIVIDEND	CHANGE	456837509		0	0	1	0	.382812		00	2020-03-31	2020-04-01	2020-04-15	2019-12-13		0	2019-12-13	?	1	0005999223			20200316.ifs	2020-03-16	2020-03-17
4241629	4241628	DIVIDEND	CHANGE	456837509		0	0	1	0	.382812		00	2020-03-31	2020-04-01	2020-04-15	2019-12-13		1	2019-12-13	2020-03-16	1	0005999223			20200316.ifs	2020-03-16	2020-03-17
4068353	4068353	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2020-03-31	2020-04-01	2020-04-15	2019-12-13		0	2019-12-13	?	1	0005999223			20191213.ifs	2019-12-13	2019-12-14
4068355	4068355	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2019-12-30	2020-01-01	2020-01-15	2019-12-13		0	2019-12-13	?	0	0005999220			20191213.ifs	2019-12-13	2019-12-14
4068428	4068428	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2020-03-31	2020-04-01	2020-04-15	2019-12-13		0	2019-12-13	?	1	0005999223			20191213.ifs	2019-12-13	2019-12-14
4068430	4068430	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2019-12-30	2020-01-01	2020-01-15	2019-12-13		0	2019-12-13	?	0	0005999220			20191213.ifs	2019-12-13	2019-12-14
3878656	3878656	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2019-09-30	2019-10-01	2019-10-15	2019-08-13		0	2019-08-13	?	0	0005930213			20190813.ifs	2019-08-13	2019-08-14
3878657	3878657	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2019-09-30	2019-10-01	2019-10-15	2019-08-13		0	2019-08-13	?	0	0005930213			20190813.ifs	2019-08-13	2019-08-14
3646867	3646867	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2019-06-28	2019-07-01	2019-07-15	2019-03-25		0	2019-03-25	?	0	0005857399			20190325.ifs	2019-03-25	2019-03-26
3646931	3646931	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2019-06-28	2019-07-01	2019-07-15	2019-03-25		0	2019-03-25	?	0	0005857399			20190325.ifs	2019-03-25	2019-03-26
3644432	3644432	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2019-03-29	2019-04-01	2019-04-15	2019-03-22		0	2019-03-22	?	0	0005856575			20190322.ifs	2019-03-22	2019-03-23
3644455	3644455	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2019-03-29	2019-04-01	2019-04-15	2019-03-22		0	2019-03-22	?	0	0005856575			20190322.ifs	2019-03-22	2019-03-23
3241417	3241417	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2018-12-28	2019-01-01	2019-01-15	2018-08-16		0	2018-08-16	?	1	0005708628			20180816.ifs	2018-08-16	2018-08-17
3241419	3241419	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2018-09-28	2018-10-01	2018-10-15	2018-08-16		0	2018-08-16	?	0	0005708627			20180816.ifs	2018-08-16	2018-08-17
3241464	3241464	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2018-12-28	2019-01-01	2019-01-15	2018-08-16		0	2018-08-16	?	1	0005708628			20180816.ifs	2018-08-16	2018-08-17
3241466	3241466	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2018-09-28	2018-10-01	2018-10-15	2018-08-16		0	2018-08-16	?	0	0005708627			20180816.ifs	2018-08-16	2018-08-17
2987153	2987153	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2018-06-28	2018-06-29	2018-07-16	2018-03-01		0	2018-03-09	?	1	0005628061			20180309.ifs	2018-03-09	2018-03-10
2987155	2987155	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2018-03-28	2018-03-29	2018-04-16	2018-03-01		0	2018-03-09	?	0	0005628059			20180309.ifs	2018-03-09	2018-03-10
2987158	2987158	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2018-06-28	2018-06-29	2018-07-16	2018-03-01		0	2018-03-09	?	1	0005628061			20180309.ifs	2018-03-09	2018-03-10
2987160	2987160	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2018-03-28	2018-03-29	2018-04-16	2018-03-01		0	2018-03-09	?	0	0005628059			20180309.ifs	2018-03-09	2018-03-10
2582488	2582488	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2017-12-28	2017-12-29	2018-01-16	2017-05-31		0	2017-06-01	?	2	0005443451			20170601.ifs	2017-06-01	2017-06-02
2582489	2582489	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2017-09-28	2017-09-29	2017-10-16	2017-05-31		0	2017-06-01	?	1	0005443449			20170601.ifs	2017-06-01	2017-06-02
2582490	2582490	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2017-06-28	2017-06-30	2017-07-17	2017-05-31		0	2017-06-01	?	0	0005443448			20170601.ifs	2017-06-01	2017-06-02
2439644	2439644	EQUITY	CHANGE	456837509	PERPETUAL DENT SECS %	0	1	2005-09-12	?	0	no	no		no		2005-09-22	2006-12-08	?							20170123.ifs	2017-01-23	2017-01-24
2439645	2439644	EQUITY	CHANGE	456837509	PERPETUAL DENT SECS %	0	1	2005-09-12	?	4	no	no		no		2005-09-22	2006-12-08	?							20170123.ifs	2017-01-23	2017-01-24
2423691	2423691	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2017-03-29	2017-04-01	2017-04-17	2017-01-09		0	2017-01-10	?	0	0005374056			20170110.ifs	2017-01-10	2017-01-11
2277975	2277975	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2016-12-28	2017-01-01	2017-01-17	2016-08-24		0	2016-08-26	?	1	0005269632			20160826.ifs	2016-08-26	2016-08-27
2277976	2277976	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2016-09-28	2016-10-01	2016-10-17	2016-08-24		0	2016-08-26	?	0	0005269631			20160826.ifs	2016-08-26	2016-08-27
2164206	2164206	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2016-06-29	2016-07-01	2016-07-15	2016-04-14		0	2016-04-14	?	0	0005205455			20160414.ifs	2016-04-14	2016-04-15
2116461	2116461	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2016-03-30	2016-04-01	2016-04-15	2016-02-22		0	2016-02-22	?	0	0005174390			20160222.ifs	2016-02-22	2016-02-23
2027914	2027914	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2015-12-29	2016-01-01	2016-01-15	2015-12-08		0	2015-12-08	?	0	0005107733			20151208.ifs	2015-12-08	2015-12-09
1966124	1966124	DIVIDEND	ADD	456837509		0	0	1	0	.382812		00	2015-09-29	2015-10-01	2015-10-15	2015-09-15		0	2015-09-15	?	0	0005062289			20150915.ifs	2015-09-15	2015-09-16
1810131	1810131	DIVIDEND	ADD	456837509		0	0	1	0	.382813		00	2015-06-29	2015-07-01	2015-07-15	2015-03-11		0	2015-03-11	?	0	0004967465			20150311.ifs	2015-03-11	2015-03-12
1808490	1808490	DIVIDEND	ADD	456837509		0	0	1	0	.382813		00	2015-03-30	2015-04-01	2015-04-15	2015-03-09		0	2015-03-09	?	0	0004966739			20150309.ifs	2015-03-09	2015-03-10
1703165	1703165	DIVIDEND	ADD	456837509		0	0	1	0	.382813		00	2014-12-29	2015-01-01	2015-01-15	2014-12-08		0	2014-12-08	?	0	0004886977			20141208.ifs	2014-12-08	2014-12-09
1613206	1613206	DIVIDEND	ADD	456837509		0	0	1	0	.382813		00	2014-09-29	2014-10-01	2014-10-15	2014-08-25		0	2014-08-26	?	0	0004831595			20140826.ifs	2014-08-26	2014-08-27
1500571	1500571	DIVIDEND	ADD	456837509		0	0	1	0	.382813		00	2014-06-27	2014-07-01	2014-07-15	2014-04-23		0	2014-04-23	?	0	0004770010			20140423.ifs	2014-04-23	2014-04-24
1246792	1246792	DIVIDEND	ADD	456837509		0	0	1	0	.382813		00	2013-12-27	2014-01-01	2014-01-15	2013-07-24		0	2013-07-25	?	1	0004604083			20130725.ifs	2013-07-25	2013-07-26
1246793	1246793	DIVIDEND	ADD	456837509		0	0	1	0	.382813		00	2013-09-27	2013-10-01	2013-10-15	2013-07-24		0	2013-07-25	?	0	0004604082			20130725.ifs	2013-07-25	2013-07-26
1110837	1110837	DIVIDEND	ADD	456837509		0	0	1	0	.382813		00	2013-06-27	2013-07-01	2013-07-15	2013-02-07		0	2013-02-11	?	0	0004527394			20130211.ifs	2013-02-11	2013-02-12
1098073	1098073	DIVIDEND	ADD	456837509		0	0	1	0	.382813		00	2013-03-27	2013-04-01	2013-04-15	2013-01-28		0	2013-01-29	?	0	0004518537			20130129.ifs	2013-01-29	2013-01-30
1011342	1011342	DIVIDEND	ADD	456837509		0	0	1	0	.382813		00	2012-12-27	2013-01-01	2013-01-15	2012-11-16		0	2012-11-16	?	0	0004458951			20121116.ifs	2012-11-16	2012-11-17
953407	953407	DIVIDEND	ADD	456837509		0	0	1	0	.382813		00	2012-09-27	2012-10-01	2012-10-15	2012-09-10		0	2012-09-10	?	0	0004427716			20120910.ifs	2012-09-10	2012-09-11
764068	764068	DIVIDEND	ADD	456837509		0	0	1	0	.382813		00	2012-03-28	2012-03-30	2012-04-16	2012-01-27		0	2012-01-27	?	0	0004323497			20120127.ifs	2012-01-27	2012-01-28
639492	639492	DIVIDEND	ADD	456837509		0	0	1	0	.382813		00	2011-09-28	2011-09-30	2011-10-17	2011-09-08		0	2011-09-08	?	0	0004241166			20110908.ifs	2011-09-08	2011-09-09
557785	557785	DIVIDEND	ADD	456837509		0	0	1	0	.382813		00	2011-06-29	2011-07-01	2011-07-15	2011-06-10		0	2011-06-10	?	0	0004200285			20110610.ifs	2011-06-10	2011-06-11
472081	472081	DIVIDEND	ADD	456837509		0	0	1	0	.382813		00	2011-03-30	2011-04-01	2011-04-15	2011-03-15		0	2011-03-15	?	0	0004159562			20110315.ifs	2011-03-15	2011-03-16
376952	376952	DIVIDEND	ADD	456837509		0	0	1	0	.382813		00	2010-12-29	2010-12-31	2011-01-18	2010-12-14		0	2010-12-14	?	0	0004104710			20101214.ifs	2010-12-14	2010-12-15
293884	293884	DIVIDEND	ADD	456837509		0	0	1	0	.382813		00	2010-09-29	2010-10-01	2010-10-15	2010-08-31		0	2010-08-31	?	0	0004052225			20100831.ifs	2010-08-31	2010-09-01
220415	220415	DIVIDEND	ADD	456837509		0	0	1	0	.38281		00	2010-06-29	2010-07-01	2010-07-15	2010-06-16		0	2010-06-16	?	0	0004018725			20100616.ifs	2010-06-16	2010-06-17
132092	132092	DIVIDEND	ADD	456837509		0	0	1	0	.38281		00	2010-03-30	2010-04-01	2010-04-15	2010-03-12		0	2010-03-12	?	0	0003977709			20100312.ifs	2010-03-12	2010-04-07
43959	43959	DIVIDEND	ADD	456837509		0	0	1	0	.38281		00	2009-12-29	2010-01-01	2010-01-15	2009-12-08		0	2009-12-08	?	0	0003921691			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 = 145324
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