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
2179474	2179474	EQUITY	CHANGE	03840M208	SPNSRD ADR NEW	D	0	2004-07-12	2016-04-26	0	no	no		no		2005-02-07	2016-04-26	?							20160427.ifs	2016-04-27	2016-04-28
2179475	2179474	EQUITY	CHANGE	03840M208	SPNSRD ADR NEW	D	0	2004-07-12	2016-04-26	0	no	no		no		2005-02-07	2016-04-27	?							20160427.ifs	2016-04-27	2016-04-28
2178542	2178542	CORPACTION	ADD	03840M208	66	D	2016-04-26			?															20160426.ifs	2016-04-26	2016-04-27
2178543	2178543	EQUITY	CHANGE	03840M208	SPNSRD ADR NEW	0	0	2004-07-12	?	0	no	no		no		2005-02-07	2004-07-12	?							20160426.ifs	2016-04-26	2016-04-27
2178544	2178543	EQUITY	CHANGE	03840M208	SPNSRD ADR NEW	D	0	2004-07-12	2016-04-26	0	no	no		no		2005-02-07	2016-04-26	?							20160426.ifs	2016-04-26	2016-04-27
1987895	1987895	DIVIDEND	CHANGE	03840M208		0	0	1	9	.4081		03	2014-05-20	2014-05-22	2014-05-28	2014-05-14		0	2014-05-14	?	0	0004782317			20151007.ifs	2015-10-07	2015-10-08
1987896	1987895	DIVIDEND	CHANGE	03840M208		0	0	1	9	.4081		03	2014-05-20	2014-05-22	2014-05-28	2014-05-14		1	2014-05-14	2015-10-07	0	0004782317			20151007.ifs	2015-10-07	2015-10-08
956182	956182	DIVIDEND	ADD	03840M208		0	0	E	0	0		58	?	?	2012-10-06	2012-09-13		0	2012-09-13	?	0	0004428719			20120913.ifs	2012-09-13	2012-09-14
833201	833201	DIVIDEND	ADD	03840M208		0	0	E	0	0		58	?	?	2012-04-06	2012-04-10		0	2012-04-10	?	0	0004360689			20120410.ifs	2012-04-10	2012-04-11
668562	668562	DIVIDEND	DELETE	03840M208		B	0	1	0	.0521		02	2011-09-06	2011-09-08	2011-10-07	2011-08-15		2	2011-08-15	2011-09-30	0	0004229634			20111005.ifs	2011-10-05	2011-10-06
668563	668563	DIVIDEND	ADD	03840M208		6	0	1	0	.063		05	2011-09-06	2011-09-08	2011-10-07	2011-08-15		3	2011-08-15	2011-10-05	0	0004229634			20111005.ifs	2011-10-05	2011-10-06
661110	661110	DIVIDEND	DELETE	03840M208		6	0	1	5	.07		26	2011-09-06	2011-09-08	?	2011-08-15		1	2011-08-15	2011-08-16	0	0004229634			20110930.ifs	2011-09-30	2011-10-01
661111	661111	DIVIDEND	ADD	03840M208		B	0	1	0	.0521		02	2011-09-06	2011-09-08	2011-10-07	2011-08-15		2	2011-08-15	2011-09-30	0	0004229634			20110930.ifs	2011-09-30	2011-10-01
619766	619766	DIVIDEND	ADD	03840M208		6	0	1	5	.07		26	?	2011-09-08	?	2011-08-15		0	2011-08-15	?	0	0004229634			20110815.ifs	2011-08-15	2011-08-16
483847	483847	DIVIDEND	DELETE	03840M208		6	0	1	5	.07		26	2011-03-01	2011-03-03	?	2011-02-17		1	2011-02-17	2011-02-18	0	0004147760			20110329.ifs	2011-03-29	2011-03-30
483848	483848	DIVIDEND	ADD	03840M208		6	0	1	0	.0711		05	2011-03-01	2011-03-03	2011-04-01	2011-02-17		2	2011-02-17	2011-03-29	0	0004147760			20110329.ifs	2011-03-29	2011-03-30
446127	446127	DIVIDEND	DELETE	03840M208		6	0	1	5	.07		26	?	2011-03-03	?	2011-02-17		0	2011-02-17	?	0	0004147760			20110218.ifs	2011-02-18	2011-02-19
446128	446128	DIVIDEND	ADD	03840M208		6	0	1	5	.07		26	2011-03-01	2011-03-03	?	2011-02-17		1	2011-02-17	2011-02-18	0	0004147760			20110218.ifs	2011-02-18	2011-02-19
444947	444947	DIVIDEND	ADD	03840M208		6	0	1	5	.07		26	?	2011-03-03	?	2011-02-17		0	2011-02-17	?	0	0004147760			20110217.ifs	2011-02-17	2011-02-18
328607	328607	DIVIDEND	DELETE	03840M208	No Ex-Date set by NBB.	6	0	1	5	.0803	0	26	?	2010-09-09	?	2010-08-30		0	2010-08-30	2010-09-10	0	0004051083			20101004.ifs	2010-10-04	2010-10-05
328608	328608	DIVIDEND	ADD	03840M208	No Ex-Date set by NBB.	6	0	1	0	.0738	0	05	?	2010-09-09	2010-10-08	2010-08-30		1	2010-08-30	2010-10-04	0	0004051083			20101004.ifs	2010-10-04	2010-10-05
291312	291312	DIVIDEND	ADD	03840M208		6	0	1	5	.0803		26	?	2010-09-09	?	2010-08-30		0	2010-08-30	?	0	0004051083			20100830.ifs	2010-08-30	2010-08-31
143369	143369	DIVIDEND	DELETE	03840M208		6	0	1	5	.035		26	2010-03-02	2010-03-04	?	2010-02-19		1	2010-02-19	2010-02-22	0	0003966778			20100329.ifs	2010-03-29	2010-04-07
143370	143370	DIVIDEND	ADD	03840M208		6	0	1	0	.0356		05	2010-03-02	2010-03-04	2010-04-05	2010-02-19		2	2010-02-19	2010-03-29	0	0003966778			20100329.ifs	2010-03-29	2010-04-07
114644	114644	DIVIDEND	DELETE	03840M208		6	0	1	5	.035		26	?	2010-03-04	?	2010-02-19		0	2010-02-19	?	0	0003966778			20100222.ifs	2010-02-22	2010-04-07
114645	114645	DIVIDEND	ADD	03840M208		6	0	1	5	.035		26	2010-03-02	2010-03-04	?	2010-02-19		1	2010-02-19	2010-02-22	0	0003966778			20100222.ifs	2010-02-22	2010-04-07
113606	113606	DIVIDEND	ADD	03840M208		6	0	1	5	.035		26	?	2010-03-04	?	2010-02-19		0	2010-02-19	?	0	0003966778			20100219.ifs	2010-02-19	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 = 145473
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