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
5557799	5557799	DIVIDEND	ADD	816851109		0	0	1	0	.62		00	2024-06-27	2024-06-27	2024-07-15	2024-05-14		0	2024-05-14	?	0	0006919647			20240514.ifs	2024-05-14	2024-05-15
5503534	5503534	DIVIDEND	ADD	816851109		0	0	1	0	.62		00	2024-03-20	2024-03-21	2024-04-15	2024-02-26		0	2024-02-27	?	0	0006879720			20240227.ifs	2024-02-27	2024-02-28
5414082	5414082	DIVIDEND	ADD	816851109		0	0	1	0	.595		00	2023-12-05	2023-12-06	2024-01-15	2023-11-14		0	2023-11-14	?	0	0006811646			20231114.ifs	2023-11-14	2023-11-15
5368887	5368887	DIVIDEND	ADD	816851109		0	0	1	0	.595		35	2023-09-26	2023-09-27	2023-10-15	2023-09-06		0	2023-09-06	?	0	0006780759			20230906.ifs	2023-09-06	2023-09-07
5350486	5350486	DIVIDEND	ADD	816851109		0	0	6	0	1		11	2023-08-22	2023-08-14	2023-08-21	2023-08-03		0	2023-08-03	?	0	0006767222			20230803.ifs	2023-08-03	2023-08-04
5350487	5350487	SPLIT	ADD	816851109	.5	2023-08-22	11	2023-08-03	?																20230803.ifs	2023-08-03	2023-08-04
5290333	5290333	DIVIDEND	ADD	816851109		0	0	1	0	1.19		00	2023-07-03	2023-07-05	2023-07-15	2023-05-11		0	2023-05-12	?	0	0006725177			20230512.ifs	2023-05-12	2023-05-13
5236789	5236789	DIVIDEND	ADD	816851109		0	0	1	0	1.19		00	2023-03-21	2023-03-22	2023-04-15	2023-02-27		0	2023-02-28	?	0	0006686317			20230228.ifs	2023-02-28	2023-03-01
5140061	5140061	DIVIDEND	ADD	816851109		0	0	1	0	1.145		00	2022-12-21	2022-12-22	2023-01-15	2022-11-15		0	2022-11-16	?	0	0006612951			20221116.ifs	2022-11-16	2022-11-17
5093954	5093954	DIVIDEND	ADD	816851109		0	0	1	0	1.145		00	2022-09-22	2022-09-23	2022-10-15	2022-09-07		0	2022-09-08	?	0	0006581409			20220908.ifs	2022-09-08	2022-09-09
5011566	5011566	DIVIDEND	ADD	816851109		0	0	1	0	1.145		00	2022-07-06	2022-07-07	2022-07-15	2022-05-12		0	2022-05-13	?	0	0006523818			20220513.ifs	2022-05-13	2022-05-14
4958312	4958312	DIVIDEND	ADD	816851109		0	0	1	0	1.145		00	2022-03-24	2022-03-25	2022-04-15	2022-02-25		0	2022-02-25	?	0	0006484032			20220225.ifs	2022-02-25	2022-02-26
4849387	4849387	DIVIDEND	ADD	816851109		0	0	1	0	1.1		00	2021-12-22	2021-12-23	2022-01-15	2021-11-17		0	2021-11-17	?	0	0006397120			20211117.ifs	2021-11-17	2021-11-18
4796340	4796340	DIVIDEND	ADD	816851109		0	0	1	0	1.1		00	2021-09-23	2021-09-24	2021-10-15	2021-09-02		0	2021-09-02	?	0	0006364548			20210902.ifs	2021-09-02	2021-09-03
4751426	4751426	CORPACTION	ADD	816851109	01	#	2021-07-02	816851109	01	2021-07-02															20210702.ifs	2021-07-02	2021-07-03
4751427	4751427	CORPACTIONAUX	ADD	816851109	01	2021-07-02	SRE	SEMPRA ENERGY	COM	SRE	SEMPRA	COM	?	2021-07-02											20210702.ifs	2021-07-02	2021-07-03
4751428	4751428	EXCHANGE	CHANGE	816851109	01	1998-06-29	2021-07-01	SRE	0	0	2001-01-29	2012-03-30													20210702.ifs	2021-07-02	2021-07-03
4751429	4751428	EXCHANGE	CHANGE	816851109	01	1998-06-29	2021-07-01	SRE	0	0	2001-01-29	2021-07-02													20210702.ifs	2021-07-02	2021-07-03
4743422	4743422	DIVIDEND	CHANGE	816851109		0	0	1	0	1.1		00	2021-07-06	2021-07-07	2021-07-15	2021-06-15		0	2021-06-15	?	0	0006321956			20210630.ifs	2021-06-30	2021-07-01
4743423	4743422	DIVIDEND	CHANGE	816851109		0	0	1	0	1.1		00	2021-07-06	2021-07-07	2021-07-15	2021-06-15		1	2021-06-15	2021-06-30	0	0006321956			20210630.ifs	2021-06-30	2021-07-01
4729680	4729680	DIVIDEND	ADD	816851109		0	0	1	0	1.1		00	2021-07-06	2021-07-07	2021-07-15	2021-06-15		0	2021-06-15	?	0	0006321956			20210615.ifs	2021-06-15	2021-06-16
4636685	4636685	DIVIDEND	ADD	816851109		0	0	1	0	1.1		00	2021-03-24	2021-03-25	2021-04-15	2021-02-25		0	2021-02-25	?	0	0006267176			20210225.ifs	2021-02-25	2021-02-26
4508829	4508829	DIVIDEND	ADD	816851109		0	0	1	0	1.045		00	2020-12-17	2020-12-18	2021-01-15	2020-11-18		0	2020-11-18	?	0	0006189017			20201118.ifs	2020-11-18	2020-11-19
4448862	4448862	DIVIDEND	ADD	816851109		0	0	1	0	1.045		00	2020-09-24	2020-09-25	2020-10-15	2020-08-31		0	2020-08-31	?	0	0006149803			20200831.ifs	2020-08-31	2020-09-01
4389849	4389849	DIVIDEND	ADD	816851109		0	0	1	0	1.045		00	2020-06-25	2020-06-26	2020-07-15	2020-06-11		0	2020-06-11	?	0	0006111781			20200611.ifs	2020-06-11	2020-06-12
4216475	4216475	DIVIDEND	ADD	816851109		0	0	1	0	1.045		00	2020-03-19	2020-03-20	2020-04-15	2020-02-25		0	2020-02-26	?	0	0006058088			20200226.ifs	2020-02-26	2020-02-27
4216476	4216476	DIVIDEND	ADD	816851109		0	0	1	0	1.045		00	2020-03-19	2020-03-20	2020-04-15	2020-02-25		0	2020-02-26	?	0	0006058088			20200226.ifs	2020-02-26	2020-02-27
4049948	4049948	DIVIDEND	ADD	816851109		0	0	1	0	.9675		00	2019-12-27	2019-12-30	2020-01-15	2019-12-09		0	2019-12-09	?	0	0005990713			20191209.ifs	2019-12-09	2019-12-10
4049989	4049989	DIVIDEND	ADD	816851109		0	0	1	0	.9675		00	2019-12-27	2019-12-30	2020-01-15	2019-12-09		0	2019-12-09	?	0	0005990713			20191209.ifs	2019-12-09	2019-12-10
3914282	3914282	DIVIDEND	ADD	816851109		0	0	1	0	.9675		00	2019-09-19	2019-09-20	2019-10-15	2019-09-06		0	2019-09-06	?	0	0005942350			20190906.ifs	2019-09-06	2019-09-07
3914306	3914306	DIVIDEND	ADD	816851109		0	0	1	0	.9675		00	2019-09-19	2019-09-20	2019-10-15	2019-09-06		0	2019-09-06	?	0	0005942350			20190906.ifs	2019-09-06	2019-09-07
3785393	3785393	DIVIDEND	ADD	816851109		0	0	1	0	.9675		00	2019-07-03	2019-07-05	2019-07-15	2019-06-18		0	2019-06-18	?	0	0005899598			20190618.ifs	2019-06-18	2019-06-19
3785404	3785404	DIVIDEND	ADD	816851109		0	0	1	0	.9675		00	2019-07-03	2019-07-05	2019-07-15	2019-06-18		0	2019-06-18	?	0	0005899598			20190618.ifs	2019-06-18	2019-06-19
3591594	3591594	DIVIDEND	ADD	816851109		0	0	1	0	.9675		00	2019-03-21	2019-03-22	2019-04-15	2019-02-22		0	2019-02-22	?	0	0005840750			20190222.ifs	2019-02-22	2019-02-23
3591595	3591595	DIVIDEND	ADD	816851109		0	0	1	0	.9675		00	2019-03-21	2019-03-22	2019-04-15	2019-02-22		0	2019-02-22	?	0	0005840750			20190222.ifs	2019-02-22	2019-02-23
3457285	3457285	DIVIDEND	ADD	816851109		0	0	1	0	.895		00	2018-12-28	2018-12-31	2019-01-15	2018-12-18		0	2018-12-18	?	0	0005787163			20181218.ifs	2018-12-18	2018-12-19
3457286	3457286	DIVIDEND	ADD	816851109		0	0	1	0	.895		00	2018-12-28	2018-12-31	2019-01-15	2018-12-18		0	2018-12-18	?	0	0005787163			20181218.ifs	2018-12-18	2018-12-19
3271851	3271851	DIVIDEND	ADD	816851109		0	0	1	0	.895		00	2018-09-20	2018-09-21	2018-10-15	2018-09-06		0	2018-09-06	?	0	0005720508			20180906.ifs	2018-09-06	2018-09-07
3271854	3271854	DIVIDEND	ADD	816851109		0	0	1	0	.895		00	2018-09-20	2018-09-21	2018-10-15	2018-09-06		0	2018-09-06	?	0	0005720508			20180906.ifs	2018-09-06	2018-09-07
3148532	3148532	DIVIDEND	ADD	816851109		0	0	1	0	.895		00	2018-06-29	2018-07-02	2018-07-15	2018-06-20		0	2018-06-20	?	0	0005677781			20180620.ifs	2018-06-20	2018-06-21
3148537	3148537	DIVIDEND	ADD	816851109		0	0	1	0	.895		00	2018-06-29	2018-07-02	2018-07-15	2018-06-20		0	2018-06-20	?	0	0005677781			20180620.ifs	2018-06-20	2018-06-21
2962610	2962610	DIVIDEND	ADD	816851109		0	0	1	0	.895		00	2018-03-22	2018-03-23	2018-04-15	2018-02-22		0	2018-02-23	?	0	0005617683			20180223.ifs	2018-02-23	2018-02-24
2962613	2962613	DIVIDEND	ADD	816851109		0	0	1	0	.895		00	2018-03-22	2018-03-23	2018-04-15	2018-02-22		0	2018-02-23	?	0	0005617683			20180223.ifs	2018-02-23	2018-02-24
2832673	2832673	DIVIDEND	ADD	816851109		0	0	1	0	.8225		00	2017-12-28	2017-12-29	2018-01-15	2017-12-15		0	2017-12-15	?	0	0005556816			20171215.ifs	2017-12-15	2017-12-16
2667876	2667876	DIVIDEND	ADD	816851109		0	0	1	0	.8225		00	2017-09-21	2017-09-22	2017-10-15	2017-09-08		0	2017-09-08	?	0	0005495045			20170908.ifs	2017-09-08	2017-09-09
2597313	2597313	DIVIDEND	ADD	816851109		0	0	1	0	.8225		00	2017-07-05	2017-07-07	2017-07-15	2017-06-21		0	2017-06-21	?	0	0005452603			20170621.ifs	2017-06-21	2017-06-22
2494491	2494491	DIVIDEND	ADD	816851109		0	0	1	0	.8225		00	2017-03-21	2017-03-23	2017-04-15	2017-02-23		0	2017-02-23	?	0	0005390734			20170223.ifs	2017-02-23	2017-02-24
2379541	2379541	DIVIDEND	ADD	816851109		0	0	1	0	.755		00	2016-12-27	2016-12-29	2017-01-15	2016-12-16		0	2016-12-16	?	0	0005338045			20161216.ifs	2016-12-16	2016-12-17
2290676	2290676	DIVIDEND	ADD	816851109		0	0	1	0	.755		00	2016-09-27	2016-09-29	2016-10-15	2016-09-09		0	2016-09-09	?	0	0005278786			20160909.ifs	2016-09-09	2016-09-10
2219929	2219929	DIVIDEND	ADD	816851109		0	0	1	0	.755		00	2016-06-28	2016-06-30	2016-07-15	2016-06-14		0	2016-06-14	?	0	0005231870			20160614.ifs	2016-06-14	2016-06-15
2115695	2115695	DIVIDEND	ADD	816851109		0	0	1	0	.755		00	2016-03-22	2016-03-25	2016-04-15	2016-02-19		0	2016-02-19	?	0	0005174023			20160219.ifs	2016-02-19	2016-02-20
2039448	2039448	DIVIDEND	ADD	816851109		0	0	1	0	.7		00	2015-12-23	2015-12-28	2016-01-15	2015-12-15		0	2015-12-15	?	0	0005116631			20151215.ifs	2015-12-15	2015-12-16
1962974	1962974	DIVIDEND	ADD	816851109		0	0	1	0	.7		00	2015-09-23	2015-09-25	2015-10-15	2015-09-10		0	2015-09-10	?	0	0005061050			20150910.ifs	2015-09-10	2015-09-11
1887165	1887165	DIVIDEND	ADD	816851109		0	0	1	0	.7		00	2015-06-25	2015-06-29	2015-07-15	2015-06-16		0	2015-06-16	?	0	0005013985			20150616.ifs	2015-06-16	2015-06-17
1793100	1793100	DIVIDEND	ADD	816851109		0	0	1	0	.7		00	2015-03-25	2015-03-27	2015-04-15	2015-02-20		0	2015-02-20	?	0	0004956374			20150220.ifs	2015-02-20	2015-02-21
1704041	1704041	DIVIDEND	ADD	816851109		0	0	1	0	.66		00	2014-12-18	2014-12-22	2015-01-15	2014-12-09		0	2014-12-09	?	0	0004887890			20141209.ifs	2014-12-09	2014-12-10
1629046	1629046	DIVIDEND	ADD	816851109		0	0	1	0	.66		00	2014-09-23	2014-09-25	2014-10-15	2014-09-12		0	2014-09-12	?	0	0004842393			20140912.ifs	2014-09-12	2014-09-13
1550253	1550253	DIVIDEND	ADD	816851109		0	0	1	0	.66		00	2014-06-27	2014-07-01	2014-07-15	2014-06-16		0	2014-06-16	?	0	0004797011			20140616.ifs	2014-06-16	2014-06-17
1447745	1447745	DIVIDEND	ADD	816851109		0	0	1	0	.66		00	2014-03-25	2014-03-27	2014-04-15	2014-02-21		0	2014-02-21	?	0	0004738622			20140221.ifs	2014-02-21	2014-02-22
1376026	1376026	DIVIDEND	ADD	816851109		0	0	1	0	.63		00	2013-12-27	2013-12-31	2014-01-15	2013-12-17		0	2013-12-17	?	0	0004687125			20131217.ifs	2013-12-17	2013-12-18
1286306	1286306	DIVIDEND	ADD	816851109		0	0	1	0	.63		00	2013-09-25	2013-09-27	2013-10-15	2013-09-12		0	2013-09-12	?	0	0004628379			20130912.ifs	2013-09-12	2013-09-13
1211707	1211707	DIVIDEND	ADD	816851109		0	0	1	0	.63		00	2013-06-26	2013-06-28	2013-07-15	2013-06-18		0	2013-06-18	?	0	0004584811			20130618.ifs	2013-06-18	2013-06-19
1116393	1116393	DIVIDEND	ADD	816851109		0	0	1	0	.63		00	2013-03-26	2013-03-28	2013-04-15	2013-02-22		0	2013-02-22	?	0	0004530130			20130222.ifs	2013-02-22	2013-02-23
1041128	1041128	DIVIDEND	ADD	816851109		0	0	1	0	.6		00	2012-12-26	2012-12-28	2013-01-15	2012-12-14		0	2012-12-14	?	0	0004479504			20121214.ifs	2012-12-14	2012-12-15
955653	955653	DIVIDEND	ADD	816851109		0	0	1	0	.6		00	2012-09-26	2012-09-28	2012-10-15	2012-09-13		0	2012-09-13	?	0	0004428821			20120913.ifs	2012-09-13	2012-09-14
883674	883674	DIVIDEND	ADD	816851109		0	0	1	0	.6		00	2012-06-25	2012-06-27	2012-07-15	2012-06-12		0	2012-06-12	?	0	0004385611			20120612.ifs	2012-06-12	2012-06-13
815848	815848	EQUITY	CHANGE	816851109	COM	0	0	1998-06-29	?	4	yes	yes		no		2001-09-05	1999-03-26	?							20120330.ifs	2012-03-30	2012-03-31
815849	815848	EQUITY	CHANGE	816851109	COM	0	0	1998-06-29	?	4	yes	yes		no		2001-09-05	2012-03-30	?							20120330.ifs	2012-03-30	2012-03-31
815850	815850	DIVIDEND	CHANGE	816851109		0	0	1	4	.39	0	00	1998-09-17	1998-09-21	1998-10-15	1998-09-01		0	?	2008-06-16	0	0001414057			20120330.ifs	2012-03-30	2012-03-31
815851	815850	DIVIDEND	CHANGE	816851109		0	0	1	4	.39	0	00	1998-09-17	1998-09-21	1998-10-15	1998-09-01		0	?	2012-03-30	0	0001414057			20120330.ifs	2012-03-30	2012-03-31
815852	815852	DIVIDEND	CHANGE	816851109		0	0	1	0	.35		00	2008-06-17	2008-06-19	2008-07-15	2008-04-02		1	2008-04-02	2008-05-22	0	0003620413			20120330.ifs	2012-03-30	2012-03-31
815853	815852	DIVIDEND	CHANGE	816851109		0	0	1	0	.35		00	2008-06-17	2008-06-19	2008-07-15	2008-04-02		1	2008-04-02	2012-03-30	0	0003620413			20120330.ifs	2012-03-30	2012-03-31
815854	815854	EXCHANGE	CHANGE	816851109	01	1998-06-29	2012-03-29	SRE	0	0	2001-01-29	1999-03-26													20120330.ifs	2012-03-30	2012-03-31
815855	815854	EXCHANGE	CHANGE	816851109	01	1998-06-29	2012-03-29	SRE	0	0	2001-01-29	2012-03-30													20120330.ifs	2012-03-30	2012-03-31
815856	815856	EXCHANGE	CHANGE	816851109	01	1998-06-29	2012-03-29	SRE	0	0	2001-01-29	2012-03-30													20120330.ifs	2012-03-30	2012-03-31
815857	815856	EXCHANGE	CHANGE	816851109	01	1998-06-29	2012-03-29	SRE	0	0	2001-01-29	2012-03-30													20120330.ifs	2012-03-30	2012-03-31
786826	786826	DIVIDEND	ADD	816851109		0	0	1	0	.6		00	2012-03-22	2012-03-26	2012-04-15	2012-02-28		0	2012-02-28	?	0	0004335838			20120228.ifs	2012-02-28	2012-02-29
713476	713476	DIVIDEND	ADD	816851109		0	0	1	0	.48		00	2011-12-20	2011-12-22	2012-01-15	2011-12-06		0	2011-12-06	?	0	0004281375			20111206.ifs	2011-12-06	2011-12-07
641895	641895	DIVIDEND	ADD	816851109		0	0	1	0	.48		00	2011-09-27	2011-09-29	2011-10-15	2011-09-13		0	2011-09-13	?	0	0004241781			20110913.ifs	2011-09-13	2011-09-14
559116	559116	DIVIDEND	ADD	816851109		0	0	1	0	.48		00	2011-06-22	2011-06-24	2011-07-15	2011-06-14		0	2011-06-14	?	0	0004200546			20110614.ifs	2011-06-14	2011-06-15
447624	447624	DIVIDEND	ADD	816851109		0	0	1	0	.48		00	2011-03-16	2011-03-18	2011-04-15	2011-02-22		0	2011-02-22	?	0	0004148549			20110222.ifs	2011-02-22	2011-02-23
371618	371618	DIVIDEND	ADD	816851109		0	0	1	0	.39		00	2010-12-21	2010-12-23	2011-01-15	2010-12-07		0	2010-12-07	?	0	0004099707			20101207.ifs	2010-12-07	2010-12-08
281318	281318	DIVIDEND	ADD	816851109		0	0	1	0	.39		00	2010-09-27	2010-09-29	2010-10-15	2010-08-19		0	2010-08-19	?	0	0004048328			20100819.ifs	2010-08-19	2010-08-20
190552	190552	DIVIDEND	ADD	816851109		0	0	1	0	.39		00	2010-06-16	2010-06-18	2010-07-15	2010-05-12		0	2010-05-12	?	0	0004005538			20100512.ifs	2010-05-12	2010-05-13
109427	109427	DIVIDEND	ADD	816851109		0	0	1	0	.39		00	2010-03-16	2010-03-18	2010-04-15	2010-02-12		0	2010-02-12	?	0	0003965059			20100212.ifs	2010-02-12	2010-04-07
55929	55929	DIVIDEND	ADD	816851109		0	0	1	0	.39		00	2009-12-28	2009-12-30	2010-01-15	2009-12-18		0	2009-12-18	?	0	0003930838			20091218.ifs	2009-12-18	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 = 130775
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