UPDATE data_universe_rkd SET RIC = 'GB0006439=L', DisplayRIC = 'GB0006439=L' WHERE SecCode = 84 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'GB0839970=L', DisplayRIC = 'GB0839970=L' WHERE SecCode = 11304 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'GB0840132=L', DisplayRIC = 'GB0840132=L' WHERE SecCode = 11308 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'STGG.F^D26' WHERE SecCode = 59737 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'ENGY.PK^D26' WHERE SecCode = 60070 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'JOJO.BO', DisplayRIC = 'JOJO.BO' WHERE SecCode = 69705 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 78322 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'SAHLIBHFI', RIC = 'SHAL.NS', DisplayRIC = 'SHAL.NS', RkdExchCode = 'NSE' WHERE SecCode = 81820 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 124822 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'SGRE.WA^D26' WHERE SecCode = 940758 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'HBGH.BO', DisplayRIC = 'HBGH.BO' WHERE SecCode = 2541445 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 3247687 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = '1922.HK^D26' WHERE SecCode = 4006851 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 4605810 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CH1544292464', SEDOL = 'BT68VR', CUSIP = 'H1954A10' WHERE SecCode = 5487993 AND Type_ = 10;
UPDATE data_universe_rkd SET SEDOL = 'BT7JNT' WHERE SecCode = 6154012 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6450911 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6745473 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CA73278C2040', SEDOL = 'BT66LH', CUSIP = '73278C20' WHERE SecCode = 10926191 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'AL.N^D26' WHERE SecCode = 10986008 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11209843 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'CPTAF', RIC = 'CPTAF.PK', DisplayRIC = 'CPTAF.PK', RkdExchCode = 'OTC' WHERE SecCode = 11240537 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'OAKU.OQ^D26' WHERE SecCode = 11253112 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA79467H1029', Ticker = 'SCAI', SEDOL = 'BT66LN', CUSIP = '79467H10', RIC = 'SCAI.V', DisplayRIC = 'SCAI.V' WHERE SecCode = 11253247 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'HYAC.N^D26' WHERE SecCode = 11257235 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdCode = 144589, RkdIssueCode = 184802, RkdIssueStatus = 1, ISIN = 'US70580B1061', Ticker = 'GLND', SEDOL = 'BV4K66', CUSIP = '70580B10', RIC = 'GLND.O', DisplayRIC = 'GLND.OQ', COATypeCode = '' WHERE SecCode = 11279226 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'MHY1250N1233', SEDOL = 'BT5JCK', CUSIP = 'Y1250N12' WHERE SecCode = 11281757 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11291637 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11292189 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11292932 AND Type_ = 1;
