UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 2633 AND Type_ = 1;
UPDATE data_universe_rkd SET ShPerListing = 33743217.0 WHERE SecCode = 7197 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 7924 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 8027 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 22571 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 28330 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 30202 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 31378 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 31501 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'HALLQ', RIC = 'HALLQ.PK', DisplayRIC = 'HALLQ.PK' WHERE SecCode = 32094 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 39905 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'SE0029278191', SEDOL = 'BVV583', CUSIP = 'W7S18S12' WHERE SecCode = 40059 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'SE0029278209', SEDOL = 'BXFL4T', CUSIP = 'W7S18S11' WHERE SecCode = 40060 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'SE0029300995', SEDOL = 'BVY4SF', CUSIP = 'W3R27E13' WHERE SecCode = 41508 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 42625 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 53155 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 55298 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 57736 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 57737 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 57742 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 73029 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 74558 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'TKMO', RIC = 'TKMO.PK', DisplayRIC = 'TKMO.PK' WHERE SecCode = 76663 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 76866 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 78743 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'BMG2110W1139', SEDOL = 'BV4G44', CUSIP = 'G2110W11' WHERE SecCode = 80461 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 80580 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'AU000000NVA2', Ticker = 'NVA', RIC = 'NVA.AX', DisplayRIC = 'NVA.AX' WHERE SecCode = 82759 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'ALENMA', RIC = 'ALENMA.KW', DisplayRIC = 'ALENMA.KW' WHERE SecCode = 86890 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'KRNV.TA^F26' WHERE SecCode = 92808 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '2540.T^F26' WHERE SecCode = 99171 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CA1199331093', SEDOL = 'BT9KMF', CUSIP = '11993310' WHERE SecCode = 99858 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 105303 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '6670.T^F26' WHERE SecCode = 112410 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'KYG3314G1284', SEDOL = 'BT9KN3', CUSIP = 'G3314G12' WHERE SecCode = 331293 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 361482 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 385733 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 519205 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'SDET.TE^F26' WHERE SecCode = 549234 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 583140 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'SE0029301258', Ticker = 'SBOK B', SEDOL = 'BVV571', CUSIP = 'W7903Z13', RIC = 'SBOKb.ST', DisplayRIC = 'SBOKb.ST' WHERE SecCode = 597085 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'Y5279H11' WHERE SecCode = 726788 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'ECEXCEL', RIC = 'ECEX.KL', DisplayRIC = 'ECEX.KL' WHERE SecCode = 941144 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'COLCRAIG-B.SN^F26' WHERE SecCode = 1425684 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 1513718 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'SNTO.KL^F26' WHERE SecCode = 1529950 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 2253409 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '3294.T^F26' WHERE SecCode = 2414127 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'AQUA', RIC = 'AQUA.OL', DisplayRIC = 'AQUA.OL' WHERE SecCode = 2620118 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'VANL.L^F26' WHERE SecCode = 3259340 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 3793428 AND Type_ = 10;
UPDATE data_universe_rkd SET ShPerListing = 0.025 WHERE SecCode = 4036738 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 4521349 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 4563452 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 4816848 AND Type_ = 10;
UPDATE data_universe_rkd SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '9338.T^F26' WHERE SecCode = 5279792 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueCode = 130012.0 WHERE SecCode = 5491796 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '464440.KQ^F26' WHERE SecCode = 5581593 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 5900313 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 6389725 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 6394298 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 6422983 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 6431535 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 6448312 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 6449028 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 6472019 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 6478326 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6503795 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6507165 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 6513037 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 6526493 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 6528726 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 6528955 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6538872 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 6541027 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 6541044 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 6556268 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 6569462 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6593845 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6596065 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6603588 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6608230 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 6608465 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 6612483 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 6626028 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6635227 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 6638308 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, PrimaryIssueType = 'PVT' WHERE SecCode = 6654323 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 6745474 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 6880028 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, PrimaryIssueType = 'PVT' WHERE SecCode = 6914495 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6921015 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'AU.V^F26' WHERE SecCode = 10781932 AND Type_ = 1;
UPDATE data_universe_rkd SET ShPerListing = 0.3333, PrimaryIssueType = 'EQU' WHERE SecCode = 10971738 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 10977605 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'TMED.X', RIC = 'TMEDx.CD', DisplayRIC = 'TMEDx.CD' WHERE SecCode = 11078563 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11112525 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'US91544A2087', SEDOL = 'BWL8QP', CUSIP = '91544A20' WHERE SecCode = 11142037 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11142838 AND Type_ = 1;
UPDATE data_universe_rkd SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11208468 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'GOCOQ', RIC = 'GOCOQ.PK', DisplayRIC = 'GOCOQ.PK', RkdExchCode = 'OTC' WHERE SecCode = 11210042 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'GXX.V^F26' WHERE SecCode = 11211824 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA92840Q5095', SEDOL = 'BWL8QQ', CUSIP = '92840Q50' WHERE SecCode = 11215246 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'FTH', RIC = 'FTH.O', DisplayRIC = 'FTH.OQ' WHERE SecCode = 11218771 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11223644 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11240505 AND Type_ = 1;
UPDATE data_universe_rkd SET ShPerListing = 3000.0 WHERE SecCode = 11245064 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'PMNT.PK', DisplayRIC = 'PMNT.PK', RkdExchCode = 'OTC' WHERE SecCode = 11262373 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 11267840 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'KYG9767H1332', SEDOL = 'BX55HX', CUSIP = 'G9767H13' WHERE SecCode = 11268688 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'KAZR', RIC = 'KAZR.O', DisplayRIC = 'KAZR.OQ' WHERE SecCode = 11274212 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'MEHA.PK', DisplayRIC = 'MEHA.PK', RkdExchCode = 'OTC' WHERE SecCode = 11274658 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11277444 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11278789 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 11281418 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 11284182 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11286246 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 11286854 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 11286913 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11287078 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11287301 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11287713 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11289483 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11291357 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11292733 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, PrimaryIssueType = 'IPO' WHERE SecCode = 11294226 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11294716 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11295981 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 11297140 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11297183 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'IPO' WHERE SecCode = 11297292 AND Type_ = 1;