Difference between revisions of "Extract and Load via SSMT"
| Line 13: | Line 13: | ||
* [[SSMT: Order Performing Facility Identifiers]] - This spreadsheet is where you syncronize multiple 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: 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== | ==Error Messages== | ||
The SSMT tool returns various error messages. Here is a page dedicated to [[SSMT Error Messages]] | The SSMT tool returns various error messages. Here is a page dedicated to [[SSMT Error Messages]] | ||
Revision as of 14:47, 31 October 2007
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 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