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
4268602	4268602	DIVIDEND	ADD	168905107		0	0	E	0	0		58	?	?	2020-04-27	2020-03-31		0	2020-03-31	?	0	0006077381			20200331.ifs	2020-03-31	2020-04-01
4268809	4268809	DIVIDEND	ADD	168905107		0	0	E	0	0		58	?	?	2020-04-27	2020-03-31		0	2020-03-31	?	0	0006077381			20200331.ifs	2020-03-31	2020-04-01
4056180	4056180	DIVIDEND	ADD	168905107		0	0	1	0	.56		00	2019-12-13	2019-12-16	2019-12-27	2019-12-11		0	2019-12-11	?	0	0005993071			20191211.ifs	2019-12-11	2019-12-12
4056346	4056346	DIVIDEND	ADD	168905107		0	0	1	0	.56		00	2019-12-13	2019-12-16	2019-12-27	2019-12-11		0	2019-12-11	?	0	0005993071			20191211.ifs	2019-12-11	2019-12-12
3885051	3885051	DIVIDEND	ADD	168905107		0	0	1	0	.56		00	2019-09-20	2019-09-23	2019-10-04	2019-08-21		0	2019-08-21	?	0	0005931698			20190821.ifs	2019-08-21	2019-08-22
3885066	3885066	DIVIDEND	ADD	168905107		0	0	1	0	.56		00	2019-09-20	2019-09-23	2019-10-04	2019-08-21		0	2019-08-21	?	0	0005931698			20190821.ifs	2019-08-21	2019-08-22
3729293	3729293	DIVIDEND	ADD	168905107		0	0	1	0	.56		00	2019-06-17	2019-06-18	2019-06-28	2019-05-15		0	2019-05-15	?	0	0005884276			20190515.ifs	2019-05-15	2019-05-16
3729304	3729304	DIVIDEND	ADD	168905107		0	0	1	0	.56		00	2019-06-17	2019-06-18	2019-06-28	2019-05-15		0	2019-05-15	?	0	0005884276			20190515.ifs	2019-05-15	2019-05-16
3642484	3642484	DIVIDEND	ADD	168905107		0	0	1	0	.56		00	2019-04-12	2019-04-15	2019-04-26	2019-03-21		0	2019-03-21	?	0	0005856238			20190321.ifs	2019-03-21	2019-03-22
3642485	3642485	DIVIDEND	ADD	168905107		0	0	1	0	.56		00	2019-04-12	2019-04-15	2019-04-26	2019-03-21		0	2019-03-21	?	0	0005856238			20190321.ifs	2019-03-21	2019-03-22
3409315	3409315	DIVIDEND	ADD	168905107		0	0	1	0	.5		00	2018-12-14	2018-12-17	2018-12-28	2018-12-06		0	2018-12-06	?	0	0005766508			20181206.ifs	2018-12-06	2018-12-07
3409316	3409316	DIVIDEND	ADD	168905107		0	0	1	0	.5		00	2018-12-14	2018-12-17	2018-12-28	2018-12-06		0	2018-12-06	?	0	0005766508			20181206.ifs	2018-12-06	2018-12-07
3248613	3248613	DIVIDEND	ADD	168905107		0	0	1	0	.5		00	2018-09-04	2018-09-05	2018-09-17	2018-08-23		0	2018-08-23	?	0	0005710156			20180823.ifs	2018-08-23	2018-08-24
3248870	3248870	DIVIDEND	ADD	168905107		0	0	1	0	.5		00	2018-09-04	2018-09-05	2018-09-17	2018-08-23		0	2018-08-23	?	0	0005710156			20180823.ifs	2018-08-23	2018-08-24
3094032	3094032	DIVIDEND	ADD	168905107		0	0	1	0	.5		00	2018-06-15	2018-06-18	2018-06-29	2018-05-17		0	2018-05-17	?	0	0005662207			20180517.ifs	2018-05-17	2018-05-18
3094039	3094039	DIVIDEND	ADD	168905107		0	0	1	0	.5		00	2018-06-15	2018-06-18	2018-06-29	2018-05-17		0	2018-05-17	?	0	0005662207			20180517.ifs	2018-05-17	2018-05-18
2998984	2998984	DIVIDEND	ADD	168905107		0	0	1	0	.5		00	2018-04-13	2018-04-16	2018-04-27	2018-03-20		0	2018-03-20	?	0	0005631245			20180320.ifs	2018-03-20	2018-03-21
2999099	2999099	DIVIDEND	ADD	168905107		0	0	1	0	.5		00	2018-04-13	2018-04-16	2018-04-27	2018-03-20		0	2018-03-20	?	0	0005631245			20180320.ifs	2018-03-20	2018-03-21
2767139	2767139	DIVIDEND	ADD	168905107		0	0	1	0	.4		00	2017-12-12	2017-12-13	2018-01-03	2017-11-15		0	2017-11-15	?	0	0005529884			20171115.ifs	2017-11-15	2017-11-16
2767195	2767195	DIVIDEND	ADD	168905107		0	0	1	0	.4		00	2017-12-12	2017-12-13	2018-01-03	2017-11-15		0	2017-11-15	?	0	0005529884			20171115.ifs	2017-11-15	2017-11-16
2646757	2646757	DIVIDEND	ADD	168905107		0	0	1	0	.4		00	2017-09-11	2017-09-12	2017-10-03	2017-08-09		0	2017-08-09	?	0	0005481897			20170809.ifs	2017-08-09	2017-08-10
2569965	2569965	DIVIDEND	ADD	168905107		0	0	1	0	.4		00	2017-06-15	2017-06-19	2017-07-10	2017-05-18		0	2017-05-18	?	0	0005436124			20170518.ifs	2017-05-18	2017-05-19
2509397	2509397	DIVIDEND	ADD	168905107		0	0	1	0	.4		00	2017-04-06	2017-04-10	2017-05-01	2017-03-08		0	2017-03-08	?	0	0005400747			20170308.ifs	2017-03-08	2017-03-09
2435980	2435980	EQUITY	CHANGE	168905107	COM	0	0	1997-09-19	?	0	yes	yes		yes		1997-09-24	2002-08-09	?							20170123.ifs	2017-01-23	2017-01-24
2435981	2435980	EQUITY	CHANGE	168905107	COM	0	0	1997-09-19	?	4	yes	yes		yes		1997-09-24	2002-08-09	?							20170123.ifs	2017-01-23	2017-01-24
2345076	2345076	DIVIDEND	ADD	168905107		0	0	1	0	.2		00	2016-12-14	2016-12-17	2017-01-05	2016-11-17		0	2016-11-17	?	0	0005311939			20161117.ifs	2016-11-17	2016-11-18
2198194	2198194	DIVIDEND	ADD	168905107		0	0	1	0	.2		00	2016-06-14	2016-06-16	2016-07-07	2016-05-17		0	2016-05-17	?	0	0005219503			20160517.ifs	2016-05-17	2016-05-18
2135626	2135626	DIVIDEND	ADD	168905107		0	0	1	0	.2		00	2016-04-05	2016-04-07	2016-04-28	2016-03-15		0	2016-03-15	?	0	0005186618			20160315.ifs	2016-03-15	2016-03-16
2029639	2029639	DIVIDEND	ADD	168905107		0	0	1	0	.15		00	2015-12-15	2015-12-17	2016-01-07	2015-12-09		0	2015-12-09	?	0	0005108314			20151209.ifs	2015-12-09	2015-12-10
1947135	1947135	DIVIDEND	ADD	168905107		0	0	1	0	.15		00	2015-09-15	2015-09-17	2015-10-08	2015-08-25		0	2015-08-25	?	0	0005049973			20150825.ifs	2015-08-25	2015-08-26
1859002	1859002	DIVIDEND	ADD	168905107		0	0	1	0	.15		00	2015-06-16	2015-06-18	2015-07-09	2015-05-06		0	2015-05-06	?	0	0004998361			20150506.ifs	2015-05-06	2015-05-07
1810926	1810926	DIVIDEND	ADD	168905107		0	0	1	0	.15		00	2015-04-07	2015-04-09	2015-04-30	2015-03-12		0	2015-03-12	?	0	0004967629			20150312.ifs	2015-03-12	2015-03-13
1685014	1685014	DIVIDEND	ADD	168905107		0	0	1	0	.1325		00	2014-12-23	2014-12-26	2015-01-16	2014-11-20		0	2014-11-20	?	0	0004874290			20141120.ifs	2014-11-20	2014-11-21
1610835	1610835	DIVIDEND	ADD	168905107		0	0	1	0	.1325		00	2014-09-24	2014-09-26	2014-10-17	2014-08-21		0	2014-08-21	?	0	0004830452			20140821.ifs	2014-08-21	2014-08-22
1552016	1552016	CORPACTION	ADD	168905107	60	#	2014-06-18	168905107	60	2014-06-18															20140618.ifs	2014-06-18	2014-06-19
1552017	1552017	CORPACTIONAUX	ADD	168905107	60	2014-06-18	PLCE	CHILDRENS PL RETAIL STRS INC	COM	PLCE	CHILDRENS PL INC NEW	COM	?	2014-06-18											20140618.ifs	2014-06-18	2014-06-19
1552018	1552018	EXCHANGE	CHANGE	168905107	60	1997-09-19	2014-06-17	PLCE	0	0	1998-08-19	2002-08-09													20140618.ifs	2014-06-18	2014-06-19
1552019	1552018	EXCHANGE	CHANGE	168905107	60	1997-09-19	2014-06-17	PLCE	0	0	1998-08-19	2014-06-18													20140618.ifs	2014-06-18	2014-06-19
1552662	1552662	DIVIDEND	CHANGE	168905107		0	0	1	0	.1325		00	2014-06-25	2014-06-27	2014-07-17	2014-05-22		0	2014-05-22	?	0	0004784123			20140618.ifs	2014-06-18	2014-06-19
1552663	1552662	DIVIDEND	CHANGE	168905107		0	0	1	0	.1325		00	2014-06-25	2014-06-27	2014-07-17	2014-05-22		1	2014-05-22	2014-06-18	0	0004784123			20140618.ifs	2014-06-18	2014-06-19
1528864	1528864	DIVIDEND	ADD	168905107		0	0	1	0	.1325		00	2014-06-25	2014-06-27	2014-07-17	2014-05-22		0	2014-05-22	?	0	0004784123			20140522.ifs	2014-05-22	2014-05-23
1461777	1461777	DIVIDEND	ADD	168905107		0	0	1	4	.1325		00	2014-03-25	2014-03-27	2014-04-17	2014-03-06		0	2014-03-06	?	0	0004748335			20140306.ifs	2014-03-06	2014-03-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 = 130839
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