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
1554506	1554506	DIVIDEND	DELETE	034919100		0	0	6	0	.2		54	2014-06-20	2014-06-20	2014-06-20	2014-06-19		0	2014-06-19	?	0	0004798526			20140620.ifs	2014-06-20	2014-06-21
1554507	1554507	DIVIDEND	ADD	034919100		0	0	6	0	.2	0	54	2014-06-20	2014-06-20	2014-06-20	2014-06-20		0	?	2014-06-20	0	0004798526			20140620.ifs	2014-06-20	2014-06-21
1554513	1554513	CORPACTION	ADD	034919100	66	Q	2014-06-20	40281L109	66	2014-06-20															20140620.ifs	2014-06-20	2014-06-21
1554514	1554514	EQUITY	CHANGE	034919100	COM	0	0	1997-12-09	?	0	no	no		no		1997-12-10	1997-12-10	?							20140620.ifs	2014-06-20	2014-06-21
1554515	1554514	EQUITY	CHANGE	034919100	COM	Q	0	1997-12-09	2014-06-20	0	no	no	40281L109	no		1997-12-10	2014-06-20	?							20140620.ifs	2014-06-20	2014-06-21
1554516	1554516	SPLIT	DELETE	034919100	5	2014-06-20	54	2014-06-19	?																20140620.ifs	2014-06-20	2014-06-21
1554518	1554518	DIVIDEND	DELETE	034919100		0	0	6	0	.2	0	54	2014-06-20	2014-06-20	2014-06-20	2014-06-20		0	?	2014-06-20	0	0004798526			20140620.ifs	2014-06-20	2014-06-21
1554146	1554146	DIVIDEND	ADD	034919100		0	0	6	0	.2		54	2014-06-20	2014-06-20	2014-06-20	2014-06-19		0	2014-06-19	?	0	0004798526			20140619.ifs	2014-06-19	2014-06-20
1554147	1554147	SPLIT	ADD	034919100	5	2014-06-20	54	2014-06-19	?																20140619.ifs	2014-06-19	2014-06-20
463635	463635	CORPACTION	ADD	034919100	65	X	2011-03-03	034919100	66	?															20110303.ifs	2011-03-03	2011-03-04
463636	463636	EXCHANGE	ADD	034919100	66	2011-03-03	2011-03-03	ASWRF	0	0	2011-03-03	?													20110303.ifs	2011-03-03	2011-03-04

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