UPDATE data_universe_rkd SET ShPerListing = 33743217.0 WHERE SecCode = 7197 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'BYM.N^B26' WHERE SecCode = 9636 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'BFZ.N^B26' WHERE SecCode = 9694 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'BFK.N^B26' WHERE SecCode = 9699 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'BNY.N^B26' WHERE SecCode = 9716 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'BLE.N^B26' WHERE SecCode = 9773 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US2324374006', Ticker = 'CYAND', SEDOL = 'BVLNNJ', CUSIP = '23243740', RIC = 'CYAND.PK', DisplayRIC = 'CYAND.PK' WHERE SecCode = 18150 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 23742 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 28902 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 30010 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 32905 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US42804T2050', SEDOL = 'BS1KWQ', CUSIP = '42804T20' WHERE SecCode = 33389 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 43183 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 43199 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 47232 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 47916 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'MHN.N^B26' WHERE SecCode = 48585 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'MUE.N^B26' WHERE SecCode = 48685 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US65340V2025', Ticker = 'NGMCD', SEDOL = 'BV5PVF', CUSIP = '65340V20', RIC = 'NGMCD.PK', DisplayRIC = 'NGMCD.PK' WHERE SecCode = 50525 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'naso' WHERE SecCode = 53383 AND Type_ = 10;
UPDATE data_universe_rkd SET SEDOL = '566407' WHERE SecCode = 58288 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'GRLF', RIC = 'GRLF.PK', DisplayRIC = 'GRLF.PK' WHERE SecCode = 70223 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 71523 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 72714 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'HLLC.CL^C17' WHERE SecCode = 73071 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'YNAM.SI^L24' WHERE SecCode = 73666 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 73755 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 75258 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'RABL.NS^D25' WHERE SecCode = 76848 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 85436 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 88338 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 93952 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 102200 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'sntk' WHERE SecCode = 102592 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 107292 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = '6022.TWO^H17' WHERE SecCode = 114768 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 184425 AND Type_ = 10;
UPDATE data_universe_rkd SET SEDOL = 'BRBSC6' WHERE SecCode = 295477 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 296181 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 337190 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 348407 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1, PrimaryIssueType = 'PVT' WHERE SecCode = 349158 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 351639 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueCode = 61412.0 WHERE SecCode = 411689 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 556900 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = 'kpmg' WHERE SecCode = 703166 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 703181 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'mggd' WHERE SecCode = 703323 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'kzmd' WHERE SecCode = 703370 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = 'prsn' WHERE SecCode = 1619944 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 1632017 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'GPIM', RIC = 'GPIM.CA', DisplayRIC = 'GPIM.CA' WHERE SecCode = 1696040 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'mzbkp' WHERE SecCode = 1713719 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = 'zmekp' WHERE SecCode = 2071779 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = 'lots' WHERE SecCode = 2253357 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'VRS.L^B26' WHERE SecCode = 2264327 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 2587195 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'KYG983421275', SEDOL = 'BVMD7K', CUSIP = 'G9834212' WHERE SecCode = 2753942 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 3206339 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueCode = 112509.0 WHERE SecCode = 3338460 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'TH8380010000' WHERE SecCode = 3410326 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = '288490.KN^B26' WHERE SecCode = 3671085 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'AAGN.VI^B26' WHERE SecCode = 4421086 AND Type_ = 10;
UPDATE data_universe_rkd SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 5648614 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6629441 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 10771021 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 10902913 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 10921139 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 10963628 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 10965889 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 10968292 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 10972830 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 10985536 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11002303 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11007485 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11025389 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11037717 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 11045993 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 11045994 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11071876 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11074192 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11078894 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11111520 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 11137310 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US34417J5002', SEDOL = 'BS1KW8', CUSIP = '34417J50' WHERE SecCode = 11138087 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11144666 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11150846 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11156209 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11174852 AND Type_ = 1;
UPDATE data_universe_rkd SET SEDOL = NULL, RIC = 'VERO.PK', DisplayRIC = 'VERO.PK', RkdExchCode = 'OTC' WHERE SecCode = 11177059 AND Type_ = 1;
UPDATE data_universe_rkd SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US91704K3014', SEDOL = 'BS1KW3', CUSIP = '91704K30' WHERE SecCode = 11199427 AND Type_ = 1;
UPDATE data_universe_rkd SET SEDOL = 'BMZC81' WHERE SecCode = 11210591 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = NULL WHERE SecCode = 11217833 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'CREVF', SEDOL = NULL, RIC = 'CREVF.PK', DisplayRIC = 'CREVF.PK', RkdExchCode = 'OTC' WHERE SecCode = 11223114 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US74319X2071', SEDOL = 'BS1KW6', CUSIP = '74319X20' WHERE SecCode = 11237417 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'KYG322121131', SEDOL = 'BS1KVT' WHERE SecCode = 11277491 AND Type_ = 1;
UPDATE data_universe_rkd SET SEDOL = 'BMXGXM' WHERE SecCode = 11278158 AND Type_ = 1;
