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
5590262	5590262	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2024-03-31	?	2024-03-05		0	2024-03-05	?	0	0006888020			20240701.ifs	2024-07-01	2024-07-02
5590263	5590263	DIVIDEND	ADD	J75963108		A	0	3	0	22		53	?	2024-03-31	2024-06-24	2024-03-05		1	2024-03-05	2024-07-01	0	0006888020			20240701.ifs	2024-07-01	2024-07-02
5512840	5512840	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2024-03-31	?	2024-03-05		0	2024-03-05	?	0	0006888020			20240305.ifs	2024-03-05	2024-03-06
5432866	5432866	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2023-09-30	?	2023-09-06		0	2023-09-06	?	0	0006780502			20231208.ifs	2023-12-08	2023-12-09
5432867	5432867	DIVIDEND	ADD	J75963108		A	0	3	0	22		53	?	2023-09-30	2023-12-08	2023-09-06		1	2023-09-06	2023-12-08	0	0006780502			20231208.ifs	2023-12-08	2023-12-09
5368756	5368756	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2023-09-30	?	2023-09-06		0	2023-09-06	?	0	0006780502			20230906.ifs	2023-09-06	2023-09-07
5321346	5321346	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2023-03-31	?	2023-02-27		0	2023-02-27	?	0	0006685931			20230629.ifs	2023-06-29	2023-06-30
5321347	5321347	DIVIDEND	ADD	J75963108		A	0	3	0	22		53	?	2023-03-31	2023-06-22	2023-02-27		1	2023-02-27	2023-06-29	0	0006685931			20230629.ifs	2023-06-29	2023-06-30
5235241	5235241	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2023-03-31	?	2023-02-27		0	2023-02-27	?	0	0006685931			20230227.ifs	2023-02-27	2023-02-28
5161274	5161274	DIVIDEND	DELETE	J75963108		A	0	3	0	22		53	?	2022-09-30	2022-12-09	2022-08-24		1	2022-08-24	2022-12-09	0	0006572057			20221212.ifs	2022-12-12	2022-12-13
5161275	5161275	DIVIDEND	ADD	J75963108		A	0	3	0	22	0	53	?	2022-09-30	2022-12-09	2022-08-22		0	?	2022-12-12	0	0006572057			20221212.ifs	2022-12-12	2022-12-13
5159250	5159250	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2022-09-30	?	2022-08-24		0	2022-08-24	?	0	0006572057			20221209.ifs	2022-12-09	2022-12-10
5159251	5159251	DIVIDEND	ADD	J75963108		A	0	3	0	22		53	?	2022-09-30	2022-12-09	2022-08-24		1	2022-08-24	2022-12-09	0	0006572057			20221209.ifs	2022-12-09	2022-12-10
5081771	5081771	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2022-09-30	?	2022-08-24		0	2022-08-24	?	0	0006572057			20220824.ifs	2022-08-24	2022-08-25
5041779	5041779	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2022-03-31	?	2022-02-28		0	2022-02-28	?	0	0006485598			20220627.ifs	2022-06-27	2022-06-28
5041780	5041780	DIVIDEND	ADD	J75963108		A	0	3	0	22		53	?	2022-03-31	2022-06-27	2022-02-28		1	2022-02-28	2022-06-27	0	0006485598			20220627.ifs	2022-06-27	2022-06-28
4959106	4959106	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2022-03-31	?	2022-02-28		0	2022-02-28	?	0	0006485598			20220228.ifs	2022-02-28	2022-03-01
4875958	4875958	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2021-09-30	?	2021-09-02		0	2021-09-02	?	0	0006364450			20211210.ifs	2021-12-10	2021-12-11
4875959	4875959	DIVIDEND	ADD	J75963108		A	0	3	0	22		53	?	2021-09-30	2021-12-08	2021-09-02		1	2021-09-02	2021-12-10	0	0006364450			20211210.ifs	2021-12-10	2021-12-11
4796139	4796139	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2021-09-30	?	2021-09-02		0	2021-09-02	?	0	0006364450			20210902.ifs	2021-09-02	2021-09-03
4738527	4738527	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2021-03-31	?	2021-03-02		0	2021-03-02	?	0	0006274155			20210625.ifs	2021-06-25	2021-06-26
4738528	4738528	DIVIDEND	ADD	J75963108		A	0	3	0	22		53	?	2021-03-31	2021-06-24	2021-03-02		1	2021-03-02	2021-06-25	0	0006274155			20210625.ifs	2021-06-25	2021-06-26
4645440	4645440	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2021-03-31	?	2021-03-02		0	2021-03-02	?	0	0006274155			20210302.ifs	2021-03-02	2021-03-03
4543363	4543363	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2020-09-30	?	2020-09-02		0	2020-09-02	?	0	0006155052			20201215.ifs	2020-12-15	2020-12-16
4543364	4543364	DIVIDEND	ADD	J75963108		A	0	3	0	22		53	?	2020-09-30	2020-12-14	2020-09-02		1	2020-09-02	2020-12-15	0	0006155052			20201215.ifs	2020-12-15	2020-12-16
4455430	4455430	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2020-09-30	?	2020-09-02		0	2020-09-02	?	0	0006155052			20200902.ifs	2020-09-02	2020-09-03
4423134	4423134	CORPACTION	ADD	J75963108	66	#	2020-07-23	J75963108	66	2020-07-23															20200723.ifs	2020-07-23	2020-07-24
4423135	4423135	CORPACTIONAUX	ADD	J75963108	66	2020-07-23	SFTBF	SOFTBANK CORP	ORD	SFTBF	SOFTBANK GROUP CORP	ORD	?	2020-07-23											20200723.ifs	2020-07-23	2020-07-24
4423136	4423136	EXCHANGE	CHANGE	J75963108	66	2004-04-23	2020-07-22	SFTBF	0	0	2004-05-17	2020-03-20													20200723.ifs	2020-07-23	2020-07-24
4423137	4423136	EXCHANGE	CHANGE	J75963108	66	2004-04-23	2020-07-22	SFTBF	0	0	2004-05-17	2020-07-23													20200723.ifs	2020-07-23	2020-07-24
4401400	4401400	DIVIDEND	DELETE	J75963108		0	1	3	6	0		08	?	2020-03-31	?	2020-05-19		0	2020-05-19	?	0	0006066279			20200626.ifs	2020-06-26	2020-06-27
4401401	4401401	DIVIDEND	ADD	J75963108		A	1	3	0	22		53	?	2020-03-31	2020-06-26	2020-05-19		1	2020-05-19	2020-06-26	0	0006066279			20200626.ifs	2020-06-26	2020-06-27
4340250	4340250	DIVIDEND	ADD	J75963108		0	1	3	6	0		08	?	2020-03-31	?	2020-05-19		0	2020-05-19	?	0	0006066279			20200519.ifs	2020-05-19	2020-05-20
4340285	4340285	DIVIDEND	ADD	J75963108		0	1	3	6	0		08	?	2020-03-31	?	2020-05-19		0	2020-05-19	?	0	0006066279			20200519.ifs	2020-05-19	2020-05-20
4245311	4245311	EXCHANGE	CHANGE	J75963108	66	2004-04-23	2020-03-19	SFTBF	0	0	2004-05-17	?													20200320.ifs	2020-03-20	2020-03-21
4245312	4245312	EXCHANGE	CHANGE	J75963108	66	2004-04-23	2020-03-19	SFTBF	0	0	2004-05-17	?													20200320.ifs	2020-03-20	2020-03-21
4245313	4245312	EXCHANGE	CHANGE	J75963108	66	2004-04-23	2020-03-19	SFBQF	0	0	2004-05-17	2020-03-20													20200320.ifs	2020-03-20	2020-03-21
4245314	4245313	EXCHANGE	CHANGE	J75963108	66	2004-04-23	2020-03-19	SFBQF	0	0	2004-05-17	2020-03-20													20200320.ifs	2020-03-20	2020-03-21
4245323	4245323	EXCHANGE	CHANGE	J75963108	66	2004-04-23	2020-03-19	SFBQF	0	0	2004-05-17	2020-03-20													20200320.ifs	2020-03-20	2020-03-21
4245324	4245324	EXCHANGE	CHANGE	J75963108	66	2004-04-23	2020-03-19	SFBQF	0	0	2004-05-17	2020-03-20													20200320.ifs	2020-03-20	2020-03-21
4245325	4245324	EXCHANGE	CHANGE	J75963108	66	2004-04-23	2020-03-19	SFTBF	0	0	2004-05-17	2020-03-20													20200320.ifs	2020-03-20	2020-03-21
4245326	4245325	EXCHANGE	CHANGE	J75963108	66	2004-04-23	2020-03-19	SFTBF	0	0	2004-05-17	2020-03-20													20200320.ifs	2020-03-20	2020-03-21
3912807	3912807	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2019-09-30	?	2019-09-05		0	2019-09-05	?	0	0005941897			20190905.ifs	2019-09-05	2019-09-06
3912810	3912810	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2019-09-30	?	2019-09-05		0	2019-09-05	?	0	0005941897			20190905.ifs	2019-09-05	2019-09-06
3791988	3791988	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2019-03-31	?	2019-03-06		0	2019-03-06	?	0	0005850382			20190621.ifs	2019-06-21	2019-06-22
3791989	3791989	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2019-03-31	?	2019-03-06		0	2019-03-06	?	0	0005850382			20190621.ifs	2019-06-21	2019-06-22
3791990	3791990	DIVIDEND	ADD	J75963108		A	0	3	0	22		53	?	2019-03-31	2019-06-20	2019-03-06		1	2019-03-06	2019-06-21	0	0005850382			20190621.ifs	2019-06-21	2019-06-22
3791991	3791991	DIVIDEND	ADD	J75963108		A	0	3	0	22		53	?	2019-03-31	2019-06-20	2019-03-06		1	2019-03-06	2019-06-21	0	0005850382			20190621.ifs	2019-06-21	2019-06-22
3770982	3770982	DIVIDEND	ADD	J75963108		0	0	6	0	1		11	?	2019-06-27	2019-06-28	2019-06-07		0	2019-06-07	?	0	0005895579			20190607.ifs	2019-06-07	2019-06-08
3770986	3770986	DIVIDEND	ADD	J75963108		0	0	6	0	1		11	?	2019-06-27	2019-06-28	2019-06-07		0	2019-06-07	?	0	0005895579			20190607.ifs	2019-06-07	2019-06-08
3617082	3617082	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2019-03-31	?	2019-03-06		0	2019-03-06	?	0	0005850382			20190306.ifs	2019-03-06	2019-03-07
3617083	3617083	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2019-03-31	?	2019-03-06		0	2019-03-06	?	0	0005850382			20190306.ifs	2019-03-06	2019-03-07
3416190	3416190	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2018-09-30	?	2018-09-04		0	2018-09-04	?	0	0005717717			20181210.ifs	2018-12-10	2018-12-11
3416192	3416192	DIVIDEND	ADD	J75963108		A	0	3	0	22		53	?	2018-09-30	2018-12-10	2018-09-04		1	2018-09-04	2018-12-10	0	0005717717			20181210.ifs	2018-12-10	2018-12-11
3416193	3416193	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2018-09-30	?	2018-09-04		0	2018-09-04	?	0	0005717717			20181210.ifs	2018-12-10	2018-12-11
3416195	3416195	DIVIDEND	ADD	J75963108		A	0	3	0	22		53	?	2018-09-30	2018-12-10	2018-09-04		1	2018-09-04	2018-12-10	0	0005717717			20181210.ifs	2018-12-10	2018-12-11
3260524	3260524	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2018-09-30	?	2018-09-04		0	2018-09-04	?	0	0005717717			20180904.ifs	2018-09-04	2018-09-05
3260797	3260797	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2018-09-30	?	2018-09-04		0	2018-09-04	?	0	0005717717			20180904.ifs	2018-09-04	2018-09-05
3153408	3153408	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	2018-03-28	2018-03-31	?	2018-03-08		1	2018-03-08	2018-03-12	0	0005627743			20180622.ifs	2018-06-22	2018-06-23
3153409	3153409	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	2018-03-28	2018-03-31	?	2018-03-08		1	2018-03-08	2018-03-12	0	0005627743			20180622.ifs	2018-06-22	2018-06-23
3153410	3153410	DIVIDEND	ADD	J75963108		A	0	3	0	22		53	2018-03-28	2018-03-31	2018-06-21	2018-03-08		2	2018-03-08	2018-06-22	0	0005627743			20180622.ifs	2018-06-22	2018-06-23
3153411	3153411	DIVIDEND	ADD	J75963108		A	0	3	0	22		53	2018-03-28	2018-03-31	2018-06-21	2018-03-08		2	2018-03-08	2018-06-22	0	0005627743			20180622.ifs	2018-06-22	2018-06-23
2987948	2987948	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2018-03-31	?	2018-03-08		0	2018-03-08	?	0	0005627743			20180312.ifs	2018-03-12	2018-03-13
2987950	2987950	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	2018-03-28	2018-03-31	?	2018-03-08		1	2018-03-08	2018-03-12	0	0005627743			20180312.ifs	2018-03-12	2018-03-13
2988032	2988032	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2018-03-31	?	2018-03-08		0	2018-03-08	?	0	0005627743			20180312.ifs	2018-03-12	2018-03-13
2988034	2988034	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	2018-03-28	2018-03-31	?	2018-03-08		1	2018-03-08	2018-03-12	0	0005627743			20180312.ifs	2018-03-12	2018-03-13
2985226	2985226	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2018-03-31	?	2018-03-08		0	2018-03-08	?	0	0005627743			20180308.ifs	2018-03-08	2018-03-09
2985306	2985306	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2018-03-31	?	2018-03-08		0	2018-03-08	?	0	0005627743			20180308.ifs	2018-03-08	2018-03-09
2824313	2824313	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	2017-09-27	2017-09-30	?	2017-09-13		1	2017-09-13	2017-09-14	0	0005496100			20171213.ifs	2017-12-13	2017-12-14
2824315	2824315	DIVIDEND	ADD	J75963108		A	0	3	0	22		53	2017-09-27	2017-09-30	2017-12-11	2017-09-13		2	2017-09-13	2017-12-13	0	0005496100			20171213.ifs	2017-12-13	2017-12-14
2824410	2824410	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	2017-09-27	2017-09-30	?	2017-09-13		1	2017-09-13	2017-09-14	0	0005496100			20171213.ifs	2017-12-13	2017-12-14
2824412	2824412	DIVIDEND	ADD	J75963108		A	0	3	0	22		53	2017-09-27	2017-09-30	2017-12-11	2017-09-13		2	2017-09-13	2017-12-13	0	0005496100			20171213.ifs	2017-12-13	2017-12-14
2669793	2669793	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2017-09-30	?	2017-09-13		0	2017-09-13	?	0	0005496100			20170914.ifs	2017-09-14	2017-09-15
2669795	2669795	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	2017-09-27	2017-09-30	?	2017-09-13		1	2017-09-13	2017-09-14	0	0005496100			20170914.ifs	2017-09-14	2017-09-15
2670207	2670207	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2017-09-30	?	2017-09-13		0	2017-09-13	?	0	0005496100			20170914.ifs	2017-09-14	2017-09-15
2670209	2670209	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	2017-09-27	2017-09-30	?	2017-09-13		1	2017-09-13	2017-09-14	0	0005496100			20170914.ifs	2017-09-14	2017-09-15
2599338	2599338	DIVIDEND	ADD	J75963108		A	0	3	0	22		53	2017-03-29	2017-03-31	2017-06-22	2017-03-06		0	?	2017-06-23	0	0005400334			20170623.ifs	2017-06-23	2017-06-24
2453588	2453588	EQUITY	CHANGE	J75963108	ORD	0	0	1997-10-09	?	0	no	no		no		1997-11-04	1997-10-10	?							20170124.ifs	2017-01-24	2017-01-25
2453589	2453588	EQUITY	CHANGE	J75963108	ORD	0	0	1997-10-09	?	2	no	no		no		1997-11-04	1997-10-10	?							20170124.ifs	2017-01-24	2017-01-25
2372719	2372719	DIVIDEND	DELETE	J75963108		A		3	0	22		53	2016-09-28	2016-09-30	2016-12-12	?		0	2016-12-13	?	0	0005268688			20161214.ifs	2016-12-14	2016-12-15
2372720	2372720	DIVIDEND	ADD	J75963108		A	0	3	0	22	0	53	2016-09-28	2016-09-30	2016-12-12	2016-08-24		0	?	2016-12-14	0	0005268688			20161214.ifs	2016-12-14	2016-12-15
2370213	2370213	DIVIDEND	ADD	J75963108		A		3	0	22		53	2016-09-28	2016-09-30	2016-12-12	?		0	2016-12-13	?	0	0005268688			20161213.ifs	2016-12-13	2016-12-14
2250061	2250061	DIVIDEND	DELETE	J75963108		A		3	0	21		53	2016-03-29	2016-03-31	2016-06-23	?		0	2016-07-12	?	0	0005184877			20160713.ifs	2016-07-13	2016-07-14
2250062	2250062	DIVIDEND	ADD	J75963108		A	0	3	0	21	0	53	2016-03-29	2016-03-31	2016-06-23	2016-03-04		0	?	2016-07-13	0	0005184877			20160713.ifs	2016-07-13	2016-07-14
2249647	2249647	DIVIDEND	ADD	J75963108		A		3	0	21		53	2016-03-29	2016-03-31	2016-06-23	?		0	2016-07-12	?	0	0005184877			20160712.ifs	2016-07-12	2016-07-13
2131194	2131194	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2016-03-31	?	2016-03-04		0	2016-03-04	?	0	0005184877			20160307.ifs	2016-03-07	2016-03-08
2130503	2130503	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2016-03-31	?	2016-03-04		0	2016-03-04	?	0	0005184877			20160304.ifs	2016-03-04	2016-03-05
2041937	2041937	DIVIDEND	ADD	J75963108		A	0	3	0	20		53	2015-09-28	2015-09-30	2015-12-14	2015-09-10		0	?	2015-12-16	0	0005060960			20151216.ifs	2015-12-16	2015-12-17
2016012	2016012	DIVIDEND	CHANGE	J75963108		A	0	3	0	20	0	53	2015-03-27	2015-03-31	2015-06-22	2015-07-01		0	?	2015-07-02	0	0004967729			20151127.ifs	2015-11-27	2015-11-28
2016013	2016012	DIVIDEND	CHANGE	J75963108		A	0	3	0	20	0	53	2015-03-27	2015-03-31	2015-06-22	2015-07-01		0	?	2015-11-27	0	0004967729			20151127.ifs	2015-11-27	2015-11-28
1909545	1909545	DIVIDEND	DELETE	J75963108		A		3	0	20		53	2015-03-27	2015-03-31	2015-06-22	?		0	2015-07-01	?	0	0004967729			20150702.ifs	2015-07-02	2015-07-03
1909546	1909546	DIVIDEND	ADD	J75963108		A	0	3	0	20	0	53	2015-03-27	2015-03-31	2015-06-22	2015-07-01		0	?	2015-07-02	0	0004967729			20150702.ifs	2015-07-02	2015-07-03
1905190	1905190	DIVIDEND	ADD	J75963108		A		3	0	20		53	2015-03-27	2015-03-31	2015-06-22	?		0	2015-07-01	?	0	0004967729			20150701.ifs	2015-07-01	2015-07-02
1738903	1738903	DIVIDEND	ADD	J75963108		A	0	3	0	20		53	?	2014-09-30	2014-12-15	2014-09-12		0	?	2014-12-23	0	0004842633			20141223.ifs	2014-12-23	2014-12-24
1739226	1739226	DIVIDEND	DELETE	J75963108		A	0	3	0	20		53	?	2014-09-30	2014-12-15	2014-09-12		0	?	2014-12-23	0	0004842633			20141223.ifs	2014-12-23	2014-12-24
1739227	1739227	DIVIDEND	ADD	J75963108		A	0	3	0	20		53	2014-09-26	2014-09-30	2014-12-15	2014-09-12		0	?	2014-12-23	0	0004842633			20141223.ifs	2014-12-23	2014-12-24
1560765	1560765	DIVIDEND	DELETE	J75963108		A		3	0	20		53	?	2014-03-31	2014-06-23	?		0	2014-06-25	?	0	0004750914			20140626.ifs	2014-06-26	2014-06-27
1560766	1560766	DIVIDEND	ADD	J75963108		A	0	3	0	20	0	53	?	2014-03-31	2014-06-23	2014-03-14		0	?	2014-06-26	0	0004750914			20140626.ifs	2014-06-26	2014-06-27
1560065	1560065	DIVIDEND	ADD	J75963108		A		3	0	20		53	?	2014-03-31	2014-06-23	?		0	2014-06-25	?	0	0004750914			20140625.ifs	2014-06-25	2014-06-26
1469361	1469361	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2014-03-31	?	2014-03-14		0	2014-03-14	?	0	0004750914			20140318.ifs	2014-03-18	2014-03-19
1466549	1466549	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2014-03-31	?	2014-03-14		0	2014-03-14	?	0	0004750914			20140314.ifs	2014-03-14	2014-03-15
1394429	1394429	DIVIDEND	ADD	J75963108		A	0	3	0	20		53	2013-09-26	2013-09-30	2013-12-16	2013-09-06		0	?	2013-12-24	0	0004626736			20131224.ifs	2013-12-24	2013-12-25
1234334	1234334	DIVIDEND	ADD	J75963108		A	0	3	0	20		53	?	2013-03-31	2013-06-24	2013-03-08		0	?	2013-07-03	0	0004539897			20130703.ifs	2013-07-03	2013-07-04
1045941	1045941	DIVIDEND	DELETE	J75963108		A		3	0	20		53	?	2012-09-30	2012-12-14	?		0	2012-12-17	?	0	0004428379			20121218.ifs	2012-12-18	2012-12-19
1045942	1045942	DIVIDEND	ADD	J75963108		A	0	3	0	20	0	53	?	2012-09-30	2012-12-14	2012-09-11		0	?	2012-12-18	0	0004428379			20121218.ifs	2012-12-18	2012-12-19
1046481	1046481	DIVIDEND	DELETE	J75963108		A	0	3	0	20	0	53	?	2012-09-30	2012-12-14	2012-09-11		0	?	2012-12-18	0	0004428379			20121218.ifs	2012-12-18	2012-12-19
1046482	1046482	DIVIDEND	ADD	J75963108		A	0	3	0	20	0	53	2012-09-26	2012-09-30	2012-12-14	2012-09-11		0	?	2012-12-18	0	0004428379			20121218.ifs	2012-12-18	2012-12-19
1043559	1043559	DIVIDEND	ADD	J75963108		A		3	0	20		53	?	2012-09-30	2012-12-14	?		0	2012-12-17	?	0	0004428379			20121217.ifs	2012-12-17	2012-12-18
954980	954980	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2012-09-30	?	2012-09-11		0	2012-09-11	?	0	0004428379			20120912.ifs	2012-09-12	2012-09-13
953948	953948	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2012-09-30	?	2012-09-11		0	2012-09-11	?	0	0004428379			20120911.ifs	2012-09-11	2012-09-12
910174	910174	DIVIDEND	DELETE	J75963108		A	0	3	0	40		53	?	2012-03-29	2012-06-25	2012-03-15		0	?	2012-06-29	0	0004345561			20120709.ifs	2012-07-09	2012-07-10
910175	910175	DIVIDEND	ADD	J75963108		A	0	3	0	40		53	2012-03-28	2012-03-30	2012-06-25	2012-03-15		0	?	2012-07-09	0	0004345561			20120709.ifs	2012-07-09	2012-07-10
897484	897484	DIVIDEND	ADD	J75963108		A	0	3	0	40		53	?	2012-03-29	2012-06-25	2012-03-15		0	?	2012-06-29	0	0004345561			20120629.ifs	2012-06-29	2012-06-30
639324	639324	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2011-09-30	?	2011-09-07		0	2011-09-07	?	0	0004240782			20110908.ifs	2011-09-08	2011-09-09
638126	638126	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2011-09-30	?	2011-09-07		0	2011-09-07	?	0	0004240782			20110907.ifs	2011-09-07	2011-09-08
571171	571171	DIVIDEND	DELETE	J75963108		A		3	0	5		44	?	2011-03-31	2011-06-27	?		0	2011-06-27	?	0	0004138625			20110628.ifs	2011-06-28	2011-06-29
571172	571172	DIVIDEND	ADD	J75963108		A	0	3	0	5	0	44	?	2011-03-31	2011-06-27	2011-01-31		0	?	2011-06-28	0	0004138625			20110628.ifs	2011-06-28	2011-06-29
570568	570568	DIVIDEND	ADD	J75963108		A		3	0	5		44	?	2011-03-31	2011-06-27	?		0	2011-06-27	?	0	0004138625			20110627.ifs	2011-06-27	2011-06-28
430572	430572	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2011-03-31	?	2011-01-31		0	2011-01-31	?	0	0004138625			20110201.ifs	2011-02-01	2011-02-02
428406	428406	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2011-03-31	?	2011-01-31		0	2011-01-31	?	0	0004138625			20110131.ifs	2011-01-31	2011-02-01
304892	304892	DIVIDEND	DELETE	J75963108		0	0	3	6	0		08	?	2010-09-30	?	2010-09-09		0	2010-09-09	?	0	0004059201			20100910.ifs	2010-09-10	2010-09-11
304390	304390	DIVIDEND	ADD	J75963108		0	0	3	6	0		08	?	2010-09-30	?	2010-09-09		0	2010-09-09	?	0	0004059201			20100909.ifs	2010-09-09	2010-09-10

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