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:159580 |
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 | ||
1975913 | 1975913 | CORPACTION | ADD | 025932302 | 01 | C | 2015-09-30 | ? | 20150930.ifs | 2015-09-30 | 2015-10-01 | ||||||||||||||||||
1950291 | 1950291 | DIVIDEND | CHANGE | 025932302 | 0 | 0 | 1 | 0 | .4375 | 00 | 2015-09-11 | 2015-09-15 | 2015-09-30 | 2015-08-10 | 0 | 2015-08-10 | ? | 0 | 0005046307 | 20150828.ifs | 2015-08-28 | 2015-08-29 | |||||||
1950292 | 1950291 | DIVIDEND | CHANGE | 025932302 | 0 | 0 | 1 | 0 | .4375 | 00 | 2015-09-11 | 2015-09-15 | 2015-09-30 | 2015-08-10 | 1 | 2015-08-10 | 2015-08-28 | 0 | 0005046307 | 20150828.ifs | 2015-08-28 | 2015-08-29 | |||||||
1870289 | 1870289 | DIVIDEND | ADD | 025932302 | 0 | 0 | 1 | 0 | .4375 | 00 | 2015-06-11 | 2015-06-15 | 2015-06-30 | 2015-05-26 | 0 | 2015-05-26 | ? | 0 | 0005002943 | 20150526.ifs | 2015-05-26 | 2015-05-27 | |||||||
1786611 | 1786611 | DIVIDEND | ADD | 025932302 | 0 | 0 | 1 | 0 | .4375 | 00 | 2015-03-11 | 2015-03-15 | 2015-03-30 | 2015-02-04 | 0 | 2015-02-04 | ? | 0 | 0004952784 | 20150204.ifs | 2015-02-04 | 2015-02-05 | |||||||
1687163 | 1687163 | DIVIDEND | ADD | 025932302 | 0 | 0 | 1 | 0 | .4375 | 00 | 2014-12-11 | 2014-12-15 | 2014-12-30 | 2014-11-24 | 0 | 2014-11-24 | ? | 0 | 0004875599 | 20141124.ifs | 2014-11-24 | 2014-11-25 | |||||||
1612697 | 1612697 | DIVIDEND | ADD | 025932302 | 0 | 0 | 1 | 0 | .4375 | 00 | 2014-09-11 | 2014-09-15 | 2014-09-30 | 2014-08-25 | 0 | 2014-08-25 | ? | 0 | 0004831344 | 20140825.ifs | 2014-08-25 | 2014-08-26 | |||||||
1501760 | 1501760 | DIVIDEND | ADD | 025932302 | 0 | 0 | 1 | 0 | .4375 | 00 | 2014-06-11 | 2014-06-15 | 2014-06-30 | 2014-04-23 | 0 | 2014-04-24 | ? | 0 | 0004770478 | 20140424.ifs | 2014-04-24 | 2014-04-25 | |||||||
1448688 | 1448688 | DIVIDEND | ADD | 025932302 | 0 | 0 | 1 | 0 | .4375 | 00 | 2014-03-12 | 2014-03-15 | 2014-03-30 | 2014-02-20 | 0 | 2014-02-24 | ? | 0 | 0004738722 | 20140224.ifs | 2014-02-24 | 2014-02-25 | |||||||
1346653 | 1346653 | DIVIDEND | ADD | 025932302 | 0 | 0 | 1 | 0 | .4375 | 00 | 2013-12-11 | 2013-12-15 | 2013-12-30 | 2013-11-25 | 0 | 2013-11-26 | ? | 0 | 0004661642 | 20131126.ifs | 2013-11-26 | 2013-11-27 | |||||||
1247074 | 1247074 | DIVIDEND | ADD | 025932302 | 0 | 0 | 1 | 0 | .4375 | 00 | 2013-09-11 | 2013-09-15 | 2013-09-30 | 2013-07-25 | 0 | 2013-07-25 | ? | 0 | 0004604259 | 20130725.ifs | 2013-07-25 | 2013-07-26 | |||||||
1116601 | 1116601 | DIVIDEND | ADD | 025932302 | 0 | 0 | 1 | 0 | .4375 | 00 | 2013-06-12 | 2013-06-15 | 2013-07-01 | 2013-02-14 | 0 | 2013-02-22 | ? | 0 | 0004530133 | 20130222.ifs | 2013-02-22 | 2013-02-23 | |||||||
1097504 | 1097504 | DIVIDEND | ADD | 025932302 | 0 | 0 | 1 | 0 | .4375 | 00 | 2013-03-13 | 2013-03-15 | 2013-04-01 | 2013-01-28 | 0 | 2013-01-28 | ? | 0 | 0004517895 | 20130128.ifs | 2013-01-28 | 2013-01-29 | |||||||
1030806 | 1030806 | EQUITY | CHANGE | 025932302 | SR NT 10/01/2050 7.000 | 0 | 0 | 2010-09-30 | ? | 0 | no | no | no | ? | 2010-10-13 | ? | 20121207.ifs | 2012-12-07 | 2012-12-08 | ||||||||||
1030807 | 1030806 | EQUITY | CHANGE | 025932302 | SR NT 10/01/2050 7.000 | 0 | 6 | 2010-09-30 | ? | 0 | no | no | no | ? | 2012-12-07 | ? | 20121207.ifs | 2012-12-07 | 2012-12-08 | ||||||||||
987260 | 987260 | DIVIDEND | ADD | 025932302 | 0 | 0 | 1 | 0 | .4375 | 00 | 2012-12-12 | 2012-12-15 | 2012-12-30 | 2012-10-16 | 0 | 2012-10-16 | ? | 0 | 0004445751 | 20121016.ifs | 2012-10-16 | 2012-10-17 | |||||||
937535 | 937535 | DIVIDEND | ADD | 025932302 | 0 | 0 | 1 | 0 | .4375 | 00 | 2012-09-12 | 2012-09-15 | 2012-10-01 | 2012-08-22 | 0 | 2012-08-22 | ? | 0 | 0004417916 | 20120822.ifs | 2012-08-22 | 2012-08-23 | |||||||
832528 | 832528 | DIVIDEND | ADD | 025932302 | 0 | 0 | 1 | 0 | .4375 | 00 | 2012-06-13 | 2012-06-15 | 2012-07-02 | 2012-04-09 | 0 | 2012-04-09 | ? | 0 | 0004360578 | 20120409.ifs | 2012-04-09 | 2012-04-10 | |||||||
755969 | 755969 | DIVIDEND | ADD | 025932302 | 0 | 0 | 1 | 0 | .4375 | 00 | 2012-03-13 | 2012-03-15 | 2012-03-30 | 2012-01-12 | 0 | 2012-01-12 | ? | 0 | 0004320626 | 20120112.ifs | 2012-01-12 | 2012-01-13 | |||||||
676305 | 676305 | DIVIDEND | ADD | 025932302 | 0 | 0 | 1 | 0 | .4375 | 00 | 2011-12-13 | 2011-12-15 | 2011-12-30 | 2011-10-20 | 0 | 2011-10-20 | ? | 0 | 0004258805 | 20111020.ifs | 2011-10-20 | 2011-10-21 | |||||||
625618 | 625618 | DIVIDEND | ADD | 025932302 | 0 | 0 | 1 | 0 | .4375 | 00 | 2011-09-13 | 2011-09-15 | 2011-09-30 | 2011-08-24 | 0 | 2011-08-24 | ? | 0 | 0004231866 | 20110824.ifs | 2011-08-24 | 2011-08-25 | |||||||
531618 | 531618 | DIVIDEND | ADD | 025932302 | 0 | 0 | 1 | 0 | .4375 | 00 | 2011-06-13 | 2011-06-15 | 2011-06-30 | 2011-05-20 | 0 | 2011-05-20 | ? | 0 | 0004189783 | 20110520.ifs | 2011-05-20 | 2011-05-21 | |||||||
461274 | 461274 | DIVIDEND | ADD | 025932302 | 0 | 0 | 1 | 0 | .4375 | 00 | 2011-03-11 | 2011-03-15 | 2011-03-30 | 2011-03-01 | 0 | 2011-03-01 | ? | 0 | 0004155902 | 20110301.ifs | 2011-03-01 | 2011-03-02 | |||||||
333876 | 333876 | EQUITY | CHANGE | 025932302 | SR NT | 0 | 0 | 2010-09-30 | ? | 0 | no | no | no | ? | 2010-10-07 | ? | 20101013.ifs | 2010-10-13 | 2010-10-14 | ||||||||||
333877 | 333876 | EQUITY | CHANGE | 025932302 | SR NT 10/01/2050 7.000 | 0 | 0 | 2010-09-30 | ? | 0 | no | no | no | ? | 2010-10-13 | ? | 20101013.ifs | 2010-10-13 | 2010-10-14 | ||||||||||
331602 | 331602 | EQUITY | CHANGE | 025932302 | SR NT | 0 | 6 | 2010-09-30 | ? | 0 | no | no | no | ? | 2010-10-01 | ? | 20101008.ifs | 2010-10-08 | 2010-10-09 | ||||||||||
331603 | 331602 | EQUITY | CHANGE | 025932302 | SR NT | 0 | 0 | 2010-09-30 | ? | 0 | no | no | no | ? | 2010-10-07 | ? | 20101008.ifs | 2010-10-08 | 2010-10-09 | ||||||||||
331604 | 331604 | EXCHANGE | ADD | 025932302 | 01 | 2010-09-30 | 2010-10-06 | AFQ | 0 | 0 | ? | 2010-10-07 | 20101008.ifs | 2010-10-08 | 2010-10-09 | ||||||||||||||
319704 | 319704 | EQUITY | ADD | 025932302 | NEW ISSUE | 0 | 0 | 2010-09-30 | ? | 0 | no | no | no | ? | ? | ? | 20100930.ifs | 2010-09-30 | 2010-10-01 | ||||||||||
319705 | 319705 | EQUITY | CHANGE | 025932302 | NEW ISSUE | 0 | 0 | 2010-09-30 | ? | 0 | no | no | no | ? | ? | ? | 20100930.ifs | 2010-09-30 | 2010-10-01 | ||||||||||
319706 | 319705 | EQUITY | CHANGE | 025932302 | SR NT | N | 6 | 2010-09-30 | ? | 0 | no | no | no | ? | 2010-09-30 | ? | 20100930.ifs | 2010-09-30 | 2010-10-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 = 159580
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