INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | N/A | Update Insititution By Cusips | |||||||||
% Owned by Insititutions: | N/A % | % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:133806 |
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 | ||
718921 | 718921 | CORPACTION | ADD | 654086107 | 01 | M | 2011-12-12 | 001204106 | 01 | 2011-12-12 | 20111212.ifs | 2011-12-12 | 2011-12-13 | ||||||||||||||||
718922 | 718922 | EQUITY | CHANGE | 654086107 | COM | 0 | 0 | 1976-05-03 | ? | 4 | yes | no | no | 1994-09-19 | 2011-12-09 | ? | 20111212.ifs | 2011-12-12 | 2011-12-13 | ||||||||||
718923 | 718922 | EQUITY | CHANGE | 654086107 | COM | M | 0 | 1976-05-03 | 2011-12-12 | 4 | yes | no | 001204106 | no | 1994-09-19 | 2011-12-12 | ? | 20111212.ifs | 2011-12-12 | 2011-12-13 | |||||||||
715888 | 715888 | CORPACTION | ADD | 654086107 | 01 | M | 2011-12-09 | 001204106 | 01 | ? | 20111209.ifs | 2011-12-09 | 2011-12-10 | ||||||||||||||||
715889 | 715889 | EQUITY | CHANGE | 654086107 | COM | 0 | 0 | 1976-05-03 | ? | 4 | yes | yes | no | 1994-09-19 | 1994-03-28 | ? | 20111209.ifs | 2011-12-09 | 2011-12-10 | ||||||||||
715890 | 715889 | EQUITY | CHANGE | 654086107 | COM | M | 0 | 1976-05-03 | 2011-12-09 | 4 | yes | yes | 001204106 | no | 1994-09-19 | 2011-12-09 | ? | 20111209.ifs | 2011-12-09 | 2011-12-10 | |||||||||
715976 | 715976 | CORPACTION | DELETE | 654086107 | 01 | M | 2011-12-09 | 001204106 | 01 | ? | 20111209.ifs | 2011-12-09 | 2011-12-10 | ||||||||||||||||
715977 | 715977 | EQUITY | CHANGE | 654086107 | COM | M | 0 | 1976-05-03 | 2011-12-09 | 4 | yes | yes | 001204106 | no | 1994-09-19 | 2011-12-09 | ? | 20111209.ifs | 2011-12-09 | 2011-12-10 | |||||||||
715978 | 715977 | EQUITY | CHANGE | 654086107 | COM | 0 | 0 | 1976-05-03 | ? | 4 | yes | no | no | 1994-09-19 | 2011-12-09 | ? | 20111209.ifs | 2011-12-09 | 2011-12-10 | ||||||||||
716797 | 716797 | DIVIDEND | ADD | 654086107 | 0 | 1 | 0 | .34875 | 14 | ? | 2011-12-08 | 2011-12-16 | 2011-12-09 | 0 | 2011-12-09 | ? | 0 | 0004267911 | 20111209.ifs | 2011-12-09 | 2011-12-10 | ||||||||
595047 | 595047 | DIVIDEND | ADD | 654086107 | 0 | 0 | 1 | 0 | .465 | 00 | 2011-09-28 | 2011-09-30 | 2011-11-01 | 2011-07-28 | 0 | 2011-07-28 | ? | 0 | 0004220185 | 20110728.ifs | 2011-07-28 | 2011-07-29 | |||||||
559177 | 559177 | DIVIDEND | ADD | 654086107 | 0 | 0 | 1 | 0 | .465 | 00 | 2011-06-28 | 2011-06-30 | 2011-08-01 | 2011-06-14 | 0 | 2011-06-14 | ? | 0 | 0004200685 | 20110614.ifs | 2011-06-14 | 2011-06-15 | |||||||
444782 | 444782 | DIVIDEND | ADD | 654086107 | 0 | 0 | 1 | 0 | .465 | 00 | 2011-03-29 | 2011-03-31 | 2011-05-01 | 2011-02-17 | 0 | 2011-02-17 | ? | 0 | 0004147642 | 20110217.ifs | 2011-02-17 | 2011-02-18 | |||||||
358692 | 358692 | DIVIDEND | ADD | 654086107 | 0 | 0 | 1 | 0 | .465 | 00 | 2010-12-29 | 2010-12-31 | 2011-02-01 | 2010-11-19 | 0 | 2010-11-19 | ? | 0 | 0004088803 | 20101119.ifs | 2010-11-19 | 2010-11-20 | |||||||
257855 | 257855 | DIVIDEND | ADD | 654086107 | 0 | 0 | 1 | 0 | .465 | 00 | 2010-09-28 | 2010-09-30 | 2010-11-01 | 2010-07-22 | 0 | 2010-07-22 | ? | 0 | 0004035816 | 20100722.ifs | 2010-07-22 | 2010-07-23 | |||||||
164700 | 164700 | DIVIDEND | ADD | 654086107 | 0 | 0 | 1 | 0 | .465 | 00 | 2010-06-28 | 2010-06-30 | 2010-08-01 | 2010-04-22 | 0 | 2010-04-22 | ? | 0 | 0003995299 | 20100422.ifs | 2010-04-22 | 2010-04-23 | |||||||
113242 | 113242 | DIVIDEND | ADD | 654086107 | 0 | 0 | 1 | 0 | .465 | 00 | 2010-03-29 | 2010-03-31 | 2010-05-01 | 2010-02-19 | 0 | 2010-02-19 | ? | 0 | 0003966772 | 20100219.ifs | 2010-02-19 | 2010-04-07 | |||||||
27551 | 27551 | DIVIDEND | ADD | 654086107 | 0 | 0 | 1 | 0 | .465 | 00 | 2009-12-29 | 2009-12-31 | 2010-02-01 | 2009-11-20 | 0 | 2009-11-20 | ? | 0 | 0003909778 | 20091120.ifs | 2009-11-20 | 2010-04-07 |
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 = 133806
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