UPDATE data_universe SET PermSecMapEndDate = '2025-12-17' WHERE SecCode = 2886 AND Type_ = 1; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 13027 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'SIGMAFA' WHERE SecCode = 27152 AND Type_ = 10; UPDATE data_universe SET Name = 'TRACTIAL EUR1 (POST SUBDIVISION)' WHERE SecCode = 52911 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69136 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 72182 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73450 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 74375 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78146 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79892 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82841 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 83589 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'AU0000053373', RkdTicker = 'HRZ', PermIDTicker = 'HRZ', RkdSEDOL = 'BK77C0', RkdCUSIP = 'Q4704L20', RkdRIC = 'HRZ.AX', RkdDisplayRIC = 'HRZ.AX', DsPrimQtSedol = 'BK77C07' WHERE SecCode = 84618 AND Type_ = 10; UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'SPNS.OQ^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-12-18', SecMapEndDate = '2025-12-16', endDate = '2025-12-16' WHERE SecCode = 86901 AND Type_ = 1; UPDATE data_universe SET Country = 'ZAF' WHERE SecCode = 90350 AND Type_ = 10; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 90585 AND Type_ = 1; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 90625 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 55848483433.0, IsPrimaryQuote = 0.0, PermInstrStatus = 'DC', ExchCode = 'ALP', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-12-17', startDate = '2004-07-28' WHERE SecCode = 91602 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 95173 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 96748 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 96847 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 97224 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CA09237D2068', RkdTicker = 'BLR.X', RkdSEDOL = 'BNZJ3B', RkdCUSIP = '09237D20', RkdRIC = 'BLRx.CD', RkdDisplayRIC = 'BLRx.CD', DsPrimQtSedol = 'BNZJ3B4' WHERE SecCode = 98666 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98779 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-12-17', PermSecMapEndDate = '2025-12-17' WHERE SecCode = 99707 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115281 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21474928708.0, ExchCode = 'JNX' WHERE SecCode = 115378 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-12-18', SecMapEndDate = '2025-12-16', PermSecMapEndDate = '2025-12-17', endDate = '2025-12-16' WHERE SecCode = 122791 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'EQU.AX', RkdDisplayRIC = 'EQU.AX', PriInstrPermID = 232905110556.0 WHERE SecCode = 122937 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 138752 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2025-12-17', SecMapEndDate = '2025-12-16', PermQuoteRetireDate = '2025-12-17', PermSecMapEndDate = '2025-12-17', endDate = '2025-12-16' WHERE SecCode = 142639 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'DORO.ST^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-12-18', SecMapEndDate = '2025-12-17', PermQuoteRetireDate = '2025-12-18', endDate = '2025-12-17' WHERE SecCode = 145422 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 145938 AND Type_ = 10; UPDATE data_universe SET PriValQuotePermID = NULL, PermSecMapEndDate = '2025-12-17' WHERE SecCode = 146369 AND Type_ = 10; UPDATE data_universe SET PermSecMapEndDate = '2025-12-17' WHERE SecCode = 148738 AND Type_ = 1; UPDATE data_universe SET RkdRIC = 'NJOB.TE', RkdDisplayRIC = 'NJOB.TE', DsPrimQtSedol = NULL, RkdIssueStatus = 1.0, RkdExchCode = 'AKT' WHERE SecCode = 167478 AND Type_ = 10; UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2025-12-16', PermQuoteRetireDate = '2025-12-17', PermSecMapEndDate = '2025-12-17', endDate = '2025-12-16' WHERE SecCode = 196165 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 340527 AND Type_ = 10; UPDATE data_universe SET PermSecMapEndDate = '2025-12-17', endDate = '2025-12-17' WHERE SecCode = 341365 AND Type_ = 1; UPDATE data_universe SET Name = 'E & E ENTERP LTD INR10' WHERE SecCode = 402372 AND Type_ = 10; UPDATE data_universe SET RkdCUSIP = 'Q6S25M14' WHERE SecCode = 822496 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2013-06-26' WHERE SecCode = 2283948 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2551346 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'FR0014013HG9', RkdSEDOL = 'BQWP9Z', RkdCUSIP = 'F5923220', DsPrimQtSedol = 'BQWP9Z2', PermSecMapEndDate = '2025-12-17', endDate = '2025-12-17' WHERE SecCode = 2598079 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2718401 AND Type_ = 10; UPDATE data_universe SET Name = 'AANCHAL ISPAT LIMI INR10 (POST CAP RED)' WHERE SecCode = 2725363 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2731219 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'BBB.L^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-12-18', SecMapEndDate = '2025-12-17', endDate = '2025-12-17' WHERE SecCode = 2739709 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2800413 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'SILVERY DRAGON GRO ''A''CNY1' WHERE SecCode = 2800421 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2915790 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'RUDRA', RkdRIC = 'RUDR.NS', RkdDisplayRIC = 'RUDR.NS', RkdExchCode = 'NSE' WHERE SecCode = 2938937 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3023871 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'WLD.AX^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-12-17', SecMapEndDate = '2025-12-12', PermQuoteRetireDate = '2025-12-17', PermSecMapEndDate = '2025-12-17', endDate = '2025-12-12' WHERE SecCode = 3043691 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3338469 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3358501 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3400255 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3405956 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3405958 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3444651 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3735955 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4129528 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4139224 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4396359 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2025-12-17' WHERE SecCode = 4511509 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'AIW.MI^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-12-18', SecMapEndDate = '2025-12-16', PermQuoteRetireDate = '2025-12-18', endDate = '2025-12-16' WHERE SecCode = 4528014 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4594523 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'AU0000446460', RkdTicker = 'VTLDA', PermIDTicker = 'VTLDA', RkdSEDOL = 'BVK5HJ', RkdRIC = 'VTLDA.NH', RkdDisplayRIC = 'VTLDA.NH', Name = 'INVICTUS THERAPEUT NPV', DsPrimQtSedol = 'BVK5HJ9', PermSecMapEndDate = '2025-12-17', endDate = '2025-12-17' WHERE SecCode = 4608552 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4617629 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4627839 AND Type_ = 10; UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'MCH.HNO^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-18', SecMapEndDate = '2025-12-17', PermQuoteRetireDate = '2025-12-18', PermSecMapEndDate = '2025-12-17', endDate = '2025-12-17' WHERE SecCode = 4687568 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'LOC.AX^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-12-17', SecMapEndDate = '2025-12-11', PermQuoteRetireDate = '2025-12-17', PermSecMapEndDate = '2025-12-17', endDate = '2025-12-11' WHERE SecCode = 4702545 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4702568 AND Type_ = 10; UPDATE data_universe SET PriValQuotePermID = 236800600615.0 WHERE SecCode = 4812249 AND Type_ = 10; UPDATE data_universe SET ModelCntry = 'AU', OrgPermID = 5085490534.0, PriInstrPermID = 21863189322.0, IsPrimaryInstr = 1.0, DomCntry = 'AUS', IncCntry = 'AUS', PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 4816848 AND Type_ = 10; UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe SET Name = 'BIOCYTOGEN PHARMAC CNY1 H' WHERE SecCode = 5140051 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5323657 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5390266 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21974026078.0, ExchCode = 'DEU' WHERE SecCode = 5452246 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5649894 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueCode = 143109.0, RelType = NULL WHERE SecCode = 6490070 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CNE100007D09' WHERE SecCode = 6520650 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CNE100007CZ3' WHERE SecCode = 6522461 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CNE100007D17' WHERE SecCode = 6522469 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CNE100007D25' WHERE SecCode = 6533618 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CNE100007D33' WHERE SecCode = 6538873 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CNE100007D41' WHERE SecCode = 6541034 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CNE100007D58' WHERE SecCode = 6556268 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6583646 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CNE100007D66' WHERE SecCode = 6587240 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CNE100007D74' WHERE SecCode = 6590965 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6590976 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'IT0005672461', RkdTicker = 'GAIN', RkdSEDOL = 'BNBVJ5', RkdCUSIP = 'T4R56C10', RkdRIC = 'GAIN.MI', RkdDisplayRIC = 'GAIN.MI', RkdCode = 143757.0, RkdIssueID = 1.0, RkdIssueCode = 183592.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'BIT', RkdExchCtry = 'ITA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6596120 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CNE100007D82' WHERE SecCode = 6601535 AND Type_ = 10; UPDATE data_universe SET Name = 'VAULT STRATEGIC MNG CORP COM SHS', PermSecMapEndDate = '2025-12-17', endDate = '2025-12-17' WHERE SecCode = 11009947 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CA7167663086', RkdSEDOL = 'BNZJ3F', RkdCUSIP = '71676630', DsPrimQtSedol = 'BNZJ3F8' WHERE SecCode = 11019667 AND Type_ = 1; UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'EVOK.OQ^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-12-18', endDate = '2025-12-18' WHERE SecCode = 11078649 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-12-18', SecMapEndDate = '2025-12-17', endDate = '2025-12-17' WHERE SecCode = 11151346 AND Type_ = 1; UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'STEP.TO^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-12-18', endDate = '2025-12-18' WHERE SecCode = 11172134 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11178785 AND Type_ = 1; UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe SET Name = 'LIGHTHOUSE GOLD INC COM' WHERE SecCode = 11199575 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG4289N1227', RkdSEDOL = 'BNZHL2', RkdCUSIP = 'G4289N12', DsPrimQtSedol = 'BNZHL25' WHERE SecCode = 11201544 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11202259 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US60879E4089', RkdSEDOL = 'BNZHRQ', RkdCUSIP = '60879E40', DsPrimQtSedol = 'BNZHRQ1' WHERE SecCode = 11203655 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11206938 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11217176 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11217561 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CA57808L3056', RkdSEDOL = 'BNZJ2K', RkdCUSIP = '57808L30', DsPrimQtSedol = 'BNZJ2K6' WHERE SecCode = 11221412 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US26145B4032', RkdSEDOL = 'BNZHST', RkdCUSIP = '26145B40', DsPrimQtSedol = 'BNZHST1' WHERE SecCode = 11229113 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'LLYVK', InfoCode = 390649, DsSecCode = 269823, DsCmpyCode = 211410, DsCtryQtStatus = 'A', DsPrimQtSedol = 'BW9HRR1', QuotePermID = 236800453717.0, InstrPermID = 232907443239.0, OrgPermID = 5057745839.0, PriTrdQuotePermID = 236800453717.0, PriValQuotePermID = 25727042352.0, PriInstrPermID = 232907443242.0, PermQuoteStatus = 'AC', IncCntry = 'USA', PriTRBCIndPermID = NULL, DsSecDelistDate = NULL, DsExchQtStartDate = '2025-12-16', SecMapStartDate = '2025-12-16', SecMapEndDate = '2079-06-06', PermQuoteRetireDate = NULL, PermOrgIPODate = '2025-12-16', PermSecMapStartDate = '2025-12-16', PermSecMapEndDate = NULL, startDate = '2025-12-16', endDate = NULL WHERE SecCode = 11256101 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US5309091008', RkdTicker = 'LLYVA', PermIDTicker = 'LLYVA', RkdSEDOL = 'BVV5T2', RkdCUSIP = '53090910', RkdRIC = 'LLYVA.O', InfoCode = 390650, DsSecCode = 269824, DsCmpyCode = 211410, DsCtryQtStatus = 'A', DsPrimQtSedol = 'BVV5T25', RkdCode = 143745.0, RkdIssueCode = 183576.0, RkdIssueStatus = 1.0, COATypeCode = '', QuotePermID = 236800453736.0, InstrPermID = 232907443242.0, OrgPermID = 5057745839.0, PriTrdQuotePermID = 236800453736.0, PriValQuotePermID = 25727042393.0, PriInstrPermID = 232907443242.0, PermQuoteStatus = 'AC', IncCntry = 'USA', PriTRBCIndPermID = NULL, DsSecDelistDate = NULL, DsExchQtStartDate = '2025-12-16', SecMapStartDate = '2025-12-16', SecMapEndDate = '2079-06-06', PermQuoteRetireDate = NULL, PermOrgIPODate = '2025-12-16', PermSecMapStartDate = '2025-12-16', PermSecMapEndDate = NULL, startDate = '2025-12-16', endDate = NULL WHERE SecCode = 11256103 AND Type_ = 1; UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'MFL.V^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-12-18', SecMapEndDate = '2025-12-17', endDate = '2025-12-17' WHERE SecCode = 11268498 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11270609 AND Type_ = 1; UPDATE data_universe SET OrgPermID = 5090646416.0, PermOrgIPODate = NULL WHERE SecCode = 11270921 AND Type_ = 1; UPDATE data_universe SET OrgPermID = 5090646416.0, PermOrgIPODate = NULL, startDate = '2024-12-14' WHERE SecCode = 11272715 AND Type_ = 1; UPDATE data_universe SET Name = 'OFA GROUP USD CL A ORD SHS' WHERE SecCode = 11278479 AND Type_ = 1; UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL WHERE SecCode = 11286422 AND Type_ = 1; UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232898306910.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11288979 AND Type_ = 1; UPDATE data_universe SET SecMapStartDate = '2025-06-21', startDate = '2025-06-21' WHERE SecCode = 11289387 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG4330A1031', RkdTicker = 'HAVA', RkdSEDOL = 'BV4FYH', RkdCUSIP = 'G4330A10', RkdRIC = 'HAVA.O', RkdDisplayRIC = 'HAVA.OQ', RkdCode = 141709.0, RkdIssueID = 1.0, RkdIssueCode = 180617.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11289483 AND Type_ = 1;