Difference between revisions of "Extract and Load via SSMT"
Jump to navigation
Jump to search
| Line 16: | Line 16: | ||
* [[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 synchronize multiple vendors. | * [[SSMT: Order Performing Facility Identifiers]] - This spreadsheet is where you synchronize multiple vendors. | ||
| + | * [[SSMT: OID - Order Defaults - Req Perf Location / Site]] - This is the spreadsheet that allows you to set defaults on a [[Site]] or [[Request Performing Location]] level. This can set various default behaviors such as charge behavior, order detail, and much, much more. | ||
* [[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 | ||
Revision as of 00:50, 30 April 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: OID - Order Defaults - Req Perf Location / Site - This is the spreadsheet that allows you to set defaults on a Site or Request Performing Location level. This can set various default behaviors such as charge behavior, order detail, and much, much more.
- 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