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
2327368	2327368	CORPACTION	ADD	454670100	66	A	2016-10-27			?															20161027.ifs	2016-10-27	2016-10-28
2327369	2327369	EQUITY	CHANGE	454670100	COM	0	0	2006-06-08	?	0	no	no		no		2006-07-05	?	?							20161027.ifs	2016-10-27	2016-10-28
2327370	2327369	EQUITY	CHANGE	454670100	COM	A	0	2006-06-08	2016-10-27	0	no	no		no		2006-07-05	2016-10-27	?							20161027.ifs	2016-10-27	2016-10-28
1938427	1938427	DIVIDEND	ADD	454670100		0	0	E	0	0		58	?	?	2015-08-18	2015-08-07		0	2015-08-07	?	0	0005045990			20150807.ifs	2015-08-07	2015-08-08
1849054	1849054	DIVIDEND	ADD	454670100		0	0	1	0	.02		35	2015-05-06	2015-05-08	2015-05-18	2015-04-28		0	2015-04-28	?	0	0004989842			20150428.ifs	2015-04-28	2015-04-29
1776210	1776210	DIVIDEND	ADD	454670100		0	0	5	0	.05		10	2015-02-05	2015-02-09	2015-02-20	2015-01-22		0	2015-01-28	?	0	0004944493			20150128.ifs	2015-01-28	2015-01-29
1776211	1776211	SPLIT	ADD	454670100	.9523809524	2015-02-05	10	2015-01-28	?																20150128.ifs	2015-01-28	2015-01-29
1774027	1774027	DIVIDEND	ADD	454670100		0	0	1	0	.02		00	2015-02-05	2015-02-09	2015-02-20	2015-01-23		0	2015-01-23	?	0	0004943679			20150123.ifs	2015-01-23	2015-01-24
1663587	1663587	DIVIDEND	ADD	454670100		0	0	1	0	.02		00	2014-11-05	2014-11-07	2014-11-17	2014-10-23		0	2014-10-27	?	0	0004862304			20141027.ifs	2014-10-27	2014-10-28
1589732	1589732	DIVIDEND	ADD	454670100		0	0	1	0	.02		00	2014-08-06	2014-08-08	2014-08-18	2014-07-24		0	2014-07-30	?	0	0004818573			20140730.ifs	2014-07-30	2014-07-31
1504183	1504183	DIVIDEND	ADD	454670100		0	0	1	0	.02		35	2014-05-07	2014-05-09	2014-05-19	2014-04-24		0	2014-04-29	?	0	0004772124			20140429.ifs	2014-04-29	2014-04-30
1443488	1443488	DIVIDEND	ADD	454670100		0	0	5	0	.05		10	2014-02-26	2014-02-28	2014-03-10	2014-01-23		0	2014-02-13	?	0	0004736337			20140213.ifs	2014-02-13	2014-02-14
1443489	1443489	SPLIT	ADD	454670100	.9523809524	2014-02-26	10	2014-02-13	?																20140213.ifs	2014-02-13	2014-02-14
1436624	1436624	DIVIDEND	ADD	454670100		0	0	1	0	.06		00	2014-02-06	2014-02-10	2014-02-18	2014-01-23		0	2014-02-03	?	0	0004733323			20140203.ifs	2014-02-03	2014-02-04
449026	449026	CORPACTION	ADD	454670100	65	X	2011-02-23	454670100	66	?															20110223.ifs	2011-02-23	2011-02-24
449027	449027	EXCHANGE	ADD	454670100	66	2011-02-23	?	IBBI	0	0	2011-02-23	?													20110223.ifs	2011-02-23	2011-02-24
449788	449788	EXCHANGE	CHANGE	454670100	65	2006-07-03	2011-01-25	IBBI	0	0	2006-07-11	?													20110223.ifs	2011-02-23	2011-02-24
449789	449788	EXCHANGE	CHANGE	454670100	65	2006-07-03	2011-02-22	IBBI	0	0	2006-07-11	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 = 159962
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