ETL code for converting Korean National Sample Cohort (NSC) derived from national insurance health service into OMOP-CDM v5 developed by Ajou University
Apache License 2.0
10
stars
16
forks
source link
route_concept_id column issue in Drug_exposure table #8
WHEN substring(a.CZ_ITEM_CD, 1, 2)='03' and substring(a.CZ_ITEM_CD, 3, 2)='01' then 4128794 -- oral -> **4132161**
WHEN substring(a.CZ_ITEM_CD, 1, 2)='03' and substring(a.CZ_ITEM_CD, 3, 2)='02' then 45956875 -- not applicable
WHEN substring(a.CZ_ITEM_CD, 1, 2)='04' and substring(a.CZ_ITEM_CD, 3, 2)='01' then 4139962 -- Subcutaneous -> **4142048**
WHEN substring(a.CZ_ITEM_CD, 1, 2)='04' and substring(a.CZ_ITEM_CD, 3, 2)='02' then 4112421 -- intravenous -> **4171047**
기존 컨셉의 domain이 route가 아닌 observation이었음