Standardizing procedures (call for non-US based collaborators)

Here is a small update on procedure standardization.

Looking at mapping from ICD-10-PCS to SNOMED CT - it seems that the map will not be similar to maps for drugs or diagnoses. E.g., for drugs - the ‘Maps to’ relationship is essentially an exact match.

It may be important to think about how to handle broad-to-narrow and narrow-to-broad in general in Athena.

We observe that SCT as target terminology is not granular enough. So instead of ‘exact-match-maps-to’ - the only relationship from ICD10PCS to SCT we will have to settle for (in some cases) is ‘narrowICD10PCS-to-broadSNOMEDCT’. (or open the pandora box of postcoordinated expression appearing in procedure_concept_id (which, from analyst point of view) may not be an option in the foreseeable future. (due to no good subsumption reasoning software that would be nicely baked into SQL).