SSMT: Allergen

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