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:159614 |
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 | ||
2657863 | 2657863 | CORPACTION | ADD | 903002202 | 01 | C | 2017-08-31 | ? | 20170831.ifs | 2017-08-31 | 2017-09-01 | ||||||||||||||||||
2657864 | 2657864 | EQUITY | CHANGE | 903002202 | CUM RED PFD SER A 8.25% | 0 | 1 | 2011-06-06 | ? | 4 | no | no | no | 2011-06-06 | ? | ? | 20170831.ifs | 2017-08-31 | 2017-09-01 | ||||||||||
2657865 | 2657864 | EQUITY | CHANGE | 903002202 | CUM RED PFD SER A 8.25% | C | 1 | 2011-06-06 | 2017-08-31 | 4 | no | no | no | 2011-06-06 | 2017-08-31 | ? | 20170831.ifs | 2017-08-31 | 2017-09-01 | ||||||||||
2637295 | 2637295 | DIVIDEND | ADD | 903002202 | 0 | 0 | C | 0 | 25 | 12 | ? | ? | 2017-08-15 | 2017-07-31 | 0 | ? | 2017-08-01 | 0 | 20170801.ifs | 2017-08-01 | 2017-08-02 | ||||||||
2634717 | 2634717 | DIVIDEND | CHANGE | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2017-08-11 | 2017-08-15 | 2017-09-15 | 2017-07-03 | 0 | 2017-07-03 | ? | 0 | 0005464077 | 20170731.ifs | 2017-07-31 | 2017-08-01 | |||||||
2634718 | 2634717 | DIVIDEND | CHANGE | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2017-08-11 | 2017-08-15 | 2017-09-15 | 2017-07-03 | 1 | 2017-07-03 | 2017-07-31 | 0 | 0005464077 | 20170731.ifs | 2017-07-31 | 2017-08-01 | |||||||
2611570 | 2611570 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2017-08-11 | 2017-08-15 | 2017-09-15 | 2017-07-03 | 0 | 2017-07-03 | ? | 0 | 0005464077 | 20170703.ifs | 2017-07-03 | 2017-07-04 | |||||||
2531231 | 2531231 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2017-05-11 | 2017-05-15 | 2017-06-15 | 2017-04-03 | 0 | 2017-04-03 | ? | 0 | 0005417173 | 20170403.ifs | 2017-04-03 | 2017-04-04 | |||||||
2446594 | 2446594 | EQUITY | CHANGE | 903002202 | CUM RED PFD SER A 8.25% | 0 | 1 | 2011-06-06 | ? | 0 | no | no | no | 2011-06-06 | ? | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2446595 | 2446594 | EQUITY | CHANGE | 903002202 | CUM RED PFD SER A 8.25% | 0 | 1 | 2011-06-06 | ? | 4 | no | no | no | 2011-06-06 | ? | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2312002 | 2312002 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2016-11-10 | 2016-11-15 | 2016-12-15 | 2016-10-03 | 0 | 2016-10-03 | ? | 0 | 0005293979 | 20161003.ifs | 2016-10-03 | 2016-10-04 | |||||||
2241312 | 2241312 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2016-08-11 | 2016-08-15 | 2016-09-15 | 2016-07-01 | 0 | 2016-07-01 | ? | 0 | 0005246150 | 20160701.ifs | 2016-07-01 | 2016-07-02 | |||||||
2157189 | 2157189 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2016-05-12 | 2016-05-16 | 2016-06-15 | 2016-04-04 | 0 | 2016-04-04 | ? | 0 | 0005203511 | 20160404.ifs | 2016-04-04 | 2016-04-05 | |||||||
2096170 | 2096170 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2016-02-11 | 2016-02-16 | 2016-03-15 | 2016-01-20 | 0 | 2016-01-21 | ? | 0 | 0005161365 | 20160121.ifs | 2016-01-21 | 2016-01-22 | |||||||
1981120 | 1981120 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2015-11-12 | 2015-11-16 | 2015-12-15 | 2015-10-01 | 0 | 2015-10-01 | ? | 0 | 0005074701 | 20151001.ifs | 2015-10-01 | 2015-10-02 | |||||||
1905607 | 1905607 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2015-08-13 | 2015-08-17 | 2015-09-15 | 2015-07-01 | 0 | 2015-07-01 | ? | 0 | 0005026587 | 20150701.ifs | 2015-07-01 | 2015-07-02 | |||||||
1830462 | 1830462 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2015-05-13 | 2015-05-15 | 2015-06-15 | 2015-04-01 | 0 | 2015-04-01 | ? | 0 | 0004980430 | 20150401.ifs | 2015-04-01 | 2015-04-02 | |||||||
1772305 | 1772305 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2015-02-12 | 2015-02-17 | 2015-03-16 | 2015-01-21 | 0 | 2015-01-21 | ? | 0 | 0004942859 | 20150121.ifs | 2015-01-21 | 2015-01-22 | |||||||
1647348 | 1647348 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2014-11-13 | 2014-11-17 | 2014-12-15 | 2014-10-01 | 0 | 2014-10-01 | ? | 0 | 0004854436 | 20141001.ifs | 2014-10-01 | 2014-10-02 | |||||||
1570792 | 1570792 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2014-08-13 | 2014-08-15 | 2014-09-15 | 2014-07-01 | 0 | 2014-07-01 | ? | 0 | 0004808812 | 20140701.ifs | 2014-07-01 | 2014-07-02 | |||||||
1485947 | 1485947 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2014-05-13 | 2014-05-15 | 2014-06-16 | 2014-04-01 | 0 | 2014-04-01 | ? | 0 | 0004762296 | 20140401.ifs | 2014-04-01 | 2014-04-02 | |||||||
1422738 | 1422738 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2014-02-13 | 2014-02-18 | 2014-03-17 | 2014-01-15 | 0 | 2014-01-15 | ? | 0 | 0004724275 | 20140115.ifs | 2014-01-15 | 2014-01-16 | |||||||
1305942 | 1305942 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2013-11-13 | 2013-11-15 | 2013-12-16 | 2013-10-01 | 0 | 2013-10-01 | ? | 0 | 0004640266 | 20131001.ifs | 2013-10-01 | 2013-10-02 | |||||||
1228837 | 1228837 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2013-08-13 | 2013-08-15 | 2013-09-16 | 2013-07-01 | 0 | 2013-07-01 | ? | 0 | 0004596285 | 20130701.ifs | 2013-07-01 | 2013-07-02 | |||||||
1156750 | 1156750 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2013-05-13 | 2013-05-15 | 2013-06-17 | 2013-04-08 | 0 | 2013-04-08 | ? | 0 | 0004556742 | 20130408.ifs | 2013-04-08 | 2013-04-09 | |||||||
1091181 | 1091181 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2013-02-13 | 2013-02-15 | 2013-03-15 | 2013-01-16 | 0 | 2013-01-16 | ? | 0 | 0004515468 | 20130116.ifs | 2013-01-16 | 2013-01-17 | |||||||
972443 | 972443 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2012-11-13 | 2012-11-15 | 2012-12-17 | 2012-10-01 | 0 | 2012-10-01 | ? | 0 | 0004439334 | 20121001.ifs | 2012-10-01 | 2012-10-02 | |||||||
910190 | 910190 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2012-08-13 | 2012-08-15 | 2012-09-17 | 2012-07-09 | 0 | 2012-07-09 | ? | 0 | 0004401777 | 20120709.ifs | 2012-07-09 | 2012-07-10 | |||||||
836689 | 836689 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2012-05-11 | 2012-05-15 | 2012-06-15 | 2012-04-17 | 0 | 2012-04-17 | ? | 0 | 0004361928 | 20120417.ifs | 2012-04-17 | 2012-04-18 | |||||||
795713 | 795713 | CORPACTION | ADD | 903002202 | 02 | X | 2012-03-02 | 903002202 | 01 | ? | 20120302.ifs | 2012-03-02 | 2012-03-03 | ||||||||||||||||
795714 | 795714 | EXCHANGE | ADD | 903002202 | 01 | 2012-03-02 | 2012-03-02 | UMH_PA | 0 | 1 | 2012-03-02 | ? | 20120302.ifs | 2012-03-02 | 2012-03-03 | ||||||||||||||
758303 | 758303 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2012-02-13 | 2012-02-15 | 2012-03-15 | 2012-01-18 | 0 | 2012-01-18 | ? | 0 | 0004321348 | 20120118.ifs | 2012-01-18 | 2012-01-19 | |||||||
666327 | 666327 | DIVIDEND | ADD | 903002202 | 0 | 0 | 1 | 0 | .515625 | 00 | 2011-11-10 | 2011-11-15 | 2011-12-15 | 2011-10-04 | 0 | 2011-10-04 | ? | 0 | 0004254970 | 20111004.ifs | 2011-10-04 | 2011-10-05 |
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 = 159614
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