SSMT: Site Location

Description

The Site Location SSMT content category is primarily used for managing the relationship between Site Locations (such as exam rooms, procedure rooms, waiting rooms, etc.) and Sites. It serves to populate the Location drop down on the Clinical Toolbar to assist with waiting room management. It will also create new Site Locations if you happen to enter a new and unique Site Location that does not already exist in the system.

Stored Procedures used:

• Extracting data: IMPGetSiteLocation
• Loading data: IMPSetSiteLocation

Column Listing and Descriptions

• Entry Code -

• Entry Name -

• Entry Mnemonic -

• SiteEntryCode - this field should reference the Entry Code value of the Site that you are mapping the Site Location to. It is recommended to pull the Entry Code directly from the Site dictionary to ensure consistency. The Site must must exist prior to doing this.

• SiteEntryName - this field should reference the Entry Name of the Site that you are mapping the Site Location to. It is recommended to pull this description directly from the Site dictionary to ensure consistency. The Site must exist prior to doing this.

• Sequence -

• IsInactive -

   * Y -
   * N - 

• Create? - this field is used to specify whether or not the Site Location being loaded is new or already exists. Valid values for this column are:

   * Y - this will add the Site Location to the Site Location dictionary if it is a new and unique Site Location.
   * N - this flag should be used when the Site Location you are mapping to the Site already exists in the Site Location dictionary.

• DeleteFlag? - this field is used to maintain or delete the mapping between Site and Site Location. Valid values for this column are:

   * Y - will delete the mapping between the given Site and Site Location.  It will NOT delete the site location itself.
   * N - will not attempt to delete the mapping between the given Site and Site Location. 

back to SSMT main page