Difference between revisions of "SSMT: Order Modifiers"
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...") |
m |
||
Line 3: | Line 3: | ||
Stored Procedures used: | Stored Procedures used: | ||
− | *Extracting data: Select EntryCode, EntryName, EntryMnemonic, IsInactiveFlag | + | *Extracting data: Select EntryCode, EntryName, EntryMnemonic, SnoTermCODE, IsInactiveFlag From QO_Mod_DE where ID > 0 order by EntryName |
− | *Loading data: | + | *Loading data: IMPSetOrderModifierDE |
==Column Listing and Descriptions== | ==Column Listing and Descriptions== | ||
− | *'''Entry Code''' - | + | *'''Entry Code''' - |
− | *'''Full Name''' - | + | *'''Full Name''' - |
− | *'''Entry Mnemonic''' - | + | *'''Entry Mnemonic''' - |
+ | |||
+ | *'''SnoTermCODE''' - | ||
*'''Inactive?''' - acceptable values for this field are: | *'''Inactive?''' - acceptable values for this field are: | ||
− | * Y - | + | * Y - |
− | * N - | + | * N - |
− | |||
− | |||
− | |||
− | |||
− | |||
== Migration Considerations == | == Migration Considerations == | ||
− | * | + | * |
− | |||
− | |||
− | |||
− | |||
'''back to [[SSMT]] main page''' | '''back to [[SSMT]] main page''' |
Revision as of 20:53, 2 February 2011
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, SnoTermCODE, IsInactiveFlag From QO_Mod_DE where ID > 0 order by EntryName
- Loading data: IMPSetOrderModifierDE
Column Listing and Descriptions
- Entry Code -
- Full Name -
- Entry Mnemonic -
- SnoTermCODE -
- Inactive? - acceptable values for this field are:
* Y - * N -
Migration Considerations
back to SSMT main page