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
5555614	5555614	DIVIDEND	ADD	01973R101		0	0	1	0	.25		00	2024-05-17	2024-05-20	2024-05-31	2024-05-08		0	2024-05-08	?	0	0006918095			20240508.ifs	2024-05-08	2024-05-09
5501445	5501445	DIVIDEND	ADD	01973R101		0	0	1	0	.25		00	2024-03-01	2024-03-04	2024-03-15	2024-02-21		0	2024-02-21	?	0	0006878353			20240221.ifs	2024-02-21	2024-02-22
5410419	5410419	DIVIDEND	ADD	01973R101		0	0	1	0	.23		00	2023-11-10	2023-11-13	2023-11-30	2023-11-02		0	2023-11-02	?	0	0006809772			20231102.ifs	2023-11-02	2023-11-03
5350784	5350784	DIVIDEND	ADD	01973R101		0	0	1	0	.23		00	2023-08-11	2023-08-14	2023-08-31	2023-08-03		0	2023-08-03	?	0	0006767830			20230803.ifs	2023-08-03	2023-08-04
5286907	5286907	DIVIDEND	ADD	01973R101		0	0	1	0	.23		00	2023-05-12	2023-05-15	2023-05-31	2023-05-03		0	2023-05-03	?	0	0006723404			20230503.ifs	2023-05-03	2023-05-04
5234314	5234314	DIVIDEND	ADD	01973R101		0	0	1	0	.23		00	2023-03-03	2023-03-06	2023-03-17	2023-02-23		0	2023-02-23	?	0	0006685103			20230223.ifs	2023-02-23	2023-02-24
5136901	5136901	DIVIDEND	ADD	01973R101		0	0	1	0	.21		00	2022-11-18	2022-11-21	2022-11-30	2022-11-07		0	2022-11-07	?	0	0006611484			20221107.ifs	2022-11-07	2022-11-08
5076056	5076056	DIVIDEND	ADD	01973R101		0	0	1	0	.21		00	2022-08-19	2022-08-22	2022-08-31	2022-08-08		0	2022-08-08	?	0	0006568718			20220808.ifs	2022-08-08	2022-08-09
5008145	5008145	DIVIDEND	ADD	01973R101		0	0	1	0	.21		00	2022-05-13	2022-05-16	2022-05-27	2022-05-04		0	2022-05-04	?	0	0006521738			20220504.ifs	2022-05-04	2022-05-05
4957943	4957943	DIVIDEND	ADD	01973R101		0	0	1	0	.21		00	2022-03-04	2022-03-07	2022-03-18	2022-02-24		0	2022-02-24	?	0	0006483869			20220224.ifs	2022-02-24	2022-02-25
4842755	4842755	DIVIDEND	ADD	01973R101		0	0	1	0	.19		00	2021-11-19	2021-11-22	2021-11-30	2021-11-02		0	2021-11-02	?	0	0006394442			20211102.ifs	2021-11-02	2021-11-03
4778885	4778885	DIVIDEND	ADD	01973R101		0	0	1	0	.19		00	2021-08-13	2021-08-16	2021-08-27	2021-08-06		0	2021-08-06	?	0	0006352672			20210806.ifs	2021-08-06	2021-08-07
4701264	4701264	DIVIDEND	ADD	01973R101		0	0	1	0	.19		00	2021-05-14	2021-05-17	2021-05-28	2021-05-06		0	2021-05-06	?	0	0006306218			20210506.ifs	2021-05-06	2021-05-07
4628540	4628540	DIVIDEND	ADD	01973R101		0	0	1	0	.19		00	2021-02-19	2021-02-22	2021-03-05	2021-02-11		0	2021-02-11	?	0	0006263595			20210211.ifs	2021-02-11	2021-02-12
4503406	4503406	DIVIDEND	ADD	01973R101		0	0	1	0	.17		00	2020-11-13	2020-11-16	2020-11-25	2020-11-05		0	2020-11-05	?	0	0006186878			20201105.ifs	2020-11-05	2020-11-06
4440403	4440403	DIVIDEND	ADD	01973R101		0	0	1	0	.17		00	2020-08-21	2020-08-24	2020-08-31	2020-08-14		0	2020-08-14	?	0	0006144249			20200814.ifs	2020-08-14	2020-08-15
4328732	4328732	DIVIDEND	ADD	01973R101		0	0	1	0	.17		00	2020-05-15	2020-05-18	2020-05-29	2020-05-07		0	2020-05-07	?	0	0006097345			20200507.ifs	2020-05-07	2020-05-08
4328800	4328800	DIVIDEND	ADD	01973R101		0	0	1	0	.17		00	2020-05-15	2020-05-18	2020-05-29	2020-05-07		0	2020-05-07	?	0	0006097345			20200507.ifs	2020-05-07	2020-05-08
4217259	4217259	DIVIDEND	ADD	01973R101		0	0	1	0	.17		00	2020-03-06	2020-03-09	2020-03-20	2020-02-26		0	2020-02-26	?	0	0006058539			20200226.ifs	2020-02-26	2020-02-27
4217260	4217260	DIVIDEND	ADD	01973R101		0	0	1	0	.17		00	2020-03-06	2020-03-09	2020-03-20	2020-02-26		0	2020-02-26	?	0	0006058539			20200226.ifs	2020-02-26	2020-02-27
4005969	4005969	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2019-11-14	2019-11-15	2019-11-27	2019-11-04		0	2019-11-04	?	0	0005973248			20191104.ifs	2019-11-04	2019-11-05
4006052	4006052	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2019-11-14	2019-11-15	2019-11-27	2019-11-04		0	2019-11-04	?	0	0005973248			20191104.ifs	2019-11-04	2019-11-05
3877972	3877972	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2019-08-22	2019-08-23	2019-08-30	2019-08-12		0	2019-08-12	?	0	0005930124			20190812.ifs	2019-08-12	2019-08-13
3877977	3877977	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2019-08-22	2019-08-23	2019-08-30	2019-08-12		0	2019-08-12	?	0	0005930124			20190812.ifs	2019-08-12	2019-08-13
3722686	3722686	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2019-05-17	2019-05-20	2019-05-31	2019-05-09		0	2019-05-09	?	0	0005882941			20190509.ifs	2019-05-09	2019-05-10
3722687	3722687	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2019-05-17	2019-05-20	2019-05-31	2019-05-09		0	2019-05-09	?	0	0005882941			20190509.ifs	2019-05-09	2019-05-10
3590158	3590158	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2019-03-01	2019-03-04	2019-03-15	2019-02-21		0	2019-02-21	?	0	0005840544			20190221.ifs	2019-02-21	2019-02-22
3590159	3590159	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2019-03-01	2019-03-04	2019-03-15	2019-02-21		0	2019-02-21	?	0	0005840544			20190221.ifs	2019-02-21	2019-02-22
3339760	3339760	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2018-11-16	2018-11-19	2018-11-30	2018-10-25		0	2018-10-25	?	0	0005743804			20181025.ifs	2018-10-25	2018-10-26
3339873	3339873	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2018-11-16	2018-11-19	2018-11-30	2018-10-25		0	2018-10-25	?	0	0005743804			20181025.ifs	2018-10-25	2018-10-26
3202812	3202812	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2018-08-17	2018-08-20	2018-08-31	2018-07-23		0	2018-07-23	?	0	0005696176			20180723.ifs	2018-07-23	2018-07-24
3202825	3202825	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2018-08-17	2018-08-20	2018-08-31	2018-07-23		0	2018-07-23	?	0	0005696176			20180723.ifs	2018-07-23	2018-07-24
3087304	3087304	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2018-05-18	2018-05-21	2018-05-31	2018-05-10		0	2018-05-10	?	0	0005660450			20180510.ifs	2018-05-10	2018-05-11
3087311	3087311	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2018-05-18	2018-05-21	2018-05-31	2018-05-10		0	2018-05-10	?	0	0005660450			20180510.ifs	2018-05-10	2018-05-11
2949056	2949056	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2018-02-16	2018-02-20	2018-02-28	2018-02-08		0	2018-02-08	?	0	0005613915			20180208.ifs	2018-02-08	2018-02-09
2949059	2949059	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2018-02-16	2018-02-20	2018-02-28	2018-02-08		0	2018-02-08	?	0	0005613915			20180208.ifs	2018-02-08	2018-02-09
2760792	2760792	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2017-11-17	2017-11-20	2017-11-30	2017-11-08		0	2017-11-08	?	0	0005528443			20171108.ifs	2017-11-08	2017-11-09
2760830	2760830	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2017-11-17	2017-11-20	2017-11-30	2017-11-08		0	2017-11-08	?	0	0005528443			20171108.ifs	2017-11-08	2017-11-09
2647370	2647370	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2017-08-17	2017-08-21	2017-08-31	2017-08-10		0	2017-08-10	?	0	0005482305			20170810.ifs	2017-08-10	2017-08-11
2566044	2566044	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2017-05-18	2017-05-22	2017-05-26	2017-05-11		0	2017-05-11	?	0	0005434660			20170511.ifs	2017-05-11	2017-05-12
2494945	2494945	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2017-03-02	2017-03-06	2017-03-15	2017-02-23		0	2017-02-23	?	0	0005390962			20170223.ifs	2017-02-23	2017-02-24
2433920	2433920	EQUITY	CHANGE	01973R101	COM	0	0	2012-03-15	?	0	no	no		no		2012-03-15	2012-03-16	?							20170123.ifs	2017-01-23	2017-01-24
2433921	2433920	EQUITY	CHANGE	01973R101	COM	0	0	2012-03-15	?	4	no	no		no		2012-03-15	2012-03-16	?							20170123.ifs	2017-01-23	2017-01-24
2339563	2339563	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2016-11-09	2016-11-14	2016-11-30	2016-11-04		0	2016-11-04	?	0	0005310099			20161104.ifs	2016-11-04	2016-11-05
2269788	2269788	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2016-08-18	2016-08-22	2016-09-02	2016-08-11		0	2016-08-11	?	0	0005265072			20160811.ifs	2016-08-11	2016-08-12
2196053	2196053	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2016-05-19	2016-05-23	2016-06-03	2016-05-12		0	2016-05-12	?	0	0005218476			20160513.ifs	2016-05-13	2016-05-14
2115167	2115167	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2016-02-25	2016-02-29	2016-03-11	2016-02-18		0	2016-02-18	?	0	0005173709			20160218.ifs	2016-02-18	2016-02-19
2004677	2004677	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2015-11-12	2015-11-16	2015-11-25	2015-11-05		0	2015-11-05	?	0	0005091180			20151105.ifs	2015-11-05	2015-11-06
1938635	1938635	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2015-08-13	2015-08-17	2015-08-28	2015-08-07		0	2015-08-07	?	0	0005046065			20150807.ifs	2015-08-07	2015-08-08
1860773	1860773	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2015-05-14	2015-05-18	2015-05-29	2015-05-08		0	2015-05-08	?	0	0004999171			20150508.ifs	2015-05-08	2015-05-09
1666367	1666367	DIVIDEND	ADD	01973R101		0	0	1	0	.15		00	2014-11-06	2014-11-10	2014-11-26	2014-10-30		0	2014-10-30	?	0	0004863590			20141030.ifs	2014-10-30	2014-10-31
1601527	1601527	DIVIDEND	ADD	01973R101		0	0	1	0	.12		00	2014-08-14	2014-08-18	2014-08-29	2014-08-07		0	2014-08-07	?	0	0004827659			20140807.ifs	2014-08-07	2014-08-08
1521759	1521759	DIVIDEND	ADD	01973R101		0	0	1	0	.12		00	2014-05-15	2014-05-19	2014-05-30	2014-05-08		0	2014-05-08	?	0	0004781396			20140508.ifs	2014-05-08	2014-05-09
1446357	1446357	DIVIDEND	ADD	01973R101		0	0	1	0	.12		00	2014-02-27	2014-03-03	2014-03-25	2014-02-19		0	2014-02-19	?	0	0004737807			20140219.ifs	2014-02-19	2014-02-20
1337205	1337205	DIVIDEND	ADD	01973R101		0	0	1	0	.12		00	2013-11-14	2013-11-18	2013-12-02	2013-11-07		0	2013-11-07	?	0	0004656944			20131107.ifs	2013-11-07	2013-11-08
1261789	1261789	DIVIDEND	ADD	01973R101		0	0	1	0	.12		00	2013-08-15	2013-08-19	2013-09-30	2013-08-08		0	2013-08-08	?	0	0004614543			20130808.ifs	2013-08-08	2013-08-09
1160192	1160192	DIVIDEND	ADD	01973R101		0	0	1	0	.12		00	2013-05-15	2013-05-17	2013-05-31	2013-04-15		0	2013-04-15	?	0	0004557816			20130415.ifs	2013-04-15	2013-04-16
1112491	1112491	DIVIDEND	ADD	01973R101		0	0	1	0	.06		00	2013-02-21	2013-02-25	2013-03-11	2013-02-14		0	2013-02-14	?	0	0004527952			20130214.ifs	2013-02-14	2013-02-15
1006409	1006409	DIVIDEND	ADD	01973R101		0	0	1	0	.06		00	2012-11-14	2012-11-16	2012-11-30	2012-11-06		0	2012-11-06	?	0	0004456590			20121106.ifs	2012-11-06	2012-11-07
857242	857242	DIVIDEND	ADD	01973R101		0	0	1	4	.06		00	2012-05-16	2012-05-18	2012-05-31	2012-05-08		0	2012-05-08	?	0	0004373004			20120508.ifs	2012-05-08	2012-05-09
803566	803566	EQUITY	CHANGE	01973R101	COM	0	0	2012-03-15	?	0	no	no		no		2012-03-15	2012-03-16	?							20120316.ifs	2012-03-16	2012-03-17
803567	803566	EQUITY	CHANGE	01973R101	COM	0	0	2012-03-15	?	0	no	no		no		2012-03-15	2012-03-16	?							20120316.ifs	2012-03-16	2012-03-17
803568	803568	EXCHANGE	CHANGE	01973R101	01	2012-03-15	2012-03-15	ALSN	0	0	2012-03-15	2012-03-16													20120316.ifs	2012-03-16	2012-03-17
803569	803568	EXCHANGE	CHANGE	01973R101	01	2012-03-15	2012-03-15	ALSN	0	0	2012-03-15	2012-03-16													20120316.ifs	2012-03-16	2012-03-17
803570	803570	EXCHANGE	CHANGE	01973R101	01	2012-03-15	2012-03-15	ALSN	0	0	2012-03-15	2012-03-16													20120316.ifs	2012-03-16	2012-03-17
803571	803570	EXCHANGE	CHANGE	01973R101	01	2012-03-15	2012-03-15	ALSN	0	0	2012-03-15	2012-03-16													20120316.ifs	2012-03-16	2012-03-17
803572	803572	EXCHANGE	CHANGE	01973R101	01	2012-03-15	2012-03-15	ALSN	0	0	2012-03-15	2012-03-16													20120316.ifs	2012-03-16	2012-03-17
803573	803572	EXCHANGE	CHANGE	01973R101	01	2012-03-15	2012-03-15	ALSN	0	0	2012-03-15	2012-03-16													20120316.ifs	2012-03-16	2012-03-17
802455	802455	EQUITY	ADD	01973R101	COM	N	0	2012-03-15	?	0	no	no		no		2012-03-15	?	?							20120315.ifs	2012-03-15	2012-03-16
802456	802456	EXCHANGE	ADD	01973R101	01	2012-03-15	2012-03-15	ALSN	0	0	2012-03-15	?													20120315.ifs	2012-03-15	2012-03-16
803489	803489	EQUITY	CHANGE	01973R101	COM	N	0	2012-03-15	?	0	no	no		no		2012-03-15	?	?							20120315.ifs	2012-03-15	2012-03-16
803490	803489	EQUITY	CHANGE	01973R101	COM	0	0	2012-03-15	?	0	no	no		no		2012-03-15	?	?							20120315.ifs	2012-03-15	2012-03-16

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