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
5381241	5381241	CORPACTION	ADD	F01699135	66	#	2023-09-27	F01699135	66	?															20230927.ifs	2023-09-27	2023-09-28
5381242	5381242	CORPACTIONAUX	ADD	F01699135	66	2023-09-27	AFRAD	AIR FRANCE KLM	ORD	AFRAF	AIR FRANCE KLM	ORD	2023-09-27	?											20230927.ifs	2023-09-27	2023-09-28
5381243	5381243	EXCHANGE	CHANGE	F01699135	66	2023-08-31	2023-09-06	AFRAD	0	0	?	2023-09-01													20230927.ifs	2023-09-27	2023-09-28
5381244	5381243	EXCHANGE	CHANGE	F01699135	66	2023-08-31	2023-09-06	AFRAF	0	0	?	2023-09-27													20230927.ifs	2023-09-27	2023-09-28
5363687	5363687	DIVIDEND	DELETE	F01699135		A	1	3	0	.15		53	2005-07-19	2005-07-18	2005-07-19	2005-08-08		0	?	?	0	0003090156			20230901.ifs	2023-09-01	2023-09-02
5363689	5363689	DIVIDEND	DELETE	F01699135		A	1	3	0	.3		53	2006-07-18	2006-07-17	2006-07-18	2006-08-24		0	?	?	0	0003249772			20230901.ifs	2023-09-01	2023-09-02
5363691	5363691	DIVIDEND	DELETE	F01699135		A	1	3	0	.48	0	53	2007-07-18	2007-07-17	2007-07-18	2007-08-20		0	?	2007-08-21	0	0003460310			20230901.ifs	2023-09-01	2023-09-02
5363693	5363693	DIVIDEND	DELETE	F01699135		A	0	3	0	.58		53	2008-07-14	2008-07-16	2008-07-17	2008-07-09		0	2008-07-09	?	0	0003666372			20230901.ifs	2023-09-01	2023-09-02
5363695	5363695	DIVIDEND	DELETE	F01699135		0	0	E	0	0		58	?	?	2009-07-17	2009-08-11		0	2009-08-11	?	0	0003867946			20230901.ifs	2023-09-01	2023-09-02
5363699	5363699	EXCHANGE	CHANGE	F01699135	66	2004-11-09	2023-08-31	AFRAF	0	0	2004-12-08	2004-11-12													20230901.ifs	2023-09-01	2023-09-02
5363700	5363699	EXCHANGE	CHANGE	F01699135	66	2004-11-09	2023-08-31	AFRAD	0	0	2004-12-08	2023-09-01													20230901.ifs	2023-09-01	2023-09-02
5363701	5363701	EXCHANGE	CHANGE	F01699135	66	2004-11-09	2023-08-31	AFRAD	0	0	2004-12-08	2023-09-01													20230901.ifs	2023-09-01	2023-09-02
5363702	5363701	EXCHANGE	CHANGE	F01699135	66	2004-11-09	2023-08-31	AFRAF	0	0	2004-12-08	2023-09-01													20230901.ifs	2023-09-01	2023-09-02
5363703	5363703	EXCHANGE	CHANGE	F01699135	66	2004-11-09	2023-08-31	AFRAF	0	0	2004-12-08	2023-09-01													20230901.ifs	2023-09-01	2023-09-02
5363704	5363703	EXCHANGE	CHANGE	F01699135	66	2004-11-09	2023-08-31	AFRAD	0	0	2004-12-08	2023-09-01													20230901.ifs	2023-09-01	2023-09-02
5363705	5363705	EXCHANGE	DELETE	F01699135	66	2004-11-09	2023-08-31	AFRAD	0	0	2004-12-08	2023-09-01													20230901.ifs	2023-09-01	2023-09-02
5363706	5363706	EXCHANGE	ADD	F01699135	66	2023-08-31	2023-08-31	AFRAD	0	0	?	2023-09-01													20230901.ifs	2023-09-01	2023-09-02
5363713	5363713	SPLIT	ADD	F01699135	10	2023-08-31	54	?	2023-09-01																20230901.ifs	2023-09-01	2023-09-02
5363715	5363715	DIVIDEND	ADD	F01699135		0	0	6	0	.1		54	2023-08-31	2023-08-31	2023-08-31	2023-08-31		0	?	2023-09-01	0	0006777479			20230901.ifs	2023-09-01	2023-09-02
5032880	5032880	CORPACTION	DELETE	F01699135	66	E	2022-06-14			2022-06-14															20220615.ifs	2022-06-15	2022-06-16
5032881	5032881	EQUITY	CHANGE	F01699135	ORD	E	0	2004-11-11	2022-06-14	0	no	no		no		2004-12-08	2022-06-14	?							20220615.ifs	2022-06-15	2022-06-16
5032882	5032881	EQUITY	CHANGE	F01699135	ORD	0	0	2004-11-11	?	0	no	no		no		2004-12-08	2022-06-15	?							20220615.ifs	2022-06-15	2022-06-16
5032476	5032476	CORPACTION	DELETE	F01699135	66	E	2022-06-10			?															20220614.ifs	2022-06-14	2022-06-15
5032477	5032477	CORPACTION	ADD	F01699135	66	E	2022-06-14			2022-06-14															20220614.ifs	2022-06-14	2022-06-15
5032478	5032478	EQUITY	CHANGE	F01699135	ORD	E	0	2004-11-11	2022-06-10	0	no	no		no		2004-12-08	2022-06-10	?							20220614.ifs	2022-06-14	2022-06-15
5032479	5032478	EQUITY	CHANGE	F01699135	ORD	E	0	2004-11-11	2022-06-14	0	no	no		no		2004-12-08	2022-06-14	?							20220614.ifs	2022-06-14	2022-06-15
5031370	5031370	CORPACTION	ADD	F01699135	66	E	2022-06-10			?															20220610.ifs	2022-06-10	2022-06-11
5031371	5031371	EQUITY	CHANGE	F01699135	ORD	0	0	2004-11-11	?	0	no	no		no		2004-12-08	2004-11-12	?							20220610.ifs	2022-06-10	2022-06-11
5031372	5031371	EQUITY	CHANGE	F01699135	ORD	E	0	2004-11-11	2022-06-10	0	no	no		no		2004-12-08	2022-06-10	?							20220610.ifs	2022-06-10	2022-06-11

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