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
3039055	3039055	EXCHANGE	CHANGE	080903206	66	2014-03-26	2018-04-12	BLVDF	0	0	?	2014-04-24													20180416.ifs	2018-04-16	2018-04-17
3039056	3039055	EXCHANGE	CHANGE	080903206	66	2014-03-26	2018-04-13	BLVDF	0	0	?	2018-04-16													20180416.ifs	2018-04-16	2018-04-17
3039066	3039066	EXCHANGE	CHANGE	080903206	66	2014-03-26	2018-04-12	BLVDF	0	0	?	2014-04-24													20180416.ifs	2018-04-16	2018-04-17
3039067	3039067	CORPACTION	ADD	080903206	66	Q	2018-04-16	080903305	66	2018-04-16															20180416.ifs	2018-04-16	2018-04-17
3039068	3039067	EXCHANGE	CHANGE	080903206	66	2014-03-26	2018-04-13	BLVDF	0	0	?	2018-04-16													20180416.ifs	2018-04-16	2018-04-17
3039069	3039069	EQUITY	CHANGE	080903206	COM NEW	0	0	2014-03-26	?	0	no	no		no		?	2014-03-26	?							20180416.ifs	2018-04-16	2018-04-17
3039071	3039070	EQUITY	CHANGE	080903206	COM NEW	Q	0	2014-03-26	2018-04-16	0	no	no	080903305	no		?	2018-04-16	?							20180416.ifs	2018-04-16	2018-04-17
3039073	3039073	SPLIT	DELETE	080903206	3	2018-04-16	54	2018-04-12	?																20180416.ifs	2018-04-16	2018-04-17
3039077	3039077	DIVIDEND	DELETE	080903206		0	0	6	0	.333333	0	54	2018-04-16	2018-04-16	2018-04-16	2018-04-16		0	?	2018-04-13	0	0005646911			20180416.ifs	2018-04-16	2018-04-17
3039078	3039078	CORPACTION	ADD	080903206	66	Q	2018-04-16	080903305	66	2018-04-16															20180416.ifs	2018-04-16	2018-04-17
3039080	3039080	EQUITY	CHANGE	080903206	COM NEW	0	0	2014-03-26	?	0	no	no		no		?	2014-03-26	?							20180416.ifs	2018-04-16	2018-04-17
3039081	3039080	EQUITY	CHANGE	080903206	COM NEW	Q	0	2014-03-26	2018-04-16	0	no	no	080903305	no		?	2018-04-16	?							20180416.ifs	2018-04-16	2018-04-17
3039083	3039083	SPLIT	DELETE	080903206	3	2018-04-16	54	2018-04-12	?																20180416.ifs	2018-04-16	2018-04-17
3039088	3039088	DIVIDEND	DELETE	080903206		0	0	6	0	.333333	0	54	2018-04-16	2018-04-16	2018-04-16	2018-04-16		0	?	2018-04-13	0	0005646911			20180416.ifs	2018-04-16	2018-04-17
3038283	3038283	DIVIDEND	DELETE	080903206		0	0	6	0	.333333		54	2018-04-16	2018-04-16	2018-04-16	2018-04-12		0	2018-04-12	?	0	0005646911			20180413.ifs	2018-04-13	2018-04-14
3038284	3038284	DIVIDEND	ADD	080903206		0	0	6	0	.333333	0	54	2018-04-16	2018-04-16	2018-04-16	2018-04-16		0	?	2018-04-13	0	0005646911			20180413.ifs	2018-04-13	2018-04-14
3038078	3038078	DIVIDEND	ADD	080903206		0	0	6	0	.333333		54	2018-04-16	2018-04-16	2018-04-16	2018-04-12		0	2018-04-12	?	0	0005646911			20180412.ifs	2018-04-12	2018-04-13
3038080	3038080	SPLIT	ADD	080903206	3	2018-04-16	54	2018-04-12	?																20180412.ifs	2018-04-12	2018-04-13
3038087	3038087	DIVIDEND	ADD	080903206		0	0	6	0	.333333		54	2018-04-16	2018-04-16	2018-04-16	2018-04-12		0	2018-04-12	?	0	0005646911			20180412.ifs	2018-04-12	2018-04-13
3038089	3038089	SPLIT	ADD	080903206	3	2018-04-16	54	2018-04-12	?																20180412.ifs	2018-04-12	2018-04-13
1501143	1501143	CORPACTION	ADD	080903206	66	#	2014-04-24	080903206	66	?															20140424.ifs	2014-04-24	2014-04-25
1501144	1501144	CORPACTIONAUX	ADD	080903206	66	2014-04-24	BLVDD	BELVEDERE RES LTD	COM NEW	BLVDF	BELVEDERE RES LTD	COM NEW	2014-04-24	?											20140424.ifs	2014-04-24	2014-04-25
1501145	1501145	EXCHANGE	CHANGE	080903206	66	2014-03-26	2014-04-08	BLVDD	0	0	?	2014-03-26													20140424.ifs	2014-04-24	2014-04-25
1501146	1501145	EXCHANGE	CHANGE	080903206	66	2014-03-26	2014-04-08	BLVDF	0	0	?	2014-04-24													20140424.ifs	2014-04-24	2014-04-25
1501184	1501184	EXCHANGE	CHANGE	080903206	66	2014-03-26	2014-04-08	BLVDF	0	0	?	2014-04-24													20140424.ifs	2014-04-24	2014-04-25
1501185	1501184	EXCHANGE	CHANGE	080903206	66	2014-03-26	2014-04-23	BLVDF	0	0	?	2014-04-24													20140424.ifs	2014-04-24	2014-04-25
1476357	1476357	EQUITY	ADD	080903206	NEW ISSUE	0	0	2014-03-26	?	0	no	no		no		?	?	?							20140326.ifs	2014-03-26	2014-03-27
1476358	1476358	EQUITY	CHANGE	080903206	NEW ISSUE	0	0	2014-03-26	?	0	no	no		no		?	?	?							20140326.ifs	2014-03-26	2014-03-27
1476359	1476358	EQUITY	CHANGE	080903206	COM NEW	N	0	2014-03-26	?	0	no	no		no		?	2014-03-26	?							20140326.ifs	2014-03-26	2014-03-27
1476360	1476360	EXCHANGE	ADD	080903206	66	2014-03-26	?	BLVDD	0	0	?	2014-03-26													20140326.ifs	2014-03-26	2014-03-27
1476365	1476365	SPLIT	ADD	080903206	9	2014-03-26	54	2014-03-25	2014-03-26																20140326.ifs	2014-03-26	2014-03-27
1476367	1476367	DIVIDEND	ADD	080903206		0	0	6	0	.111111	0	54	2014-03-26	2014-03-26	2014-03-26	2014-03-26		0	?	2014-03-26	0	0004755047			20140326.ifs	2014-03-26	2014-03-27
1477183	1477183	EQUITY	CHANGE	080903206	COM NEW	N	0	2014-03-26	?	0	no	no		no		?	2014-03-26	?							20140326.ifs	2014-03-26	2014-03-27
1477184	1477183	EQUITY	CHANGE	080903206	COM NEW	0	0	2014-03-26	?	0	no	no		no		?	2014-03-26	?							20140326.ifs	2014-03-26	2014-03-27

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