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
2510762	2510762	DIVIDEND	DELETE	74460D125		0	0	1	6	0		08	?	?	2016-07-26	2016-06-21		0	2016-06-21	?	0	0005236369			20170310.ifs	2017-03-10	2017-03-11
2510763	2510763	DIVIDEND	ADD	74460D125		0	0	1	0	.110243		00	?	?	2016-07-26	2016-06-21		1	2016-06-21	2017-03-10	0	0005236369			20170310.ifs	2017-03-10	2017-03-11
2256924	2256924	CORPACTION	ADD	74460D125	01	C	2016-07-26			?															20160726.ifs	2016-07-26	2016-07-27
2256925	2256925	EQUITY	CHANGE	74460D125	DEPOSITARY SH REPSTG 1/1000TH PFD SER R	0	1	2011-07-20	?	0	no	no		no		2011-07-20	?	?							20160726.ifs	2016-07-26	2016-07-27
2256926	2256925	EQUITY	CHANGE	74460D125	DEPOSITARY SH REPSTG 1/1000TH PFD SER R	C	1	2011-07-20	2016-07-26	0	no	no		no		2011-07-20	2016-07-26	?							20160726.ifs	2016-07-26	2016-07-27
2227319	2227319	DIVIDEND	ADD	74460D125		0	0	C	0	25		12	?	?	2016-07-26	2016-06-21		0	?	2016-06-22	0				20160622.ifs	2016-06-22	2016-06-23
2226402	2226402	DIVIDEND	ADD	74460D125		0	0	1	6	0		08	?	?	2016-07-26	2016-06-21		0	2016-06-21	?	0	0005236369			20160621.ifs	2016-06-21	2016-06-22
2179985	2179985	DIVIDEND	ADD	74460D125		0	0	1	0	.396875		00	2016-06-13	2016-06-15	2016-06-30	2016-04-26		0	2016-04-27	?	0	0005208797			20160427.ifs	2016-04-27	2016-04-28
2114015	2114015	DIVIDEND	ADD	74460D125		0	0	1	0	.396875		00	2016-03-14	2016-03-16	2016-03-31	2016-02-15		0	2016-02-17	?	0	0005173138			20160217.ifs	2016-02-17	2016-02-18
1999024	1999024	DIVIDEND	ADD	74460D125		0	0	1	0	.396875		00	2015-12-11	2015-12-15	2015-12-30	2015-10-28		0	2015-10-29	?	0	0005083266			20151029.ifs	2015-10-29	2015-10-30
1935619	1935619	DIVIDEND	ADD	74460D125		0	0	1	0	.396875		00	2015-09-11	2015-09-15	2015-09-30	2015-07-29		0	2015-08-04	?	0	0005045032			20150804.ifs	2015-08-04	2015-08-05
1851526	1851526	DIVIDEND	ADD	74460D125		0	0	1	0	.396875		00	2015-06-11	2015-06-15	2015-06-30	2015-04-29		0	2015-04-30	?	0	0004992031			20150430.ifs	2015-04-30	2015-05-01
1793119	1793119	DIVIDEND	ADD	74460D125		0	0	1	0	.396875		00	2015-03-12	2015-03-16	2015-03-31	2015-02-19		0	2015-02-20	?	0	0004956247			20150220.ifs	2015-02-20	2015-02-21
1676060	1676060	DIVIDEND	ADD	74460D125		0	0	1	0	.396875		00	2014-12-11	2014-12-15	2014-12-30	2014-10-30		0	2014-11-05	?	0	0004871106			20141105.ifs	2014-11-05	2014-11-06
1595447	1595447	DIVIDEND	ADD	74460D125		0	0	1	0	.396875		00	2014-09-11	2014-09-15	2014-09-30	2014-08-01		0	2014-08-01	?	0	0004824466			20140801.ifs	2014-08-01	2014-08-02
1516404	1516404	DIVIDEND	ADD	74460D125		0	0	1	0	.396875		00	2014-06-11	2014-06-13	2014-06-30	2014-05-01		0	2014-05-02	?	0	0004779781			20140502.ifs	2014-05-02	2014-05-03
1449241	1449241	DIVIDEND	ADD	74460D125		0	0	1	0	.396875		00	2014-03-12	2014-03-14	2014-03-31	2014-02-24		0	2014-02-25	?	0	0004739182			20140225.ifs	2014-02-25	2014-02-26
1330953	1330953	DIVIDEND	ADD	74460D125		0	0	1	0	.396875		00	2013-12-11	2013-12-13	2013-12-30	2013-10-31		0	2013-11-01	?	0	0004654370			20131101.ifs	2013-11-01	2013-11-02
1258595	1258595	DIVIDEND	ADD	74460D125		0	0	1	0	.396875		00	2013-09-11	2013-09-13	2013-09-30	2013-08-01		0	2013-08-02	?	0	0004613143			20130802.ifs	2013-08-02	2013-08-03
1187004	1187004	DIVIDEND	DELETE	74460D125		0	0	1	6	0		08	2013-06-10	2013-06-12	2013-06-27	2013-05-09		0	2013-05-09	?	0	0004570457			20130516.ifs	2013-05-16	2013-05-17
1187005	1187005	DIVIDEND	ADD	74460D125		0	0	1	0	.396875		00	2013-06-10	2013-06-12	2013-06-27	2013-05-09		1	2013-05-09	2013-05-16	0	0004570457			20130516.ifs	2013-05-16	2013-05-17
1183107	1183107	DIVIDEND	ADD	74460D125		0	0	1	6	0		08	2013-06-10	2013-06-12	2013-06-27	2013-05-09		0	2013-05-09	?	0	0004570457			20130509.ifs	2013-05-09	2013-05-10
1116431	1116431	DIVIDEND	ADD	74460D125		0	0	1	0	.396875		00	2013-03-11	2013-03-13	2013-03-28	2013-02-21		0	2013-02-22	?	0	0004530150			20130222.ifs	2013-02-22	2013-02-23
1017168	1017168	DIVIDEND	DELETE	74460D125		0	0	1	6	0		08	2012-12-10	2012-12-12	2012-12-27	2012-11-16		0	2012-11-16	?	0	0004458542			20121128.ifs	2012-11-28	2012-11-29
1017169	1017169	DIVIDEND	ADD	74460D125		0	0	1	0	.396875		00	2012-12-10	2012-12-12	2012-12-27	2012-11-08		1	2012-11-16	2012-11-28	0	0004458542			20121128.ifs	2012-11-28	2012-11-29
1011240	1011240	DIVIDEND	ADD	74460D125		0	0	1	6	0		08	2012-12-10	2012-12-12	2012-12-27	2012-11-16		0	2012-11-16	?	0	0004458542			20121116.ifs	2012-11-16	2012-11-17
926586	926586	DIVIDEND	ADD	74460D125		0	0	1	0	.396875		00	2012-09-10	2012-09-12	2012-09-27	2012-08-02		0	2012-08-06	?	0	0004414105			20120806.ifs	2012-08-06	2012-08-07
879135	879135	DIVIDEND	ADD	74460D125		0	0	1	0	.396875		00	2012-06-11	2012-06-13	2012-06-28	2012-05-03		0	2012-06-04	?	0	0004384586			20120604.ifs	2012-06-04	2012-06-05
856057	856057	DIVIDEND	CHANGE	74460D125		0	0	1	4	.291042		00	2011-09-12	2011-09-14	2011-09-29	2011-08-04		0	2011-08-31	2012-05-07	0	0004235063			20120507.ifs	2012-05-07	2012-05-08
856058	856057	DIVIDEND	CHANGE	74460D125		0	0	1	4	.291042		00	2011-09-12	2011-09-14	2011-09-29	2011-08-04		0	2011-08-31	2012-05-07	0	0004235063			20120507.ifs	2012-05-07	2012-05-08
856059	856059	DIVIDEND	CHANGE	74460D125		0	0	1	0	.396875		00	2011-12-12	2011-12-14	2011-12-29	2011-11-03		0	2011-11-03	2012-05-07	0	0004268188			20120507.ifs	2012-05-07	2012-05-08
856060	856059	DIVIDEND	CHANGE	74460D125		0	0	1	0	.396875		00	2011-12-12	2011-12-14	2011-12-29	2011-11-03		0	2011-11-03	2012-05-07	0	0004268188			20120507.ifs	2012-05-07	2012-05-08
856061	856061	DIVIDEND	CHANGE	74460D125		0	0	1	0	.396875		00	2012-03-12	2012-03-14	2012-03-29	2012-02-23		0	2012-02-27	2012-05-07	0	0004335770			20120507.ifs	2012-05-07	2012-05-08
856062	856061	DIVIDEND	CHANGE	74460D125		0	0	1	0	.396875		00	2012-03-12	2012-03-14	2012-03-29	2012-02-23		0	2012-02-27	2012-05-07	0	0004335770			20120507.ifs	2012-05-07	2012-05-08
785872	785872	DIVIDEND	ADD	74460D125		0	0	1	0	.396875		00	2012-03-12	2012-03-14	2012-03-29	2012-02-23		0	2012-02-27	?	0	0004335770			20120227.ifs	2012-02-27	2012-02-28
689830	689830	DIVIDEND	ADD	74460D125		0	0	1	0	.396875		00	2011-12-12	2011-12-14	2011-12-29	2011-11-03		0	2011-11-03	?	0	0004268188			20111103.ifs	2011-11-03	2011-11-04
629567	629567	DIVIDEND	ADD	74460D125		0	0	1	4	.291042		00	2011-09-12	2011-09-14	2011-09-29	2011-08-04		0	2011-08-31	?	0	0004235063			20110831.ifs	2011-08-31	2011-09-01
592704	592704	CORPACTION	ADD	74460D125	66	X	2011-07-26	74460D125	01	?															20110726.ifs	2011-07-26	2011-07-27
592705	592705	EXCHANGE	ADD	74460D125	01	2011-07-26	2011-07-26	PSA_PR	0	1	2011-07-26	?													20110726.ifs	2011-07-26	2011-07-27
591079	591079	EQUITY	ADD	74460D125	DEPOSITARY SH REPSTG 1/1000TH PFD SER R	N	1	2011-07-20	?	0	no	no		no		2011-07-20	?	?							20110720.ifs	2011-07-20	2011-07-21
591080	591080	EXCHANGE	ADD	74460D125	66	2011-07-20	2011-07-20	PSAD	0	1	2011-07-20	?													20110720.ifs	2011-07-20	2011-07-21

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