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
1267892	1267892	EQUITY	CHANGE	02073D109	COM	Q	0	1993-11-01	2013-08-20	9	yes	no	00164E101	no		2001-05-11	2013-08-20	?							20130821.ifs	2013-08-21	2013-08-22
1267893	1267892	EQUITY	CHANGE	02073D109	COM	Q	0	1993-11-01	2013-08-20	9	yes	no	00164E101	no		2001-05-11	2013-08-21	?							20130821.ifs	2013-08-21	2013-08-22
1267121	1267121	DIVIDEND	DELETE	02073D109		0	0	6	0	.1		54	2013-08-20	2013-08-20	2013-08-20	2013-08-19		0	2013-08-19	?	0	0004616330			20130820.ifs	2013-08-20	2013-08-21
1267122	1267122	DIVIDEND	ADD	02073D109		0	0	6	0	.1	0	54	2013-08-20	2013-08-20	2013-08-20	2013-08-20		0	?	2013-08-20	0	0004616330			20130820.ifs	2013-08-20	2013-08-21
1267129	1267129	CORPACTION	DELETE	02073D109	66	D	2012-05-25			2012-05-25															20130820.ifs	2013-08-20	2013-08-21
1267133	1267133	CORPACTION	ADD	02073D109	74	Q	2013-08-20	00164E101	66	2013-08-20															20130820.ifs	2013-08-20	2013-08-21
1267134	1267134	EQUITY	CHANGE	02073D109	COM	0	0	1993-11-01	?	9	yes	no		no		2001-05-11	2012-05-29	?							20130820.ifs	2013-08-20	2013-08-21
1267135	1267134	EQUITY	CHANGE	02073D109	COM	Q	0	1993-11-01	2013-08-20	9	yes	no	00164E101	no		2001-05-11	2013-08-20	?							20130820.ifs	2013-08-20	2013-08-21
1267136	1267136	SPLIT	DELETE	02073D109	10	2013-08-20	54	2013-08-19	?																20130820.ifs	2013-08-20	2013-08-21
1267138	1267138	DIVIDEND	DELETE	02073D109		0	0	6	0	.1	0	54	2013-08-20	2013-08-20	2013-08-20	2013-08-20		0	?	2013-08-20	0	0004616330			20130820.ifs	2013-08-20	2013-08-21
1267497	1267497	CORPACTION	DELETE	02073D109	74	Q	2013-08-20	00164E101	66	2013-08-20															20130820.ifs	2013-08-20	2013-08-21
1267498	1267498	CORPACTION	ADD	02073D109	66	Q	2013-08-20	00164E101	66	2013-08-20															20130820.ifs	2013-08-20	2013-08-21
1267500	1267500	EXCHANGE	CHANGE	02073D109	66	2004-04-23	2012-05-24	ALGLF	0	0	2004-04-29	2012-05-25													20130820.ifs	2013-08-20	2013-08-21
1267501	1267500	EXCHANGE	CHANGE	02073D109	66	2004-04-23	2013-08-19	ALGLF	0	0	2004-04-29	2013-08-20													20130820.ifs	2013-08-20	2013-08-21
1267089	1267089	DIVIDEND	ADD	02073D109		0	0	6	0	.1		54	2013-08-20	2013-08-20	2013-08-20	2013-08-19		0	2013-08-19	?	0	0004616330			20130819.ifs	2013-08-19	2013-08-20
1267090	1267090	SPLIT	ADD	02073D109	10	2013-08-20	54	2013-08-19	?																20130819.ifs	2013-08-19	2013-08-20
868124	868124	EQUITY	CHANGE	02073D109	COM	0	0	1993-11-01	?	9	yes	no		no		2001-05-11	2012-05-29	?							20120531.ifs	2012-05-31	2012-06-01
868125	868124	EQUITY	CHANGE	02073D109	COM	0	0	1993-11-01	?	9	yes	no		no		2001-05-11	2012-05-29	?							20120531.ifs	2012-05-31	2012-06-01
866898	866898	CORPACTION	ADD	02073D109	66	D	2012-05-25			2012-05-25															20120525.ifs	2012-05-25	2012-05-26

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