Extract and Load via SSMT

Description

The SSMT tool is an Allscripts provided tool that allows clinics to extract and load data into their TouchWorks system. This tool should be used by a person that understands how to use it and you should be sure to follow the Allscripts documented process when utilizing the tool.

    Warning:
    Ensure that you complete a database SQL Backup prior to loading any data through SSMT.  The tool is pretty robust, 
    but human error or progam bugs could create a mess.  Completing a backup first takes only takes a few minutes and can save 
    hours of time if something does happen. 

Below are a list of some common spreadsheets with their description. Select the Spreadsheet name for a more indepth description.

Spreadsheet Definitions

• SSMT: Users / Providers - This is the spreadsheet you use to load and manger user and provider accounts.
• SSMT: RID - Resultable Item Dictionary - This is the spreadsheet that allows you to load the result definitions from your various lab vendors.
• SSMT: OID - Orderable Item Dictionary - This spreadsheet allows you to load you Order Level items for your various vendors.
• SSMT: Order Performing Facility Identifiers - This spreadsheet is where you syncronize multiple vendors.
• SSMT: Charge Codes - This spreadsheet is where you would load or edit Charge Codes within TouchWorks
• SSMT: Document Type - This is the spreadsheet that allows you to upload or edit documents within TouchWorks

Error Messages

The SSMT tool returns various error messages. Here is a page dedicated to SSMT Error Messages