Difference between revisions of "SSMT: Order Modifiers"

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Jump to navigation Jump to search
m (Created page with "==Description== This page will explain how to manage the Body Site dictionary using SSMT. This dictionary is typically manually managed by the admin team manually and does conta...")
 
 
(7 intermediate revisions by 4 users not shown)
Line 1: Line 1:
 +
[[Category:SSMT|Order Modifiers]]
 
==Description==
 
==Description==
−
This page will explain how to manage the Body Site dictionary using SSMT.  This dictionary is typically manually managed by the admin team manually and does contain many system delivered entries.  In these types of cases SSMT can be useful when helping in moving certain groups or reconciling amongst environments.
+
This page will explain how to use the Order Modifiers SSMT content category to assist in managing the [[Item Modifier|item modifiers]].  Order modifiers are the base for modifier pick lists which are assigned to orderable items via the [[Order Item Dictionary|orderable item dictionary]] and engaged via the order detail screen in the EHR application.
  
 
Stored Procedures used:
 
Stored Procedures used:
−
*Extracting data: Select EntryCode, EntryName, EntryMnemonic, IsInactiveFlag, 'N' 'Create?' From Body_Site_DE where ID > 0 order by EntryName
+
*Extracting data: Select EntryCode, EntryName, EntryMnemonic, SnoTermCODE, IsInactiveFlag From QO_Mod_DE where ID > 0 order by EntryName
−
*Loading data: IMPSetSimpleDE'Body_Site_DE'
+
*Loading data: IMPSetOrderModifierDE
  
 
==Column Listing and Descriptions==
 
==Column Listing and Descriptions==
  
−
*'''Entry Code''' - this is the unique alpha-mnemonic entry code value for the body site entry.
+
*'''Entry Code''' - this is the unique entry code value of the order item modifier.  This can never be left null and can be an alpha and/or numeric combination.
  
−
*'''Full Name''' - this is the full name description of the body site entry.
+
*'''Full Name''' - this is the description of the order item modifier.  This should be meaningful and is what the user will see if addressing the prompt during the ordering process.
  
−
*'''Entry Mnemonic''' - this is the unique alpha-mnemonic entry code value for the body site entry.
+
*'''Entry Mnemonic''' - this is the unique entry mnemonic of the order item modifier.  This field may appear blank for records that are delivered with the system.
 +
 
 +
*'''SnoTermCODE''' - indicates the SnoMed CT code for the SnoMed term that is linked to the entry; if one exists.
  
 
*'''Inactive?''' - acceptable values for this field are:
 
*'''Inactive?''' - acceptable values for this field are:
  
−
     * Y - indicates the entry is currently inactive; use to inactivate.
+
     * Y - indicates the current entry is inactive; use to inactivate entries.
−
     * N - indicates the entry is currently active; use to create new or update existing entries.
+
     * N - indicates the current entry is not inactive, use to create new entries.
−
 
 
−
*'''Create?''' - acceptable values for this field are:
 
−
 
 
−
    * Y - indicates that a new entry is being created; use to add new entries.
 
−
    * Blank - indicates an already existing entry; use to update already existing entries.
 
  
 
== Migration Considerations ==
 
== Migration Considerations ==
  
−
* '''Delivered/Enforced Entries''' - always review or take the time to briefly reconcile these prior to migrating from environment to environment.  It is quite possible that atomic changes to the entry code field (for example) could easily lead to duplicate or unintended records in the new environment.
+
*'''No Create flag''' - the Inactive? flag with a parameter of N is actually used to trigger the creation of a new record AND update already existing records.  If the code for the item modifier being loading already exists an update will be attempted; otherwise a new entry will be created.
−
* '''FLAG Cross Check''' - always cross check any flags that will effect how the record is interpreted by the new environment!!
 
−
**'''IsInactiveFLAG''' - double check that inactive records are not attempting to be created.  For example, it would not make sense to load records where the IsInactiveFLAG and Create flags are both 'Y'.
 
−
**'''Create''' - take the time to make sure that records intended to be net new records are 'Y' and any other potential record updates set to 'N'.
 
−
 
 
−
 
 
−
'''back to [[SSMT]] main page'''
 

Latest revision as of 14:48, 28 November 2012

Description

This page will explain how to use the Order Modifiers SSMT content category to assist in managing the item modifiers. Order modifiers are the base for modifier pick lists which are assigned to orderable items via the orderable item dictionary and engaged via the order detail screen in the EHR application.

Stored Procedures used:

  • Extracting data: Select EntryCode, EntryName, EntryMnemonic, SnoTermCODE, IsInactiveFlag From QO_Mod_DE where ID > 0 order by EntryName
  • Loading data: IMPSetOrderModifierDE

Column Listing and Descriptions

  • Entry Code - this is the unique entry code value of the order item modifier. This can never be left null and can be an alpha and/or numeric combination.
  • Full Name - this is the description of the order item modifier. This should be meaningful and is what the user will see if addressing the prompt during the ordering process.
  • Entry Mnemonic - this is the unique entry mnemonic of the order item modifier. This field may appear blank for records that are delivered with the system.
  • SnoTermCODE - indicates the SnoMed CT code for the SnoMed term that is linked to the entry; if one exists.
  • Inactive? - acceptable values for this field are:
   * Y - indicates the current entry is inactive; use to inactivate entries.
   * N - indicates the current entry is not inactive, use to create new entries.

Migration Considerations

  • No Create flag - the Inactive? flag with a parameter of N is actually used to trigger the creation of a new record AND update already existing records. If the code for the item modifier being loading already exists an update will be attempted; otherwise a new entry will be created.
Retrieved from "https://wiki.galenhealthcare.com/index.php?title=SSMT:_Order_Modifiers&oldid=15660"