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
4420588	4420588	DIVIDEND	CHANGE	Y002A6104		A	0	3	0	.04854	0	53	?	2020-05-29	2020-07-16	2020-04-01		1	2020-04-01	2020-07-16	0	0006081738			20200717.ifs	2020-07-17	2020-07-18
4420589	4420588	DIVIDEND	CHANGE	Y002A6104	Eq. to:China 0.04442	A	0	3	0	.04854	0	53	?	2020-05-29	2020-07-16	2020-04-01		1	2020-04-01	2020-07-17	0	0006081738			20200717.ifs	2020-07-17	2020-07-18
4419821	4419821	DIVIDEND	DELETE	Y002A6104	Eq. to:China 0.04442	0	0	3	6	0	0	08	?	2020-05-29	2020-07-16	2020-04-01		0	2020-04-01	2020-04-02	0	0006081738			20200716.ifs	2020-07-16	2020-07-17
4419822	4419822	DIVIDEND	ADD	Y002A6104		A	0	3	0	.04854	0	53	?	2020-05-29	2020-07-16	2020-04-01		1	2020-04-01	2020-07-16	0	0006081738			20200716.ifs	2020-07-16	2020-07-17
4270058	4270058	DIVIDEND	ADD	Y002A6104		0	0	3	6	0		08	?	2020-05-29	2020-07-16	2020-04-01		0	2020-04-01	?	0	0006081738			20200401.ifs	2020-04-01	2020-04-02
4270061	4270061	DIVIDEND	ADD	Y002A6104		0	0	3	6	0		08	?	2020-05-29	2020-07-16	2020-04-01		0	2020-04-01	?	0	0006081738			20200401.ifs	2020-04-01	2020-04-02
3834036	3834036	DIVIDEND	ADD	Y002A6104	Eq. to:China 0.10328	A	0	3	0	.117499		53	?	2019-06-04	2019-07-11	2019-03-28		0	?	2019-07-12	0	0005859570			20190712.ifs	2019-07-12	2019-07-13
3834037	3834037	DIVIDEND	ADD	Y002A6104	Eq. to:China 0.10328	A	0	3	0	.117499		53	?	2019-06-04	2019-07-11	2019-03-28		0	?	2019-07-12	0	0005859570			20190712.ifs	2019-07-12	2019-07-13
3184890	3184890	DIVIDEND	CHANGE	Y002A6104		A	0	3	0	.141889	0	53	?	2018-05-30	2018-07-04	2018-03-28		1	2018-03-28	2018-07-05	0	0005636676			20180706.ifs	2018-07-06	2018-07-07
3184892	3184891	DIVIDEND	CHANGE	Y002A6104	Eq. to:China 0.11497	A	0	3	0	.141889	0	53	?	2018-05-30	2018-07-04	2018-03-28		1	2018-03-28	2018-07-06	0	0005636676			20180706.ifs	2018-07-06	2018-07-07
3184918	3184918	DIVIDEND	CHANGE	Y002A6104		A	0	3	0	.141889	0	53	?	2018-05-30	2018-07-04	2018-03-28		1	2018-03-28	2018-07-05	0	0005636676			20180706.ifs	2018-07-06	2018-07-07
3184919	3184918	DIVIDEND	CHANGE	Y002A6104	Eq. to:China 0.11497	A	0	3	0	.141889	0	53	?	2018-05-30	2018-07-04	2018-03-28		1	2018-03-28	2018-07-06	0	0005636676			20180706.ifs	2018-07-06	2018-07-07
3183480	3183480	DIVIDEND	DELETE	Y002A6104	Eq. to:China 0.11497	0	0	3	6	0	0	08	?	2018-05-30	2018-07-04	2018-03-28		0	2018-03-28	2018-03-29	0	0005636676			20180705.ifs	2018-07-05	2018-07-06
3183481	3183481	DIVIDEND	ADD	Y002A6104		A	0	3	0	.141889	0	53	?	2018-05-30	2018-07-04	2018-03-28		1	2018-03-28	2018-07-05	0	0005636676			20180705.ifs	2018-07-05	2018-07-06
3184265	3184265	DIVIDEND	DELETE	Y002A6104	Eq. to:China 0.11497	0	0	3	6	0	0	08	?	2018-05-30	2018-07-04	2018-03-28		0	2018-03-28	2018-03-29	0	0005636676			20180705.ifs	2018-07-05	2018-07-06
3184266	3184266	DIVIDEND	ADD	Y002A6104		A	0	3	0	.141889	0	53	?	2018-05-30	2018-07-04	2018-03-28		1	2018-03-28	2018-07-05	0	0005636676			20180705.ifs	2018-07-05	2018-07-06
3011794	3011794	DIVIDEND	ADD	Y002A6104		0	0	3	6	0		08	?	2018-05-30	2018-07-04	2018-03-28		0	2018-03-28	?	0	0005636676			20180328.ifs	2018-03-28	2018-03-29
2618401	2618401	DIVIDEND	CHANGE	Y002A6104		A	0	3	0	.122039	0	53	2017-05-31	2017-06-01	2017-07-07	2017-03-31		1	2017-03-31	2017-07-07	0	0005411777			20170710.ifs	2017-07-10	2017-07-11
2618402	2618401	DIVIDEND	CHANGE	Y002A6104	Eq. to:China 0.10771	A	0	3	0	.122039	0	53	2017-05-31	2017-06-01	2017-07-07	2017-03-31		1	2017-03-31	2017-07-10	0	0005411777			20170710.ifs	2017-07-10	2017-07-11
2617656	2617656	DIVIDEND	DELETE	Y002A6104	Eq. to:China 0.10771	0	0	3	6	0	0	08	2017-05-31	2017-06-01	2017-07-07	2017-03-31		0	2017-03-31	2017-04-03	0	0005411777			20170707.ifs	2017-07-07	2017-07-08
2617657	2617657	DIVIDEND	ADD	Y002A6104		A	0	3	0	.122039	0	53	2017-05-31	2017-06-01	2017-07-07	2017-03-31		1	2017-03-31	2017-07-07	0	0005411777			20170707.ifs	2017-07-07	2017-07-08
2525896	2525896	DIVIDEND	ADD	Y002A6104		0	0	3	6	0		08	2017-05-31	2017-06-01	2017-07-07	2017-03-31		0	2017-03-31	?	0	0005411777			20170331.ifs	2017-03-31	2017-04-01
2472919	2472919	EQUITY	CHANGE	Y002A6104	ORD	0	0	2004-12-20	?	0	no	no		no		2005-01-18	2004-12-20	?							20170126.ifs	2017-01-26	2017-01-27
2472920	2472919	EQUITY	CHANGE	Y002A6104	ORD	0	0	2004-12-20	?	1	no	no		no		2005-01-18	2004-12-20	?							20170126.ifs	2017-01-26	2017-01-27
2240314	2240314	DIVIDEND	CHANGE	Y002A6104		A	0	3	0	.126989	0	53	2016-05-30	2016-05-31	2016-06-30	2016-04-04		2	2016-04-04	2016-06-30	0	0005203313			20160701.ifs	2016-07-01	2016-07-02
2240315	2240314	DIVIDEND	CHANGE	Y002A6104	Eq. to:China 0.107	A	0	3	0	.126989	0	53	2016-05-30	2016-05-31	2016-06-30	2016-04-04		2	2016-04-04	2016-07-01	0	0005203313			20160701.ifs	2016-07-01	2016-07-02
2236309	2236309	DIVIDEND	DELETE	Y002A6104	Eq. to:China 0.107	0	0	3	6	0	0	08	2016-05-30	2016-05-31	2016-06-30	2016-04-04		1	2016-04-04	2016-04-06	0	0005203313			20160630.ifs	2016-06-30	2016-07-01
2236310	2236310	DIVIDEND	ADD	Y002A6104		A	0	3	0	.126989	0	53	2016-05-30	2016-05-31	2016-06-30	2016-04-04		2	2016-04-04	2016-06-30	0	0005203313			20160630.ifs	2016-06-30	2016-07-01
2159008	2159008	DIVIDEND	CHANGE	Y002A6104		0	0	3	6	0	0	08	2016-05-30	2016-05-31	2016-06-30	2016-04-04		1	2016-04-04	2016-04-05	0	0005203313			20160406.ifs	2016-04-06	2016-04-07
2159009	2159008	DIVIDEND	CHANGE	Y002A6104	Eq. to:China 0.107	0	0	3	6	0	0	08	2016-05-30	2016-05-31	2016-06-30	2016-04-04		1	2016-04-04	2016-04-06	0	0005203313			20160406.ifs	2016-04-06	2016-04-07
2158338	2158338	DIVIDEND	CHANGE	Y002A6104	Eq. to:China 0.107	0	0	3	6	0	0	08	2016-05-30	2016-05-31	2016-06-30	2016-04-04		0	2016-04-04	2016-04-05	0	0005203313			20160405.ifs	2016-04-05	2016-04-06
2158339	2158338	DIVIDEND	CHANGE	Y002A6104		0	0	3	6	0	0	08	2016-05-30	2016-05-31	2016-06-30	2016-04-04		1	2016-04-04	2016-04-05	0	0005203313			20160405.ifs	2016-04-05	2016-04-06
2157127	2157127	DIVIDEND	ADD	Y002A6104		0	0	3	6	0		08	2016-05-30	2016-05-31	2016-06-30	2016-04-04		0	2016-04-04	?	0	0005203313			20160404.ifs	2016-04-04	2016-04-05
1913163	1913163	DIVIDEND	CHANGE	Y002A6104		A	0	3	0	.06626	0	53	2015-05-28	2015-05-29	2015-07-08	2015-04-02		2	2015-04-02	2015-07-08	0	0004984137			20150709.ifs	2015-07-09	2015-07-10
1913164	1913163	DIVIDEND	CHANGE	Y002A6104	Eq. to:China 0.05223	A	0	3	0	.06626	0	53	2015-05-28	2015-05-29	2015-07-08	2015-04-02		2	2015-04-02	2015-07-09	0	0004984137			20150709.ifs	2015-07-09	2015-07-10
1912636	1912636	DIVIDEND	DELETE	Y002A6104	Eq. to:China 0.05223	0	0	3	6	0	0	08	2015-05-28	2015-05-29	?	2015-04-02		1	2015-04-02	2015-04-07	0	0004984137			20150708.ifs	2015-07-08	2015-07-09
1912637	1912637	DIVIDEND	ADD	Y002A6104		A	0	3	0	.06626	0	53	2015-05-28	2015-05-29	2015-07-08	2015-04-02		2	2015-04-02	2015-07-08	0	0004984137			20150708.ifs	2015-07-08	2015-07-09
1836054	1836054	DIVIDEND	CHANGE	Y002A6104		0	0	3	6	0	0	08	2015-05-28	2015-05-29	?	2015-04-02		1	2015-04-02	2015-04-06	0	0004984137			20150407.ifs	2015-04-07	2015-04-08
1836055	1836054	DIVIDEND	CHANGE	Y002A6104	Eq. to:China 0.05223	0	0	3	6	0	0	08	2015-05-28	2015-05-29	?	2015-04-02		1	2015-04-02	2015-04-07	0	0004984137			20150407.ifs	2015-04-07	2015-04-08
1835408	1835408	DIVIDEND	CHANGE	Y002A6104	Eq. to:China 0.05223	0	0	3	6	0	0	08	2015-05-28	2015-05-29	?	2015-04-02		0	2015-04-02	2015-04-06	0	0004984137			20150406.ifs	2015-04-06	2015-04-07
1835409	1835408	DIVIDEND	CHANGE	Y002A6104		0	0	3	6	0	0	08	2015-05-28	2015-05-29	?	2015-04-02		1	2015-04-02	2015-04-06	0	0004984137			20150406.ifs	2015-04-06	2015-04-07
1834282	1834282	DIVIDEND	ADD	Y002A6104		0	0	3	6	0		08	2015-05-28	2015-05-29	?	2015-04-02		0	2015-04-02	?	0	0004984137			20150402.ifs	2015-04-02	2015-04-03
1580389	1580389	DIVIDEND	CHANGE	Y002A6104		A	0	3	0	.056989	0	53	2014-06-06	2014-06-09	2014-07-15	2014-04-04		1	2014-04-04	2014-07-15	0	0004766506			20140716.ifs	2014-07-16	2014-07-17
1580390	1580389	DIVIDEND	CHANGE	Y002A6104	Eq. to:China 0.04531	A	0	3	0	.056989	0	53	2014-06-06	2014-06-09	2014-07-15	2014-04-04		1	2014-04-04	2014-07-16	0	0004766506			20140716.ifs	2014-07-16	2014-07-17
1580391	1580391	DIVIDEND	CHANGE	Y002A6104		A	0	3	0	.07433	0	53	2013-06-07	2013-06-10	2013-07-16	2013-04-02		1	2013-04-02	2013-07-16	0	0004555380			20140716.ifs	2014-07-16	2014-07-17
1580392	1580391	DIVIDEND	CHANGE	Y002A6104	Eq. to:China 0.05935	A	0	3	0	.07433	0	53	2013-06-07	2013-06-10	2013-07-16	2013-04-02		1	2013-04-02	2014-07-16	0	0004555380			20140716.ifs	2014-07-16	2014-07-17
1579793	1579793	DIVIDEND	DELETE	Y002A6104	Eq. to:China 0.04531	0	0	3	6	0	0	08	2014-06-06	2014-06-09	?	2014-04-04		0	2014-04-04	2014-04-07	0	0004766506			20140715.ifs	2014-07-15	2014-07-16
1579794	1579794	DIVIDEND	ADD	Y002A6104		A	0	3	0	.056989	0	53	2014-06-06	2014-06-09	2014-07-15	2014-04-04		1	2014-04-04	2014-07-15	0	0004766506			20140715.ifs	2014-07-15	2014-07-16
1491600	1491600	DIVIDEND	ADD	Y002A6104		0	0	3	6	0		08	2014-06-06	2014-06-09	?	2014-04-04		0	2014-04-04	?	0	0004766506			20140404.ifs	2014-04-04	2014-04-05
1240890	1240890	DIVIDEND	DELETE	Y002A6104	Eq. to:China 0.05935	0	0	3	6	0	0	08	2013-06-07	2013-06-10	?	2013-04-02		0	2013-04-02	2013-04-03	0	0004555380			20130716.ifs	2013-07-16	2013-07-17
1240891	1240891	DIVIDEND	ADD	Y002A6104		A	0	3	0	.07433	0	53	2013-06-07	2013-06-10	2013-07-16	2013-04-02		1	2013-04-02	2013-07-16	0	0004555380			20130716.ifs	2013-07-16	2013-07-17
1152278	1152278	DIVIDEND	ADD	Y002A6104		0	0	3	6	0		08	2013-06-07	2013-06-10	?	2013-04-02		0	2013-04-02	?	0	0004555380			20130402.ifs	2013-04-02	2013-04-03
918902	918902	DIVIDEND	DELETE	Y002A6104		A	0	3	0	.118		53	?	2012-07-04	2012-07-23	2012-06-22		0	2012-06-22	?	1	0004390545			20120723.ifs	2012-07-23	2012-07-24
918903	918903	DIVIDEND	ADD	Y002A6104		6	0	3	0	.13059		28	?	2012-07-04	2012-07-23	2012-06-22		1	2012-06-22	2012-07-23	1	0004390545			20120723.ifs	2012-07-23	2012-07-24
918904	918904	DIVIDEND	DELETE	Y002A6104		A	0	3	0	.118		53	2012-06-14	2012-06-15	?	2012-04-27		0	2012-04-27	?	0	0004364862			20120723.ifs	2012-07-23	2012-07-24
891795	891795	DIVIDEND	ADD	Y002A6104		A	0	3	0	.118		53	?	2012-07-04	2012-07-23	2012-06-22		0	2012-06-22	?	1	0004390545			20120622.ifs	2012-06-22	2012-06-23
844546	844546	DIVIDEND	ADD	Y002A6104		A	0	3	0	.118		53	2012-06-14	2012-06-15	?	2012-04-27		0	2012-04-27	?	0	0004364862			20120427.ifs	2012-04-27	2012-04-28
559866	559866	DIVIDEND	DELETE	Y002A6104		A	0	3	0	.1182		53	2011-04-20	2011-04-21	2011-06-15	2011-04-13		1	2011-04-13	2011-05-31	0	0004175208			20110615.ifs	2011-06-15	2011-06-16
559867	559867	DIVIDEND	ADD	Y002A6104		6	0	3	0	.12708		28	2011-04-20	2011-04-21	2011-06-15	2011-04-13		2	2011-04-13	2011-06-15	0	0004175208			20110615.ifs	2011-06-15	2011-06-16
538360	538360	DIVIDEND	DELETE	Y002A6104		A	0	3	0	.1182		53	2011-04-20	2011-04-21	2011-05-26	2011-04-13		0	2011-04-13	?	0	0004175208			20110531.ifs	2011-05-31	2011-06-01
538361	538361	DIVIDEND	ADD	Y002A6104		A	0	3	0	.1182		53	2011-04-20	2011-04-21	2011-06-15	2011-04-13		1	2011-04-13	2011-05-31	0	0004175208			20110531.ifs	2011-05-31	2011-06-01
501388	501388	DIVIDEND	ADD	Y002A6104		A	0	3	0	.1182		53	2011-04-20	2011-04-21	2011-05-26	2011-04-13		0	2011-04-13	?	0	0004175208			20110413.ifs	2011-04-13	2011-04-14

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