INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
||||||||||
Total Insititutions : | N/A | 0 | Update Insititution By Cusips | |||||||||||
% Owned by Insititutions: | N/A % | 0 % | ||||||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | ||||||||||||
|
||||||||||||||
the compid is:142343 |
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 | ||
4934049 | 4934049 | CORPACTION | ADD | Y8564M105 | 01 | A | 2022-01-13 | ? | 20220113.ifs | 2022-01-13 | 2022-01-14 | ||||||||||||||||||
4934050 | 4934050 | EQUITY | CHANGE | Y8564M105 | PRTSHP UNITS | 0 | 0 | 2005-05-05 | ? | 4 | no | no | no | 2005-05-06 | 2005-05-05 | ? | 20220113.ifs | 2022-01-13 | 2022-01-14 | ||||||||||
4934051 | 4934050 | EQUITY | CHANGE | Y8564M105 | PRTSHP UNITS | A | 0 | 2005-05-05 | 2022-01-13 | 4 | no | no | no | 2005-05-06 | 2022-01-13 | ? | 20220113.ifs | 2022-01-13 | 2022-01-14 | ||||||||||
4827203 | 4827203 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .2875 | 00 | 2021-11-04 | 2021-11-05 | 2021-11-12 | 2021-10-15 | 0 | 2021-10-15 | ? | 0 | 0006383945 | 20211015.ifs | 2021-10-15 | 2021-10-16 | |||||||
4759944 | 4759944 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .2875 | 00 | 2021-08-04 | 2021-08-05 | 2021-08-13 | 2021-07-16 | 0 | 2021-07-16 | ? | 0 | 0006340589 | 20210716.ifs | 2021-07-16 | 2021-07-17 | |||||||
4681675 | 4681675 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .2875 | 00 | 2021-05-04 | 2021-05-05 | 2021-05-14 | 2021-04-15 | 0 | 2021-04-15 | ? | 0 | 0006294757 | 20210415.ifs | 2021-04-15 | 2021-04-16 | |||||||
4608443 | 4608443 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .25 | 00 | 2021-02-01 | 2021-02-02 | 2021-02-12 | 2021-01-20 | 0 | 2021-01-20 | ? | 0 | 0006252637 | 20210120.ifs | 2021-01-20 | 2021-01-21 | |||||||
4487753 | 4487753 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .25 | 00 | 2020-10-30 | 2020-11-02 | 2020-11-13 | 2020-10-19 | 0 | 2020-10-19 | ? | 0 | 0006175947 | 20201019.ifs | 2020-10-19 | 2020-10-20 | |||||||
4420774 | 4420774 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .25 | 00 | 2020-07-30 | 2020-07-31 | 2020-08-14 | 2020-07-17 | 0 | 2020-07-17 | ? | 0 | 0006131343 | 20200717.ifs | 2020-07-17 | 2020-07-18 | |||||||
4289732 | 4289732 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .25 | 00 | 2020-04-30 | 2020-05-01 | 2020-05-15 | 2020-04-16 | 0 | 2020-04-16 | ? | 0 | 0006085675 | 20200416.ifs | 2020-04-16 | 2020-04-17 | |||||||
4290066 | 4290066 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .25 | 00 | 2020-04-30 | 2020-05-01 | 2020-05-15 | 2020-04-16 | 0 | 2020-04-16 | ? | 0 | 0006085675 | 20200416.ifs | 2020-04-16 | 2020-04-17 | |||||||
4173270 | 4173270 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .19 | 00 | 2020-01-30 | 2020-01-31 | 2020-02-14 | 2020-01-20 | 0 | 2020-01-21 | ? | 0 | 0006043774 | 20200121.ifs | 2020-01-21 | 2020-01-22 | |||||||
4173280 | 4173280 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .19 | 00 | 2020-01-30 | 2020-01-31 | 2020-02-14 | 2020-01-20 | 0 | 2020-01-21 | ? | 0 | 0006043774 | 20200121.ifs | 2020-01-21 | 2020-01-22 | |||||||
3978703 | 3978703 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .19 | 00 | 2019-10-31 | 2019-11-01 | 2019-11-14 | 2019-10-21 | 0 | 2019-10-21 | ? | 0 | 0005963653 | 20191021.ifs | 2019-10-21 | 2019-10-22 | |||||||
3978792 | 3978792 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .19 | 00 | 2019-10-31 | 2019-11-01 | 2019-11-14 | 2019-10-21 | 0 | 2019-10-21 | ? | 0 | 0005963653 | 20191021.ifs | 2019-10-21 | 2019-10-22 | |||||||
3844204 | 3844204 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .19 | 00 | 2019-08-05 | 2019-08-06 | 2019-08-14 | 2019-07-19 | 0 | 2019-07-23 | ? | 0 | 0005918729 | 20190723.ifs | 2019-07-23 | 2019-07-24 | |||||||
3844205 | 3844205 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .19 | 00 | 2019-08-05 | 2019-08-06 | 2019-08-14 | 2019-07-19 | 0 | 2019-07-23 | ? | 0 | 0005918729 | 20190723.ifs | 2019-07-23 | 2019-07-24 | |||||||
3692504 | 3692504 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .19 | 00 | 2019-05-06 | 2019-05-07 | 2019-05-15 | 2019-04-24 | 0 | 2019-04-24 | ? | 0 | 0005872590 | 20190424.ifs | 2019-04-24 | 2019-04-25 | |||||||
3692514 | 3692514 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .19 | 00 | 2019-05-06 | 2019-05-07 | 2019-05-15 | 2019-04-24 | 0 | 2019-04-24 | ? | 0 | 0005872590 | 20190424.ifs | 2019-04-24 | 2019-04-25 | |||||||
3544350 | 3544350 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .14 | 00 | 2019-01-31 | 2019-02-01 | 2019-02-08 | 2019-01-08 | 0 | 2019-01-08 | ? | 0 | 0005825173 | 20190108.ifs | 2019-01-08 | 2019-01-09 | |||||||
3544361 | 3544361 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .14 | 00 | 2019-01-31 | 2019-02-01 | 2019-02-08 | 2019-01-08 | 0 | 2019-01-08 | ? | 0 | 0005825173 | 20190108.ifs | 2019-01-08 | 2019-01-09 | |||||||
3320469 | 3320469 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .14 | 00 | 2018-11-01 | 2018-11-02 | 2018-11-09 | 2018-10-03 | 0 | 2018-10-03 | ? | 0 | 0005738980 | 20181003.ifs | 2018-10-03 | 2018-10-04 | |||||||
3320476 | 3320476 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .14 | 00 | 2018-11-01 | 2018-11-02 | 2018-11-09 | 2018-10-03 | 0 | 2018-10-03 | ? | 0 | 0005738980 | 20181003.ifs | 2018-10-03 | 2018-10-04 | |||||||
3183462 | 3183462 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .14 | 00 | 2018-08-02 | 2018-08-03 | 2018-08-10 | 2018-07-05 | 0 | 2018-07-05 | ? | 0 | 0005691832 | 20180705.ifs | 2018-07-05 | 2018-07-06 | |||||||
3184247 | 3184247 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .14 | 00 | 2018-08-02 | 2018-08-03 | 2018-08-10 | 2018-07-05 | 0 | 2018-07-05 | ? | 0 | 0005691832 | 20180705.ifs | 2018-07-05 | 2018-07-06 | |||||||
3028591 | 3028591 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .14 | 00 | 2018-05-03 | 2018-05-04 | 2018-05-11 | 2018-04-04 | 0 | 2018-04-04 | ? | 0 | 0005645363 | 20180404.ifs | 2018-04-04 | 2018-04-05 | |||||||
3028727 | 3028727 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .14 | 00 | 2018-05-03 | 2018-05-04 | 2018-05-11 | 2018-04-04 | 0 | 2018-04-04 | ? | 0 | 0005645363 | 20180404.ifs | 2018-04-04 | 2018-04-05 | |||||||
2911599 | 2911599 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .14 | 00 | 2018-02-01 | 2018-02-02 | 2018-02-09 | 2018-01-04 | 0 | 2018-01-04 | ? | 0 | 0005600631 | 20180104.ifs | 2018-01-04 | 2018-01-05 | |||||||
2911600 | 2911600 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .14 | 00 | 2018-02-01 | 2018-02-02 | 2018-02-09 | 2018-01-04 | 0 | 2018-01-04 | ? | 0 | 0005600631 | 20180104.ifs | 2018-01-04 | 2018-01-05 | |||||||
2712499 | 2712499 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .14 | 00 | 2017-11-02 | 2017-11-03 | 2017-11-10 | 2017-10-03 | 0 | 2017-10-03 | ? | 0 | 0005512542 | 20171003.ifs | 2017-10-03 | 2017-10-04 | |||||||
2712524 | 2712524 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .14 | 00 | 2017-11-02 | 2017-11-03 | 2017-11-10 | 2017-10-03 | 0 | 2017-10-03 | ? | 0 | 0005512542 | 20171003.ifs | 2017-10-03 | 2017-10-04 | |||||||
2617644 | 2617644 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .14 | 00 | 2017-08-02 | 2017-08-04 | 2017-08-11 | 2017-07-07 | 0 | 2017-07-07 | ? | 0 | 0005466793 | 20170707.ifs | 2017-07-07 | 2017-07-08 | |||||||
2530769 | 2530769 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .14 | 00 | 2017-05-03 | 2017-05-05 | 2017-05-12 | 2017-04-03 | 0 | 2017-04-03 | ? | 0 | 0005417101 | 20170403.ifs | 2017-04-03 | 2017-04-04 | |||||||
2448382 | 2448382 | EQUITY | CHANGE | Y8564M105 | PRTSHP UNITS | 0 | 0 | 2005-05-05 | ? | 0 | no | no | no | 2005-05-06 | 2005-05-05 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2448383 | 2448382 | EQUITY | CHANGE | Y8564M105 | PRTSHP UNITS | 0 | 0 | 2005-05-05 | ? | 4 | no | no | no | 2005-05-06 | 2005-05-05 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2414255 | 2414255 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .14 | 00 | 2017-02-01 | 2017-02-03 | 2017-02-10 | 2017-01-03 | 0 | 2017-01-03 | ? | 0 | 0005371792 | 20170103.ifs | 2017-01-03 | 2017-01-04 | |||||||
2311560 | 2311560 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .14 | 00 | 2016-11-02 | 2016-11-04 | 2016-11-10 | 2016-10-03 | 0 | 2016-10-03 | ? | 0 | 0005294549 | 20161003.ifs | 2016-10-03 | 2016-10-04 | |||||||
2240811 | 2240811 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .14 | 00 | 2016-07-27 | 2016-07-29 | 2016-08-12 | 2016-07-01 | 0 | 2016-07-01 | ? | 0 | 0005245239 | 20160701.ifs | 2016-07-01 | 2016-07-02 | |||||||
2152761 | 2152761 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .14 | 00 | 2016-04-27 | 2016-04-29 | 2016-05-13 | 2016-04-01 | 0 | 2016-04-01 | ? | 0 | 0005198353 | 20160401.ifs | 2016-04-01 | 2016-04-02 | |||||||
2095387 | 2095387 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .14 | 00 | 2016-02-03 | 2016-02-05 | 2016-02-12 | 2016-01-20 | 0 | 2016-01-20 | ? | 0 | 0005160911 | 20160120.ifs | 2016-01-20 | 2016-01-21 | |||||||
1984773 | 1984773 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .7 | 00 | 2015-10-08 | 2015-10-13 | 2015-11-13 | 2015-10-02 | 0 | 2015-10-02 | ? | 0 | 0005077104 | 20151002.ifs | 2015-10-02 | 2015-10-03 | |||||||
1912619 | 1912619 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .7 | 00 | 2015-07-10 | 2015-07-14 | 2015-08-14 | 2015-07-02 | 0 | 2015-07-08 | ? | 0 | 0005031713 | 20150708.ifs | 2015-07-08 | 2015-07-09 | |||||||
1834262 | 1834262 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .7 | 00 | 2015-04-09 | 2015-04-13 | 2015-05-15 | 2015-04-02 | 0 | 2015-04-02 | ? | 0 | 0004984320 | 20150402.ifs | 2015-04-02 | 2015-04-03 | |||||||
1759135 | 1759135 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .7 | 00 | 2015-01-13 | 2015-01-15 | 2015-02-13 | 2015-01-02 | 0 | 2015-01-02 | ? | 0 | 0004936854 | 20150102.ifs | 2015-01-02 | 2015-01-03 | |||||||
1653331 | 1653331 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .6918 | 00 | 2014-10-15 | 2014-10-17 | 2014-11-14 | 2014-10-02 | 0 | 2014-10-06 | ? | 0 | 0004858393 | 20141006.ifs | 2014-10-06 | 2014-10-07 | |||||||
1577818 | 1577818 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .6918 | 00 | 2014-07-23 | 2014-07-25 | 2014-08-08 | 2014-07-09 | 0 | 2014-07-10 | ? | 0 | 0004814311 | 20140710.ifs | 2014-07-10 | 2014-07-11 | |||||||
1493760 | 1493760 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .6918 | 00 | 2014-04-23 | 2014-04-25 | 2014-05-09 | 2014-04-09 | 0 | 2014-04-09 | ? | 0 | 0004767542 | 20140409.ifs | 2014-04-09 | 2014-04-10 | |||||||
1422718 | 1422718 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .6918 | 00 | 2014-01-29 | 2014-01-31 | 2014-02-14 | 2014-01-15 | 0 | 2014-01-15 | ? | 0 | 0004724321 | 20140115.ifs | 2014-01-15 | 2014-01-16 | |||||||
1315194 | 1315194 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .675 | 00 | 2013-10-21 | 2013-10-23 | 2013-11-08 | 2013-10-11 | 0 | 2013-10-11 | ? | 0 | 0004645027 | 20131011.ifs | 2013-10-11 | 2013-10-12 | |||||||
1239436 | 1239436 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .675 | 00 | 2013-07-19 | 2013-07-23 | 2013-08-09 | 2013-07-12 | 0 | 2013-07-12 | ? | 0 | 0004601401 | 20130712.ifs | 2013-07-12 | 2013-07-13 | |||||||
1162222 | 1162222 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .675 | 00 | 2013-04-26 | 2013-04-30 | 2013-05-14 | 2013-04-18 | 0 | 2013-04-18 | ? | 0 | 0004558871 | 20130418.ifs | 2013-04-18 | 2013-04-19 | |||||||
1095683 | 1095683 | DIVIDEND | DELETE | Y8564M105 | 0 | 0 | 1 | 0 | .675 | 00 | 2013-01-30 | 2013-02-01 | 2013-02-14 | 2013-01-18 | 0 | 2013-01-18 | ? | 0 | 0004516020 | 20130125.ifs | 2013-01-25 | 2013-01-26 | |||||||
1095684 | 1095684 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .675 | 00 | 2013-01-31 | 2013-02-04 | 2013-02-14 | 2013-01-18 | 1 | 2013-01-18 | 2013-01-25 | 0 | 0004516020 | 20130125.ifs | 2013-01-25 | 2013-01-26 | |||||||
1092461 | 1092461 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .675 | 00 | 2013-01-30 | 2013-02-01 | 2013-02-14 | 2013-01-18 | 0 | 2013-01-18 | ? | 0 | 0004516020 | 20130118.ifs | 2013-01-18 | 2013-01-19 | |||||||
985109 | 985109 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .675 | 00 | 2012-10-22 | 2012-10-24 | 2012-11-09 | 2012-10-12 | 0 | 2012-10-12 | ? | 0 | 0004445158 | 20121012.ifs | 2012-10-12 | 2012-10-13 | |||||||
912683 | 912683 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .675 | 00 | 2012-07-23 | 2012-07-25 | 2012-08-10 | 2012-07-13 | 0 | 2012-07-16 | ? | 0 | 0004402920 | 20120716.ifs | 2012-07-16 | 2012-07-17 | |||||||
834095 | 834095 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .675 | 00 | 2012-04-19 | 2012-04-23 | 2012-05-14 | 2012-04-12 | 0 | 2012-04-12 | ? | 0 | 0004361152 | 20120412.ifs | 2012-04-12 | 2012-04-13 | |||||||
759164 | 759164 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .63 | 00 | 2012-01-30 | 2012-02-01 | 2012-02-14 | 2012-01-19 | 0 | 2012-01-19 | ? | 0 | 0004321697 | 20120119.ifs | 2012-01-19 | 2012-01-20 | |||||||
674394 | 674394 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .63 | 00 | 2011-10-31 | 2011-11-02 | 2011-11-14 | 2011-10-18 | 0 | 2011-10-18 | ? | 0 | 0004257990 | 20111018.ifs | 2011-10-18 | 2011-10-19 | |||||||
591765 | 591765 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .63 | 00 | 2011-08-03 | 2011-08-05 | 2011-08-12 | 2011-07-22 | 0 | 2011-07-22 | ? | 0 | 0004218893 | 20110722.ifs | 2011-07-22 | 2011-07-23 | |||||||
506899 | 506899 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .63 | 00 | 2011-05-04 | 2011-05-06 | 2011-05-13 | 2011-04-21 | 0 | 2011-04-21 | ? | 0 | 0004176992 | 20110421.ifs | 2011-04-21 | 2011-04-22 | |||||||
425921 | 425921 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .63 | 00 | 2011-02-03 | 2011-02-07 | 2011-02-14 | 2011-01-26 | 0 | 2011-01-26 | ? | 0 | 0004137431 | 20110126.ifs | 2011-01-26 | 2011-01-27 | |||||||
340955 | 340955 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .6 | 00 | 2010-11-03 | 2010-11-05 | 2010-11-12 | 2010-10-25 | 0 | 2010-10-25 | ? | 0 | 0004076838 | 20101025.ifs | 2010-10-25 | 2010-10-26 | |||||||
260984 | 260984 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .6 | 00 | 2010-08-04 | 2010-08-06 | 2010-08-13 | 2010-07-28 | 0 | 2010-07-28 | ? | 0 | 0004037709 | 20100728.ifs | 2010-07-28 | 2010-07-29 | |||||||
172140 | 172140 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .6 | 00 | 2010-05-05 | 2010-05-07 | 2010-05-14 | 2010-04-29 | 0 | 2010-04-29 | ? | 0 | 0003997243 | 20100429.ifs | 2010-04-29 | 2010-04-30 | |||||||
95164 | 95164 | DIVIDEND | ADD | Y8564M105 | 0 | 0 | 1 | 0 | .57 | 00 | 2010-02-03 | 2010-02-05 | 2010-02-12 | 2010-01-27 | 0 | 2010-01-27 | ? | 0 | 0003956465 | 20100127.ifs | 2010-01-27 | 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 = 142343
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