Extract and Load via SSMT
Revision as of 18:06, 1 November 2007 by Jason.Carmichael (talk | contribs)
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 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