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
5012963	5012963	EQUITY	CHANGE	03240P108	COM	Q	0	2007-04-18	2018-01-22	0	no	no	03240P207	no		2007-04-18	2018-01-22	?							20220517.ifs	2022-05-17	2022-05-18
5012964	5012963	EQUITY	CHANGE	03240P108	COM	Q	0	2007-04-18	2022-05-17	0	no	no	03240P207	no		2007-04-18	2022-05-17	?							20220517.ifs	2022-05-17	2022-05-18
5012965	5012965	CORPACTION	ADD	03240P108	66	Q	2022-05-17	82664T101	66	?															20220517.ifs	2022-05-17	2022-05-18
5012966	5012966	EQUITY	CHANGE	03240P108	COM	Q	0	2007-04-18	2022-05-17	0	no	no	03240P207	no		2007-04-18	2022-05-17	?							20220517.ifs	2022-05-17	2022-05-18
5012967	5012966	EQUITY	CHANGE	03240P108	COM	Q	0	2007-04-18	2022-05-17	0	no	no	82664T101	no		2007-04-18	2022-05-17	?							20220517.ifs	2022-05-17	2022-05-18
2923630	2923630	CORPACTION	ADD	03240P108	66	Q	2018-01-22	03240P207	66	2018-01-22															20180122.ifs	2018-01-22	2018-01-23
2923632	2923632	EQUITY	CHANGE	03240P108	COM	0	0	2007-04-18	?	0	no	no		no		2007-04-18	2012-05-31	?							20180122.ifs	2018-01-22	2018-01-23
2923634	2923633	EQUITY	CHANGE	03240P108	COM	Q	0	2007-04-18	2018-01-22	0	no	no	03240P207	no		2007-04-18	2018-01-22	?							20180122.ifs	2018-01-22	2018-01-23
2923636	2923636	SPLIT	DELETE	03240P108	4	2018-01-22	54	2018-01-18	?																20180122.ifs	2018-01-22	2018-01-23
2923640	2923640	DIVIDEND	DELETE	03240P108		0	0	6	0	.25	0	54	2018-01-22	2018-01-22	2018-01-22	2018-01-22		0	?	2018-01-19	0	0005602356			20180122.ifs	2018-01-22	2018-01-23
2923641	2923641	CORPACTION	ADD	03240P108	66	Q	2018-01-22	03240P207	66	2018-01-22															20180122.ifs	2018-01-22	2018-01-23
2923643	2923643	EQUITY	CHANGE	03240P108	COM	0	0	2007-04-18	?	0	no	no		no		2007-04-18	2012-05-31	?							20180122.ifs	2018-01-22	2018-01-23
2923645	2923644	EQUITY	CHANGE	03240P108	COM	Q	0	2007-04-18	2018-01-22	0	no	no	03240P207	no		2007-04-18	2018-01-22	?							20180122.ifs	2018-01-22	2018-01-23
2923648	2923648	SPLIT	DELETE	03240P108	4	2018-01-22	54	2018-01-18	?																20180122.ifs	2018-01-22	2018-01-23
2923652	2923652	DIVIDEND	DELETE	03240P108		0	0	6	0	.25	0	54	2018-01-22	2018-01-22	2018-01-22	2018-01-22		0	?	2018-01-19	0	0005602356			20180122.ifs	2018-01-22	2018-01-23
2921919	2921919	DIVIDEND	DELETE	03240P108		0	0	6	0	.25		54	2018-01-22	2018-01-22	2018-01-22	2018-01-18		0	2018-01-18	?	0	0005602356			20180119.ifs	2018-01-19	2018-01-20
2921920	2921920	DIVIDEND	DELETE	03240P108		0	0	6	0	.25		54	2018-01-22	2018-01-22	2018-01-22	2018-01-18		0	2018-01-18	?	0	0005602356			20180119.ifs	2018-01-19	2018-01-20
2921921	2921921	DIVIDEND	ADD	03240P108		0	0	6	0	.25	0	54	2018-01-22	2018-01-22	2018-01-22	2018-01-22		0	?	2018-01-19	0	0005602356			20180119.ifs	2018-01-19	2018-01-20
2921922	2921922	DIVIDEND	ADD	03240P108		0	0	6	0	.25	0	54	2018-01-22	2018-01-22	2018-01-22	2018-01-22		0	?	2018-01-19	0	0005602356			20180119.ifs	2018-01-19	2018-01-20
2921627	2921627	DIVIDEND	ADD	03240P108		0	0	6	0	.25		54	2018-01-22	2018-01-22	2018-01-22	2018-01-18		0	2018-01-18	?	0	0005602356			20180118.ifs	2018-01-18	2018-01-19
2921629	2921629	SPLIT	ADD	03240P108	4	2018-01-22	54	2018-01-18	?																20180118.ifs	2018-01-18	2018-01-19
2921632	2921632	DIVIDEND	ADD	03240P108		0	0	6	0	.25		54	2018-01-22	2018-01-22	2018-01-22	2018-01-18		0	2018-01-18	?	0	0005602356			20180118.ifs	2018-01-18	2018-01-19
2921634	2921634	SPLIT	ADD	03240P108	4	2018-01-22	54	2018-01-18	?																20180118.ifs	2018-01-18	2018-01-19
1152223	1152223	CORPACTION	DELETE	03240P108	66	D	2012-05-30			2012-05-30															20130402.ifs	2013-04-02	2013-04-03
867908	867908	EQUITY	CHANGE	03240P108	COM	D	0	2007-04-18	2012-05-30	0	no	no		no		2007-04-18	2012-05-30	?							20120531.ifs	2012-05-31	2012-06-01
867909	867908	EQUITY	CHANGE	03240P108	COM	0	0	2007-04-18	?	0	no	no		no		2007-04-18	2012-05-31	?							20120531.ifs	2012-05-31	2012-06-01
868390	868390	EXCHANGE	CHANGE	03240P108	66	2007-04-18	2012-05-29	ANXGF	0	0	2007-04-18	2012-05-30													20120531.ifs	2012-05-31	2012-06-01
868391	868390	EXCHANGE	CHANGE	03240P108	66	2007-04-18	2012-05-29	ANXGF	0	0	2007-04-18	2012-05-30													20120531.ifs	2012-05-31	2012-06-01
868853	868852	EXCHANGE	CHANGE	03240P108	66	D	2012-05-30			2012-05-30															20120531.ifs	2012-05-31	2012-06-01
868854	868853	EXCHANGE	CHANGE	03240P108	66	D	2012-05-30			2012-05-30															20120531.ifs	2012-05-31	2012-06-01

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