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
2691306	2691306	CORPACTION	ADD	74460W404	01	C	2017-09-28			?															20170928.ifs	2017-09-28	2017-09-29
2691308	2691308	EQUITY	CHANGE	74460W404	DEPOSITARY SH REPSTG 1/1000TH PFD SH BEN INT SER T	0	1	2012-03-07	?	4	no	no		no		2012-03-07	2012-07-24	?							20170928.ifs	2017-09-28	2017-09-29
2691310	2691309	EQUITY	CHANGE	74460W404	DEPOSITARY SH REPSTG 1/1000TH PFD SH BEN INT SER T	C	1	2012-03-07	2017-09-28	4	no	no		no		2012-03-07	2017-09-28	?							20170928.ifs	2017-09-28	2017-09-29
2691437	2691437	CORPACTION	ADD	74460W404	01	C	2017-09-28			?															20170928.ifs	2017-09-28	2017-09-29
2691439	2691439	EQUITY	CHANGE	74460W404	DEPOSITARY SH REPSTG 1/1000TH PFD SH BEN INT SER T	0	1	2012-03-07	?	4	no	no		no		2012-03-07	2012-07-24	?							20170928.ifs	2017-09-28	2017-09-29
2691441	2691440	EQUITY	CHANGE	74460W404	DEPOSITARY SH REPSTG 1/1000TH PFD SH BEN INT SER T	C	1	2012-03-07	2017-09-28	4	no	no		no		2012-03-07	2017-09-28	?							20170928.ifs	2017-09-28	2017-09-29
2645133	2645133	DIVIDEND	ADD	74460W404		0	0	C	0	25		12	?	?	2017-09-28	2017-08-04		0	?	2017-08-07	0				20170807.ifs	2017-08-07	2017-08-08
2644777	2644777	DIVIDEND	CHANGE	74460W404		0	0	1	0	.359375		00	2017-09-12	2017-09-13	2017-09-28	2017-07-26		0	2017-08-02	?	0	0005480103			20170804.ifs	2017-08-04	2017-08-05
2644778	2644777	DIVIDEND	CHANGE	74460W404		0	0	1	0	.359375		00	2017-09-12	2017-09-13	2017-09-28	2017-07-26		1	2017-08-02	2017-08-04	0	0005480103			20170804.ifs	2017-08-04	2017-08-05
2642705	2642705	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2017-09-12	2017-09-13	2017-09-28	2017-07-26		0	2017-08-02	?	0	0005480103			20170802.ifs	2017-08-02	2017-08-03
2548015	2548015	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2017-06-12	2017-06-14	2017-06-29	2017-04-26		0	2017-04-26	?	0	0005424445			20170426.ifs	2017-04-26	2017-04-27
2496415	2496415	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2017-03-13	2017-03-15	2017-03-30	2017-02-22		0	2017-02-27	?	0	0005391870			20170227.ifs	2017-02-27	2017-02-28
2444226	2444226	EQUITY	CHANGE	74460W404	DEPOSITARY SH REPSTG 1/1000TH PFD SH BEN INT SER T	0	1	2012-03-07	?	0	no	no		no		2012-03-07	2012-07-24	?							20170123.ifs	2017-01-23	2017-01-24
2444227	2444226	EQUITY	CHANGE	74460W404	DEPOSITARY SH REPSTG 1/1000TH PFD SH BEN INT SER T	0	1	2012-03-07	?	4	no	no		no		2012-03-07	2012-07-24	?							20170123.ifs	2017-01-23	2017-01-24
2341457	2341457	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2016-12-12	2016-12-14	2016-12-29	2016-10-26		0	2016-11-09	?	0	0005310514			20161109.ifs	2016-11-09	2016-11-10
2258971	2258971	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2016-09-12	2016-09-14	2016-09-29	2016-07-27		0	2016-07-28	?	0	0005255210			20160728.ifs	2016-07-28	2016-07-29
2179982	2179982	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2016-06-13	2016-06-15	2016-06-30	2016-04-26		0	2016-04-27	?	0	0005208799			20160427.ifs	2016-04-27	2016-04-28
2114011	2114011	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2016-03-14	2016-03-16	2016-03-31	2016-02-15		0	2016-02-17	?	0	0005173140			20160217.ifs	2016-02-17	2016-02-18
1999020	1999020	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2015-12-11	2015-12-15	2015-12-30	2015-10-28		0	2015-10-29	?	0	0005083268			20151029.ifs	2015-10-29	2015-10-30
1935614	1935614	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2015-09-11	2015-09-15	2015-09-30	2015-07-29		0	2015-08-04	?	0	0005045034			20150804.ifs	2015-08-04	2015-08-05
1851521	1851521	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2015-06-11	2015-06-15	2015-06-30	2015-04-29		0	2015-04-30	?	0	0004992035			20150430.ifs	2015-04-30	2015-05-01
1793113	1793113	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2015-03-12	2015-03-16	2015-03-31	2015-02-19		0	2015-02-20	?	0	0004956249			20150220.ifs	2015-02-20	2015-02-21
1676054	1676054	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2014-12-11	2014-12-15	2014-12-30	2014-10-30		0	2014-11-05	?	0	0004871108			20141105.ifs	2014-11-05	2014-11-06
1595441	1595441	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2014-09-11	2014-09-15	2014-09-30	2014-08-01		0	2014-08-01	?	0	0004824468			20140801.ifs	2014-08-01	2014-08-02
1516398	1516398	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2014-06-11	2014-06-13	2014-06-30	2014-05-01		0	2014-05-02	?	0	0004779783			20140502.ifs	2014-05-02	2014-05-03
1449235	1449235	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2014-03-12	2014-03-14	2014-03-31	2014-02-24		0	2014-02-25	?	0	0004739184			20140225.ifs	2014-02-25	2014-02-26
1330947	1330947	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2013-12-11	2013-12-13	2013-12-30	2013-10-31		0	2013-11-01	?	0	0004654372			20131101.ifs	2013-11-01	2013-11-02
1258589	1258589	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2013-09-11	2013-09-13	2013-09-30	2013-08-01		0	2013-08-02	?	0	0004613145			20130802.ifs	2013-08-02	2013-08-03
1186994	1186994	DIVIDEND	DELETE	74460W404		0	0	1	6	0		08	2013-06-10	2013-06-12	2013-06-27	2013-05-09		0	2013-05-09	?	0	0004570459			20130516.ifs	2013-05-16	2013-05-17
1186995	1186995	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2013-06-10	2013-06-12	2013-06-27	2013-05-09		1	2013-05-09	2013-05-16	0	0004570459			20130516.ifs	2013-05-16	2013-05-17
1183102	1183102	DIVIDEND	ADD	74460W404		0	0	1	6	0		08	2013-06-10	2013-06-12	2013-06-27	2013-05-09		0	2013-05-09	?	0	0004570459			20130509.ifs	2013-05-09	2013-05-10
1116426	1116426	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2013-03-11	2013-03-13	2013-03-28	2013-02-21		0	2013-02-22	?	0	0004530152			20130222.ifs	2013-02-22	2013-02-23
1017152	1017152	DIVIDEND	DELETE	74460W404		0	0	1	6	0		08	2012-12-10	2012-12-12	2012-12-27	2012-11-16		0	2012-11-16	?	0	0004458544			20121128.ifs	2012-11-28	2012-11-29
1017153	1017153	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2012-12-10	2012-12-12	2012-12-27	2012-11-08		1	2012-11-16	2012-11-28	0	0004458544			20121128.ifs	2012-11-28	2012-11-29
1011235	1011235	DIVIDEND	ADD	74460W404		0	0	1	6	0		08	2012-12-10	2012-12-12	2012-12-27	2012-11-16		0	2012-11-16	?	0	0004458544			20121116.ifs	2012-11-16	2012-11-17
926576	926576	DIVIDEND	ADD	74460W404		0	0	1	0	.359375		00	2012-09-10	2012-09-12	2012-09-27	2012-08-02		0	2012-08-06	?	0	0004414107			20120806.ifs	2012-08-06	2012-08-07
919362	919362	EQUITY	CHANGE	74460W404	DEPOSITARY SH REPSTG 1/1000TH PFD SH BEN INT SER T	0	0	2012-03-07	?	0	no	no		no		2012-03-07	2012-03-07	?							20120724.ifs	2012-07-24	2012-07-25
919363	919362	EQUITY	CHANGE	74460W404	DEPOSITARY SH REPSTG 1/1000TH PFD SH BEN INT SER T	0	1	2012-03-07	?	0	no	no		no		2012-03-07	2012-07-24	?							20120724.ifs	2012-07-24	2012-07-25
879121	879121	DIVIDEND	ADD	74460W404		0	0	1	4	.435243		00	2012-06-11	2012-06-13	2012-06-28	2012-05-03		0	2012-06-04	?	0	0004384588			20120604.ifs	2012-06-04	2012-06-05
801134	801134	CORPACTION	ADD	74460W404	66	X	2012-03-13	74460W404	01	?															20120313.ifs	2012-03-13	2012-03-14
801135	801135	EXCHANGE	ADD	74460W404	01	2012-03-13	2012-03-13	PSA_PT	0	0	2012-03-13	?													20120313.ifs	2012-03-13	2012-03-14
798281	798281	EQUITY	ADD	74460W404	COM	N	0	2012-03-07	?	0	no	no		no		2012-03-07	?	?							20120307.ifs	2012-03-07	2012-03-08
798282	798282	EXCHANGE	ADD	74460W404	66	2012-03-07	2012-03-07	PSAPP	0	0	2012-03-07	?													20120307.ifs	2012-03-07	2012-03-08
798413	798413	EQUITY	CHANGE	74460W404	COM	N	0	2012-03-07	?	0	no	no		no		2012-03-07	?	?							20120307.ifs	2012-03-07	2012-03-08
798414	798413	EQUITY	CHANGE	74460W404	DEPOSITARY SH REPSTG 1/1000TH PFD SH BEN INT SER T	N	0	2012-03-07	?	0	no	no		no		2012-03-07	2012-03-07	?							20120307.ifs	2012-03-07	2012-03-08
798866	798866	EQUITY	CHANGE	74460W404	DEPOSITARY SH REPSTG 1/1000TH PFD SH BEN INT SER T	N	0	2012-03-07	?	0	no	no		no		2012-03-07	2012-03-07	?							20120307.ifs	2012-03-07	2012-03-08
798867	798866	EQUITY	CHANGE	74460W404	DEPOSITARY SH REPSTG 1/1000TH PFD SH BEN INT SER T	0	0	2012-03-07	?	0	no	no		no		2012-03-07	2012-03-07	?							20120307.ifs	2012-03-07	2012-03-08

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