ETL code for converting Korean National Sample Cohort (NSC) derived from national insurance health service into OMOP-CDM v5 developed by Ajou University
Issue1. In the care_site table, the location_id is the id of the raw data, not the id referenced in the location table.
Issue2. Only the id for Si, Gun, and Gu (State, county, ...) is given in the location table. However, in the raw data, address information for caresite is limited to city(county) units. Therefore, a new id must be given in the location table.
Issue1. In the care_site table, the location_id is the id of the raw data, not the id referenced in the location table.
Issue2. Only the id for Si, Gun, and Gu (State, county, ...) is given in the location table. However, in the raw data, address information for caresite is limited to city(county) units. Therefore, a new id must be given in the location table.