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
5577996	5577996	DIVIDEND	ADD	922042775		0	0	1	0	.4589		00	2024-06-21	2024-06-21	2024-06-25	2024-06-18		0	2024-06-18	?	0	0006934286			20240618.ifs	2024-06-18	2024-06-19
5516128	5516128	DIVIDEND	ADD	922042775		0	0	1	0	.2153		00	2024-03-15	2024-03-18	2024-03-20	2024-03-13		0	2024-03-14	?	0	0006889693			20240314.ifs	2024-03-14	2024-03-15
5440896	5440896	DIVIDEND	ADD	922042775		0	0	1	0	.843		00	2023-12-18	2023-12-19	2023-12-21	2023-12-14		0	2023-12-14	?	0	0006832982			20231214.ifs	2023-12-14	2023-12-15
5373026	5373026	DIVIDEND	ADD	922042775		0	0	1	0	.3		00	2023-09-18	2023-09-19	2023-09-21	2023-09-14		0	2023-09-14	?	0	0006783151			20230914.ifs	2023-09-14	2023-09-15
5312760	5312760	DIVIDEND	ADD	922042775		0	0	1	0	.6054		00	2023-06-20	2023-06-21	2023-06-23	2023-06-15		0	2023-06-16	?	0	0006739705			20230616.ifs	2023-06-16	2023-06-17
5250084	5250084	DIVIDEND	ADD	922042775		0	0	1	0	.115		00	2023-03-20	2023-03-21	2023-03-23	2023-03-16		0	2023-03-17	?	0	0006696665			20230317.ifs	2023-03-17	2023-03-18
5169479	5169479	DIVIDEND	ADD	922042775		0	0	1	0	.6186		00	2022-12-19	2022-12-20	2022-12-22	2022-12-15		0	2022-12-15	?	0	0006637674			20221215.ifs	2022-12-15	2022-12-16
5098708	5098708	DIVIDEND	ADD	922042775		0	0	1	0	.2613		00	2022-09-19	2022-09-20	2022-09-22	2022-09-15		0	2022-09-16	?	0	0006584243			20220916.ifs	2022-09-16	2022-09-17
5035477	5035477	DIVIDEND	ADD	922042775		0	0	1	0	.578		00	2022-06-21	2022-06-22	2022-06-24	2022-06-16		0	2022-06-17	?	0	0006539653			20220617.ifs	2022-06-17	2022-06-18
4973345	4973345	DIVIDEND	ADD	922042775		0	0	1	0	.106		00	2022-03-21	2022-03-22	2022-03-24	2022-03-17		0	2022-03-18	?	0	0006495657			20220318.ifs	2022-03-18	2022-03-19
4891671	4891671	DIVIDEND	ADD	922042775		0	0	1	0	.8454		00	2021-12-20	2021-12-21	2021-12-23	2021-12-16		0	2021-12-16	?	0	0006431455			20211216.ifs	2021-12-16	2021-12-17
4803067	4803067	DIVIDEND	ADD	922042775		0	0	1	0	.3674		00	2021-09-20	2021-09-21	2021-09-23	2021-09-16		0	2021-09-16	?	0	0006368616			20210916.ifs	2021-09-16	2021-09-17
4732592	4732592	DIVIDEND	ADD	922042775		0	0	1	0	.5075		00	2021-06-21	2021-06-22	2021-06-24	2021-06-17		0	2021-06-18	?	0	0006323827			20210618.ifs	2021-06-18	2021-06-19
4655792	4655792	DIVIDEND	ADD	922042775		0	0	1	0	.1642		00	2021-03-22	2021-03-23	2021-03-25	2021-03-18		0	2021-03-18	?	0	0006278764			20210318.ifs	2021-03-18	2021-03-19
4549714	4549714	DIVIDEND	ADD	922042775		0	0	1	0	.4518		00	2020-12-21	2020-12-22	2020-12-24	2020-12-17		0	2020-12-17	?	0	0006219689			20201217.ifs	2020-12-17	2020-12-18
4464007	4464007	DIVIDEND	ADD	922042775		0	0	1	0	.3416		00	2020-09-21	2020-09-22	2020-09-24	2020-09-17		0	2020-09-17	?	0	0006159997			20200917.ifs	2020-09-17	2020-09-18
4395431	4395431	DIVIDEND	ADD	922042775		0	0	1	0	.2538		00	2020-06-22	2020-06-23	2020-06-25	2020-06-18		0	2020-06-19	?	0	0006114693			20200619.ifs	2020-06-19	2020-06-20
4243740	4243740	DIVIDEND	ADD	922042775		0	0	1	0	.1177		00	2020-03-23	2020-03-24	2020-03-26	2020-03-19		0	2020-03-19	?	0	0006070706			20200319.ifs	2020-03-19	2020-03-20
4243776	4243776	DIVIDEND	ADD	922042775		0	0	1	0	.1177		00	2020-03-23	2020-03-24	2020-03-26	2020-03-19		0	2020-03-19	?	0	0006070706			20200319.ifs	2020-03-19	2020-03-20
4092409	4092409	DIVIDEND	ADD	922042775		0	0	1	0	.5814		00	2019-12-23	2019-12-24	2019-12-27	2019-12-19		0	2019-12-19	?	0	0006014468			20191219.ifs	2019-12-19	2019-12-20
4092792	4092792	DIVIDEND	ADD	922042775		0	0	1	0	.5814		00	2019-12-23	2019-12-24	2019-12-27	2019-12-19		0	2019-12-19	?	0	0006014468			20191219.ifs	2019-12-19	2019-12-20
3930514	3930514	DIVIDEND	ADD	922042775		0	0	1	0	.3273		00	2019-09-24	2019-09-25	2019-09-27	2019-09-20		0	2019-09-20	?	0	0005948323			20190920.ifs	2019-09-20	2019-09-21
3930573	3930573	DIVIDEND	ADD	922042775		0	0	1	0	.3273		00	2019-09-24	2019-09-25	2019-09-27	2019-09-20		0	2019-09-20	?	0	0005948323			20190920.ifs	2019-09-20	2019-09-21
3777578	3777578	DIVIDEND	ADD	922042775		0	0	1	0	.579		00	2019-06-17	2019-06-18	2019-06-20	2019-06-13		0	2019-06-13	?	0	0005897722			20190613.ifs	2019-06-13	2019-06-14
3777579	3777579	DIVIDEND	ADD	922042775		0	0	1	0	.579		00	2019-06-17	2019-06-18	2019-06-20	2019-06-13		0	2019-06-13	?	0	0005897722			20190613.ifs	2019-06-13	2019-06-14
3641846	3641846	DIVIDEND	ADD	922042775		0	0	1	0	.1788		00	2019-03-25	2019-03-26	2019-03-28	2019-03-21		0	2019-03-21	?	0	0005856388			20190321.ifs	2019-03-21	2019-03-22
3641847	3641847	DIVIDEND	ADD	922042775		0	0	1	0	.1788		00	2019-03-25	2019-03-26	2019-03-28	2019-03-21		0	2019-03-21	?	0	0005856388			20190321.ifs	2019-03-21	2019-03-22
3474247	3474247	DIVIDEND	ADD	922042775		0	0	1	0	.4461		00	2018-12-24	2018-12-26	2018-12-28	2018-12-20		0	2018-12-20	?	0	0005799615			20181220.ifs	2018-12-20	2018-12-21
3474272	3474272	DIVIDEND	ADD	922042775		0	0	1	0	.4461		00	2018-12-24	2018-12-26	2018-12-28	2018-12-20		0	2018-12-20	?	0	0005799615			20181220.ifs	2018-12-20	2018-12-21
3296584	3296584	DIVIDEND	ADD	922042775		0	0	1	0	.2738		00	2018-09-26	2018-09-27	2018-10-01	2018-09-24		0	2018-09-24	?	0	0005727902			20180924.ifs	2018-09-24	2018-09-25
3296585	3296585	DIVIDEND	ADD	922042775		0	0	1	0	.2738		00	2018-09-26	2018-09-27	2018-10-01	2018-09-24		0	2018-09-24	?	0	0005727902			20180924.ifs	2018-09-24	2018-09-25
3148458	3148458	DIVIDEND	ADD	922042775		0	0	1	0	.613		00	2018-06-22	2018-06-25	2018-06-27	2018-06-20		0	2018-06-20	?	0	0005678207			20180620.ifs	2018-06-20	2018-06-21
3148463	3148463	DIVIDEND	ADD	922042775		0	0	1	0	.613		00	2018-06-22	2018-06-25	2018-06-27	2018-06-20		0	2018-06-20	?	0	0005678207			20180620.ifs	2018-06-20	2018-06-21
3002272	3002272	DIVIDEND	ADD	922042775		0	0	1	0	.1563		00	2018-03-26	2018-03-27	2018-03-29	2018-03-22		0	2018-03-22	?	0	0005633452			20180322.ifs	2018-03-22	2018-03-23
3002397	3002397	DIVIDEND	ADD	922042775		0	0	1	0	.1563		00	2018-03-26	2018-03-27	2018-03-29	2018-03-22		0	2018-03-22	?	0	0005633452			20180322.ifs	2018-03-22	2018-03-23
2841708	2841708	DIVIDEND	ADD	922042775		0	0	1	0	.4629		00	2017-12-21	2017-12-22	2017-12-27	2017-12-19		0	2017-12-19	?	0	0005567453			20171219.ifs	2017-12-19	2017-12-20
2841828	2841828	DIVIDEND	ADD	922042775		0	0	1	0	.4629		00	2017-12-21	2017-12-22	2017-12-27	2017-12-19		0	2017-12-19	?	0	0005567453			20171219.ifs	2017-12-19	2017-12-20
2675871	2675871	DIVIDEND	ADD	922042775		0	0	1	0	.298		00	2017-09-20	2017-09-21	2017-09-25	2017-09-18		0	2017-09-18	?	0	0005498870			20170918.ifs	2017-09-18	2017-09-19
2675880	2675880	DIVIDEND	ADD	922042775		0	0	1	0	.298		00	2017-09-20	2017-09-21	2017-09-25	2017-09-18		0	2017-09-18	?	0	0005498870			20170918.ifs	2017-09-18	2017-09-19
2598520	2598520	DIVIDEND	DELETE	922042775		0	0	1	0	.541		00	2017-06-20	2017-06-19	2017-06-21	2017-06-19		0	2017-06-21	?	0	0005452566			20170622.ifs	2017-06-22	2017-06-23
2597222	2597222	DIVIDEND	ADD	922042775		0	0	1	0	.541		00	2017-06-20	2017-06-19	2017-06-21	2017-06-19		0	2017-06-21	?	0	0005452566			20170621.ifs	2017-06-21	2017-06-22
2594900	2594900	DIVIDEND	ADD	922042775		0	0	1	0	.541		00	2017-06-21	2017-06-23	2017-06-27	2017-06-19		0	2017-06-19	?	0	0005451106			20170619.ifs	2017-06-19	2017-06-20
2517061	2517061	DIVIDEND	ADD	922042775		0	0	1	0	.153		00	2017-03-22	2017-03-24	2017-03-28	2017-03-20		0	2017-03-21	?	0	0005404738			20170321.ifs	2017-03-21	2017-03-22
2446890	2446890	EQUITY	CHANGE	922042775	FTSE ALL-WORLD EX-US INDEX FD ETF	0	A	2007-03-08	?	0	no	no		no		2007-03-08	2007-03-08	?							20170123.ifs	2017-01-23	2017-01-24
2446891	2446890	EQUITY	CHANGE	922042775	FTSE ALL-WORLD EX-US INDEX FD ETF	0	A	2007-03-08	?	4	no	no		no		2007-03-08	2007-03-08	?							20170123.ifs	2017-01-23	2017-01-24
2379027	2379027	DIVIDEND	ADD	922042775		0	0	1	0	.375		00	2016-12-20	2016-12-22	2016-12-27	2016-12-16		0	2016-12-16	?	0	0005340892			20161216.ifs	2016-12-16	2016-12-17
2290579	2290579	DIVIDEND	ADD	922042775		0	0	1	0	.255		00	2016-09-13	2016-09-15	2016-09-19	2016-09-09		0	2016-09-09	?	0	0005279192			20160909.ifs	2016-09-09	2016-09-10
2219021	2219021	DIVIDEND	ADD	922042775		0	0	1	0	.53		00	2016-06-14	2016-06-16	2016-06-20	2016-06-10		0	2016-06-13	?	0	0005231548			20160613.ifs	2016-06-13	2016-06-14
2134599	2134599	DIVIDEND	ADD	922042775		0	0	1	0	.148		00	2016-03-15	2016-03-17	2016-03-21	2016-03-11		0	2016-03-14	?	0	0005186415			20160314.ifs	2016-03-14	2016-03-15
2045190	2045190	DIVIDEND	ADD	922042775		0	0	1	0	.335		00	2015-12-21	2015-12-23	2015-12-28	2015-12-17		0	2015-12-17	?	0	0005125321			20151217.ifs	2015-12-17	2015-12-18
1970876	1970876	DIVIDEND	ADD	922042775		0	0	1	0	.228		00	2015-09-25	2015-09-29	2015-10-01	2015-09-23		0	2015-09-23	?	0	0005066508			20150923.ifs	2015-09-23	2015-09-24
1894444	1894444	DIVIDEND	ADD	922042775		0	0	1	0	.557		00	2015-06-26	2015-06-30	2015-07-02	2015-06-24		0	2015-06-24	?	0	0005019307			20150624.ifs	2015-06-24	2015-06-25
1818340	1818340	DIVIDEND	ADD	922042775		0	0	1	0	.162		00	2015-03-25	2015-03-27	2015-03-31	2015-03-23		0	2015-03-23	?	0	0004972047			20150323.ifs	2015-03-23	2015-03-24
1730549	1730549	DIVIDEND	ADD	922042775		0	0	1	0	.379		00	2014-12-22	2014-12-24	2014-12-29	2014-12-18		0	2014-12-19	?	0	0004910302			20141219.ifs	2014-12-19	2014-12-20
1635292	1635292	DIVIDEND	ADD	922042775		0	0	1	0	.268		00	2014-09-24	2014-09-26	2014-09-30	2014-09-22		0	2014-09-22	?	0	0004846107			20140922.ifs	2014-09-22	2014-09-23
1556822	1556822	DIVIDEND	ADD	922042775		0	0	1	0	.61		00	2014-06-24	2014-06-26	2014-06-30	2014-06-20		0	2014-06-23	?	0	0004800078			20140623.ifs	2014-06-23	2014-06-24
1473348	1473348	DIVIDEND	ADD	922042775		0	0	1	0	.394		00	2014-03-25	2014-03-27	2014-03-31	2014-03-21		0	2014-03-21	?	0	0004753903			20140321.ifs	2014-03-21	2014-03-22
1392038	1392038	DIVIDEND	CHANGE	922042775		0	0	1	0	.387		00	2013-12-20	2013-12-24	2013-12-27	2013-12-18		0	2013-12-18	?	0	0004692469			20131223.ifs	2013-12-23	2013-12-24
1392039	1392038	DIVIDEND	CHANGE	922042775		0	0	1	0	.387		00	2013-12-20	2013-12-24	2013-12-27	2013-12-18		1	2013-12-18	2013-12-23	0	0004692469			20131223.ifs	2013-12-23	2013-12-24
1379102	1379102	DIVIDEND	ADD	922042775		0	0	1	0	.387		00	2013-12-20	2013-12-24	2013-12-27	2013-12-18		0	2013-12-18	?	0	0004692469			20131218.ifs	2013-12-18	2013-12-19
1295503	1295503	DIVIDEND	CHANGE	922042775		0	0	1	0	.221		00	2013-09-23	2013-09-25	2013-09-27	2013-09-19		0	2013-09-19	?	0	0004631311			20130924.ifs	2013-09-24	2013-09-25
1295504	1295503	DIVIDEND	CHANGE	922042775		0	0	1	0	.221		00	2013-09-23	2013-09-25	2013-09-27	2013-09-19		1	2013-09-19	2013-09-24	0	0004631311			20130924.ifs	2013-09-24	2013-09-25
1290818	1290818	DIVIDEND	ADD	922042775		0	0	1	0	.221		00	2013-09-23	2013-09-25	2013-09-27	2013-09-19		0	2013-09-19	?	0	0004631311			20130919.ifs	2013-09-19	2013-09-20
1217052	1217052	DIVIDEND	CHANGE	922042775		0	0	1	0	.605		00	2013-06-24	2013-06-26	2013-06-28	2013-06-20		0	2013-06-20	?	0	0004586865			20130625.ifs	2013-06-25	2013-06-26
1217053	1217052	DIVIDEND	CHANGE	922042775		0	0	1	0	.605		00	2013-06-24	2013-06-26	2013-06-28	2013-06-20		1	2013-06-20	2013-06-25	0	0004586865			20130625.ifs	2013-06-25	2013-06-26
1212949	1212949	DIVIDEND	ADD	922042775		0	0	1	0	.605		00	2013-06-24	2013-06-26	2013-06-28	2013-06-20		0	2013-06-20	?	0	0004586865			20130620.ifs	2013-06-20	2013-06-21
1141257	1141257	DIVIDEND	CHANGE	922042775		0	0	1	0	.137		00	2013-03-22	2013-03-26	2013-03-28	2013-03-20		0	2013-03-20	?	0	0004543720			20130325.ifs	2013-03-25	2013-03-26
1141258	1141257	DIVIDEND	CHANGE	922042775		0	0	1	0	.137		00	2013-03-22	2013-03-26	2013-03-28	2013-03-20		1	2013-03-20	2013-03-25	0	0004543720			20130325.ifs	2013-03-25	2013-03-26
1137448	1137448	DIVIDEND	ADD	922042775		0	0	1	0	.137		00	2013-03-22	2013-03-26	2013-03-28	2013-03-20		0	2013-03-20	?	0	0004543720			20130320.ifs	2013-03-20	2013-03-21
1046545	1046545	DIVIDEND	ADD	922042775		0	0	1	0	.546		00	2012-12-20	2012-12-24	2012-12-27	2012-12-18		0	2012-12-18	?	0	0004486149			20121218.ifs	2012-12-18	2012-12-19
965461	965461	DIVIDEND	CHANGE	922042775		0	0	1	0	.799		00	2012-09-24	2012-09-26	2012-09-28	2012-09-20		1	2012-09-20	2012-09-21	0	0004432015			20120926.ifs	2012-09-26	2012-09-27
965462	965461	DIVIDEND	CHANGE	922042775		0	0	1	0	.799		00	2012-09-24	2012-09-26	2012-09-28	2012-09-20		2	2012-09-20	2012-09-26	0	0004432015			20120926.ifs	2012-09-26	2012-09-27
961763	961763	DIVIDEND	CHANGE	922042775		0	0	1	0	.799		00	2012-09-24	2012-09-26	2012-09-28	2012-09-20		0	2012-09-20	?	0	0004432015			20120921.ifs	2012-09-21	2012-09-22
961764	961763	DIVIDEND	CHANGE	922042775		0	0	1	0	.799		00	2012-09-24	2012-09-26	2012-09-28	2012-09-20		1	2012-09-20	2012-09-21	0	0004432015			20120921.ifs	2012-09-21	2012-09-22
960089	960089	DIVIDEND	ADD	922042775		0	0	1	0	.799		00	2012-09-24	2012-09-26	2012-09-28	2012-09-20		0	2012-09-20	?	0	0004432015			20120920.ifs	2012-09-20	2012-09-21
730033	730033	DIVIDEND	ADD	922042775		0	0	1	0	1.369		00	2011-12-21	2011-12-23	2011-12-28	2011-12-19		0	2011-12-19	?	0	0004295552			20111219.ifs	2011-12-19	2011-12-20
385561	385561	DIVIDEND	ADD	922042775		0	0	1	0	1.019		00	2010-12-22	2010-12-27	2010-12-29	2010-12-20		0	2010-12-20	?	0	0004112295			20101220.ifs	2010-12-20	2010-12-21
61566	61566	DIVIDEND	ADD	922042775		0	0	1	0	.863		00	2009-12-24	2009-12-29	2009-12-31	2009-12-22		0	2009-12-22	?	0	0003936699			20091222.ifs	2009-12-22	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 = 152192
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