UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 9636 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 9699 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 9773 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'THRG.L^D26' WHERE SecCode = 11934 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'HINOY.PK^D26' WHERE SecCode = 33634 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'ELL.V^D26' WHERE SecCode = 42608 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 48685 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 48726 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 48825 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'HWTR.PK^D26' WHERE SecCode = 53277 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '4690.T^D26' WHERE SecCode = 69654 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'JSWDULUX', RIC = 'JSWD.NS', DisplayRIC = 'JSWD.NS' WHERE SecCode = 71430 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'AU000000SER1', Ticker = 'SER', SEDOL = '629766', CUSIP = 'Q8793A10', RIC = 'SER.AX', DisplayRIC = 'SER.AX' WHERE SecCode = 78043 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'AU000000KAI5', Ticker = 'KAI', SEDOL = 'BYMY9W', CUSIP = 'Q5171P19', RIC = 'KAI.AX', DisplayRIC = 'KAI.AX' WHERE SecCode = 99340 AND Type_ = 10; UPDATE data_universe_rkd SET ISIN = 'CA57779K1049', Ticker = 'MAV', SEDOL = 'BVN4ZZ', CUSIP = '57779K10', RIC = 'MAV.CD', DisplayRIC = 'MAV.CD' WHERE SecCode = 100885 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 113954 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 126438 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'ELY.V^D26' WHERE SecCode = 335310 AND Type_ = 1; UPDATE data_universe_rkd SET CUSIP = 'Q9762N15' WHERE SecCode = 347684 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 586319 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'Y834GE12' WHERE SecCode = 786648 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueCode = 91683.0 WHERE SecCode = 1633543 AND Type_ = 10; UPDATE data_universe_rkd SET CUSIP = 'M2R43K38' WHERE SecCode = 3384119 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'CG000A0BKQF7.BR^L25' WHERE SecCode = 3387586 AND Type_ = 10; UPDATE data_universe_rkd SET Ticker = 'COLT', RIC = 'COLT.PR', DisplayRIC = 'COLT.PR' WHERE SecCode = 4245390 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueCode = 125741.0 WHERE SecCode = 4425536 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueCode = NULL WHERE SecCode = 5183014 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '457630.KQ^D26' WHERE SecCode = 5515094 AND Type_ = 10; UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '455310.KQ^D26' WHERE SecCode = 5517574 AND Type_ = 10; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 10980226 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'MRCC.OQ^D26' WHERE SecCode = 11037386 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueCode = 91683.0 WHERE SecCode = 11065648 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'DUKR', RIC = 'DUKR.PK', DisplayRIC = 'DUKR.PK' WHERE SecCode = 11163329 AND Type_ = 1; UPDATE data_universe_rkd SET Ticker = 'ELVG', RIC = 'ELVG.PK', DisplayRIC = 'ELVG.PK' WHERE SecCode = 11198346 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11209704 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11225910 AND Type_ = 1; UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 11236616 AND Type_ = 1; UPDATE data_universe_rkd SET CUSIP = 'M2R43K38' WHERE SecCode = 11242197 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueCode = 91683.0, RelType = 1.0 WHERE SecCode = 11254623 AND Type_ = 1; UPDATE data_universe_rkd SET PrimaryIssueCode = 125741.0, RelType = 1.0 WHERE SecCode = 11260395 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11291346 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11293248 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11293452 AND Type_ = 1; UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11293777 AND Type_ = 1;