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
3160932	3160932	CORPACTION	ADD	317923100	60	A	2018-06-19	46618Q109	66	2018-06-28															20180628.ifs	2018-06-28	2018-06-29
3160934	3160934	EQUITY	CHANGE	317923100	CL A	0	0	1992-06-09	?	4	yes	yes		yes		1996-12-18	2001-11-12	?							20180628.ifs	2018-06-28	2018-06-29
3160936	3160935	EQUITY	CHANGE	317923100	CL A	A	0	1992-06-09	2018-06-19	4	yes	yes	46618Q109	yes		1996-12-18	2018-06-28	?							20180628.ifs	2018-06-28	2018-06-29
3160938	3160938	EXCHANGE	CHANGE	317923100	60	1992-06-09	2018-06-27	FINL	0	0	?	2001-02-05													20180628.ifs	2018-06-28	2018-06-29
3160940	3160939	EXCHANGE	CHANGE	317923100	60	1992-06-09	2018-06-18	FINL	0	0	?	2018-06-28													20180628.ifs	2018-06-28	2018-06-29
3160957	3160957	CORPACTION	ADD	317923100	60	A	2018-06-19	46618Q109	66	2018-06-28															20180628.ifs	2018-06-28	2018-06-29
3160959	3160959	EQUITY	CHANGE	317923100	CL A	0	0	1992-06-09	?	4	yes	yes		yes		1996-12-18	2001-11-12	?							20180628.ifs	2018-06-28	2018-06-29
3160961	3160960	EQUITY	CHANGE	317923100	CL A	A	0	1992-06-09	2018-06-19	4	yes	yes	46618Q109	yes		1996-12-18	2018-06-28	?							20180628.ifs	2018-06-28	2018-06-29
3160963	3160963	EXCHANGE	CHANGE	317923100	60	1992-06-09	2018-06-27	FINL	0	0	?	2001-02-05													20180628.ifs	2018-06-28	2018-06-29
3160965	3160964	EXCHANGE	CHANGE	317923100	60	1992-06-09	2018-06-18	FINL	0	0	?	2018-06-28													20180628.ifs	2018-06-28	2018-06-29
3134087	3134087	DIVIDEND	CHANGE	317923100		0	0	1	0	.115		00	2018-05-17	2018-05-18	2018-06-04	2018-04-19		0	2018-04-19	?	0	0005648216			20180611.ifs	2018-06-11	2018-06-12
3134089	3134088	DIVIDEND	CHANGE	317923100		0	0	1	0	.115		00	2018-05-17	2018-05-18	2018-06-04	2018-04-19		1	2018-04-19	2018-06-11	0	0005648216			20180611.ifs	2018-06-11	2018-06-12
3134102	3134102	DIVIDEND	CHANGE	317923100		0	0	1	0	.115		00	2018-05-17	2018-05-18	2018-06-04	2018-04-19		0	2018-04-19	?	0	0005648216			20180611.ifs	2018-06-11	2018-06-12
3134103	3134102	DIVIDEND	CHANGE	317923100		0	0	1	0	.115		00	2018-05-17	2018-05-18	2018-06-04	2018-04-19		1	2018-04-19	2018-06-11	0	0005648216			20180611.ifs	2018-06-11	2018-06-12
3044044	3044044	DIVIDEND	ADD	317923100		0	0	1	0	.115		00	2018-05-17	2018-05-18	2018-06-04	2018-04-19		0	2018-04-19	?	0	0005648216			20180419.ifs	2018-04-19	2018-04-20
3044057	3044057	DIVIDEND	ADD	317923100		0	0	1	0	.115		00	2018-05-17	2018-05-18	2018-06-04	2018-04-19		0	2018-04-19	?	0	0005648216			20180419.ifs	2018-04-19	2018-04-20
2920518	2920518	DIVIDEND	ADD	317923100		0	0	1	0	.115		00	2018-03-01	2018-03-02	2018-03-19	2018-01-17		0	2018-01-17	?	0	0005602046			20180117.ifs	2018-01-17	2018-01-18
2920526	2920526	DIVIDEND	ADD	317923100		0	0	1	0	.115		00	2018-03-01	2018-03-02	2018-03-19	2018-01-17		0	2018-01-17	?	0	0005602046			20180117.ifs	2018-01-17	2018-01-18
2727636	2727636	DIVIDEND	ADD	317923100		0	0	1	0	.11		00	2017-11-22	2017-11-24	2017-12-11	2017-10-18		0	2017-10-18	?	0	0005515506			20171018.ifs	2017-10-18	2017-10-19
2622655	2622655	DIVIDEND	ADD	317923100		0	0	1	0	.11		00	2017-08-23	2017-08-25	2017-09-11	2017-07-13		0	2017-07-13	?	0	0005468281			20170713.ifs	2017-07-13	2017-07-14
2542176	2542176	DIVIDEND	ADD	317923100		0	0	1	0	.11		00	2017-05-24	2017-05-26	2017-06-12	2017-04-13		0	2017-04-13	?	0	0005421067			20170413.ifs	2017-04-13	2017-04-14
2437890	2437890	EQUITY	CHANGE	317923100	CL A	0	0	1992-06-09	?	0	yes	yes		yes		1996-12-18	2001-11-12	?							20170123.ifs	2017-01-23	2017-01-24
2437891	2437890	EQUITY	CHANGE	317923100	CL A	0	0	1992-06-09	?	4	yes	yes		yes		1996-12-18	2001-11-12	?							20170123.ifs	2017-01-23	2017-01-24
2424294	2424294	DIVIDEND	ADD	317923100		0	0	1	0	.11		00	2017-02-22	2017-02-24	2017-03-13	2017-01-11		0	2017-01-11	?	0	0005374378			20170111.ifs	2017-01-11	2017-01-12
2320893	2320893	DIVIDEND	ADD	317923100		0	0	1	0	.1		00	2016-11-22	2016-11-25	2016-12-12	2016-10-13		0	2016-10-13	?	0	0005298042			20161013.ifs	2016-10-13	2016-10-14
2251285	2251285	DIVIDEND	ADD	317923100		0	0	1	0	.1		00	2016-08-24	2016-08-26	2016-09-12	2016-07-14		0	2016-07-14	?	0	0005251506			20160714.ifs	2016-07-14	2016-07-15
2164236	2164236	DIVIDEND	ADD	317923100		0	0	1	0	.1		00	2016-05-25	2016-05-27	2016-06-13	2016-04-14		0	2016-04-14	?	0	0005205430			20160414.ifs	2016-04-14	2016-04-15
2102516	2102516	DIVIDEND	ADD	317923100		0	0	1	0	.1		00	2016-02-24	2016-02-26	2016-03-14	2016-01-07		0	2016-01-29	?	0	0005164341			20160129.ifs	2016-01-29	2016-01-30
1991384	1991384	DIVIDEND	ADD	317923100		0	0	1	0	.09		00	2015-11-24	2015-11-27	2015-12-14	2015-10-15		0	2015-10-15	?	0	0005079679			20151015.ifs	2015-10-15	2015-10-16
1917988	1917988	DIVIDEND	ADD	317923100		0	0	1	0	.09		00	2015-08-26	2015-08-28	2015-09-14	2015-07-16		0	2015-07-16	?	0	0005033299			20150716.ifs	2015-07-16	2015-07-17
1841569	1841569	DIVIDEND	ADD	317923100		0	0	1	0	.09		00	2015-05-27	2015-05-29	2015-06-15	2015-04-16		0	2015-04-16	?	0	0004986562			20150416.ifs	2015-04-16	2015-04-17
1769460	1769460	DIVIDEND	ADD	317923100		0	0	1	0	.09		00	2015-02-25	2015-02-27	2015-03-16	2015-01-15		0	2015-01-15	?	0	0004941862			20150115.ifs	2015-01-15	2015-01-16
1657839	1657839	DIVIDEND	ADD	317923100		0	0	1	0	.08		00	2014-11-25	2014-11-28	2014-12-15	2014-10-15		0	2014-10-15	?	0	0004859887			20141015.ifs	2014-10-15	2014-10-16
1582890	1582890	DIVIDEND	DELETE	317923100		0	0	1	0	.08		00	2014-08-27	2014-08-29	2014-07-15	2014-07-17		0	2014-07-17	?	0	0004815568			20140718.ifs	2014-07-18	2014-07-19
1582891	1582891	DIVIDEND	ADD	317923100		0	0	1	0	.08		00	2014-08-27	2014-08-29	2014-09-15	2014-07-17		1	2014-07-17	2014-07-18	0	0004815568			20140718.ifs	2014-07-18	2014-07-19
1582006	1582006	DIVIDEND	ADD	317923100		0	0	1	0	.08		00	2014-08-27	2014-08-29	2014-07-15	2014-07-17		0	2014-07-17	?	0	0004815568			20140717.ifs	2014-07-17	2014-07-18
1496917	1496917	DIVIDEND	ADD	317923100		0	0	1	0	.08		00	2014-05-28	2014-05-30	2014-06-16	2014-04-16		0	2014-04-16	?	0	0004768533			20140416.ifs	2014-04-16	2014-04-17
1423555	1423555	DIVIDEND	ADD	317923100		0	0	1	0	.08		00	2014-02-26	2014-02-28	2014-03-17	2014-01-16		0	2014-01-16	?	0	0004724540			20140116.ifs	2014-01-16	2014-01-17
1317091	1317091	DIVIDEND	ADD	317923100		0	0	1	0	.07		00	2013-11-26	2013-11-29	2013-12-16	2013-10-16		0	2013-10-16	?	0	0004645754			20131016.ifs	2013-10-16	2013-10-17
1242632	1242632	DIVIDEND	ADD	317923100		0	0	1	0	.07		00	2013-08-28	2013-08-30	2013-09-16	2013-07-18		0	2013-07-18	?	0	0004602394			20130718.ifs	2013-07-18	2013-07-19
1165242	1165242	DIVIDEND	ADD	317923100		0	0	1	0	.07		00	2013-05-29	2013-05-31	2013-06-17	2013-04-23		0	2013-04-23	?	0	0004559701			20130423.ifs	2013-04-23	2013-04-24
1091285	1091285	DIVIDEND	ADD	317923100		0	0	1	0	.07		00	2013-02-27	2013-03-01	2013-03-18	2013-01-16		0	2013-01-16	?	0	0004515571			20130116.ifs	2013-01-16	2013-01-17
987776	987776	DIVIDEND	ADD	317923100		0	0	1	0	.06		00	2012-11-28	2012-11-30	2012-12-17	2012-10-17		0	2012-10-17	?	0	0004445949			20121017.ifs	2012-10-17	2012-10-18
915986	915986	DIVIDEND	ADD	317923100		0	0	1	0	.06		00	2012-08-29	2012-08-31	2012-09-17	2012-07-20		0	2012-07-20	?	0	0004403899			20120720.ifs	2012-07-20	2012-07-21
837530	837530	DIVIDEND	ADD	317923100		0	0	1	0	.06		00	2012-05-30	2012-06-01	2012-06-18	2012-04-18		0	2012-04-18	?	0	0004362206			20120418.ifs	2012-04-18	2012-04-19
758569	758569	DIVIDEND	ADD	317923100		0	0	1	0	.06		00	2012-02-29	2012-03-02	2012-03-19	2012-01-18		0	2012-01-18	?	0	0004321314			20120118.ifs	2012-01-18	2012-01-19
675219	675219	DIVIDEND	ADD	317923100		0	0	1	0	.05		00	2011-11-22	2011-11-25	2011-12-12	2011-10-19		0	2011-10-19	?	0	0004258213			20111019.ifs	2011-10-19	2011-10-20
506165	506165	DIVIDEND	ADD	317923100		0	0	1	0	.05		00	2011-05-25	2011-05-27	2011-06-13	2011-04-20		0	2011-04-20	?	0	0004176650			20110420.ifs	2011-04-20	2011-04-21
421445	421445	DIVIDEND	ADD	317923100		0	0	1	0	.05		00	2011-02-23	2011-02-25	2011-03-14	2011-01-20		0	2011-01-20	?	0	0004135696			20110120.ifs	2011-01-20	2011-01-21
339658	339658	DIVIDEND	ADD	317923100		0	0	1	0	.04		00	2010-11-23	2010-11-26	2010-12-13	2010-10-21		0	2010-10-21	?	0	0004076080			20101021.ifs	2010-10-21	2010-10-22
257921	257921	DIVIDEND	ADD	317923100		0	0	1	0	.04		00	2010-08-25	2010-08-27	2010-09-13	2010-07-22		0	2010-07-22	?	0	0004035958			20100722.ifs	2010-07-22	2010-07-23
163483	163483	DIVIDEND	ADD	317923100		0	0	1	0	.04		00	2010-05-26	2010-05-28	2010-06-14	2010-04-21		0	2010-04-21	?	0	0003994863			20100421.ifs	2010-04-21	2010-04-22
92123	92123	DIVIDEND	ADD	317923100		0	0	1	0	.04		00	2010-02-24	2010-02-26	2010-03-15	2010-01-21		0	2010-01-21	?	0	0003955284			20100121.ifs	2010-01-21	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 = 130982
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