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
5355510	5355510	DIVIDEND	ADD	G3224V108		6	0	3	0	.035		28	?	2023-10-27	2023-12-05	2023-08-18		0	2023-08-18	?	0	0006770160			20230818.ifs	2023-08-18	2023-08-19
5273627	5273627	DIVIDEND	ADD	G3224V108		6	0	3	0	.07		28	?	2023-05-19	2023-07-05	2023-04-19		0	2023-04-19	?	0	0006713466			20230419.ifs	2023-04-19	2023-04-20
5085344	5085344	DIVIDEND	ADD	G3224V108		6	0	3	0	.035		28	?	2022-10-28	2022-12-05	2022-08-31		0	2022-08-31	?	0	0006574240			20220831.ifs	2022-08-31	2022-09-01
4980263	4980263	DIVIDEND	ADD	G3224V108		6	0	3	0	.06		28	?	2022-05-27	2022-07-06	2022-03-30		0	2022-03-30	?	0	0006501259			20220330.ifs	2022-03-30	2022-03-31
4829796	4829796	DIVIDEND	ADD	G3224V108		6	0	3	0	.03		28	?	2021-11-05	2021-12-06	2021-10-21		0	2021-10-21	?	0	0006385346			20211021.ifs	2021-10-21	2021-10-22
4724590	4724590	DIVIDEND	DELETE	G3224V108		0	0	3	6	0		08	?	2021-06-04	?	2021-06-03		0	2021-06-03	?	0	0006318690			20210608.ifs	2021-06-08	2021-06-09
4724591	4724591	DIVIDEND	ADD	G3224V108		6	0	3	0	.015		28	?	2021-06-04	2021-07-07	2021-06-03		1	2021-06-03	2021-06-08	0	0006318690			20210608.ifs	2021-06-08	2021-06-09
4721717	4721717	DIVIDEND	ADD	G3224V108		0	0	3	6	0		08	?	2021-06-04	?	2021-06-03		0	2021-06-03	?	0	0006318690			20210603.ifs	2021-06-03	2021-06-04
3891402	3891402	DIVIDEND	ADD	G3224V108		6	0	3	0	.021		28	?	2019-10-25	2019-12-06	2019-08-27		0	2019-08-27	?	0	0005933567			20190827.ifs	2019-08-27	2019-08-28
3891403	3891403	DIVIDEND	ADD	G3224V108		6	0	3	0	.021		28	?	2019-10-25	2019-12-06	2019-08-27		0	2019-08-27	?	0	0005933567			20190827.ifs	2019-08-27	2019-08-28
3625378	3625378	DIVIDEND	ADD	G3224V108		6	0	3	0	.032		28	?	2019-05-17	2019-07-05	2019-03-13		0	2019-03-13	?	0	0005851847			20190313.ifs	2019-03-13	2019-03-14
3625379	3625379	DIVIDEND	ADD	G3224V108		6	0	3	0	.032		28	?	2019-05-17	2019-07-05	2019-03-13		0	2019-03-13	?	0	0005851847			20190313.ifs	2019-03-13	2019-03-14
3388159	3388159	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.016		28	?	2018-10-05	2018-11-30	2018-08-17		0	2018-08-17	?	0	0005708916			20181130.ifs	2018-11-30	2018-12-01
3388160	3388159	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.016		28	?	2018-10-05	2018-11-30	2018-08-17		1	2018-08-17	2018-11-30	0	0005708916			20181130.ifs	2018-11-30	2018-12-01
3388177	3388177	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.016		28	?	2018-10-05	2018-11-30	2018-08-17		0	2018-08-17	?	0	0005708916			20181130.ifs	2018-11-30	2018-12-01
3388179	3388178	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.016		28	?	2018-10-05	2018-11-30	2018-08-17		1	2018-08-17	2018-11-30	0	0005708916			20181130.ifs	2018-11-30	2018-12-01
3242302	3242302	DIVIDEND	ADD	G3224V108		6	0	3	0	.016		28	?	2018-10-05	2018-11-30	2018-08-17		0	2018-08-17	?	0	0005708916			20180817.ifs	2018-08-17	2018-08-18
3242303	3242303	DIVIDEND	ADD	G3224V108		6	0	3	0	.016		28	?	2018-10-05	2018-11-30	2018-08-17		0	2018-08-17	?	0	0005708916			20180817.ifs	2018-08-17	2018-08-18
3191420	3191420	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.024		28	?	2018-04-20	2018-07-06	2018-03-27		0	2018-03-27	?	0	0005635656			20180711.ifs	2018-07-11	2018-07-12
3191421	3191421	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.024		28	?	2018-04-20	2018-07-06	2018-03-27		0	2018-03-27	?	0	0005635656			20180711.ifs	2018-07-11	2018-07-12
3191422	3191421	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.024		28	?	2018-04-20	2018-07-06	2018-03-27		1	2018-03-27	2018-07-11	0	0005635656			20180711.ifs	2018-07-11	2018-07-12
3191423	3191422	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.024		28	?	2018-04-20	2018-07-06	2018-03-27		1	2018-03-27	2018-07-11	0	0005635656			20180711.ifs	2018-07-11	2018-07-12
3009306	3009306	DIVIDEND	ADD	G3224V108		6	0	3	0	.024		28	?	2018-04-20	2018-07-06	2018-03-27		0	2018-03-27	?	0	0005635656			20180327.ifs	2018-03-27	2018-03-28
3009316	3009316	DIVIDEND	ADD	G3224V108		6	0	3	0	.024		28	?	2018-04-20	2018-07-06	2018-03-27		0	2018-03-27	?	0	0005635656			20180327.ifs	2018-03-27	2018-03-28
2802364	2802364	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.012		28	2017-10-05	2017-10-06	2017-12-01	2017-09-11		0	2017-09-11	?	0	0005495382			20171205.ifs	2017-12-05	2017-12-06
2802365	2802364	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.012		28	2017-10-05	2017-10-06	2017-12-01	2017-09-11		1	2017-09-11	2017-12-05	0	0005495382			20171205.ifs	2017-12-05	2017-12-06
2805866	2805866	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.012		28	2017-10-05	2017-10-06	2017-12-01	2017-09-11		0	2017-09-11	?	0	0005495382			20171205.ifs	2017-12-05	2017-12-06
2805867	2805866	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.012		28	2017-10-05	2017-10-06	2017-12-01	2017-09-11		1	2017-09-11	2017-12-05	0	0005495382			20171205.ifs	2017-12-05	2017-12-06
2668533	2668533	DIVIDEND	ADD	G3224V108		6	0	3	0	.012		28	2017-10-05	2017-10-06	2017-12-01	2017-09-11		0	2017-09-11	?	0	0005495382			20170911.ifs	2017-09-11	2017-09-12
2518411	2518411	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.018		28	2017-04-20	2017-04-21	2017-07-07	2017-03-22		0	2017-03-22	?	0	0005405916			20170323.ifs	2017-03-23	2017-03-24
2518412	2518411	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.018		28	2017-04-20	2017-04-21	2017-07-07	2017-03-22		1	2017-03-22	2017-03-23	0	0005405916			20170323.ifs	2017-03-23	2017-03-24
2453200	2453200	EQUITY	CHANGE	G3224V108	ORD	0	0	2000-06-27	?	0	no	no		no		2000-08-22	2000-06-28	?							20170124.ifs	2017-01-24	2017-01-25
2453201	2453200	EQUITY	CHANGE	G3224V108	ORD	0	0	2000-06-27	?	2	no	no		no		2000-08-22	2000-06-28	?							20170124.ifs	2017-01-24	2017-01-25
2361932	2361932	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.009		28	2016-10-06	2016-10-07	2016-12-02	2016-08-24		0	2016-08-24	?	0	0005268533			20161206.ifs	2016-12-06	2016-12-07
2361933	2361932	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.009		28	2016-10-06	2016-10-07	2016-12-02	2016-08-24		1	2016-08-24	2016-12-06	0	0005268533			20161206.ifs	2016-12-06	2016-12-07
2275705	2275705	DIVIDEND	ADD	G3224V108		6	0	3	0	.009		28	2016-10-06	2016-10-07	2016-12-02	2016-08-24		0	2016-08-24	?	0	0005268533			20160824.ifs	2016-08-24	2016-08-25
1613800	1613800	DIVIDEND	ADD	G3224V108		6	0	3	0	.056		28	2014-10-09	2014-10-10	2014-12-05	2014-08-27		0	2014-08-27	?	0	0004831936			20140827.ifs	2014-08-27	2014-08-28
1576499	1576499	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.085		28	2014-04-23	2014-04-25	2014-07-04	2014-03-14		0	2014-03-14	?	0	0004750334			20140708.ifs	2014-07-08	2014-07-09
1576500	1576499	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.085		28	2014-04-23	2014-04-25	2014-07-04	2014-03-14		1	2014-03-14	2014-07-08	0	0004750334			20140708.ifs	2014-07-08	2014-07-09
1466556	1466556	DIVIDEND	ADD	G3224V108		6	0	3	0	.085		28	2014-04-23	2014-04-25	2014-07-04	2014-03-14		0	2014-03-14	?	0	0004750334			20140314.ifs	2014-03-14	2014-03-15
1266060	1266060	DIVIDEND	ADD	G3224V108		6	0	3	0	.056		28	2013-10-09	2013-10-11	2013-12-06	2013-08-16		0	2013-08-16	?	0	0004615997			20130816.ifs	2013-08-16	2013-08-17
1132151	1132151	DIVIDEND	ADD	G3224V108		6	0	3	0	.085		28	2013-04-24	2013-04-26	2013-07-05	2013-03-13		0	2013-03-13	?	0	0004540823			20130313.ifs	2013-03-13	2013-03-14
1035209	1035209	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.056		28	2012-10-10	2012-10-12	2012-12-07	2012-09-05		0	2012-09-05	?	0	0004426214			20121211.ifs	2012-12-11	2012-12-12
1035210	1035209	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.056		28	2012-10-10	2012-10-12	2012-12-07	2012-09-05		1	2012-09-05	2012-12-11	0	0004426214			20121211.ifs	2012-12-11	2012-12-12
949480	949480	DIVIDEND	ADD	G3224V108		6	0	3	0	.056		28	2012-10-10	2012-10-12	2012-12-07	2012-09-05		0	2012-09-05	?	0	0004426214			20120905.ifs	2012-09-05	2012-09-06
860208	860208	DIVIDEND	ADD	G3224V108		6	0	3	0	.085		28	2012-04-25	2012-04-27	2012-07-06	2012-03-08		0	?	2012-05-14	0	0004360710			20120514.ifs	2012-05-14	2012-05-15
650539	650539	DIVIDEND	ADD	G3224V108		6	0	3	0	.053		28	?	2011-10-14	?	2011-09-22		0	2011-09-22	?	0	0004245246			20110922.ifs	2011-09-22	2011-09-23
650540	650540	DIVIDEND	CHANGE	G3224V108		6	0	3	4	.0765		28	?	2011-04-26	2011-07-05	2011-03-10		0	2011-03-10	?	0	0004158674			20110922.ifs	2011-09-22	2011-09-23
650541	650540	DIVIDEND	CHANGE	G3224V108		6	0	3	0	.0765		28	?	2011-04-26	2011-07-05	2011-03-10		1	2011-03-10	2011-09-22	0	0004158674			20110922.ifs	2011-09-22	2011-09-23
469311	469311	DIVIDEND	ADD	G3224V108		6	0	3	4	.0765		28	?	2011-04-26	2011-07-05	2011-03-10		0	2011-03-10	?	0	0004158674			20110310.ifs	2011-03-10	2011-03-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 = 145549
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