PROCEDURE_TYPE_CONCEPT_ID should be set to 0 if it is 'UN' - mapping document states to use 45877986

National-COVID-Cohort-Collaborative / Data-Ingestion-and-Harmonization

Data Ingestion and Harmonization

41 stars 12 forks source link

PROCEDURE_TYPE_CONCEPT_ID should be set to 0 if it is 'UN' - mapping document states to use 45877986 #42

Closed stephanieshong closed 4 years ago

stephanieshong commented 4 years ago

CASE WHEN pr.px_source ='BI' THEN 257 WHEN pr.px_source ='CL' THEN 32468 WHEN pr.px_source ='OD' THEN 38000275 --ORDER /EHR WHEN pr.px_source ='UN' THEN 0 --UN This is not a type concept and it really has no value, so set to 0 6/18/20 SSH WHEN pr.px_source ='NI' THEN 46237210 WHEN pr.px_source ='OT' THEN 45878142 ELSE 0 END AS PROCEDURE_TYPE_CONCEPT_ID,

stephanieshong commented 4 years ago

set to 0. UN This is not a type concept and it really has no value, so set to 0 per Clair and Kristin. 6/18/20 SSH