2011 06 06 - loinc workshop and tutorial
DESCRIPTION
TRANSCRIPT
![Page 1: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/1.jpg)
©2011 Regenstrief Institute and James Case
Using RELMA Or…In Search of the Missing LOINC
James T. Case MS, DVM, PhD Health Program Specialist, SNOMED CT
National Library of Medicine
Laboratory LOINC Meeting – June 2011
![Page 2: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/2.jpg)
©2011 Regenstrief Institute and James Case
Acknowledgements • RELMA Development Team
• John Hook, Karen Ahmad, Mark Fisher, Craig Kelker
• Dan Vreeman • Clem McDonald • Kathy Mercer • The Lab LOINC CommiFee • Funding Support
• NLM, Regenstrief InsJtute, NCI, CDC
![Page 3: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/3.jpg)
©2011 Regenstrief Institute and James Case
What will we cover today? • Overview of LOINC • Reviewing new RELMA features! • Installing RELMA • SeMng personal preferences • Loading a Local ObservaJon File (LMOF) • Searching for a LOINC Term • Preparing LMOF for Mapping • Review of Map Screen FuncJons • SeMng Search Limits • Mapping Local Terms to LOINC • Viewing LOINC Term Details • Proposing/SubmiMng New LOINC Terms • ExporJng/PrinJng Mapped Terms • Mapping your own LMOF data
![Page 4: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/4.jpg)
©2011 Regenstrief Institute and James Case
Why are we doing this? Goals of Health Information Standards
• Interoperability – the ability to exchange informaJon between organizaJons
• Comparability – the ability to ascertain the equivalence of data from different sources
• Data Quality – the measurement of accessibility, completeness, accuracy and precision (and more)
![Page 5: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/5.jpg)
©2011 Regenstrief Institute and James Case
Levels of Interoperability • Basic – allows data to be exchanged between computer systems • Word processing documents, text messages
• Func7onal – describes the standard syntax (format) of the data • Document templates, forms, data structures • Message standards
• Seman7c – requires use of standardized content (vocabularies) within the data structure
![Page 6: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/6.jpg)
©2011 Regenstrief Institute and James Case
Comparability • Meaning of the data is consistent when shared among different parJes • Erysipelas – Human skin disease; Streptococcus Grp A • Erysipelas – Animal SepJcemia/dermaJJs; Erysipelothrix rhusiopathiae
• Common terminology required • Should work in the background
• Words are not enough • Codes – uniquely idenJfy terms • Vocabulary – specialized, precise terms that remove ambiguity
• Ontology – describes nature of enJJes and their relaJons • ClassificaJon – groups related terms
![Page 7: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/7.jpg)
©2011 Regenstrief Institute and James Case
Potential Uses of Health Data are Constrained by Data Quality Factors • Data quality issues
• Different for client/paJent communicaJons vs. clinical decision support vs. epidemiological analysis
• O\en constrained by external forces • e.g. criteria for diagnosis o\en differs from the criteria for reporJng
• UnidirecJonal effect of data consolidaJon • Detailed → General • General → Detailed
![Page 8: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/8.jpg)
©2011 Regenstrief Institute and James Case
The Problem “In aFempJng to arrive at the truth, I have applied everywhere for informaJon, but in scarcely an instance have I been able to obtain hospital records fit for any purpose of comparison. If they could be obtained, they would enable us to decide many other quesJons… They would show [subscribers] how their money was being spent [and] what amount of good was really being done with it…”
Florence Nightingale -‐ Notes on a Hospital, 1873
![Page 9: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/9.jpg)
©2011 Regenstrief Institute and James Case
Test comparisons
Lab A Test Name: Lyme Disease Serology Measures: B. burgdorferi Ab IgG Method: ELISA Scale: quan7ta7ve e.g.: Titer 1:40
Lab B Test Name: Lyme Disease An7body Measures: B. burgdorferi Ab IgM Method: Immune blot Scale: qualita7ve e.g.: Posi7ve
LOINC Code = 5062-‐5 LOINC Code = 6321-‐4
What you see in the order list
![Page 10: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/10.jpg)
©2011 Regenstrief Institute and James Case
Why LOINC? “Within one laboratory, local jargon terms
may be used which are usually well understood between colleagues, but
would not be sufficiently widely known for communicaJon with the outside world.”
U. Forsum et al., Pure Appl. Chem 72:555-‐745, 2000 Proper3es and Units in the Clinical Laboratory Sciences Part VII. Proper3es and Units in Clinical Microbiology
![Page 11: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/11.jpg)
©2011 Regenstrief Institute and James Case
LOINC® 101 Emphasis on Laboratory
LOINC
![Page 12: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/12.jpg)
©2011 Regenstrief Institute and James Case
5193-‐8:Hepatitis B virus surface Ab:ACnc:Pt:Ser:Qn:EIA
5193-‐8 LOINC Code
Hepa77s B virus surface Ab
ACnc
Pt
Ser
Qn
EIA
Component
Property Measured
Timing
System
Scale
Method
There are six major LOINC axes
Anatomy of a LOINC Term
![Page 13: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/13.jpg)
©2011 Regenstrief Institute and James Case
What is NOT part of a LOINC Name? • The instrument used in tesJng • Specific details about the specimen • Priority (e.g. STAT) • Where tesJng was done • Who did the test • Test interpretaJon • Anything that is not an intrinsic part of the name of the result
• Other things that are carried in; • The OBR or OBX segment • An HL7 Version 3 ObservaJon Object
![Page 14: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/14.jpg)
©2011 Regenstrief Institute and James Case
The substance or enJty that is measured, evaluated, or observed
Component/Analyte
-‐ Sodium -‐ Glucose -‐ Brucella sp. organism -‐ Influenza A Virus anJgen -‐ Cytomegalovirus Virus anJbody -‐ Lipids.Total
5193-‐8:Hepatitis B virus surface Ab:ACnc:Pt:Ser:Qn:EIA
![Page 15: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/15.jpg)
©2011 Regenstrief Institute and James Case
Component/Analyte Structure
• Formal name of Analyte (e.g. Calcium) • Must specify any “subanalyte”
• e.g. Coronavirus Ag • May have a subclass – separated by “.”
• e.g. Calcium.Free
• Challenge -‐ e.g, 1H post 100 gm Glucose PO • Two subparts separated by “post” • <Jme delay> post <challenge type>
• Adjustments/correcJons • E.g. Adjusted to pH 7.4
Analyte Name^Challenge^Adjustments
![Page 16: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/16.jpg)
©2011 Regenstrief Institute and James Case
• Mass: ObservaJons reported with mass (milligrams, grams, etc.) in the numerator of their units of measure
• Substance: ObservaJons reported with moles or milliequivalents in the numerator of their units of measure
• Cataly7c ac7vity: ObservaJons that report enzymaJc acJvity • Arbitrary: Results that report arbitrary units in the numerator of
their units of measure • Number: Counts
Property
5193-‐8:Hepatitis B virus surface Ab:ACnc:Pt:Ser:Qn:EIA
The characterisJc or aFribute of the analyte that is measured, evaluated, or observed
the most difficult LOINC axis
Major Categories
![Page 17: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/17.jpg)
©2011 Regenstrief Institute and James Case
• MCnc – mass concentraJon (mass/unit vol) • MCnt – mass content (mass/unit mass) • NCnc – number concentraJon (number/unit vol) • TmStp – Jme • CCnc – catalyJc concentraJon (acJvity) • Prid – presence or idenJty • Imp – impression/interpretaJon • Find – subjecJve or objecJve observaJon • Type – “Kind-‐of”
Property
5193-‐8:Hepatitis B virus surface Ab:ACnc:Pt:Ser:Qn:EIA
the most difficult LOINC axis
Combine Major Categories with Subtypes for Full Property
![Page 18: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/18.jpg)
©2011 Regenstrief Institute and James Case
Common Issues with LOINC Properties
• FracJon = Part/whole • Number fracJon (NFr): % Eosinophils • Substance fracJon (SFr): % HGB which is A2
• RaJo = Measures mulJple analytes from the same system (specimen) • Mass concentraJon raJo -‐ MCrto
• e.g., BUN/Creat in urine specimen • Substance raJo-‐SCrto
• Urea/CreaJnine expressed as mmol/L (SI units)
• RelaJve RaJo = Measures from different systems • RelRto – mulJple of the median • RlTm – Jme from actual and normal control
FracJon (proporJon) vs. RaJo a/a+b vs. a/b
![Page 19: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/19.jpg)
©2011 Regenstrief Institute and James Case
• Pt -‐ at a point in Jme • 12H -‐ a twelve hour collecJon • 24H -‐ a twenty four hour collecJon
Timing*
*non-‐Pt Jmings are usually associated with RaJo Property
The interval of Jme over which the observaJon or measurement was made
![Page 20: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/20.jpg)
©2011 Regenstrief Institute and James Case
• Ser -‐ Serum • Bld -‐ Whole blood (RBC) • Ur-‐ Urine • BldA -‐ Arterial blood • Liver -‐ Liver • Flu – Body Fluid, unspecified
• Gast – Gastric fluid/contents • Food – Food or feedstuff • Tiss – Tissue • XXX – To be specified in
another part of the message
System The system (context) or specimen type upon which
the observaJon was made.
Super System Second subpart (^). When not included, “paJent” is the default. Used to indicated blood product unit (BPU), a bone
marrow donor, or a fetus. (e.g. Serum^BPU)
![Page 21: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/21.jpg)
©2011 Regenstrief Institute and James Case
• Qn -‐ QuanJtaJve • ConJnuous numeric (real, integer, raJo) • OpJonal operator (>, ≥, ≤, <)
• When assay detecJon limits are exceeded
• Ord -‐ Ordinal • a ranked set of possible values (1+, 2+, 3+)
• Nom -‐ Nominal • an unranked collecJon of possible values • a taxonomy (e.g list of bacteria)
• Nar -‐ NarraJve • free text narraJve (e.g., visit note)
Scale
![Page 22: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/22.jpg)
©2011 Regenstrief Institute and James Case
Scale (Special) • OrdQn – Ordinal or QuanJtaJve
• Primarily used for anJmicrobial observaJons e.g. MIC reported as resistant, intermediate, suscepJble or as the mm diameter of the inhibiJon zone
• Use is discouraged in other contexts • MulJ – structured text “globs”
• e.g. chromatography output • Use is discouraged
• Doc – Clinical documents • Set – Clinical aFachments (headers)
![Page 23: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/23.jpg)
©2011 Regenstrief Institute and James Case
Method • Methods only needed if interpretaJon affected
• Different normal ranges • Test SensiJvity/Specificity
• Generally listed only at the generic level • AggluJnaJon (limited subtypes) • Immunoassay • Probe with target amplificaJon
![Page 24: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/24.jpg)
©2011 Regenstrief Institute and James Case
Mapping Terms to LOINC Things to Remember
• The thing ordered is not always the thing measured: • Blood Culture – live organism(s) idenJfied • VDRL – Treponema pallidum Ab • Urinalysis – lots of different things
• The quesJon (what am I measuring? e.g. Glucose) is not the answer (e.g. 90 mg/dl) • You are mapping the quesJon, not the answer!
• You must know the specifics of the component being tested for (what is this test actually measuring?)
![Page 25: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/25.jpg)
©2011 Regenstrief Institute and James Case
What is in LOINC? Content
• Term structures • SubmiFed units, Example UCUM units
• aiming toward preferred units sorJng • Synonyms • Answer lists (increasing number) • Text descripJons – links to info sources about individual tests • Panel structures • Foreign language translaJons
![Page 26: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/26.jpg)
©2011 Regenstrief Institute and James Case
RELMA® Regenstrief LOINC Mapping Assistant
![Page 27: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/27.jpg)
©2011 Regenstrief Institute and James Case
Purpose of Tutorial • “Eliminate” need to read the User’s Manual • Become familiar with RELMA features • Provide some insight into mapping Jps/pi}alls • Help begin the mapping process for your insJtuJon
![Page 28: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/28.jpg)
©2011 Regenstrief Institute and James Case
• LOINC files and indexes • Manual and automated mapping funcJons • Same free use as LOINC (see license) • RELMA tools transform local words in local file
• User creates file of local term/name and codes
• Assigns LOINC term to local test/baFery code • “Common tests” subset to speed mapping • Context sensiJve hierarchies for local use. • Flexible “Google-‐like” search funcJons
RELMA Functions
![Page 29: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/29.jpg)
©2011 Regenstrief Institute and James Case
New in This Version (Rel. 5.2) • Searches now have opJon to use “Auto Mapper” methods
• Select "Use Auto Mapper Search" checkbox. • Revised screen for reviewing Terms Mapped to Deprecated/
Discouraged LOINCs • The "Replacement LOINC" secJon gives the user access to all the replacement LOINC codes.
• The Comment field has been added. (RaJonal for replacement term)
• Added navigaJon buFons. • Lucene proximity and fuzzy searches are now supported on
the mapping and simple search screens. • Lucene score is displayed on the mapping and the simple
search screens.
![Page 30: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/30.jpg)
©2011 Regenstrief Institute and James Case
• Column headers on screens are the same as Lucene field names. • Example: [ ExUnits:mg ] -‐"ExUnits" = example units.
• Double-‐clicking displays the details for selected row.
• LOINC Part quoJents (e.g. "CreaJne kinase.MB/CreaJne kinase.total“) displayed in the Part secJon of details screen.
New in This Version (Rel. 5.2)
![Page 31: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/31.jpg)
©2011 Regenstrief Institute and James Case
LOINC Web Site
![Page 32: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/32.jpg)
©2011 Regenstrief Institute and James Case
What’s available to download? • RELMA -‐ mapping and browsing tool
• HL7 message converter-‐ Makes a database suitable for mapping
• HL7 lint (finds bad messages) • LOINC database and spreadsheets • LOINC User guide; RELMA User Guide • Tools to assist language translaJons by part • Tools for building databases to map from HL7 messages
• New guidance documents for mappers
32
![Page 33: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/33.jpg)
©2011 Regenstrief Institute and James Case
RELMA Highlights • Browse-‐able hierarchies of LOINC parts • Display search results in tree view • Enhanced “details” view of terms/parts
• References • DescripJons • Sample units
• Empirically-‐derived common test list • Special features for panels/forms • Enhanced export/copy-‐paste opJons
![Page 34: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/34.jpg)
©2011 Regenstrief Institute and James Case
Installing RELMA®
![Page 35: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/35.jpg)
©2011 Regenstrief Institute and James Case
Installation Steps • Make sure you have enough free disk space!
• 2Gb is recommended
• From CD -‐ Start – Run – <drive>:\RELMA\Setup
• Specify installaJon directory • Life will be easier if you accept the default
• Two database files installed • RELMA.MDB – LOINC Terms Database • LMOF3.MDB – Local Master ObservaJon File
• Two sample files included • Run from Start – (All) Programs – Regenstrief – RELMA
![Page 36: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/36.jpg)
©2011 Regenstrief Institute and James Case
File Locations • Database and Ancillary Files
• Windows XP = C:\Documents and SeMngs\All Users\Documents\RELMA\
• Windows Vista = C:\Users\Public\Documents\RELMA\ • Windows 7 = C:\Users\Public\Documents\RELMA\
• Sample files • Windows XP = C:\Documents and SeMngs\All Users\Documents\RELMA\Samples\
• Windows Vista = C:\Users\Public\Documents\RELMA\Samples\
• Windows 7 = C:\Users\Public\Documents\RELMA\Samples\
![Page 37: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/37.jpg)
©2011 Regenstrief Institute and James Case
Running RELMA® Version 5.2
![Page 38: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/38.jpg)
©2011 Regenstrief Institute and James Case
Copyright Screen
![Page 39: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/39.jpg)
©2011 Regenstrief Institute and James Case
Main Menu/Welcome Screen
![Page 40: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/40.jpg)
©2011 Regenstrief Institute and James Case
Set Preferred Language
Click File, Set Preferred Language
![Page 41: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/41.jpg)
©2011 Regenstrief Institute and James Case
Select Linguistic Variant(s)
Selecting a translation may require indexes to be built
![Page 42: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/42.jpg)
©2011 Regenstrief Institute and James Case
LOINC Terms with Spanish Linguistic Variant
All Spanish!
![Page 43: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/43.jpg)
©2011 Regenstrief Institute and James Case
Setting User Preferences
![Page 44: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/44.jpg)
©2011 Regenstrief Institute and James Case
Select User Preferences From the File Menu
Set User Preferences
...or from Welcome Screen
![Page 45: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/45.jpg)
©2011 Regenstrief Institute and James Case
Set User Preference Dialog
Startup Screen Preference
New File Locations: (See prior slide for location)
![Page 46: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/46.jpg)
©2011 Regenstrief Institute and James Case
User Map Screen Preferences
Click Map Screen Tab
Include/Exclude Battery Terms
Add comments on Mappings
![Page 47: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/47.jpg)
©2011 Regenstrief Institute and James Case
Importing Local Terms into RELMA
![Page 48: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/48.jpg)
©2011 Regenstrief Institute and James Case
4 Ways to Load LMOF Files • Direct entry into LMOF from within RELMA (painful)
• Handy for individual entries/edits
• Create an Access table that mimics the LMOF structure (less painful but tedious) • Appendix A: RELMA Manual
• Create a delimited ASCII file from your local test catalog (good choice)
• Load directly from HL7 v2.x messages • Pulls data from OBR and OBX segments • Stores NTE segment data
![Page 49: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/49.jpg)
©2011 Regenstrief Institute and James Case
Constructing a Local Dataset Create extract of your test catalog with:
• BaFery/Panel Code • BaFery/Panel DescripJon or Name • *Local Code • *Test DescripJon or Name
• Include Method if Important • Units • Example Values • Laboratory SecJon
![Page 50: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/50.jpg)
©2011 Regenstrief Institute and James Case
Creating Delimited ASCII File • RELMA can’t parse free text
• Need to create separate fields • Can use any of these delimiters
• Tab, Semicolon, Comma, Space • Can define your own
• Fields can be in any order • Minimum required fields
• Local Code • Local DescripJon • Units (highly recommended)
![Page 51: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/51.jpg)
©2011 Regenstrief Institute and James Case
Entering New Local Terms into RELMA
![Page 52: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/52.jpg)
©2011 Regenstrief Institute and James Case
Manual Enter/Edit
View/Add/Edit Local Terms
![Page 53: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/53.jpg)
©2011 Regenstrief Institute and James Case
Edit Term Dialog
Edit\Add\Delete Terms Export Terms
Print Preview List Text alignment option
![Page 54: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/54.jpg)
©2011 Regenstrief Institute and James Case
Export Local Term File
Delimiters supported: Tab, comma, bar (|)
![Page 55: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/55.jpg)
©2011 Regenstrief Institute and James Case
Add Local Term
Click to Add to Current Working File
MICRO!
BUBPLAG!BUBONIC PLAGUE – RRT PCR!
![Page 56: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/56.jpg)
©2011 Regenstrief Institute and James Case
Search Local Term File
Enter Keyword from any Field Return to Full List
Calcium
![Page 57: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/57.jpg)
©2011 Regenstrief Institute and James Case
Print Preview Local Term File
![Page 58: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/58.jpg)
©2011 Regenstrief Institute and James Case
Steps to Import Local Terms 1. Click Import Local Terms BuFon from Main Menu
a) File>Import Local Terms from Delimited File 2. Locate your local terms text file
a) E.g. WinXP Sample files loaded into C:\Documents and SeMngs\All Users\Shared Documents\RELMA
3. Name your Working Set a) LMOF database can contain mulJple work sets
4. Define default secJon (OpJonal) 5. IdenJfy file delimiter 6. Assign fields to LMOF aFributes
a) Ignore fields you don’t need b) Combine fields if needed
7. Check “Case-‐sensiJve” if needed 8. Click Import.
![Page 59: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/59.jpg)
©2011 Regenstrief Institute and James Case
Example Tab-‐Delimited File
![Page 60: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/60.jpg)
©2011 Regenstrief Institute and James Case
Importing Local Files
Select Import Local Terms from Delimited File…
![Page 61: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/61.jpg)
©2011 Regenstrief Institute and James Case
Navigate to File Location Select File and Click Open Sample jiles stored in
RELMA Directory
![Page 62: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/62.jpg)
©2011 Regenstrief Institute and James Case
Open File in RELMA
Name your working set. RELMA allows multiple sets in
LMOF database
Select your delimiter
Import Button
![Page 63: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/63.jpg)
©2011 Regenstrief Institute and James Case
Fields Segregated
Assign LMOF Attribute
Choose jield name
![Page 64: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/64.jpg)
©2011 Regenstrief Institute and James Case
Ready to Import
Minimum assignments
Now you can click the Import button!
![Page 65: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/65.jpg)
©2011 Regenstrief Institute and James Case
Post-‐Processing of Local File
• A\er import, RELMA Searches for terms (words) that it does not recognize
• Stored in a file for future reconciliaJon
![Page 66: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/66.jpg)
©2011 Regenstrief Institute and James Case
Local Term File Options
![Page 67: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/67.jpg)
©2011 Regenstrief Institute and James Case
Change Local Term File
Select the Working Set
Current mapping status
![Page 68: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/68.jpg)
©2011 Regenstrief Institute and James Case
Alternative Pragmatic Way • Use large set of HL7 messages • AutomaJcally make dataset of:
• OBR ID • OBR descripJon • OBX ID • OBX descripJon • Sample of results with
• Real values • Units • Abnormal flags • Normal ranges
![Page 69: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/69.jpg)
©2011 Regenstrief Institute and James Case
Generate Local term jile from HL7 messages
Select Import Terms from HL7 File
![Page 70: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/70.jpg)
©2011 Regenstrief Institute and James Case
Select File to Import
Select HL7 File
![Page 71: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/71.jpg)
©2011 Regenstrief Institute and James Case
Specify HL7 File Name and Sample Size
Name the Local Term File (working set)
Select which codes to store
Skip import of sample values
Select the number of sample values
![Page 72: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/72.jpg)
©2011 Regenstrief Institute and James Case
HL7 Messages Data Statistics
![Page 73: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/73.jpg)
©2011 Regenstrief Institute and James Case
New Terms added to LMOF
New Battery Code
Click on “Edit Term” to see Sample Data
![Page 74: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/74.jpg)
©2011 Regenstrief Institute and James Case
Sample Results for Observation New Test Code
Sample Values from Messages
![Page 75: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/75.jpg)
©2011 Regenstrief Institute and James Case
Lenny L’OINC says: “Load the Sample Files Into RELMA now!”
• Import the two sample files provided • Import_Sample_OBR.txt
• Contains baFery code and descripJon
• Import_Sample_OBX.txt • Contains test code and descripJon
• Create 2 working sets • Load your personal data set
![Page 76: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/76.jpg)
©2011 Regenstrief Institute and James Case
Cleaning your data
![Page 77: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/77.jpg)
©2011 Regenstrief Institute and James Case
Preparing your Data for Mapping
• Improve mapping success by: • Expanding abbreviaJons • Standardizing colloquial terms • Ignoring “administraJve” terms • Standardizing Jme references
• Can be done prior to imporJng • BeFer to use tools built into RELMA
![Page 78: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/78.jpg)
©2011 Regenstrief Institute and James Case
RELMA Cleaning Tools Use this tool to edit unknown terms
![Page 79: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/79.jpg)
©2011 Regenstrief Institute and James Case
Review Unknown Local Terms
May Re-‐Scan File for Unknown Terms
![Page 80: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/80.jpg)
©2011 Regenstrief Institute and James Case
Replace Local Terms
Assign LMOF Attribute Replacement Options
![Page 81: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/81.jpg)
©2011 Regenstrief Institute and James Case
RELMA Cleaning Tools Use this tool to make global substitutions
![Page 82: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/82.jpg)
©2011 Regenstrief Institute and James Case
Term Substitution
Save this global substitution for only this working set
![Page 83: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/83.jpg)
©2011 Regenstrief Institute and James Case
Lenny L’OINC says: “Begin to clean your
data now!”
• Using the OBR or OBX sample files, take 15-‐20 minutes to clean up these unrecognized terms • You may use your own data if you wish.
![Page 84: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/84.jpg)
©2011 Regenstrief Institute and James Case
Searching for LOINC Terms
![Page 85: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/85.jpg)
©2011 Regenstrief Institute and James Case
Simplijied Search Only Tool
![Page 86: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/86.jpg)
©2011 Regenstrief Institute and James Case
Search Window
Enter Search Terms Limit to
Specijic Units Limit to Common
Tests
Use Automapper logic
Help File
“Common Tests” rank Restrict to “Common Tests”
New! Lucene score indicates relevance of search result
![Page 87: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/87.jpg)
©2011 Regenstrief Institute and James Case
New RELMA Helpjile
![Page 88: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/88.jpg)
©2011 Regenstrief Institute and James Case
Context Menu
Right click to bring up context menu
![Page 89: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/89.jpg)
©2011 Regenstrief Institute and James Case
Mapping Local Terms
![Page 90: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/90.jpg)
©2011 Regenstrief Institute and James Case
Mapping Local Terms
• Select your Working Set to Map • File>Select Local Term File to Process
• Select “Map Local Terms to LOINC” from Welcome Screen
• Select the subset of terms to work with: • All • Mapped • Unmapped
• Set your Search Limits • Set Search Limits BuFon
![Page 91: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/91.jpg)
©2011 Regenstrief Institute and James Case
Standard Mapping Window Features
• Customizable grid • View details of LOINC term • Sort by column
• Click column • Custom Sort
• Print or export results grid • Spell check squiggly line to signify words not known to RELMA
![Page 92: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/92.jpg)
©2011 Regenstrief Institute and James Case
Mapping Screen View or edit local term
Quick select button list
Custom Grid Conjiguration
Enter local term number
![Page 93: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/93.jpg)
©2011 Regenstrief Institute and James Case
Conjigure Grid
Reorder grid elements
Select elements to display
Reset Default Conjiguration Visually resize elements
![Page 94: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/94.jpg)
©2011 Regenstrief Institute and James Case
Quick choice buttons
Viewing LOINC term detail
![Page 95: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/95.jpg)
©2011 Regenstrief Institute and James Case
View Local Term Details
Select level of detail to display
![Page 96: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/96.jpg)
©2011 Regenstrief Institute and James Case
View Local Term Details Select text size
![Page 97: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/97.jpg)
©2011 Regenstrief Institute and James Case
Select detail display level
Select level of detail to display
![Page 98: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/98.jpg)
©2011 Regenstrief Institute and James Case
Standard Mapping Screen
Begin a search (or hit “enter”)
EEK! What’ll I do?!
![Page 99: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/99.jpg)
©2011 Regenstrief Institute and James Case
Standard Mapping Screen
Click to show words used in search
![Page 100: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/100.jpg)
©2011 Regenstrief Institute and James Case
Initial Mapping Results
Use term checkbox
Number of LOINC terms containing
keyword
Battery terms included in search
![Page 101: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/101.jpg)
©2011 Regenstrief Institute and James Case
Revised Mapping Results
Number of matching
records found
Match units selected by default
![Page 102: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/102.jpg)
©2011 Regenstrief Institute and James Case
Re-‐revised Mapping Results
Number of matching
records found Match units unselected
![Page 103: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/103.jpg)
©2011 Regenstrief Institute and James Case
Standard Mapping Screen
Clear all input jields
Enter keywords here
CANINE DISTEMPER VIRUS IF
![Page 104: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/104.jpg)
©2011 Regenstrief Institute and James Case
Ad hoc term search
![Page 105: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/105.jpg)
©2011 Regenstrief Institute and James Case
Standard Mapping Screen
Navigate through the local terms
![Page 106: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/106.jpg)
©2011 Regenstrief Institute and James Case
Tabbed Access to Functions
Navigate to Functions from Mapping Page
Switch between Grid and Tree Views
![Page 107: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/107.jpg)
©2011 Regenstrief Institute and James Case
Tree View
![Page 108: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/108.jpg)
©2011 Regenstrief Institute and James Case
Tree View • Results displayed hierarchically
• Defined by the mulJ-‐axial hierarchy in search restricJons (covered later)
• Map to a term in tree by clicking Map buFon or double clicking term • Only rows that have LOINC Codes
![Page 109: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/109.jpg)
©2011 Regenstrief Institute and James Case
Tree View
Cannot map to terms
representing LOINC parts
Can map to terms with LOINC Codes
Tree Navigation Buttons
![Page 110: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/110.jpg)
©2011 Regenstrief Institute and James Case
Assigning a LOINC Map
Highlight correct term
Click “Map” Button (or doubleclick)
![Page 111: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/111.jpg)
©2011 Regenstrief Institute and James Case
Adding Mapping Comments
If comments option is selected, prompt appears
Check with Frank in Chemistry
![Page 112: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/112.jpg)
©2011 Regenstrief Institute and James Case
Assigning a LOINC Map
LOINC Term Assigned
![Page 113: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/113.jpg)
©2011 Regenstrief Institute and James Case
View LOINC Term Details
View details for a specijic LOINC Term
Right clicking on a LOINC term brings up a Task Menu
![Page 114: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/114.jpg)
©2011 Regenstrief Institute and James Case
LOINC Term Details
Can scroll through returned subset of
terms Change to expanded
details view
Change text size
Can scroll down a single formatted page
![Page 115: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/115.jpg)
©2011 Regenstrief Institute and James Case
View Panel Children
Select View Panel Children from context menu
![Page 116: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/116.jpg)
©2011 Regenstrief Institute and James Case
Panel Children
![Page 117: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/117.jpg)
©2011 Regenstrief Institute and James Case
Conjigure Export Options
Output Options Include
column headers Save Conjiguration and/or Export
![Page 118: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/118.jpg)
©2011 Regenstrief Institute and James Case
Excel Export Format
![Page 119: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/119.jpg)
©2011 Regenstrief Institute and James Case
More on Searching Mapping Screen
![Page 120: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/120.jpg)
©2011 Regenstrief Institute and James Case
Basic Search Syntax Special Character(s)
Example Defini7on
“ “ Influenza “virus A” Linked terms must appear together
AND Morphine AND Opiates
Both terms must appear in the search result term
OR Influenza OR Parainfluenza
Either or both terms must appear in the search result term
NOT Influenza NOT equine Excludes terms with the word following the NOT. Cannot be used alone.
? Gluc?se (glucose,glucase)
SubsJtutes a single character in the string. Cannot be used as the first character; cannot be used in “phrases”
* Gluc*se (glucose, glucuronidase, etc.)
SubsJtute mulJple characters in the string. Cannot be used as the first character; cannot be used in “phrases”
![Page 121: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/121.jpg)
©2011 Regenstrief Institute and James Case
Search Qualijiers
Includes Glucuronidase, Glucosidase,
Glucosylceramidase, etc.
Detailed help available
![Page 122: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/122.jpg)
©2011 Regenstrief Institute and James Case
Combining Search Terms
Reduced number of terms
Exclude Glucosidase
![Page 123: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/123.jpg)
©2011 Regenstrief Institute and James Case
Advanced Search Syntax based on Google-‐like search syntax
Parameter Descrip7on
+ Term must be included in search
-‐ Term must be excluded from the search
( ) Group terms for subquery (i.e. A OR B; A AND B)
Fieldname: Limit term search to the associated field (e.g. Component: glucose)
Fieldname:() Group mulJple terms in a single field
~ Fuzzy search (e.g. Hemo�ilus~)
“ “~ Proximity search for mulJple terms (e.g. “funcJon panel”~1)
{}, [] Upper and lower bounds; {} exclusive, [] inclusive
\ Special character escape
![Page 124: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/124.jpg)
©2011 Regenstrief Institute and James Case
Applying advanced search
![Page 125: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/125.jpg)
©2011 Regenstrief Institute and James Case
Limiting Searches
![Page 126: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/126.jpg)
©2011 Regenstrief Institute and James Case
Setting Search Limits
• Narrows search to specific subset of LOINC terms • Reduces number of candidate terms • Limits can be applied to all components • Component aFribute can be further restricted by number of words
• Tree structure allows for hierarchical constraints
![Page 127: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/127.jpg)
©2011 Regenstrief Institute and James Case
General Search Constraints • Controls features including:
• Limit to LOINC terms compaJble with submiFed units • Forced match with any specimen contained in name • Method-‐less terms only • Limit to components/analytes with N or fewer words in their name
• Pop up search Jming staJsJcs a\er each search • Use carefully or search may not be successful
(Note parallel control switches at boFom of screen)
![Page 128: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/128.jpg)
©2011 Regenstrief Institute and James Case
Setting Search Limits
Click Hierarchy & Search Limits Tab
![Page 129: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/129.jpg)
©2011 Regenstrief Institute and James Case
Setting search limits Can also set most of them by toggling buFons
at the boFom of the screen
Toggle Buttons
![Page 130: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/130.jpg)
©2011 Regenstrief Institute and James Case
Search Constraints
Predejined, general search constraints
Attribute trees
Local Unit Constraint: Default is “ON”
New! Type toggle boxes
![Page 131: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/131.jpg)
©2011 Regenstrief Institute and James Case
Terms Consistent with Units
Only terms consistent with mmol/L appear
![Page 132: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/132.jpg)
©2011 Regenstrief Institute and James Case
Setting Search Limits
Specimen constraints
![Page 133: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/133.jpg)
©2011 Regenstrief Institute and James Case
Terms Consistent with Specimen
CSF
Enter default Specimen
![Page 134: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/134.jpg)
©2011 Regenstrief Institute and James Case
Terms Consistent with Specimen
Only CSF Terms are returned
![Page 135: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/135.jpg)
©2011 Regenstrief Institute and James Case
Setting Search Limits
Methodless Terms Restriction
Override Methodless Terms Restriction
![Page 136: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/136.jpg)
©2011 Regenstrief Institute and James Case
Limit to Methodless Terms
![Page 137: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/137.jpg)
©2011 Regenstrief Institute and James Case
Limit to Methodless Terms
Only Methodless Terms Appear
![Page 138: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/138.jpg)
©2011 Regenstrief Institute and James Case
More on Methodless Terms • Some LOINC categories do not have methodless terms
• Checking methodless only will remove these from view on results grid
• Checking addiJonal box allows these to be seen
![Page 139: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/139.jpg)
©2011 Regenstrief Institute and James Case
Methodless Only Unchecked
All terms returned
![Page 140: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/140.jpg)
©2011 Regenstrief Institute and James Case
Methodless Only Checked
Only Methodless terms returned
Differ in one or more components
![Page 141: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/141.jpg)
©2011 Regenstrief Institute and James Case
Conditional Methodless
More terms returned
No methodless term; all shown
![Page 142: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/142.jpg)
©2011 Regenstrief Institute and James Case
Setting Search Limits
Limit to Lab Tests Only (No Clinical LOINC Terms)
![Page 143: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/143.jpg)
©2011 Regenstrief Institute and James Case
Setting Search Limits
Limit to common lab tests
![Page 144: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/144.jpg)
©2011 Regenstrief Institute and James Case
Setting Search Limits
Limit Number of Words in the Component Attribute
![Page 145: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/145.jpg)
©2011 Regenstrief Institute and James Case
Limit Number of Component Words
Without Limit Applied: 792 terms returned
![Page 146: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/146.jpg)
©2011 Regenstrief Institute and James Case
Limit Number of Component Words
With Limit Applied: 57 terms returned
Restriction appears on Toggle Bar
(cannot toggle off)
Component limited to 1 word
![Page 147: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/147.jpg)
©2011 Regenstrief Institute and James Case
Setting Search Limits
Include Trial, Deprecated or Discouraged LOINC Codes with
Returned Terms
![Page 148: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/148.jpg)
©2011 Regenstrief Institute and James Case
Include Deprecated LOINC Terms
Deprecated LOINC Terms appear as Strikethrough Text with a “Do Not”
Symbol
-‐ You cannot map to deprecated LOINC terms -‐ You are warned before mapping to discouraged LOINC terms
Discouraged LOINC Terms appear as an inverted triangle
![Page 149: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/149.jpg)
©2011 Regenstrief Institute and James Case
Favor Property Restriction
Favor one type of property over others
All other components being equal MCnc
only will be displayed
![Page 150: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/150.jpg)
©2011 Regenstrief Institute and James Case
Order/Observation Restriction
Order or Observation preference
![Page 151: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/151.jpg)
©2011 Regenstrief Institute and James Case
LOINC Hierarchies – Class Tree
Three top-‐level branches
Tree Navigation Buttons
![Page 152: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/152.jpg)
©2011 Regenstrief Institute and James Case
Before Class Restriction
Large number of candidate terms
Most terms have class of “CHAL”
![Page 153: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/153.jpg)
©2011 Regenstrief Institute and James Case
Search Trees
+Non +Chem
Restrict eligible tests to non-‐challenge
chemistry tests only
![Page 154: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/154.jpg)
©2011 Regenstrief Institute and James Case
Following Class Restriction
Only Non-‐Challenge Chemistry tests
returned
![Page 155: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/155.jpg)
©2011 Regenstrief Institute and James Case
Improvements to Trees
Continued reorganization to provide a Specimen
hierarchy
![Page 156: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/156.jpg)
©2011 Regenstrief Institute and James Case
Improved Hierarchy for Component
Show the LOINC Codes associated with these
components
Click on details for more information about the
selection
![Page 157: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/157.jpg)
©2011 Regenstrief Institute and James Case
Details Screen LOINC Part
![Page 158: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/158.jpg)
©2011 Regenstrief Institute and James Case
Show Associated LOINCs
![Page 159: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/159.jpg)
©2011 Regenstrief Institute and James Case
LOINC Term Details Screen
Detailed Information on LOINC Parts
![Page 160: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/160.jpg)
©2011 Regenstrief Institute and James Case
Tree Export Tools
Conjigure Export Format
Export according to Conjiguration
![Page 161: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/161.jpg)
©2011 Regenstrief Institute and James Case
Tree Export Conjiguration
![Page 162: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/162.jpg)
©2011 Regenstrief Institute and James Case
RELMA -‐ Tree Features • All trees operate the same way • Shows terms spelled out • Can expand and collapse parts or all of tree. • Tree is string searchable • Search can be based on one or more branches of a tree with or without other criteria
• Use “Clear Most Limits” buFon on Mapping Screen to remove all tree selecJons
![Page 163: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/163.jpg)
©2011 Regenstrief Institute and James Case
LOINC Part Search
• Same look as term search • Uses “Google-‐like” query language
• Extremely fast • Include and exclude criteria • ParJal string matching (using wildcards)
• Demo • Campylobacter fetus, not Ab
![Page 164: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/164.jpg)
©2011 Regenstrief Institute and James Case
Navigating through the Mapping Process
![Page 165: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/165.jpg)
©2011 Regenstrief Institute and James Case
• Limit effort to one lab secJon at a Jme and focus experJse
• Chemistry and hematology will be easiest • For manufactured assays, use package insert as source informaJon
• Sample results give clue to property and scale • Consider prioriJzing by frequency of use
LOINC Mapping Tactics
![Page 166: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/166.jpg)
©2011 Regenstrief Institute and James Case
Vreeman DJ, Finnell JT, Overhage JM. A Rationale for Parsimonious Laboratory Term Mapping by Frequency. AMIA Annu Symp Proc. 2007;:771-‐775.
![Page 167: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/167.jpg)
©2011 Regenstrief Institute and James Case
More LOINC Mapping Tactics • Try using method-‐less terms first
• Specific methods can be transmiFed in: • OBX–17 (v2.x), ObservaJon.methodCode (v3.0)
• Examine local units or real results to verify correct property and scale • ProperJes are rarely disJnguishable in test names
• You don’t have to do it all at one siMng • Use the “Unmapped” funcJon to return where you le\ off
• With every release -‐ Update previous mappings to idenJfy deprecated terms
![Page 168: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/168.jpg)
©2011 Regenstrief Institute and James Case
Common Mapping Issues
• Locally Defined Test Name Ambiguity • Reuse of local test code
• “Analyte-‐free” Local Test Names • (Miscellaneous serology)
• Incongruent Value sets (Scale ambiguity) • Result vs. InterpretaJon • Available LOINC Terms too Specific/General • Panel vs. Discrete Test
• Common in Microbiology
![Page 169: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/169.jpg)
©2011 Regenstrief Institute and James Case
Using your Mapped Terms
• Print results of LOINC Mapping • Export to File
![Page 170: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/170.jpg)
©2011 Regenstrief Institute and James Case
Conjigure Export Format
Context Sensitive Export Conjiguration
![Page 171: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/171.jpg)
©2011 Regenstrief Institute and James Case
LMOF Export Conjiguration
Select Fields to Export
Select Export Format
Save Conjiguration and Export
![Page 172: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/172.jpg)
©2011 Regenstrief Institute and James Case
Print Mapped Terms from View/Add/Edit Menu
May highlight terms to be printed
Click Print button to Preview output
![Page 173: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/173.jpg)
©2011 Regenstrief Institute and James Case
Formatted Report Output
Click Print button to output formatted report
![Page 174: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/174.jpg)
©2011 Regenstrief Institute and James Case
Custom Export Conjiguration
Select the Fields you wish to Export
Select the Format you wish to Export
![Page 175: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/175.jpg)
©2011 Regenstrief Institute and James Case
Excel™ Export
![Page 176: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/176.jpg)
©2011 Regenstrief Institute and James Case
New and Improved Lab Auto Mapper
• Run in batch mode to find N-‐ closest terms • Can then use this output to do final mapping • Again units are VERY important • Can pick all limits available to regular mapping
![Page 177: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/177.jpg)
©2011 Regenstrief Institute and James Case
Picking the Lab Auto Mapper
![Page 178: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/178.jpg)
©2011 Regenstrief Institute and James Case
Lab Auto Mapper Start Screen
Maximum number of terms to return
Can restrict search to common tests
![Page 179: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/179.jpg)
©2011 Regenstrief Institute and James Case
Lab Auto Mapper Start Screen
Local terms used for mapping
Local test code
![Page 180: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/180.jpg)
©2011 Regenstrief Institute and James Case
Lab Auto Mapper -‐ Mapping Screen
![Page 181: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/181.jpg)
©2011 Regenstrief Institute and James Case
Exporting Mapped Terms
Export Terms to Delimited File
![Page 182: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/182.jpg)
©2011 Regenstrief Institute and James Case
Export Terms Dialog
Check Fields you wish to export
Select Delimiter
Select Term Set
![Page 183: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/183.jpg)
©2011 Regenstrief Institute and James Case
Other RELMA® Features
![Page 184: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/184.jpg)
©2011 Regenstrief Institute and James Case
Panels, Forms and Survey Review
Review Panels, Forms and Surveys
Review Panels, Forms and Surveys
![Page 185: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/185.jpg)
©2011 Regenstrief Institute and James Case
Government Forms
Form Name
Component LOINC terms
![Page 186: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/186.jpg)
©2011 Regenstrief Institute and James Case
Laboratory Panels
Expand category to see panels
Double-‐click panel name to see
components
![Page 187: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/187.jpg)
©2011 Regenstrief Institute and James Case
Expanded Panel Detail
![Page 188: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/188.jpg)
©2011 Regenstrief Institute and James Case
Expanded Clinical Panel
![Page 189: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/189.jpg)
©2011 Regenstrief Institute and James Case
Clinical Panels
Find where a term has been used
35089-2, 35090-0
![Page 190: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/190.jpg)
©2011 Regenstrief Institute and James Case
LOINC Term Panel Usage
![Page 191: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/191.jpg)
©2011 Regenstrief Institute and James Case
Other Survey Instruments
![Page 192: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/192.jpg)
©2011 Regenstrief Institute and James Case
HIPAA Attachments
View Various HIPAA Attachments
![Page 193: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/193.jpg)
©2011 Regenstrief Institute and James Case
HIPPA Attachment Tree
![Page 194: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/194.jpg)
©2011 Regenstrief Institute and James Case
Expanded Attachment Data
![Page 195: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/195.jpg)
©2011 Regenstrief Institute and James Case
Can’t jind the term you want?
![Page 196: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/196.jpg)
©2011 Regenstrief Institute and James Case
Search Hints and Tips • Keywords with zero frequency are ignored
• May need to rephrase – use synonym • Some causes for no returned terms
• Too many keywords in search – uncheck some • Limits applied that don’t make sense
• E.g. Method-‐less tests plus Method tree set to EIA • Did not find and revise words not in RELMA
• Local units not in RELMA
• Units are GREAT discriminators • You may have tests that need to be added to LOINC
![Page 197: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/197.jpg)
©2011 Regenstrief Institute and James Case
Proposing New LOINC Terms
![Page 198: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/198.jpg)
©2011 Regenstrief Institute and James Case
Proposing New Terms • Make sure the term is really needed
• Think of other names for the same concept • Avoid detailed methods or localizaJons • Is the disJncJon really important?
• Supply sufficient annotaJon to jusJfy the new term • Package inserts, sample reports (email to Regenstrief) • The more the beFer!
• Construct new terms within RELMA • File>Propose a new LOINC
• Linked to the “trees” to allow browsing • Can review and submit them to LOINC from within RELMA
![Page 199: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/199.jpg)
©2011 Regenstrief Institute and James Case
Propose new LOINC terms
Select Propose a new LOINC
![Page 200: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/200.jpg)
©2011 Regenstrief Institute and James Case
Required jields in red
Navigate through proposed terms
Create new term, save current term
or Exit form
![Page 201: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/201.jpg)
©2011 Regenstrief Institute and James Case
Preview Proposed Terms
Review your new terms
![Page 202: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/202.jpg)
©2011 Regenstrief Institute and James Case
Review Proposed Terms
All proposed terms fully editable
Choose whether to send or postpone
X
X X
James T. Case DVM, PhD
NIH/NLM
301-555-1314
301-555-1315
![Page 203: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/203.jpg)
©2011 Regenstrief Institute and James Case
Submitting New Terms • Must supply name, organizaJon, phone and email of submiFer
• Must select at least one proposed term to send
• “Configure export” does not affect submission output
• Email resulJng file to Regenstrief
![Page 204: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/204.jpg)
©2011 Regenstrief Institute and James Case
Use Existing Terms as Template
Select your closest match
Click the Propose Term button
![Page 205: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/205.jpg)
©2011 Regenstrief Institute and James Case
Use Existing Terms as Template
All required components jilled in
![Page 206: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/206.jpg)
©2011 Regenstrief Institute and James Case
Using LOINC and SNOMED Together
![Page 207: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/207.jpg)
©2011 Regenstrief Institute and James Case
Where do LOINC and SNOMED Fit?
• LOINC represents the quesJon: • Is there any Botulism toxin in my specimen? (33708-‐9)
• Organisms idenJfied in specimen? (634-‐6)
• SNOMED represents the answer: • NegaJve (SCTID 260385009) • E. coli O157:H7 (SCTID 103429008)
Remember:
![Page 208: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/208.jpg)
©2011 Regenstrief Institute and James Case
Where do LOINC and SNOMED Fit? • In an HL7 message, LOINC may be used:
• In OBR-‐4 (Universal Service IdenJfier) • In OBX-‐3 (ObservaJon IdenJfier
• SNOMED may be used: • In OBX-‐5 (where nominal values are needed) • Almost anyplace else in an HL7 message where coded values are needed
![Page 209: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/209.jpg)
©2011 Regenstrief Institute and James Case
The code is from SNOMED
The code is from LOINC
OBX-‐5: Data A code for L.
monocytogenes
A code that identijies the data type in OBX-‐5 as a
coded element
OBX: With a Coded Value
OBX-‐3:A code that identijies the data in
OBX-‐5 (Listeria culture)
OBX||CE|6609-2^Listeria ID^LN||36094007^L. monocytogenes^SCT
![Page 210: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/210.jpg)
©2011 Regenstrief Institute and James Case
HL7 2.5 Example (ER-‐7 format) MSH|^~\&| LABGL1|| DMCRES|| 199812300100|| ORU^ R01|
LABGL1199510221838581| P| 2.3||| NE| NE PID||| 6910828^ Y^ C8|| Newman^ Alfred^ E|| 19720812| M|| W| 25 Centscheap Ave^^ Whatmeworry^ UT^ 85201^^ P||( 555) 777- 6666|( 444) 677- 7777|| M|| 773789090 OBR|| 110801^ LABGL| 387209373^ DMCRES|634-6^Bacteria XXX Aerobe Cult ^LN||| 199812292128||||||||Stool| IN2973^ Schadow^ Gunther^^^^ MD^
UPIN|||||||||||||||| CA20837^ Spinosa^ John^^^^ MD^ UPIN OBX|| CE| 634-6^Bacteria XXX Aerobe Cult^ LN||50136005^Salmonella typhimurium
^SCT|||||| F||| 199812292128|| CA20837 OBR|| 110801^ LABGL| 387209373^ DMCRES| 29567-9^Bacterial Susceptibility
Panel^ LN||| 199812300934||||||||Bacterial isolate| IN2973^ Schadow^ Gunther^^^^ MD^ UPIN||||||||| Salmonella typhimurium ||||||| CA20837^ Spinosa^ John^^^^ MD^ UPIN
OBX|| CE|23631-5^Trimethoprim/Sulfasoxazole^ LN||264841006^Intermediate
^SCT|||||| F||| 199812300934|| CA20837 OBX|| CE|18967-7^Penicillin^LN||30714006^Resistant^SCT|||||| F||| 199812300934||
CA20837 OBX|| CE|18928-2^Gentamicin^ LN||131196009^Susceptible^SCT|||||| F|||
199812300934|| CA20837
First Order OBR (Culture and ID)
First Result (Culture and ID) First Result
(Culture and ID) Second Result(s)
OBXs
First Result Value (SNOMED)
First Result Description OBX (LOINC)
Second Order OBR (Susceptibility)
![Page 211: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/211.jpg)
©2011 Regenstrief Institute and James Case
Q and A Session
![Page 212: 2011 06 06 - LOINC Workshop and Tutorial](https://reader034.vdocuments.us/reader034/viewer/2022050808/54921450b47959640d8b5712/html5/thumbnails/212.jpg)
©2011 Regenstrief Institute and James Case
Exercise Map your own data