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
2631258	2631258	CORPACTION	ADD	74460W206	01	C	2017-07-26			?															20170726.ifs	2017-07-26	2017-07-27
2631259	2631259	EQUITY	CHANGE	74460W206	DEP SH REPSTG PFD SH BEN INT SER S	0	1	2012-01-09	?	4	no	no		no		2012-01-09	?	?							20170726.ifs	2017-07-26	2017-07-27
2631260	2631259	EQUITY	CHANGE	74460W206	DEP SH REPSTG PFD SH BEN INT SER S	C	1	2012-01-09	2017-07-26	4	no	no		no		2012-01-09	2017-07-26	?							20170726.ifs	2017-07-26	2017-07-27
2600520	2600520	DIVIDEND	ADD	74460W206		0	0	C	0	25		12	?	?	2017-07-26	2017-06-23		0	?	2017-06-26	0				20170626.ifs	2017-06-26	2017-06-27
2600060	2600060	DIVIDEND	ADD	74460W206		0	0	1	6	0		08	?	?	2017-07-26	2017-06-23		0	2017-06-23	?	0	0005454276			20170623.ifs	2017-06-23	2017-06-24
2548016	2548016	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2017-06-12	2017-06-14	2017-06-29	2017-04-26		0	2017-04-26	?	0	0005424444			20170426.ifs	2017-04-26	2017-04-27
2496416	2496416	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2017-03-13	2017-03-15	2017-03-30	2017-02-22		0	2017-02-27	?	0	0005391869			20170227.ifs	2017-02-27	2017-02-28
2444224	2444224	EQUITY	CHANGE	74460W206	DEP SH REPSTG PFD SH BEN INT SER S	0	1	2012-01-09	?	0	no	no		no		2012-01-09	?	?							20170123.ifs	2017-01-23	2017-01-24
2444225	2444224	EQUITY	CHANGE	74460W206	DEP SH REPSTG PFD SH BEN INT SER S	0	1	2012-01-09	?	4	no	no		no		2012-01-09	?	?							20170123.ifs	2017-01-23	2017-01-24
2341458	2341458	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2016-12-12	2016-12-14	2016-12-29	2016-10-26		0	2016-11-09	?	0	0005310513			20161109.ifs	2016-11-09	2016-11-10
2258972	2258972	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2016-09-12	2016-09-14	2016-09-29	2016-07-27		0	2016-07-28	?	0	0005255209			20160728.ifs	2016-07-28	2016-07-29
2179983	2179983	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2016-06-13	2016-06-15	2016-06-30	2016-04-26		0	2016-04-27	?	0	0005208798			20160427.ifs	2016-04-27	2016-04-28
2114012	2114012	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2016-03-14	2016-03-16	2016-03-31	2016-02-15		0	2016-02-17	?	0	0005173139			20160217.ifs	2016-02-17	2016-02-18
1999021	1999021	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2015-12-11	2015-12-15	2015-12-30	2015-10-28		0	2015-10-29	?	0	0005083267			20151029.ifs	2015-10-29	2015-10-30
1935615	1935615	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2015-09-11	2015-09-15	2015-09-30	2015-07-29		0	2015-08-04	?	0	0005045033			20150804.ifs	2015-08-04	2015-08-05
1851522	1851522	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2015-06-11	2015-06-15	2015-06-30	2015-04-29		0	2015-04-30	?	0	0004992033			20150430.ifs	2015-04-30	2015-05-01
1793114	1793114	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2015-03-12	2015-03-16	2015-03-31	2015-02-19		0	2015-02-20	?	0	0004956248			20150220.ifs	2015-02-20	2015-02-21
1676055	1676055	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2014-12-11	2014-12-15	2014-12-30	2014-10-30		0	2014-11-05	?	0	0004871107			20141105.ifs	2014-11-05	2014-11-06
1595442	1595442	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2014-09-11	2014-09-15	2014-09-30	2014-08-01		0	2014-08-01	?	0	0004824467			20140801.ifs	2014-08-01	2014-08-02
1516399	1516399	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2014-06-11	2014-06-13	2014-06-30	2014-05-01		0	2014-05-02	?	0	0004779782			20140502.ifs	2014-05-02	2014-05-03
1449236	1449236	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2014-03-12	2014-03-14	2014-03-31	2014-02-24		0	2014-02-25	?	0	0004739183			20140225.ifs	2014-02-25	2014-02-26
1330948	1330948	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2013-12-11	2013-12-13	2013-12-30	2013-10-31		0	2013-11-01	?	0	0004654371			20131101.ifs	2013-11-01	2013-11-02
1258590	1258590	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2013-09-11	2013-09-13	2013-09-30	2013-08-01		0	2013-08-02	?	0	0004613144			20130802.ifs	2013-08-02	2013-08-03
1186996	1186996	DIVIDEND	DELETE	74460W206		0	0	1	6	0		08	2013-06-10	2013-06-12	2013-06-27	2013-05-09		0	2013-05-09	?	0	0004570458			20130516.ifs	2013-05-16	2013-05-17
1186997	1186997	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2013-06-10	2013-06-12	2013-06-27	2013-05-09		1	2013-05-09	2013-05-16	0	0004570458			20130516.ifs	2013-05-16	2013-05-17
1183103	1183103	DIVIDEND	ADD	74460W206		0	0	1	6	0		08	2013-06-10	2013-06-12	2013-06-27	2013-05-09		0	2013-05-09	?	0	0004570458			20130509.ifs	2013-05-09	2013-05-10
1116427	1116427	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2013-03-11	2013-03-13	2013-03-28	2013-02-21		0	2013-02-22	?	0	0004530151			20130222.ifs	2013-02-22	2013-02-23
1017154	1017154	DIVIDEND	DELETE	74460W206		0	0	1	6	0		08	2012-12-10	2012-12-12	2012-12-27	2012-11-16		0	2012-11-16	?	0	0004458543			20121128.ifs	2012-11-28	2012-11-29
1017155	1017155	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2012-12-10	2012-12-12	2012-12-27	2012-11-08		1	2012-11-16	2012-11-28	0	0004458543			20121128.ifs	2012-11-28	2012-11-29
1011236	1011236	DIVIDEND	ADD	74460W206		0	0	1	6	0		08	2012-12-10	2012-12-12	2012-12-27	2012-11-16		0	2012-11-16	?	0	0004458543			20121116.ifs	2012-11-16	2012-11-17
926577	926577	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2012-09-10	2012-09-12	2012-09-27	2012-08-02		0	2012-08-06	?	0	0004414106			20120806.ifs	2012-08-06	2012-08-07
879122	879122	DIVIDEND	ADD	74460W206		0	0	1	0	.36875		00	2012-06-11	2012-06-13	2012-06-28	2012-05-03		0	2012-06-04	?	0	0004384587			20120604.ifs	2012-06-04	2012-06-05
856055	856055	DIVIDEND	CHANGE	74460W206		0	0	1	4	.327778		00	2012-03-12	2012-03-14	2012-03-29	2012-02-27		0	2012-02-29	2012-05-07	0	0004337670			20120507.ifs	2012-05-07	2012-05-08
856056	856055	DIVIDEND	CHANGE	74460W206		0	0	1	4	.327778		00	2012-03-12	2012-03-14	2012-03-29	2012-02-27		0	2012-02-29	2012-05-07	0	0004337670			20120507.ifs	2012-05-07	2012-05-08
788878	788878	DIVIDEND	ADD	74460W206		0	0	1	4	.327778		00	2012-03-12	2012-03-14	2012-03-29	2012-02-27		0	2012-02-29	?	0	0004337670			20120229.ifs	2012-02-29	2012-03-01
755075	755075	EXCHANGE	ADD	74460W206	01	2012-01-12	2012-01-12	PSA_PS	0	1	?	2012-01-12													20120112.ifs	2012-01-12	2012-01-13
755076	755076	CORPACTION	ADD	74460W206	66	X	2012-01-12	74460W206	01	2012-01-12															20120112.ifs	2012-01-12	2012-01-13
753386	753386	EQUITY	ADD	74460W206	DEP SH REPSTG PFD SH BEN INT SER S	N	1	2012-01-09	?	0	no	no		no		2012-01-09	?	?							20120109.ifs	2012-01-09	2012-01-10
753387	753387	EXCHANGE	ADD	74460W206	66	2012-01-09	2012-01-09	PSAY	0	1	2012-01-09	?													20120109.ifs	2012-01-09	2012-01-10
754223	754223	EQUITY	CHANGE	74460W206	DEP SH REPSTG PFD SH BEN INT SER S	N	1	2012-01-09	?	0	no	no		no		2012-01-09	?	?							20120109.ifs	2012-01-09	2012-01-10
754224	754223	EQUITY	CHANGE	74460W206	DEP SH REPSTG PFD SH BEN INT SER S	0	1	2012-01-09	?	0	no	no		no		2012-01-09	?	?							20120109.ifs	2012-01-09	2012-01-10

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