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
2061677	2061677	CORPACTION	ADD	031498207	66	A	2015-12-23			?															20151223.ifs	2015-12-23	2015-12-24
2061678	2061678	EQUITY	CHANGE	031498207	COM NEW	0	0	2003-01-13	?	0	no	no		no		2003-05-22	2015-12-22	?							20151223.ifs	2015-12-23	2015-12-24
2061679	2061678	EQUITY	CHANGE	031498207	COM NEW	A	0	2003-01-13	2015-12-23	0	no	no		no		2003-05-22	2015-12-23	?							20151223.ifs	2015-12-23	2015-12-24
2061850	2061850	EXCHANGE	CHANGE	031498207	66	2004-04-23	2015-12-14	ACCKF	0	0	2004-12-17	?													20151223.ifs	2015-12-23	2015-12-24
2061851	2061850	EXCHANGE	CHANGE	031498207	66	2004-04-23	2015-12-22	ACCKF	0	0	2004-12-17	2015-12-23													20151223.ifs	2015-12-23	2015-12-24
2058232	2058232	EQUITY	CHANGE	031498207	COM NEW	0	0	2003-01-13	?	0	no	no		no		2003-05-22	2003-01-13	?							20151222.ifs	2015-12-22	2015-12-23
2058233	2058232	EQUITY	CHANGE	031498207	COM NEW	A	0	2003-01-13	2015-12-22	0	no	no		no		2003-05-22	2015-12-22	?							20151222.ifs	2015-12-22	2015-12-23
2058300	2058300	EQUITY	CHANGE	031498207	COM NEW	A	0	2003-01-13	2015-12-22	0	no	no		no		2003-05-22	2015-12-22	?							20151222.ifs	2015-12-22	2015-12-23
2058301	2058300	EQUITY	CHANGE	031498207	COM NEW	0	0	2003-01-13	?	0	no	no		no		2003-05-22	2015-12-22	?							20151222.ifs	2015-12-22	2015-12-23
1957355	1957355	DIVIDEND	ADD	031498207		A	0	2	0	.105		15	2015-09-08	2015-09-10	2015-09-17	2015-08-28		0	2015-09-01	?	0	0005055559			20150901.ifs	2015-09-01	2015-09-02
1838048	1838048	DIVIDEND	ADD	031498207		A	0	2	0	.105		15	2015-05-27	2015-05-29	2015-06-15	2015-04-09		0	2015-04-09	?	0	0004985256			20150409.ifs	2015-04-09	2015-04-10
1768810	1768810	DIVIDEND	ADD	031498207		A	0	2	0	.105		15	2015-02-25	2015-02-27	2015-03-13	2015-01-14		0	2015-01-14	?	0	0004941484			20150114.ifs	2015-01-14	2015-01-15
1681712	1681712	DIVIDEND	CHANGE	031498207		A	0	2	0	.105		15	2014-11-26	2014-11-28	2014-12-15	2014-10-14		1	2014-10-14	2014-11-14	0	0004859540			20141117.ifs	2014-11-17	2014-11-18
1681713	1681712	DIVIDEND	CHANGE	031498207	NBB ex-date: 11-26-2014.	A	0	2	0	.105	0	15	2014-11-26	2014-11-28	2014-12-15	2014-10-14		1	2014-10-14	2014-11-17	0	0004859540			20141117.ifs	2014-11-17	2014-11-18
1681467	1681467	DIVIDEND	DELETE	031498207		A	0	2	0	.105		15	2014-11-25	2014-11-28	2014-12-15	2014-10-14		0	2014-10-14	?	0	0004859540			20141114.ifs	2014-11-14	2014-11-15
1681468	1681468	DIVIDEND	ADD	031498207		A	0	2	0	.105		15	2014-11-26	2014-11-28	2014-12-15	2014-10-14		1	2014-10-14	2014-11-14	0	0004859540			20141114.ifs	2014-11-14	2014-11-15
1657156	1657156	DIVIDEND	ADD	031498207		A	0	2	0	.105		15	2014-11-25	2014-11-28	2014-12-15	2014-10-14		0	2014-10-14	?	0	0004859540			20141014.ifs	2014-10-14	2014-10-15
1608698	1608698	DIVIDEND	ADD	031498207		A	0	2	0	.105		15	2014-08-27	2014-08-29	2014-09-15	2014-08-18		0	2014-08-18	?	0	0004829676			20140818.ifs	2014-08-18	2014-08-19
1495717	1495717	DIVIDEND	ADD	031498207		A	0	2	0	.105		15	2014-05-28	2014-05-30	2014-06-13	2014-04-14		0	2014-04-14	?	0	0004768051			20140414.ifs	2014-04-14	2014-04-15
1421713	1421713	DIVIDEND	ADD	031498207		A	0	2	0	.105		15	2014-02-26	2014-02-28	2014-03-14	2014-01-13		0	2014-01-13	?	0	0004723715			20140113.ifs	2014-01-13	2014-01-14
1321027	1321027	DIVIDEND	DELETE	031498207		A	0	2	0	.105		15	2013-11-26	2013-11-29	2013-12-13	2013-10-15		0	2013-10-15	?	0	0004645273			20131022.ifs	2013-10-22	2013-10-23
1321028	1321028	DIVIDEND	ADD	031498207		A	0	2	0	.105		15	2013-11-27	2013-11-29	2013-12-13	2013-10-15		1	2013-10-15	2013-10-22	0	0004645273			20131022.ifs	2013-10-22	2013-10-23
1316557	1316557	DIVIDEND	ADD	031498207		A	0	2	0	.105		15	2013-11-26	2013-11-29	2013-12-13	2013-10-15		0	2013-10-15	?	0	0004645273			20131015.ifs	2013-10-15	2013-10-16
1263097	1263097	DIVIDEND	ADD	031498207		A	0	2	0	.105		15	2013-08-28	2013-08-30	2013-09-13	2013-08-12		0	2013-08-12	?	0	0004614951			20130812.ifs	2013-08-12	2013-08-13
1157495	1157495	DIVIDEND	ADD	031498207		A	0	2	0	.105		15	2013-05-29	2013-05-31	2013-06-14	2013-04-09		0	2013-04-09	?	0	0004557037			20130409.ifs	2013-04-09	2013-04-10
1090891	1090891	DIVIDEND	ADD	031498207		A	0	2	0	.105		15	2013-02-26	2013-02-28	2013-03-15	2013-01-15		0	2013-01-15	?	0	0004515330			20130115.ifs	2013-01-15	2013-01-16
986202	986202	DIVIDEND	ADD	031498207		A	0	2	0	.105		15	2012-11-28	2012-11-30	2012-12-14	2012-10-15		0	2012-10-15	?	0	0004445433			20121015.ifs	2012-10-15	2012-10-16
932342	932342	DIVIDEND	ADD	031498207		A	0	2	0	.105		15	2012-08-29	2012-08-31	2012-09-14	2012-08-13		0	2012-08-13	?	0	0004415494			20120813.ifs	2012-08-13	2012-08-14
834367	834367	DIVIDEND	ADD	031498207		A	0	2	0	.105		15	2012-05-29	2012-05-31	2012-06-15	2012-04-12		0	2012-04-12	?	0	0004361068			20120412.ifs	2012-04-12	2012-04-13
757708	757708	DIVIDEND	ADD	031498207		A	0	2	0	.105		15	2012-02-27	2012-02-29	2012-03-15	2012-01-16		0	2012-01-17	?	0	0004320935			20120117.ifs	2012-01-17	2012-01-18
694453	694453	DIVIDEND	ADD	031498207		A	0	2	0	.095		15	2011-11-28	2011-11-30	2011-12-15	2011-11-14		0	2011-11-14	?	0	0004269627			20111114.ifs	2011-11-14	2011-11-15
619768	619768	DIVIDEND	ADD	031498207		A	0	2	0	.095		15	2011-08-29	2011-08-31	2011-09-15	2011-08-15		0	2011-08-15	?	0	0004229494			20110815.ifs	2011-08-15	2011-08-16
501665	501665	DIVIDEND	DELETE	031498207		A	0	2	0	.085		15	2011-05-27	2011-05-31	2011-06-15	2011-04-13		0	2011-04-13	?	0	0004175058			20110414.ifs	2011-04-14	2011-04-15
501666	501666	DIVIDEND	ADD	031498207	TSX ex-date: 5-27-2011	A	0	2	0	.085	0	15	2011-05-26	2011-05-31	2011-06-15	2011-04-13		0	?	2011-04-14	0	0004175058			20110414.ifs	2011-04-14	2011-04-15
501521	501521	DIVIDEND	ADD	031498207		A	0	2	0	.085		15	2011-05-27	2011-05-31	2011-06-15	2011-04-13		0	2011-04-13	?	0	0004175058			20110413.ifs	2011-04-13	2011-04-14
417901	417901	DIVIDEND	ADD	031498207		A	0	2	0	.085		15	2011-02-24	2011-02-28	2011-03-15	2011-01-12		0	2011-01-12	?	0	0004134357			20110112.ifs	2011-01-12	2011-01-13
333686	333686	DIVIDEND	ADD	031498207		A	0	2	0	.07		15	2010-11-26	2010-11-30	2010-12-15	2010-10-12		0	2010-10-12	?	0	0004074399			20101012.ifs	2010-10-12	2010-10-13
278281	278281	DIVIDEND	ADD	031498207		A	0	2	0	.06		15	2010-08-27	2010-08-31	2010-09-15	2010-08-11		0	2010-08-12	?	0	0004046714			20100812.ifs	2010-08-12	2010-08-13
159372	159372	DIVIDEND	DELETE	031498207	NBB ex-date: 5-26-2010	A	0	2	0	.06	0	15	2010-05-27	2010-05-31	2010-06-15	2010-04-13		0	2010-04-14	2010-04-15	0	0003993106			20100415.ifs	2010-04-15	2010-04-16
159373	159373	DIVIDEND	ADD	031498207	TSX ex-date: 5-27-2010.	A	0	2	0	.06	0	15	2010-05-26	2010-05-31	2010-06-15	2010-04-13		0	?	2010-04-15	0	0003993106			20100415.ifs	2010-04-15	2010-04-16
159306	159306	DIVIDEND	ADD	031498207		A	0	2	0	.06		15	2010-05-27	2010-05-31	2010-06-15	2010-04-13		0	2010-04-14	?	0	0003993106			20100414.ifs	2010-04-14	2010-04-15
87159	87159	DIVIDEND	ADD	031498207		A	0	2	0	.06		15	2010-02-24	2010-02-26	2010-03-15	2010-01-12		0	2010-01-12	?	0	0003953293			20100112.ifs	2010-01-12	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 = 145362
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