#411: Align SNOW SHRINE terminology with ARCH and ACT ontology for
interoperation
of query
-------------------------+----------------------------------------------
Reporter: dconnolly | Owner: campbell
Type: enhancement | Status: assigned
Priority: major | Milestone: snow-shrine-3
Component: data-stds | Resolution:
Keywords: ModelMashup | Blocked By: 23, 90, 201, 243, 280, 525, 583
Blocking: |
-------------------------+----------------------------------------------
Comment (by jay.pedersen):
Comprehensive RxNORM coding information from the NLM, dated August 2018
("RxCUI Tables").
UNMC uploaded the attachment RxCUI_Tables_20180801.7z, which is a 7zip-
format compressed file containing CSV files with RxNORM information and a
MS Word document named RxCUI_Tables_Reference_<date>.docx explains the
contents of each CSV file on a field by field basis.
A PDF file RxCUI_Tables_Reference_<date>.pdf is also attached to the
ticket.
The information contained in the file(s) is directly extracted from the
NLM's REST API for RxNORM (mostly from
https://rxnav.nlm.nih.gov/RxNormAPIs.html#).
The importance to the GPC would be that it would allow the analysis of the
RxNORM codes that a site is using. Each RxNORM code (aka RxCUI code) has
a type which indicates its domain. The NLM calls this the TTY (term type)
and it is simply called TYPE in the RxCUI Tables. For example a TTY value
of 'IN' indicates an ingredient, a type of 'SCD' indicates an orderable
generic drug. The relationships between the RxCUI codes is documented in
the 'rxcui_relationships.csv' file. That file lists the relationships
from any RxCUI to its associated RxCUI codes.
As an example, if a medication order for Bayer Aspirin had been
incorrectly coded as the Brand Name for Bayer Aspirin (RxCUI 215568, TTY
'BN') instead of the orderable drug Bayer Aspirin, then these tables would
at least indicate the set of orderable drug codes for Tylenolol.
Orderable drugs have TTY values of SCD or SBD (or GPCK or BPCK for packs).
So looking for the relationships of those types from RxCUI 215568
currently finds 8 Generic Drug codes, 8 Branded drug codes and 2 Generic
pack codes.
Here is the SQL for such a query that presumes the rxcui_relationships.csv
file is loaded into a table called RXCUI_RELATIONSHIPS:
select rr.* from RXCUI_RELATIONSHIPS rr where rr.RXCUI=215568 and
rr.RELATION_TYPE in ('SCD','SBD','GPCK','BPCK') order by relation_type
would indicate the RxCUI codes for the orderable drug Tylenol.
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/411#comment:27>
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
