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
2110293	2110292			111320107	60	M	2016-02-02	Y09827109	60	?															20160208.ifs	2016-02-08	2016-02-09
2110294	2110293			111320107	60	A	2016-02-02	Y09827109	60	2016-02-08															20160208.ifs	2016-02-08	2016-02-09
2110295	2110295	EQUITY	CHANGE	111320107	CL A	M	0	1998-04-17	2016-02-02	8	yes	yes	Y09827109	yes		1999-01-27	2016-02-02	?							20160208.ifs	2016-02-08	2016-02-09
2110296	2110295	EQUITY	CHANGE	111320107	CL A	A	0	1998-04-17	2016-02-02	8	yes	yes	Y09827109	yes		1999-01-27	2016-02-08	?							20160208.ifs	2016-02-08	2016-02-09
2107246	2107246	CORPACTION	ADD	111320107	60	M	2016-02-02	Y09827109	60	?															20160202.ifs	2016-02-02	2016-02-03
2107247	2107247	EQUITY	CHANGE	111320107	CL A	0	0	1998-04-17	?	8	yes	yes		yes		1999-01-27	2000-08-04	?							20160202.ifs	2016-02-02	2016-02-03
2107248	2107247	EQUITY	CHANGE	111320107	CL A	M	0	1998-04-17	2016-02-02	8	yes	yes	Y09827109	yes		1999-01-27	2016-02-02	?							20160202.ifs	2016-02-02	2016-02-03
2010563	2010563	DIVIDEND	ADD	111320107		0	0	1	0	.14		00	2015-11-25	2015-11-30	2015-12-14	2015-11-17		0	2015-11-17	?	0	0005094114			20151117.ifs	2015-11-17	2015-11-18
1940808	1940808	DIVIDEND	ADD	111320107		0	0	1	0	.14		00	2015-08-26	2015-08-28	2015-09-14	2015-08-13		0	2015-08-13	?	0	0005046912			20150813.ifs	2015-08-13	2015-08-14
1874813	1874813	DIVIDEND	CHANGE	111320107		0	0	1	0	.14		00	2015-05-27	2015-05-29	2015-06-15	2015-05-12		0	2015-05-12	?	0	0004999803			20150529.ifs	2015-05-29	2015-05-30
1874814	1874813	DIVIDEND	CHANGE	111320107		0	0	1	0	.14		00	2015-05-27	2015-05-29	2015-06-15	2015-05-12		1	2015-05-12	2015-05-29	0	0004999803			20150529.ifs	2015-05-29	2015-05-30
1862141	1862141	DIVIDEND	ADD	111320107		0	0	1	0	.14		00	2015-05-27	2015-05-29	2015-06-15	2015-05-12		0	2015-05-12	?	0	0004999803			20150512.ifs	2015-05-12	2015-05-13
1777674	1777674	DIVIDEND	ADD	111320107		0	0	1	0	.14		00	2015-02-11	2015-02-13	2015-03-02	2015-01-29		0	2015-01-29	?	0	0004945229			20150129.ifs	2015-01-29	2015-01-30
1684034	1684034	DIVIDEND	ADD	111320107		0	0	1	0	.12		00	2014-11-26	2014-12-01	2014-12-15	2014-11-19		0	2014-11-19	?	0	0004873998			20141119.ifs	2014-11-19	2014-11-20
1607045	1607045	DIVIDEND	ADD	111320107		0	0	1	0	.12		00	2014-08-27	2014-08-29	2014-09-15	2014-08-14		0	2014-08-14	?	0	0004828805			20140814.ifs	2014-08-14	2014-08-15
1523510	1523510	DIVIDEND	ADD	111320107		0	0	1	0	.12		00	2014-05-28	2014-05-30	2014-06-16	2014-05-13		0	2014-05-13	?	0	0004782070			20140513.ifs	2014-05-13	2014-05-14
1430809	1430809	DIVIDEND	ADD	111320107		0	0	1	0	.12		00	2014-02-12	2014-02-14	2014-03-03	2014-01-29		0	2014-01-30	?	0	0004727326			20140130.ifs	2014-01-30	2014-01-31
1339421	1339421	DIVIDEND	ADD	111320107		0	0	1	0	.11		00	2013-11-21	2013-11-25	2013-12-09	2013-11-13		0	2013-11-13	?	0	0004657688			20131113.ifs	2013-11-13	2013-11-14
1265686	1265686	DIVIDEND	ADD	111320107		0	0	1	0	.11		00	2013-08-28	2013-08-30	2013-09-16	2013-08-15		0	2013-08-15	?	0	0004615632			20130815.ifs	2013-08-15	2013-08-16
1185475	1185475	DIVIDEND	ADD	111320107		0	0	1	0	.11		00	2013-05-29	2013-05-31	2013-06-17	2013-05-14		0	2013-05-14	?	0	0004571071			20130514.ifs	2013-05-14	2013-05-15
1098300	1098300	DIVIDEND	ADD	111320107		0	0	1	0	.11		00	2013-02-13	2013-02-15	2013-03-04	2013-01-28		0	2013-01-29	?	0	0004518332			20130129.ifs	2013-01-29	2013-01-30
1007013	1007013	DIVIDEND	ADD	111320107		0	0	1	0	.1		00	2012-11-20	2012-11-23	2012-12-10	2012-11-07		0	2012-11-07	?	0	0004456764			20121107.ifs	2012-11-07	2012-11-08
934345	934345	DIVIDEND	ADD	111320107		0	0	1	0	.1		00	2012-08-29	2012-08-31	2012-09-17	2012-08-16		0	2012-08-16	?	0	0004416516			20120816.ifs	2012-08-16	2012-08-17
868879	868879	DIVIDEND	CHANGE	111320107		0	0	1	0	.1		00	2012-02-15	2012-02-17	2012-03-05	2012-01-30		2	2012-01-31	2012-05-30	0	0004324504			20120531.ifs	2012-05-31	2012-06-01
868880	868879	DIVIDEND	CHANGE	111320107		0	0	1	0	.1		00	2012-02-15	2012-02-17	2012-03-05	2012-01-30		2	2012-01-31	2012-05-30	0	0004324504			20120531.ifs	2012-05-31	2012-06-01
869119	869119	DIVIDEND	CHANGE	111320107		0	0	1	0	.1		00	2012-05-30	2012-06-01	2012-06-18	2012-05-15		1	2012-05-15	2012-05-30	0	0004374252			20120531.ifs	2012-05-31	2012-06-01
869120	869119	DIVIDEND	CHANGE	111320107		0	0	1	0	.1		00	2012-05-30	2012-06-01	2012-06-18	2012-05-15		1	2012-05-15	2012-05-30	0	0004374252			20120531.ifs	2012-05-31	2012-06-01
867704	867704	DIVIDEND	CHANGE	111320107		0	0	1	0	.1		00	2012-05-30	2012-06-01	2012-06-18	2012-05-15		0	2012-05-15	?	0	0004374252			20120530.ifs	2012-05-30	2012-05-31
867705	867704	DIVIDEND	CHANGE	111320107		0	0	1	0	.1		00	2012-05-30	2012-06-01	2012-06-18	2012-05-15		1	2012-05-15	2012-05-30	0	0004374252			20120530.ifs	2012-05-30	2012-05-31
867706	867706	DIVIDEND	CHANGE	111320107		0	0	1	0	.1		00	2012-02-15	2012-02-17	2012-03-05	2012-01-30		1	2012-01-31	2012-02-15	0	0004324504			20120530.ifs	2012-05-30	2012-05-31
867707	867706	DIVIDEND	CHANGE	111320107		0	0	1	0	.1		00	2012-02-15	2012-02-17	2012-03-05	2012-01-30		2	2012-01-31	2012-05-30	0	0004324504			20120530.ifs	2012-05-30	2012-05-31
861775	861775	DIVIDEND	ADD	111320107		0	0	1	0	.1		00	2012-05-30	2012-06-01	2012-06-18	2012-05-15		0	2012-05-15	?	0	0004374252			20120515.ifs	2012-05-15	2012-05-16
780095	780095	DIVIDEND	CHANGE	111320107		0	0	1	0	.1		00	2012-02-15	2012-02-17	2012-03-05	2012-01-30		0	2012-01-31	?	0	0004324504			20120215.ifs	2012-02-15	2012-02-16
780096	780095	DIVIDEND	CHANGE	111320107		0	0	1	0	.1		00	2012-02-15	2012-02-17	2012-03-05	2012-01-30		1	2012-01-31	2012-02-15	0	0004324504			20120215.ifs	2012-02-15	2012-02-16
768021	768021	DIVIDEND	ADD	111320107		0	0	1	0	.1		00	2012-02-15	2012-02-17	2012-03-05	2012-01-30		0	2012-01-31	?	0	0004324504			20120131.ifs	2012-01-31	2012-02-01
692653	692653	DIVIDEND	ADD	111320107		0	0	1	0	.09		00	2011-11-30	2011-12-02	2011-12-19	2011-11-09		0	2011-11-09	?	0	0004269142			20111109.ifs	2011-11-09	2011-11-10
614744	614744	DIVIDEND	ADD	111320107		0	0	1	0	.09		00	2011-08-24	2011-08-26	2011-09-12	2011-08-11		0	2011-08-11	?	0	0004229188			20110811.ifs	2011-08-11	2011-08-12
521132	521132	DIVIDEND	ADD	111320107		0	0	1	0	.09		00	2011-05-18	2011-05-20	2011-06-06	2011-05-05		0	2011-05-05	?	0	0004186592			20110505.ifs	2011-05-05	2011-05-06
434769	434769	DIVIDEND	ADD	111320107		0	0	1	0	.09		00	2011-02-16	2011-02-18	2011-03-07	2011-01-31		0	2011-02-01	?	0	0004143645			20110201.ifs	2011-02-01	2011-02-02
353780	353780	DIVIDEND	ADD	111320107		0	0	1	0	.08		00	2010-11-23	2010-11-26	2010-12-13	2010-11-11		0	2010-11-11	?	0	0004086859			20101111.ifs	2010-11-11	2010-11-12
278269	278269	DIVIDEND	ADD	111320107		0	0	1	0	.08		00	2010-08-25	2010-08-27	2010-09-13	2010-08-12		0	2010-08-12	?	0	0004047063			20100812.ifs	2010-08-12	2010-08-13
196401	196401	DIVIDEND	ADD	111320107		0	0	1	0	.08		00	2010-06-02	2010-06-04	2010-06-21	2010-05-20		0	2010-05-20	?	0	0004007503			20100520.ifs	2010-05-20	2010-05-21
104592	104592	DIVIDEND	ADD	111320107		0	0	1	0	.08		35	2010-02-17	2010-02-19	2010-03-08	2010-01-27		0	2010-02-03	?	0	0003963432			20100203.ifs	2010-02-03	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 = 130928
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