UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 1331 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 1332 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 1333 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 1334 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 9636 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 9637 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 9699 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 9704 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'QVCGQ.PK', DisplayRIC = 'QVCGQ.PK' WHERE SecCode = 42293 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 48825 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 48826 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 48827 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 48828 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 48829 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 57743 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueCode = 27974.0 WHERE SecCode = 70930 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 125758 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'CNTL', RIC = 'CNTL.S', DisplayRIC = 'CNTL.S' WHERE SecCode = 146022 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 586319 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'ROYAL.IS^D26' WHERE SecCode = 2226891 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = 'JTLD.BO', DisplayRIC = 'JTLD.BO' WHERE SecCode = 2469416 AND Type_ = 10; UPDATE data_universe_rkd SET RkdListingType = 'OSR', ShPerListing = NULL, PrimaryIssueCode = NULL, RelType = NULL WHERE SecCode = 4540648 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 4616827 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueCode = 134486.0 WHERE SecCode = 5183014 AND Type_ = 10; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 5678857 AND Type_ = 10; UPDATE data_universe_rkd SET RIC = '7821.TW', DisplayRIC = '7821.TW', RkdExchCode = 'TPE' WHERE SecCode = 6213117 AND Type_ = 10; UPDATE data_universe_rkd SET RkdCode = 142478, RkdIssueCode = 181752, ISIN = NULL, Ticker = NULL, SEDOL = NULL, CUSIP = NULL, RIC = NULL, DisplayRIC = NULL, RkdExchCode = 'NA', RkdExchCtry = NULL, PrimaryIssueType = 'IPO', PrimaryIssueCode = NULL, COATypeCode = '' WHERE SecCode = 6383728 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'SPIEQ', RIC = 'SPIEQ.PK', DisplayRIC = 'SPIEQ.PK' WHERE SecCode = 11155526 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'QVCD.N' WHERE SecCode = 11189948 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11189974 AND Type_ = 1; UPDATE data_universe_rkd SET RIC = 'QVCC.N' WHERE SecCode = 11202462 AND Type_ = 1; UPDATE data_universe_rkd SET ShPerListing = 1000.0 WHERE SecCode = 11213058 AND Type_ = 1; UPDATE data_universe_rkd SET ISIN = 'US2079442081', Ticker = 'CNTMD', RIC = 'CNTMD.PK', DisplayRIC = 'CNTMD.PK' WHERE SecCode = 11243411 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'TRAX', DisplayRIC = 'TRAX.OQ' WHERE SecCode = 11294194 AND Type_ = 1;