SSMT: Body Site

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Revision as of 18:52, 28 January 2011 by David.Burkhead (talk | contribs)
Jump to navigation Jump to search

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.

Stored Procedures used:

  • Extracting data: Select EntryCode, EntryName, EntryMnemonic, IsInactiveFlag, 'N' 'Create?' From Body_Site_DE where ID > 0 order by EntryName
  • Loading data: IMPSetSimpleDE'Body_Site_DE'

Column Listing and Descriptions

  • Entry Code -
  • Full Name -
  • Entry Mnemonic -
  • Inactive? -
  • Create? -

back to SSMT main page