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:159598 |
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 | ||
2561631 | 2561631 | CORPACTION | ADD | 517942702 | 01 | C | 2017-05-04 | ? | 20170504.ifs | 2017-05-04 | 2017-05-05 | ||||||||||||||||||
2561632 | 2561632 | EQUITY | CHANGE | 517942702 | PFD SHS BEN INT SER H 7.50% | 0 | 1 | 2011-01-31 | ? | 4 | no | no | no | 2011-01-31 | ? | ? | 20170504.ifs | 2017-05-04 | 2017-05-05 | ||||||||||
2561633 | 2561632 | EQUITY | CHANGE | 517942702 | PFD SHS BEN INT SER H 7.50% | C | 1 | 2011-01-31 | 2017-05-04 | 4 | no | no | no | 2011-01-31 | 2017-05-04 | ? | 20170504.ifs | 2017-05-04 | 2017-05-05 | ||||||||||
2534720 | 2534720 | DIVIDEND | ADD | 517942702 | 0 | 0 | C | 0 | 25 | 12 | ? | ? | 2017-05-04 | 2017-05-04 | 0 | ? | 2017-04-04 | 0 | 20170404.ifs | 2017-04-04 | 2017-04-05 | ||||||||
2534725 | 2534725 | DIVIDEND | DELETE | 517942702 | 0 | 0 | C | 0 | 25 | 12 | ? | ? | 2017-05-04 | 2017-05-04 | 0 | ? | 2017-04-04 | 0 | 20170404.ifs | 2017-04-04 | 2017-04-05 | ||||||||
2534726 | 2534726 | DIVIDEND | ADD | 517942702 | 0 | 0 | C | 0 | 25 | 0 | 12 | ? | ? | 2017-05-04 | 2017-04-03 | 0 | ? | 2017-04-04 | 0 | 20170404.ifs | 2017-04-04 | 2017-04-05 | |||||||
2532917 | 2532917 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 6 | 0 | 08 | ? | ? | 2017-05-04 | 2017-04-03 | 0 | 2017-04-03 | ? | 0 | 0005416591 | 20170403.ifs | 2017-04-03 | 2017-04-04 | |||||||
2512919 | 2512919 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2017-03-29 | 2017-03-31 | 2017-04-17 | 2017-03-15 | 0 | 2017-03-15 | ? | 0 | 0005402544 | 20170315.ifs | 2017-03-15 | 2017-03-16 | |||||||
2441052 | 2441052 | EQUITY | CHANGE | 517942702 | PFD SHS BEN INT SER H 7.50% | 0 | 1 | 2011-01-31 | ? | 0 | no | no | no | 2011-01-31 | ? | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2441053 | 2441052 | EQUITY | CHANGE | 517942702 | PFD SHS BEN INT SER H 7.50% | 0 | 1 | 2011-01-31 | ? | 4 | no | no | no | 2011-01-31 | ? | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2377075 | 2377075 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2016-12-28 | 2016-12-30 | 2017-01-17 | 2016-12-15 | 0 | 2016-12-15 | ? | 0 | 0005334327 | 20161215.ifs | 2016-12-15 | 2016-12-16 | |||||||
2294502 | 2294502 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2016-09-28 | 2016-09-30 | 2016-10-17 | 2016-09-15 | 0 | 2016-09-15 | ? | 0 | 0005280186 | 20160915.ifs | 2016-09-15 | 2016-09-16 | |||||||
2228936 | 2228936 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2016-06-29 | 2016-07-01 | 2016-07-15 | 2016-06-15 | 0 | 2016-06-23 | ? | 0 | 0005237336 | 20160623.ifs | 2016-06-23 | 2016-06-24 | |||||||
2137432 | 2137432 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2016-03-30 | 2016-04-01 | 2016-04-15 | 2016-03-14 | 0 | 2016-03-17 | ? | 0 | 0005187776 | 20160317.ifs | 2016-03-17 | 2016-03-18 | |||||||
2040673 | 2040673 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2015-12-29 | 2016-01-01 | 2016-01-15 | 2015-12-15 | 0 | 2015-12-15 | ? | 0 | 0005116551 | 20151215.ifs | 2015-12-15 | 2015-12-16 | |||||||
1966790 | 1966790 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2015-09-29 | 2015-10-01 | 2015-10-15 | 2015-09-15 | 0 | 2015-09-16 | ? | 0 | 0005062687 | 20150916.ifs | 2015-09-16 | 2015-09-17 | |||||||
1888208 | 1888208 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2015-06-29 | 2015-07-01 | 2015-07-15 | 2015-06-15 | 0 | 2015-06-17 | ? | 0 | 0005014420 | 20150617.ifs | 2015-06-17 | 2015-06-18 | |||||||
1813352 | 1813352 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2015-03-30 | 2015-04-01 | 2015-04-15 | 2015-03-13 | 0 | 2015-03-16 | ? | 0 | 0004968870 | 20150316.ifs | 2015-03-16 | 2015-03-17 | |||||||
1727833 | 1727833 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2014-12-29 | 2015-01-01 | 2015-01-15 | 2014-12-16 | 0 | 2014-12-18 | ? | 0 | 0004906943 | 20141218.ifs | 2014-12-18 | 2014-12-19 | |||||||
1633273 | 1633273 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2014-09-29 | 2014-10-01 | 2014-10-15 | 2014-09-18 | 0 | 2014-09-18 | ? | 0 | 0004844181 | 20140918.ifs | 2014-09-18 | 2014-09-19 | |||||||
1558887 | 1558887 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2014-06-27 | 2014-07-01 | 2014-07-15 | 2014-06-24 | 0 | 2014-06-24 | ? | 0 | 0004800924 | 20140624.ifs | 2014-06-24 | 2014-06-25 | |||||||
1468113 | 1468113 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2014-03-28 | 2014-04-01 | 2014-04-15 | 2014-03-14 | 0 | 2014-03-17 | ? | 0 | 0004751011 | 20140317.ifs | 2014-03-17 | 2014-03-18 | |||||||
1374548 | 1374548 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2013-12-27 | 2014-01-01 | 2014-01-15 | 2013-12-16 | 0 | 2013-12-16 | ? | 0 | 0004685143 | 20131216.ifs | 2013-12-16 | 2013-12-17 | |||||||
1290088 | 1290088 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2013-09-27 | 2013-10-01 | 2013-10-15 | 2013-09-16 | 0 | 2013-09-18 | ? | 0 | 0004630239 | 20130918.ifs | 2013-09-18 | 2013-09-19 | |||||||
1211021 | 1211021 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2013-06-27 | 2013-07-01 | 2013-07-15 | 2013-06-14 | 0 | 2013-06-17 | ? | 0 | 0004584524 | 20130617.ifs | 2013-06-17 | 2013-06-18 | |||||||
1135513 | 1135513 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2013-03-27 | 2013-04-01 | 2013-04-15 | 2013-03-15 | 0 | 2013-03-18 | ? | 0 | 0004542608 | 20130318.ifs | 2013-03-18 | 2013-03-19 | |||||||
1044572 | 1044572 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2012-12-27 | 2013-01-01 | 2013-01-15 | 2012-12-17 | 0 | 2012-12-17 | ? | 0 | 0004483608 | 20121217.ifs | 2012-12-17 | 2012-12-18 | |||||||
958452 | 958452 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2012-09-27 | 2012-10-01 | 2012-10-15 | 2012-09-17 | 0 | 2012-09-18 | ? | 0 | 0004430513 | 20120918.ifs | 2012-09-18 | 2012-09-19 | |||||||
886441 | 886441 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2012-06-27 | 2012-07-01 | 2012-07-13 | 2012-06-15 | 0 | 2012-06-15 | ? | 0 | 0004387109 | 20120615.ifs | 2012-06-15 | 2012-06-16 | |||||||
803167 | 803167 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2012-03-28 | 2012-04-01 | 2012-04-13 | 2012-03-15 | 0 | 2012-03-15 | ? | 0 | 0004346121 | 20120315.ifs | 2012-03-15 | 2012-03-16 | |||||||
732817 | 732817 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2011-12-28 | 2012-01-01 | 2012-01-13 | 2011-12-15 | 0 | 2011-12-20 | ? | 0 | 0004296386 | 20111220.ifs | 2011-12-20 | 2011-12-21 | |||||||
645621 | 645621 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2011-09-28 | 2011-10-01 | 2011-10-14 | 2011-09-15 | 0 | 2011-09-16 | ? | 0 | 0004243562 | 20110916.ifs | 2011-09-16 | 2011-09-17 | |||||||
562001 | 562001 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 0 | .46875 | 00 | 2011-06-29 | 2011-07-01 | 2011-07-15 | 2011-06-15 | 0 | 2011-06-16 | ? | 0 | 0004201989 | 20110616.ifs | 2011-06-16 | 2011-06-17 | |||||||
472045 | 472045 | DIVIDEND | ADD | 517942702 | 0 | 0 | 1 | 4 | .421875 | 00 | 2011-03-30 | 2011-04-01 | 2011-04-15 | 2011-03-15 | 0 | 2011-03-15 | ? | 0 | 0004159571 | 20110315.ifs | 2011-03-15 | 2011-03-16 | |||||||
428183 | 428183 | EQUITY | ADD | 517942702 | PFD SHS BEN INT SER H 7.50% | N | 1 | 2011-01-31 | ? | 0 | no | no | no | 2011-01-31 | ? | ? | 20110131.ifs | 2011-01-31 | 2011-02-01 | ||||||||||
428184 | 428184 | EXCHANGE | ADD | 517942702 | 01 | 2011-01-31 | 2011-01-31 | LHO_PH | 0 | 1 | 2011-01-31 | ? | 20110131.ifs | 2011-01-31 | 2011-02-01 | ||||||||||||||
428361 | 428361 | EQUITY | CHANGE | 517942702 | PFD SHS BEN INT SER H 7.50% | N | 1 | 2011-01-31 | ? | 0 | no | no | no | 2011-01-31 | ? | ? | 20110131.ifs | 2011-01-31 | 2011-02-01 | ||||||||||
428362 | 428361 | EQUITY | CHANGE | 517942702 | PFD SHS BEN INT SER H 7.50% | 0 | 1 | 2011-01-31 | ? | 0 | no | no | no | 2011-01-31 | ? | ? | 20110131.ifs | 2011-01-31 | 2011-02-01 |
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 = 159598
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