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
2257519	2257519	DIVIDEND	DELETE	158520106		0	0	6	0	.005		54	2016-07-27	2016-07-27	2016-07-27	2016-07-26		0	2016-07-26	?	0	0005254130			20160727.ifs	2016-07-27	2016-07-28
2257520	2257520	DIVIDEND	ADD	158520106		0	0	6	0	.005	0	54	2016-07-27	2016-07-27	2016-07-27	2016-07-27		0	?	2016-07-27	0	0005254130			20160727.ifs	2016-07-27	2016-07-28
2257527	2257527	CORPACTION	ADD	158520106	66	Q	2016-07-27	158520205	66	2016-07-27															20160727.ifs	2016-07-27	2016-07-28
2257528	2257528	EQUITY	CHANGE	158520106	COM	0	0	1993-01-21	?	4	yes	no		no		1996-12-18	2012-06-12	?							20160727.ifs	2016-07-27	2016-07-28
2257529	2257528	EQUITY	CHANGE	158520106	COM	Q	0	1993-01-21	2016-07-27	4	yes	no	158520205	no		1996-12-18	2016-07-27	?							20160727.ifs	2016-07-27	2016-07-28
2257530	2257530	SPLIT	DELETE	158520106	200	2016-07-27	54	2016-07-26	?																20160727.ifs	2016-07-27	2016-07-28
2257532	2257532	DIVIDEND	DELETE	158520106		0	0	6	0	.005	0	54	2016-07-27	2016-07-27	2016-07-27	2016-07-27		0	?	2016-07-27	0	0005254130			20160727.ifs	2016-07-27	2016-07-28
2257352	2257352	DIVIDEND	ADD	158520106		0	0	6	0	.005		54	2016-07-27	2016-07-27	2016-07-27	2016-07-26		0	2016-07-26	?	0	0005254130			20160726.ifs	2016-07-26	2016-07-27
2257353	2257353	SPLIT	ADD	158520106	200	2016-07-27	54	2016-07-26	?																20160726.ifs	2016-07-26	2016-07-27
912487	912487	CORPACTION	ADD	158520106	60	X	2012-07-16	158520106	66	?															20120716.ifs	2012-07-16	2012-07-17
912488	912488	EXCHANGE	ADD	158520106	66	2012-07-16	2012-07-16	CHMP	0	0	2012-07-16	?													20120716.ifs	2012-07-16	2012-07-17
883430	883430	EQUITY	CHANGE	158520106	COM	0	0	1993-01-21	?	4	yes	no		yes		1996-12-18	?	?							20120612.ifs	2012-06-12	2012-06-13
883431	883430	EQUITY	CHANGE	158520106	COM	0	0	1993-01-21	?	4	yes	no		no		1996-12-18	2012-06-12	?							20120612.ifs	2012-06-12	2012-06-13

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