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:159967 |
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 | ||
5481201 | 5481201 | CORPACTION | ADD | 21988T207 | 66 | D | 2024-01-17 | ? | 20240117.ifs | 2024-01-17 | 2024-01-18 | ||||||||||||||||||
5481202 | 5481202 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | 0 | 0 | 2007-02-16 | ? | 2 | no | no | no | 2007-02-16 | 2020-06-25 | ? | 20240117.ifs | 2024-01-17 | 2024-01-18 | ||||||||||
5481203 | 5481202 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | D | 0 | 2007-02-16 | 2024-01-17 | 2 | no | no | no | 2007-02-16 | 2024-01-17 | ? | 20240117.ifs | 2024-01-17 | 2024-01-18 | ||||||||||
4399994 | 4399994 | CORPACTION | DELETE | 21988T207 | 01 | D | 2020-05-19 | 2020-05-20 | 20200625.ifs | 2020-06-25 | 2020-06-26 | ||||||||||||||||||
4399995 | 4399995 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | D | 0 | 2007-02-16 | 2020-06-18 | 2 | no | no | no | 2007-02-16 | 2020-06-18 | ? | 20200625.ifs | 2020-06-25 | 2020-06-26 | ||||||||||
4399996 | 4399995 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | 0 | 0 | 2007-02-16 | ? | 2 | no | no | no | 2007-02-16 | 2020-06-25 | ? | 20200625.ifs | 2020-06-25 | 2020-06-26 | ||||||||||
4393933 | 4393933 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | D | 0 | 2007-02-16 | 2020-06-03 | 2 | no | no | no | 2007-02-16 | 2020-06-03 | ? | 20200618.ifs | 2020-06-18 | 2020-06-19 | ||||||||||
4393934 | 4393933 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | D | 0 | 2007-02-16 | 2020-06-18 | 2 | no | no | no | 2007-02-16 | 2020-06-18 | ? | 20200618.ifs | 2020-06-18 | 2020-06-19 | ||||||||||
4393935 | 4393935 | CORPACTION | ADD | 21988T207 | 01 | X | 2020-06-18 | 21988T207 | 66 | ? | 20200618.ifs | 2020-06-18 | 2020-06-19 | ||||||||||||||||
4393936 | 4393936 | EXCHANGE | ADD | 21988T207 | 66 | 2020-06-18 | ? | CBTRP | 0 | 0 | 2020-06-18 | ? | 20200618.ifs | 2020-06-18 | 2020-06-19 | ||||||||||||||
4385348 | 4385348 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | D | 0 | 2007-02-16 | 2020-05-19 | 2 | no | no | no | 2007-02-16 | 2020-05-20 | ? | 20200603.ifs | 2020-06-03 | 2020-06-04 | ||||||||||
4385349 | 4385348 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | D | 0 | 2007-02-16 | 2020-06-03 | 2 | no | no | no | 2007-02-16 | 2020-06-03 | ? | 20200603.ifs | 2020-06-03 | 2020-06-04 | ||||||||||
4385845 | 4385845 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | D | 0 | 2007-02-16 | 2020-05-19 | 2 | no | no | no | 2007-02-16 | 2020-05-20 | ? | 20200603.ifs | 2020-06-03 | 2020-06-04 | ||||||||||
4385846 | 4385845 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | D | 0 | 2007-02-16 | 2020-06-03 | 2 | no | no | no | 2007-02-16 | 2020-06-03 | ? | 20200603.ifs | 2020-06-03 | 2020-06-04 | ||||||||||
4341691 | 4341691 | CORPACTION | ADD | 21988T207 | 01 | S | 2020-05-20 | 2020-05-20 | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||||||||||
4341692 | 4341692 | CORPACTION | ADD | 21988T207 | 01 | S | 2020-05-20 | 2020-05-20 | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||||||||||
4341693 | 4341693 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | 0 | 0 | 2007-02-16 | ? | 2 | no | no | no | 2007-02-16 | ? | ? | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||
4341694 | 4341693 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | S | 0 | 2007-02-16 | 2020-05-20 | 2 | no | no | no | 2007-02-16 | 2020-05-20 | ? | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||
4341695 | 4341695 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | 0 | 0 | 2007-02-16 | ? | 2 | no | no | no | 2007-02-16 | ? | ? | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||
4341697 | 4341696 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | S | 0 | 2007-02-16 | 2020-05-20 | 2 | no | no | no | 2007-02-16 | 2020-05-20 | ? | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||
4341702 | 4341702 | CORPACTION | DELETE | 21988T207 | 01 | S | 2020-05-20 | 2020-05-20 | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||||||||||
4341704 | 4341704 | CORPACTION | ADD | 21988T207 | 01 | S | 2020-05-19 | 2020-05-20 | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||||||||||
4341705 | 4341705 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | S | 0 | 2007-02-16 | 2020-05-20 | 2 | no | no | no | 2007-02-16 | 2020-05-20 | ? | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||
4341706 | 4341706 | CORPACTION | DELETE | 21988T207 | 01 | S | 2020-05-20 | 2020-05-20 | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||||||||||
4341707 | 4341706 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | S | 0 | 2007-02-16 | 2020-05-19 | 2 | no | no | no | 2007-02-16 | 2020-05-20 | ? | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||
4341708 | 4341708 | CORPACTION | ADD | 21988T207 | 01 | S | 2020-05-19 | 2020-05-20 | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||||||||||
4341710 | 4341710 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | S | 0 | 2007-02-16 | 2020-05-20 | 2 | no | no | no | 2007-02-16 | 2020-05-20 | ? | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||
4341712 | 4341711 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | S | 0 | 2007-02-16 | 2020-05-19 | 2 | no | no | no | 2007-02-16 | 2020-05-20 | ? | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||
4341911 | 4341911 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | S | 0 | 2007-02-16 | 2020-05-19 | 2 | no | no | no | 2007-02-16 | 2020-05-20 | ? | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||
4341913 | 4341912 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | D | 0 | 2007-02-16 | 2020-05-19 | 2 | no | no | no | 2007-02-16 | 2020-05-20 | ? | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||
4341950 | 4341950 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | S | 0 | 2007-02-16 | 2020-05-19 | 2 | no | no | no | 2007-02-16 | 2020-05-20 | ? | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||
4341952 | 4341951 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | D | 0 | 2007-02-16 | 2020-05-19 | 2 | no | no | no | 2007-02-16 | 2020-05-20 | ? | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||
4342134 | 4342133 | EXCHANGE | ADD | 21988T207 | 01 | S | 2020-05-19 | 2020-05-20 | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||||||||||
4342135 | 4342134 | EXCHANGE | ADD | 21988T207 | 01 | D | 2020-05-19 | 2020-05-20 | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||||||||||
4342216 | 4342215 | EXCHANGE | ADD | 21988T207 | 01 | S | 2020-05-19 | 2020-05-20 | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||||||||||
4342218 | 4342217 | EXCHANGE | ADD | 21988T207 | 01 | D | 2020-05-19 | 2020-05-20 | 20200520.ifs | 2020-05-20 | 2020-05-21 | ||||||||||||||||||
4341252 | 4341252 | DIVIDEND | DELETE | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2020-08-28 | 2020-08-31 | 2020-09-01 | 2020-01-21 | 0 | 2020-01-21 | ? | 1 | 0006043877 | 20200519.ifs | 2020-05-19 | 2020-05-20 | |||||||
4341269 | 4341269 | DIVIDEND | DELETE | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2020-08-28 | 2020-08-31 | 2020-09-01 | 2020-01-21 | 0 | 2020-01-21 | ? | 1 | 0006043877 | 20200519.ifs | 2020-05-19 | 2020-05-20 | |||||||
4173843 | 4173843 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2020-08-28 | 2020-08-31 | 2020-09-01 | 2020-01-21 | 0 | 2020-01-21 | ? | 1 | 0006043877 | 20200121.ifs | 2020-01-21 | 2020-01-22 | |||||||
4173845 | 4173845 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2020-02-27 | 2020-02-28 | 2020-03-01 | 2020-01-21 | 0 | 2020-01-21 | ? | 0 | 0006043873 | 20200121.ifs | 2020-01-21 | 2020-01-22 | |||||||
4173848 | 4173848 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2020-08-28 | 2020-08-31 | 2020-09-01 | 2020-01-21 | 0 | 2020-01-21 | ? | 1 | 0006043877 | 20200121.ifs | 2020-01-21 | 2020-01-22 | |||||||
4173850 | 4173850 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2020-02-27 | 2020-02-28 | 2020-03-01 | 2020-01-21 | 0 | 2020-01-21 | ? | 0 | 0006043873 | 20200121.ifs | 2020-01-21 | 2020-01-22 | |||||||
3547408 | 3547408 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2019-08-29 | 2019-08-30 | 2019-09-01 | 2019-01-10 | 0 | 2019-01-10 | ? | 1 | 0005825321 | 20190110.ifs | 2019-01-10 | 2019-01-11 | |||||||
3547410 | 3547410 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2019-02-27 | 2019-02-28 | 2019-03-01 | 2019-01-10 | 0 | 2019-01-10 | ? | 0 | 0005825320 | 20190110.ifs | 2019-01-10 | 2019-01-11 | |||||||
3547777 | 3547777 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2019-08-29 | 2019-08-30 | 2019-09-01 | 2019-01-10 | 0 | 2019-01-10 | ? | 1 | 0005825321 | 20190110.ifs | 2019-01-10 | 2019-01-11 | |||||||
3547778 | 3547778 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2019-02-27 | 2019-02-28 | 2019-03-01 | 2019-01-10 | 0 | 2019-01-10 | ? | 0 | 0005825320 | 20190110.ifs | 2019-01-10 | 2019-01-11 | |||||||
2915967 | 2915967 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2018-08-30 | 2018-08-31 | 2018-09-04 | 2018-01-09 | 0 | 2018-01-09 | ? | 1 | 0005601209 | 20180109.ifs | 2018-01-09 | 2018-01-10 | |||||||
2915969 | 2915969 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2018-02-27 | 2018-02-28 | 2018-03-01 | 2018-01-09 | 0 | 2018-01-09 | ? | 0 | 0005601208 | 20180109.ifs | 2018-01-09 | 2018-01-10 | |||||||
2915980 | 2915980 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2018-08-30 | 2018-08-31 | 2018-09-04 | 2018-01-09 | 0 | 2018-01-09 | ? | 1 | 0005601209 | 20180109.ifs | 2018-01-09 | 2018-01-10 | |||||||
2915982 | 2915982 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2018-02-27 | 2018-02-28 | 2018-03-01 | 2018-01-09 | 0 | 2018-01-09 | ? | 0 | 0005601208 | 20180109.ifs | 2018-01-09 | 2018-01-10 | |||||||
2449820 | 2449820 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | 0 | 0 | 2007-02-16 | ? | 0 | no | no | no | 2007-02-16 | ? | ? | 20170124.ifs | 2017-01-24 | 2017-01-25 | ||||||||||
2449821 | 2449820 | EQUITY | CHANGE | 21988T207 | JC PENNEY DEB BKD 2007 1 CTF CL A-1 | 0 | 0 | 2007-02-16 | ? | 2 | no | no | no | 2007-02-16 | ? | ? | 20170124.ifs | 2017-01-24 | 2017-01-25 | ||||||||||
2423796 | 2423796 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2017-08-29 | 2017-08-31 | 2017-09-01 | 2017-01-09 | 0 | 2017-01-10 | ? | 0 | 0005374095 | 20170110.ifs | 2017-01-10 | 2017-01-11 | |||||||
2303190 | 2303190 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2017-02-24 | 2017-02-28 | 2017-03-01 | 2016-09-27 | 0 | 2016-09-27 | ? | 0 | 0005285860 | 20160927.ifs | 2016-09-27 | 2016-09-28 | |||||||
2268087 | 2268087 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2016-08-29 | 2016-08-31 | 2016-09-01 | 2016-08-08 | 0 | 2016-08-08 | ? | 0 | 0005264354 | 20160808.ifs | 2016-08-08 | 2016-08-09 | |||||||
2110811 | 2110811 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2016-02-25 | 2016-02-29 | 2016-03-01 | 2016-02-08 | 0 | 2016-02-08 | ? | 0 | 0005171334 | 20160208.ifs | 2016-02-08 | 2016-02-09 | |||||||
1821821 | 1821821 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2015-08-27 | 2015-08-31 | 2015-09-01 | 2015-03-25 | 0 | 2015-03-26 | ? | 0 | 0004973734 | 20150326.ifs | 2015-03-26 | 2015-03-27 | |||||||
1786551 | 1786551 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2015-02-25 | 2015-02-27 | 2015-03-02 | 2015-02-04 | 0 | 2015-02-04 | ? | 0 | 0004952801 | 20150204.ifs | 2015-02-04 | 2015-02-05 | |||||||
1526103 | 1526103 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2014-08-27 | 2014-08-29 | 2014-09-01 | 2014-05-19 | 0 | 2014-05-19 | ? | 0 | 0004783209 | 20140519.ifs | 2014-05-19 | 2014-05-20 | |||||||
1441846 | 1441846 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2014-02-26 | 2014-02-28 | 2014-03-03 | 2014-02-07 | 0 | 2014-02-10 | ? | 0 | 0004735503 | 20140210.ifs | 2014-02-10 | 2014-02-11 | |||||||
1248844 | 1248844 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2013-08-28 | 2013-08-30 | 2013-09-03 | 2013-07-29 | 0 | 2013-07-29 | ? | 0 | 0004605038 | 20130729.ifs | 2013-07-29 | 2013-07-30 | |||||||
1110903 | 1110903 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2013-02-26 | 2013-02-28 | 2013-03-01 | 2013-02-11 | 0 | 2013-02-11 | ? | 0 | 0004527401 | 20130211.ifs | 2013-02-11 | 2013-02-12 | |||||||
1080992 | 1080992 | DIVIDEND | DELETE | 21988T207 | 0 | 1 | 1 | 0 | .875 | 14 | 2012-02-27 | 2012-02-29 | 2012-03-01 | 2013-01-03 | 0 | 2013-01-03 | ? | 0 | 0004315135 | 20130104.ifs | 2013-01-04 | 2013-01-05 | |||||||
1077982 | 1077982 | DIVIDEND | ADD | 21988T207 | 0 | 1 | 1 | 0 | .875 | 14 | 2012-02-27 | 2012-02-29 | 2012-03-01 | 2013-01-03 | 0 | 2013-01-03 | ? | 0 | 0004315135 | 20130103.ifs | 2013-01-03 | 2013-01-04 | |||||||
926120 | 926120 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2012-08-29 | 2012-08-31 | 2012-09-01 | 2012-08-03 | 0 | 2012-08-03 | ? | 0 | 0004413876 | 20120803.ifs | 2012-08-03 | 2012-08-04 | |||||||
748422 | 748422 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2012-02-27 | 2012-02-29 | 2012-03-01 | 2012-01-03 | 0 | 2012-01-03 | ? | 0 | 0004315135 | 20120103.ifs | 2012-01-03 | 2012-01-04 | |||||||
612536 | 612536 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2011-08-29 | 2011-08-31 | 2011-09-01 | 2011-08-10 | 0 | 2011-08-10 | ? | 0 | 0004228967 | 20110810.ifs | 2011-08-10 | 2011-08-11 | |||||||
443450 | 443450 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2011-02-24 | 2011-02-28 | 2011-03-01 | 2011-02-15 | 0 | 2011-02-15 | ? | 0 | 0004147199 | 20110215.ifs | 2011-02-15 | 2011-02-16 | |||||||
277331 | 277331 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2010-08-27 | 2010-08-31 | 2010-09-01 | 2010-08-11 | 0 | 2010-08-11 | ? | 0 | 0004046664 | 20100811.ifs | 2010-08-11 | 2010-08-12 | |||||||
111842 | 111842 | DIVIDEND | ADD | 21988T207 | 0 | 0 | 1 | 0 | .875 | 00 | 2010-02-24 | 2010-02-26 | 2010-03-01 | 2010-02-17 | 0 | 2010-02-17 | ? | 0 | 0003966031 | 20100217.ifs | 2010-02-17 | 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 = 159967
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