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
5541927	5541927	DIVIDEND	ADD	89832Q109		0	0	1	0	.52		00	2024-05-09	2024-05-10	2024-06-03	2024-04-23		0	2024-04-23	?	0	0006908270			20240423.ifs	2024-04-23	2024-04-24
5483596	5483596	DIVIDEND	ADD	89832Q109		0	0	1	0	.52		00	2024-02-08	2024-02-09	2024-03-01	2024-01-23		0	2024-01-23	?	0	0006865936			20240123.ifs	2024-01-23	2024-01-24
5399204	5399204	DIVIDEND	ADD	89832Q109		0	0	1	0	.52		00	2023-11-09	2023-11-10	2023-12-01	2023-10-24		0	2023-10-24	?	0	0006801013			20231024.ifs	2023-10-24	2023-10-25
5339278	5339278	DIVIDEND	ADD	89832Q109		0	0	1	0	.52		00	2023-08-10	2023-08-11	2023-09-01	2023-07-25		0	2023-07-25	?	0	0006758525			20230725.ifs	2023-07-25	2023-07-26
5276632	5276632	DIVIDEND	ADD	89832Q109		0	0	1	0	.52		00	2023-05-11	2023-05-12	2023-06-01	2023-04-25		0	2023-04-25	?	0	0006715182			20230425.ifs	2023-04-25	2023-04-26
5215674	5215674	DIVIDEND	ADD	89832Q109		0	0	1	0	.52		00	2023-02-09	2023-02-10	2023-03-01	2023-01-24		0	2023-01-24	?	0	0006671813			20230124.ifs	2023-01-24	2023-01-25
5124984	5124984	DIVIDEND	ADD	89832Q109		0	0	1	0	.52		00	2022-11-09	2022-11-10	2022-12-01	2022-10-25		0	2022-10-25	?	0	0006602197			20221025.ifs	2022-10-25	2022-10-26
5063533	5063533	DIVIDEND	ADD	89832Q109		0	0	1	0	.52		00	2022-08-11	2022-08-12	2022-09-01	2022-07-26		0	2022-07-26	?	0	0006558659			20220726.ifs	2022-07-26	2022-07-27
4997967	4997967	DIVIDEND	ADD	89832Q109		0	0	1	0	.48		00	2022-05-12	2022-05-13	2022-06-01	2022-04-26		0	2022-04-26	?	0	0006513441			20220426.ifs	2022-04-26	2022-04-27
4938964	4938964	DIVIDEND	ADD	89832Q109		0	0	1	0	.48		00	2022-02-10	2022-02-11	2022-03-01	2022-01-25		0	2022-01-25	?	0	0006470410			20220125.ifs	2022-01-25	2022-01-26
4831913	4831913	DIVIDEND	ADD	89832Q109		0	0	1	0	.48		00	2021-11-10	2021-11-12	2021-12-01	2021-10-26		0	2021-10-26	?	0	0006386376			20211026.ifs	2021-10-26	2021-10-27
4765352	4765352	DIVIDEND	ADD	89832Q109		0	0	1	0	.48		00	2021-08-12	2021-08-13	2021-09-01	2021-07-27		0	2021-07-27	?	0	0006342729			20210727.ifs	2021-07-27	2021-07-28
4688915	4688915	DIVIDEND	ADD	89832Q109		0	0	1	0	.45		00	2021-05-13	2021-05-14	2021-06-01	2021-04-27		0	2021-04-27	?	0	0006297417			20210427.ifs	2021-04-27	2021-04-28
4611746	4611746	DIVIDEND	ADD	89832Q109		0	0	1	0	.45		00	2021-02-11	2021-02-12	2021-03-01	2021-01-26		0	2021-01-26	?	0	0006254074			20210126.ifs	2021-01-26	2021-01-27
4506142	4506142	EQUITY	CHANGE	89832Q109	COM	0	0	2012-01-31	?	0	no	no		no		2019-12-05	?	?							20201113.ifs	2020-11-13	2020-11-14
4506143	4506142	EQUITY	CHANGE	89832Q109	COM	0	0	2012-01-31	?	4	no	no		no		2019-12-05	2020-11-13	?							20201113.ifs	2020-11-13	2020-11-14
4491786	4491786	DIVIDEND	ADD	89832Q109		0	0	1	0	.45		00	2020-11-12	2020-11-13	2020-12-01	2020-10-27		0	2020-10-27	?	0	0006178093			20201027.ifs	2020-10-27	2020-10-28
4425139	4425139	DIVIDEND	ADD	89832Q109		0	0	1	0	.45		00	2020-08-13	2020-08-14	2020-09-01	2020-07-28		0	2020-07-28	?	0	0006133462			20200728.ifs	2020-07-28	2020-07-29
4303745	4303745	DIVIDEND	ADD	89832Q109		0	0	1	0	.45		00	2020-05-14	2020-05-15	2020-06-01	2020-04-28		0	2020-04-28	?	0	0006088663			20200428.ifs	2020-04-28	2020-04-29
4303746	4303746	DIVIDEND	ADD	89832Q109		0	0	1	0	.45		00	2020-05-14	2020-05-15	2020-06-01	2020-04-28		0	2020-04-28	?	0	0006088663			20200428.ifs	2020-04-28	2020-04-29
4180012	4180012	DIVIDEND	ADD	89832Q109		0	0	1	0	.45		00	2020-02-13	2020-02-14	2020-03-02	2020-01-28		0	2020-01-28	?	0	0006045483			20200128.ifs	2020-01-28	2020-01-29
4180037	4180037	DIVIDEND	ADD	89832Q109		0	0	1	0	.45		00	2020-02-13	2020-02-14	2020-03-02	2020-01-28		0	2020-01-28	?	0	0006045483			20200128.ifs	2020-01-28	2020-01-29
4049544	4049544	EXCHANGE	ADD	89832Q109	01	2019-12-09	2019-12-09	TFC	0	0	2019-12-09	?													20191209.ifs	2019-12-09	2019-12-10
4049545	4049545	EXCHANGE	ADD	89832Q109	01	2019-12-09	2019-12-09	TFC	0	0	2019-12-09	?													20191209.ifs	2019-12-09	2019-12-10
4051274	4051274	EQUITY	CHANGE	89832Q109	COM	N	0	2012-01-31	?	0	no	no		no		2019-12-05	?	?							20191209.ifs	2019-12-09	2019-12-10
4051276	4051275	EQUITY	CHANGE	89832Q109	COM	0	0	2012-01-31	?	0	no	no		no		2019-12-05	?	?							20191209.ifs	2019-12-09	2019-12-10
4051407	4051407	EQUITY	CHANGE	89832Q109	COM	N	0	2012-01-31	?	0	no	no		no		2019-12-05	?	?							20191209.ifs	2019-12-09	2019-12-10
4051408	4051407	EQUITY	CHANGE	89832Q109	COM	0	0	2012-01-31	?	0	no	no		no		2019-12-05	?	?							20191209.ifs	2019-12-09	2019-12-10
4041705	4041705	EQUITY	ADD	89832Q109	COM	N	0	2012-01-31	?	0	no	no		no		2019-12-05	?	?							20191205.ifs	2019-12-05	2019-12-06
4041708	4041708	EQUITY	ADD	89832Q109	COM	N	0	2012-01-31	?	0	no	no		no		2019-12-05	?	?							20191205.ifs	2019-12-05	2019-12-06

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