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
4875414	4875414	EQUITY	CHANGE	01626P403	SUB VTG SH	V	0	1995-06-22	2021-12-09	4	yes	no	01626P304	no		2001-11-23	2021-12-09	?							20211210.ifs	2021-12-10	2021-12-11
4875415	4875414	EQUITY	CHANGE	01626P403	SUB VTG SH	V	0	1995-06-22	2021-12-10	4	yes	no	01626P304	no		2001-11-23	2021-12-10	?							20211210.ifs	2021-12-10	2021-12-11
4875590	4875590	CORPACTION	ADD	01626P403	66	V	2021-12-10	01626P304	66	?															20211210.ifs	2021-12-10	2021-12-11
4872520	4872520	EQUITY	CHANGE	01626P403	SUB VTG SH	V	0	1995-06-22	2021-12-08	4	yes	no	01626P304	no		2001-11-23	2021-12-08	?							20211209.ifs	2021-12-09	2021-12-10
4872521	4872520	EQUITY	CHANGE	01626P403	SUB VTG SH	V	0	1995-06-22	2021-12-09	4	yes	no	01626P304	no		2001-11-23	2021-12-09	?							20211209.ifs	2021-12-09	2021-12-10
4870243	4870243	EQUITY	CHANGE	01626P403	SUB VTG SH	0	0	1995-06-22	?	4	yes	no		no		2001-11-23	2004-11-05	?							20211208.ifs	2021-12-08	2021-12-09
4870244	4870243	EQUITY	CHANGE	01626P403	SUB VTG SH	V	0	1995-06-22	2021-12-08	4	yes	no	01626P304	no		2001-11-23	2021-12-08	?							20211208.ifs	2021-12-08	2021-12-09
4852314	4852314	DIVIDEND	ADD	01626P403		A	0	2	0	.11		15	2021-12-01	2021-12-02	2021-12-16	2021-11-23		0	2021-11-23	?	0	0006398907			20211123.ifs	2021-11-23	2021-11-24
4797537	4797537	DIVIDEND	ADD	01626P403		A	0	2	0	.0875		15	2021-09-08	2021-09-09	2021-09-23	2021-08-31		0	2021-09-03	?	0	0006364809			20210903.ifs	2021-09-03	2021-09-04
4742092	4742092	DIVIDEND	ADD	01626P403		A	0	2	0	.0875		15	2021-07-07	2021-07-08	2021-07-22	2021-06-29		0	2021-06-29	?	0	0006329591			20210629.ifs	2021-06-29	2021-06-30
4657739	4657739	DIVIDEND	ADD	01626P403		A	0	2	0	.0875		15	2021-03-25	2021-03-26	2021-04-09	2021-03-18		0	2021-03-19	?	0	0006279067			20210319.ifs	2021-03-19	2021-03-20
4523735	4523735	DIVIDEND	CHANGE	01626P403		A	0	2	0	.085		15	2020-12-02	2020-12-03	2020-12-17	2020-11-24		0	2020-11-24	?	0	0006190996			20201201.ifs	2020-12-01	2020-12-02
4523736	4523735	DIVIDEND	CHANGE	01626P403		A	0	2	0	.0875		15	2020-12-02	2020-12-03	2020-12-17	2020-11-24		1	2020-11-24	2020-12-01	0	0006190996			20201201.ifs	2020-12-01	2020-12-02
4513459	4513459	DIVIDEND	ADD	01626P403		A	0	2	0	.085		15	2020-12-02	2020-12-03	2020-12-17	2020-11-24		0	2020-11-24	?	0	0006190996			20201124.ifs	2020-11-24	2020-11-25
4457112	4457112	DIVIDEND	ADD	01626P403		A	0	2	0	.07		15	2020-09-10	2020-09-11	2020-09-25	2020-09-02		0	2020-09-03	?	0	0006155804			20200903.ifs	2020-09-03	2020-09-04
4415157	4415157	DIVIDEND	ADD	01626P403		A	0	2	0	.07		15	2020-07-08	2020-07-09	2020-07-23	2020-06-29		0	2020-07-06	?	0	0006128743			20200706.ifs	2020-07-06	2020-07-07
4029526	4029526	DIVIDEND	ADD	01626P403		A	0	2	1	.0625		29	2019-12-04	2019-12-05	2019-12-19	2019-11-26		0	2019-11-26	?	0	0005979045			20191126.ifs	2019-11-26	2019-11-27
4029527	4029527	DIVIDEND	ADD	01626P403		A	0	2	1	.0625		29	2019-12-04	2019-12-05	2019-12-19	2019-11-26		0	2019-11-26	?	0	0005979045			20191126.ifs	2019-11-26	2019-11-27
3937331	3937331	DIVIDEND	CHANGE	01626P403		0	0	6	0	1		11	2019-09-30	2019-09-20	2019-09-27	2019-09-04		1	2019-09-05	2019-09-17	0	0005942173			20190924.ifs	2019-09-24	2019-09-25
3937333	3937332	DIVIDEND	CHANGE	01626P403		0	0	6	0	1		11	2019-09-30	2019-09-20	2019-09-27	2019-09-04		2	2019-09-05	2019-09-24	0	0005942173			20190924.ifs	2019-09-24	2019-09-25
3937435	3937435	DIVIDEND	CHANGE	01626P403		0	0	6	0	1		11	2019-09-30	2019-09-20	2019-09-27	2019-09-04		1	2019-09-05	2019-09-17	0	0005942173			20190924.ifs	2019-09-24	2019-09-25
3937436	3937435	DIVIDEND	CHANGE	01626P403		0	0	6	0	1		11	2019-09-30	2019-09-20	2019-09-27	2019-09-04		2	2019-09-05	2019-09-24	0	0005942173			20190924.ifs	2019-09-24	2019-09-25
3925559	3925559	DIVIDEND	DELETE	01626P403		0	0	6	0	1		11	?	2019-09-20	2019-09-27	2019-09-04		0	2019-09-05	?	0	0005942173			20190917.ifs	2019-09-17	2019-09-18
3925561	3925561	DIVIDEND	ADD	01626P403		0	0	6	0	1		11	2019-09-30	2019-09-20	2019-09-27	2019-09-04		1	2019-09-05	2019-09-17	0	0005942173			20190917.ifs	2019-09-17	2019-09-18
3925563	3925563	SPLIT	ADD	01626P403	.5	2019-09-30	11	2019-09-17	?																20190917.ifs	2019-09-17	2019-09-18
3925566	3925566	DIVIDEND	DELETE	01626P403		0	0	6	0	1		11	?	2019-09-20	2019-09-27	2019-09-04		0	2019-09-05	?	0	0005942173			20190917.ifs	2019-09-17	2019-09-18
3925568	3925568	DIVIDEND	ADD	01626P403		0	0	6	0	1		11	2019-09-30	2019-09-20	2019-09-27	2019-09-04		1	2019-09-05	2019-09-17	0	0005942173			20190917.ifs	2019-09-17	2019-09-18
3925570	3925570	SPLIT	ADD	01626P403	.5	2019-09-30	11	2019-09-17	?																20190917.ifs	2019-09-17	2019-09-18
3915228	3915228	DIVIDEND	ADD	01626P403		A	0	2	0	.125		29	2019-09-12	2019-09-13	2019-09-27	2019-09-05		0	2019-09-06	?	0	0005942183			20190906.ifs	2019-09-06	2019-09-07
3915256	3915256	DIVIDEND	ADD	01626P403		A	0	2	0	.125		29	2019-09-12	2019-09-13	2019-09-27	2019-09-05		0	2019-09-06	?	0	0005942183			20190906.ifs	2019-09-06	2019-09-07
3913375	3913375	DIVIDEND	ADD	01626P403		0	0	6	0	1		11	?	2019-09-20	2019-09-27	2019-09-04		0	2019-09-05	?	0	0005942173			20190905.ifs	2019-09-05	2019-09-06
3913378	3913378	DIVIDEND	ADD	01626P403		0	0	6	0	1		11	?	2019-09-20	2019-09-27	2019-09-04		0	2019-09-05	?	0	0005942173			20190905.ifs	2019-09-05	2019-09-06
3833750	3833750	DIVIDEND	ADD	01626P403		A	0	2	0	.125		15	2019-07-17	2019-07-18	2019-08-01	2019-07-10		0	2019-07-11	?	0	0005915826			20190711.ifs	2019-07-11	2019-07-12
3833897	3833897	DIVIDEND	ADD	01626P403		A	0	2	0	.125		15	2019-07-17	2019-07-18	2019-08-01	2019-07-10		0	2019-07-11	?	0	0005915826			20190711.ifs	2019-07-11	2019-07-12
3639130	3639130	DIVIDEND	ADD	01626P403		A	0	2	0	.125		15	2019-03-27	2019-03-28	2019-04-11	2019-03-19		0	2019-03-19	?	0	0005854937			20190319.ifs	2019-03-19	2019-03-20
3639140	3639140	DIVIDEND	ADD	01626P403		A	0	2	0	.125		15	2019-03-27	2019-03-28	2019-04-11	2019-03-19		0	2019-03-19	?	0	0005854937			20190319.ifs	2019-03-19	2019-03-20
3387446	3387446	DIVIDEND	ADD	01626P403		A	0	2	0	.1		15	2018-12-05	2018-12-06	2018-12-20	2018-11-28		0	2018-11-29	?	0	0005758626			20181129.ifs	2018-11-29	2018-11-30
3387453	3387453	DIVIDEND	ADD	01626P403		A	0	2	0	.1		15	2018-12-05	2018-12-06	2018-12-20	2018-11-28		0	2018-11-29	?	0	0005758626			20181129.ifs	2018-11-29	2018-11-30
3276602	3276602	DIVIDEND	ADD	01626P403		A	0	2	0	.1		15	2018-09-13	2018-09-14	2018-09-28	2018-09-07		0	2018-09-10	?	0	0005721260			20180910.ifs	2018-09-10	2018-09-11
3276615	3276615	DIVIDEND	ADD	01626P403		A	0	2	0	.1		15	2018-09-13	2018-09-14	2018-09-28	2018-09-07		0	2018-09-10	?	0	0005721260			20180910.ifs	2018-09-10	2018-09-11
3192808	3192808	DIVIDEND	ADD	01626P403		A	0	2	0	.1		15	2018-07-17	2018-07-18	2018-08-01	2018-07-11		0	2018-07-12	?	0	0005693423			20180712.ifs	2018-07-12	2018-07-13
3192809	3192809	DIVIDEND	ADD	01626P403		A	0	2	0	.1		15	2018-07-17	2018-07-18	2018-08-01	2018-07-11		0	2018-07-12	?	0	0005693423			20180712.ifs	2018-07-12	2018-07-13
3001689	3001689	DIVIDEND	ADD	01626P403		A	0	2	0	.09		15	2018-03-28	2018-03-29	2018-04-12	2018-03-20		0	2018-03-21	?	0	0005632113			20180321.ifs	2018-03-21	2018-03-22
3001710	3001710	DIVIDEND	ADD	01626P403		A	0	2	0	.09		15	2018-03-28	2018-03-29	2018-04-12	2018-03-20		0	2018-03-21	?	0	0005632113			20180321.ifs	2018-03-21	2018-03-22
2778772	2778772	DIVIDEND	ADD	01626P403		A	0	2	0	.09		15	2017-12-06	2017-12-07	2017-12-21	2017-11-28		0	2017-11-28	?	0	0005533045			20171128.ifs	2017-11-28	2017-11-29
2778946	2778946	DIVIDEND	ADD	01626P403		A	0	2	0	.09		15	2017-12-06	2017-12-07	2017-12-21	2017-11-28		0	2017-11-28	?	0	0005533045			20171128.ifs	2017-11-28	2017-11-29
2667439	2667439	DIVIDEND	ADD	01626P403		A	0	2	0	.09		15	2017-09-14	2017-09-15	2017-09-29	2017-09-06		0	2017-09-07	?	0	0005494675			20170907.ifs	2017-09-07	2017-09-08
2622713	2622713	DIVIDEND	ADD	01626P403		A	0	2	0	.09		15	2017-07-19	2017-07-21	2017-08-04	2017-07-12		0	2017-07-13	?	0	0005468143			20170713.ifs	2017-07-13	2017-07-14
2512305	2512305	DIVIDEND	ADD	01626P403		A	0	2	0	.09		15	2017-03-21	2017-03-23	2017-04-06	2017-03-14		0	2017-03-14	?	0	0005401684			20170314.ifs	2017-03-14	2017-03-15
2433752	2433752	EQUITY	CHANGE	01626P403	SUB VTG SH	0	0	1995-06-22	?	9	yes	no		no		2001-11-23	2004-11-05	?							20170123.ifs	2017-01-23	2017-01-24
2433753	2433752	EQUITY	CHANGE	01626P403	SUB VTG SH	0	0	1995-06-22	?	4	yes	no		no		2001-11-23	2004-11-05	?							20170123.ifs	2017-01-23	2017-01-24
2348585	2348585	DIVIDEND	ADD	01626P403		A	0	2	0	.09		15	2016-11-29	2016-12-01	2016-12-15	2016-11-22		0	2016-11-23	?	0	0005313922			20161123.ifs	2016-11-23	2016-11-24
2287242	2287242	DIVIDEND	ADD	01626P403		A	0	2	0	.0775		15	2016-09-07	2016-09-09	2016-09-23	2016-08-31		0	2016-09-01	?	0	0005273871			20160901.ifs	2016-09-01	2016-09-02
2249956	2249956	DIVIDEND	ADD	01626P403		A	0	2	0	.0775		15	2016-07-19	2016-07-21	2016-08-04	2016-07-12		0	2016-07-12	?	0	0005250913			20160712.ifs	2016-07-12	2016-07-13
2135750	2135750	DIVIDEND	ADD	01626P403		A	0	2	0	.0675		15	2016-03-22	2016-03-24	2016-04-07	2016-03-15		0	2016-03-15	?	0	0005186641			20160315.ifs	2016-03-15	2016-03-16
2015468	2015468	DIVIDEND	ADD	01626P403		A	0	2	0	.0675		15	2015-12-01	2015-12-03	2015-12-17	2015-11-24		0	2015-11-24	?	0	0005096625			20151124.ifs	2015-11-24	2015-11-25
1957464	1957464	DIVIDEND	ADD	01626P403		A	0	2	0	.055		15	2015-09-09	2015-09-11	2015-09-25	2015-09-01		0	2015-09-01	?	0	0005057980			20150901.ifs	2015-09-01	2015-09-02
1917364	1917364	DIVIDEND	ADD	01626P403		A	0	2	0	.055		15	2015-07-21	2015-07-23	2015-08-06	2015-07-15		0	2015-07-15	?	0	0005033250			20150715.ifs	2015-07-15	2015-07-16
1815238	1815238	DIVIDEND	ADD	01626P403		A	0	2	0	.045		15	2015-03-24	2015-03-26	2015-04-09	2015-03-18		0	2015-03-18	?	0	0004969916			20150318.ifs	2015-03-18	2015-03-19
1688198	1688198	DIVIDEND	ADD	01626P403		A	0	2	0	.045		15	2014-12-02	2014-12-04	2014-12-18	2014-11-25		0	2014-11-25	?	0	0004876400			20141125.ifs	2014-11-25	2014-11-26
1624019	1624019	DIVIDEND	ADD	01626P403		A	0	2	0	.045		15	2014-09-10	2014-09-12	2014-09-26	2014-09-03		0	2014-09-03	?	0	0004840102			20140903.ifs	2014-09-03	2014-09-04
1576027	1576027	DIVIDEND	ADD	01626P403		A	0	2	1	.04		29	2014-07-14	2014-07-16	2014-07-30	2014-07-07		0	2014-07-07	?	0	0004813719			20140707.ifs	2014-07-07	2014-07-08
1493477	1493477	DIVIDEND	ADD	01626P403		0	0	6	0	2		11	2014-04-23	2014-04-14	2014-04-22	2014-03-18		0	2014-04-08	?	0	0004767372			20140408.ifs	2014-04-08	2014-04-09
1493478	1493478	SPLIT	ADD	01626P403	.3333333333	2014-04-23	11	2014-04-08	?																20140408.ifs	2014-04-08	2014-04-09
1469944	1469944	DIVIDEND	ADD	01626P403		A	0	2	0	.1		15	2014-03-25	2014-03-27	2014-04-10	2014-03-18		0	2014-03-18	?	0	0004751807			20140318.ifs	2014-03-18	2014-03-19
1346658	1346658	DIVIDEND	ADD	01626P403		A	0	2	0	.1		15	2013-12-03	2013-12-05	2013-12-19	2013-11-26		0	2013-11-26	?	0	0004661555			20131126.ifs	2013-11-26	2013-11-27
1276726	1276726	DIVIDEND	ADD	01626P403		A	0	2	0	.0875		15	2013-09-09	2013-09-11	2013-09-25	2013-08-30		0	2013-08-30	?	0	0004621156			20130830.ifs	2013-08-30	2013-08-31
1237634	1237634	DIVIDEND	ADD	01626P403		A	0	2	0	.075		15	2013-07-16	2013-07-18	2013-08-01	2013-07-09		0	2013-07-09	?	0	0004600575			20130709.ifs	2013-07-09	2013-07-10
1136718	1136718	DIVIDEND	ADD	01626P403		A	0	2	0	.075		15	2013-03-26	2013-03-28	2013-04-11	2013-03-19		0	2013-03-19	?	0	0004542653			20130319.ifs	2013-03-19	2013-03-20
1016569	1016569	DIVIDEND	ADD	01626P403		A	0	2	0	.075		15	2012-12-04	2012-12-06	2012-12-20	2012-11-27		0	2012-11-27	?	0	0004461066			20121127.ifs	2012-11-27	2012-11-28
950445	950445	DIVIDEND	ADD	01626P403		A	0	2	0	.075		15	2012-09-12	2012-09-14	2012-09-28	2012-09-05		0	2012-09-05	?	0	0004425863			20120905.ifs	2012-09-05	2012-09-06
801692	801692	DIVIDEND	ADD	01626P403		A	0	2	0	.075		15	2012-03-21	2012-03-23	2012-04-06	2012-03-13		0	2012-03-13	?	0	0004344991			20120313.ifs	2012-03-13	2012-03-14
628507	628507	DIVIDEND	ADD	01626P403		A	0	2	0	.0625		15	2011-09-07	2011-09-09	2011-09-19	2011-08-30		0	2011-08-30	?	0	0004233460			20110830.ifs	2011-08-30	2011-08-31
586876	586876	DIVIDEND	ADD	01626P403		A	0	2	0	.0625		15	2011-07-19	2011-07-21	2011-07-29	2011-07-12		0	2011-07-13	?	0	0004216240			20110713.ifs	2011-07-13	2011-07-14
469588	469588	DIVIDEND	ADD	01626P403		A	0	2	0	.05		15	2011-03-17	2011-03-21	2011-03-29	2011-03-10		0	2011-03-10	?	0	0004158624			20110310.ifs	2011-03-10	2011-03-11
361359	361359	DIVIDEND	ADD	01626P403		A	0	2	0	.05		15	2010-11-30	2010-12-02	2010-12-10	2010-11-23		0	2010-11-23	?	0	0004089946			20101123.ifs	2010-11-23	2010-11-24
286290	286290	DIVIDEND	ADD	01626P403		A	0	2	0	.04		15	2010-08-31	2010-09-02	2010-09-10	2010-08-24		0	2010-08-25	?	0	0004049462			20100825.ifs	2010-08-25	2010-08-26
248998	248998	DIVIDEND	ADD	01626P403		A	0	2	0	.04		15	2010-07-20	2010-07-22	2010-07-30	2010-07-13		0	2010-07-13	?	0	0004033337			20100713.ifs	2010-07-13	2010-07-14
129630	129630	DIVIDEND	ADD	01626P403		A	0	2	0	.04		15	2010-03-16	2010-03-18	2010-03-26	2010-03-09		0	2010-03-09	?	0	0003976500			20100309.ifs	2010-03-09	2010-04-07
30250	30250	DIVIDEND	ADD	01626P403		A	0	2	0	.035		15	2009-12-01	2009-12-03	2009-12-11	2009-11-24		0	2009-11-24	?	0	0003910815			20091124.ifs	2009-11-24	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 = 145455
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