SSMT: Allergen

Description

This page will explain how to manage the Allergen dictionary using SSMT. This dictionary is typically managed (and usually manually) by an analyst or admin team. SSMT can be useful with regard to allergens when it may be necessary to move large groups of allergens to a new environment or perhaps to assist with 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 and is self defined if the allergen is self defined.

• Full Name - this is the description of the allergen value and is self defined if the allergen is self defined.

• Entry Mnemonic - this is the unique alpha or numeric entry code value for the allergen. It may typically mirror the entry code value and is self defined if the allergen is self defined.

• 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 already existing 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 already existing entries.

back to SSMT main page