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:159603 |
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 | ||
2325753 | 2325753 | DIVIDEND | CHANGE | 70509V308 | 0 | 0 | 1 | 6 | 0 | 08 | ? | ? | 2016-09-21 | 2016-08-12 | 0 | 2016-08-12 | ? | 0 | 0005265399 | 20161025.ifs | 2016-10-25 | 2016-10-26 | |||||||
2325754 | 2325753 | DIVIDEND | CHANGE | 70509V308 | 0 | 0 | 1 | 0 | .37778 | 0 | 08 | ? | ? | 2016-09-21 | 2016-08-12 | 0 | 2016-08-12 | 2016-10-25 | 0 | 0005265399 | 20161025.ifs | 2016-10-25 | 2016-10-26 | ||||||
2326045 | 2326045 | DIVIDEND | DELETE | 70509V308 | 0 | 0 | 1 | 0 | .37778 | 0 | 08 | ? | ? | 2016-09-21 | 2016-08-12 | 0 | 2016-08-12 | 2016-10-25 | 0 | 0005265399 | 20161025.ifs | 2016-10-25 | 2016-10-26 | ||||||
2326046 | 2326046 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 0 | .37778 | 0 | 00 | ? | ? | 2016-09-21 | 2016-08-12 | 1 | 2016-08-12 | 2016-10-25 | 0 | 0005265399 | 20161025.ifs | 2016-10-25 | 2016-10-26 | ||||||
2298694 | 2298694 | CORPACTION | ADD | 70509V308 | 01 | C | 2016-09-21 | ? | 20160921.ifs | 2016-09-21 | 2016-09-22 | ||||||||||||||||||
2298695 | 2298695 | EQUITY | CHANGE | 70509V308 | PFD SER B 8% | 0 | 1 | 2011-09-16 | ? | 0 | no | no | no | 2011-09-16 | 2011-09-23 | ? | 20160921.ifs | 2016-09-21 | 2016-09-22 | ||||||||||
2298696 | 2298695 | EQUITY | CHANGE | 70509V308 | PFD SER B 8% | C | 1 | 2011-09-16 | 2016-09-21 | 0 | no | no | no | 2011-09-16 | 2016-09-21 | ? | 20160921.ifs | 2016-09-21 | 2016-09-22 | ||||||||||
2270512 | 2270512 | DIVIDEND | ADD | 70509V308 | 0 | 0 | C | 0 | 25 | 12 | ? | ? | 2016-09-21 | 2016-08-12 | 0 | ? | 2016-08-15 | 0 | 20160815.ifs | 2016-08-15 | 2016-08-16 | ||||||||
2270244 | 2270244 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 6 | 0 | 08 | ? | ? | 2016-09-21 | 2016-08-12 | 0 | 2016-08-12 | ? | 0 | 0005265399 | 20160812.ifs | 2016-08-12 | 2016-08-13 | |||||||
2221098 | 2221098 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 0 | .5 | 00 | 2016-06-28 | 2016-06-30 | 2016-07-15 | 2016-06-15 | 0 | 2016-06-15 | ? | 0 | 0005232297 | 20160615.ifs | 2016-06-15 | 2016-06-16 | |||||||
2135376 | 2135376 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 0 | .5 | 00 | 2016-03-29 | 2016-03-31 | 2016-04-15 | 2016-03-15 | 0 | 2016-03-15 | ? | 0 | 0005186724 | 20160315.ifs | 2016-03-15 | 2016-03-16 | |||||||
2039591 | 2039591 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 0 | .5 | 00 | 2015-12-29 | 2015-12-31 | 2016-01-15 | 2015-12-15 | 0 | 2015-12-15 | ? | 0 | 0005116496 | 20151215.ifs | 2015-12-15 | 2015-12-16 | |||||||
1965913 | 1965913 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 0 | .5 | 00 | 2015-09-28 | 2015-09-30 | 2015-10-15 | 2015-09-09 | 0 | 2015-09-15 | ? | 0 | 0005062214 | 20150915.ifs | 2015-09-15 | 2015-09-16 | |||||||
1884135 | 1884135 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 0 | .5 | 00 | 2015-06-26 | 2015-06-30 | 2015-07-15 | 2015-06-10 | 0 | 2015-06-10 | ? | 0 | 0005012707 | 20150610.ifs | 2015-06-10 | 2015-06-11 | |||||||
1813170 | 1813170 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 0 | .5 | 00 | 2015-03-27 | 2015-03-31 | 2015-04-15 | 2015-03-16 | 0 | 2015-03-16 | ? | 0 | 0004968662 | 20150316.ifs | 2015-03-16 | 2015-03-17 | |||||||
1715884 | 1715884 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 0 | .5 | 00 | 2014-12-29 | 2014-12-31 | 2015-01-15 | 2014-12-15 | 0 | 2014-12-15 | ? | 0 | 0004897218 | 20141215.ifs | 2014-12-15 | 2014-12-16 | |||||||
1630236 | 1630236 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 0 | .5 | 00 | 2014-09-26 | 2014-09-30 | 2014-10-15 | 2014-09-15 | 0 | 2014-09-15 | ? | 0 | 0004842809 | 20140915.ifs | 2014-09-15 | 2014-09-16 | |||||||
1550306 | 1550306 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 0 | .5 | 00 | 2014-06-26 | 2014-06-30 | 2014-07-15 | 2014-06-16 | 0 | 2014-06-16 | ? | 0 | 0004796443 | 20140616.ifs | 2014-06-16 | 2014-06-17 | |||||||
1466683 | 1466683 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 0 | .5 | 00 | 2014-03-27 | 2014-03-31 | 2014-04-15 | 2014-03-14 | 0 | 2014-03-14 | ? | 0 | 0004750280 | 20140314.ifs | 2014-03-14 | 2014-03-15 | |||||||
1369251 | 1369251 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 0 | .5 | 00 | 2013-12-27 | 2013-12-31 | 2014-01-15 | 2013-12-13 | 0 | 2013-12-13 | ? | 0 | 0004680430 | 20131213.ifs | 2013-12-13 | 2013-12-14 | |||||||
1287165 | 1287165 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 0 | .5 | 00 | 2013-09-26 | 2013-09-30 | 2013-10-15 | 2013-09-13 | 0 | 2013-09-13 | ? | 0 | 0004628607 | 20130913.ifs | 2013-09-13 | 2013-09-14 | |||||||
1209925 | 1209925 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 0 | .5 | 00 | 2013-06-27 | 2013-07-01 | 2013-07-15 | 2013-06-14 | 0 | 2013-06-14 | ? | 0 | 0004583966 | 20130614.ifs | 2013-06-14 | 2013-06-15 | |||||||
1134045 | 1134045 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 0 | .5 | 00 | 2013-03-27 | 2013-04-01 | 2013-04-15 | 2013-03-15 | 0 | 2013-03-15 | ? | 0 | 0004541512 | 20130315.ifs | 2013-03-15 | 2013-03-16 | |||||||
1041273 | 1041273 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 0 | .5 | 00 | 2012-12-27 | 2012-12-31 | 2013-01-15 | 2012-12-14 | 0 | 2012-12-14 | ? | 0 | 0004479152 | 20121214.ifs | 2012-12-14 | 2012-12-15 | |||||||
956710 | 956710 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 0 | .5 | 00 | 2012-09-26 | 2012-09-28 | 2012-10-15 | 2012-09-14 | 0 | 2012-09-14 | ? | 0 | 0004429284 | 20120914.ifs | 2012-09-14 | 2012-09-15 | |||||||
886256 | 886256 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 0 | .5 | 00 | 2012-06-27 | 2012-06-29 | 2012-07-16 | 2012-06-15 | 0 | 2012-06-15 | ? | 0 | 0004386538 | 20120615.ifs | 2012-06-15 | 2012-06-16 | |||||||
803088 | 803088 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 0 | .5 | 00 | 2012-03-28 | 2012-03-30 | 2012-04-16 | 2012-03-15 | 0 | 2012-03-15 | ? | 0 | 0004346093 | 20120315.ifs | 2012-03-15 | 2012-03-16 | |||||||
723814 | 723814 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 0 | .5 | 00 | 2011-12-28 | 2011-12-31 | 2012-01-16 | 2011-12-15 | 0 | 2011-12-15 | ? | 0 | 0004288216 | 20111215.ifs | 2011-12-15 | 2011-12-16 | |||||||
651456 | 651456 | CORPACTION | ADD | 70509V308 | 66 | X | 2011-09-23 | 70509V308 | 01 | ? | 20110923.ifs | 2011-09-23 | 2011-09-24 | ||||||||||||||||
651457 | 651457 | EXCHANGE | ADD | 70509V308 | 01 | 2011-09-23 | 2011-09-23 | PEB_PB | 0 | 1 | 2011-09-23 | ? | 20110923.ifs | 2011-09-23 | 2011-09-24 | ||||||||||||||
651566 | 651566 | EXCHANGE | DELETE | 70509V308 | 01 | 2011-09-22 | 2011-09-23 | PEB_PB | 0 | 1 | ? | 2011-09-22 | 20110923.ifs | 2011-09-23 | 2011-09-24 | ||||||||||||||
651567 | 651567 | CORPACTION | DELETE | 70509V308 | 66 | X | 2011-09-22 | 70509V308 | 01 | 2011-09-22 | 20110923.ifs | 2011-09-23 | 2011-09-24 | ||||||||||||||||
651568 | 651568 | EXCHANGE | CHANGE | 70509V308 | 66 | 2011-09-16 | 2011-09-21 | PEBHP | 0 | 1 | 2011-09-16 | ? | 20110923.ifs | 2011-09-23 | 2011-09-24 | ||||||||||||||
651569 | 651568 | EXCHANGE | CHANGE | 70509V308 | 66 | 2011-09-16 | 2011-09-22 | PEBHP | 0 | 1 | 2011-09-16 | 2011-09-23 | 20110923.ifs | 2011-09-23 | 2011-09-24 | ||||||||||||||
651570 | 651570 | EQUITY | CHANGE | 70509V308 | PFD SER B 8% | N | 1 | 2011-09-16 | ? | 0 | no | no | no | 2011-09-16 | 2011-09-19 | ? | 20110923.ifs | 2011-09-23 | 2011-09-24 | ||||||||||
651571 | 651570 | EQUITY | CHANGE | 70509V308 | PFD SER B 8% | 0 | 1 | 2011-09-16 | ? | 0 | no | no | no | 2011-09-16 | 2011-09-23 | ? | 20110923.ifs | 2011-09-23 | 2011-09-24 | ||||||||||
651876 | 651876 | DIVIDEND | ADD | 70509V308 | 0 | 0 | 1 | 4 | .13333 | 00 | 2011-09-28 | 2011-09-30 | 2011-10-17 | 2011-09-22 | 0 | 2011-09-23 | ? | 0 | 0004245835 | 20110923.ifs | 2011-09-23 | 2011-09-24 | |||||||
650311 | 650311 | EXCHANGE | ADD | 70509V308 | 01 | 2011-09-22 | ? | PEB_PB | 0 | 1 | ? | 2011-09-22 | 20110922.ifs | 2011-09-22 | 2011-09-23 | ||||||||||||||
650312 | 650312 | CORPACTION | ADD | 70509V308 | 66 | X | 2011-09-22 | 70509V308 | 01 | 2011-09-22 | 20110922.ifs | 2011-09-22 | 2011-09-23 | ||||||||||||||||
646151 | 646151 | EQUITY | CHANGE | 70509V308 | PFD SER B | N | 1 | 2011-09-16 | ? | 0 | no | no | no | 2011-09-16 | ? | ? | 20110919.ifs | 2011-09-19 | 2011-09-20 | ||||||||||
646152 | 646151 | EQUITY | CHANGE | 70509V308 | PFD SER B 8% | N | 1 | 2011-09-16 | ? | 0 | no | no | no | 2011-09-16 | 2011-09-19 | ? | 20110919.ifs | 2011-09-19 | 2011-09-20 | ||||||||||
645110 | 645110 | EQUITY | ADD | 70509V308 | PFD SER B | N | 1 | 2011-09-16 | ? | 0 | no | no | no | 2011-09-16 | ? | ? | 20110916.ifs | 2011-09-16 | 2011-09-17 | ||||||||||
645111 | 645111 | EXCHANGE | ADD | 70509V308 | 66 | 2011-09-16 | ? | PEBHP | 0 | 1 | 2011-09-16 | ? | 20110916.ifs | 2011-09-16 | 2011-09-17 |
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 = 159603
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