UPDATE data_universe_rkd SET ShPerListing = 33743217.0 WHERE SecCode = 7197 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 10981 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'CSGS.OQ^E26' WHERE SecCode = 11450 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'TKNO3.SA^E26' WHERE SecCode = 31046 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'TKNO4.SA^E26' WHERE SecCode = 31059 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'DE000A41YE56', Ticker = 'BIO1', SEDOL = 'BQRDX7', CUSIP = 'D1178M10', RIC = 'BIO1n.H', DisplayRIC = 'BIO1n.H' WHERE SecCode = 51554 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'DE000A41YE49', Ticker = 'BIO0', SEDOL = 'BQS8PT', CUSIP = 'D1178M11', RIC = 'BIO0n_p.H', DisplayRIC = 'BIO0n_p.H' WHERE SecCode = 51555 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'AU000000SRN2', Ticker = 'SRN', SEDOL = 'BDH2R9', CUSIP = 'Q8805Y10', RIC = 'SRN.AX', DisplayRIC = 'SRN.AX' WHERE SecCode = 72565 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '3593.T^E26' WHERE SecCode = 83697 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '4917.T^E26' WHERE SecCode = 88188 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '6901.T^E26' WHERE SecCode = 94746 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'AU0000469595', Ticker = 'NCRDB', SEDOL = 'BQKXR5', RIC = 'NCRDB.NH', DisplayRIC = 'NCRDB.NH' WHERE SecCode = 96942 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'IME.CD^E26' WHERE SecCode = 100728 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'WRI.H', RIC = 'WRIh.V', DisplayRIC = 'WRIh.V', RkdExchCode = 'NEX' WHERE SecCode = 101003 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'AU0000469801', Ticker = 'AM3', SEDOL = 'BVV9JG', RIC = 'AM3.AX', DisplayRIC = 'AM3.AX' WHERE SecCode = 190747 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'MLPVG.EUA^E26' WHERE SecCode = 331348 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'PIX.WA^E26' WHERE SecCode = 1614017 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'APOI.BO', DisplayRIC = 'APOI.BO' WHERE SecCode = 1998085 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 3261278 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'MNGM.BO', DisplayRIC = 'MNGM.BO' WHERE SecCode = 3344589 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'AAV.HN^E26' WHERE SecCode = 3531558 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'ALTRA', RIC = 'ALTRAF.ST', DisplayRIC = 'ALTRAF.ST' WHERE SecCode = 3671118 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'KYG6875A1177', SEDOL = 'BNZHV1', CUSIP = 'G6875A11' WHERE SecCode = 3764430 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 4533297 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 4605810 AND Type_ = 10;
UPDATE data_universe_rkd SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE0NIJ01025', SEDOL = 'BPCPCB', CUSIP = 'Y2R5GM13' WHERE SecCode = 5380531 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6802661 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'EE3100003112', Ticker = 'LVN1T', CUSIP = 'X5S4DN10', RIC = 'LVN1T.TL', DisplayRIC = 'LVN1T.TL', PrimaryIssueType = 'EQU' WHERE SecCode = 6806166 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6806188 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'TPH.N^E26' WHERE SecCode = 11060677 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 11110120 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'APLS.OQ^E26' WHERE SecCode = 11153355 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'DUKR.O', DisplayRIC = 'DUKR.OQ', RkdExchCode = 'NASD' WHERE SecCode = 11163329 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US52177H2094', Ticker = 'LBUYD', SEDOL = 'BWBZ14', CUSIP = '52177H20', RIC = 'LBUYD.PK', DisplayRIC = 'LBUYD.PK' WHERE SecCode = 11166544 AND Type_ = 1;
UPDATE data_universe_rkd SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, Ticker = 'RVPH', RIC = 'RVPH.PK', DisplayRIC = 'RVPH.PK', RkdExchCode = 'OTC' WHERE SecCode = 11191215 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'SNCY.OQ^E26' WHERE SecCode = 11220771 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11226252 AND Type_ = 1;
UPDATE data_universe_rkd SET SEDOL = 'BT9QVD' WHERE SecCode = 11249174 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA2986011054', SEDOL = 'BWW4J8', CUSIP = '29860110' WHERE SecCode = 11251612 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, Ticker = 'ALCYF', RIC = 'ALCYF.PK', DisplayRIC = 'ALCYF.PK', RkdExchCode = 'OTC' WHERE SecCode = 11254323 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11294562 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11295151 AND Type_ = 1;