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
5563099	5563099	DIVIDEND	DELETE	J00714105		0	0	3	6	0		08	?	2024-03-31	?	2024-03-01		0	2024-03-01	?	0	0006884703			20240529.ifs	2024-05-29	2024-05-30
5563100	5563100	DIVIDEND	ADD	J00714105		A	0	3	0	90		53	?	2024-03-31	2024-05-29	2024-03-01		1	2024-03-01	2024-05-29	0	0006884703			20240529.ifs	2024-05-29	2024-05-30
5507858	5507858	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2024-03-31	?	2024-03-01		0	2024-03-01	?	0	0006884703			20240301.ifs	2024-03-01	2024-03-02
5418735	5418735	DIVIDEND	DELETE	J00714105		0	0	3	6	0		08	?	2023-09-30	?	2023-09-07		0	2023-09-07	?	0	0006780842			20231127.ifs	2023-11-27	2023-11-28
5418736	5418736	DIVIDEND	ADD	J00714105		A	0	3	0	80		53	?	2023-09-30	2023-11-27	2023-09-07		1	2023-09-07	2023-11-27	0	0006780842			20231127.ifs	2023-11-27	2023-11-28
5369427	5369427	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2023-09-30	?	2023-09-07		0	2023-09-07	?	0	0006780842			20230907.ifs	2023-09-07	2023-09-08
5298069	5298069	DIVIDEND	DELETE	J00714105		0	0	3	6	0		08	?	2023-03-31	?	2023-03-01		0	2023-03-01	?	0	0006691587			20230530.ifs	2023-05-30	2023-05-31
5298070	5298070	DIVIDEND	ADD	J00714105		A	0	3	0	100		53	?	2023-03-31	2023-05-29	2023-03-01		1	2023-03-01	2023-05-30	0	0006691587			20230530.ifs	2023-05-30	2023-05-31
5239598	5239598	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2023-03-31	?	2023-03-01		0	2023-03-01	?	0	0006691587			20230301.ifs	2023-03-01	2023-03-02
5144359	5144359	DIVIDEND	DELETE	J00714105		A	0	3	0	70		53	?	2022-09-30	2022-11-25	2022-08-29		1	2022-08-29	2022-11-25	0	0006573226			20221128.ifs	2022-11-28	2022-11-29
5144360	5144360	DIVIDEND	ADD	J00714105		A	0	3	0	70	0	53	?	2022-09-30	2022-11-25	2022-08-25		0	?	2022-11-28	0	0006573226			20221128.ifs	2022-11-28	2022-11-29
5144080	5144080	DIVIDEND	DELETE	J00714105		0	0	3	6	0		08	?	2022-09-30	?	2022-08-29		0	2022-08-29	?	0	0006573226			20221125.ifs	2022-11-25	2022-11-26
5144081	5144081	DIVIDEND	ADD	J00714105		A	0	3	0	70		53	?	2022-09-30	2022-11-25	2022-08-29		1	2022-08-29	2022-11-25	0	0006573226			20221125.ifs	2022-11-25	2022-11-26
5083763	5083763	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2022-09-30	?	2022-08-29		0	2022-08-29	?	0	0006573226			20220829.ifs	2022-08-29	2022-08-30
5021328	5021328	DIVIDEND	DELETE	J00714105		0	0	3	6	0		08	?	2022-03-31	?	2022-03-02		0	2022-03-02	?	0	0006490271			20220601.ifs	2022-06-01	2022-06-02
5021329	5021329	DIVIDEND	ADD	J00714105		A	0	3	0	100		53	?	2022-03-31	2022-05-30	2022-03-02		1	2022-03-02	2022-06-01	0	0006490271			20220601.ifs	2022-06-01	2022-06-02
4964741	4964741	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2022-03-31	?	2022-03-02		0	2022-03-02	?	0	0006490271			20220302.ifs	2022-03-02	2022-03-03
4853463	4853463	DIVIDEND	DELETE	J00714105		0	0	3	6	0		08	?	2021-09-30	?	2021-09-02		0	2021-09-02	?	0	0006364181			20211126.ifs	2021-11-26	2021-11-27
4853464	4853464	DIVIDEND	ADD	J00714105		A	0	3	0	70		53	?	2021-09-30	2021-11-26	2021-09-02		1	2021-09-02	2021-11-26	0	0006364181			20211126.ifs	2021-11-26	2021-11-27
4796255	4796255	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2021-09-30	?	2021-09-02		0	2021-09-02	?	0	0006364181			20210902.ifs	2021-09-02	2021-09-03
4720879	4720879	DIVIDEND	DELETE	J00714105		0	0	3	6	0		08	?	2021-03-31	?	2021-02-22		0	2021-02-22	?	0	0006265881			20210602.ifs	2021-06-02	2021-06-03
4720880	4720880	DIVIDEND	ADD	J00714105		A	0	3	0	100		53	?	2021-03-31	2021-05-31	2021-02-22		1	2021-02-22	2021-06-02	0	0006265881			20210602.ifs	2021-06-02	2021-06-03
4633698	4633698	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2021-03-31	?	2021-02-22		0	2021-02-22	?	0	0006265881			20210222.ifs	2021-02-22	2021-02-23
4515498	4515498	DIVIDEND	DELETE	J00714105		0	0	3	6	0		08	?	2020-09-30	?	2020-09-01		0	2020-09-01	?	0	0006152886			20201127.ifs	2020-11-27	2020-11-28
4515499	4515499	DIVIDEND	ADD	J00714105		A	0	3	0	20		53	?	2020-09-30	2020-11-26	2020-09-01		1	2020-09-01	2020-11-27	0	0006152886			20201127.ifs	2020-11-27	2020-11-28
4450913	4450913	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2020-09-30	?	2020-09-01		0	2020-09-01	?	0	0006152886			20200901.ifs	2020-09-01	2020-09-02
4353116	4353116	DIVIDEND	DELETE	J00714105		0	0	3	6	0		08	?	2020-03-31	?	2020-03-03		0	2020-03-03	?	0	0006065904			20200529.ifs	2020-05-29	2020-05-30
4353118	4353118	DIVIDEND	ADD	J00714105		A	0	3	0	60		53	?	2020-03-31	2020-05-28	2020-03-03		1	2020-03-03	2020-05-29	0	0006065904			20200529.ifs	2020-05-29	2020-05-30
4353177	4353177	DIVIDEND	DELETE	J00714105		0	0	3	6	0		08	?	2020-03-31	?	2020-03-03		0	2020-03-03	?	0	0006065904			20200529.ifs	2020-05-29	2020-05-30
4353179	4353179	DIVIDEND	ADD	J00714105		A	0	3	0	60		53	?	2020-03-31	2020-05-28	2020-03-03		1	2020-03-03	2020-05-29	0	0006065904			20200529.ifs	2020-05-29	2020-05-30
4230033	4230033	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2020-03-31	?	2020-03-03		0	2020-03-03	?	0	0006065904			20200303.ifs	2020-03-03	2020-03-04
4230034	4230034	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2020-03-31	?	2020-03-03		0	2020-03-03	?	0	0006065904			20200303.ifs	2020-03-03	2020-03-04
3915867	3915867	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2019-09-30	?	2019-09-09		0	2019-09-09	?	0	0005942990			20190909.ifs	2019-09-09	2019-09-10
3915919	3915919	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2019-09-30	?	2019-09-09		0	2019-09-09	?	0	0005942990			20190909.ifs	2019-09-09	2019-09-10
3798798	3798798	DIVIDEND	DELETE	J00714105		0	0	3	6	0		08	?	2019-03-31	?	2019-03-01		1	2019-03-01	2019-04-16	0	0005847814			20190625.ifs	2019-06-25	2019-06-26
3798800	3798800	DIVIDEND	ADD	J00714105		A	0	3	0	90		53	?	2019-03-31	2019-06-19	2019-03-01		2	2019-03-01	2019-06-25	0	0005847814			20190625.ifs	2019-06-25	2019-06-26
3798820	3798820	DIVIDEND	DELETE	J00714105		0	0	3	6	0		08	?	2019-03-31	?	2019-03-01		1	2019-03-01	2019-04-16	0	0005847814			20190625.ifs	2019-06-25	2019-06-26
3798822	3798822	DIVIDEND	ADD	J00714105		A	0	3	0	90		53	?	2019-03-31	2019-06-19	2019-03-01		2	2019-03-01	2019-06-25	0	0005847814			20190625.ifs	2019-06-25	2019-06-26
3685320	3685320	DIVIDEND	CHANGE	J00714105		0	0	3	6	0		08	?	2019-03-31	?	2019-03-01		0	2019-03-01	?	0	0005847814			20190416.ifs	2019-04-16	2019-04-17
3685322	3685321	DIVIDEND	CHANGE	J00714105		0	0	3	6	0		08	?	2019-03-31	?	2019-03-01		1	2019-03-01	2019-04-16	0	0005847814			20190416.ifs	2019-04-16	2019-04-17
3685325	3685325	DIVIDEND	CHANGE	J00714105		0	0	3	6	0		08	?	2019-03-31	?	2019-03-01		0	2019-03-01	?	0	0005847814			20190416.ifs	2019-04-16	2019-04-17
3685327	3685326	DIVIDEND	CHANGE	J00714105		0	0	3	6	0		08	?	2019-03-31	?	2019-03-01		1	2019-03-01	2019-04-16	0	0005847814			20190416.ifs	2019-04-16	2019-04-17
3605295	3605295	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2019-03-31	?	2019-03-01		0	2019-03-01	?	0	0005847814			20190301.ifs	2019-03-01	2019-03-02
3605500	3605500	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2019-03-31	?	2019-03-01		0	2019-03-01	?	0	0005847814			20190301.ifs	2019-03-01	2019-03-02
3382550	3382550	DIVIDEND	DELETE	J00714105		0	0	3	6	0		08	?	2018-09-30	?	2018-09-06		1	2018-09-06	2018-09-07	0	0005720427			20181127.ifs	2018-11-27	2018-11-28
3382552	3382552	DIVIDEND	ADD	J00714105		A	0	3	0	60		53	?	2018-09-30	2018-11-27	2018-09-06		2	2018-09-06	2018-11-27	0	0005720427			20181127.ifs	2018-11-27	2018-11-28
3382553	3382553	DIVIDEND	DELETE	J00714105		0	0	3	6	0		08	?	2018-09-30	?	2018-09-06		1	2018-09-06	2018-09-07	0	0005720427			20181127.ifs	2018-11-27	2018-11-28
3382556	3382556	DIVIDEND	ADD	J00714105		A	0	3	0	60		53	?	2018-09-30	2018-11-27	2018-09-06		2	2018-09-06	2018-11-27	0	0005720427			20181127.ifs	2018-11-27	2018-11-28
3273703	3273703	DIVIDEND	CHANGE	J00714105		0	0	3	6	0		08	?	2018-09-30	?	2018-09-06		0	2018-09-06	?	0	0005720427			20180907.ifs	2018-09-07	2018-09-08
3273705	3273704	DIVIDEND	CHANGE	J00714105		0	0	3	6	0		08	?	2018-09-30	?	2018-09-06		1	2018-09-06	2018-09-07	0	0005720427			20180907.ifs	2018-09-07	2018-09-08
3273729	3273729	DIVIDEND	CHANGE	J00714105		0	0	3	6	0		08	?	2018-09-30	?	2018-09-06		0	2018-09-06	?	0	0005720427			20180907.ifs	2018-09-07	2018-09-08
3273731	3273730	DIVIDEND	CHANGE	J00714105		0	0	3	6	0		08	?	2018-09-30	?	2018-09-06		1	2018-09-06	2018-09-07	0	0005720427			20180907.ifs	2018-09-07	2018-09-08
3271757	3271757	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2018-09-30	?	2018-09-06		0	2018-09-06	?	0	0005720427			20180906.ifs	2018-09-06	2018-09-07
3271760	3271760	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2018-09-30	?	2018-09-06		0	2018-09-06	?	0	0005720427			20180906.ifs	2018-09-06	2018-09-07
3154368	3154368	DIVIDEND	DELETE	J00714105		0	0	3	6	0		08	?	2018-03-31	?	2018-03-05		2	2018-03-05	2018-06-25	0	0005626981			20180626.ifs	2018-06-26	2018-06-27
3154370	3154370	DIVIDEND	ADD	J00714105		A	0	3	0	90		53	2018-03-28	2018-03-31	2018-06-20	2018-03-05		3	2018-03-05	2018-06-26	0	0005626981			20180626.ifs	2018-06-26	2018-06-27
3154381	3154381	DIVIDEND	DELETE	J00714105		0	0	3	6	0		08	?	2018-03-31	?	2018-03-05		2	2018-03-05	2018-06-25	0	0005626981			20180626.ifs	2018-06-26	2018-06-27
3154383	3154383	DIVIDEND	ADD	J00714105		A	0	3	0	90		53	2018-03-28	2018-03-31	2018-06-20	2018-03-05		3	2018-03-05	2018-06-26	0	0005626981			20180626.ifs	2018-06-26	2018-06-27
3017292	3017292	DIVIDEND	CHANGE	J00714105		0	0	3	6	0		08	?	2018-03-31	?	2018-03-05		0	2018-03-05	?	0	0005626981			20180402.ifs	2018-04-02	2018-04-03
3017293	3017292	DIVIDEND	CHANGE	J00714105		0	0	3	6	0		08	?	2018-03-31	?	2018-03-05		1	2018-03-05	2018-04-02	0	0005626981			20180402.ifs	2018-04-02	2018-04-03
3021680	3021680	DIVIDEND	CHANGE	J00714105		0	0	3	6	0		08	?	2018-03-31	?	2018-03-05		0	2018-03-05	?	0	0005626981			20180402.ifs	2018-04-02	2018-04-03
3021682	3021681	DIVIDEND	CHANGE	J00714105		0	0	3	6	0		08	?	2018-03-31	?	2018-03-05		1	2018-03-05	2018-04-02	0	0005626981			20180402.ifs	2018-04-02	2018-04-03
2981728	2981728	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2018-03-31	?	2018-03-05		0	2018-03-05	?	0	0005626981			20180305.ifs	2018-03-05	2018-03-06
2982349	2982349	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2018-03-31	?	2018-03-05		0	2018-03-05	?	0	0005626981			20180305.ifs	2018-03-05	2018-03-06
2776480	2776480	DIVIDEND	DELETE	J00714105		A		3	0	60		53	?	2017-09-30	2017-11-27	?		0	2017-11-27	?	0	0005498124			20171128.ifs	2017-11-28	2017-11-29
2776481	2776481	DIVIDEND	ADD	J00714105		A	0	3	0	60	0	53	?	2017-09-30	2017-11-27	2017-09-15		0	?	2017-11-28	0	0005498124			20171128.ifs	2017-11-28	2017-11-29
2776690	2776690	DIVIDEND	DELETE	J00714105		A		3	0	60		53	?	2017-09-30	2017-11-27	?		0	2017-11-27	?	0	0005498124			20171128.ifs	2017-11-28	2017-11-29
2776692	2776692	DIVIDEND	ADD	J00714105		A	0	3	0	60	0	53	?	2017-09-30	2017-11-27	2017-09-15		0	?	2017-11-28	0	0005498124			20171128.ifs	2017-11-28	2017-11-29
2775790	2775790	DIVIDEND	ADD	J00714105		A		3	0	60		53	?	2017-09-30	2017-11-27	?		0	2017-11-27	?	0	0005498124			20171127.ifs	2017-11-27	2017-11-28
2775791	2775791	DIVIDEND	ADD	J00714105		A		3	0	60		53	?	2017-09-30	2017-11-27	?		0	2017-11-27	?	0	0005498124			20171127.ifs	2017-11-27	2017-11-28
2675749	2675749	DIVIDEND	DELETE	J00714105		0	0	3	6	0		08	?	2017-09-30	?	2017-09-15		0	2017-09-15	?	0	0005498124			20170918.ifs	2017-09-18	2017-09-19
2675781	2675781	DIVIDEND	DELETE	J00714105		0	0	3	6	0		08	?	2017-09-30	?	2017-09-15		0	2017-09-15	?	0	0005498124			20170918.ifs	2017-09-18	2017-09-19
2672357	2672357	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2017-09-30	?	2017-09-15		0	2017-09-15	?	0	0005498124			20170915.ifs	2017-09-15	2017-09-16
2673053	2673053	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2017-09-30	?	2017-09-15		0	2017-09-15	?	0	0005498124			20170915.ifs	2017-09-15	2017-09-16
2599340	2599340	DIVIDEND	ADD	J00714105		A	0	3	0	75		53	?	2017-03-31	2017-06-19	2017-03-02		0	?	2017-06-23	0	0005399337			20170623.ifs	2017-06-23	2017-06-24
2453384	2453384	EQUITY	CHANGE	J00714105	ORD	0	0	2005-08-09	?	0	no	no		no		?	2005-09-23	?							20170124.ifs	2017-01-24	2017-01-25
2453385	2453384	EQUITY	CHANGE	J00714105	ORD	0	0	2005-08-09	?	2	no	no		no		?	2005-09-23	?							20170124.ifs	2017-01-24	2017-01-25
2359007	2359007	DIVIDEND	ADD	J00714105		A	0	3	0	50		53	?	2016-09-30	2016-11-25	2016-09-01		0	?	2016-12-02	0	0005275769			20161202.ifs	2016-12-02	2016-12-03
2229930	2229930	DIVIDEND	CHANGE	J00714105		A	0	3	0	50	0	53	2016-03-29	2016-03-31	2016-06-20	2016-03-03		0	?	2016-06-22	0	0005184565			20160624.ifs	2016-06-24	2016-06-25
2229931	2229930	DIVIDEND	CHANGE	J00714105		A	0	3	0	50	0	53	2016-03-29	2016-03-31	2016-06-20	2016-03-03		0	?	2016-06-24	0	0005184565			20160624.ifs	2016-06-24	2016-06-25
2227328	2227328	DIVIDEND	DELETE	J00714105		A		3	0	50		53	2016-03-29	2016-03-31	2016-06-20	?		0	2016-06-21	?	0	0005184565			20160622.ifs	2016-06-22	2016-06-23
2227329	2227329	DIVIDEND	ADD	J00714105		A	0	3	0	50	0	53	2016-03-29	2016-03-31	2016-06-20	2016-03-03		0	?	2016-06-22	0	0005184565			20160622.ifs	2016-06-22	2016-06-23
2226269	2226269	DIVIDEND	ADD	J00714105		A		3	0	50		53	2016-03-29	2016-03-31	2016-06-20	?		0	2016-06-21	?	0	0005184565			20160621.ifs	2016-06-21	2016-06-22
2041954	2041954	DIVIDEND	DELETE	J00714105		A		3	0	50		53	2015-09-28	2015-09-30	2015-11-26	?		0	2015-12-15	?	0	0005061458			20151216.ifs	2015-12-16	2015-12-17
2041955	2041955	DIVIDEND	ADD	J00714105		A	0	3	0	50	0	53	2015-09-28	2015-09-30	2015-11-26	2015-12-15		0	?	2015-12-16	0	0005061458			20151216.ifs	2015-12-16	2015-12-17
2039045	2039045	DIVIDEND	ADD	J00714105		A		3	0	50		53	2015-09-28	2015-09-30	2015-11-26	?		0	2015-12-15	?	0	0005061458			20151215.ifs	2015-12-15	2015-12-16
1964932	1964932	DIVIDEND	DELETE	J00714105		0	0	3	6	0		08	?	2015-09-30	?	2015-09-11		0	2015-09-11	?	0	0005061458			20150914.ifs	2015-09-14	2015-09-15
1963868	1963868	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2015-09-30	?	2015-09-11		0	2015-09-11	?	0	0005061458			20150911.ifs	2015-09-11	2015-09-12
1895090	1895090	DIVIDEND	DELETE	J00714105		A		3	0	50		53	2015-03-27	2015-03-31	2015-06-19	?		0	2015-06-24	?	0	0004968152			20150625.ifs	2015-06-25	2015-06-26
1895091	1895091	DIVIDEND	ADD	J00714105		A	0	3	0	50	0	53	2015-03-27	2015-03-31	2015-06-19	2015-06-24		0	?	2015-06-25	0	0004968152			20150625.ifs	2015-06-25	2015-06-26
1894245	1894245	DIVIDEND	ADD	J00714105		A		3	0	50		53	2015-03-27	2015-03-31	2015-06-19	?		0	2015-06-24	?	0	0004968152			20150624.ifs	2015-06-24	2015-06-25
1813006	1813006	DIVIDEND	DELETE	J00714105		0	0	3	6	0		08	?	2015-03-31	?	2015-03-13		0	2015-03-13	?	0	0004968152			20150316.ifs	2015-03-16	2015-03-17
1811473	1811473	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2015-03-31	?	2015-03-13		0	2015-03-13	?	0	0004968152			20150313.ifs	2015-03-13	2015-03-14
1702600	1702600	DIVIDEND	DELETE	J00714105		A		3	0	45		53	2014-09-26	2014-09-30	2014-11-26	?		0	2014-12-05	?	0	0004842978			20141208.ifs	2014-12-08	2014-12-09
1702601	1702601	DIVIDEND	ADD	J00714105		A	0	3	0	45	0	53	2014-09-26	2014-09-30	2014-11-26	2014-09-15		0	?	2014-12-08	0	0004842978			20141208.ifs	2014-12-08	2014-12-09
1700577	1700577	DIVIDEND	ADD	J00714105		A		3	0	45		53	2014-09-26	2014-09-30	2014-11-26	?		0	2014-12-05	?	0	0004842978			20141205.ifs	2014-12-05	2014-12-06
1554407	1554407	DIVIDEND	DELETE	J00714105		A		3	0	60		53	2014-03-27	2014-03-31	2014-06-19	?		0	2014-06-19	?	0	0004748883			20140620.ifs	2014-06-20	2014-06-21
1554408	1554408	DIVIDEND	ADD	J00714105		A	0	3	0	60	0	53	2014-03-27	2014-03-31	2014-06-19	2014-03-07		0	?	2014-06-20	0	0004748883			20140620.ifs	2014-06-20	2014-06-21
1553249	1553249	DIVIDEND	ADD	J00714105		A		3	0	60		53	2014-03-27	2014-03-31	2014-06-19	?		0	2014-06-19	?	0	0004748883			20140619.ifs	2014-06-19	2014-06-20
1462253	1462253	DIVIDEND	ADD	J00714105		0	0	3	6	0		08	?	2014-03-31	?	2014-03-07		0	2014-03-07	?	0	0004748883			20140307.ifs	2014-03-07	2014-03-08
1346714	1346714	DIVIDEND	ADD	J00714105		A	0	3	0	35		53	2013-09-26	2013-09-30	2013-11-26	2013-09-05		0	?	2013-11-27	0	0004626649			20131127.ifs	2013-11-27	2013-11-28
1212440	1212440	DIVIDEND	ADD	J00714105		A	0	3	0	50		53	2013-03-29	2013-03-31	2013-06-19	2013-03-07		0	?	2013-06-20	0	0004539425			20130620.ifs	2013-06-20	2013-06-21
1016614	1016614	DIVIDEND	ADD	J00714105		A	0	3	0	25		53	2012-09-26	2012-09-30	2012-11-26	2012-09-12		0	?	2012-11-28	0	0004428460			20121128.ifs	2012-11-28	2012-11-29
568698	568698	DIVIDEND	DELETE	J00714105		A		3	0	25		53	?	2011-03-31	2011-06-22	?		0	2011-06-23	?	1	0004063583			20110624.ifs	2011-06-24	2011-06-25
568699	568699	DIVIDEND	ADD	J00714105		A	0	3	0	25	0	53	?	2011-03-31	2011-06-22	2010-09-23		0	?	2011-06-24	1	0004063583			20110624.ifs	2011-06-24	2011-06-25
567969	567969	DIVIDEND	ADD	J00714105		A		3	0	25		53	?	2011-03-31	2011-06-22	?		0	2011-06-23	?	1	0004063583			20110623.ifs	2011-06-23	2011-06-24
364106	364106	DIVIDEND	DELETE	J00714105		A		3	4	25		53	?	2010-09-30	2010-11-26	?		0	2010-11-29	?	0	0004061786			20101130.ifs	2010-11-30	2010-12-01
364107	364107	DIVIDEND	ADD	J00714105		A	0	3	4	25	0	53	?	2010-09-30	2010-11-26	2010-09-20		0	?	2010-11-30	0	0004061786			20101130.ifs	2010-11-30	2010-12-01
363387	363387	DIVIDEND	ADD	J00714105		A		3	4	25		53	?	2010-09-30	2010-11-26	?		0	2010-11-29	?	0	0004061786			20101129.ifs	2010-11-29	2010-11-30
313609	313609	DIVIDEND	DELETE	J00714105		0	0	3	4	0		08	?	2011-03-31	?	2010-09-23		0	2010-09-23	?	0	0004063583			20100924.ifs	2010-09-24	2010-09-25
312850	312850	DIVIDEND	ADD	J00714105		0	0	3	4	0		08	?	2011-03-31	?	2010-09-23		0	2010-09-23	?	0	0004063583			20100923.ifs	2010-09-23	2010-09-24
311520	311520	DIVIDEND	DELETE	J00714105		0	0	3	4	0		08	?	2010-09-30	?	2010-09-20		0	2010-09-20	?	0	0004061786			20100921.ifs	2010-09-21	2010-09-22
310553	310553	DIVIDEND	ADD	J00714105		0	0	3	4	0		08	?	2010-09-30	?	2010-09-20		0	2010-09-20	?	0	0004061786			20100920.ifs	2010-09-20	2010-09-21

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