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
2240698	2240698	CORPACTION	ADD	001204106	01	A	2016-07-01			2016-07-01															20160701.ifs	2016-07-01	2016-07-02
2240699	2240699	EQUITY	CHANGE	001204106	COM	0	0	1996-03-07	?	4	yes	yes		no		1996-03-07	2001-04-17	?							20160701.ifs	2016-07-01	2016-07-02
2240700	2240699	EQUITY	CHANGE	001204106	COM	A	0	1996-03-07	2016-07-01	4	yes	yes		no		1996-03-07	2016-07-01	?							20160701.ifs	2016-07-01	2016-07-02
2240194	2240194	DIVIDEND	CHANGE	001204106		0	0	1	0	.53		00	2016-05-11	2016-05-13	2016-06-01	2016-05-03		1	2016-05-03	2016-06-29	0	0005216349			20160630.ifs	2016-06-30	2016-07-01
2240195	2240194	DIVIDEND	CHANGE	001204106		0	0	1	0	.53		00	2016-05-11	2016-05-13	2016-06-01	2016-05-03		2	2016-05-03	2016-06-30	0	0005216349			20160630.ifs	2016-06-30	2016-07-01
2235721	2235721	DIVIDEND	CHANGE	001204106		0	0	1	0	.53		00	2016-05-11	2016-05-13	2016-06-01	2016-05-03		0	2016-05-03	?	0	0005216349			20160629.ifs	2016-06-29	2016-06-30
2235722	2235721	DIVIDEND	CHANGE	001204106		0	0	1	0	.53		00	2016-05-11	2016-05-13	2016-06-01	2016-05-03		1	2016-05-03	2016-06-29	0	0005216349			20160629.ifs	2016-06-29	2016-06-30
2190798	2190798	DIVIDEND	ADD	001204106		0	0	1	0	.53		00	2016-05-11	2016-05-13	2016-06-01	2016-05-03		0	2016-05-03	?	0	0005216349			20160503.ifs	2016-05-03	2016-05-04
2111906	2111906	DIVIDEND	ADD	001204106		0	0	1	0	.53		00	2016-02-17	2016-02-19	2016-03-01	2016-02-10		0	2016-02-10	?	0	0005171765			20160210.ifs	2016-02-10	2016-02-11
1947240	1947240	DIVIDEND	CHANGE	001204106		0	0	1	0	.51		00	2015-08-12	2015-08-14	2015-09-01	2015-07-28		0	2015-07-29	?	0	0005036321			20150825.ifs	2015-08-25	2015-08-26
1947241	1947240	DIVIDEND	CHANGE	001204106		0	0	1	0	.51		00	2015-08-12	2015-08-14	2015-09-01	2015-07-28		1	2015-07-29	2015-08-25	0	0005036321			20150825.ifs	2015-08-25	2015-08-26
1925409	1925409	DIVIDEND	ADD	001204106		0	0	1	0	.51		00	2015-08-12	2015-08-14	2015-09-01	2015-07-28		0	2015-07-29	?	0	0005036321			20150729.ifs	2015-07-29	2015-07-30
1857903	1857903	DIVIDEND	ADD	001204106		0	0	1	0	.51		00	2015-05-13	2015-05-15	2015-06-01	2015-04-28		0	2015-05-01	?	0	0004995731			20150501.ifs	2015-05-01	2015-05-02
1785812	1785812	DIVIDEND	ADD	001204106		0	0	1	0	.51		00	2015-02-11	2015-02-13	2015-03-01	2015-02-03		0	2015-02-03	?	0	0004952113			20150203.ifs	2015-02-03	2015-02-04
1665420	1665420	DIVIDEND	ADD	001204106		0	0	1	0	.49		00	2014-11-12	2014-11-14	2014-12-01	2014-10-29		0	2014-10-29	?	0	0004862883			20141029.ifs	2014-10-29	2014-10-30
1590176	1590176	DIVIDEND	ADD	001204106		0	0	1	0	.49		00	2014-08-13	2014-08-15	2014-09-01	2014-07-30		0	2014-07-30	?	0	0004818414			20140730.ifs	2014-07-30	2014-07-31
1508005	1508005	DIVIDEND	ADD	001204106		0	0	1	0	.49		00	2014-05-14	2014-05-16	2014-06-01	2014-04-29		0	2014-04-30	?	0	0004772652			20140430.ifs	2014-04-30	2014-05-01
1439156	1439156	DIVIDEND	ADD	001204106		0	0	1	0	.49		00	2014-02-12	2014-02-14	2014-03-01	2014-02-04		0	2014-02-04	?	0	0004734362			20140204.ifs	2014-02-04	2014-02-05
1326085	1326085	DIVIDEND	ADD	001204106		0	0	1	0	.47		00	2013-11-13	2013-11-15	2013-12-01	2013-10-29		0	2013-10-30	?	0	0004648615			20131030.ifs	2013-10-30	2013-10-31
1253577	1253577	DIVIDEND	ADD	001204106		0	0	1	0	.47		00	2013-08-14	2013-08-16	2013-09-01	2013-07-31		0	2013-07-31	?	0	0004605885			20130731.ifs	2013-07-31	2013-08-01
1178011	1178011	DIVIDEND	ADD	001204106		0	0	1	0	.47		00	2013-05-15	2013-05-17	2013-06-01	2013-04-30		0	2013-05-01	?	0	0004565136			20130501.ifs	2013-05-01	2013-05-02
1108566	1108566	DIVIDEND	ADD	001204106		0	0	1	0	.47		00	2013-02-13	2013-02-15	2013-03-01	2013-02-05		0	2013-02-05	?	0	0004526242			20130205.ifs	2013-02-05	2013-02-06
1003081	1003081	DIVIDEND	ADD	001204106		0	0	1	0	.46		00	2012-11-14	2012-11-16	2012-12-01	2012-10-31		0	2012-11-01	?	0	0004453982			20121101.ifs	2012-11-01	2012-11-02
854225	854225	DIVIDEND	ADD	001204106		0	0	1	0	.46		00	2012-05-16	2012-05-18	2012-06-01	2012-05-02		0	2012-05-02	?	0	0004371651			20120502.ifs	2012-05-02	2012-05-03
775798	775798	DIVIDEND	DELETE	001204106		0	0	1	0	.3511		00	2012-02-15	2012-02-17	2012-03-01	2011-12-23		0	?	2011-12-27	0	0004266243			20120207.ifs	2012-02-07	2012-02-08
775799	775799	DIVIDEND	ADD	001204106		0	0	1	0	.3611		00	2012-02-15	2012-02-17	2012-03-01	2012-02-07		0	?	2012-02-07	1	0004266243			20120207.ifs	2012-02-07	2012-02-08
737863	737863	DIVIDEND	ADD	001204106		0	0	1	0	.3511		00	2012-02-15	2012-02-17	2012-03-01	2011-12-23		0	?	2011-12-27	0	0004266243			20111227.ifs	2011-12-27	2011-12-28
725630	725630	CORPACTION	ADD	001204106	01	#	2011-12-16	001204106	01	?															20111216.ifs	2011-12-16	2011-12-17
725631	725631	CORPACTIONAUX	ADD	001204106	01	2011-12-16	AGL	AGL RES INC	COM	GAS	AGL RES INC	COM	2011-12-16	?											20111216.ifs	2011-12-16	2011-12-17
725632	725632	EXCHANGE	CHANGE	001204106	01	1996-03-07	2011-12-15	AGL	0	0	2001-01-29	2009-02-09													20111216.ifs	2011-12-16	2011-12-17
725633	725632	EXCHANGE	CHANGE	001204106	01	1996-03-07	2011-12-15	GAS	0	0	2001-01-29	2011-12-16													20111216.ifs	2011-12-16	2011-12-17
718469	718469	DIVIDEND	ADD	001204106		0	1	1	0	.098901		14	2011-12-12	2011-12-08	2011-12-16	2011-12-09		0	2011-12-09	?	0	0004284711			20111209.ifs	2011-12-09	2011-12-10
699578	699578	DIVIDEND	ADD	001204106		0	0	1	0	.45		00	2011-11-16	2011-11-18	2011-12-01	2011-11-01		0	?	2011-11-25	0	0004266141			20111125.ifs	2011-11-25	2011-11-26
604261	604261	DIVIDEND	ADD	001204106		0	0	1	0	.45		00	2011-08-17	2011-08-19	2011-09-01	2011-08-02		0	2011-08-02	?	0	0004226907			20110802.ifs	2011-08-02	2011-08-03
520466	520466	DIVIDEND	ADD	001204106		0	0	1	0	.45		00	2011-05-11	2011-05-13	2011-06-01	2011-05-03		0	2011-05-04	?	0	0004186243			20110504.ifs	2011-05-04	2011-05-05
440268	440268	DIVIDEND	ADD	001204106		0	0	1	0	.45		00	2011-02-16	2011-02-18	2011-03-01	2011-02-08		0	2011-02-09	?	0	0004145943			20110209.ifs	2011-02-09	2011-02-10
344315	344315	DIVIDEND	ADD	001204106		0	0	1	0	.44		00	2010-11-17	2010-11-19	2010-12-01	2010-10-28		0	2010-10-28	?	0	0004077907			20101028.ifs	2010-10-28	2010-10-29
261775	261775	DIVIDEND	ADD	001204106		0	0	1	0	.44		00	2010-08-11	2010-08-13	2010-09-01	2010-07-28		0	2010-07-28	?	0	0004037205			20100728.ifs	2010-07-28	2010-07-29
170405	170405	DIVIDEND	ADD	001204106		0	0	1	0	.44		00	2010-05-12	2010-05-14	2010-06-01	2010-04-27		0	2010-04-28	?	0	0003996749			20100428.ifs	2010-04-28	2010-04-29
105520	105520	DIVIDEND	ADD	001204106		0	0	1	0	.44		00	2010-02-17	2010-02-19	2010-03-01	2010-02-04		0	2010-02-04	?	0	0003963471			20100204.ifs	2010-02-04	2010-04-07
9196	9196	DIVIDEND	ADD	001204106		0	0	1	0	.43		00	2009-11-10	2009-11-13	2009-12-01	2009-10-28		0	2009-10-28	?	0	0003899526			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 = 130562
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