Difference between revisions of "V11 Order and Result Dictionary Build and Synchronization"
m (V11 Order and Result Dictionary Build and Syncronization moved to V11 Order and Result Dictionary Build and Synchronization: spelled wrong)
Revision as of 18:45, 21 February 2008
This page is designed to walk someone through the build process for the TouchWorks v11 Order and Results dictionary build. In TouchWorks v11 you have to synchronize your orderable items with the Touchworks Order Concept Dictionary (OCD) in order for things such as care plans and AHS defined specialty favorites to work correctly with orders. If you are using multiple vendors, you also must go through the process of synchronizing the multiple vendors together. Once you have the order side complete, you can go through the process of synchronizing results to the Results Concept Dictionary (RCD). Currently this does not do anything, but future functionality will utilize this feature.
Step 1: Request the Order/Result Compendium from the various vendors
The first step is to gather the order/result compendiums from the various lab vendors. In most cases people will ask for a utilization report and only focus their effort on the top 80% of labs ordered for their locations. There are a bunch of possible orders that aren't used often or at all, so it can cut down on the effort and future maintenance if you focus your efforts. If you do use this approach, you will need to have a process for ordering labs not found in the system, which will most likely be the current paper process. When the results are returned through the interface the dictionary values may need to be entered for the results to file. There is also a dictionary loader interface that can be utilized with results interfaces. This can be requested from your AHS interface analyst. It will file missing items on the fly. This is much better than manually working one error at a time.
When requesting the compendium from the vendor, be sure to ask for CPT4 and LOINC codes as well. This helps dramatically when going through the synchronization process. This will allow you to group the various vendors by CPT4 and/or LOINC and help determine which orders and results are indeed the same. It is not always one for one, but it usually narrows it quite a bit.
Step 2: Pick a Master Vendor
The next step is probably the easiest, pick your master vendor. In most cases a medical group has a lab that they utilize the most and that is typically the best choice. Overall you want to choose the Lab vendor that has the most codes and preferably the cleanest compendium. This vendor that you choose will be loaded as the primary lab vendor and will be the vendor that gets loaded into the Order Item Dictionary OID. It is ok if the primary vendor doesn't have every single item that your other vendors will need, but it should be more than 50% of the distinct tests.
Step 3: Build the OID dictionary for you primary vendor
To begin building the OID dictionary for TouchWorks you should begin by getting the unique list of Order codes from your primary Lab vendors compendium. This does not include any of the resultables that are tied to the Orderable, just the actual test name and it's underlying information.
Once you have the unique list of Orderables, you must insert the data into the corresponding SSMT spreadsheet. For this dictionary, you want the SSMT spreadsheet named "OID - Orderable Item". To get the Headers for this spreadsheet, I would recommend extracting the spreadsheet from the TouchWorks Database using SSMT and ensuring that the "Show Headers in Extracted Data?" option is selected. There have been many times where the headers at the bottom of the screen have differed from the actual needed headers. Returning them during the extraction seems to be more reliable.
If you are unfamiliar with the SSMT columns for the OID spreadsheet please refer to SSMT: OID - Orderable Item Dictionary
Step 4: Build the RID Dictionary for you primary vendor
The Results Item Dictionary (RID) is the dictionary that houses the actual dictionary items for the returned result data. These are the place holders for the numeric or text values that are returned by the vendor. For example if you order a CBC that would include resultable such as White Blood Count (WBC), Red Blood count (RBC), or Hemoglobin counts.
This exercise requires you to link the resultables to the parent order for the primary results only.
If you are unfamiliar with the SSMT columns for the RID spreadsheet please refer to SSMT: RID - Resultable Item Dictionary
Step 5: Link the secondary vendor to the primary
This step is the first part of the synchronization process. This will allow you to enter identical labs from multiple vendors but only presents the user with one option. For example if you are loading LabCorp and Quest Orders, they would both have a CBC. If you don't sync the Orders, the user would have two CBC's to choose from and it would be confusing. When the two have been linked, the user will simply choose the requested performing location and it would then be routed appropriately with the correct codes. The requested performing location can be defaulted in many ways in v11. You can set them based on site, insurance, or a combination of the two. This allows you to define the most likely choice, but also allows the user to change it if they have feel it needs to go elsewhere.
In this exercise you need to tell the system which secondary labs are equivalent to the primary labs. In some cases, the primary vendor may have multiple codes for the same Orderable as well. In that case, you would treat the duplicate orderable as if it were a secondary lab also. The primary value should be the active Order code. This is done in the order Performing Facility Identifiers spreadsheet.
If you are unfamiliar with this spreadsheet, please refer to SSMT: Order Performing Facility Identifiers
If your secondary lab has orders that do not match your primary vendors entries, you would enter that order as if it were the primary lab and complete Steps 3 and 4 for that Order.
Step 6: Link your secondary lab results to the primary
This step is optional, but recommended. This wasn't available in v10, but the advantage of synchronizing resultables for multiple vendors is that it allows the user to flow common results from multiple vendors on one line. This is a huge benefit to the providers if they want to track the trend of a results ordered from multiple places.
This step is very similar to the Order synchronization process. You will fill out the Results Where Performed Identifiers spreadsheet to complete this process.
If you are unfamiliar with this spreadsheet, please refer to SSMT: Results Where Performed Identifiers
If your secondary vendor has items that can't be matched to the primary vendor, you should load the item into the RID dictionary by following step 4. This is a little trickier than the first pass because you may have to place the secondary labs result items under the primary labs order code. If the secondary labs order is tied to a primary lab in the Order Performing Facility Identifier spreadsheet, you must load the unlinkable secondary resultables under the primary labs order code in the RID.
Let's continue the example using LabCorp as your primary and Quest as your secondary. Imagine that the LabCorp CBC included only WBC and RBC, but the Quest CBC had WBC, RBC, and MCH. You wouldn't be able to synchronize MCH because it doesn't exist in the Primary lab, but the result is under an Order Code (CBC) that is synchronized. In that case you would need to load the Quest MCH resultable code into the RID spreadsheet tied to the LabCorp CBC Order code.
Step 7: Optional - Highly recommended: Link the OID dictionary to the TouchWorks OCD Dictionary
Once you have completed loading the OID and RID entries into the system it is time to synchronize the OID dictionary to the Order Concept Dictionary (OCD) dictionary. The main purpose of this is for users to have the ability to use CareGuides. This is for the most part a manualy process that a lab expert would need to complete for the client. This is completed within TWAdmin. Please see OCD Mapping for further details regarding this process.
Step 8: Optional - Not Recommended: Link the RID dictionary to the TouchWorks RCD Dictionary
Once the RID dictionary has been built you can synchronize those items to the Allscripts Results Concept Dictionary (RCD). This currently doesn't provide any benefit, although it is supposed to be beneficial in the future. I would recommend doing this if you have the time and expertise available, but it is a low priority item that can be done in the future when the functionality is there to utilize the effort. Please see RCD Mapping for further details.