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
4305193	4305193	CORPACTION	ADD	02209U108	66	D	2020-04-29			?															20200429.ifs	2020-04-29	2020-04-30
4305195	4305195	EQUITY	CHANGE	02209U108	SPONSORED ADR	0	0	2001-06-14	?	8	no	no		no		2002-06-25	?	?							20200429.ifs	2020-04-29	2020-04-30
4305196	4305195	EQUITY	CHANGE	02209U108	SPONSORED ADR	D	0	2001-06-14	2020-04-29	8	no	no		no		2002-06-25	2020-04-29	?							20200429.ifs	2020-04-29	2020-04-30
4305203	4305203	CORPACTION	ADD	02209U108	66	D	2020-04-29			?															20200429.ifs	2020-04-29	2020-04-30
4305205	4305205	EQUITY	CHANGE	02209U108	SPONSORED ADR	0	0	2001-06-14	?	8	no	no		no		2002-06-25	?	?							20200429.ifs	2020-04-29	2020-04-30
4305207	4305206	EQUITY	CHANGE	02209U108	SPONSORED ADR	D	0	2001-06-14	2020-04-29	8	no	no		no		2002-06-25	2020-04-29	?							20200429.ifs	2020-04-29	2020-04-30
3829446	3829446	DIVIDEND	DELETE	02209U108		0	0	1	5	.026983		19	2019-06-25	2019-06-26	2019-07-16	2019-06-14		0	2019-06-14	?	0	0005898407			20190705.ifs	2019-07-05	2019-07-06
3829447	3829447	DIVIDEND	DELETE	02209U108		0	0	1	5	.026983		19	2019-06-25	2019-06-26	2019-07-16	2019-06-14		0	2019-06-14	?	0	0005898407			20190705.ifs	2019-07-05	2019-07-06
3829448	3829448	DIVIDEND	ADD	02209U108		0	0	1	0	.027094		00	2019-06-25	2019-06-26	2019-07-16	2019-06-14		1	2019-06-14	2019-07-05	0	0005898407			20190705.ifs	2019-07-05	2019-07-06
3829449	3829449	DIVIDEND	ADD	02209U108		0	0	1	0	.027094		00	2019-06-25	2019-06-26	2019-07-16	2019-06-14		1	2019-06-14	2019-07-05	0	0005898407			20190705.ifs	2019-07-05	2019-07-06
3782224	3782224	DIVIDEND	ADD	02209U108		0	0	1	5	.026983		19	2019-06-25	2019-06-26	2019-07-16	2019-06-14		0	2019-06-14	?	0	0005898407			20190614.ifs	2019-06-14	2019-06-15
3782245	3782245	DIVIDEND	ADD	02209U108		0	0	1	5	.026983		19	2019-06-25	2019-06-26	2019-07-16	2019-06-14		0	2019-06-14	?	0	0005898407			20190614.ifs	2019-06-14	2019-06-15
3105622	3105622	DIVIDEND	ADD	02209U108		0	0	1	0	.028383		00	2018-05-09	2018-05-10	2018-05-30	2018-04-13		0	?	2018-05-30	0	0005647053			20180530.ifs	2018-05-30	2018-05-31
3105651	3105651	DIVIDEND	ADD	02209U108		0	0	1	0	.028383		00	2018-05-09	2018-05-10	2018-05-30	2018-04-13		0	?	2018-05-30	0	0005647053			20180530.ifs	2018-05-30	2018-05-31
3035422	3035422	DIVIDEND	CHANGE	02209U108		6	0	1	9	.166319		25	2018-04-13	2018-04-16	2018-04-23	2018-04-09		0	2018-04-09	?	0	0005646154			20180410.ifs	2018-04-10	2018-04-11
3035424	3035423	DIVIDEND	CHANGE	02209U108		6	0	1	9	.166319		25	2018-04-13	2018-04-16	2018-04-23	2018-04-09		1	2018-04-09	2018-04-10	0	0005646154			20180410.ifs	2018-04-10	2018-04-11
3035463	3035463	DIVIDEND	CHANGE	02209U108		6	0	1	9	.166319		25	2018-04-13	2018-04-16	2018-04-23	2018-04-09		0	2018-04-09	?	0	0005646154			20180410.ifs	2018-04-10	2018-04-11
3035465	3035464	DIVIDEND	CHANGE	02209U108		6	0	1	9	.166319		25	2018-04-13	2018-04-16	2018-04-23	2018-04-09		1	2018-04-09	2018-04-10	0	0005646154			20180410.ifs	2018-04-10	2018-04-11
3033776	3033776	DIVIDEND	ADD	02209U108		6	0	1	9	.166319		25	2018-04-13	2018-04-16	2018-04-23	2018-04-09		0	2018-04-09	?	0	0005646154			20180409.ifs	2018-04-09	2018-04-10
3033777	3033777	DIVIDEND	ADD	02209U108		6	0	1	9	.166319		25	2018-04-13	2018-04-16	2018-04-23	2018-04-09		0	2018-04-09	?	0	0005646154			20180409.ifs	2018-04-09	2018-04-10
2587139	2587139	DIVIDEND	DELETE	02209U108		B	0	1	5	.016385		39	2017-05-24	2017-05-26	?	2017-05-16		0	2017-05-16	?	0	0005435699			20170606.ifs	2017-06-06	2017-06-07
2587140	2587140	DIVIDEND	ADD	02209U108		0	0	1	0	.026933		00	2017-05-24	2017-05-26	2017-06-12	2017-05-16		1	2017-05-16	2017-06-06	0	0005435699			20170606.ifs	2017-06-06	2017-06-07
2568395	2568395	DIVIDEND	ADD	02209U108		B	0	1	5	.016385		39	2017-05-24	2017-05-26	?	2017-05-16		0	2017-05-16	?	0	0005435699			20170516.ifs	2017-05-16	2017-05-17
2199101	2199101	DIVIDEND	DELETE	02209U108		0	0	1	5	.21483		19	2016-05-04	2016-05-06	2016-06-01	2016-04-20		1	2016-04-20	2016-04-21	0	0005206717			20160518.ifs	2016-05-18	2016-05-19
2199102	2199102	DIVIDEND	ADD	02209U108		0	0	1	0	.021363		00	2016-05-04	2016-05-06	2016-06-01	2016-04-20		2	2016-04-20	2016-05-18	0	0005206717			20160518.ifs	2016-05-18	2016-05-19
2168851	2168851	DIVIDEND	DELETE	02209U108		0	0	1	5	.21483		19	?	2016-05-06	2016-06-01	2016-04-20		0	2016-04-20	?	0	0005206717			20160421.ifs	2016-04-21	2016-04-22
2168852	2168852	DIVIDEND	ADD	02209U108		0	0	1	5	.21483		19	2016-05-04	2016-05-06	2016-06-01	2016-04-20		1	2016-04-20	2016-04-21	0	0005206717			20160421.ifs	2016-04-21	2016-04-22
2168005	2168005	DIVIDEND	ADD	02209U108		0	0	1	5	.21483		19	?	2016-05-06	2016-06-01	2016-04-20		0	2016-04-20	?	0	0005206717			20160420.ifs	2016-04-20	2016-04-21
1871277	1871277	DIVIDEND	DELETE	02209U108		0	0	1	5	.016777		19	2015-05-13	2015-05-15	2015-06-11	2015-05-05		1	2015-05-05	2015-05-06	0	0004998013			20150527.ifs	2015-05-27	2015-05-28
1871278	1871278	DIVIDEND	ADD	02209U108		0	0	1	0	.016697		00	2015-05-13	2015-05-15	2015-06-11	2015-05-05		2	2015-05-05	2015-05-27	0	0004998013			20150527.ifs	2015-05-27	2015-05-28
1859075	1859075	DIVIDEND	DELETE	02209U108		0	0	1	5	.016777		19	?	2015-05-15	2015-06-11	2015-05-05		0	2015-05-05	?	0	0004998013			20150506.ifs	2015-05-06	2015-05-07
1859076	1859076	DIVIDEND	ADD	02209U108		0	0	1	5	.016777		19	2015-05-13	2015-05-15	2015-06-11	2015-05-05		1	2015-05-05	2015-05-06	0	0004998013			20150506.ifs	2015-05-06	2015-05-07
1576025	1576025	DIVIDEND	DELETE	02209U108		0	0	1	5	.014978		19	2014-06-13	2014-06-17	2014-07-14	2014-06-04		1	2014-06-04	2014-06-05	0	0004793948			20140707.ifs	2014-07-07	2014-07-08
1576026	1576026	DIVIDEND	ADD	02209U108		6	0	1	0	.013148		05	2014-06-13	2014-06-17	2014-07-14	2014-06-04		2	2014-06-04	2014-07-07	0	0004793948			20140707.ifs	2014-07-07	2014-07-08
1543662	1543662	DIVIDEND	DELETE	02209U108		0	0	1	5	.014978		19	?	2014-06-17	2014-07-14	2014-06-04		0	2014-06-04	?	0	0004793948			20140605.ifs	2014-06-05	2014-06-06
1543663	1543663	DIVIDEND	ADD	02209U108		0	0	1	5	.014978		19	2014-06-13	2014-06-17	2014-07-14	2014-06-04		1	2014-06-04	2014-06-05	0	0004793948			20140605.ifs	2014-06-05	2014-06-06
1543027	1543027	DIVIDEND	ADD	02209U108		0	0	1	5	.014978		19	?	2014-06-17	2014-07-14	2014-06-04		0	2014-06-04	?	0	0004793948			20140604.ifs	2014-06-04	2014-06-05
1241945	1241945	DIVIDEND	DELETE	02209U108		6	0	1	5	.010205		26	2013-07-11	2013-07-15	2013-08-06	2013-07-03		2	2013-07-03	2013-07-08	0	0004599720			20130717.ifs	2013-07-17	2013-07-18
1241946	1241946	DIVIDEND	ADD	02209U108		6	0	1	0	.010262		05	2013-07-11	2013-07-15	2013-07-26	2013-07-03		3	2013-07-03	2013-07-17	0	0004599720			20130717.ifs	2013-07-17	2013-07-18
1236996	1236996	DIVIDEND	DELETE	02209U108		0	0	1	5	.011705		19	2013-07-11	2013-07-15	2013-08-06	2013-07-03		1	2013-07-03	2013-07-05	0	0004599720			20130708.ifs	2013-07-08	2013-07-09
1236997	1236997	DIVIDEND	ADD	02209U108		6	0	1	5	.010205		26	2013-07-11	2013-07-15	2013-08-06	2013-07-03		2	2013-07-03	2013-07-08	0	0004599720			20130708.ifs	2013-07-08	2013-07-09
1236286	1236286	DIVIDEND	DELETE	02209U108		0	0	1	5	.011705		19	?	2013-07-15	2013-08-06	2013-07-03		0	2013-07-03	?	0	0004599720			20130705.ifs	2013-07-05	2013-07-06
1236287	1236287	DIVIDEND	ADD	02209U108		0	0	1	5	.011705		19	2013-07-11	2013-07-15	2013-08-06	2013-07-03		1	2013-07-03	2013-07-05	0	0004599720			20130705.ifs	2013-07-05	2013-07-06
1235395	1235395	DIVIDEND	ADD	02209U108		0	0	1	5	.011705		19	?	2013-07-15	2013-08-06	2013-07-03		0	2013-07-03	?	0	0004599720			20130703.ifs	2013-07-03	2013-07-04

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