Difference between revisions of "SSMT: Order Performing Facility Identifiers"

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Jump to: navigation, search
m (Details)
(Column Listing and Descriptions)
Line 9: Line 9:
  
 
==Column Listing and Descriptions==
 
==Column Listing and Descriptions==
The columns for this dictionary in TouchWorks v11.0.1 (confirmed for v11.1.5) are as follows:
+
The columns for this dictionary in TouchWorks v11.0.1 (confirmed for v11.2) are as follows:
  
* OrderableItemEntryCode - this is the Order EntryCode of the Primary vendor that you are attempting to sync with the secondary vendor.  If LabCorp is your primary vendor and you are linking a quest order to it, you would enter the LabCorp Order Code here.  
+
*'''OrderableItemEntryCode''' - this is the Order EntryCode of the Primary vendor that you are attempting to sync with the secondary vendor.  If LabCorp is your primary vendor and you are linking a quest order to it, you would enter the LabCorp Order Code here.  
* OrderableItemEntryname - This would be the Order Name of the primary vendor.  To continue with the example, this would be the LabCorp Order Name.
+
* '''OrderableItemEntryname''' - This would be the Order Name of the primary vendor.  To continue with the example, this would be the LabCorp Order Name.
*  Performing Location EntryName -  This should be the name of the Requested Performing Location entry for the secondary lab.  This item must exist in the [[Requested Performing Location]] dictionary prior to loading the spreadsheet.  In our example, this would be Quest
+
'''Performing Location EntryName''' -  This should be the name of the Requested Performing Location entry for the secondary lab.  This item must exist in the [[Requested Performing Location]] dictionary prior to loading the spreadsheet.  In our example, this would be Quest.
*  Performing Location Specific Orderable Entryname - This is the secondary lab's entryname.  This will not display in the product since the user will see the Primary labs entry name or the Display name set in the OID dictionary.  In this example, we would pace the Quest Order Name here.   
+
'''Performing Location Specific Orderable Entryname''' - This is the secondary lab's entryname.  This will not display in the product since the user will see the Primary labs entry name or the Display name set in the OID dictionary.  In this example, we would place the Quest Order Name here.   
*  Performing Location Specific Orderable EntryCode - This is the Order Entry code of the secondary lab vendor.  In this example we would put the Quest CBC Order Code in this field.
+
'''Performing Location Specific Orderable EntryCode''' - This is the Order Entry code of the secondary lab vendor.  In this example we would put the Quest CBC Order Code in this field.
*  Performing Location Specific Orderable EntryMnemonic - this is the Order Entry Mnemonic of the secondary Lan vendor.  In this example we would place the Quest Entry Mnemonic for the order in this field.   
+
'''Performing Location Specific Orderable EntryMnemonic''' - this is the Order Entry Mnemonic of the secondary Lan vendor.  In this example we would place the Quest Entry Mnemonic for the order in this field.   
*  Delete - This field should be set to 'N' if you are loading new entries.  If you need to remove items in the future, you can extract the dictionary and set the itmes you wish to remove to 'Y' and load the data through [[SSMT 101: How to Load and Extract using SSMT|SSMT]].
+
'''Delete''' - This field should be set to 'N' if you are loading new entries.  If you need to remove items in the future, you can extract the dictionary and set the items you wish to remove to 'Y' and load the data through [[SSMT 101: How to Load and Extract using SSMT|SSMT]].
 +
* '''Create?''' - This field should be set to Y if new entries are being loaded.
  
 
         Storage:  Works.dbo.OrderItem_Identifier
 
         Storage:  Works.dbo.OrderItem_Identifier
  
 
'''back to [[SSMT]] main page'''
 
'''back to [[SSMT]] main page'''

Revision as of 12:39, 27 August 2012

Description

This is an article describing the SSMT spreadsheet for the Order Performing Facility Identifiers.

For details on building this dictionary refer to V11 Order and Result Dictionary Build and Syncronization

Stored Procedures used:

  • Extracting data: ImpGetOrderPerformingFacilityIdentifiers
  • Loading data: ImpSetOrderPerformingFacilityIdentifiers

Column Listing and Descriptions

The columns for this dictionary in TouchWorks v11.0.1 (confirmed for v11.2) are as follows:

  • OrderableItemEntryCode - this is the Order EntryCode of the Primary vendor that you are attempting to sync with the secondary vendor. If LabCorp is your primary vendor and you are linking a quest order to it, you would enter the LabCorp Order Code here.
  • OrderableItemEntryname - This would be the Order Name of the primary vendor. To continue with the example, this would be the LabCorp Order Name.
  • Performing Location EntryName - This should be the name of the Requested Performing Location entry for the secondary lab. This item must exist in the Requested Performing Location dictionary prior to loading the spreadsheet. In our example, this would be Quest.
  • Performing Location Specific Orderable Entryname - This is the secondary lab's entryname. This will not display in the product since the user will see the Primary labs entry name or the Display name set in the OID dictionary. In this example, we would place the Quest Order Name here.
  • Performing Location Specific Orderable EntryCode - This is the Order Entry code of the secondary lab vendor. In this example we would put the Quest CBC Order Code in this field.
  • Performing Location Specific Orderable EntryMnemonic - this is the Order Entry Mnemonic of the secondary Lan vendor. In this example we would place the Quest Entry Mnemonic for the order in this field.
  • Delete - This field should be set to 'N' if you are loading new entries. If you need to remove items in the future, you can extract the dictionary and set the items you wish to remove to 'Y' and load the data through SSMT.
  • Create? - This field should be set to Y if new entries are being loaded.
       Storage:  Works.dbo.OrderItem_Identifier

back to SSMT main page