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
3521816	3521816	CORPACTION	ADD	780097739	01	C	2018-12-31			?															20181231.ifs	2018-12-31	2019-01-01
3521819	3521819	EQUITY	CHANGE	780097739	SPONSORED ADR REPSTG PREF SER S	0	1	2007-06-27	?	4	no	no		no		2007-06-27	2007-06-28	?							20181231.ifs	2018-12-31	2019-01-01
3521821	3521820	EQUITY	CHANGE	780097739	SPONSORED ADR REPSTG PREF SER S	C	1	2007-06-27	2018-12-31	4	no	no		no		2007-06-27	2018-12-31	?							20181231.ifs	2018-12-31	2019-01-01
3521827	3521827	CORPACTION	ADD	780097739	01	C	2018-12-31			?															20181231.ifs	2018-12-31	2019-01-01
3521829	3521829	EQUITY	CHANGE	780097739	SPONSORED ADR REPSTG PREF SER S	0	1	2007-06-27	?	4	no	no		no		2007-06-27	2007-06-28	?							20181231.ifs	2018-12-31	2019-01-01
3521831	3521830	EQUITY	CHANGE	780097739	SPONSORED ADR REPSTG PREF SER S	C	1	2007-06-27	2018-12-31	4	no	no		no		2007-06-27	2018-12-31	?							20181231.ifs	2018-12-31	2019-01-01
3387609	3387609	DIVIDEND	ADD	780097739		0	0	C	0	25		12	?	?	2018-12-31	2018-11-29		0	?	2018-11-30	0				20181130.ifs	2018-11-30	2018-12-01
3387610	3387610	DIVIDEND	ADD	780097739		0	0	C	0	25		12	?	?	2018-12-31	2018-11-29		0	?	2018-11-30	0				20181130.ifs	2018-11-30	2018-12-01
3386086	3386086	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	?	?	2018-12-31	2018-11-29		0	2018-11-29	?	0	0005758745			20181129.ifs	2018-11-29	2018-11-30
3386093	3386093	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	?	?	2018-12-31	2018-11-29		0	2018-11-29	?	0	0005758745			20181129.ifs	2018-11-29	2018-11-30
3249738	3249738	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2018-09-12	2018-09-13	2018-09-28	2018-08-24		0	2018-08-24	?	0	0005711352			20180824.ifs	2018-08-24	2018-08-25
3249739	3249739	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2018-09-12	2018-09-13	2018-09-28	2018-08-24		0	2018-08-24	?	0	0005711352			20180824.ifs	2018-08-24	2018-08-25
2980270	2980270	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2018-03-14	2018-03-15	2018-03-29	2018-03-02		0	2018-03-02	?	0	0005626581			20180302.ifs	2018-03-02	2018-03-03
2980273	2980273	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2018-03-14	2018-03-15	2018-03-29	2018-03-02		0	2018-03-02	?	0	0005626581			20180302.ifs	2018-03-02	2018-03-03
2775209	2775209	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2017-12-13	2017-12-14	2017-12-29	2017-11-24		0	2017-11-24	?	0	0005532724			20171124.ifs	2017-11-24	2017-11-25
2775232	2775232	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2017-12-13	2017-12-14	2017-12-29	2017-11-24		0	2017-11-24	?	0	0005532724			20171124.ifs	2017-11-24	2017-11-25
2653947	2653947	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2017-09-13	2017-09-14	2017-09-29	2017-08-24		0	2017-08-24	?	0	0005485444			20170824.ifs	2017-08-24	2017-08-25
2581044	2581044	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2017-06-13	2017-06-15	2017-06-30	2017-06-01		0	2017-06-01	?	0	0005443771			20170601.ifs	2017-06-01	2017-06-02
2495551	2495551	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2017-03-14	2017-03-16	2017-03-31	2017-02-24		0	2017-02-24	?	0	0005391388			20170224.ifs	2017-02-24	2017-02-25
2444564	2444564	EQUITY	CHANGE	780097739	SPONSORED ADR REPSTG PREF SER S	0	1	2007-06-27	?	0	no	no		no		2007-06-27	2007-06-28	?							20170123.ifs	2017-01-23	2017-01-24
2444565	2444564	EQUITY	CHANGE	780097739	SPONSORED ADR REPSTG PREF SER S	0	1	2007-06-27	?	4	no	no		no		2007-06-27	2007-06-28	?							20170123.ifs	2017-01-23	2017-01-24
2347327	2347327	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2016-12-13	2016-12-15	2016-12-30	2016-11-22		0	2016-11-22	?	0	0005313340			20161122.ifs	2016-11-22	2016-11-23
2278725	2278725	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2016-09-13	2016-09-15	2016-09-30	2016-08-29		0	2016-08-29	?	0	0005270279			20160829.ifs	2016-08-29	2016-08-30
2204727	2204727	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2016-06-13	2016-06-15	2016-06-30	2016-05-27		0	2016-05-27	?	0	0005222556			20160527.ifs	2016-05-27	2016-05-28
2120092	2120092	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2016-03-14	2016-03-16	2016-03-31	2016-02-26		0	2016-02-26	?	0	0005176258			20160226.ifs	2016-02-26	2016-02-27
2014012	2014012	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2015-12-14	2015-12-16	2015-12-31	2015-11-23		0	2015-11-23	?	0	0005095784			20151123.ifs	2015-11-23	2015-11-24
1949588	1949588	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2015-09-11	2015-09-15	2015-09-30	2015-08-28		0	2015-08-28	?	0	0005051456			20150828.ifs	2015-08-28	2015-08-29
1873379	1873379	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2015-06-11	2015-06-15	2015-06-30	2015-05-29		0	2015-05-29	?	0	0005004992			20150529.ifs	2015-05-29	2015-05-30
1687703	1687703	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2014-12-12	2014-12-16	2014-12-31	2014-11-25		0	2014-11-25	?	0	0004876062			20141125.ifs	2014-11-25	2014-11-26
1610053	1610053	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2014-09-11	2014-09-15	2014-09-30	2014-08-20		0	2014-08-20	?	0	0004830345			20140820.ifs	2014-08-20	2014-08-21
1525935	1525935	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2014-06-11	2014-06-13	2014-06-30	2014-05-19		0	2014-05-19	?	0	0004783285			20140519.ifs	2014-05-19	2014-05-20
1450041	1450041	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2014-03-12	2014-03-14	2014-03-31	2014-02-26		0	2014-02-26	?	0	0004739839			20140226.ifs	2014-02-26	2014-02-27
1347146	1347146	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2013-12-12	2013-12-16	2013-12-31	2013-11-27		0	2013-11-27	?	0	0004662215			20131127.ifs	2013-11-27	2013-11-28
1271082	1271082	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2013-09-11	2013-09-13	2013-09-30	2013-08-26		0	2013-08-26	?	0	0004617984			20130826.ifs	2013-08-26	2013-08-27
1193387	1193387	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2013-06-11	2013-06-13	2013-06-28	2013-05-28		0	2013-05-28	?	0	0004573760			20130528.ifs	2013-05-28	2013-05-29
1117854	1117854	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2013-03-11	2013-03-13	2013-03-28	2013-02-26		0	2013-02-26	?	0	0004530721			20130226.ifs	2013-02-26	2013-02-27
1018132	1018132	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2012-12-12	2012-12-14	2012-12-31	2012-11-29		0	2012-11-29	?	0	0004461959			20121129.ifs	2012-11-29	2012-11-30
943116	943116	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2012-09-11	2012-09-13	2012-09-28	2012-08-31		0	2012-08-31	?	0	0004419830			20120831.ifs	2012-08-31	2012-09-01
857049	857049	DIVIDEND	ADD	780097739		6	0	1	9	.4125		25	2012-06-12	2012-06-14	2012-06-29	2012-05-08		0	2012-05-08	?	0	0004373050			20120508.ifs	2012-05-08	2012-05-09
214656	214656	DIVIDEND	ADD	780097739		0	0	E	0	0		58	?	?	2010-06-30	2010-06-07		0	2010-06-07	?	0	0004017000			20100607.ifs	2010-06-07	2010-06-08
165109	165109	DIVIDEND	CHANGE	780097739		6	0	1	0	.4125		05	2009-06-11	2009-06-15	2009-06-30	2009-06-01		0	2009-06-01	2010-04-23	0	0003835537			20100423.ifs	2010-04-23	2010-04-24
165110	165109	DIVIDEND	CHANGE	780097739		6	0	1	0	.4125		05	2009-06-11	2009-06-15	2009-06-30	2009-06-01		0	2009-06-01	2010-04-23	0	0003835537			20100423.ifs	2010-04-23	2010-04-24
165111	165111	DIVIDEND	CHANGE	780097739		6	0	1	0	.4125		05	2009-09-11	2009-09-15	2009-09-30	2009-09-01		0	2009-09-01	2010-04-23	0	0003875633			20100423.ifs	2010-04-23	2010-04-24
165112	165111	DIVIDEND	CHANGE	780097739		6	0	1	0	.4125		05	2009-09-11	2009-09-15	2009-09-30	2009-09-01		0	2009-09-01	2010-04-23	0	0003875633			20100423.ifs	2010-04-23	2010-04-24
115165	115165	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2010-03-12	2010-03-16	2010-03-31	2010-02-23		0	2010-02-23	?	0	0003967586			20100223.ifs	2010-02-23	2010-04-07
35945	35945	DIVIDEND	ADD	780097739		6	0	1	0	.4125		05	2009-12-14	2009-12-16	2009-12-31	2009-12-01		0	2009-12-01	?	0	0003915683			20091202.ifs	2009-12-02	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 = 151985
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