Difference between revisions of "SSMT: Allergen"
Jump to navigation
Jump to search
(Created page with "==Description== This page will explain how to manage the Allergen dictionary using SSMT. Stored Procedures used: *Extracting data: Select EntryCode, EntryName, EntryMnemonic, Is...") |
|||
| Line 1: | Line 1: | ||
==Description== | ==Description== | ||
| − | This page will explain how to manage the Allergen dictionary using SSMT. | + | This page will explain how to manage the Allergen dictionary using SSMT. This dictionary is typically manually managed by the admin team, but SSMT can be useful when helping in moving certain groups of allergens or reconciling amongst environments. |
Stored Procedures used: | Stored Procedures used: | ||
Revision as of 18:05, 28 January 2011
Description
This page will explain how to manage the Allergen dictionary using SSMT. This dictionary is typically manually managed by the admin team, but SSMT can be useful when helping in moving certain groups of allergens or reconciling amongst environments.
Stored Procedures used:
- Extracting data: Select EntryCode, EntryName, EntryMnemonic, IsInactiveFlag, 'N' 'Create?' From Allergen_DE where ID > 0 order by EntryName
- Loading data: ImpSetSimpleDE'Allergen_DE'
Column Listing and Descriptions
- Entry Code - this is the unique alpha or numeric entry code value for the allergen.
- Full Name - this is the description of the allergen value.
- Entry Mnemonic - this is the unique alpha or numeric entry code value for the allergen.
- Inactive? - acceptable values for this field are:
* Y - indicates that the entry is currently inactive; use to inactivate entries. * N - indicates that the entry is not inactive; use to update entries.
- Create? - acceptable values for this field are:
* Y - if set will attempt to create the entry as a new record; use to create new entries. * Blank - if set will attempt to update an already existing entry if found; use to update entries.
back to SSMT main page