#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
