#243: GPC Procedure Ontology: CPT, HCPCS --------------------------+---------------------------- Reporter: rwaitman | Owner: lpatel Type: design-issue | Status: assigned Priority: major | Milestone: snow-shrine-2 Component: data-stds | Resolution: Keywords: | Blocked By: Blocking: 411 | --------------------------+---------------------------- Changes (by lpatel):
* cc: gpc-dev@… (added) Comment: == creating Adapter mapping for the procedure. Adapter mapping for shrine procedure is created using the following SQL, and then converted to CSV and appended to existing `AdapterMappings.csv.` {{{ select '\\SHRINE'|| so.c_fullname scihls_path ,'\\PCORI_PROCEDURE' || ht.c_fullname heron_path from SHRINE_ONT.shrine so join blueheronmetadata.heron_terms ht on replace(so.c_basecode,'ICD10PCS','ICD10') = ht.c_basecode where ( so.c_basecode like 'CPT:%' or so.c_basecode like 'ICD9:%' or so.c_basecode like 'ICD10PCS:%' ) and ht.C_FULLNAME like '\PCORI\PROCEDURE\%'; }}} * no changes to ontologies. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/243#comment:20> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics _______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev