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
3046497	3046497	CORPACTION	ADD	073844102	60	A	2018-04-23			?															20180423.ifs	2018-04-23	2018-04-24
3046499	3046499	EQUITY	CHANGE	073844102	COM	0	0	2014-06-03	?	4	no	no		yes		2014-06-03	2014-06-05	?							20180423.ifs	2018-04-23	2018-04-24
3046500	3046500	CORPACTION	ADD	073844102	60	A	2018-04-23			?															20180423.ifs	2018-04-23	2018-04-24
3046501	3046500	EQUITY	CHANGE	073844102	COM	A	0	2014-06-03	2018-04-23	4	no	no		yes		2014-06-03	2018-04-23	?							20180423.ifs	2018-04-23	2018-04-24
3046502	3046502	EQUITY	CHANGE	073844102	COM	0	0	2014-06-03	?	4	no	no		yes		2014-06-03	2014-06-05	?							20180423.ifs	2018-04-23	2018-04-24
3046503	3046502	EQUITY	CHANGE	073844102	COM	A	0	2014-06-03	2018-04-23	4	no	no		yes		2014-06-03	2018-04-23	?							20180423.ifs	2018-04-23	2018-04-24
3036892	3036892	DIVIDEND	CHANGE	073844102		0	0	1	0	.03		00	2018-01-31	2018-02-01	2018-02-15	2018-01-17		0	2018-01-17	?	0	0005602114			20180411.ifs	2018-04-11	2018-04-12
3036894	3036893	DIVIDEND	CHANGE	073844102		0	0	1	0	.03		00	2018-01-31	2018-02-01	2018-02-15	2018-01-17		1	2018-01-17	2018-04-11	0	0005602114			20180411.ifs	2018-04-11	2018-04-12
3036914	3036914	DIVIDEND	CHANGE	073844102		0	0	1	0	.03		00	2018-01-31	2018-02-01	2018-02-15	2018-01-17		0	2018-01-17	?	0	0005602114			20180411.ifs	2018-04-11	2018-04-12
3036916	3036915	DIVIDEND	CHANGE	073844102		0	0	1	0	.03		00	2018-01-31	2018-02-01	2018-02-15	2018-01-17		1	2018-01-17	2018-04-11	0	0005602114			20180411.ifs	2018-04-11	2018-04-12
2920581	2920581	DIVIDEND	ADD	073844102		0	0	1	0	.03		00	2018-01-31	2018-02-01	2018-02-15	2018-01-17		0	2018-01-17	?	0	0005602114			20180117.ifs	2018-01-17	2018-01-18
2920605	2920605	DIVIDEND	ADD	073844102		0	0	1	0	.03		00	2018-01-31	2018-02-01	2018-02-15	2018-01-17		0	2018-01-17	?	0	0005602114			20180117.ifs	2018-01-17	2018-01-18
2727702	2727702	DIVIDEND	ADD	073844102		0	0	1	0	.03		00	2017-10-31	2017-11-01	2017-11-15	2017-10-18		0	2017-10-18	?	0	0005515654			20171018.ifs	2017-10-18	2017-10-19
2653563	2653563	DIVIDEND	CHANGE	073844102		0	0	1	0	.03		00	2017-08-03	2017-08-07	2017-08-21	2017-07-26		0	2017-07-26	?	0	0005471549			20170823.ifs	2017-08-23	2017-08-24
2653564	2653563	DIVIDEND	CHANGE	073844102		0	0	1	0	.03		00	2017-08-03	2017-08-07	2017-08-21	2017-07-26		1	2017-07-26	2017-08-23	0	0005471549			20170823.ifs	2017-08-23	2017-08-24
2631680	2631680	DIVIDEND	ADD	073844102		0	0	1	0	.03		00	2017-08-03	2017-08-07	2017-08-21	2017-07-26		0	2017-07-26	?	0	0005471549			20170726.ifs	2017-07-26	2017-07-27
2544485	2544485	DIVIDEND	ADD	073844102		0	0	1	0	.03		00	2017-04-27	2017-05-01	2017-05-15	2017-04-19		0	2017-04-19	?	0	0005422104			20170419.ifs	2017-04-19	2017-04-20
2435114	2435114	EQUITY	CHANGE	073844102	COM	0	0	2014-06-03	?	0	no	no		yes		2014-06-03	2014-06-05	?							20170123.ifs	2017-01-23	2017-01-24
2435115	2435114	EQUITY	CHANGE	073844102	COM	0	0	2014-06-03	?	4	no	no		yes		2014-06-03	2014-06-05	?							20170123.ifs	2017-01-23	2017-01-24
2427959	2427959	DIVIDEND	ADD	073844102		0	0	1	0	.03		00	2017-01-30	2017-02-01	2017-02-15	2017-01-18		0	2017-01-18	?	0	0005375583			20170118.ifs	2017-01-18	2017-01-19
2323244	2323244	DIVIDEND	ADD	073844102		0	0	1	0	.025		00	2016-10-28	2016-11-01	2016-11-15	2016-10-19		0	2016-10-19	?	0	0005299284			20161019.ifs	2016-10-19	2016-10-20
2252072	2252072	DIVIDEND	ADD	073844102		0	0	1	0	.025		00	2016-07-28	2016-08-01	2016-08-15	2016-07-13		0	2016-07-15	?	0	0005251731			20160715.ifs	2016-07-15	2016-07-16
2252073	2252073	DIVIDEND	DELETE	073844102		0	0	1	0	.025		35	2016-04-28	2016-05-02	2016-05-16	2016-04-22		0	2016-04-22	?	0	0005207295			20160715.ifs	2016-07-15	2016-07-16
2252074	2252074	DIVIDEND	ADD	073844102		0	0	1	0	.025		00	2016-04-28	2016-05-02	2016-05-16	2016-04-22		1	2016-04-22	2016-07-15	0	0005207295			20160715.ifs	2016-07-15	2016-07-16
2169636	2169636	DIVIDEND	ADD	073844102		0	0	1	0	.025		35	2016-04-28	2016-05-02	2016-05-16	2016-04-22		0	2016-04-22	?	0	0005207295			20160422.ifs	2016-04-22	2016-04-23
1681458	1681458	DIVIDEND	ADD	073844102		0	0	5	0	.11		10	2014-11-26	2014-12-01	2014-12-15	2014-11-14		0	2014-11-14	?	0	0004872995			20141114.ifs	2014-11-14	2014-11-15
1681459	1681459	SPLIT	ADD	073844102	.9009009009	2014-11-26	10	2014-11-14	?																20141114.ifs	2014-11-14	2014-11-15
1543162	1543162	EQUITY	CHANGE	073844102	COM	N	0	2014-06-03	?	0	no	no		yes		2014-06-03	2014-06-03	?							20140605.ifs	2014-06-05	2014-06-06
1543163	1543162	EQUITY	CHANGE	073844102	COM	0	0	2014-06-03	?	0	no	no		yes		2014-06-03	2014-06-05	?							20140605.ifs	2014-06-05	2014-06-06
1540967	1540967	EQUITY	ADD	073844102	COM	N	0	2014-06-03	?	0	no	no		no		2014-06-03	?	?							20140603.ifs	2014-06-03	2014-06-04
1540971	1540971	EXCHANGE	ADD	073844102	60	2014-06-03	2014-06-03	BSF	0	0	2014-06-03	?													20140603.ifs	2014-06-03	2014-06-04
1540972	1540972	EQUITY	CHANGE	073844102	COM	N	0	2014-06-03	?	0	no	no		no		2014-06-03	?	?							20140603.ifs	2014-06-03	2014-06-04
1540973	1540972	EQUITY	CHANGE	073844102	COM	N	0	2014-06-03	?	0	no	no		yes		2014-06-03	2014-06-03	?							20140603.ifs	2014-06-03	2014-06-04

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