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
2649089	2649089	CORPACTION	ADD	43785X108	66	A	2017-08-14			?															20170814.ifs	2017-08-14	2017-08-15
2649090	2649090	EQUITY	CHANGE	43785X108	COM	0	0	2007-06-29	?	0	no	no		no		2007-06-29	?	?							20170814.ifs	2017-08-14	2017-08-15
2649091	2649090	EQUITY	CHANGE	43785X108	COM	A	0	2007-06-29	2017-08-14	0	no	no		no		2007-06-29	2017-08-14	?							20170814.ifs	2017-08-14	2017-08-15
1015588	1015588	DIVIDEND	ADD	43785X108		0	0	E	0	0		58	?	?	2012-08-18	2012-11-26		0	2012-11-26	?	0	0004460904			20121126.ifs	2012-11-26	2012-11-27
840809	840809	DIVIDEND	ADD	43785X108		0	0	1	0	.02		00	2012-05-02	2012-05-04	2012-05-18	2012-04-20		0	2012-04-23	?	0	0004363335			20120423.ifs	2012-04-23	2012-04-24
771278	771278	DIVIDEND	ADD	43785X108		0	0	1	0	.02		00	2012-02-15	2012-02-17	2012-03-02	2012-01-19		0	2012-02-01	?	0	0004328669			20120201.ifs	2012-02-01	2012-02-02
676940	676940	DIVIDEND	ADD	43785X108		0	0	1	0	.02		00	2011-11-02	2011-11-04	2011-11-18	2011-10-21		0	2011-10-24	?	0	0004259682			20111024.ifs	2011-10-24	2011-10-25
624940	624940	CORPACTION	ADD	43785X108	65	X	2011-08-24	43785X108	66	?															20110824.ifs	2011-08-24	2011-08-25
624941	624941	EXCHANGE	ADD	43785X108	66	2011-08-24	2011-08-24	HTWC	0	0	2011-08-24	?													20110824.ifs	2011-08-24	2011-08-25
593152	593152	DIVIDEND	ADD	43785X108		0	0	1	0	.02		00	2011-08-03	2011-08-05	2011-08-19	2011-07-22		0	2011-07-26	?	0	0004219435			20110726.ifs	2011-07-26	2011-07-27
509113	509113	DIVIDEND	ADD	43785X108		0	0	1	0	.02		00	2011-05-04	2011-05-06	2011-05-20	2011-04-25		0	2011-04-26	?	0	0004177795			20110426.ifs	2011-04-26	2011-04-27
425138	425138	DIVIDEND	ADD	43785X108		0	0	1	0	.02		00	2011-02-02	2011-02-04	2011-02-18	2011-01-21		0	2011-01-25	?	0	0004136970			20110125.ifs	2011-01-25	2011-01-26
342862	342862	DIVIDEND	ADD	43785X108		0	0	1	0	.02		00	2010-11-03	2010-11-05	2010-11-19	2010-10-25		0	2010-10-27	?	0	0004077600			20101027.ifs	2010-10-27	2010-10-28
258843	258843	DIVIDEND	ADD	43785X108		0	0	1	0	.02		00	2010-08-04	2010-08-06	2010-08-20	2010-07-23		0	2010-07-23	?	0	0004036315			20100723.ifs	2010-07-23	2010-07-24
170165	170165	DIVIDEND	ADD	43785X108		0	0	1	0	.02		00	2010-05-05	2010-05-07	2010-05-21	2010-04-26		0	2010-04-28	?	0	0003996586			20100428.ifs	2010-04-28	2010-04-29
93518	93518	DIVIDEND	ADD	43785X108		0	0	1	0	.02		00	2010-02-03	2010-02-05	2010-02-19	2010-01-21		0	2010-01-25	?	0	0003955642			20100125.ifs	2010-01-25	2010-04-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 = 151575
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