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
5562627	5562627	DIVIDEND	ADD	S08470189		A	0	3	0	2.1		53	?	2024-06-21	2024-06-24	2024-05-28		0	2024-05-28	?	0	0006922253			20240528.ifs	2024-05-28	2024-05-29
5416572	5416572	DIVIDEND	ADD	S08470189		A	0	3	0	3		53	?	2024-01-05	2024-01-08	2023-11-20		0	2023-11-20	?	0	0006813223			20231120.ifs	2023-11-20	2023-11-21
5294643	5294643	DIVIDEND	ADD	S08470189		A	0	3	0	2		53	?	2023-06-23	2023-06-26	2023-05-22		0	2023-05-22	?	0	0006727374			20230522.ifs	2023-05-22	2023-05-23
5142055	5142055	DIVIDEND	ADD	S08470189		A	0	3	9	5.5		41	?	2023-01-06	2023-01-09	2022-11-21		0	2022-11-21	?	1	0006614236			20221121.ifs	2022-11-21	2022-11-22
5142056	5142056	DIVIDEND	ADD	S08470189		A	0	3	0	2.95		53	?	2023-01-06	2023-01-09	2022-11-21		0	2022-11-21	?	0	0006614228			20221121.ifs	2022-11-21	2022-11-22
5021088	5021088	DIVIDEND	DELETE	S08470189		A	0	3	0	1.65		53	?	2022-06-24	2022-06-27	2022-05-31		0	2022-05-31	?	0	0006528695			20220601.ifs	2022-06-01	2022-06-02
5021089	5021089	DIVIDEND	ADD	S08470189		A	0	3	0	1.65	0	53	?	2022-06-24	2022-06-27	2022-05-27		0	?	2022-06-01	0	0006528695			20220601.ifs	2022-06-01	2022-06-02
5020033	5020033	DIVIDEND	ADD	S08470189		A	0	3	0	1.65		53	?	2022-06-24	2022-06-27	2022-05-31		0	2022-05-31	?	0	0006528695			20220531.ifs	2022-05-31	2022-06-01
4851043	4851043	DIVIDEND	ADD	S08470189		A	0	3	9	11.5		41	?	2022-01-07	2022-01-10	2021-11-22		0	2021-11-22	?	1	0006398211			20211122.ifs	2021-11-22	2021-11-23
4851044	4851044	DIVIDEND	ADD	S08470189		A	0	3	0	3		53	?	2022-01-07	2022-01-10	2021-11-22		0	2021-11-22	?	0	0006398209			20211122.ifs	2021-11-22	2021-11-23
4817192	4817192	CORPACTION	ADD	S08470189	66	D	2021-10-01			?															20211001.ifs	2021-10-01	2021-10-02
4817193	4817193	EQUITY	CHANGE	S08470189	ORD	0	0	2007-03-12	?	2	no	no		no		2007-03-13	2007-07-16	?							20211001.ifs	2021-10-01	2021-10-02
4817194	4817193	EQUITY	CHANGE	S08470189	ORD	D	0	2007-03-12	2021-10-01	2	no	no		no		2007-03-13	2021-10-01	?							20211001.ifs	2021-10-01	2021-10-02
4817281	4817281	CORPACTION	DELETE	S08470189	66	D	2021-10-01			?															20211001.ifs	2021-10-01	2021-10-02
4817282	4817282	EQUITY	CHANGE	S08470189	ORD	D	0	2007-03-12	2021-10-01	2	no	no		no		2007-03-13	2021-10-01	?							20211001.ifs	2021-10-01	2021-10-02
4817283	4817282	EQUITY	CHANGE	S08470189	ORD	0	0	2007-03-12	?	2	no	no		no		2007-03-13	2021-10-01	?							20211001.ifs	2021-10-01	2021-10-02
4024082	4024082	DIVIDEND	ADD	S08470189		A	0	3	9	2.28		41	?	2020-01-10	2020-01-13	2019-11-22		0	2019-11-22	?	1	0005977592			20191122.ifs	2019-11-22	2019-11-23
4024084	4024084	DIVIDEND	ADD	S08470189		A	0	3	0	2.97		53	?	2020-01-10	2020-01-13	2019-11-22		0	2019-11-22	?	0	0005977589			20191122.ifs	2019-11-22	2019-11-23
4024127	4024127	DIVIDEND	ADD	S08470189		A	0	3	9	2.28		41	?	2020-01-10	2020-01-13	2019-11-22		0	2019-11-22	?	1	0005977592			20191122.ifs	2019-11-22	2019-11-23
4024129	4024129	DIVIDEND	ADD	S08470189		A	0	3	0	2.97		53	?	2020-01-10	2020-01-13	2019-11-22		0	2019-11-22	?	0	0005977589			20191122.ifs	2019-11-22	2019-11-23
3772908	3772908	DIVIDEND	CHANGE	S08470189		A	0	3	0	1.65		53	?	2019-06-07	2019-06-10	2019-05-28		0	2019-05-28	?	0	0005886938			20190610.ifs	2019-06-10	2019-06-11
3772910	3772909	DIVIDEND	CHANGE	S08470189		A	0	3	0	1.65		53	?	2019-06-07	2019-06-10	2019-05-28		1	2019-05-28	2019-06-10	0	0005886938			20190610.ifs	2019-06-10	2019-06-11
3772913	3772913	DIVIDEND	CHANGE	S08470189		A	0	3	0	1.65		53	?	2019-06-07	2019-06-10	2019-05-28		0	2019-05-28	?	0	0005886938			20190610.ifs	2019-06-10	2019-06-11
3772914	3772913	DIVIDEND	CHANGE	S08470189		A	0	3	0	1.65		53	?	2019-06-07	2019-06-10	2019-05-28		1	2019-05-28	2019-06-10	0	0005886938			20190610.ifs	2019-06-10	2019-06-11
3739851	3739851	DIVIDEND	ADD	S08470189		A	0	3	0	1.65		53	?	2019-06-07	2019-06-10	2019-05-28		0	2019-05-28	?	0	0005886938			20190528.ifs	2019-05-28	2019-05-29
3739875	3739875	DIVIDEND	ADD	S08470189		A	0	3	0	1.65		53	?	2019-06-07	2019-06-10	2019-05-28		0	2019-05-28	?	0	0005886938			20190528.ifs	2019-05-28	2019-05-29
3549123	3549123	DIVIDEND	CHANGE	S08470189		A	0	3	0	3.17		53	?	2019-01-11	2019-01-14	2018-11-19		0	2018-11-19	?	0	0005755834			20190114.ifs	2019-01-14	2019-01-15
3549124	3549124	DIVIDEND	CHANGE	S08470189		A	0	3	0	3.17		53	?	2019-01-11	2019-01-14	2018-11-19		0	2018-11-19	?	0	0005755834			20190114.ifs	2019-01-14	2019-01-15
3549125	3549124	DIVIDEND	CHANGE	S08470189		A	0	3	0	3.17		53	?	2019-01-11	2019-01-14	2018-11-19		1	2018-11-19	2019-01-14	0	0005755834			20190114.ifs	2019-01-14	2019-01-15
3549126	3549125	DIVIDEND	CHANGE	S08470189		A	0	3	0	3.17		53	?	2019-01-11	2019-01-14	2018-11-19		1	2018-11-19	2019-01-14	0	0005755834			20190114.ifs	2019-01-14	2019-01-15
3374835	3374835	DIVIDEND	ADD	S08470189		A	0	3	0	3.17		53	?	2019-01-11	2019-01-14	2018-11-19		0	2018-11-19	?	0	0005755834			20181119.ifs	2018-11-19	2018-11-20
3374836	3374836	DIVIDEND	ADD	S08470189		A	0	3	0	3.17		53	?	2019-01-11	2019-01-14	2018-11-19		0	2018-11-19	?	0	0005755834			20181119.ifs	2018-11-19	2018-11-20
3134773	3134773	DIVIDEND	CHANGE	S08470189		A	0	3	0	1.45		53	?	2018-06-08	2018-06-11	2018-05-21		0	2018-05-21	?	0	0005662840			20180612.ifs	2018-06-12	2018-06-13
3134775	3134774	DIVIDEND	CHANGE	S08470189		A	0	3	0	1.45		53	?	2018-06-08	2018-06-11	2018-05-21		1	2018-05-21	2018-06-12	0	0005662840			20180612.ifs	2018-06-12	2018-06-13
3134892	3134892	DIVIDEND	CHANGE	S08470189		A	0	3	0	1.45		53	?	2018-06-08	2018-06-11	2018-05-21		0	2018-05-21	?	0	0005662840			20180612.ifs	2018-06-12	2018-06-13
3134894	3134893	DIVIDEND	CHANGE	S08470189		A	0	3	0	1.45		53	?	2018-06-08	2018-06-11	2018-05-21		1	2018-05-21	2018-06-12	0	0005662840			20180612.ifs	2018-06-12	2018-06-13
3096217	3096217	DIVIDEND	ADD	S08470189		A	0	3	0	1.45		53	?	2018-06-08	2018-06-11	2018-05-21		0	2018-05-21	?	0	0005662840			20180521.ifs	2018-05-21	2018-05-22
3096218	3096218	DIVIDEND	ADD	S08470189		A	0	3	0	1.45		53	?	2018-06-08	2018-06-11	2018-05-21		0	2018-05-21	?	0	0005662840			20180521.ifs	2018-05-21	2018-05-22
2920253	2920253	DIVIDEND	CHANGE	S08470189		A	0	3	0	2.65		53	2018-01-10	2018-01-12	2018-01-15	2017-11-20		0	2017-11-20	?	0	0005531239			20180117.ifs	2018-01-17	2018-01-18
2920254	2920254	DIVIDEND	CHANGE	S08470189		A	0	3	0	2.65		53	2018-01-10	2018-01-12	2018-01-15	2017-11-20		0	2017-11-20	?	0	0005531239			20180117.ifs	2018-01-17	2018-01-18
2920255	2920254	DIVIDEND	CHANGE	S08470189		A	0	3	0	2.65		53	2018-01-10	2018-01-12	2018-01-15	2017-11-20		1	2017-11-20	2018-01-17	0	0005531239			20180117.ifs	2018-01-17	2018-01-18
2920256	2920255	DIVIDEND	CHANGE	S08470189		A	0	3	0	2.65		53	2018-01-10	2018-01-12	2018-01-15	2017-11-20		1	2017-11-20	2018-01-17	0	0005531239			20180117.ifs	2018-01-17	2018-01-18
2770501	2770501	DIVIDEND	ADD	S08470189		A	0	3	0	2.65		53	2018-01-10	2018-01-12	2018-01-15	2017-11-20		0	2017-11-20	?	0	0005531239			20171120.ifs	2017-11-20	2017-11-21
2591351	2591351	DIVIDEND	CHANGE	S08470189		A	0	3	0	1.25		53	2017-06-07	2017-06-09	2017-06-12	2017-05-15		0	2017-05-15	?	0	0005435349			20170615.ifs	2017-06-15	2017-06-16
2591352	2591351	DIVIDEND	CHANGE	S08470189		A	0	3	0	1.25		53	2017-06-07	2017-06-09	2017-06-12	2017-05-15		1	2017-05-15	2017-06-15	0	0005435349			20170615.ifs	2017-06-15	2017-06-16
2567625	2567625	DIVIDEND	ADD	S08470189		A	0	3	0	1.25		53	2017-06-07	2017-06-09	2017-06-12	2017-05-15		0	2017-05-15	?	0	0005435349			20170515.ifs	2017-05-15	2017-05-16
2453830	2453830	EQUITY	CHANGE	S08470189	ORD	0	0	2007-03-12	?	0	no	no		no		2007-03-13	2007-07-16	?							20170124.ifs	2017-01-24	2017-01-25
2453831	2453830	EQUITY	CHANGE	S08470189	ORD	0	0	2007-03-12	?	2	no	no		no		2007-03-13	2007-07-16	?							20170124.ifs	2017-01-24	2017-01-25
2428316	2428316	DIVIDEND	CHANGE	S08470189		A	0	3	0	2.3		53	2017-01-11	2017-01-13	2017-01-16	2017-01-03		0	2017-01-03	?	0	0005369052			20170119.ifs	2017-01-19	2017-01-20
2428317	2428316	DIVIDEND	CHANGE	S08470189		A	0	3	0	2.3		53	2017-01-11	2017-01-13	2017-01-16	2017-01-03		1	2017-01-03	2017-01-19	0	0005369052			20170119.ifs	2017-01-19	2017-01-20
2414265	2414265	DIVIDEND	ADD	S08470189		A	0	3	0	2.3		53	2017-01-11	2017-01-13	2017-01-16	2017-01-03		0	2017-01-03	?	0	0005369052			20170103.ifs	2017-01-03	2017-01-04
2226251	2226251	DIVIDEND	CHANGE	S08470189		A	0	3	0	1.15		53	2016-06-06	2016-06-10	2016-06-13	2016-05-26		1	2016-05-26	2016-05-27	0	0005221995			20160621.ifs	2016-06-21	2016-06-22
2226252	2226251	DIVIDEND	CHANGE	S08470189		A	0	3	0	1.15		53	2016-06-06	2016-06-10	2016-06-13	2016-05-26		2	2016-05-26	2016-06-21	0	0005221995			20160621.ifs	2016-06-21	2016-06-22
2204575	2204575	DIVIDEND	CHANGE	S08470189		A	0	3	0	1.15		53	2016-06-06	2016-06-10	2016-06-13	2016-05-26		0	2016-05-26	?	0	0005221995			20160527.ifs	2016-05-27	2016-05-28
2204576	2204575	DIVIDEND	CHANGE	S08470189		A	0	3	0	1.15		53	2016-06-06	2016-06-10	2016-06-13	2016-05-26		1	2016-05-26	2016-05-27	0	0005221995			20160527.ifs	2016-05-27	2016-05-28
2203611	2203611	DIVIDEND	ADD	S08470189		A	0	3	0	1.15		53	2016-06-06	2016-06-10	2016-06-13	2016-05-26		0	2016-05-26	?	0	0005221995			20160526.ifs	2016-05-26	2016-05-27
2096132	2096132	DIVIDEND	CHANGE	S08470189		A	0	3	0	2.3		53	2016-01-11	2016-01-15	2016-01-18	2015-11-16		0	2015-11-16	?	0	0005093529			20160121.ifs	2016-01-21	2016-01-22
2096133	2096132	DIVIDEND	CHANGE	S08470189		A	0	3	0	2.3		53	2016-01-11	2016-01-15	2016-01-18	2015-11-16		1	2015-11-16	2016-01-21	0	0005093529			20160121.ifs	2016-01-21	2016-01-22
2009433	2009433	DIVIDEND	ADD	S08470189		A	0	3	0	2.3		53	2016-01-11	2016-01-15	2016-01-18	2015-11-16		0	2015-11-16	?	0	0005093529			20151116.ifs	2015-11-16	2015-11-17
1865656	1865656	DIVIDEND	CHANGE	S08470189		A	0	3	0	1.15		53	2015-06-08	2015-06-12	2015-06-15	2015-05-18		0	2015-05-18	?	0	0005001001			20150519.ifs	2015-05-19	2015-05-20
1865657	1865656	DIVIDEND	CHANGE	S08470189		A	0	3	0	1.15		53	2015-06-08	2015-06-12	2015-06-15	2015-05-18		1	2015-05-18	2015-05-19	0	0005001001			20150519.ifs	2015-05-19	2015-05-20
1865012	1865012	DIVIDEND	ADD	S08470189		A	0	3	0	1.15		53	2015-06-08	2015-06-12	2015-06-15	2015-05-18		0	2015-05-18	?	0	0005001001			20150518.ifs	2015-05-18	2015-05-19
1775200	1775200	DIVIDEND	CHANGE	S08470189		A	0	3	0	2.14		53	2015-01-19	2015-01-23	2015-01-26	2014-12-23		0	2014-12-23	?	0	0004918305			20150127.ifs	2015-01-27	2015-01-28
1775201	1775200	DIVIDEND	CHANGE	S08470189		A	0	3	0	2.14		53	2015-01-19	2015-01-23	2015-01-26	2014-12-23		1	2014-12-23	2015-01-27	0	0004918305			20150127.ifs	2015-01-27	2015-01-28
1739213	1739213	DIVIDEND	ADD	S08470189		A	0	3	0	2.14		53	2015-01-19	2015-01-23	2015-01-26	2014-12-23		0	2014-12-23	?	0	0004918305			20141223.ifs	2014-12-23	2014-12-24
1552141	1552141	DIVIDEND	CHANGE	S08470189		A	0	3	0	1.06		53	2014-06-09	2014-06-13	2014-06-17	2014-05-20		0	2014-05-20	?	0	0004783639			20140618.ifs	2014-06-18	2014-06-19
1552142	1552141	DIVIDEND	CHANGE	S08470189		A	0	3	0	1.06		53	2014-06-09	2014-06-13	2014-06-17	2014-05-20		1	2014-05-20	2014-06-18	0	0004783639			20140618.ifs	2014-06-18	2014-06-19
1526513	1526513	DIVIDEND	ADD	S08470189		A	0	3	0	1.06		53	2014-06-09	2014-06-13	2014-06-17	2014-05-20		0	2014-05-20	?	0	0004783639			20140520.ifs	2014-05-20	2014-05-21
1341195	1341195	DIVIDEND	ADD	S08470189		A	0	3	0	1.95		53	2014-01-13	2014-01-17	2014-01-20	2013-11-18		0	2013-11-18	?	0	0004658508			20131118.ifs	2013-11-18	2013-11-19
1188811	1188811	DIVIDEND	ADD	S08470189		A	0	3	0	.96		53	2013-06-10	2013-06-14	2013-06-18	2013-05-20		0	2013-05-20	?	0	0004572174			20130520.ifs	2013-05-20	2013-05-21
1089546	1089546	DIVIDEND	ADD	S08470189		A	1	3	0	1.467534		53	2013-01-07	2013-01-11	2013-01-14	2013-01-14		0	2013-01-14	?	0	0004514910			20130114.ifs	2013-01-14	2013-01-15
1089547	1089547	DIVIDEND	DELETE	S08470189		A	0	3	0	.032466		53	2013-01-07	2013-01-11	2013-01-14	2012-12-18		0	2012-12-18	?	0	0004484347			20130114.ifs	2013-01-14	2013-01-15
1089548	1089548	DIVIDEND	ADD	S08470189		6	0	3	0	.032466		28	2013-01-07	2013-01-11	2013-01-14	2012-12-18		1	2012-12-18	2013-01-14	1	0004484347			20130114.ifs	2013-01-14	2013-01-15
1046473	1046473	DIVIDEND	ADD	S08470189		A	0	3	0	.032466		53	2013-01-07	2013-01-11	2013-01-14	2012-12-18		0	2012-12-18	?	0	0004484347			20121218.ifs	2012-12-18	2012-12-19
880001	880001	DIVIDEND	ADD	S08470189		A	0	3	0	.8		53	2012-06-11	2012-06-15	2012-06-18	2012-06-05		0	2012-06-05	?	0	0004384723			20120605.ifs	2012-06-05	2012-06-06
734749	734749	DIVIDEND	ADD	S08470189		6	0	3	0	1.05		28	2012-01-09	2012-01-13	2012-01-16	2011-12-21		0	2011-12-21	?	0	0004297851			20111221.ifs	2011-12-21	2011-12-22
638848	638848	EXCHANGE	ADD	S08470189	66	2004-04-23	2011-09-06	BRRAF	0	0	?	2011-09-08													20110908.ifs	2011-09-08	2011-09-09
638849	638849	SPLIT	DELETE	S08470189	1	2007-07-09	20	?	2007-07-16																20110908.ifs	2011-09-08	2011-09-09
559445	559445	DIVIDEND	ADD	S08470189		6	0	3	0	.5		28	2011-06-06	2011-06-10	2011-06-13	2011-05-26		0	?	2011-06-15	0				20110615.ifs	2011-06-15	2011-06-16
559446	559446	DIVIDEND	CHANGE	S08470189		6	0	3	0	.5		28	2011-06-06	2011-06-10	2011-06-13	2011-05-26		0	?	2011-06-15	0				20110615.ifs	2011-06-15	2011-06-16
559447	559446	DIVIDEND	CHANGE	S08470189		6	0	3	0	.5		28	2011-06-06	2011-06-10	2011-06-13	2011-05-26		0	?	2011-06-15	0	0004191446			20110615.ifs	2011-06-15	2011-06-16
559875	559875	DIVIDEND	CHANGE	S08470189		6	0	3	0	.5		28	2011-06-06	2011-06-10	2011-06-13	2011-05-26		0	?	2011-06-15	0	0004191446			20110615.ifs	2011-06-15	2011-06-16
559876	559875	DIVIDEND	CHANGE	S08470189		6	0	3	0	.5		28	2011-06-06	2011-06-10	2011-06-13	2011-05-26		0	?	2011-06-15	0	0004191446			20110615.ifs	2011-06-15	2011-06-16
193193	193193	DIVIDEND	ADD	S08470189		6	0	3	0	.2		28	2010-05-31	2010-06-04	2010-06-07	2010-05-17		0	2010-05-17	?	0	0004006330			20100517.ifs	2010-05-17	2010-05-18
156862	156862	DIVIDEND	DELETE	S08470189		6	0	3	0	.06		28	2009-11-23	2009-11-27	2009-11-30	2009-11-05		0	2009-11-05	?	0	0003906865			20100409.ifs	2010-04-09	2010-04-10
26423	26423	DIVIDEND	ADD	S08470189		6	0	3	0	.7		28	2010-01-11	2010-01-15	2010-01-18	2009-11-19		0	2009-11-19	?	0	0003909484			20091119.ifs	2009-11-19	2010-04-07
18942	18942	DIVIDEND	ADD	S08470189		6	0	3	0	.06		28	2009-11-23	2009-11-27	2009-11-30	2009-11-05		0	2009-11-05	?	0	0003906865			20091105.ifs	2009-11-05	2010-04-07

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