Well, it probably makes little sense to bring CTV3 into the Standardized Vocabularies as its life expectancy is short. However, the NHS provides mapping tables here.
To make it easy for you I extracted the CTV3 to SNOMED mapping. Please download from the OHDSI FTP site ftp://ftp.ohdsi.org. In the CTV3 folder there is the file CTV3_to_Snomed_MAP.xlsx. It has 4 fields:
- CTV3_SCUI: One of the CTV3 identifiers
- CTV3_STUI: Another CTV3 identifier
- ASSURED: They are providing a one to many mapping. One of the many is “assured”. At least, that’s what it looks like. There is no explicit documentation, or at least I cannot find it.
You may want to convert that thing into a proper SOURCE_TO_CONCEPT_MAP table. You need to pick which of the identifiers you need to use, and convert the SNOMED code into OMOP concept_id.
What kind of data are you working with that has CTV3?