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
5514154	5514154	DIVIDEND	ADD	N07045102		B	0	1	5	2.556757		39	2024-05-15	2024-05-16	2024-05-22	2024-03-08		0	2024-03-08	?	0	0006888523			20240308.ifs	2024-03-08	2024-03-09
5291262	5291262	DIVIDEND	DELETE	N07045102		B	0	1	5	2.265887		39	2023-05-17	2023-05-18	2023-05-25	2023-03-10		0	2023-03-10	?	0	0006694762			20230515.ifs	2023-05-15	2023-05-16
5291263	5291263	DIVIDEND	ADD	N07045102		B	0	1	0	2.31115		02	2023-05-17	2023-05-18	2023-05-25	2023-03-10		1	2023-03-10	2023-05-15	0	0006694762			20230515.ifs	2023-05-15	2023-05-16
5247107	5247107	DIVIDEND	ADD	N07045102		B	0	1	5	2.265887		39	2023-05-17	2023-05-18	2023-05-25	2023-03-10		0	2023-03-10	?	0	0006694762			20230310.ifs	2023-03-10	2023-03-11
5016217	5016217	DIVIDEND	ADD	N07045102		B	0	1	0	2.247612		02	2022-05-18	2022-05-19	2022-05-27	2022-03-24		0	?	2022-05-24	0	0006494192			20220524.ifs	2022-05-24	2022-05-25
4340178	4340178	DIVIDEND	DELETE	N07045102		B	0	1	5	1.377		39	2020-05-20	2020-05-21	2020-05-28	2020-04-24		0	2020-04-24	?	1	0006088283			20200519.ifs	2020-05-19	2020-05-20
4340180	4340180	DIVIDEND	ADD	N07045102		0	0	1	9	1.38108		03	2020-05-20	2020-05-21	2020-05-28	2020-04-24		1	2020-04-24	2020-05-19	1	0006088283			20200519.ifs	2020-05-19	2020-05-20
4340182	4340182	DIVIDEND	DELETE	N07045102		B	0	1	5	.459		39	2020-05-20	2020-05-21	2020-05-28	2020-04-23		0	2020-04-24	?	0	0006088282			20200519.ifs	2020-05-19	2020-05-20
4340185	4340185	DIVIDEND	ADD	N07045102		B	0	1	0	.46036		02	2020-05-20	2020-05-21	2020-05-28	2020-04-23		1	2020-04-24	2020-05-19	0	0006088282			20200519.ifs	2020-05-19	2020-05-20
4340215	4340215	DIVIDEND	DELETE	N07045102		B	0	1	5	1.377		39	2020-05-20	2020-05-21	2020-05-28	2020-04-24		0	2020-04-24	?	1	0006088283			20200519.ifs	2020-05-19	2020-05-20
4340217	4340217	DIVIDEND	ADD	N07045102		0	0	1	9	1.38108		03	2020-05-20	2020-05-21	2020-05-28	2020-04-24		1	2020-04-24	2020-05-19	1	0006088283			20200519.ifs	2020-05-19	2020-05-20
4340219	4340219	DIVIDEND	DELETE	N07045102		B	0	1	5	.459		39	2020-05-20	2020-05-21	2020-05-28	2020-04-23		0	2020-04-24	?	0	0006088282			20200519.ifs	2020-05-19	2020-05-20
4340221	4340221	DIVIDEND	ADD	N07045102		B	0	1	0	.46036		02	2020-05-20	2020-05-21	2020-05-28	2020-04-23		1	2020-04-24	2020-05-19	0	0006088282			20200519.ifs	2020-05-19	2020-05-20
4301125	4301125	DIVIDEND	ADD	N07045102		B	0	1	5	1.377		39	2020-05-20	2020-05-21	2020-05-28	2020-04-24		0	2020-04-24	?	1	0006088283			20200424.ifs	2020-04-24	2020-04-25
4301126	4301126	DIVIDEND	ADD	N07045102		B	0	1	5	1.377		39	2020-05-20	2020-05-21	2020-05-28	2020-04-24		0	2020-04-24	?	1	0006088283			20200424.ifs	2020-04-24	2020-04-25
4301127	4301127	DIVIDEND	ADD	N07045102		B	0	1	5	.459		39	2020-05-20	2020-05-21	2020-05-28	2020-04-23		0	2020-04-24	?	0	0006088282			20200424.ifs	2020-04-24	2020-04-25
4301128	4301128	DIVIDEND	ADD	N07045102		B	0	1	5	.459		39	2020-05-20	2020-05-21	2020-05-28	2020-04-23		0	2020-04-24	?	0	0006088282			20200424.ifs	2020-04-24	2020-04-25
4008846	4008846	DIVIDEND	DELETE	N07045102		B	0	1	5	.94673		39	2019-11-05	2019-11-06	2019-11-12	2019-10-31		0	2019-10-31	?	0	0005966901			20191107.ifs	2019-11-07	2019-11-08
4008848	4008848	DIVIDEND	ADD	N07045102		B	0	1	0	.94265		02	2019-11-05	2019-11-06	2019-11-12	2019-10-31		1	2019-10-31	2019-11-07	0	0005966901			20191107.ifs	2019-11-07	2019-11-08
4009031	4009031	DIVIDEND	DELETE	N07045102		B	0	1	5	.94673		39	2019-11-05	2019-11-06	2019-11-12	2019-10-31		0	2019-10-31	?	0	0005966901			20191107.ifs	2019-11-07	2019-11-08
4009033	4009033	DIVIDEND	ADD	N07045102		B	0	1	0	.94265		02	2019-11-05	2019-11-06	2019-11-12	2019-10-31		1	2019-10-31	2019-11-07	0	0005966901			20191107.ifs	2019-11-07	2019-11-08
3990969	3990969	DIVIDEND	ADD	N07045102		B	0	1	5	.94673		39	2019-11-05	2019-11-06	2019-11-12	2019-10-31		0	2019-10-31	?	0	0005966901			20191031.ifs	2019-10-31	2019-11-01
3991032	3991032	DIVIDEND	ADD	N07045102		B	0	1	5	.94673		39	2019-11-05	2019-11-06	2019-11-12	2019-10-31		0	2019-10-31	?	0	0005966901			20191031.ifs	2019-10-31	2019-11-01
3734436	3734436	DIVIDEND	ADD	N07045102		B	0	1	0	.949195		02	2019-05-22	2019-05-23	2019-05-29	2019-03-14		0	?	2019-05-22	0	0005852013			20190522.ifs	2019-05-22	2019-05-23
3734437	3734437	DIVIDEND	ADD	N07045102		B	0	1	0	.949195		02	2019-05-22	2019-05-23	2019-05-29	2019-03-14		0	?	2019-05-22	0	0005852013			20190522.ifs	2019-05-22	2019-05-23
3230574	3230574	DIVIDEND	ADD	N07045102		B	0	1	0	4.6944		41	2018-08-07	2018-08-08	2018-08-10	2018-06-29		0	?	2018-08-06	0	0005685477			20180806.ifs	2018-08-06	2018-08-07
3230575	3230575	DIVIDEND	ADD	N07045102		B	0	1	0	4.6944		41	2018-08-07	2018-08-08	2018-08-10	2018-06-29		0	?	2018-08-06	0	0005685477			20180806.ifs	2018-08-06	2018-08-07
3129300	3129300	DIVIDEND	ADD	N07045102		B	0	1	0	.791792		02	2018-05-30	2018-05-31	2018-06-07	2018-04-19		0	?	2018-06-07	0	0005648419			20180607.ifs	2018-06-07	2018-06-08
3129310	3129310	DIVIDEND	ADD	N07045102		B	0	1	0	.791792		02	2018-05-30	2018-05-31	2018-06-07	2018-04-19		0	?	2018-06-07	0	0005648419			20180607.ifs	2018-06-07	2018-06-08
2575287	2575287	DIVIDEND	ADD	N07045102		B	0	1	0	.667292		02	2017-05-23	2017-05-25	2017-06-01	2017-03-14		0	?	2017-05-30	0	0005401691			20170530.ifs	2017-05-30	2017-05-31
2472597	2472597	EQUITY	CHANGE	N07045102	ORD	0	0	1996-12-04	?	0	yes	no		no		1996-12-30	2016-07-22	?							20170126.ifs	2017-01-26	2017-01-27
2472598	2472597	EQUITY	CHANGE	N07045102	ORD	0	0	1996-12-04	?	1	yes	no		no		1996-12-30	2016-07-22	?							20170126.ifs	2017-01-26	2017-01-27
2255382	2255382	EQUITY	CHANGE	N07045102	ORD	0	0	1996-12-04	2016-06-02	0	yes	no	N07045102	no		1996-12-30	2016-06-02	?							20160722.ifs	2016-07-22	2016-07-23
2255383	2255382	EQUITY	CHANGE	N07045102	ORD	0	0	1996-12-04	?	0	yes	no		no		1996-12-30	2016-07-22	?							20160722.ifs	2016-07-22	2016-07-23
2214350	2214350	DIVIDEND	ADD	N07045102		B	0	1	0	.663187		02	2016-05-26	2016-05-31	2016-06-07	2016-04-26		0	?	2016-06-03	0	0005208053			20160603.ifs	2016-06-03	2016-06-04
2213011	2213011	EQUITY	CHANGE	N07045102	ORD	0	0	1996-12-04	2015-08-21	0	yes	no	N07045102	no		1996-12-30	2015-08-21	?							20160602.ifs	2016-06-02	2016-06-03
2213012	2213011	EQUITY	CHANGE	N07045102	ORD	0	0	1996-12-04	2016-06-02	0	yes	no	N07045102	no		1996-12-30	2016-06-02	?							20160602.ifs	2016-06-02	2016-06-03
1944553	1944553	CORPACTION	ADD	N07045102	60	X	2015-08-21	N07045102	66	?															20150821.ifs	2015-08-21	2015-08-22
1944554	1944554	EXCHANGE	ADD	N07045102	66	2015-08-21	?	ASMIY	0	0	2015-08-21	?													20150821.ifs	2015-08-21	2015-08-22
1944555	1944555	EQUITY	CHANGE	N07045102	ORD	0	0	1996-12-04	?	0	yes	yes		yes		1996-12-30	2001-12-17	?							20150821.ifs	2015-08-21	2015-08-22
1944556	1944555	EQUITY	CHANGE	N07045102	ORD	0	0	1996-12-04	?	0	yes	yes		no		1996-12-30	2015-08-21	?							20150821.ifs	2015-08-21	2015-08-22
1944603	1944602	EQUITY	CHANGE	N07045102	60	X	2015-08-21	N07045102	66	?															20150821.ifs	2015-08-21	2015-08-22
1944604	1944603	EQUITY	CHANGE	N07045102	60	D	2015-08-21	N07045102	66	2015-08-21															20150821.ifs	2015-08-21	2015-08-22
1944605	1944605	EQUITY	CHANGE	N07045102	ORD	0	0	1996-12-04	?	0	yes	yes		no		1996-12-30	2015-08-21	?							20150821.ifs	2015-08-21	2015-08-22
1944606	1944605	EQUITY	CHANGE	N07045102	ORD	D	0	1996-12-04	2015-08-21	0	yes	yes		no		1996-12-30	2015-08-21	?							20150821.ifs	2015-08-21	2015-08-22
1944625	1944625	EQUITY	CHANGE	N07045102	ORD	D	0	1996-12-04	2015-08-21	0	yes	yes		no		1996-12-30	2015-08-21	?							20150821.ifs	2015-08-21	2015-08-22
1944626	1944625	EQUITY	CHANGE	N07045102	ORD	0	0	1996-12-04	?	0	yes	no		no		1996-12-30	2015-08-21	?							20150821.ifs	2015-08-21	2015-08-22
1944628	1944627	EQUITY	CHANGE	N07045102	60	D	2015-08-21	N07045102	66	2015-08-21															20150821.ifs	2015-08-21	2015-08-22
1944629	1944628	EQUITY	CHANGE	N07045102	60	Q	2015-08-21	N07045102	66	2015-08-21															20150821.ifs	2015-08-21	2015-08-22
1944630	1944630	EQUITY	CHANGE	N07045102	ORD	0	0	1996-12-04	?	0	yes	no		no		1996-12-30	2015-08-21	?							20150821.ifs	2015-08-21	2015-08-22
1944631	1944630	EQUITY	CHANGE	N07045102	ORD	Q	0	1996-12-04	2015-08-21	0	yes	no	N07045102	no		1996-12-30	2015-08-21	?							20150821.ifs	2015-08-21	2015-08-22
1944633	1944632	EQUITY	CHANGE	N07045102	60	Q	2015-08-21	N07045102	66	2015-08-21															20150821.ifs	2015-08-21	2015-08-22
1944634	1944633	EQUITY	CHANGE	N07045102	60	X	2015-08-21	N07045102	66	2015-08-21															20150821.ifs	2015-08-21	2015-08-22
1944635	1944635	EQUITY	CHANGE	N07045102	ORD	Q	0	1996-12-04	2015-08-21	0	yes	no	N07045102	no		1996-12-30	2015-08-21	?							20150821.ifs	2015-08-21	2015-08-22
1944636	1944635	EQUITY	CHANGE	N07045102	ORD	0	0	1996-12-04	2015-08-21	0	yes	no	N07045102	no		1996-12-30	2015-08-21	?							20150821.ifs	2015-08-21	2015-08-22
1868751	1868751	DIVIDEND	ADD	N07045102		B	0	1	0	.6		02	2015-05-25	2015-05-26	2015-06-09	2015-05-21		0	?	2015-05-22	0	0004989393			20150522.ifs	2015-05-22	2015-05-23
1868752	1868752	DIVIDEND	DELETE	N07045102		B	0	1	0	.6		02	2015-05-25	2015-05-26	2015-06-09	2015-05-21		0	?	2015-05-22	0	0004989393			20150522.ifs	2015-05-22	2015-05-23
1868753	1868753	DIVIDEND	ADD	N07045102		B	0	1	0	.567783	0	02	2015-05-22	2015-05-26	2015-06-09	2015-05-21		0	?	2015-05-22	0	0004989393			20150522.ifs	2015-05-22	2015-05-23
1530068	1530068	DIVIDEND	DELETE	N07045102		B		1	0	.58123		02	2014-05-22	2014-05-27	2014-06-06	?		0	2014-05-23	?	0	0004772323			20140527.ifs	2014-05-27	2014-05-28
1530069	1530069	DIVIDEND	ADD	N07045102		B	0	1	0	.58123	0	02	2014-05-22	2014-05-27	2014-06-06	2014-04-29		0	?	2014-05-27	0	0004772323			20140527.ifs	2014-05-27	2014-05-28
1529443	1529443	DIVIDEND	ADD	N07045102		B		1	0	.58123		02	2014-05-22	2014-05-27	2014-06-06	?		0	2014-05-23	?	0	0004772323			20140523.ifs	2014-05-23	2014-05-24
1246158	1246158	DIVIDEND	CHANGE	N07045102		6	0	1	9	5.59555		25	2013-07-25	2013-07-29	2013-07-31	2013-07-11		0	?	2013-07-24	0	0004601190			20130725.ifs	2013-07-25	2013-07-26
1246159	1246158	DIVIDEND	CHANGE	N07045102	Ex-date corresponds with foreign ex-date.	6	0	1	9	5.59555	0	25	2013-07-25	2013-07-29	2013-07-31	2013-07-11		0	?	2013-07-25	0	0004601190			20130725.ifs	2013-07-25	2013-07-26
1245282	1245282	DIVIDEND	ADD	N07045102	Ex-date corresponds with foreign ex-date.	B	0	1	0	5.596		02	2013-07-25	2013-07-29	2013-07-31	2013-07-11		0	?	2013-07-24	0	0004601190			20130724.ifs	2013-07-24	2013-07-25
1245703	1245703	DIVIDEND	DELETE	N07045102	Ex-date corresponds with foreign ex-date.	B	0	1	0	5.596		02	2013-07-25	2013-07-29	2013-07-31	2013-07-11		0	?	2013-07-24	0	0004601190			20130724.ifs	2013-07-24	2013-07-25
1245704	1245704	DIVIDEND	ADD	N07045102		6	0	1	9	5.59555		25	2013-07-25	2013-07-29	2013-07-31	2013-07-11		0	?	2013-07-24	0	0004601190			20130724.ifs	2013-07-24	2013-07-25
1192146	1192146	DIVIDEND	CHANGE	N07045102		B	0	1	0	.547825	0	02	2013-05-20	2013-05-22	2013-05-30	2013-05-02		2	2013-05-02	2013-05-23	0	0004569123			20130524.ifs	2013-05-24	2013-05-25
1192147	1192146	DIVIDEND	CHANGE	N07045102	Ex-date corresponds with foreign ex-date.	B	0	1	0	.547825	0	02	2013-05-20	2013-05-22	2013-05-30	2013-05-02		2	2013-05-02	2013-05-24	0	0004569123			20130524.ifs	2013-05-24	2013-05-25
1191514	1191514	DIVIDEND	DELETE	N07045102	Ex-date corresponds with foreign ex-date.	B	0	1	5	.55658	0	39	2013-05-20	2013-05-22	2013-05-30	2013-05-02		1	2013-05-02	2013-05-20	0	0004569123			20130523.ifs	2013-05-23	2013-05-24
1191515	1191515	DIVIDEND	ADD	N07045102		B	0	1	0	.547825	0	02	2013-05-20	2013-05-22	2013-05-30	2013-05-02		2	2013-05-02	2013-05-23	0	0004569123			20130523.ifs	2013-05-23	2013-05-24
1188154	1188154	DIVIDEND	CHANGE	N07045102		B	0	1	5	.55658		39	2013-05-20	2013-05-22	2013-05-30	2013-05-02		1	2013-05-02	2013-05-17	0	0004569123			20130520.ifs	2013-05-20	2013-05-21
1188155	1188154	DIVIDEND	CHANGE	N07045102	Ex-date corresponds with foreign ex-date.	B	0	1	5	.55658	0	39	2013-05-20	2013-05-22	2013-05-30	2013-05-02		1	2013-05-02	2013-05-20	0	0004569123			20130520.ifs	2013-05-20	2013-05-21
1187806	1187806	DIVIDEND	DELETE	N07045102		B	0	1	5	.55658		39	?	2013-05-22	2013-05-30	2013-05-02		0	2013-05-02	?	0	0004569123			20130517.ifs	2013-05-17	2013-05-18
1187807	1187807	DIVIDEND	ADD	N07045102		B	0	1	5	.55658		39	2013-05-20	2013-05-22	2013-05-30	2013-05-02		1	2013-05-02	2013-05-17	0	0004569123			20130517.ifs	2013-05-17	2013-05-18
1178554	1178554	DIVIDEND	ADD	N07045102		B	0	1	5	.55658		39	?	2013-05-22	2013-05-30	2013-05-02		0	2013-05-02	?	0	0004569123			20130502.ifs	2013-05-02	2013-05-03
862692	862692	DIVIDEND	DELETE	N07045102		B		1	0	.545827		02	2012-05-17	2012-05-21	2012-05-29	?		0	2012-05-16	?	0	0004372797			20120517.ifs	2012-05-17	2012-05-18
862693	862693	DIVIDEND	ADD	N07045102		B	0	1	0	.545827	0	02	2012-05-17	2012-05-21	2012-05-29	2012-05-07		0	?	2012-05-17	0	0004372797			20120517.ifs	2012-05-17	2012-05-18
862245	862245	DIVIDEND	ADD	N07045102		B		1	0	.545827		02	2012-05-17	2012-05-21	2012-05-29	?		0	2012-05-16	?	0	0004372797			20120516.ifs	2012-05-16	2012-05-17
858392	858392	DIVIDEND	DELETE	N07045102		B	0	1	5	.554795		39	?	2012-05-21	2012-05-29	2012-05-07		0	2012-05-07	?	0	0004372797			20120509.ifs	2012-05-09	2012-05-10
856345	856345	DIVIDEND	ADD	N07045102		B	0	1	5	.554795		39	?	2012-05-21	2012-05-29	2012-05-07		0	2012-05-07	?	0	0004372797			20120507.ifs	2012-05-07	2012-05-08
541327	541327	DIVIDEND	CHANGE	N07045102		B	0	1	0	.47668	0	02	2011-05-25	2011-05-27	2011-06-03	2011-05-12		2	2011-05-12	2011-05-31	0	0004187879			20110601.ifs	2011-06-01	2011-06-02
541328	541327	DIVIDEND	CHANGE	N07045102	Ex-date corresponds with foreign ex-date.	B	0	1	0	.47668	0	02	2011-05-25	2011-05-27	2011-06-03	2011-05-12		2	2011-05-12	2011-06-01	0	0004187879			20110601.ifs	2011-06-01	2011-06-02
538370	538370	DIVIDEND	DELETE	N07045102	Ex-date corresponds with foreign ex-date.	B	0	1	5	.490076	0	39	2011-05-25	2011-05-27	2011-06-03	2011-05-12		1	2011-05-12	2011-05-18	0	0004187879			20110531.ifs	2011-05-31	2011-06-01
538371	538371	DIVIDEND	ADD	N07045102		B	0	1	0	.47668	0	02	2011-05-25	2011-05-27	2011-06-03	2011-05-12		2	2011-05-12	2011-05-31	0	0004187879			20110531.ifs	2011-05-31	2011-06-01
528026	528026	DIVIDEND	CHANGE	N07045102		B	0	1	5	.490076		39	2011-05-25	2011-05-27	2011-06-03	2011-05-12		1	2011-05-12	2011-05-17	0	0004187879			20110518.ifs	2011-05-18	2011-05-19
528027	528026	DIVIDEND	CHANGE	N07045102	Ex-date corresponds with foreign ex-date.	B	0	1	5	.490076	0	39	2011-05-25	2011-05-27	2011-06-03	2011-05-12		1	2011-05-12	2011-05-18	0	0004187879			20110518.ifs	2011-05-18	2011-05-19
527748	527748	DIVIDEND	CHANGE	N07045102		B	0	1	5	.490076		39	2011-05-25	2011-05-27	2011-06-03	2011-05-12		0	2011-05-12	?	0	0004187879			20110517.ifs	2011-05-17	2011-05-18
527749	527748	DIVIDEND	CHANGE	N07045102		B	0	1	5	.490076		39	2011-05-25	2011-05-27	2011-06-03	2011-05-12		1	2011-05-12	2011-05-17	0	0004187879			20110517.ifs	2011-05-17	2011-05-18
525024	525024	DIVIDEND	ADD	N07045102		B	0	1	5	.490076		39	2011-05-25	2011-05-27	2011-06-03	2011-05-12		0	2011-05-12	?	0	0004187879			20110512.ifs	2011-05-12	2011-05-13

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