Difference between revisions of "Extract and Load via SSMT"
Jump to navigation
Jump to search
Line 15: | Line 15: | ||
* [[SSMT: RID - Resultable Item Dictionary]] - This is the spreadsheet that allows you to load the result definitions from your various lab vendors. | * [[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: 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 | + | * [[SSMT: Order Performing Facility Identifiers]] - This spreadsheet is where you synchronize 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 | * [[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 18:56, 21 February 2008
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 synchronize 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