UPDATE data_universe_rkd SET ShPerListing = 33743217.0 WHERE SecCode = 7197 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'PAZRIO.CN', DisplayRIC = 'PAZRIO.CN' WHERE SecCode = 27018 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'EXITO.CN', DisplayRIC = 'EXITO.CN' WHERE SecCode = 27179 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'BBVACOL.CN', DisplayRIC = 'BBVACOL.CN' WHERE SecCode = 27263 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'POPULAR.CN', DisplayRIC = 'POPULAR.CN' WHERE SecCode = 27286 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'BOGOTA.CN', DisplayRIC = 'BOGOTA.CN' WHERE SecCode = 27341 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'PFBBVACOL.CN', DisplayRIC = 'PFBBVACOL.CN' WHERE SecCode = 27443 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'OCCIDENTE.CN', DisplayRIC = 'OCCIDENTE.CN' WHERE SecCode = 27471 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'CARTON.CN', DisplayRIC = 'CARTON.CN' WHERE SecCode = 27801 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'GRUPOARGOS.CN', DisplayRIC = 'GRUPOARGOS.CN' WHERE SecCode = 27900 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'CEMARGOS.CN', DisplayRIC = 'CEMARGOS.CN' WHERE SecCode = 27901 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'PFCORFICOL.CN', DisplayRIC = 'PFCORFICOL.CN' WHERE SecCode = 27904 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'NUTRESA.CN', DisplayRIC = 'NUTRESA.CN' WHERE SecCode = 27954 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'CORFERIAS.CN', DisplayRIC = 'CORFERIAS.CN' WHERE SecCode = 28161 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'MARLY.CN', DisplayRIC = 'MARLY.CN' WHERE SecCode = 28207 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'GRUPOSURA.CN', DisplayRIC = 'GRUPOSURA.CN' WHERE SecCode = 28364 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'GRUPOAVAL.CN', DisplayRIC = 'GRUPOAVAL.CN' WHERE SecCode = 29137 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'VILLAS.CN', DisplayRIC = 'VILLAS.CN' WHERE SecCode = 29138 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'INVENSA.CN', DisplayRIC = 'INVENSA.CN' WHERE SecCode = 29426 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'PROMIGAS.CN', DisplayRIC = 'PROMIGAS.CN' WHERE SecCode = 30328 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'AGROCHAL.CN', DisplayRIC = 'AGROCHAL.CN' WHERE SecCode = 30548 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'VALSIMESA.CN', DisplayRIC = 'VALSIMESA.CN' WHERE SecCode = 30564 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'ESTRA.CN', DisplayRIC = 'ESTRA.CN' WHERE SecCode = 30568 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'INESA.CN', DisplayRIC = 'INESA.CN' WHERE SecCode = 30569 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'CELSIA.CN', DisplayRIC = 'CELSIA.CN' WHERE SecCode = 30658 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'GRUBOLIVAR.CN', DisplayRIC = 'GRUBOLIVAR.CN' WHERE SecCode = 30769 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 31098 AND Type_ = 1;
UPDATE data_universe_rkd SET RIC = 'CORFICOLCF.CN', DisplayRIC = 'CORFICOLCF.CN' WHERE SecCode = 31220 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'TITAN.CN', DisplayRIC = 'TITAN.CN' WHERE SecCode = 31387 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'KWY', RIC = 'KWY', DisplayRIC = 'KWY.N' WHERE SecCode = 39746 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0 WHERE SecCode = 48754 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '2692.T^E26' WHERE SecCode = 79181 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'GILT.PSX^E26' WHERE SecCode = 84612 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'PFVILLAS00.CN', DisplayRIC = 'PFVILLAS00.CN' WHERE SecCode = 111339 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'PFVILLASCA.CN', DisplayRIC = 'PFVILLASCA.CN' WHERE SecCode = 111340 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueID = 1, RkdIssueCode = 86888, RkdIssueStatus = 1, RkdIssueOrder = 2, RkdListingType = NULL, ISIN = 'US48127Q1094', Ticker = 'CPFID', SEDOL = 'BMW3X9', CUSIP = '48127Q10', RIC = 'CPFID.PK', DisplayRIC = 'CPFID.PK', RkdExchCode = 'OTC' WHERE SecCode = 309092 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 1 WHERE SecCode = 342149 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'MINEROS.CN', DisplayRIC = 'MINEROS.CN' WHERE SecCode = 347222 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'ENKA.CN', DisplayRIC = 'ENKA.CN' WHERE SecCode = 350028 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'ECOPETROL.CN', DisplayRIC = 'ECOPETROL.CN' WHERE SecCode = 350029 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'MAYAGUEZ.CN', DisplayRIC = 'MAYAGUEZ.CN' WHERE SecCode = 519056 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'INCASTILLA.CN', DisplayRIC = 'INCASTILLA.CN' WHERE SecCode = 519060 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'PFVILLAS.CN', DisplayRIC = 'PFVILLAS.CN' WHERE SecCode = 519437 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'PROTECCION.CN', DisplayRIC = 'PROTECCION.CN' WHERE SecCode = 519567 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'EMPAQUES.CN', DisplayRIC = 'EMPAQUES.CN' WHERE SecCode = 519598 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'FGNTOLIMA.CN', DisplayRIC = 'FGNTOLIMA.CN' WHERE SecCode = 519748 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'CONCONCRET.CN', DisplayRIC = 'CONCONCRET.CN' WHERE SecCode = 519755 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'CSACOL.CN', DisplayRIC = 'CSACOL.CN' WHERE SecCode = 520495 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'VALINDUSTR.CN', DisplayRIC = 'VALINDUSTR.CN' WHERE SecCode = 521503 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'CONCIVILES.CN', DisplayRIC = 'CONCIVILES.CN' WHERE SecCode = 521938 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'ELECTULUA.CN', DisplayRIC = 'ELECTULUA.CN' WHERE SecCode = 532082 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'FABRICATO.CN', DisplayRIC = 'FABRICATO.CN' WHERE SecCode = 550263 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'INE392H01026', SEDOL = 'BPCPC5', CUSIP = 'Y834GE10' WHERE SecCode = 786648 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'PFDAVVNDA.CN', DisplayRIC = 'PFDAVVNDA.CN' WHERE SecCode = 838130 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'FR0014017FP5', SEDOL = 'BWTRHY' WHERE SecCode = 1109069 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'PFAVAL.CN', DisplayRIC = 'PFAVAL.CN' WHERE SecCode = 1143455 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'PFGRUPSURA.CN', DisplayRIC = 'PFGRUPSURA.CN' WHERE SecCode = 1479218 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'ELCONDOR.CN', DisplayRIC = 'ELCONDOR.CN' WHERE SecCode = 1543889 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'PFCARPAK.CN', DisplayRIC = 'PFCARPAK.CN' WHERE SecCode = 1594656 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'PFGRUPOARG.CN', DisplayRIC = 'PFGRUPOARG.CN' WHERE SecCode = 1603593 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'SANFELIPE.CN', DisplayRIC = 'SANFELIPE.CN' WHERE SecCode = 1605740 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'CARACOLTV.CN', DisplayRIC = 'CARACOLTV.CN' WHERE SecCode = 2071778 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'PFCEMARGOS.CN', DisplayRIC = 'PFCEMARGOS.CN' WHERE SecCode = 2240520 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'PFVILLA053.CN', DisplayRIC = 'PFVILLA053.CN' WHERE SecCode = 2333061 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'DESCAUCANO.CN', DisplayRIC = 'DESCAUCANO.CN' WHERE SecCode = 2338193 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'AU0000470262', Ticker = 'FMN', SEDOL = 'BRJN90', RIC = 'FMN.AX', DisplayRIC = 'FMN.AX' WHERE SecCode = 2372641 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'PFVILLA051.CN', DisplayRIC = 'PFVILLA051.CN' WHERE SecCode = 2402420 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'PFVILLAS01.CN', DisplayRIC = 'PFVILLAS01.CN' WHERE SecCode = 2402434 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'RIOPAILA.CN', DisplayRIC = 'RIOPAILA.CN' WHERE SecCode = 2429985 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'RIOPAILIND.CN', DisplayRIC = 'RIOPAILIND.CN' WHERE SecCode = 2551377 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'TERPEL.CN', DisplayRIC = 'TERPEL.CN' WHERE SecCode = 2623009 AND Type_ = 10;
UPDATE data_universe_rkd SET SEDOL = 'BX01MR' WHERE SecCode = 3002458 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'COLOMBINA.CN', DisplayRIC = 'COLOMBINA.CN' WHERE SecCode = 3247541 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'COLTEL.CN', DisplayRIC = 'COLTEL.CN' WHERE SecCode = 3571418 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'T5263L12' WHERE SecCode = 3779974 AND Type_ = 10;
UPDATE data_universe_rkd SET CUSIP = 'R3R38116' WHERE SecCode = 4443375 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = 'LPGO.ST^E26' WHERE SecCode = 4513760 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 = '7136.T^E26' WHERE SecCode = 4882385 AND Type_ = 10;
UPDATE data_universe_rkd SET Ticker = 'TMHK', RIC = 'TMHK.ASE', DisplayRIC = 'TMHK.ASE' WHERE SecCode = 5037215 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'GASORIENTE.CN', DisplayRIC = 'GASORIENTE.CN' WHERE SecCode = 5222995 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '462020.KQ^E26' WHERE SecCode = 5553171 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, RIC = '466910.KQ^E26' WHERE SecCode = 5597638 AND Type_ = 10;
UPDATE data_universe_rkd SET RIC = 'RCNTELEVI.CN', DisplayRIC = 'RCNTELEVI.CN' WHERE SecCode = 6378664 AND Type_ = 10;
UPDATE data_universe_rkd SET PrimaryIssueCode = 144753.0, RelType = NULL, COATypeCode = 'IND' WHERE SecCode = 6813821 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 6829242 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'US25382K1007', SEDOL = 'BMWF3W', CUSIP = '25382K10' WHERE SecCode = 10785144 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'PVT' WHERE SecCode = 11131840 AND Type_ = 1;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = 'SLNO.OQ^E26' WHERE SecCode = 11139994 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA65557M1014', Ticker = 'NRDX', SEDOL = 'BVSVTR', CUSIP = '65557M10', RIC = 'NRDX.CD', DisplayRIC = 'NRDX.CD' WHERE SecCode = 11185275 AND Type_ = 1;
UPDATE data_universe_rkd SET Ticker = 'CEXY', RIC = 'CEXY.CD', DisplayRIC = 'CEXY.CD' WHERE SecCode = 11185444 AND Type_ = 1;
UPDATE data_universe_rkd SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA38211A1021', Ticker = 'GPIN', SEDOL = 'BRDWDJ', CUSIP = '38211A10', RIC = 'GPIN.CD', DisplayRIC = 'GPIN.CD' WHERE SecCode = 11215871 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'VGG5279F3007', SEDOL = 'BRDXC4', CUSIP = 'G5279F30' WHERE SecCode = 11218121 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'CA65346L1094', Ticker = 'NPV', SEDOL = 'BWW4JB', CUSIP = '65346L10', RIC = 'NPV.V', DisplayRIC = 'NPV.V' WHERE SecCode = 11237323 AND Type_ = 1;
UPDATE data_universe_rkd SET ISIN = 'KYG6421C1380', SEDOL = 'BRF0NM', CUSIP = 'G6421C13' WHERE SecCode = 11264491 AND Type_ = 1;
UPDATE data_universe_rkd SET PrimaryIssueType = 'EQU' WHERE SecCode = 11273589 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11295044 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 11295488 AND Type_ = 1;
