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
918238	918238	CORPACTION	ADD	472100106	65	X	2012-07-23	472100106	66	?															20120723.ifs	2012-07-23	2012-07-24
918239	918239	EXCHANGE	ADD	472100106	66	2012-07-23	2011-03-14	JYHW	0	0	2012-07-23	?													20120723.ifs	2012-07-23	2012-07-24
781217	781217	CORPACTION	ADD	472100106	65	#	2012-02-17	472100106	65	?															20120217.ifs	2012-02-17	2012-02-18
781218	781218	CORPACTIONAUX	ADD	472100106	65	2012-02-17	JYHWE	JAYHAWK ENERGY INC	COM	JYHW	JAYHAWK ENERGY INC	COM	2012-02-17	?											20120217.ifs	2012-02-17	2012-02-18
781219	781219	EXCHANGE	CHANGE	472100106	65	2007-06-25	2011-02-22	JYHWE	0	0	2007-06-25	2012-01-19													20120217.ifs	2012-02-17	2012-02-18
781220	781219	EXCHANGE	CHANGE	472100106	65	2007-06-25	2011-02-22	JYHW	0	0	2007-06-25	2012-02-17													20120217.ifs	2012-02-17	2012-02-18
781221	781221	EXCHANGE	CHANGE	472100106	65	2011-03-15	2012-02-16	JYHWE	0	0	2011-03-15	2012-01-19													20120217.ifs	2012-02-17	2012-02-18
781222	781221	EXCHANGE	CHANGE	472100106	65	2011-03-15	2012-02-16	JYHW	0	0	2011-03-15	2012-02-17													20120217.ifs	2012-02-17	2012-02-18
758817	758817	CORPACTION	ADD	472100106	65	#	2012-01-19	472100106	65	?															20120119.ifs	2012-01-19	2012-01-20
758818	758818	CORPACTIONAUX	ADD	472100106	65	2012-01-19	JYHW	JAYHAWK ENERGY INC	COM	JYHWE	JAYHAWK ENERGY INC	COM	2012-01-19	?											20120119.ifs	2012-01-19	2012-01-20
758819	758819	EXCHANGE	CHANGE	472100106	65	2007-06-25	2011-02-22	JYHW	0	0	2007-06-25	?													20120119.ifs	2012-01-19	2012-01-20
758820	758819	EXCHANGE	CHANGE	472100106	65	2007-06-25	2011-02-22	JYHWE	0	0	2007-06-25	2012-01-19													20120119.ifs	2012-01-19	2012-01-20
758821	758821	EXCHANGE	CHANGE	472100106	65	2011-03-15	2012-01-18	JYHW	0	0	2011-03-15	?													20120119.ifs	2012-01-19	2012-01-20
758822	758821	EXCHANGE	CHANGE	472100106	65	2011-03-15	2012-01-18	JYHWE	0	0	2011-03-15	2012-01-19													20120119.ifs	2012-01-19	2012-01-20
471537	471537	CORPACTION	ADD	472100106	66	X	2011-03-15	472100106	65	?															20110315.ifs	2011-03-15	2011-03-16
471538	471538	EXCHANGE	ADD	472100106	65	2011-03-15	2011-03-15	JYHW	0	0	2011-03-15	?													20110315.ifs	2011-03-15	2011-03-16
449169	449169	CORPACTION	ADD	472100106	65	X	2011-02-23	472100106	66	?															20110223.ifs	2011-02-23	2011-02-24
449170	449170	EXCHANGE	ADD	472100106	66	2011-02-23	?	JYHW	0	0	2011-02-23	?													20110223.ifs	2011-02-23	2011-02-24

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