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
5218067	5218067	CORPACTION	ADD	Q09504137	66	D	2023-01-30			?															20230130.ifs	2023-01-30	2023-01-31
5218068	5218068	EQUITY	CHANGE	Q09504137	ORD	0	0	1996-01-15	?	2	no	no		no		2000-02-25	2000-04-12	?							20230130.ifs	2023-01-30	2023-01-31
5218069	5218068	EQUITY	CHANGE	Q09504137	ORD	D	0	1996-01-15	2023-01-30	2	no	no		no		2000-02-25	2023-01-30	?							20230130.ifs	2023-01-30	2023-01-31
5126460	5126460	DIVIDEND	ADD	Q09504137		6	0	3	0	.74		28	?	2022-11-08	2022-12-15	2022-10-27		0	2022-10-27	?	0	0006602726			20221027.ifs	2022-10-27	2022-10-28
5009645	5009645	DIVIDEND	ADD	Q09504137		6	0	3	0	.72		28	?	2022-05-10	2022-07-01	2022-05-09		0	2022-05-09	?	0	0006522722			20220509.ifs	2022-05-09	2022-05-10
4837963	4837963	DIVIDEND	ADD	Q09504137		6	0	3	0	.72		28	?	2021-11-09	2021-12-16	2021-11-01		0	2021-11-01	?	0	0006391879			20211101.ifs	2021-11-01	2021-11-02
4700975	4700975	DIVIDEND	ADD	Q09504137		6	0	3	0	.7		28	?	2021-05-11	2021-07-01	2021-05-06		0	2021-05-06	?	0	0006306138			20210506.ifs	2021-05-06	2021-05-07
4493318	4493318	DIVIDEND	ADD	Q09504137		6	0	3	0	.35		28	?	2020-11-10	2020-12-16	2020-10-29		0	2020-10-29	?	0	0006179063			20201029.ifs	2020-10-29	2020-10-30
4442379	4442379	DIVIDEND	ADD	Q09504137		6	0	3	0	.25		28	?	2020-08-25	2020-09-30	2020-08-19		0	2020-08-19	?	0	0006145075			20200819.ifs	2020-08-19	2020-08-20
4014045	4014045	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.56		28	?	2019-11-12	2019-12-18	2019-11-01		0	2019-11-01	?	0	0005972262			20191114.ifs	2019-11-14	2019-11-15
4014046	4014045	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.8		28	?	2019-11-12	2019-12-18	2019-11-01		1	2019-11-01	2019-11-14	0	0005972262			20191114.ifs	2019-11-14	2019-11-15
4014049	4014049	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.56		28	?	2019-11-12	2019-12-18	2019-11-01		0	2019-11-01	?	0	0005972262			20191114.ifs	2019-11-14	2019-11-15
4014050	4014049	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.8		28	?	2019-11-12	2019-12-18	2019-11-01		1	2019-11-01	2019-11-14	0	0005972262			20191114.ifs	2019-11-14	2019-11-15
3996798	3996798	DIVIDEND	ADD	Q09504137		6	0	3	0	.56		28	?	2019-11-12	2019-12-18	2019-11-01		0	2019-11-01	?	0	0005972262			20191101.ifs	2019-11-01	2019-11-02
3996802	3996802	DIVIDEND	ADD	Q09504137		6	0	3	0	.56		28	?	2019-11-12	2019-12-18	2019-11-01		0	2019-11-01	?	0	0005972262			20191101.ifs	2019-11-01	2019-11-02
3826604	3826604	DIVIDEND	ADD	Q09504137		6	0	3	0	.8		28	?	2019-05-14	2019-07-01	2019-05-01		0	?	2019-07-03	0	0005878687			20190703.ifs	2019-07-03	2019-07-04
3826605	3826605	DIVIDEND	ADD	Q09504137		6	0	3	0	.8		28	?	2019-05-14	2019-07-01	2019-05-01		0	?	2019-07-03	0	0005878687			20190703.ifs	2019-07-03	2019-07-04
3456482	3456482	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.8		28	2018-11-12	2018-11-13	2018-12-18	2018-10-31		0	2018-10-31	?	0	0005745406			20181218.ifs	2018-12-18	2018-12-19
3456484	3456483	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.8		28	2018-11-12	2018-11-13	2018-12-18	2018-10-31		1	2018-10-31	2018-12-18	0	0005745406			20181218.ifs	2018-12-18	2018-12-19
3456485	3456485	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.8		28	2018-11-12	2018-11-13	2018-12-18	2018-10-31		0	2018-10-31	?	0	0005745406			20181218.ifs	2018-12-18	2018-12-19
3456487	3456486	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.8		28	2018-11-12	2018-11-13	2018-12-18	2018-10-31		1	2018-10-31	2018-12-18	0	0005745406			20181218.ifs	2018-12-18	2018-12-19
3345554	3345554	DIVIDEND	ADD	Q09504137		6	0	3	0	.8		28	2018-11-12	2018-11-13	2018-12-18	2018-10-31		0	2018-10-31	?	0	0005745406			20181031.ifs	2018-10-31	2018-11-01
3345618	3345618	DIVIDEND	ADD	Q09504137		6	0	3	0	.8		28	2018-11-12	2018-11-13	2018-12-18	2018-10-31		0	2018-10-31	?	0	0005745406			20181031.ifs	2018-10-31	2018-11-01
3172111	3172111	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.8		28	2018-05-14	2018-05-15	2018-07-02	2018-05-01		0	2018-05-01	?	0	0005657133			20180702.ifs	2018-07-02	2018-07-03
3172112	3172111	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.8		28	2018-05-14	2018-05-15	2018-07-02	2018-05-01		1	2018-05-01	2018-07-02	0	0005657133			20180702.ifs	2018-07-02	2018-07-03
3173311	3173311	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.8		28	2018-05-14	2018-05-15	2018-07-02	2018-05-01		0	2018-05-01	?	0	0005657133			20180702.ifs	2018-07-02	2018-07-03
3173313	3173312	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.8		28	2018-05-14	2018-05-15	2018-07-02	2018-05-01		1	2018-05-01	2018-07-02	0	0005657133			20180702.ifs	2018-07-02	2018-07-03
3066869	3066869	DIVIDEND	ADD	Q09504137		6	0	3	0	.8		28	2018-05-14	2018-05-15	2018-07-02	2018-05-01		0	2018-05-01	?	0	0005657133			20180501.ifs	2018-05-01	2018-05-02
3066933	3066933	DIVIDEND	ADD	Q09504137		6	0	3	0	.8		28	2018-05-14	2018-05-15	2018-07-02	2018-05-01		0	2018-05-01	?	0	0005657133			20180501.ifs	2018-05-01	2018-05-02
2841534	2841534	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.8		28	2017-11-13	2017-11-14	2017-12-18	2017-10-27		0	2017-10-27	?	0	0005518864			20171219.ifs	2017-12-19	2017-12-20
2841536	2841535	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.8		28	2017-11-13	2017-11-14	2017-12-18	2017-10-27		1	2017-10-27	2017-12-19	0	0005518864			20171219.ifs	2017-12-19	2017-12-20
2841655	2841655	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.8		28	2017-11-13	2017-11-14	2017-12-18	2017-10-27		0	2017-10-27	?	0	0005518864			20171219.ifs	2017-12-19	2017-12-20
2841657	2841656	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.8		28	2017-11-13	2017-11-14	2017-12-18	2017-10-27		1	2017-10-27	2017-12-19	0	0005518864			20171219.ifs	2017-12-19	2017-12-20
2738037	2738037	DIVIDEND	ADD	Q09504137		6	0	3	0	.8		28	2017-11-13	2017-11-14	2017-12-18	2017-10-27		0	2017-10-27	?	0	0005518864			20171027.ifs	2017-10-27	2017-10-28
2738045	2738045	DIVIDEND	ADD	Q09504137		6	0	3	0	.8		28	2017-11-13	2017-11-14	2017-12-18	2017-10-27		0	2017-10-27	?	0	0005518864			20171027.ifs	2017-10-27	2017-10-28
2615255	2615255	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.8		28	2017-05-08	2017-05-09	2017-07-03	2017-05-02		0	2017-05-02	?	0	0005431908			20170705.ifs	2017-07-05	2017-07-06
2615256	2615255	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.8		28	2017-05-08	2017-05-09	2017-07-03	2017-05-02		1	2017-05-02	2017-07-05	0	0005431908			20170705.ifs	2017-07-05	2017-07-06
2558370	2558370	DIVIDEND	ADD	Q09504137		6	0	3	0	.8		28	2017-05-08	2017-05-09	2017-07-03	2017-05-02		0	2017-05-02	?	0	0005431908			20170502.ifs	2017-05-02	2017-05-03
2453756	2453756	EQUITY	CHANGE	Q09504137	ORD	0	0	1996-01-15	?	0	no	no		no		2000-02-25	2000-04-12	?							20170124.ifs	2017-01-24	2017-01-25
2453757	2453756	EQUITY	CHANGE	Q09504137	ORD	0	0	1996-01-15	?	2	no	no		no		2000-02-25	2000-04-12	?							20170124.ifs	2017-01-24	2017-01-25
2386039	2386039	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.8		28	2016-11-14	2016-11-15	2016-12-16	2016-11-03		0	2016-11-03	?	0	0005309659			20161220.ifs	2016-12-20	2016-12-21
2386040	2386039	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.8		28	2016-11-14	2016-11-15	2016-12-16	2016-11-03		1	2016-11-03	2016-12-20	0	0005309659			20161220.ifs	2016-12-20	2016-12-21
2338505	2338505	DIVIDEND	ADD	Q09504137		6	0	3	0	.8		28	2016-11-14	2016-11-15	2016-12-16	2016-11-03		0	2016-11-03	?	0	0005309659			20161103.ifs	2016-11-03	2016-11-04
2245040	2245040	DIVIDEND	DELETE	Q09504137		6	0	3	0	.8		28	2016-05-09	2016-05-10	2016-06-01	2016-05-03		1	2016-05-03	2016-05-04	0	0005216720			20160705.ifs	2016-07-05	2016-07-06
2245041	2245041	DIVIDEND	ADD	Q09504137		6	0	3	0	.8		28	2016-05-09	2016-05-10	2016-07-01	2016-05-03		2	2016-05-03	2016-07-05	0	0005216720			20160705.ifs	2016-07-05	2016-07-06
2191068	2191068	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.8		28	2016-05-09	2016-05-10	2016-06-01	2016-05-03		0	2016-05-03	?	0	0005216720			20160504.ifs	2016-05-04	2016-05-05
2191069	2191068	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.8		28	2016-05-09	2016-05-10	2016-06-01	2016-05-03		1	2016-05-03	2016-05-04	0	0005216720			20160504.ifs	2016-05-04	2016-05-05
2189550	2189550	DIVIDEND	ADD	Q09504137		6	0	3	0	.8		28	2016-05-09	2016-05-10	2016-06-01	2016-05-03		0	2016-05-03	?	0	0005216720			20160503.ifs	2016-05-03	2016-05-04
2050964	2050964	DIVIDEND	DELETE	Q09504137		6	0	3	0	.95		28	?	2015-11-10	2015-12-15	2015-10-29		1	2015-10-29	2015-10-30	0	0005083135			20151218.ifs	2015-12-18	2015-12-19
2050965	2050965	DIVIDEND	ADD	Q09504137		6	0	3	0	.95		28	2015-11-06	2015-11-10	2015-12-16	2015-10-29		2	2015-10-29	2015-12-18	0	0005083135			20151218.ifs	2015-12-18	2015-12-19
1999986	1999986	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.95		28	?	2015-11-10	2015-12-15	2015-10-29		0	2015-10-29	?	0	0005083135			20151030.ifs	2015-10-30	2015-10-31
1999987	1999986	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.95		28	?	2015-11-10	2015-12-15	2015-10-29		1	2015-10-29	2015-10-30	0	0005083135			20151030.ifs	2015-10-30	2015-10-31
1998784	1998784	DIVIDEND	ADD	Q09504137		6	0	3	0	.95		28	?	2015-11-10	2015-12-15	2015-10-29		0	2015-10-29	?	0	0005083135			20151029.ifs	2015-10-29	2015-10-30
1909793	1909793	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.86		28	2015-05-08	2015-05-12	2015-07-01	2015-05-05		1	2015-05-05	2015-05-06	0	0004998122			20150702.ifs	2015-07-02	2015-07-03
1909794	1909793	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.86		28	2015-05-08	2015-05-12	2015-07-01	2015-05-05		2	2015-05-05	2015-07-02	0	0004998122			20150702.ifs	2015-07-02	2015-07-03
1858664	1858664	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.86		28	2015-05-08	2015-05-12	2015-07-01	2015-05-05		0	2015-05-05	?	0	0004998122			20150506.ifs	2015-05-06	2015-05-07
1858665	1858664	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.86		28	2015-05-08	2015-05-12	2015-07-01	2015-05-05		1	2015-05-05	2015-05-06	0	0004998122			20150506.ifs	2015-05-06	2015-05-07
1721457	1721457	DIVIDEND	DELETE	Q09504137		6	0	3	0	.95		28	?	2014-11-11	2014-12-16	2014-10-31		1	2014-10-31	2014-11-03	0	0004863952			20141217.ifs	2014-12-17	2014-12-18
1721458	1721458	DIVIDEND	ADD	Q09504137		6	0	3	0	.95		28	2014-11-07	2014-11-11	2014-12-16	2014-10-31		2	2014-10-31	2014-12-17	0	0004863952			20141217.ifs	2014-12-17	2014-12-18
1670705	1670705	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.95		28	?	2014-11-11	2014-12-16	2014-10-31		0	2014-10-31	?	0	0004863952			20141103.ifs	2014-11-03	2014-11-04
1670706	1670705	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.95		28	?	2014-11-11	2014-12-16	2014-10-31		1	2014-10-31	2014-11-03	0	0004863952			20141103.ifs	2014-11-03	2014-11-04
1666982	1666982	DIVIDEND	ADD	Q09504137		6	0	3	0	.95		28	?	2014-11-11	2014-12-16	2014-10-31		0	2014-10-31	?	0	0004863952			20141031.ifs	2014-10-31	2014-11-01
1511242	1511242	DIVIDEND	ADD	Q09504137		6	0	3	0	.83		28	?	2014-05-13	2014-07-01	2014-05-01		0	2014-05-01	?	0	0004778375			20140501.ifs	2014-05-01	2014-05-02
1334522	1334522	DIVIDEND	ADD	Q09504137		6	0	3	0	.91		28	?	2013-11-13	2013-12-16	2013-11-04		0	2013-11-04	?	0	0004656141			20131104.ifs	2013-11-04	2013-11-05
1228179	1228179	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.73		28	?	2013-05-15	2013-07-01	2013-05-01		0	2013-05-01	?	0	0004566799			20130701.ifs	2013-07-01	2013-07-02
1228180	1228179	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.73		28	?	2013-05-15	2013-07-01	2013-05-01		1	2013-05-01	2013-07-01	0	0004566799			20130701.ifs	2013-07-01	2013-07-02
1174506	1174506	DIVIDEND	ADD	Q09504137		6	0	3	0	.73		28	?	2013-05-15	2013-07-01	2013-05-01		0	2013-05-01	?	0	0004566799			20130501.ifs	2013-05-01	2013-05-02
1055203	1055203	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.79		28	?	2012-11-14	2012-12-19	2012-10-31		0	2012-10-31	?	0	0004448818			20121221.ifs	2012-12-21	2012-12-22
1055204	1055203	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.79		28	?	2012-11-14	2012-12-19	2012-10-31		1	2012-10-31	2012-12-21	0	0004448818			20121221.ifs	2012-12-21	2012-12-22
996349	996349	DIVIDEND	ADD	Q09504137		6	0	3	0	.79		28	?	2012-11-14	2012-12-19	2012-10-31		0	2012-10-31	?	0	0004448818			20121031.ifs	2012-10-31	2012-11-01
854693	854693	DIVIDEND	ADD	Q09504137		6	0	3	0	.66		28	?	2012-05-16	2012-07-02	2012-05-03		0	2012-05-03	?	0	0004372146			20120503.ifs	2012-05-03	2012-05-04
690395	690395	DIVIDEND	ADD	Q09504137		6	0	3	0	.76		28	?	2011-11-16	2011-12-16	2011-11-04		0	2011-11-04	?	0	0004268222			20111104.ifs	2011-11-04	2011-11-05
520800	520800	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.64		28	?	2011-05-18	2011-07-01	2011-05-04		0	2011-05-04	?	0	0004186191			20110505.ifs	2011-05-05	2011-05-06
520801	520800	DIVIDEND	CHANGE	Q09504137		6	0	3	0	.64		28	?	2011-05-18	2011-07-01	2011-05-04		1	2011-05-04	2011-05-05	0	0004186191			20110505.ifs	2011-05-05	2011-05-06
519996	519996	DIVIDEND	ADD	Q09504137		6	0	3	0	.64		28	?	2011-05-18	2011-07-01	2011-05-04		0	2011-05-04	?	0	0004186191			20110504.ifs	2011-05-04	2011-05-05
345109	345109	DIVIDEND	ADD	Q09504137		6	0	3	0	.74		28	?	2010-11-10	2010-12-17	2010-10-29		0	2010-10-29	?	0	0004078580			20101029.ifs	2010-10-29	2010-10-30
175192	175192	DIVIDEND	ADD	Q09504137		6	0	3	0	.52		28	?	2010-05-12	2010-07-01	2010-04-30		0	2010-04-30	?	0	0003997523			20100430.ifs	2010-04-30	2010-05-01
9662	9662	DIVIDEND	ADD	Q09504137		6	0	3	0	.56		28	?	2009-11-11	2009-12-18	2009-10-29		0	2009-10-29	?	0	0003899825			20091029.ifs	2009-10-29	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 = 145457
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