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:130770 |
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 | ||
938652 | 938652 | CORPACTION | ADD | 46133K108 | 01 | M | 2012-08-27 | 46131F101 | 01 | ? | 20120827.ifs | 2012-08-27 | 2012-08-28 | ||||||||||||||||
938653 | 938653 | EQUITY | CHANGE | 46133K108 | COM | 0 | 7 | 2010-06-01 | ? | 0 | no | no | no | 2010-06-01 | 2010-06-01 | ? | 20120827.ifs | 2012-08-27 | 2012-08-28 | ||||||||||
938654 | 938653 | EQUITY | CHANGE | 46133K108 | COM | M | 7 | 2010-06-01 | 2012-08-27 | 0 | no | no | 46131F101 | no | 2010-06-01 | 2012-08-27 | ? | 20120827.ifs | 2012-08-27 | 2012-08-28 | |||||||||
939009 | 939009 | DIVIDEND | CHANGE | 46133K108 | 0 | 0 | 1 | 0 | .1258 | 00 | 2012-08-22 | 2012-08-24 | 2012-08-31 | 2012-08-20 | 1 | 2012-08-20 | 2012-08-21 | 0 | 0004417113 | 20120827.ifs | 2012-08-27 | 2012-08-28 | |||||||
939010 | 939009 | DIVIDEND | CHANGE | 46133K108 | 0 | 0 | 1 | 0 | .1258 | 00 | 2012-08-22 | 2012-08-24 | 2012-08-31 | 2012-08-20 | 2 | 2012-08-20 | 2012-08-27 | 0 | 0004417113 | 20120827.ifs | 2012-08-27 | 2012-08-28 | |||||||
936543 | 936543 | DIVIDEND | CHANGE | 46133K108 | 0 | 0 | 1 | 0 | .1258 | 00 | 2012-08-22 | 2012-08-24 | 2012-08-31 | 2012-08-20 | 0 | 2012-08-20 | ? | 0 | 0004417113 | 20120821.ifs | 2012-08-21 | 2012-08-22 | |||||||
936544 | 936543 | DIVIDEND | CHANGE | 46133K108 | 0 | 0 | 1 | 0 | .1258 | 00 | 2012-08-22 | 2012-08-24 | 2012-08-31 | 2012-08-20 | 1 | 2012-08-20 | 2012-08-21 | 0 | 0004417113 | 20120821.ifs | 2012-08-21 | 2012-08-22 | |||||||
935809 | 935809 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .1258 | 00 | 2012-08-22 | 2012-08-24 | 2012-08-31 | 2012-08-20 | 0 | 2012-08-20 | ? | 0 | 0004417113 | 20120820.ifs | 2012-08-20 | 2012-08-21 | |||||||
904502 | 904502 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2012-07-12 | 2012-07-16 | 2012-07-31 | 2012-07-02 | 0 | 2012-07-02 | ? | 0 | 0004398915 | 20120702.ifs | 2012-07-02 | 2012-07-03 | |||||||
876035 | 876035 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2012-06-13 | 2012-06-15 | 2012-06-29 | 2012-06-01 | 0 | 2012-06-01 | ? | 0 | 0004382091 | 20120601.ifs | 2012-06-01 | 2012-06-02 | |||||||
851367 | 851367 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2012-05-11 | 2012-05-15 | 2012-05-31 | 2012-05-01 | 0 | 2012-05-01 | ? | 0 | 0004370182 | 20120501.ifs | 2012-05-01 | 2012-05-02 | |||||||
825406 | 825406 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2012-04-11 | 2012-04-13 | 2012-04-30 | 2012-04-02 | 0 | 2012-04-02 | ? | 0 | 0004356295 | 20120402.ifs | 2012-04-02 | 2012-04-03 | |||||||
793743 | 793743 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2012-03-12 | 2012-03-14 | 2012-03-30 | 2012-03-01 | 0 | 2012-03-01 | ? | 0 | 0004340770 | 20120301.ifs | 2012-03-01 | 2012-03-02 | |||||||
771159 | 771159 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2012-02-13 | 2012-02-15 | 2012-02-29 | 2012-02-01 | 0 | 2012-02-01 | ? | 0 | 0004328708 | 20120201.ifs | 2012-02-01 | 2012-02-02 | |||||||
747404 | 747404 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2012-01-12 | 2012-01-17 | 2012-01-31 | 2012-01-03 | 0 | 2012-01-03 | ? | 0 | 0004314693 | 20120103.ifs | 2012-01-03 | 2012-01-04 | |||||||
708653 | 708653 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2011-12-13 | 2011-12-15 | 2011-12-30 | 2011-12-01 | 0 | 2011-12-01 | ? | 0 | 0004278983 | 20111201.ifs | 2011-12-01 | 2011-12-02 | |||||||
686681 | 686681 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2011-11-14 | 2011-11-16 | 2011-11-30 | 2011-11-01 | 0 | 2011-11-01 | ? | 0 | 0004265550 | 20111101.ifs | 2011-11-01 | 2011-11-02 | |||||||
659959 | 659959 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2011-10-12 | 2011-10-14 | 2011-10-31 | 2011-09-30 | 0 | 2011-09-30 | ? | 0 | 0004249039 | 20110930.ifs | 2011-09-30 | 2011-10-01 | |||||||
633925 | 633925 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2011-09-13 | 2011-09-15 | 2011-09-30 | 2011-09-01 | 0 | 2011-09-01 | ? | 0 | 0004237917 | 20110901.ifs | 2011-09-01 | 2011-09-02 | |||||||
601263 | 601263 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2011-08-11 | 2011-08-15 | 2011-08-31 | 2011-08-01 | 0 | 2011-08-01 | ? | 0 | 0004225226 | 20110801.ifs | 2011-08-01 | 2011-08-02 | |||||||
580375 | 580375 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2011-07-13 | 2011-07-15 | 2011-07-29 | 2011-07-01 | 0 | 2011-07-01 | ? | 0 | 0004211743 | 20110701.ifs | 2011-07-01 | 2011-07-02 | |||||||
543818 | 543818 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2011-06-13 | 2011-06-15 | 2011-06-30 | 2011-06-01 | 0 | 2011-06-01 | ? | 0 | 0004195894 | 20110601.ifs | 2011-06-01 | 2011-06-02 | |||||||
516628 | 516628 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2011-05-11 | 2011-05-13 | 2011-05-31 | 2011-05-02 | 0 | 2011-05-02 | ? | 0 | 0004182768 | 20110502.ifs | 2011-05-02 | 2011-05-03 | |||||||
491851 | 491851 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2011-04-13 | 2011-04-15 | 2011-04-29 | 2011-04-01 | 0 | 2011-04-01 | ? | 0 | 0004170686 | 20110401.ifs | 2011-04-01 | 2011-04-02 | |||||||
460080 | 460080 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2011-03-11 | 2011-03-15 | 2011-03-31 | 2011-03-01 | 0 | 2011-03-01 | ? | 0 | 0004154697 | 20110301.ifs | 2011-03-01 | 2011-03-02 | |||||||
433750 | 433750 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2011-02-11 | 2011-02-15 | 2011-02-28 | 2011-02-01 | 0 | 2011-02-01 | ? | 0 | 0004142411 | 20110201.ifs | 2011-02-01 | 2011-02-02 | |||||||
410037 | 410037 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2011-01-12 | 2011-01-14 | 2011-01-31 | 2011-01-03 | 0 | 2011-01-03 | ? | 0 | 0004130172 | 20110103.ifs | 2011-01-03 | 2011-01-04 | |||||||
358718 | 358718 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2010-11-26 | 2010-11-30 | 2010-12-15 | 2010-11-19 | 0 | 2010-11-19 | ? | 0 | 0004088801 | 20101119.ifs | 2010-11-19 | 2010-11-20 | |||||||
337537 | 337537 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2010-10-27 | 2010-10-29 | 2010-11-15 | 2010-10-19 | 0 | 2010-10-19 | ? | 0 | 0004075443 | 20101019.ifs | 2010-10-19 | 2010-10-20 | |||||||
310822 | 310822 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2010-09-28 | 2010-09-30 | 2010-10-15 | 2010-09-20 | 0 | 2010-09-20 | ? | 0 | 0004061644 | 20100920.ifs | 2010-09-20 | 2010-09-21 | |||||||
282151 | 282151 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2010-08-27 | 2010-08-31 | 2010-09-15 | 2010-08-20 | 0 | 2010-08-20 | ? | 0 | 0004048396 | 20100820.ifs | 2010-08-20 | 2010-08-21 | |||||||
255592 | 255592 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2010-07-28 | 2010-07-30 | 2010-08-13 | 2010-07-20 | 0 | 2010-07-20 | ? | 0 | 0004034930 | 20100720.ifs | 2010-07-20 | 2010-07-21 | |||||||
222886 | 222886 | DIVIDEND | ADD | 46133K108 | 0 | 0 | 1 | 0 | .045 | 00 | 2010-06-28 | 2010-06-30 | 2010-07-15 | 2010-06-18 | 0 | 2010-06-18 | ? | 0 | 0004019897 | 20100618.ifs | 2010-06-18 | 2010-06-19 | |||||||
204949 | 204949 | EQUITY | ADD | 46133K108 | COM | N | 0 | 2010-06-01 | ? | 0 | no | no | no | 2010-06-01 | ? | ? | 20100601.ifs | 2010-06-01 | 2010-06-02 | ||||||||||
204953 | 204953 | EXCHANGE | ADD | 46133K108 | 01 | 2010-06-01 | 2010-06-01 | MSY | 0 | 7 | 2010-06-01 | ? | 20100601.ifs | 2010-06-01 | 2010-06-02 | ||||||||||||||
206438 | 206438 | EQUITY | CHANGE | 46133K108 | COM | N | 0 | 2010-06-01 | ? | 0 | no | no | no | 2010-06-01 | ? | ? | 20100601.ifs | 2010-06-01 | 2010-06-02 | ||||||||||
206439 | 206438 | EQUITY | CHANGE | 46133K108 | COM | N | 7 | 2010-06-01 | ? | 0 | no | no | no | 2010-06-01 | 2010-06-01 | ? | 20100601.ifs | 2010-06-01 | 2010-06-02 | ||||||||||
209788 | 209788 | EQUITY | CHANGE | 46133K108 | COM | N | 7 | 2010-06-01 | ? | 0 | no | no | no | 2010-06-01 | 2010-06-01 | ? | 20100601.ifs | 2010-06-01 | 2010-06-02 | ||||||||||
209789 | 209788 | EQUITY | CHANGE | 46133K108 | COM | 0 | 7 | 2010-06-01 | ? | 0 | no | no | no | 2010-06-01 | 2010-06-01 | ? | 20100601.ifs | 2010-06-01 | 2010-06-02 |
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 = 130770
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