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
1863253	1863253	CORPACTION	ADD	299707307	66	D	2015-05-14			2015-05-14															20150514.ifs	2015-05-14	2015-05-15
1863254	1863254	EQUITY	CHANGE	299707307	COM PAR$.001	N	0	2012-07-06	?	0	no	no		no		2012-07-06	2012-07-24	?							20150514.ifs	2015-05-14	2015-05-15
1863255	1863254	EQUITY	CHANGE	299707307	COM PAR$.001	D	0	2012-07-06	2015-05-14	0	no	no		no		2012-07-06	2015-05-14	?							20150514.ifs	2015-05-14	2015-05-15
1863256	1863256	EXCHANGE	CHANGE	299707307	66	2012-07-23	2015-05-07	EVCA	0	0	2012-07-23	2012-08-02													20150514.ifs	2015-05-14	2015-05-15
1863257	1863256	EXCHANGE	CHANGE	299707307	66	2012-07-23	2015-05-13	EVCA	0	0	2012-07-23	2015-05-14													20150514.ifs	2015-05-14	2015-05-15
1786841	1786841	EXCHANGE	DELETE	299707307	65	2012-07-22	2012-07-20	EVCAD	0	0	2012-07-23	2012-07-23													20150205.ifs	2015-02-05	2015-02-06
1786842	1786842	EXCHANGE	ADD	299707307	65	2012-07-20	2012-07-20	EVCAD	0	0	?	2015-02-05													20150205.ifs	2015-02-05	2015-02-06
924217	924217	CORPACTION	ADD	299707307	66	#	2012-08-02	299707307	66	?															20120802.ifs	2012-08-02	2012-08-03
924218	924218	CORPACTIONAUX	ADD	299707307	66	2012-08-02	EVCAD	EVCARCO INC	COM PAR$.001	EVCA	EVCARCO INC	COM PAR$.001	2012-08-02	?											20120802.ifs	2012-08-02	2012-08-03
924219	924219	EXCHANGE	CHANGE	299707307	66	2012-07-23	2012-08-01	EVCAD	0	0	2012-07-23	?													20120802.ifs	2012-08-02	2012-08-03
924220	924219	EXCHANGE	CHANGE	299707307	66	2012-07-23	2012-08-01	EVCA	0	0	2012-07-23	2012-08-02													20120802.ifs	2012-08-02	2012-08-03
919296	919296	EQUITY	CHANGE	299707307	COM	N	0	2012-07-06	?	0	no	no		no		2012-07-06	?	?							20120724.ifs	2012-07-24	2012-07-25
919297	919296	EQUITY	CHANGE	299707307	COM PAR$.001	N	0	2012-07-06	?	0	no	no		no		2012-07-06	2012-07-24	?							20120724.ifs	2012-07-24	2012-07-25
917927	917927	EXCHANGE	ADD	299707307	65	2012-07-22	?	EVCAD	0	0	2012-07-23	?													20120723.ifs	2012-07-23	2012-07-24
917928	917928	CORPACTION	ADD	299707307	65	X	2012-07-23	299707307	66	?															20120723.ifs	2012-07-23	2012-07-24
917929	917929	EXCHANGE	ADD	299707307	66	2012-07-23	?	EVCAD	0	0	2012-07-23	?													20120723.ifs	2012-07-23	2012-07-24
917930	917930	EXCHANGE	CHANGE	299707307	65	2012-07-22	?	EVCAD	0	0	2012-07-23	?													20120723.ifs	2012-07-23	2012-07-24
917931	917930	EXCHANGE	CHANGE	299707307	65	2012-07-22	2012-07-20	EVCAD	0	0	2012-07-23	2012-07-23													20120723.ifs	2012-07-23	2012-07-24
909001	909001	EQUITY	ADD	299707307	COM	N	0	2012-07-06	?	0	no	no		no		2012-07-06	?	?							20120706.ifs	2012-07-06	2012-07-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 = 153487
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