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:160330 |
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 | ||
2293358 | 2293358 | CORPACTION | ADD | 045488202 | 01 | C | 2016-09-15 | ? | 20160915.ifs | 2016-09-15 | 2016-09-16 | ||||||||||||||||||
2293359 | 2293359 | EQUITY | CHANGE | 045488202 | DEPOSITARY SH REPSTG 1/40TH INT SH PERPETUAL PFD STK SER B | 0 | 1 | 2011-09-09 | ? | 0 | no | no | no | 2011-09-09 | ? | ? | 20160915.ifs | 2016-09-15 | 2016-09-16 | ||||||||||
2293360 | 2293359 | EQUITY | CHANGE | 045488202 | DEPOSITARY SH REPSTG 1/40TH INT SH PERPETUAL PFD STK SER B | C | 1 | 2011-09-09 | 2016-09-15 | 0 | no | no | no | 2011-09-09 | 2016-09-15 | ? | 20160915.ifs | 2016-09-15 | 2016-09-16 | ||||||||||
2257470 | 2257470 | DIVIDEND | ADD | 045488202 | 0 | 0 | C | 0 | 25 | 0 | 12 | ? | ? | 2016-09-15 | 2016-07-27 | 0 | ? | 2016-07-27 | 0 | 20160727.ifs | 2016-07-27 | 2016-07-28 | |||||||
2257376 | 2257376 | DIVIDEND | ADD | 045488202 | 0 | 0 | 1 | 0 | .5 | 00 | 2016-08-30 | 2016-09-01 | 2016-09-15 | 2016-07-26 | 0 | 2016-07-26 | ? | 0 | 0005254237 | 20160726.ifs | 2016-07-26 | 2016-07-27 | |||||||
2179220 | 2179220 | DIVIDEND | ADD | 045488202 | 0 | 0 | 1 | 0 | .5 | 00 | 2016-05-27 | 2016-06-01 | 2016-06-15 | 2016-04-26 | 0 | 2016-04-26 | ? | 0 | 0005208213 | 20160426.ifs | 2016-04-26 | 2016-04-27 | |||||||
2108445 | 2108445 | DIVIDEND | ADD | 045488202 | 0 | 0 | 1 | 0 | .5 | 00 | 2016-02-26 | 2016-03-01 | 2016-03-15 | 2016-02-02 | 0 | 2016-02-02 | ? | 0 | 0005170471 | 20160202.ifs | 2016-02-02 | 2016-02-03 | |||||||
1993664 | 1993664 | DIVIDEND | ADD | 045488202 | 0 | 0 | 1 | 0 | .5 | 00 | 2015-11-27 | 2015-12-01 | 2015-12-15 | 2015-10-20 | 0 | 2015-10-20 | ? | 0 | 0005080787 | 20151020.ifs | 2015-10-20 | 2015-10-21 | |||||||
1922010 | 1922010 | DIVIDEND | ADD | 045488202 | 0 | 0 | 1 | 0 | .5 | 00 | 2015-08-28 | 2015-09-01 | 2015-09-15 | 2015-07-21 | 0 | 2015-07-23 | ? | 2 | 0005034908 | 20150723.ifs | 2015-07-23 | 2015-07-24 | |||||||
1844548 | 1844548 | DIVIDEND | ADD | 045488202 | 0 | 0 | 1 | 0 | .5 | 00 | 2015-05-28 | 2015-06-01 | 2015-06-15 | 2015-04-21 | 0 | 2015-04-21 | ? | 0 | 0004987945 | 20150421.ifs | 2015-04-21 | 2015-04-22 | |||||||
1785706 | 1785706 | DIVIDEND | ADD | 045488202 | 0 | 0 | 1 | 0 | .5 | 00 | 2015-02-26 | 2015-03-02 | 2015-03-16 | 2015-02-03 | 0 | 2015-02-03 | ? | 0 | 0004952310 | 20150203.ifs | 2015-02-03 | 2015-02-04 | |||||||
1739083 | 1739083 | CORPACTION | ADD | 045488202 | 01 | # | 2014-12-23 | 045488202 | 01 | ? | 20141223.ifs | 2014-12-23 | 2014-12-24 | ||||||||||||||||
1739084 | 1739084 | CORPACTIONAUX | ADD | 045488202 | 01 | 2014-12-23 | ABW_PB | ASSOCIATED BANC-CORP WIS | DEPOSITARY SH R | ASB_PB | ASSOCIATED BANC-CORP WIS | DEPOSITARY SH R | 2014-12-23 | ? | 20141223.ifs | 2014-12-23 | 2014-12-24 | ||||||||||||
1739085 | 1739085 | EXCHANGE | CHANGE | 045488202 | 01 | 2011-10-10 | 2014-12-22 | ABW_PB | 0 | 1 | 2011-10-10 | ? | 20141223.ifs | 2014-12-23 | 2014-12-24 | ||||||||||||||
1739086 | 1739085 | EXCHANGE | CHANGE | 045488202 | 01 | 2011-10-10 | 2014-12-22 | ASB_PB | 0 | 1 | 2011-10-10 | 2014-12-23 | 20141223.ifs | 2014-12-23 | 2014-12-24 | ||||||||||||||
1676262 | 1676262 | DIVIDEND | ADD | 045488202 | 0 | 0 | 1 | 0 | .5 | 00 | 2014-11-26 | 2014-12-01 | 2014-12-15 | 2014-10-28 | 0 | 2014-11-05 | ? | 0 | 0004871008 | 20141105.ifs | 2014-11-05 | 2014-11-06 | |||||||
1584868 | 1584868 | DIVIDEND | ADD | 045488202 | 0 | 0 | 1 | 0 | .5 | 00 | 2014-08-28 | 2014-09-02 | 2014-09-15 | 2014-07-22 | 0 | 2014-07-22 | ? | 0 | 0004816832 | 20140722.ifs | 2014-07-22 | 2014-07-23 | |||||||
1504470 | 1504470 | DIVIDEND | ADD | 045488202 | 0 | 0 | 1 | 0 | .5 | 00 | 2014-05-29 | 2014-06-02 | 2014-06-16 | 2014-04-22 | 0 | 2014-04-29 | ? | 0 | 0004772157 | 20140429.ifs | 2014-04-29 | 2014-04-30 | |||||||
1437813 | 1437813 | DIVIDEND | DELETE | 045488202 | 0 | 0 | 1 | 0 | .5 | 00 | 2014-02-27 | 2014-03-03 | 2014-03-15 | 2014-01-28 | 0 | 2014-01-28 | ? | 0 | 0004726593 | 20140203.ifs | 2014-02-03 | 2014-02-04 | |||||||
1437814 | 1437814 | DIVIDEND | ADD | 045488202 | 0 | 0 | 1 | 0 | .5 | 00 | 2014-02-27 | 2014-03-03 | 2014-03-17 | 2014-01-28 | 1 | 2014-01-28 | 2014-02-03 | 0 | 0004726593 | 20140203.ifs | 2014-02-03 | 2014-02-04 | |||||||
1428824 | 1428824 | DIVIDEND | ADD | 045488202 | 0 | 0 | 1 | 0 | .5 | 00 | 2014-02-27 | 2014-03-03 | 2014-03-15 | 2014-01-28 | 0 | 2014-01-28 | ? | 0 | 0004726593 | 20140128.ifs | 2014-01-28 | 2014-01-29 | |||||||
1321015 | 1321015 | DIVIDEND | ADD | 045488202 | 0 | 0 | 1 | 0 | .5 | 00 | 2013-11-27 | 2013-12-02 | 2013-12-16 | 2013-10-22 | 0 | 2013-10-22 | ? | 0 | 0004646825 | 20131022.ifs | 2013-10-22 | 2013-10-23 | |||||||
1263093 | 1263093 | DIVIDEND | ADD | 045488202 | 0 | 0 | 1 | 0 | .5 | 00 | 2013-08-29 | 2013-09-03 | 2013-09-16 | 2013-07-23 | 0 | 2013-08-12 | ? | 0 | 0004614978 | 20130812.ifs | 2013-08-12 | 2013-08-13 | |||||||
1165501 | 1165501 | DIVIDEND | ADD | 045488202 | 0 | 0 | 1 | 0 | .5 | 00 | 2013-05-30 | 2013-06-03 | 2013-06-17 | 2013-04-23 | 0 | 2013-04-23 | ? | 0 | 0004559943 | 20130423.ifs | 2013-04-23 | 2013-04-24 | |||||||
1094753 | 1094753 | DIVIDEND | ADD | 045488202 | 0 | 0 | 1 | 0 | .5 | 00 | 2013-02-27 | 2013-03-01 | 2013-03-15 | 2013-01-22 | 0 | 2013-01-23 | ? | 0 | 0004517000 | 20130123.ifs | 2013-01-23 | 2013-01-24 | |||||||
1009895 | 1009895 | DIVIDEND | ADD | 045488202 | 0 | 0 | 1 | 0 | .5 | 00 | 2012-11-29 | 2012-12-03 | 2012-12-17 | 2012-11-13 | 0 | 2012-11-14 | ? | 0 | 0004458032 | 20121114.ifs | 2012-11-14 | 2012-11-15 | |||||||
931243 | 931243 | DIVIDEND | ADD | 045488202 | 0 | 0 | 1 | 0 | .5 | 00 | 2012-08-30 | 2012-09-04 | 2012-09-15 | 2012-08-08 | 0 | 2012-08-08 | ? | 0 | 0004414784 | 20120808.ifs | 2012-08-08 | 2012-08-09 | |||||||
780125 | 780125 | DIVIDEND | ADD | 045488202 | 0 | 0 | 1 | 0 | .5 | 00 | 2012-02-28 | 2012-03-01 | 2012-03-15 | 2012-02-15 | 0 | 2012-02-15 | ? | 0 | 0004333045 | 20120215.ifs | 2012-02-15 | 2012-02-16 | |||||||
709982 | 709982 | DIVIDEND | ADD | 045488202 | 0 | 0 | 1 | 4 | .5 | 00 | 2011-12-08 | 2011-12-12 | 2011-12-15 | 2011-12-01 | 0 | 2011-12-01 | ? | 0 | 0004276930 | 20111201.ifs | 2011-12-01 | 2011-12-02 | |||||||
670285 | 670285 | CORPACTION | ADD | 045488202 | 66 | X | 2011-10-10 | 045488202 | 01 | ? | 20111010.ifs | 2011-10-10 | 2011-10-11 | ||||||||||||||||
670286 | 670286 | EXCHANGE | ADD | 045488202 | 01 | 2011-10-10 | 2011-10-10 | ABW_PB | 0 | 1 | 2011-10-10 | ? | 20111010.ifs | 2011-10-10 | 2011-10-11 | ||||||||||||||
639993 | 639993 | EQUITY | ADD | 045488202 | DEPOSITARY SH REPSTG 1/40TH INT SH PERPETUAL PFD STK SER B | N | 1 | 2011-09-09 | ? | 0 | no | no | no | 2011-09-09 | ? | ? | 20110909.ifs | 2011-09-09 | 2011-09-10 | ||||||||||
639994 | 639994 | EXCHANGE | ADD | 045488202 | 66 | 2011-09-09 | 2011-09-09 | ASBCP | 0 | 1 | 2011-09-09 | ? | 20110909.ifs | 2011-09-09 | 2011-09-10 | ||||||||||||||
640553 | 640553 | EQUITY | CHANGE | 045488202 | DEPOSITARY SH REPSTG 1/40TH INT SH PERPETUAL PFD STK SER B | N | 1 | 2011-09-09 | ? | 0 | no | no | no | 2011-09-09 | ? | ? | 20110909.ifs | 2011-09-09 | 2011-09-10 | ||||||||||
640554 | 640553 | EQUITY | CHANGE | 045488202 | DEPOSITARY SH REPSTG 1/40TH INT SH PERPETUAL PFD STK SER B | 0 | 1 | 2011-09-09 | ? | 0 | no | no | no | 2011-09-09 | ? | ? | 20110909.ifs | 2011-09-09 | 2011-09-10 |
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 = 160330
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