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:159747 |
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 | ||
777003 | 777003 | CORPACTION | ADD | 36186R209 | 66 | Q | 2012-02-09 | 02005N605 | 66 | 2012-02-09 | 20120209.ifs | 2012-02-09 | 2012-02-10 | ||||||||||||||||
777004 | 777004 | EQUITY | CHANGE | 36186R209 | PERP PFD SER G 7% 144A | 0 | 1 | 2010-07-29 | ? | 0 | no | no | no | ? | 2012-02-08 | ? | 20120209.ifs | 2012-02-09 | 2012-02-10 | ||||||||||
777005 | 777004 | EQUITY | CHANGE | 36186R209 | PERP PFD SER G 7% 144A | Q | 1 | 2010-07-29 | 2012-02-09 | 0 | no | no | 02005N605 | no | ? | 2012-02-09 | ? | 20120209.ifs | 2012-02-09 | 2012-02-10 | |||||||||
777006 | 777006 | EXCHANGE | CHANGE | 36186R209 | 66 | 2010-08-02 | 2010-10-14 | GMSPZ | 0 | 1 | 2010-08-02 | ? | 20120209.ifs | 2012-02-09 | 2012-02-10 | ||||||||||||||
777007 | 777006 | EXCHANGE | CHANGE | 36186R209 | 66 | 2010-08-02 | 2012-02-08 | GMSPZ | 0 | 1 | 2010-08-02 | 2012-02-09 | 20120209.ifs | 2012-02-09 | 2012-02-10 | ||||||||||||||
775908 | 775908 | EQUITY | CHANGE | 36186R209 | PERP PFD SER G 7% 144A | N | 1 | 2010-07-29 | ? | 0 | no | no | no | ? | ? | ? | 20120208.ifs | 2012-02-08 | 2012-02-09 | ||||||||||
775909 | 775908 | EQUITY | CHANGE | 36186R209 | PERP PFD SER G 7% 144A | 0 | 1 | 2010-07-29 | ? | 0 | no | no | no | ? | 2012-02-08 | ? | 20120208.ifs | 2012-02-08 | 2012-02-09 | ||||||||||
756796 | 756796 | DIVIDEND | ADD | 36186R209 | 0 | 0 | 1 | 0 | 17.5 | 00 | ? | 2012-02-01 | 2012-02-15 | 2012-01-04 | 0 | 2012-01-13 | ? | 0 | 0004320714 | 20120113.ifs | 2012-01-13 | 2012-01-14 | |||||||
670884 | 670884 | DIVIDEND | ADD | 36186R209 | 0 | 0 | 1 | 0 | 17.5 | 00 | ? | 2011-11-01 | 2011-11-15 | 2011-10-06 | 0 | 2011-10-11 | ? | 0 | 0004256752 | 20111011.ifs | 2011-10-11 | 2011-10-12 | |||||||
593163 | 593163 | DIVIDEND | ADD | 36186R209 | 0 | 0 | 1 | 0 | 17.31 | 00 | ? | 2011-08-01 | 2011-08-15 | 2011-07-18 | 0 | 2011-07-26 | ? | 0 | 0004219432 | 20110726.ifs | 2011-07-26 | 2011-07-27 | |||||||
507044 | 507044 | DIVIDEND | ADD | 36186R209 | 0 | 0 | 1 | 0 | 17.69 | 00 | ? | 2011-05-02 | 2011-05-16 | 2011-04-18 | 0 | 2011-04-21 | ? | 0 | 0004177010 | 20110421.ifs | 2011-04-21 | 2011-04-22 | |||||||
419015 | 419015 | DIVIDEND | ADD | 36186R209 | 0 | 0 | 1 | 0 | 17.5 | 00 | ? | 2011-02-01 | 2011-02-15 | 2011-01-14 | 0 | 2011-01-14 | ? | 0 | 0004135031 | 20110114.ifs | 2011-01-14 | 2011-01-15 | |||||||
337553 | 337553 | DIVIDEND | ADD | 36186R209 | 0 | 0 | 1 | 0 | 17.31 | 00 | ? | 2010-11-01 | 2010-11-15 | 2010-10-01 | 0 | 2010-10-19 | ? | 0 | 0004075405 | 20101019.ifs | 2010-10-19 | 2010-10-20 | |||||||
266742 | 266742 | EXCHANGE | ADD | 36186R209 | 66 | 2010-08-02 | ? | GMSPZ | 0 | 1 | 2010-08-02 | ? | 20100802.ifs | 2010-08-02 | 2010-08-03 | ||||||||||||||
262924 | 262924 | EQUITY | ADD | 36186R209 | PERP PFD SER G 7% 144A | N | 1 | 2010-07-29 | ? | 0 | no | no | no | ? | ? | ? | 20100729.ifs | 2010-07-29 | 2010-07-30 | ||||||||||
262925 | 262925 | DIVIDEND | ADD | 36186R209 | 0 | 0 | 1 | 4 | 17.89 | 00 | ? | 2010-05-03 | 2010-05-17 | 2010-03-25 | 0 | 2010-07-29 | ? | 1 | 0004037756 | 20100729.ifs | 2010-07-29 | 2010-07-30 | |||||||
262926 | 262926 | DIVIDEND | ADD | 36186R209 | 0 | 0 | 1 | 0 | 17.31 | 00 | ? | 2010-02-01 | 2010-02-15 | 2010-01-08 | 0 | 2010-07-29 | ? | 0 | 0004037755 | 20100729.ifs | 2010-07-29 | 2010-07-30 | |||||||
262927 | 262927 | DIVIDEND | ADD | 36186R209 | 0 | 0 | 1 | 0 | 17.31 | 00 | ? | 2010-08-02 | 2010-08-16 | 2010-07-14 | 0 | 2010-07-29 | ? | 2 | 0004037754 | 20100729.ifs | 2010-07-29 | 2010-07-30 |
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 = 159747
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