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:159745 |
reportDate | ratio | endQuaterAffected | dayFrom | dayTo | ||
2012-03-19 | 0.9697 | 2012-03-31 | 2012-01-01 | 2012-03-31 | DELETE | RUN |
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 | ||
3494495 | 3494495 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | L | 1 | 2010-12-08 | 2018-12-06 | 4 | no | no | no | 2010-12-08 | 2018-12-14 | ? | 20181224.ifs | 2018-12-24 | 2018-12-25 | ||||||||||
3494497 | 3494496 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | L | 1 | 2010-12-08 | 2018-12-24 | 4 | no | no | no | 2010-12-08 | 2018-12-24 | ? | 20181224.ifs | 2018-12-24 | 2018-12-25 | ||||||||||
3494499 | 3494499 | CORPACTION | ADD | 37250U300 | 66 | L | 2018-12-24 | ? | 20181224.ifs | 2018-12-24 | 2018-12-25 | ||||||||||||||||||
3494611 | 3494611 | CORPACTION | DELETE | 37250U300 | 66 | L | 2018-12-24 | ? | 20181224.ifs | 2018-12-24 | 2018-12-25 | ||||||||||||||||||
3484607 | 3484607 | EXCHANGE | CHANGE | 37250U300 | 66 | 2014-10-02 | 2018-12-20 | GMETP | 0 | 1 | 2014-10-02 | 2014-11-21 | 20181221.ifs | 2018-12-21 | 2018-12-22 | ||||||||||||||
3484608 | 3484608 | EXCHANGE | CHANGE | 37250U300 | 66 | 2014-10-02 | 2018-12-20 | GMETP | 0 | 1 | 2014-10-02 | 2014-11-21 | 20181221.ifs | 2018-12-21 | 2018-12-22 | ||||||||||||||
3484609 | 3484608 | EXCHANGE | CHANGE | 37250U300 | 66 | 2014-10-02 | 2018-12-04 | GMETP | 0 | 1 | 2014-10-02 | 2018-12-21 | 20181221.ifs | 2018-12-21 | 2018-12-22 | ||||||||||||||
3484610 | 3484609 | EXCHANGE | CHANGE | 37250U300 | 66 | 2014-10-02 | 2018-12-04 | GMETP | 0 | 1 | 2014-10-02 | 2018-12-21 | 20181221.ifs | 2018-12-21 | 2018-12-22 | ||||||||||||||
3436690 | 3436690 | CORPACTION | ADD | 37250U300 | 66 | L | 2018-12-06 | ? | 20181214.ifs | 2018-12-14 | 2018-12-15 | ||||||||||||||||||
3436691 | 3436691 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | 0 | 1 | 2010-12-08 | ? | 4 | no | no | no | 2010-12-08 | 2014-11-21 | ? | 20181214.ifs | 2018-12-14 | 2018-12-15 | ||||||||||
3436692 | 3436691 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | L | 1 | 2010-12-08 | 2018-12-06 | 4 | no | no | no | 2010-12-08 | 2018-12-14 | ? | 20181214.ifs | 2018-12-14 | 2018-12-15 | ||||||||||
3437397 | 3437397 | CORPACTION | ADD | 37250U300 | 66 | L | 2018-12-06 | ? | 20181214.ifs | 2018-12-14 | 2018-12-15 | ||||||||||||||||||
3437399 | 3437399 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | 0 | 1 | 2010-12-08 | ? | 4 | no | no | no | 2010-12-08 | 2014-11-21 | ? | 20181214.ifs | 2018-12-14 | 2018-12-15 | ||||||||||
3437401 | 3437400 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | L | 1 | 2010-12-08 | 2018-12-06 | 4 | no | no | no | 2010-12-08 | 2018-12-14 | ? | 20181214.ifs | 2018-12-14 | 2018-12-15 | ||||||||||
2490779 | 2490779 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | D | 1.663615 | 42 | 2017-02-16 | 2017-02-08 | 2017-02-15 | 2017-01-25 | 0 | 2017-02-15 | ? | 0 | 0005388681 | 20170215.ifs | 2017-02-15 | 2017-02-16 | |||||||
2438762 | 2438762 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | 0 | 1 | 2010-12-08 | ? | 0 | no | no | no | 2010-12-08 | 2014-11-21 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2438763 | 2438762 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | 0 | 1 | 2010-12-08 | ? | 4 | no | no | no | 2010-12-08 | 2014-11-21 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
1940737 | 1940737 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | 0 | .24 | 00 | 2015-09-11 | 2015-09-15 | 2015-09-30 | 2015-08-13 | 0 | 2015-08-13 | ? | 0 | 0005047095 | 20150813.ifs | 2015-08-13 | 2015-08-14 | |||||||
1879229 | 1879229 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2015-06-11 | 2015-06-15 | 2015-06-30 | 2015-06-01 | 0 | ? | 2015-06-02 | 0 | 0005008292 | 20150602.ifs | 2015-06-02 | 2015-06-03 | |||||||
1879230 | 1879230 | DIVIDEND | CHANGE | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2015-06-11 | 2015-06-15 | 2015-06-30 | 2015-06-01 | 0 | ? | 2015-06-02 | 0 | 0005008292 | 20150602.ifs | 2015-06-02 | 2015-06-03 | |||||||
1879231 | 1879230 | DIVIDEND | CHANGE | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2015-06-11 | 2015-06-15 | 2015-06-30 | 2015-06-01 | 37250U300 | 0 | ? | 2015-06-02 | 0 | 0005008292 | 20150602.ifs | 2015-06-02 | 2015-06-03 | ||||||
1808733 | 1808733 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2015-03-12 | 2015-03-16 | 2015-03-31 | 2015-02-19 | 37250U300 | 0 | ? | 2015-03-10 | 0 | 0004966779 | 20150310.ifs | 2015-03-10 | 2015-03-11 | ||||||
1719702 | 1719702 | DIVIDEND | DELETE | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2014-12-11 | 2014-12-15 | 2014-12-31 | 2014-12-05 | 37250U300 | 0 | 2014-12-11 | ? | 0 | 0004890475 | 20141216.ifs | 2014-12-16 | 2014-12-17 | ||||||
1719703 | 1719703 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2014-12-16 | 2014-12-15 | 2014-12-31 | 2014-12-05 | 37250U300 | 1 | 2014-12-11 | 2014-12-16 | 0 | 0004890475 | 20141216.ifs | 2014-12-16 | 2014-12-17 | ||||||
1709615 | 1709615 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2014-12-11 | 2014-12-15 | 2014-12-31 | 2014-12-05 | 37250U300 | 0 | 2014-12-11 | ? | 0 | 0004890475 | 20141211.ifs | 2014-12-11 | 2014-12-12 | ||||||
1685332 | 1685332 | CORPACTION | DELETE | 37250U300 | 60 | D | 2014-11-06 | 2014-11-06 | 20141121.ifs | 2014-11-21 | 2014-11-22 | ||||||||||||||||||
1685333 | 1685333 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | D | 1 | 2010-12-08 | 2014-11-06 | 0 | no | no | no | 2010-12-08 | 2014-11-06 | ? | 20141121.ifs | 2014-11-21 | 2014-11-22 | ||||||||||
1685334 | 1685333 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | D | 1 | 2010-12-08 | ? | 0 | no | no | no | 2010-12-08 | 2014-11-21 | ? | 20141121.ifs | 2014-11-21 | 2014-11-22 | ||||||||||
1685335 | 1685335 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | D | 1 | 2010-12-08 | ? | 0 | no | no | no | 2010-12-08 | 2014-11-21 | ? | 20141121.ifs | 2014-11-21 | 2014-11-22 | ||||||||||
1685336 | 1685335 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | 0 | 1 | 2010-12-08 | ? | 0 | no | no | no | 2010-12-08 | 2014-11-21 | ? | 20141121.ifs | 2014-11-21 | 2014-11-22 | ||||||||||
1685384 | 1685384 | EXCHANGE | CHANGE | 37250U300 | 60 | 2010-12-09 | 2014-11-05 | GMETP | 0 | 1 | 2010-12-09 | 2014-11-06 | 20141121.ifs | 2014-11-21 | 2014-11-22 | ||||||||||||||
1685385 | 1685384 | EXCHANGE | CHANGE | 37250U300 | 60 | 2010-12-09 | 2014-10-01 | GMETP | 0 | 1 | 2010-12-09 | 2014-11-21 | 20141121.ifs | 2014-11-21 | 2014-11-22 | ||||||||||||||
1676897 | 1676897 | CORPACTION | ADD | 37250U300 | 60 | D | 2014-11-06 | 2014-11-06 | 20141106.ifs | 2014-11-06 | 2014-11-07 | ||||||||||||||||||
1676898 | 1676898 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | 0 | 1 | 2010-12-08 | ? | 0 | no | no | no | 2010-12-08 | 2012-05-14 | ? | 20141106.ifs | 2014-11-06 | 2014-11-07 | ||||||||||
1676899 | 1676898 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | D | 1 | 2010-12-08 | 2014-11-06 | 0 | no | no | no | 2010-12-08 | 2014-11-06 | ? | 20141106.ifs | 2014-11-06 | 2014-11-07 | ||||||||||
1676900 | 1676900 | EXCHANGE | CHANGE | 37250U300 | 60 | 2010-12-09 | 2014-10-01 | GMETP | 0 | 1 | 2010-12-09 | ? | 20141106.ifs | 2014-11-06 | 2014-11-07 | ||||||||||||||
1676901 | 1676900 | EXCHANGE | CHANGE | 37250U300 | 60 | 2010-12-09 | 2014-11-05 | GMETP | 0 | 1 | 2010-12-09 | 2014-11-06 | 20141106.ifs | 2014-11-06 | 2014-11-07 | ||||||||||||||
1650746 | 1650746 | CORPACTION | ADD | 37250U300 | 60 | X | 2014-10-02 | 37250U300 | 66 | ? | 20141002.ifs | 2014-10-02 | 2014-10-03 | ||||||||||||||||
1650747 | 1650747 | EXCHANGE | ADD | 37250U300 | 66 | 2014-10-02 | 2014-10-02 | GMETP | 0 | 1 | 2014-10-02 | ? | 20141002.ifs | 2014-10-02 | 2014-10-03 | ||||||||||||||
1624682 | 1624682 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2014-09-11 | 2014-09-15 | 2014-09-30 | 2014-09-04 | 37250U300 | 0 | 2014-09-04 | ? | 1 | 0004840124 | 20140904.ifs | 2014-09-04 | 2014-09-05 | ||||||
1624683 | 1624683 | DIVIDEND | CHANGE | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2014-06-12 | 2014-06-16 | 2014-06-30 | 2014-06-06 | 37250U300 | 1 | 2014-06-06 | 2014-06-09 | 0 | 0004794325 | 20140904.ifs | 2014-09-04 | 2014-09-05 | ||||||
1624684 | 1624683 | DIVIDEND | CHANGE | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2014-06-12 | 2014-06-16 | 2014-06-30 | 2014-06-06 | 37250U300 | 2 | 2014-06-06 | 2014-09-04 | 0 | 0004794325 | 20140904.ifs | 2014-09-04 | 2014-09-05 | ||||||
1545380 | 1545380 | DIVIDEND | DELETE | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2014-06-13 | 2014-06-17 | 2014-06-30 | 2014-06-06 | 37250U300 | 0 | 2014-06-06 | ? | 0 | 0004794325 | 20140609.ifs | 2014-06-09 | 2014-06-10 | ||||||
1545381 | 1545381 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2014-06-12 | 2014-06-16 | 2014-06-30 | 2014-06-06 | 37250U300 | 1 | 2014-06-06 | 2014-06-09 | 0 | 0004794325 | 20140609.ifs | 2014-06-09 | 2014-06-10 | ||||||
1544294 | 1544294 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2014-06-13 | 2014-06-17 | 2014-06-30 | 2014-06-06 | 37250U300 | 0 | 2014-06-06 | ? | 0 | 0004794325 | 20140606.ifs | 2014-06-06 | 2014-06-07 | ||||||
1461058 | 1461058 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2014-03-13 | 2014-03-17 | 2014-03-31 | 2014-03-05 | 37250U300 | 0 | 2014-03-05 | ? | 0 | 0004748020 | 20140305.ifs | 2014-03-05 | 2014-03-06 | ||||||
1356982 | 1356982 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2013-12-11 | 2013-12-13 | 2013-12-31 | 2013-12-03 | 37250U300 | 0 | 2013-12-03 | ? | 0 | 0004669669 | 20131203.ifs | 2013-12-03 | 2013-12-04 | ||||||
1282647 | 1282647 | DIVIDEND | CHANGE | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2013-03-14 | 2013-03-18 | 2013-04-01 | 2013-03-08 | 27250U301 | 0 | 2013-03-08 | ? | 0 | 0004539663 | 20130906.ifs | 2013-09-06 | 2013-09-07 | ||||||
1282648 | 1282647 | DIVIDEND | CHANGE | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 0 | 00 | 2013-03-14 | 2013-03-18 | 2013-04-01 | 2013-03-08 | 37250U300 | 0 | 2013-03-08 | 2013-09-06 | 0 | 0004539663 | 20130906.ifs | 2013-09-06 | 2013-09-07 | |||||
1282512 | 1282512 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2013-09-16 | 2013-09-18 | 2013-09-30 | 2013-09-05 | 37250U300 | 0 | 2013-09-05 | ? | 0 | 0004626532 | 20130905.ifs | 2013-09-05 | 2013-09-06 | ||||||
1205129 | 1205129 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2013-06-14 | 2013-06-18 | 2013-07-01 | 2013-06-05 | 37250U300 | 0 | 2013-06-05 | ? | 0 | 0004581811 | 20130605.ifs | 2013-06-05 | 2013-06-06 | ||||||
1130154 | 1130154 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2013-03-14 | 2013-03-18 | 2013-04-01 | 2013-03-08 | 27250U301 | 0 | 2013-03-08 | ? | 0 | 0004539663 | 20130308.ifs | 2013-03-08 | 2013-03-09 | ||||||
1030306 | 1030306 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2012-12-13 | 2012-12-17 | 2012-12-31 | 2012-12-06 | 37250U300 | 0 | 2012-12-06 | ? | 0 | 0004470546 | 20121206.ifs | 2012-12-06 | 2012-12-07 | ||||||
951337 | 951337 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2012-09-14 | 2012-09-18 | 2012-10-01 | 2012-09-06 | 37250U300 | 0 | 2012-09-06 | ? | 0 | 0004426627 | 20120906.ifs | 2012-09-06 | 2012-09-07 | ||||||
882317 | 882317 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2012-06-14 | 2012-06-18 | 2012-07-02 | 2012-06-08 | 37250U300 | 0 | 2012-06-08 | ? | 0 | 0004385208 | 20120608.ifs | 2012-06-08 | 2012-06-09 | ||||||
860263 | 860263 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | 0 | 1 | 2010-12-08 | ? | 0 | no | no | yes | 2010-12-08 | 2010-12-09 | ? | 20120514.ifs | 2012-05-14 | 2012-05-15 | ||||||||||
860264 | 860263 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | 0 | 1 | 2010-12-08 | ? | 0 | no | no | no | 2010-12-08 | 2012-05-14 | ? | 20120514.ifs | 2012-05-14 | 2012-05-15 | ||||||||||
860399 | 860399 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | 0 | 1 | 2010-12-08 | ? | 0 | no | no | no | 2010-12-08 | 2012-05-14 | ? | 20120514.ifs | 2012-05-14 | 2012-05-15 | ||||||||||
860400 | 860399 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | 0 | 1 | 2010-12-08 | ? | 0 | no | no | yes | 2010-12-08 | 2012-05-14 | ? | 20120514.ifs | 2012-05-14 | 2012-05-15 | ||||||||||
860401 | 860401 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | 0 | 1 | 2010-12-08 | ? | 0 | no | no | yes | 2010-12-08 | 2012-05-14 | ? | 20120514.ifs | 2012-05-14 | 2012-05-15 | ||||||||||
860402 | 860401 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | 0 | 1 | 2010-12-08 | ? | 0 | no | no | no | 2010-12-08 | 2012-05-14 | ? | 20120514.ifs | 2012-05-14 | 2012-05-15 | ||||||||||
799939 | 799939 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2012-03-19 | 2012-03-21 | 2012-04-02 | 2012-03-09 | 37250U300 | 0 | 2012-03-09 | ? | 0 | 0004344704 | 20120309.ifs | 2012-03-09 | 2012-03-10 | ||||||
715404 | 715404 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2011-12-14 | 2011-12-16 | 2012-01-03 | 2011-12-07 | 37250U300 | 0 | 2011-12-07 | ? | 0 | 0004281987 | 20111207.ifs | 2011-12-07 | 2011-12-08 | ||||||
635546 | 635546 | DIVIDEND | DELETE | 37250U300 | 0 | 0 | 4 | 0 | .03125 | 04 | 2011-03-15 | 2011-03-17 | 2011-03-31 | 2011-03-11 | 0 | ? | 2011-03-14 | 0 | 0004158996 | 20110902.ifs | 2011-09-02 | 2011-09-03 | |||||||
635547 | 635547 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 0 | 00 | 2011-03-15 | 2011-03-17 | 2011-03-31 | 2011-03-11 | 0 | ? | 2011-09-02 | 0 | 0004158996 | 20110902.ifs | 2011-09-02 | 2011-09-03 | ||||||
635548 | 635548 | DIVIDEND | CHANGE | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 0 | 00 | 2011-03-15 | 2011-03-17 | 2011-03-31 | 2011-03-11 | 0 | ? | 2011-09-02 | 0 | 0004158996 | 20110902.ifs | 2011-09-02 | 2011-09-03 | ||||||
635549 | 635548 | DIVIDEND | CHANGE | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 0 | 00 | 2011-03-15 | 2011-03-17 | 2011-03-31 | 2011-03-11 | 37250U300 | 0 | ? | 2011-09-02 | 0 | 0004158996 | 20110902.ifs | 2011-09-02 | 2011-09-03 | |||||
634406 | 634406 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 1 | 0 | .03125 | 00 | 2011-09-08 | 2011-09-12 | 2011-09-30 | 2011-09-01 | 37250U300 | 0 | 2011-09-01 | ? | 0 | 0004236498 | 20110901.ifs | 2011-09-01 | 2011-09-02 | ||||||
470765 | 470765 | DIVIDEND | ADD | 37250U300 | 0 | 0 | 4 | 0 | .03125 | 04 | 2011-03-15 | 2011-03-17 | 2011-03-31 | 2011-03-11 | 0 | ? | 2011-03-14 | 0 | 0004158996 | 20110314.ifs | 2011-03-14 | 2011-03-15 | |||||||
374246 | 374246 | EXCHANGE | ADD | 37250U300 | 60 | 2010-12-09 | 2010-12-09 | GMETP | 0 | 1 | 2010-12-09 | ? | 20101209.ifs | 2010-12-09 | 2010-12-10 | ||||||||||||||
374347 | 374347 | EQUITY | CHANGE | 37250U300 | PRE | N | 1 | 2010-12-08 | ? | 0 | no | no | yes | 2010-12-08 | 2010-12-08 | ? | 20101209.ifs | 2010-12-09 | 2010-12-10 | ||||||||||
374348 | 374347 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | N | 1 | 2010-12-08 | ? | 0 | no | no | yes | 2010-12-08 | 2010-12-09 | ? | 20101209.ifs | 2010-12-09 | 2010-12-10 | ||||||||||
374480 | 374480 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | N | 1 | 2010-12-08 | ? | 0 | no | no | yes | 2010-12-08 | 2010-12-09 | ? | 20101209.ifs | 2010-12-09 | 2010-12-10 | ||||||||||
374481 | 374480 | EQUITY | CHANGE | 37250U300 | PFD CONV SER A | 0 | 1 | 2010-12-08 | ? | 0 | no | no | yes | 2010-12-08 | 2010-12-09 | ? | 20101209.ifs | 2010-12-09 | 2010-12-10 | ||||||||||
372688 | 372688 | EQUITY | ADD | 37250U300 | PRE | N | 1 | 2010-12-08 | ? | 0 | no | no | no | 2010-12-08 | ? | ? | 20101208.ifs | 2010-12-08 | 2010-12-09 | ||||||||||
372689 | 372689 | EQUITY | CHANGE | 37250U300 | PRE | N | 1 | 2010-12-08 | ? | 0 | no | no | no | 2010-12-08 | ? | ? | 20101208.ifs | 2010-12-08 | 2010-12-09 | ||||||||||
372690 | 372689 | EQUITY | CHANGE | 37250U300 | PRE | N | 1 | 2010-12-08 | ? | 0 | no | no | yes | 2010-12-08 | 2010-12-08 | ? | 20101208.ifs | 2010-12-08 | 2010-12-09 |
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 = 159745
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