Difference between revisions of "Procedures Module Configuration for Manual Result Entry"

From OpenEMR Project Wiki
 
(87 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Preface==
=='''Preface'''==
The goal of this guide is to provide a set of step-by-step instructions for setting up the Procedures Module to enter diagnostic results by hand.  Doing so brings this data into the Encounter Form and closer to the clinical note.
The goal of this guide is to provide a set of step-by-step instructions for setting up the Procedures Module to enter diagnostic results by hand.  Doing so brings this data into the Encounter Form and closer to the clinical note.


Configuration necessitates meticulous attention to detail and order of execution.  Once properly configured, deployment is relatively simple by comparison.
Configuration necessitates meticulous attention to detail and order of execution.  Once properly configured, deployment is relatively simple by comparison.


It is possible to upload a scanned image of results into Decuments/Medical Record, but that will place the data at a further distance from the clinical note.
It is possible to upload a scanned image of results into Documents/Medical Record, but that will place the data at a further distance from the clinical note.


To transmit orders and receive results from an external laboratory facility, refer to [[Media:LEN_User_Documentation_v1.0.pdf‎|Laboratory Exchange User Documentation]].
To transmit orders and receive results from an external laboratory facility, refer to [[Media:LEN_User_Documentation_v1.0.pdf‎|Laboratory Exchange User Documentation]].


==Facility==
=='''Facility'''==
Despite the fact that no orders will be transmitted to an external facility; it is necessary, however, to manufacture a fictitious Lab Service in order to configure this module.  The fictional facility must be entered in the Address Book first.
Despite the fact that no orders will be transmitted to an external facility; it is necessary, however, to manufacture a fictitious Lab Service in order to configure this module.  If the practice has an in-house lab, enter its name.  "Our Own Lab" will the Lab Service for the purpose of this exercise.


"Our Own Lab" will the Lab Service for the purpose of this exercise.
From the Menu on the left side bar, go to Procedures/Providers and add "Our Own Lab".


From the Menu on the left side bar, go to Procedures/Providers and add "Our Own Lab".
[[File:1fake.png|center]]
[[File:2fake.png|center]]
[[File:3fake.png|center]]


[[File:lab.png]]


==Configuration==
=='''Configuration'''==
The module can be set up for a panel of tests or for a single study.  A panel will require a 3 tier process while it is only 2 for a single test.
===Manual Method===
The module can be set up for a panel of tests or for a single study.  A panel will require a 4 tier process while it is only 3 for a single test.


===Panel===
====Panel====
Click the Configuration link and the "Add Top Level" button to begin.  This button must be clicked each time a new panel or new single study is added to the list.
Click the Configuration link and the "Add Top Level" button to begin.  This button must be clicked each time a new panel or new single study is added to the list.


[[File:lab1.png]]
[[File:1panel.png|center]]




The first tier, or level, of the configuration, will be the naming of the Group.  Maintain the Sequence to keep the list in the desired order.
The first tier, or level, of the configuration, will be the naming of the Group.  Maintain the Sequence to keep the list in the desired order.
[[File:lab2.png]]
[[File:lab2.png|center]]




To begin the second tier of configuration, click the "Add" link. It may be necessary to scroll to the far right to see that link in the image below. Use "Edit" to modify configuration.  To delete a setting, click "Edit" and go to the desired dialog box to delete the entry.
To begin the second tier of configuration, click the "Add" link.   Use "Edit" to modify configuration.  To delete a setting, click "Edit" and go to the desired dialog box to delete the entry.
[[File:lab3.png]]
[[File:2chm1.png]][[File:2chm2.png|right]]




The second tier involves naming the Group as "Electrolytes" and assigning an Identifying Code to it.  The choice of numerals or letters is at the discretion of the practice.
The second tier involves naming the Group as "Electrolytes" and assigning an Identifying Code to it.  The choice of numerals or letters is at the discretion of the practice.
[[File:lab6.png]]
[[File:lab6.png|center]]


[[File:lab7.png]]
[[File:lab7.png|center]]




Be certain that there is a "Yes" under the Order column and an Identifying Code as well.  If these items are missing, it is a '''warning''' that the configuration had been faulty.  The entries must be deleted and the process begun anew.
Be certain that there is a "Yes" under the Order column and an Identifying Code as well.  If these items are missing, it is a '''warning''' that the configuration had been faulty.  The entries must be deleted and the process begun anew.


Click the "Add" link associated with "Electrolytes" to begin setting up Sodium. Scroll to the right if the image of the link is not visible.
Click the "Add" link associated with "Electrolytes" to begin setting up Sodium.  
[[File:lab8.png]]
[[File:1ele1.png]][[File:1ele2.png|right]]




The third tier will configure the first test of the panel, namely Sodium.  Fields left empty are optional.
The third tier will configure the first test of the panel, namely Sodium.  Fields left empty are optional.
[[File:3na.png|center]]
Because mEq/L was missing; it had to be added in Administration/Lists/Procedure Units.  Remember to make the addition Active before saving it. 
[[File:1meq.png|center]]
It is helpful to have the range of values for a particular test in Discrete Result; but Recommendation is optional.  Click "Add" link on the same line as Sodium to configure the fourth tier, Discrete Result.
[[File:1val.png|center]]


[[File:lab9.png]]


[[File:lab11.png|center]]


Because mEq/L was missing; it had to be added in Administation/Lists/Procedure Units.  Remember to make the addition Active before saving it. 
[[File:lab10.png]]


A similar process is used to add the other tests of the panel. Again click the "Add" link associated with "Electrolytes" to begin.  Pay close attention to Sequence; otherwise the tests will appear in alphabetical order; not Na, K, Cl, CO2 as physicians are accustomed.
[[File:5k1.png]][[File:3k2.png|right]]


It is helpful to have the range of values for a particular test in Discrete Result; but Recommendation, a third step of the third level configuration, is optional.


[[File:lab11.png]]
[[File:2k1.png|center]]




A similar process is used to add the other tests of the panel. Again click the "Add" link associated with "Electrolytes" to begin.  Scroll if need be.  Pay close attention to Sequence; otherwise the tests will appear in alphabetical order; not Na, K, Cl, CO2 as physicians are accustomed.
Click "Add" on the Potassium line to configure Discrete Result.
[[File:lab12.png]]
[[File:lab14.png|center]]
[[File:lab13.png]]
[[File:lab14.png]]




A full panel should look like the following.
A full panel should look like the following.
[[File:lab15.png]]
[[File:1total1.png]][[File:1toal2.png|right]]
 


===Single Study===
====Single Study====
Click "Add Top Level".  A single test requires the naming of the Group and of the test.
Click "Add Top Level".  A single test requires the naming of the Group and of the test.
[[File:lab16.png]]
[[File:lab16.png|center]]
[[File:lab17.png]]
[[File:6bun1.png|center]]
[[File:lab18.png]]




Check that "Yes" and the code are present.
Check that "Yes" and the code are present.  Click the "Add" link to configure the third tier, Discrete Result.
[[File:lab19.png]]
[[File:2bun1.png]][[File:2bun2.png|right]]


==Procedure Order==
 
[[File:lab18.png|center]]
 
 
Bear in mind that if there is a study which has different normal values depending on the gender of the patient, the user must assign different Identifying Codes for each Discrete Result.  An example would be Hemoglobin/Hematocrit.  If the user assigns only one code for the 2 Discrete Result ranges, there will a configuration problem.
 
===Load Compendium===
If the user partners with Diagnostic Pathology Medical Group, Pathgroup Labs LLC or Yosemite Pathology Medical Group, he can obtain from them a data set of diagnostic studies for the Procedure module to avoid manual configuration.
 
===Database Method===
Users who don't use the services of the above mentioned vendors can try their hand at configuration of tests with phpMyAdmin.  The Forum discussion can be found [http://sourceforge.net/p/openemr/discussion/202505/thread/0dd43fc8/?limit=25&page=1#18c5 here].
 
There are 1794 studies in the Mayo Clinic data set.  For most practices this list will need to be whittled down.  Only Carbon Dioxide has been configured with 3 tiers. The balance will need additional work setting up Group and Discrete Result.  It will do the reader little good if he can search for the test but unable to enter lab results.
 
====Preparations====
Download this data set, [http://www.open-emr.org/wiki/index.php/File:Mayo_loinc.zip Mayo_loinc.zip].  Because phpMyAdmin will only accept a zipped '''.sql''' file (this is a zipped .csv file), it must be extracted before import.
 
Understand the structure of the procedure_type table and the characteristics of each column.
[[File:0mayo.png|center]]
 
====Import====
Navigate from the Menu to Administration/Other/Database.  From the 4th page of the database, go to procedure_type, then to the Import tab.  Browse for the '''unzipped''' file and click Go. 
[[File:3mayo.png|center]]
 
 
If all goes well, you should see the following.
[[File:5mayo.png|center]]
 
====Working in phpMyAdmin====
From the Browse tab navigate to the last page, 72.  Scroll to the bottom and follow the CO2 example to add Group and Discrete Result for a particular test.
[[File:2mayo.png|center]]
 
 
Most users will find manual configuration easier to handle.  The Graphical User Interface will become familiar after a few attempts.  Working in phpMyAdmin requires more skills with a potential for damaging the database.  '''Backup''' is strongly advised beforehand.
 
A safer way to accomplish this task is to load the .csv file into OpenOffice Calc or Excel after studying the CO2 example.  The deletion of unwanted studies and the insertion of rows for Group and Discrete Result will be more in the user's comfort zone.  If there are errors in the spreadsheet, the worse that will happen is the inability to re-import the file back into the database.
 
=='''Procedure Order'''==
Create an encounter.  From Administrative, choose "Procedure Order".
Create an encounter.  From Administrative, choose "Procedure Order".
[[File:lab20.png]]
[[File:1po.png|center]]  




Click in the designated area to search for the diagnostic study.
Click in the designated area to search for the diagnostic study.
[[File:lab21a.png]]
[[File:2po.png|center]]  




[[File:lab22.png]]
Click the link to select the study.
[[File:lab22.png|center]]




Click "Save and Transmit".
Click "Save and Transmit".
[[File:lab23a.png]]
[[File:3po.png|center]]
 
 
=='''Pending Review'''==
To bring up the studies for result entry, login as Physician. Other staff, including Administrator, will not have the ability to perform this task.  Generally this privilege should be reserved for the Physician.  The Front Desk should not be permitted to sign off on diagnostic studies. 


In unusual situations wherein the Physician wears two hats and has the responsibility of the Administrator as well, this can be changed in Administration/ACL by granting the Access Control Object, "Sign Lab Results", to the Administrator.


==Pending Review==
[[File:Signlab.png|center]]
To bring up the studies for result entry, login as Physician. Other staff, including Administrator, will not have the ability to perform this task.  This can be changed in Administration/ACL.
[[File:lab24.png]]




Add the Reported date and assign a Status before clicking the "Sign Results" button.
[[File:5lab24.png|center]]
[[File:lab25.png]]




==Patient Results==
Add the Reported date, assign a Status and enter the results before clicking the "Sign Results" button.
After the signing the results, the data will appear in Patient Results.
[[File:4lab25.png|center]]
[[File:lab26.png]]




==Electronic Reports==
=='''Patient Results'''==
This can be used to look up studies for a particular day.  It is a good way to track tests which are lacking results.
After signing the results, the data will appear in Patient Results.
[[File:lab27.png]]
[[File:2lab26.png|center]]




==Postscript==
=='''Electronic Reports'''==
This can be used to look up studies for a particular day or period of time.  It is an excellent tool to prevent a study from being forgotten.  In a busy practice it is not unusual to overlook an ordered study; only to discover later, ''to the horror of the practice'', that in addition to the abnormal result; that the timely processing of that result could have saved the patient from a delay in diagnosis and treatment.
[[File:2lab27.png|center]]
 
 
=='''Postscript'''==
Configuration of the Procedures Module is a bit of a workout.  Like all other aspects of OpenEMR, the more a physician masters; the greater his confidence and the deeper his appreciation of the ''magnum opus'' of the developers of this Project and all other Open Source projects as well.
Configuration of the Procedures Module is a bit of a workout.  Like all other aspects of OpenEMR, the more a physician masters; the greater his confidence and the deeper his appreciation of the ''magnum opus'' of the developers of this Project and all other Open Source projects as well.


Always frolick along the way.
Always frolick along the way.
 
<br><br>
 
[[Category: Configuration Guide]][[Category:User Guide]][[Category:User Guide 4.1.0]][[Category:User Guide 4.1.1]][[Category:User Guide 4.1.2]][[Category:User Guide 4.2.0]]
Categories:Configuration Guide|User Guide|User Guide 4.1.0|User Guide 4.1.1|User Guide 4.1.2

Latest revision as of 16:29, 19 December 2015

Preface

The goal of this guide is to provide a set of step-by-step instructions for setting up the Procedures Module to enter diagnostic results by hand. Doing so brings this data into the Encounter Form and closer to the clinical note.

Configuration necessitates meticulous attention to detail and order of execution. Once properly configured, deployment is relatively simple by comparison.

It is possible to upload a scanned image of results into Documents/Medical Record, but that will place the data at a further distance from the clinical note.

To transmit orders and receive results from an external laboratory facility, refer to Laboratory Exchange User Documentation.

Facility

Despite the fact that no orders will be transmitted to an external facility; it is necessary, however, to manufacture a fictitious Lab Service in order to configure this module. If the practice has an in-house lab, enter its name. "Our Own Lab" will the Lab Service for the purpose of this exercise.

From the Menu on the left side bar, go to Procedures/Providers and add "Our Own Lab".

1fake.png
2fake.png
3fake.png


Configuration

Manual Method

The module can be set up for a panel of tests or for a single study. A panel will require a 4 tier process while it is only 3 for a single test.

Panel

Click the Configuration link and the "Add Top Level" button to begin. This button must be clicked each time a new panel or new single study is added to the list.

1panel.png


The first tier, or level, of the configuration, will be the naming of the Group. Maintain the Sequence to keep the list in the desired order.

Lab2.png


To begin the second tier of configuration, click the "Add" link. Use "Edit" to modify configuration. To delete a setting, click "Edit" and go to the desired dialog box to delete the entry.

2chm1.png

2chm2.png


The second tier involves naming the Group as "Electrolytes" and assigning an Identifying Code to it. The choice of numerals or letters is at the discretion of the practice.

Lab6.png
Lab7.png


Be certain that there is a "Yes" under the Order column and an Identifying Code as well. If these items are missing, it is a warning that the configuration had been faulty. The entries must be deleted and the process begun anew.

Click the "Add" link associated with "Electrolytes" to begin setting up Sodium.

1ele1.png

1ele2.png


The third tier will configure the first test of the panel, namely Sodium. Fields left empty are optional.

3na.png


Because mEq/L was missing; it had to be added in Administration/Lists/Procedure Units. Remember to make the addition Active before saving it.

1meq.png


It is helpful to have the range of values for a particular test in Discrete Result; but Recommendation is optional. Click "Add" link on the same line as Sodium to configure the fourth tier, Discrete Result.

1val.png


Lab11.png


A similar process is used to add the other tests of the panel. Again click the "Add" link associated with "Electrolytes" to begin. Pay close attention to Sequence; otherwise the tests will appear in alphabetical order; not Na, K, Cl, CO2 as physicians are accustomed.

5k1.png

3k2.png


2k1.png


Click "Add" on the Potassium line to configure Discrete Result.

Lab14.png


A full panel should look like the following.

1total1.png

1toal2.png


Single Study

Click "Add Top Level". A single test requires the naming of the Group and of the test.

Lab16.png
6bun1.png


Check that "Yes" and the code are present. Click the "Add" link to configure the third tier, Discrete Result.

2bun1.png

2bun2.png


Lab18.png


Bear in mind that if there is a study which has different normal values depending on the gender of the patient, the user must assign different Identifying Codes for each Discrete Result. An example would be Hemoglobin/Hematocrit. If the user assigns only one code for the 2 Discrete Result ranges, there will a configuration problem.

Load Compendium

If the user partners with Diagnostic Pathology Medical Group, Pathgroup Labs LLC or Yosemite Pathology Medical Group, he can obtain from them a data set of diagnostic studies for the Procedure module to avoid manual configuration.

Database Method

Users who don't use the services of the above mentioned vendors can try their hand at configuration of tests with phpMyAdmin. The Forum discussion can be found here.

There are 1794 studies in the Mayo Clinic data set. For most practices this list will need to be whittled down. Only Carbon Dioxide has been configured with 3 tiers. The balance will need additional work setting up Group and Discrete Result. It will do the reader little good if he can search for the test but unable to enter lab results.

Preparations

Download this data set, Mayo_loinc.zip. Because phpMyAdmin will only accept a zipped .sql file (this is a zipped .csv file), it must be extracted before import.

Understand the structure of the procedure_type table and the characteristics of each column.

0mayo.png

Import

Navigate from the Menu to Administration/Other/Database. From the 4th page of the database, go to procedure_type, then to the Import tab. Browse for the unzipped file and click Go.

3mayo.png


If all goes well, you should see the following.

5mayo.png

Working in phpMyAdmin

From the Browse tab navigate to the last page, 72. Scroll to the bottom and follow the CO2 example to add Group and Discrete Result for a particular test.

2mayo.png


Most users will find manual configuration easier to handle. The Graphical User Interface will become familiar after a few attempts. Working in phpMyAdmin requires more skills with a potential for damaging the database. Backup is strongly advised beforehand.

A safer way to accomplish this task is to load the .csv file into OpenOffice Calc or Excel after studying the CO2 example. The deletion of unwanted studies and the insertion of rows for Group and Discrete Result will be more in the user's comfort zone. If there are errors in the spreadsheet, the worse that will happen is the inability to re-import the file back into the database.

Procedure Order

Create an encounter. From Administrative, choose "Procedure Order".

1po.png


Click in the designated area to search for the diagnostic study.

2po.png


Click the link to select the study.

Lab22.png


Click "Save and Transmit".

3po.png


Pending Review

To bring up the studies for result entry, login as Physician. Other staff, including Administrator, will not have the ability to perform this task. Generally this privilege should be reserved for the Physician. The Front Desk should not be permitted to sign off on diagnostic studies.

In unusual situations wherein the Physician wears two hats and has the responsibility of the Administrator as well, this can be changed in Administration/ACL by granting the Access Control Object, "Sign Lab Results", to the Administrator.

Signlab.png


5lab24.png


Add the Reported date, assign a Status and enter the results before clicking the "Sign Results" button.

4lab25.png


Patient Results

After signing the results, the data will appear in Patient Results.

2lab26.png


Electronic Reports

This can be used to look up studies for a particular day or period of time. It is an excellent tool to prevent a study from being forgotten. In a busy practice it is not unusual to overlook an ordered study; only to discover later, to the horror of the practice, that in addition to the abnormal result; that the timely processing of that result could have saved the patient from a delay in diagnosis and treatment.

2lab27.png


Postscript

Configuration of the Procedures Module is a bit of a workout. Like all other aspects of OpenEMR, the more a physician masters; the greater his confidence and the deeper his appreciation of the magnum opus of the developers of this Project and all other Open Source projects as well.

Always frolick along the way.