INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 1111 | 1037 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 88.73 % | 90.45 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:130528 |
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 | ||
5550320 | 5550320 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .66 | 00 | 2024-05-31 | 2024-05-31 | 2024-06-17 | 2024-04-30 | 0 | 2024-05-01 | ? | 0 | 0006913275 | 20240501.ifs | 2024-05-01 | 2024-05-02 | |||||||
5494918 | 5494918 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .66 | 00 | 2024-02-28 | 2024-02-29 | 2024-03-15 | 2024-02-05 | 0 | 2024-02-05 | ? | 0 | 0006874763 | 20240205.ifs | 2024-02-05 | 2024-02-06 | |||||||
5407773 | 5407773 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .66 | 00 | 2023-11-29 | 2023-11-30 | 2023-12-15 | 2023-11-01 | 0 | 2023-11-01 | ? | 0 | 0006805638 | 20231101.ifs | 2023-11-01 | 2023-11-02 | |||||||
5355640 | 5355640 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .66 | 00 | 2023-08-30 | 2023-08-31 | 2023-09-15 | 2023-08-18 | 0 | 2023-08-18 | ? | 0 | 0006770040 | 20230818.ifs | 2023-08-18 | 2023-08-19 | |||||||
5286677 | 5286677 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .66 | 00 | 2023-05-30 | 2023-05-31 | 2023-06-15 | 2023-05-03 | 0 | 2023-05-03 | ? | 0 | 0006723179 | 20230503.ifs | 2023-05-03 | 2023-05-04 | |||||||
5225855 | 5225855 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .66 | 00 | 2023-02-27 | 2023-02-28 | 2023-03-15 | 2023-02-02 | 0 | 2023-02-02 | ? | 0 | 0006679691 | 20230202.ifs | 2023-02-02 | 2023-02-03 | |||||||
5134626 | 5134626 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .66 | 00 | 2022-11-29 | 2022-11-30 | 2022-12-15 | 2022-11-02 | 0 | 2022-11-02 | ? | 0 | 0006609982 | 20221102.ifs | 2022-11-02 | 2022-11-03 | |||||||
5079499 | 5079499 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .6 | 00 | 2022-08-30 | 2022-08-31 | 2022-09-15 | 2022-08-18 | 0 | 2022-08-18 | ? | 0 | 0006570283 | 20220818.ifs | 2022-08-18 | 2022-08-19 | |||||||
5006929 | 5006929 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .6 | 00 | 2022-05-27 | 2022-05-31 | 2022-06-15 | 2022-05-03 | 0 | 2022-05-03 | ? | 0 | 0006520361 | 20220503.ifs | 2022-05-03 | 2022-05-04 | |||||||
4948303 | 4948303 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .6 | 00 | 2022-02-25 | 2022-02-28 | 2022-03-15 | 2022-02-03 | 0 | 2022-02-03 | ? | 0 | 0006477741 | 20220203.ifs | 2022-02-03 | 2022-02-04 | |||||||
4842283 | 4842283 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .6 | 00 | 2021-11-29 | 2021-11-30 | 2021-12-15 | 2021-11-02 | 0 | 2021-11-02 | ? | 0 | 0006393759 | 20211102.ifs | 2021-11-02 | 2021-11-03 | |||||||
4783926 | 4783926 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .53 | 00 | 2021-08-30 | 2021-08-31 | 2021-09-15 | 2021-08-19 | 0 | 2021-08-19 | ? | 0 | 0006354373 | 20210819.ifs | 2021-08-19 | 2021-08-20 | |||||||
4696835 | 4696835 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .53 | 00 | 2021-05-27 | 2021-05-28 | 2021-06-15 | 2021-05-03 | 0 | 2021-05-03 | ? | 0 | 0006301209 | 20210503.ifs | 2021-05-03 | 2021-05-04 | |||||||
4625377 | 4625377 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .53 | 00 | 2021-02-25 | 2021-02-26 | 2021-03-15 | 2021-02-05 | 0 | 2021-02-05 | ? | 0 | 0006262173 | 20210205.ifs | 2021-02-05 | 2021-02-06 | |||||||
4499278 | 4499278 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .53 | 00 | 2020-11-27 | 2020-11-30 | 2020-12-15 | 2020-11-02 | 0 | 2020-11-02 | ? | 0 | 0006181672 | 20201102.ifs | 2020-11-02 | 2020-11-03 | |||||||
4443487 | 4443487 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .48 | 00 | 2020-08-28 | 2020-08-31 | 2020-09-15 | 2020-08-20 | 0 | 2020-08-20 | ? | 0 | 0006145309 | 20200820.ifs | 2020-08-20 | 2020-08-21 | |||||||
4289045 | 4289045 | DIVIDEND | ADD | 518439104 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-06-15 | 2020-04-15 | 0 | 2020-04-15 | ? | 0 | 0006085328 | 20200415.ifs | 2020-04-15 | 2020-04-16 | |||||||
4289046 | 4289046 | DIVIDEND | ADD | 518439104 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-06-15 | 2020-04-15 | 0 | 2020-04-15 | ? | 0 | 0006085328 | 20200415.ifs | 2020-04-15 | 2020-04-16 | |||||||
4200112 | 4200112 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .48 | 00 | 2020-02-27 | 2020-02-28 | 2020-03-16 | 2020-02-06 | 0 | 2020-02-06 | ? | 0 | 0006053515 | 20200206.ifs | 2020-02-06 | 2020-02-07 | |||||||
4200159 | 4200159 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .48 | 00 | 2020-02-27 | 2020-02-28 | 2020-03-16 | 2020-02-06 | 0 | 2020-02-06 | ? | 0 | 0006053515 | 20200206.ifs | 2020-02-06 | 2020-02-07 | |||||||
3993211 | 3993211 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .48 | 00 | 2019-11-27 | 2019-11-29 | 2019-12-16 | 2019-10-31 | 0 | 2019-10-31 | ? | 0 | 0005966823 | 20191031.ifs | 2019-10-31 | 2019-11-01 | |||||||
3993254 | 3993254 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .48 | 00 | 2019-11-27 | 2019-11-29 | 2019-12-16 | 2019-10-31 | 0 | 2019-10-31 | ? | 0 | 0005966823 | 20191031.ifs | 2019-10-31 | 2019-11-01 | |||||||
3882615 | 3882615 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .43 | 00 | 2019-08-29 | 2019-08-30 | 2019-09-16 | 2019-08-19 | 0 | 2019-08-19 | ? | 0 | 0005931059 | 20190819.ifs | 2019-08-19 | 2019-08-20 | |||||||
3882622 | 3882622 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .43 | 00 | 2019-08-29 | 2019-08-30 | 2019-09-16 | 2019-08-19 | 0 | 2019-08-19 | ? | 0 | 0005931059 | 20190819.ifs | 2019-08-19 | 2019-08-20 | |||||||
3710195 | 3710195 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .43 | 00 | 2019-05-30 | 2019-05-31 | 2019-06-17 | 2019-05-01 | 0 | 2019-05-01 | ? | 0 | 0005877198 | 20190501.ifs | 2019-05-01 | 2019-05-02 | |||||||
3710202 | 3710202 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .43 | 00 | 2019-05-30 | 2019-05-31 | 2019-06-17 | 2019-05-01 | 0 | 2019-05-01 | ? | 0 | 0005877198 | 20190501.ifs | 2019-05-01 | 2019-05-02 | |||||||
3575579 | 3575579 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .43 | 00 | 2019-02-27 | 2019-02-28 | 2019-03-15 | 2019-02-04 | 0 | 2019-02-05 | ? | 0 | 0005836419 | 20190205.ifs | 2019-02-05 | 2019-02-06 | |||||||
3575580 | 3575580 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .43 | 00 | 2019-02-27 | 2019-02-28 | 2019-03-15 | 2019-02-04 | 0 | 2019-02-05 | ? | 0 | 0005836419 | 20190205.ifs | 2019-02-05 | 2019-02-06 | |||||||
3347965 | 3347965 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .43 | 00 | 2018-11-29 | 2018-11-30 | 2018-12-17 | 2018-10-31 | 0 | 2018-10-31 | ? | 0 | 0005745267 | 20181031.ifs | 2018-10-31 | 2018-11-01 | |||||||
3348012 | 3348012 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .43 | 00 | 2018-11-29 | 2018-11-30 | 2018-12-17 | 2018-10-31 | 0 | 2018-10-31 | ? | 0 | 0005745267 | 20181031.ifs | 2018-10-31 | 2018-11-01 | |||||||
3243662 | 3243662 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .38 | 00 | 2018-08-30 | 2018-08-31 | 2018-09-17 | 2018-08-20 | 0 | 2018-08-20 | ? | 0 | 0005709069 | 20180820.ifs | 2018-08-20 | 2018-08-21 | |||||||
3243663 | 3243663 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .38 | 00 | 2018-08-30 | 2018-08-31 | 2018-09-17 | 2018-08-20 | 0 | 2018-08-20 | ? | 0 | 0005709069 | 20180820.ifs | 2018-08-20 | 2018-08-21 | |||||||
3075763 | 3075763 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .38 | 00 | 2018-05-30 | 2018-05-31 | 2018-06-15 | 2018-05-02 | 0 | 2018-05-02 | ? | 0 | 0005658039 | 20180502.ifs | 2018-05-02 | 2018-05-03 | |||||||
3075770 | 3075770 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .38 | 00 | 2018-05-30 | 2018-05-31 | 2018-06-15 | 2018-05-02 | 0 | 2018-05-02 | ? | 0 | 0005658039 | 20180502.ifs | 2018-05-02 | 2018-05-03 | |||||||
2943723 | 2943723 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .38 | 00 | 2018-02-27 | 2018-02-28 | 2018-03-15 | 2018-02-02 | 0 | 2018-02-02 | ? | 0 | 0005612242 | 20180202.ifs | 2018-02-02 | 2018-02-03 | |||||||
2943798 | 2943798 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .38 | 00 | 2018-02-27 | 2018-02-28 | 2018-03-15 | 2018-02-02 | 0 | 2018-02-02 | ? | 0 | 0005612242 | 20180202.ifs | 2018-02-02 | 2018-02-03 | |||||||
2751102 | 2751102 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .38 | 00 | 2017-11-29 | 2017-11-30 | 2017-12-15 | 2017-11-01 | 0 | 2017-11-01 | ? | 0 | 0005522713 | 20171101.ifs | 2017-11-01 | 2017-11-02 | |||||||
2651602 | 2651602 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .34 | 00 | 2017-08-29 | 2017-08-31 | 2017-09-15 | 2017-08-18 | 0 | 2017-08-18 | ? | 0 | 0005483617 | 20170818.ifs | 2017-08-18 | 2017-08-19 | |||||||
2561038 | 2561038 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .34 | 00 | 2017-05-26 | 2017-05-31 | 2017-06-15 | 2017-05-03 | 0 | 2017-05-03 | ? | 0 | 0005432412 | 20170503.ifs | 2017-05-03 | 2017-05-04 | |||||||
2484213 | 2484213 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .34 | 00 | 2017-02-24 | 2017-02-28 | 2017-03-15 | 2017-02-02 | 0 | 2017-02-02 | ? | 0 | 0005385509 | 20170202.ifs | 2017-02-02 | 2017-02-03 | |||||||
2441060 | 2441060 | EQUITY | CHANGE | 518439104 | CL A | 0 | 0 | 1995-11-17 | ? | 1 | yes | yes | no | 2002-10-31 | 2006-01-09 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2441061 | 2441060 | EQUITY | CHANGE | 518439104 | CL A | 0 | 0 | 1995-11-17 | ? | 4 | yes | yes | no | 2002-10-31 | 2006-01-09 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2337600 | 2337600 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .34 | 00 | 2016-11-28 | 2016-11-30 | 2016-12-15 | 2016-11-02 | 0 | 2016-11-02 | ? | 0 | 0005308737 | 20161102.ifs | 2016-11-02 | 2016-11-03 | |||||||
2273475 | 2273475 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .3 | 00 | 2016-08-29 | 2016-08-31 | 2016-09-15 | 2016-08-19 | 0 | 2016-08-19 | ? | 0 | 0005266740 | 20160819.ifs | 2016-08-19 | 2016-08-20 | |||||||
2189994 | 2189994 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .3 | 00 | 2016-05-26 | 2016-05-31 | 2016-06-15 | 2016-05-03 | 0 | 2016-05-03 | ? | 0 | 0005215614 | 20160503.ifs | 2016-05-03 | 2016-05-04 | |||||||
2110164 | 2110164 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .3 | 00 | 2016-02-25 | 2016-02-29 | 2016-03-15 | 2016-02-05 | 0 | 2016-02-05 | ? | 0 | 0005170921 | 20160205.ifs | 2016-02-05 | 2016-02-06 | |||||||
1942194 | 1942194 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .24 | 00 | 2015-08-27 | 2015-08-31 | 2015-09-15 | 2015-08-17 | 0 | 2015-08-17 | ? | 0 | 0005047508 | 20150817.ifs | 2015-08-17 | 2015-08-18 | |||||||
1787202 | 1787202 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .24 | 00 | 2015-02-25 | 2015-02-27 | 2015-03-16 | 2015-02-05 | 0 | 2015-02-05 | ? | 0 | 0004952982 | 20150205.ifs | 2015-02-05 | 2015-02-06 | |||||||
1674882 | 1674882 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .24 | 00 | 2014-11-25 | 2014-11-28 | 2014-12-15 | 2014-11-04 | 0 | 2014-11-04 | ? | 0 | 0004870224 | 20141104.ifs | 2014-11-04 | 2014-11-05 | |||||||
1607779 | 1607779 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .2 | 00 | 2014-08-27 | 2014-08-29 | 2014-09-15 | 2014-08-15 | 0 | 2014-08-15 | ? | 0 | 0004829091 | 20140815.ifs | 2014-08-15 | 2014-08-16 | |||||||
1516458 | 1516458 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .2 | 00 | 2014-05-28 | 2014-05-30 | 2014-06-16 | 2014-05-02 | 0 | 2014-05-02 | ? | 0 | 0004779412 | 20140502.ifs | 2014-05-02 | 2014-05-03 | |||||||
1439569 | 1439569 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .2 | 00 | 2014-02-26 | 2014-02-28 | 2014-03-17 | 2014-02-05 | 0 | 2014-02-05 | ? | 0 | 0004734633 | 20140205.ifs | 2014-02-05 | 2014-02-06 | |||||||
1327796 | 1327796 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .2 | 00 | 2013-11-26 | 2013-11-29 | 2013-12-16 | 2013-10-31 | 0 | 2013-10-31 | ? | 0 | 0004649197 | 20131031.ifs | 2013-10-31 | 2013-11-01 | |||||||
1265568 | 1265568 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .18 | 00 | 2013-08-28 | 2013-08-30 | 2013-09-16 | 2013-08-15 | 0 | 2013-08-15 | ? | 0 | 0004615572 | 20130815.ifs | 2013-08-15 | 2013-08-16 | |||||||
1178920 | 1178920 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .18 | 00 | 2013-05-29 | 2013-05-31 | 2013-06-17 | 2013-05-02 | 0 | 2013-05-02 | ? | 0 | 0004568497 | 20130502.ifs | 2013-05-02 | 2013-05-03 | |||||||
1108376 | 1108376 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .18 | 00 | 2013-02-26 | 2013-02-28 | 2013-03-15 | 2013-02-05 | 0 | 2013-02-05 | ? | 0 | 0004526140 | 20130205.ifs | 2013-02-05 | 2013-02-06 | |||||||
1003153 | 1003153 | DIVIDEND | DELETE | 518439104 | 0 | 0 | 1 | 1 | .72 | 06 | 2013-11-26 | 2013-11-30 | 2012-12-17 | 2012-11-01 | 0 | 2012-11-01 | ? | 0 | 0004451669 | 20121102.ifs | 2012-11-02 | 2012-11-03 | |||||||
1003154 | 1003154 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 1 | .72 | 0 | 06 | 2012-11-26 | 2012-11-30 | 2012-12-17 | 2012-11-01 | 0 | ? | 2012-11-02 | 0 | 0004451669 | 20121102.ifs | 2012-11-02 | 2012-11-03 | ||||||
1004035 | 1004035 | DIVIDEND | DELETE | 518439104 | 0 | 0 | 1 | 1 | .72 | 0 | 06 | 2012-11-26 | 2012-11-30 | 2012-12-17 | 2012-11-01 | 0 | ? | 2012-11-02 | 0 | 0004451669 | 20121102.ifs | 2012-11-02 | 2012-11-03 | ||||||
1004036 | 1004036 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 1 | .72 | 0 | 06 | 2012-11-28 | 2012-11-30 | 2012-12-17 | 2012-11-01 | 0 | ? | 2012-11-02 | 0 | 0004451669 | 20121102.ifs | 2012-11-02 | 2012-11-03 | ||||||
1001521 | 1001521 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 1 | .72 | 06 | 2013-11-26 | 2013-11-30 | 2012-12-17 | 2012-11-01 | 0 | 2012-11-01 | ? | 0 | 0004451669 | 20121101.ifs | 2012-11-01 | 2012-11-02 | |||||||
689884 | 689884 | DIVIDEND | ADD | 518439104 | 0 | 0 | 5 | 0 | 1 | 10 | 2012-01-23 | 2012-01-04 | 2012-01-20 | 2011-11-03 | 0 | 2011-11-03 | ? | 1 | 0004267995 | 20111103.ifs | 2011-11-03 | 2011-11-04 | |||||||
689885 | 689885 | SPLIT | ADD | 518439104 | .5 | 2012-01-23 | 10 | 2011-11-03 | ? | 20111103.ifs | 2011-11-03 | 2011-11-04 | |||||||||||||||||
689886 | 689886 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | 1.05 | 00 | 2011-11-23 | 2011-11-28 | 2011-12-14 | 2011-11-03 | 0 | 2011-11-03 | ? | 0 | 0004267994 | 20111103.ifs | 2011-11-03 | 2011-11-04 | |||||||
352502 | 352502 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .75 | 00 | 2010-11-24 | 2010-11-29 | 2010-12-15 | 2010-11-09 | 0 | 2010-11-09 | ? | 0 | 0004086093 | 20101109.ifs | 2010-11-09 | 2010-11-10 | |||||||
23263 | 23263 | DIVIDEND | ADD | 518439104 | 0 | 0 | 1 | 0 | .55 | 00 | 2009-11-25 | 2009-11-30 | 2009-12-16 | 2009-11-13 | 0 | 2009-11-13 | ? | 0 | 0003908101 | 20091113.ifs | 2009-11-13 | 2010-04-07 |
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 = 130528
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