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:130521 |
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 | ||
2196153 | 2196153 | CORPACTION | ADD | 80004C101 | 60 | M | 2016-05-13 | 958102105 | 60 | ? | 20160513.ifs | 2016-05-13 | 2016-05-14 | ||||||||||||||||
2196154 | 2196154 | EQUITY | CHANGE | 80004C101 | COM | 0 | 0 | 1995-11-08 | ? | 8 | yes | yes | yes | 2000-01-27 | 2006-04-24 | ? | 20160513.ifs | 2016-05-13 | 2016-05-14 | ||||||||||
2196155 | 2196154 | EQUITY | CHANGE | 80004C101 | COM | M | 0 | 1995-11-08 | 2016-05-13 | 8 | yes | yes | 958102105 | yes | 2000-01-27 | 2016-05-13 | ? | 20160513.ifs | 2016-05-13 | 2016-05-14 | |||||||||
1998991 | 1998991 | DIVIDEND | CHANGE | 80004C101 | 0 | 0 | 1 | 0 | .3 | 00 | 2015-07-30 | 2015-08-03 | 2015-08-25 | 2015-07-22 | 0 | 2015-07-22 | ? | 0 | 0005034757 | 20151029.ifs | 2015-10-29 | 2015-10-30 | |||||||
1998992 | 1998991 | DIVIDEND | CHANGE | 80004C101 | 0 | 0 | 1 | 0 | .3 | 00 | 2015-07-30 | 2015-08-03 | 2015-08-25 | 2015-07-22 | 1 | 2015-07-22 | 2015-10-29 | 0 | 0005034757 | 20151029.ifs | 2015-10-29 | 2015-10-30 | |||||||
1920801 | 1920801 | DIVIDEND | ADD | 80004C101 | 0 | 0 | 1 | 0 | .3 | 00 | 2015-07-30 | 2015-08-03 | 2015-08-25 | 2015-07-22 | 0 | 2015-07-22 | ? | 0 | 0005034757 | 20150722.ifs | 2015-07-22 | 2015-07-23 | |||||||
1840677 | 1840677 | DIVIDEND | ADD | 80004C101 | 0 | 0 | 1 | 0 | .3 | 00 | 2015-04-30 | 2015-05-04 | 2015-05-26 | 2015-04-15 | 0 | 2015-04-15 | ? | 0 | 0004986327 | 20150415.ifs | 2015-04-15 | 2015-04-16 | |||||||
1772343 | 1772343 | DIVIDEND | ADD | 80004C101 | 0 | 0 | 1 | 0 | .3 | 00 | 2015-02-26 | 2015-03-02 | 2015-03-23 | 2015-01-21 | 0 | 2015-01-21 | ? | 0 | 0004942884 | 20150121.ifs | 2015-01-21 | 2015-01-22 | |||||||
1658316 | 1658316 | DIVIDEND | ADD | 80004C101 | 0 | 0 | 1 | 0 | .3 | 00 | 2014-10-30 | 2014-11-03 | 2014-11-24 | 2014-10-16 | 0 | 2014-10-16 | ? | 0 | 0004860145 | 20141016.ifs | 2014-10-16 | 2014-10-17 | |||||||
1580925 | 1580925 | DIVIDEND | ADD | 80004C101 | 0 | 0 | 1 | 0 | .3 | 00 | 2014-07-31 | 2014-08-04 | 2014-08-25 | 2014-07-16 | 0 | 2014-07-16 | ? | 0 | 0004815482 | 20140716.ifs | 2014-07-16 | 2014-07-17 | |||||||
1496840 | 1496840 | DIVIDEND | ADD | 80004C101 | 0 | 0 | 1 | 0 | .225 | 00 | 2014-05-01 | 2014-05-05 | 2014-05-27 | 2014-04-16 | 0 | 2014-04-16 | ? | 1 | 0004768580 | 20140416.ifs | 2014-04-16 | 2014-04-17 | |||||||
1496841 | 1496841 | DIVIDEND | CHANGE | 80004C101 | 0 | 0 | 1 | 0 | .225 | 00 | 2014-01-30 | 2014-02-03 | 2014-02-24 | 2014-01-22 | 0 | 2014-01-22 | ? | 0 | 0004725386 | 20140416.ifs | 2014-04-16 | 2014-04-17 | |||||||
1496842 | 1496841 | DIVIDEND | CHANGE | 80004C101 | 0 | 0 | 1 | 0 | .225 | 00 | 2014-01-30 | 2014-02-03 | 2014-02-24 | 2014-01-22 | 1 | 2014-01-22 | 2014-04-16 | 0 | 0004725386 | 20140416.ifs | 2014-04-16 | 2014-04-17 | |||||||
1425580 | 1425580 | DIVIDEND | ADD | 80004C101 | 0 | 0 | 1 | 0 | .225 | 00 | 2014-01-30 | 2014-02-03 | 2014-02-24 | 2014-01-22 | 0 | 2014-01-22 | ? | 0 | 0004725386 | 20140122.ifs | 2014-01-22 | 2014-01-23 | |||||||
1316974 | 1316974 | DIVIDEND | ADD | 80004C101 | 0 | 0 | 1 | 0 | .225 | 00 | 2013-10-31 | 2013-11-04 | 2013-11-25 | 2013-10-16 | 0 | 2013-10-16 | ? | 0 | 0004645726 | 20131016.ifs | 2013-10-16 | 2013-10-17 | |||||||
1250894 | 1250894 | DIVIDEND | ADD | 80004C101 | 0 | 0 | 1 | 0 | .225 | 35 | 2013-08-08 | 2013-08-12 | 2013-08-30 | 2013-07-31 | 0 | 2013-07-31 | ? | 0 | 0004608045 | 20130731.ifs | 2013-07-31 | 2013-08-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 = 130521
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