SSMT: Pharmacy

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Jump to navigation Jump to search


The Pharmacy content category in SSMT is intended to provide an automated way to build and manage the Pharmacy dictionary in Allscripts Enterprise EHR. Typically when approaching this build step in the implementation it is given that the system comes pre-loaded with SureScripts EDI enabled pharmacies. This content category may be utilized to add additional pharmacies that may not come with the system, to help single out the top 25 - 50 in preparation for SureScripts go-live, or even to do some basic formatting and field updates.

Stored Procedures used:

  • Extracting data: ImpGetPharmacy
  • Loading data: ImpSetPharmacy

Column Listing and Descriptions

  • Entry Code - this is the unique entry code or identifier for the pharmacy entry. This is typically a numeric value for pre-delivered SureScripts pharmacies, but for pharmacies you wish to add aside from that it can be alpha-numeric or self defined.
  • Entry Name - this should be the name or description of the pharmacy. Sometimes this is appended with a town, city, or street name depending on its local reputation.
  • Entry Mnem - this is the unique entry mnemonic value of the pharmacy and will typically mirror the entry code value. Depending on the internal naming convention it can be set to a somewhat descriptive alpha value if desired.
  • Address - this is the address of the pharmacy.
  • City - this is the city that the pharmacy is located in.
  • State - this is the state that the pharmacy is located in. This needs to be the standard two letter abbreviation for the state.
  • Zip - this is the zip code in which the pharmacy is located.
  • Phone - this is the 9 digit phone number value of the pharmacy location. Possible input formats include:
  • Ext - this field is for a phone number extension value if it applies.
  • Fax - this is the 9 digit fax number value of the pharmacy location.
  • Contact - this field is designated for any particular name or general information regarding a preferred contact person at the pharmacy location.
  • NABP# - this field is for the NABP (National Association of Boards of Pharmacy) identification number if it is available. It helps to uniquely identify a pharmacy location; similarly to how a lab assigned LOINC code might function.
  • Inactive? - this is the inactive flag for the pharmacy entry. Possible values include:
   * Y - for already existing entries this will flag the pharmacy as inactive in the system. 
   * N - should be set to this for creating new entries or re-activating already existing entries.
  • Create? this is the create flag for the pharmacy entry. Possible values include:
   * Y - should use this flag is you are attempting to create a new pharmacy entry.
   * Blank -  should be left as blank (or even 'N') if you are updating already existing pharmacy entries.