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
2272241	2272241	CORPACTION	ADD	617460209	01	C	2016-08-18			?															20160818.ifs	2016-08-18	2016-08-19
2272242	2272242	EQUITY	CHANGE	617460209	CAP SECS %	0	1	2003-02-20	?	0	yes	no		no		2003-03-28	?	?							20160818.ifs	2016-08-18	2016-08-19
2272243	2272242	EQUITY	CHANGE	617460209	CAP SECS %	C	1	2003-02-20	2016-08-18	0	yes	no		no		2003-03-28	2016-08-18	?							20160818.ifs	2016-08-18	2016-08-19
2253686	2253686	DIVIDEND	ADD	617460209		0	0	C	0	25		12	?	?	2016-08-18	2016-07-19		0	?	2016-07-20	0				20160720.ifs	2016-07-20	2016-07-21
2253284	2253284	DIVIDEND	ADD	617460209		0	0	1	0	.334201		00	?	?	2016-08-18	2016-07-19		0	2016-07-19	?	0	0005252496			20160719.ifs	2016-07-19	2016-07-20
2144859	2144859	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2016-05-11	2016-05-15	2016-06-01	2016-03-29		0	2016-03-29	?	0	0005192872			20160329.ifs	2016-03-29	2016-03-30
2011937	2011937	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2016-02-10	2016-02-15	2016-03-01	2015-11-19		0	2015-11-19	?	0	0005094681			20151119.ifs	2015-11-19	2015-11-20
1987761	1987761	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2015-11-10	2015-11-15	2015-12-01	2015-10-07		0	2015-10-07	?	0	0005078699			20151007.ifs	2015-10-07	2015-10-08
1920848	1920848	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2015-08-12	2015-08-15	2015-09-01	2015-07-22		0	2015-07-22	?	0	0005034715			20150722.ifs	2015-07-22	2015-07-23
1810733	1810733	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2015-05-13	2015-05-15	2015-06-01	2015-03-11		0	2015-03-12	?	0	0004967671			20150312.ifs	2015-03-12	2015-03-13
1766029	1766029	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2015-02-11	2015-02-15	2015-03-02	2015-01-07		0	2015-01-07	?	0	0004940767			20150107.ifs	2015-01-07	2015-01-08
1605088	1605088	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2014-11-12	2014-11-15	2014-12-01	2014-08-12		0	2014-08-12	?	0	0004828284			20140812.ifs	2014-08-12	2014-08-13
1543571	1543571	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2014-08-13	2014-08-15	2014-09-01	2014-05-16		0	2014-06-05	?	0	0004794160			20140605.ifs	2014-06-05	2014-06-06
1500522	1500522	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2014-05-13	2014-05-15	2014-06-01	2014-04-22		0	2014-04-23	?	0	0004769911			20140423.ifs	2014-04-23	2014-04-24
1427407	1427407	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2014-02-12	2014-02-15	2014-03-03	2014-01-23		0	2014-01-24	?	0	0004725852			20140124.ifs	2014-01-24	2014-01-25
1247821	1247821	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2013-11-13	2013-11-15	2013-12-02	2013-07-25		0	2013-07-26	?	0	0004604897			20130726.ifs	2013-07-26	2013-07-27
1237456	1237456	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2013-08-13	2013-08-15	2013-09-03	2013-06-25		0	2013-07-09	?	0	0004600620			20130709.ifs	2013-07-09	2013-07-10
1120933	1120933	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2013-05-13	2013-05-15	2013-06-03	2013-02-26		0	2013-02-28	?	0	0004532791			20130228.ifs	2013-02-28	2013-03-01
1072275	1072275	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2013-02-13	2013-02-15	2013-03-01	2012-12-31		0	2013-01-02	?	0	0004509819			20130102.ifs	2013-01-02	2013-01-03
984554	984554	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2012-11-13	2012-11-15	2012-12-01	2012-10-11		0	2012-10-11	?	0	0004445135			20121011.ifs	2012-10-11	2012-10-12
811402	811402	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2012-05-11	2012-05-15	2012-06-01	2012-03-28		0	2012-03-28	?	0	0004349977			20120328.ifs	2012-03-28	2012-03-29
672169	672169	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2011-11-10	2011-11-15	2011-12-01	2011-10-13		0	2011-10-13	?	0	0004257231			20111013.ifs	2011-10-13	2011-10-14
591850	591850	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2011-08-11	2011-08-15	2011-09-01	2011-07-22		0	2011-07-22	?	0	0004219024			20110722.ifs	2011-07-22	2011-07-23
510715	510715	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2011-05-11	2011-05-13	2011-06-01	2011-04-28		0	2011-04-28	?	0	0004179166			20110428.ifs	2011-04-28	2011-04-29
433069	433069	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2011-02-11	2011-02-15	2011-03-01	2011-02-01		0	2011-02-01	?	0	0004143871			20110201.ifs	2011-02-01	2011-02-02
349233	349233	DIVIDEND	ADD	617460209		0	0	1	0	.390624		00	2010-11-09	2010-11-12	2010-12-01	2010-11-03		0	2010-11-03	?	0	0004085144			20101103.ifs	2010-11-03	2010-11-04
261174	261174	DIVIDEND	ADD	617460209		0	0	1	0	.39062		00	2010-08-13	2010-08-17	2010-09-01	2010-07-28		0	2010-07-28	?	0	0004037679			20100728.ifs	2010-07-28	2010-07-29
170068	170068	DIVIDEND	ADD	617460209		0	0	1	0	.39062		00	2010-05-12	2010-05-14	2010-06-01	2010-04-28		0	2010-04-28	?	0	0003996885			20100428.ifs	2010-04-28	2010-04-29
94244	94244	DIVIDEND	ADD	617460209		0	0	1	0	.39062		00	2010-02-10	2010-02-14	2010-03-01	2010-01-26		0	2010-01-26	?	0	0003956103			20100126.ifs	2010-01-26	2010-04-07
8856	8856	DIVIDEND	ADD	617460209		0	0	1	0	.39062		00	2009-11-12	2009-11-16	2009-12-01	2009-10-28		0	2009-10-28	?	0	0003899655			20091028.ifs	2009-10-28	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 = 142482
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