SSMT: Allergen
Revision as of 18:03, 28 January 2011 by David.Burkhead (talk | contribs) (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...")
Description
This page will explain how to manage the Allergen dictionary using SSMT.
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