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
5538123	5538123	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2024-04-25	2024-04-26	2024-05-15	2024-04-10		0	2024-04-11	?	0	0006906019			20240411.ifs	2024-04-11	2024-04-12
5371358	5371358	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2023-09-28	2023-09-29	2023-10-17	2023-09-08		0	2023-09-11	?	0	0006781541			20230911.ifs	2023-09-11	2023-09-12
5272262	5272262	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2023-04-27	2023-04-28	2023-05-17	2023-04-12		0	2023-04-14	?	0	0006712499			20230414.ifs	2023-04-14	2023-04-15
5094355	5094355	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2022-09-28	2022-09-29	2022-10-18	2022-09-07		0	2022-09-08	?	0	0006581423			20220908.ifs	2022-09-08	2022-09-09
4993026	4993026	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2022-04-28	2022-04-29	2022-05-17	2022-04-11		0	2022-04-12	?	0	0006510630			20220412.ifs	2022-04-12	2022-04-13
4800372	4800372	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2021-09-28	2021-09-30	2021-10-15	2021-09-08		0	2021-09-10	?	0	0006366382			20210910.ifs	2021-09-10	2021-09-11
4678656	4678656	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2021-04-29	2021-04-30	2021-05-17	2021-04-07		0	2021-04-08	?	0	0006293428			20210408.ifs	2021-04-08	2021-04-09
4461101	4461101	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2020-09-29	2020-09-30	2020-10-16	2020-09-10		0	2020-09-11	?	0	0006158033			20200911.ifs	2020-09-11	2020-09-12
4286393	4286393	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2020-04-29	2020-04-30	2020-05-15	2020-04-08		0	2020-04-09	?	0	0006084963			20200409.ifs	2020-04-09	2020-04-10
4286399	4286399	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2020-04-29	2020-04-30	2020-05-15	2020-04-08		0	2020-04-09	?	0	0006084963			20200409.ifs	2020-04-09	2020-04-10
3922224	3922224	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2019-09-27	2019-09-30	2019-10-16	2019-09-11		0	2019-09-12	?	0	0005944180			20190912.ifs	2019-09-12	2019-09-13
3922233	3922233	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2019-09-27	2019-09-30	2019-10-16	2019-09-11		0	2019-09-12	?	0	0005944180			20190912.ifs	2019-09-12	2019-09-13
3683746	3683746	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2019-04-29	2019-04-30	2019-05-15	2019-04-11		0	2019-04-12	?	0	0005870269			20190412.ifs	2019-04-12	2019-04-13
3683750	3683750	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2019-04-29	2019-04-30	2019-05-15	2019-04-11		0	2019-04-12	?	0	0005870269			20190412.ifs	2019-04-12	2019-04-13
3282531	3282531	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2018-09-27	2018-09-28	2018-10-16	2018-09-12		0	2018-09-13	?	0	0005722554			20180913.ifs	2018-09-13	2018-09-14
3282614	3282614	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2018-09-27	2018-09-28	2018-10-16	2018-09-12		0	2018-09-13	?	0	0005722554			20180913.ifs	2018-09-13	2018-09-14
3038146	3038146	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2018-04-27	2018-04-30	2018-05-16	2018-04-11		0	2018-04-12	?	0	0005646823			20180412.ifs	2018-04-12	2018-04-13
3038154	3038154	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2018-04-27	2018-04-30	2018-05-16	2018-04-11		0	2018-04-12	?	0	0005646823			20180412.ifs	2018-04-12	2018-04-13
2671698	2671698	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2017-09-28	2017-09-29	2017-10-17	2017-09-13		0	2017-09-14	?	0	0005496444			20170914.ifs	2017-09-14	2017-09-15
2671928	2671928	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2017-09-28	2017-09-29	2017-10-17	2017-09-13		0	2017-09-14	?	0	0005496444			20170914.ifs	2017-09-14	2017-09-15
2542214	2542214	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2017-04-26	2017-04-28	2017-05-16	2017-04-13		0	2017-04-13	?	0	0005421057			20170413.ifs	2017-04-13	2017-04-14
2449102	2449102	EQUITY	CHANGE	00089N103	SUB VTG SHS	0	0	1999-04-19	?	0	no	no		no		2004-10-15	2004-10-13	?							20170124.ifs	2017-01-24	2017-01-25
2449103	2449102	EQUITY	CHANGE	00089N103	SUB VTG SHS	0	0	1999-04-19	?	2	no	no		no		2004-10-15	2004-10-13	?							20170124.ifs	2017-01-24	2017-01-25
2294993	2294993	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2016-09-28	2016-09-30	2016-10-17	2016-09-14		0	2016-09-15	?	0	0005280090			20160915.ifs	2016-09-15	2016-09-16
2164315	2164315	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2016-04-27	2016-04-29	2016-05-16	2016-04-14		0	2016-04-14	?	0	0005205353			20160414.ifs	2016-04-14	2016-04-15
1964565	1964565	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2015-09-28	2015-09-30	2015-10-15	2015-09-11		0	2015-09-11	?	0	0005061896			20150911.ifs	2015-09-11	2015-09-12
1838055	1838055	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2015-04-28	2015-04-30	2015-05-15	2015-04-09		0	2015-04-09	?	0	0004985255			20150409.ifs	2015-04-09	2015-04-10
1628532	1628532	DIVIDEND	CHANGE	00089N103		A	0	2	0	.1		15	2014-09-26	2014-09-30	2014-10-15	2014-09-11		0	2014-09-11	?	0	0004842284			20140912.ifs	2014-09-12	2014-09-13
1628533	1628532	DIVIDEND	CHANGE	00089N103		A	0	2	0	.01	0	15	2014-09-26	2014-09-30	2014-10-15	2014-09-11		0	2014-09-11	2014-09-12	0	0004842284			20140912.ifs	2014-09-12	2014-09-13
1629593	1629593	DIVIDEND	CHANGE	00089N103		A	0	2	0	.01	0	15	2014-09-26	2014-09-30	2014-10-15	2014-09-11		0	2014-09-11	2014-09-12	0	0004842284			20140912.ifs	2014-09-12	2014-09-13
1629594	1629593	DIVIDEND	CHANGE	00089N103		A	0	2	0	.01	0	15	2014-09-26	2014-09-30	2014-10-15	2014-09-11		1	2014-09-11	2014-09-12	0	0004842284			20140912.ifs	2014-09-12	2014-09-13
1628494	1628494	DIVIDEND	ADD	00089N103		A	0	2	0	.1		15	2014-09-26	2014-09-30	2014-10-15	2014-09-11		0	2014-09-11	?	0	0004842284			20140911.ifs	2014-09-11	2014-09-12
1494500	1494500	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2014-04-28	2014-04-30	2014-05-16	2014-04-10		0	2014-04-10	?	0	0004767704			20140410.ifs	2014-04-10	2014-04-11
1282567	1282567	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2013-09-26	2013-09-30	2013-10-16	2013-09-05		0	2013-09-05	?	0	0004626529			20130905.ifs	2013-09-05	2013-09-06
1158768	1158768	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2013-04-26	2013-04-30	2013-05-17	2013-04-11		0	2013-04-11	?	0	0004557280			20130411.ifs	2013-04-11	2013-04-12
951595	951595	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2012-09-19	2012-09-21	2012-10-15	2012-09-06		0	2012-09-06	?	0	0004426621			20120906.ifs	2012-09-06	2012-09-07
834390	834390	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2012-04-26	2012-04-30	2012-05-17	2012-04-12		0	2012-04-12	?	0	0004361075			20120412.ifs	2012-04-12	2012-04-13
638739	638739	DIVIDEND	ADD	00089N103		A	0	2	0	.01		15	2011-09-20	2011-09-22	2011-10-17	2011-09-06		0	2011-09-07	?	0	0004240446			20110907.ifs	2011-09-07	2011-09-08
502250	502250	DIVIDEND	ADD	00089N103		A	0	2	4	.01		15	2011-04-27	2011-04-29	2011-05-16	2011-04-14		0	2011-04-14	?	0	0004175284			20110414.ifs	2011-04-14	2011-04-15

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