2015 08 11 - clinical loinc and relma workshop
DESCRIPTION
Using RELMA tutorial given by Susan A. MatneyTRANSCRIPT
-
2014 Regenstrief Institute
Using RELMA OrIn Search of the Missing LOINC
Susan A. Matney, PhD, RN-C, FAAN Medical Informatics Consultant 3M Health Information Systems Clinical LOINC Meeting August 2015
-
2014 Regenstrief Institute
Acknowledgements LOINC Development Team Clem McDonald, Dan Vreeman, Jami Deckard, David Baorto, Rachel Fuhr, Katy Holck, Swapna Abhyankar
RELMA Development Team John Hook, Anandhi Sowmyan, James Dennis Clinical LOINC Commi8ee Supporters: NLM, Regenstrief InsHtute, Regenstrief FoundaHon
Lab LOINC RELMA Tutorial: James Case
-
2014 Regenstrief Institute
What will we cover today? Overview of LOINC Reviewing new RELMA features! Installing RELMA SeMng personal preferences Loading a Local ObservaHon File (LMOF) Searching for a LOINC Term Preparing LMOF for Mapping Review of Map Screen FuncHons SeMng Search Limits Mapping Local Terms to LOINC Viewing LOINC Term Details Proposing/SubmiMng New LOINC Terms ExporHng/PrinHng Mapped Terms Mapping Special SituaHons Mapping your own LMOF data
-
2014 Regenstrief Institute
-
2014 Regenstrief Institute
Why are we doing this? Goals of Health Information Standards
Interoperability the ability to exchange informaHon between organizaHons
Comparability the ability to ascertain the equivalence of data from dierent sources
Data Quality the measurement of accessibility, completeness, accuracy and precision (and more)
-
2014 Regenstrief Institute
Levels of Interoperability Basic allows data to be exchanged between computer systems Word processing documents, text messages
FuncConal describes the standard syntax (format) of the data Document templates, forms, data structures Message standards
SemanCc requires use of standardized content (vocabularies) within the data structure
-
2014 Regenstrief Institute
Comparability Meaning of the data is consistent when shared among dierent parHes Erysipelas Human skin disease; Streptococcus Grp A Erysipelas Animal SepHcemia/dermaHHs; Erysipelothrix rhusiopathiae
Common terminology required Should work in the background
Words are not enough Codes uniquely idenHfy terms Vocabulary specialized, precise terms that remove ambiguity
Ontology describes nature of enHHes and their relaHons ClassicaHon groups related terms by category
-
2014 Regenstrief Institute
Potential Uses of Health Data are Constrained by Data Quality Factors Data quality issues
Dierent for client/paHent communicaHons vs. clinical decision support vs. epidemiological analysis
O]en constrained by external forces e.g. criteria for diagnosis o]en diers from the criteria for reporHng
UnidirecHonal eect of data consolidaHon Detailed General General Detailed
This is a problem even when standard
terminologies are used
-
2014 Regenstrief Institute
The Problem In a`empHng to arrive at the truth, I have applied everywhere for informaHon, but in scarcely an instance have I been able to obtain hospital records t for any purpose of comparison. If they could be obtained, they would enable us to decide many other quesHons 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
-
2014 Regenstrief Institute
Test comparisons
Lab A Test Name: Lyme Disease Serology Measures: B. burgdorferi Ab IgG Method: ELISA Scale: quanCtaCve e.g.: Titer 1:40
Lab B Test Name: Lyme Disease AnCbody Measures: B. burgdorferi Ab IgM Method: Immune blot Scale: qualitaCve e.g.: PosiCve
LOINC Code = 5062-5 LOINC Code = 6321-4
What you see in the order list
-
2014 Regenstrief Institute
Why LOINC? Within one laboratory, local jargon terms
may be used which are usually well understood between colleagues, but
would not be suciently widely known for communicaHon 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
-
2014 Regenstrief Institute
LOINC 101 Emphasis on Laboratory
LOINC
-
2014 Regenstrief Institute
5193-8:Hepatitis B virus surface Ab:ACnc:Pt:Ser:Qn:EIA
5193-8 LOINC Code
HepaCCs 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
-
2014 Regenstrief Institute
NOT part of a LOINC Name Reason for the test (why it was ordered or the disease it
diagnoses)
TesHng instrument Specic details about the specimen Priority (e.g. STAT) Where tesHng was done Who did the test Test interpretaHon Pricing or cost Anything not part of naming the test Things from other elds in an HL7 arHfact
-
2014 Regenstrief Institute
The substance or enHty that is measured, evaluated, or observed
Component/Analyte
- Sodium - Glucose - Brucella sp. organism - Inuenza A Virus anHgen - Cytomegalovirus Virus anHbody - Lipids.Total
5193-8:Hepatitis B virus surface Ab:ACnc:Pt:Ser:Qn:EIA
-
2014 Regenstrief Institute
Component Structure Analyte Name^Challenge^Adjustments
Formal analyte name Specify subanalytes May have subclasses
Challenge Two parts separated by post
Adjustments
Calcium Coronavirus Ag Calcium.ionized
1H post 100 g Glucose PO
post
Adjusted to pH 7.4
-
2014 Regenstrief Institute
Mass: ObservaHons reported with mass (milligrams, grams, etc.) in the numerator of their units of measure
Substance: ObservaHons reported with moles or milliequivalents in the numerator of their units of measure
CatalyCc acCvity: ObservaHons that report enzymaHc acHvity Arbitrary: Results that report arbitrary units in the numerator of their units
of measure (slowly being reHred) Threshold: Results that represent the relaHon between a value and some
established limit or cut-o Number: Counts
Property
5193-8:Hepatitis B virus surface Ab:ACnc:Pt:Ser:Qn:EIA
The characterisHc or a`ribute of the analyte that is measured, evaluated, or observed
the most dicult LOINC axis
Major Categories
-
2014 Regenstrief Institute
MCnc mass concentraHon (mass/unit vol; e.g. mg/dL) MCnt mass content (mass/unit mass; e.g. mg/Kg) NCnc number concentraHon (number/unit vol; e.g. num/mL) TmStp Hme CCnc catalyHc concentraHon (acHvity; e.g. kat/L) Prid presence or idenHty Imp impression/interpretaHon Find subjecHve or objecHve observaHon Type Kind-of
Property
5193-8:Hepatitis B virus surface Ab:ACnc:Pt:Ser:Qn:EIA
the most dicult LOINC axis
Combine Major Categories with Subtypes for Full Property
-
2014 Regenstrief Institute
Common Property Issues
FracCon = Part/Whole NFr: % Eosinophils / leukocytes SFr: % HGB which is A2
RaCo = mulHple analytes from same system
MCrto: BUN/CreaHnine in serum RelaCve RaCo = measures from dierent system
RelRto: Albumin.pericard d/Albumin.SerPl
Fraction versus Ratio
-
2014 Regenstrief Institute
Important property changes ACNC was always a placeholder
For P/N results, changed to Threshold AddiHonal migraHons occurring gradually LOINC IDs being retained
Flavors of Threshold Property ThrSCnc Threshold Substance ConcentraHon ThrMCnc Threshold Mass ConcentraHon ThrACnc Threshold Arbitrary ConcentraHon
PR vs PRID Presence or absence of an analyte now represented as PR (presence)
For nominal results, property is sHll PRID
-
2014 Regenstrief Institute
Pt - at a point in Hme 12H - a twelve hour collecHon 24H - a twenty four hour collecHon
Timing*
*non-Pt Hmings are usually associated with Rate Property
The interval of Hme over which the observaHon or measurement was made
5193-8:Hepatitis B virus surface Ab:ACnc:Pt:Ser:Qn:EIA
-
2014 Regenstrief Institute
System The system (context) or specimen type upon
which the observation was made.
Ser Ser/Plas Bld Ur Flu Tiss XXX
serum serum or plasma whole blood urine body fluid tissue specified elsewhere
photo via AlishaV
5193-8:Hepatitis B virus surface Ab:ACnc:Pt:Ser:Qn:EIA
-
2014 Regenstrief Institute
System Structure
Super System PaHent is the default Used to indicate
blood product unit bone marrow donor fetus
818-5:A Ag:ACnc:Pt:RBC^BPU:Ord: 54417-1:ABO+Rh group:Type:Pt:Bld^fetus:Nom:
System^Super System
photo via Xurble
-
2014 Regenstrief Institute
Scale Qn Ord Nom Nar
Quantitative continuous numeric can have operators ()
Ordinal Ranked set (1+, 2+, 3+)
Nominal unranked collection Taxonomy (e.g. bacteria)
Narrative
photo via puuikibeach
5193-8:Hepatitis B virus surface Ab:ACnc:Pt:Ser:Qn:EIA
-
2014 Regenstrief Institute
Scale (Special) OrdQn Ordinal or QuanHtaHve
Primarily used for anHmicrobial observaHons e.g. MIC reported as resistant, intermediate, suscepHble or as the mm diameter of the inhibiHon zone
Use is discouraged in other contexts MulH structured text globs
e.g. chromatography output Use is discouraged
Doc Clinical documents Set Clinical a`achments (headers)
-
2014 Regenstrief Institute
Method Only needed if interpretaHon aected
Dierent normal ranges Test sensiHvity/specicity
Generally listed at the generic level AggluHnaHon Enzyme Immunoassay Probe with target amplicaHon
5193-8:Hepatitis B virus surface Ab:ACnc:Pt:Ser:Qn:EIA
-
2014 Regenstrief Institute
Hierarchies LOINC Class
one per term arbitrarily assigned
One for each LOINC axis MulH-axial
Component | System Separate download
-
2014 Regenstrief Institute
Mapping Terms to LOINC Things to Remember
The thing ordered is not always the thing measured: Blood Culture live organism(s) idenHed VDRL Treponema pallidum Ab Urinalysis lots of dierent things
You must know the specics of the component being tested for (what actually being measured?)
The quesHon (what am I measuring? e.g. Glucose) is not the answer (e.g. 90 mg/dl) You are mapping the quesHon, not the answer!
Need to get the observaHon/result boundary correct. Sample values help substanHally
-
2014 Regenstrief Institute
What is in LOINC? Content
Term structures Submi`ed units, Example UCUM units
aiming toward preferred units sorHng Synonyms Answer lists (increasing number) Text descripHons links to info sources about individual tests Panel structures Foreign language translaHons
And much more
-
2014 Regenstrief Institute
RELMA Regenstrief LOINC Mapping Assistant
-
2014 Regenstrief Institute
Download of latest version
The latest version of the installaHon le may be downloaded from:
h`ps://iu.box.com/relma67
-
2014 Regenstrief Institute
Purpose of Tutorial Eliminate need to read the Users Manual Become familiar with RELMA features Provide some insight into mapping Hps/piyalls Help begin the mapping process for your insHtuHon
Hang with some really cool folks
-
2014 Regenstrief Institute
LOINC les and indexes Manual and automated mapping funcHons RELMA tools transform local words in local le
User creates le of local term/name and codes
Assigns LOINC term to local test/ba`ery code Common tests subset to speed mapping Context sensiHve hierarchies for local use. Flexible Google-like search funcHons
RELMA Functions
-
2014 Regenstrief Institute
New in Recent Versions (6.7-10) A new search restricHon of PanelType has been added
A new search restricHon of LForms Cardinality representaHon changed.
Ex. opHonal with no upper bound is now displayed as "0..*" instead of "0..n."
"Export full panel structure to Excel" funcHon includes the LOINC answer list id ("LL" code) and answer list name on the ANSWERS tab of the spreadsheet.
Answer list informaHon now available via the main search screen.
-
2014 Regenstrief Institute
LOINC Web Site
-
2014 Regenstrief Institute
Whats available to download? RELMA - mapping and browsing tool
HL7 message converter- Makes a database suitable for mapping
LOINC database and spreadsheets Accessory les (panels, forms, top 2000, etc.) LOINC User guide; RELMA User Guide Tools to assist language translaHons by part Tools for building databases to map from HL7 messages
Guidance documents for mappers
-
2014 Regenstrief Institute
RELMA Highlights Browse-able hierarchies of LOINC parts Display search results in tree view Enhanced details view of terms/parts
References DescripHons Sample units
Empirically-derived common test list Empirically-derived common order list Special features for panels/forms Enhanced export/copy-paste opHons
-
2014 Regenstrief Institute
Installing RELMA
-
2014 Regenstrief Institute
Installation Steps Requires Windows (or VM on a Mac) Make sure you have enough free disk space!
2Gb is recommended
From CD - Start Run :\RELMA\Setup Specify installaHon directory
Life will be easier if you accept the default
Two database les installed RELMA.MDB LOINC Terms Database LMOF3.MDB Local Master ObservaHon File
Two sample les included Run from Start (All) Programs Regenstrief RELMA
-
2014 Regenstrief Institute
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, 8 = C:\Users\Public\Public Documents\RELMA\
Sample les Windows XP = C:\Documents and SeMngs\All Users\Documents\RELMA\Samples\
Windows Vista = C:\Users\Public\Documents\RELMA\Samples\ Windows 7, 8 = C:\Users\Public\Public Documents\RELMA\Samples\
-
2014 Regenstrief Institute
Running RELMA Version 6.7
-
2014 Regenstrief Institute
Copyright Screen
-
2014 Regenstrief Institute
Join the LOINC Community
-
2014 Regenstrief Institute
LOINC crowdsourcing
-
2014 Regenstrief Institute
Main Menu/Welcome Screen
-
2014 Regenstrief Institute
Set Preferred Language
Click File, Set Preferred Language
-
2014 Regenstrief Institute
Select Linguistic Variant(s)
Selecting a translation may require indexes to be built
-
2014 Regenstrief Institute
LOINC Terms with Spanish Linguistic Variant
All Spanish!
-
2014 Regenstrief Institute
Setting User Preferences
-
2014 Regenstrief Institute
Select User Preferences From the File Menu
Set User Preferences
...or from Welcome Screen
-
2014 Regenstrief Institute
Set User Preference Dialog
Startup Screen Preference
File Locations: (See prior slide for location)
New Local Term Backup Tab
-
2014 Regenstrief Institute
User Map Screen Preferences Click Map Screen Tab
Include/Exclude Battery Terms
Add comments on Mappings
Auto create search terms
-
2014 Regenstrief Institute
User Detail Pages Preferences
Download detail pages from LOINC.org
-
2014 Regenstrief Institute
Request Submission Preference
Preferred method of request submission
-
2014 Regenstrief Institute
New! Local Backup Preferences
-
2014 Regenstrief Institute
Importing Local Terms into RELMA
-
2014 Regenstrief Institute
5 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 le from your local test catalog (good choice)
Import Excel le Load directly from HL7 v2.x messages
Pulls data from OBR and OBX segments Stores NTE segment data
-
2014 Regenstrief Institute
Constructing a Local Dataset Create extract of your test catalog with:
Ba`ery/Panel Code Ba`ery/Panel DescripHon or Name *Local Code *Test DescripHon or Name
Include Method if Important Units Example Values Laboratory SecHon
-
2014 Regenstrief Institute
Creating Delimited ASCII File RELMA cant parse free text
Need to create separate elds Can use any of these delimiters
Tab, Semicolon, Comma, Space Can dene your own
Fields can be in any order Minimum required elds
Local Code Local DescripHon Units (highly recommended)
-
2014 Regenstrief Institute
Entering New Local Terms into RELMA
-
2014 Regenstrief Institute
Manual Enter/Edit
View/Add/Edit Local Terms
-
2014 Regenstrief Institute
Edit Term Dialog
Edit\Add\Delete Terms Export Terms
Print Preview List Text alignment option
User assigned tags
-
2014 Regenstrief Institute
Export Local Term File
Delimiters supported: Tab, comma, bar (|)
Export to Microsoft Excel or Text File
New feature! Export assigned tags
-
2014 Regenstrief Institute
Add Local Term
Click to Add to Current Working File
MICRO
BUBPLAGBUBONIC PLAGUE RRT PCR
Add tags
-
2014 Regenstrief Institute
Search Local Term File
Enter Keyword from any Field
Calcium
Return to Full List
Tags panel only appears if tags have been assigned
Open or close tag list
-
2014 Regenstrief Institute
Using tags to gilter local terms
Print preview local term gile
Congigure output prior to viewing and printing
-
2014 Regenstrief Institute
Print Preview Local Term File
Only prints selected rows
-
2014 Regenstrief Institute
Steps to Import Local Terms 1. Click Import Local Terms Bu`on from Main Menu
a) File>Import Local Terms from Delimited File 2. Locate your local terms text le 3. Name your Working Set (Mandatory)
a) LMOF database can contain mulHple work sets 4. Dene default secHon (OpHonal) 5. IdenHfy le delimiter 6. Assign elds to LMOF a`ributes
a) Ignore elds you dont need b) Combine elds if needed
7. Check Case-sensiHve if needed 8. Click Import.
-
2014 Regenstrief Institute
Example Tab-Delimited File
-
2014 Regenstrief Institute
Importing Local Files
Select Import Local Terms from Delimited File or Excel Spreadsheet
-
2014 Regenstrief Institute
Navigate to File Location Select File and Click Open Sample giles stored in
RELMA Directory
-
2014 Regenstrief Institute
Open File in RELMA
Name your working set. RELMA allows multiple sets in
LMOF database
Select your delimiter
Import Button
-
2014 Regenstrief Institute
Fields Segregated
Assign LMOF Attribute
Assign working set name
-
2014 Regenstrief Institute
Working set import LOINC Workshop OBR
-
2014 Regenstrief Institute
Ready to Import
Minimum assignments
Now you can click the Import button!
-
2014 Regenstrief Institute
New feature import tags
You can include tags in your import le that allow you to categorize your local terms
New elds in import funcHon allow assignment of Tag with
-
2014 Regenstrief Institute
Local term gile with added tags
Tag terms
-
2014 Regenstrief Institute
Assign tag values
New gield assignment
-
2014 Regenstrief Institute
Tagged local terms
Imported tags
-
2014 Regenstrief Institute
Post-Processing of Local File
A]er import, RELMA Searches for terms (words) that it does not recognize
Stored in a le for future reconciliaHon
-
2014 Regenstrief Institute
Importing Excel gile
Excel giles now appear along with text giles
-
2014 Regenstrief Institute
Excel format for import
-
2014 Regenstrief Institute
Local Term File Options
-
2014 Regenstrief Institute
Change Local Term File
Select the Working Set
Current mapping status
Can delete local term set; not the active one
-
2014 Regenstrief Institute
Alternative Pragmatic Way Use large set of HL7 messages AutomaHcally make dataset of:
OBR ID OBR descripHon OBX ID OBX descripHon Sample of results with
Real values Units Abnormal ags Normal ranges
-
2014 Regenstrief Institute
Generate Local term gile from HL7 messages
Select Import Terms from HL7 File
-
2014 Regenstrief Institute
Select File to Import
Select HL7 File
-
2014 Regenstrief Institute
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
-
2014 Regenstrief Institute
HL7 Messages Data Statistics
-
2014 Regenstrief Institute
New Terms added to LMOF
New Battery Code
Click on Edit Term to see Sample Data
-
2014 Regenstrief Institute
Sample Results for Observation New Test Code
Sample Values from Messages
-
2014 Regenstrief Institute
Lenny LOINC says: Load the Sample Files Into RELMA now!
Import the two sample les provided Import_Sample_OBR.txt
Contains ba`ery code and descripHon
Sample_HL7.HL7 Contains test code and descripHon and sample values
Create 2 working sets Load your personal data set
-
2014 Regenstrief Institute
Cleaning your data
-
2014 Regenstrief Institute
Preparing your Data for Mapping
Improve mapping success by: Expanding abbreviaHons Standardizing colloquial terms Ignoring administraHve terms Standardizing Hme references
Can be done prior to imporHng Be`er to use tools built into RELMA
-
2014 Regenstrief Institute
RELMA Cleaning Tools Use this tool to edit unknown terms
Only available if no language variant selected
-
2014 Regenstrief Institute
Review Unknown Local Terms
May Re-Scan File for Unknown Terms
-
2014 Regenstrief Institute
Replace Local Terms
Assign LMOF Attribute Replacement Options
-
2014 Regenstrief Institute
RELMA Cleaning Tools Use this tool to make global substitutions
-
2014 Regenstrief Institute
Term Substitution
Save this global substitution for only this working set
-
2014 Regenstrief Institute
Lenny LOINC says: Begin to clean your
data now!
Using the OBR sample le or your own data, take 15-20 minutes to clean up these unrecognized terms
-
2014 Regenstrief Institute
Searching for LOINC Terms
-
2014 Regenstrief Institute
Comprehensive Search Only Tool
-
2014 Regenstrief Institute
Search Window
Enter Search Terms
Limit to Specigic Units
Use different logic
Help File
Restrict Limits
-
2014 Regenstrief Institute
Search Window
No Limits selected Clinical Automapper rank
-
2014 Regenstrief Institute
RELMA Search Helpgile
-
2014 Regenstrief Institute
Context Menu
Right click to bring up context menu
-
2014 Regenstrief Institute
Changed search function Max words
Keyword ComponentWordCount restricts word count
Restricting to Component Axis regines further
-
2014 Regenstrief Institute
Search function - Answerlist
Large number of results Restricting to terms that
have answer lists
-
2014 Regenstrief Institute
Answerlist details
-
2014 Regenstrief Institute
Mapping Local Terms
-
2014 Regenstrief Institute
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 Bu`on
-
2014 Regenstrief Institute
Standard Mapping Window Features
Customizable grid View details of LOINC term New! Add searchable tags to local term Sort by column
Click column Custom Sort
Print or export results grid Spell check squiggly line to signify words not known to RELMA
-
2014 Regenstrief Institute
Mapping Screen View or edit local term
Quick select button list
Custom Grid Congiguration
Enter local term number
User assigned tags
-
2014 Regenstrief Institute
Congigure Grid
Reorder grid elements
Select elements to display
Reset Default Congiguration Visually resize elements
-
2014 Regenstrief Institute
Quick choice buttons
Viewing LOINC term detail
-
2014 Regenstrief Institute
View Local Term Details
Select level of detail to display
Can scroll through returned subset of
terms
Change text size
Can scroll down a single formatted page
-
2014 Regenstrief Institute
Details Text Size Select text size
-
2014 Regenstrief Institute
Select detail display level
Select level of detail to display
-
2014 Regenstrief Institute
Standard Mapping Screen
Begin a search (or hit enter) EEK! Whatll I
do?!
-
2014 Regenstrief Institute
Standard Mapping Screen
Click to show words
used in search
-
2014 Regenstrief Institute
Initial Mapping Results
Use term checkbox
Number of LOINC terms containing
keyword Battery terms included in search
-
2014 Regenstrief Institute
Revised Mapping Results
Number of matching
records found
-
2014 Regenstrief Institute
Re-revised Mapping Results
Number of matching
records found Match units selected
-
2014 Regenstrief Institute
Standard Mapping Screen
Clear all input gields
Enter keywords here
CANINE DISTEMPER VIRUS IF
-
2014 Regenstrief Institute
Standard Mapping Screen
Navigate through the local terms
-
2014 Regenstrief Institute
Tabbed Access to Functions
Navigate to Functions from Mapping Page
Switch between Grid and Tree Views
-
2014 Regenstrief Institute
Tree View
-
2014 Regenstrief Institute
Tree View Results displayed hierarchically
Dened by the mulH-axial hierarchy in search restricHons (covered later)
Map to a term in tree by clicking Map bu`on or double clicking term Only to rows that have LOINC Codes
-
2014 Regenstrief Institute
Tree View
Cannot map to terms
representing LOINC parts
Can map to terms with LOINC Codes
Tree Navigation Buttons
-
2014 Regenstrief Institute
Assigning a LOINC Map
Highlight correct term
Click Map Button (or doubleclick)
-
2014 Regenstrief Institute
Adding Mapping Comments
If comments option is selected, prompt appears
Check with Frank in Chemistry
-
2014 Regenstrief Institute
Assigning a LOINC Map
LOINC Term Assigned
-
2014 Regenstrief Institute
View Panel Children
Select View Panel Children from context menu
-
2014 Regenstrief Institute
Panel Children
-
2014 Regenstrief Institute
Congigure Export Options
Output Options Include
column headers Save Congiguration and/or Export
-
2014 Regenstrief Institute
New feature linked answer lists
Adds answer list IDs to the answer tab of a panel export
Allows linkage using the AnswerlistID with the LOINC codes and the answer to see which answer go with a specic LOINC
-
2014 Regenstrief Institute
Search for panels
Search for panel or LOINC code
Find the panels associated
-
2014 Regenstrief Institute
Get panel details and export
Export the full panel structure
-
2014 Regenstrief Institute
Exported Wound Forms Tab
Panel Children
Parent LOINC code
Panel Name Conditionality
-
2014 Regenstrief Institute
Exported Wound Panel LOINC Tab
LOINC code
Class
-
2014 Regenstrief Institute
Detailed answer data
LOINC code AnswerListID Answer String
-
2014 Regenstrief Institute
More on Searching Search Screen
-
2014 Regenstrief Institute
Basic Search Syntax Special Character(s)
Example DeniCon
Inuenza virus A Linked terms must appear together
AND Morphine AND Opiates
Both terms must appear in the search result term
OR Inuenza OR Parainuenza
Either or both terms must appear in the search result term
NOT Inuenza NOT equine Excludes terms with the word following the NOT. Cannot be used alone.
? Gluc?se (glucose,glucase)
SubsHtutes a single character in the string. Cannot be used as the rst character; cannot be used in phrases
* Gluc*se (glucose, glucuronidase, etc.)
SubsHtute mulHple characters in the string. Cannot be used as the rst character; cannot be used in phrases
-
2014 Regenstrief Institute
Search Qualigiers
Includes Glucuronidase, Glucosidase,
Glucosylceramidase, etc.
Detailed help available
-
2014 Regenstrief Institute
Combining Search Terms
Reduced number of terms
Exclude Glucosidase
-
2014 Regenstrief Institute
Advanced Search Syntax based on Google-like search syntax
Parameter DescripCon
+ 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 eld (e.g. Component: glucose)
Fieldname:() Group mulHple terms in a single eld
~ Fuzzy search (e.g. Hemoilus~)
~ Proximity search for mulHple terms (e.g. funcHon panel~1)
{}, [] Upper and lower bounds; {} exclusive, [] inclusive
\ Special character escape
-
2014 Regenstrief Institute
Applying advanced search
129 terms
-
2014 Regenstrief Institute
Applying advanced search
6 terms
-
2014 Regenstrief Institute
Limiting Searches
-
2014 Regenstrief Institute
Setting Search Limits
Narrows search to specic subset of LOINC terms Reduces number of candidate terms Limits can be applied to all components Component a`ribute can be further restricted by number of words
Tree structure allows for hierarchical constraints
-
2014 Regenstrief Institute
General Search Constraints Controls features including:
Limit to LOINC terms compaHble with submi`ed units Forced match with any specimen contained in name Method-less terms only Restrict by class type Remove lateralized terms
Use carefully or search may not be successful (Note parallel control switches at bo`om of screen)
-
2014 Regenstrief Institute
Setting Search Limits
Click Hierarchy & Search Limits Tab
-
2014 Regenstrief Institute
Setting search limits Can also set most of them by toggling bu`ons
at the bo`om of the screen
Toggle Buttons
-
2014 Regenstrief Institute
Search Constraints
Expanded predegined, general search constraints
Attribute trees
Limit to LOINC terms consistent with local units
-
2014 Regenstrief Institute
Terms Consistent with Units
Only terms consistent with ml appear
-
2014 Regenstrief Institute
Setting Search Limits
Specimen constraints
-
2014 Regenstrief Institute
Setting Search Limits
Exclude laterality
-
2014 Regenstrief Institute
Exclude laterality
Laterality terms
-
2014 Regenstrief Institute
Setting Search Limits
Restrict to common orders
-
2014 Regenstrief Institute
Restriction to common orders
Large number of candidates Common orders
rank
-
2014 Regenstrief Institute
Setting Search Limits
Methodless Terms Restriction
Override Methodless Terms Restriction
-
2014 Regenstrief Institute
Limit to Methodless Terms
Both method and method-less terms
-
2014 Regenstrief Institute
Limit to Methodless Terms
Only Methodless Terms Appear
-
2014 Regenstrief Institute
More on Methodless Terms Some LOINC categories do not have methodless terms
Checking methodless only will remove these from view on results grid
Checking addiHonal box allows these to be seen
-
2014 Regenstrief Institute
Setting Search Limits
Include Trial, Deprecated or Discouraged LOINC Codes with
Returned Terms
-
2014 Regenstrief Institute
Include Deprecated LOINC Terms
Deprecated LOINC Terms appear as Strikethrough Text with a Do Not
Symbol
You cannot map to deprecated LOINC terms
The map button is grayed out if one of these terms is selected
Discouraged LOINC Terms appear as an inverted triangle
-
2014 Regenstrief Institute
Order/Observation Restriction
Order or Observation preference
-
2014 Regenstrief Institute
LOINC Hierarchies Class Tree
Three top-level branches
Tree Navigation Buttons
-
2014 Regenstrief Institute
Before Class Restriction
Large number of candidate terms
Many terms have class of CHAL
-
2014 Regenstrief Institute
Search Trees
Restrict eligible tests to non-challenge
chemistry tests only
-
2014 Regenstrief Institute
Limiting Search by Subclass
Selecting subclass constrains search to all
members
-
2014 Regenstrief Institute
Following Class Restriction
Only clinical codes (no lab) returned
-
2014 Regenstrief Institute
System Hierarchy
-
2014 Regenstrief Institute
Component Hierarchy
Show the LOINC Codes associated with these
components
Click on details for more information about the
selection
-
2014 Regenstrief Institute
Details Screen LOINC Part
-
2014 Regenstrief Institute
Show Associated LOINCs
-
2014 Regenstrief Institute
LOINC Term Details Screen
-
2014 Regenstrief Institute
Tree Export Tools
Congigure Export Format
Export according to Congiguration
-
2014 Regenstrief Institute
Tree Export Congiguration
-
2014 Regenstrief Institute
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 bu`on on Mapping Screen to remove all tree selecHons
-
2014 Regenstrief Institute
LOINC Part Search Same look as term search Uses same Google-like query language
Extremely fast Include and exclude criteria ParHal string matching (using wildcards)
LOINC CLASS values may now be search using "ClassList:" eld
Demo Campylobacter fetus, not Ab
-
2014 Regenstrief Institute
LOINC Answer List Search
Nominal LOINC terms are now required to be submi`ed with answer lists.
Finding answer lists and the use of them can be done with Answer List Search tab
-
2014 Regenstrief Institute
Answer List Search
Answer Lists associated with LOINC term
-
2014 Regenstrief Institute
Navigating through the Mapping Process
-
2014 Regenstrief Institute
Special Situations Nursing Assessments Radiology content Document Ontology Validated Instruments
-
2014 Regenstrief Institute
Radiology
Modality
Anatomic Region
Everything Else
-
2014 Regenstrief Institute
Document Ontology Be aware of the Document Ontology model
Kind of Document
Setting
Subject Matter domain
-
2014 Regenstrief Institute
Status LOINC and Nursing Content
Many areas incomplete Current work happening to determine gaps
Physiologic Assessments Basic Med/Surg Assessment Submi`ed
Assessment Framework New Nursing Judgment (Impression) LOINC codes
Future Nursing LOINC Landing Page
-
2014 Regenstrief Institute
Limit eort to one clinical secHon at a Hme and focus experHse
Vitals, skin, wound assessments will be easiest Map radiology by modality (constrain to that modality)
Sample results give clue to property and scale Consider prioriHzing by frequency of use
LOINC Mapping Tactics
-
2014 Regenstrief Institute
Vreeman DJ, Finnell JT, Overhage JM. A Rationale for Parsimonious Laboratory Term Mapping by Frequency. AMIA Annu Symp Proc. 2007;:771-775.
-
2014 Regenstrief Institute
More LOINC Mapping Tactics Try using method-less terms rst
Specic methods can be transmi`ed in: OBX17 (v2.x), ObservaHon.methodCode (v3.0)
Examine local units or real results to verify correct property and scale ProperHes are rarely disHnguishable in test names
You dont have to do it all at one siMng Use the Unmapped funcHon to return where you le] o
With every release - Update previous mappings to idenHfy deprecated terms
-
2014 Regenstrief Institute
Common Mapping Issues
Locally Dened Test Name Ambiguity Reuse of local test code
Incongruent Value sets (Scale ambiguity) Result vs. InterpretaHon Available LOINC Terms too Specic/General LOINC not yet dened
-
2014 Regenstrief Institute
Using your Mapped Terms Print results of LOINC Mapping Export to File
Open Local Term File
-
2014 Regenstrief Institute
Congigure Export Format
Context Sensitive Export Congiguration
-
2014 Regenstrief Institute
LMOF Export Congiguration
Select Fields to Export
Select Export Format
Save Congiguration and Export
-
2014 Regenstrief Institute
Print Mapped Terms from View/Add/Edit Menu
May highlight terms to be printed
Click Print button to Preview output
-
2014 Regenstrief Institute
Formatted Report Output
Click Print button to output formatted report
-
2014 Regenstrief Institute
Excel Export
-
2014 Regenstrief Institute
Exporting Mapped Terms
Export Terms to Delimited File
-
2014 Regenstrief Institute
Export Terms Dialog
Check Fields you wish to export
Select Delimiter
Select Term Set
Direct export to Excel
Select gile location
-
2014 Regenstrief Institute
Other RELMA Features
-
2014 Regenstrief Institute
Panels, Forms and Survey Review
Review Panels, Forms and Surveys
Review Panels, Forms and Surveys
-
2014 Regenstrief Institute
Laboratory Panels
Expand category to see panels
Double-click panel test to see components
-
2014 Regenstrief Institute
Expanded Panel Detail
-
2014 Regenstrief Institute
Government Panels
Form Category
Panel Codes
-
2014 Regenstrief Institute
Government Panel Children
-
2014 Regenstrief Institute
Expanded Clinical Panel
-
2014 Regenstrief Institute
Clinical Panels
Find where a term has been used
35089-2, 35090-0
-
2014 Regenstrief Institute
LOINC Term Panel Usage
-
2014 Regenstrief Institute
Other Survey Instruments
-
2014 Regenstrief Institute
HIPAA Attachments
View Various HIPAA Attachments
-
2014 Regenstrief Institute
HIPPA Attachment Tree
-
2014 Regenstrief Institute
Expanded Attachment Data
-
2014 Regenstrief Institute
Cant gind the term you want?
-
2014 Regenstrief Institute
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 dont make sense
E.g. Method-less tests plus Method tree set to EIA Did not nd 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
-
2014 Regenstrief Institute
Proposing New LOINC Terms
-
2014 Regenstrief Institute
Proposing New Terms Make sure the term is really needed
Think of other names for the same concept Avoid detailed methods or localizaHons Is the disHncHon really important?
Supply sucient annotaHon to jusHfy the new term Package inserts, sample reports (email to Regenstrief) The more the be`er!
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
-
2014 Regenstrief Institute
Propose new LOINC terms
Select Propose a new LOINC
-
2014 Regenstrief Institute
Required gields in red
Navigate through proposed terms
Create new term, save current term
or Exit form
-
2014 Regenstrief Institute
Preview Proposed Terms
Review your new terms
-
2014 Regenstrief Institute
Review Proposed Terms
All proposed terms fully editable
Choose whether to send or postpone
X
X X
Susan A. Matney, PhD, RN-C
3M HIS
801-447-9294
801-447-9294
Direct submission via web
-
2014 Regenstrief Institute
Submit Proposed Terms
Add additional information, if
necessary Add attachments
-
2014 Regenstrief Institute
Submitting New Terms Must supply name, organizaHon, phone and email of submi`er
Must select at least one proposed term to send
Congure export does not aect submission output
Email resulHng le to Regenstrief
-
2014 Regenstrief Institute
Use Existing Terms as Template
Select your closest match
Click the Propose Term button
-
2014 Regenstrief Institute
Use Existing Terms as Template
All required components gilled in
-
2014 Regenstrief Institute
Using LOINC and SNOMED Together
-
2014 Regenstrief Institute
Where do LOINC and SNOMED Fit?
LOINC represents the quesHon: Is there any Botulism toxin in my specimen? (33708-9)
Organisms idenHed in specimen? (634-6)
SNOMED represents the answer: NegaHve (SCTID 260385009) E. coli O157:H7 (SCTID 103429008)
Remember:
-
2014 Regenstrief Institute
Where do LOINC and SNOMED Fit? In an HL7 message, LOINC may be used:
In OBR-4 (Universal Service IdenHer) In OBX-3 (ObservaHon IdenHer
SNOMED may be used: In OBX-5 (where nominal values are needed) Almost anyplace else in an HL7 message where coded values are needed
-
2014 Regenstrief Institute
The code is from SNOMED
The code is from LOINC
OBX-5: Data A code for L.
monocytogenes
A code that identigies the data type in OBX-5 as a
coded element
OBX: With a Coded Value
OBX-3:A code that identigies the data in
OBX-5 (Listeria culture)
OBX||CE|6609-2^Listeria ID^LN||36094007^L. monocytogenes^SCT
-
2014 Regenstrief Institute
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)
-
2014 Regenstrief Institute
Q and A Session
-
2014 Regenstrief Institute
Exercise Map your own data