Difference between revisions of "Extract and Load via SSMT"
Jump to navigation
Jump to search
Max.Stroud (talk | contribs) |
Max.Stroud (talk | contribs) |
||
| Line 25: | Line 25: | ||
This bears repeating here: | This bears repeating here: | ||
| − | '''Warning''': | + | '''Warning''': |
Ensure that you complete a database [[SQL Backup]] prior to loading any data through SSMT. The tool is pretty robust, | 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 | 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. | + | hours of time if something does happen. |
| + | |||
| + | *See above, complete a database [[SQL backup]] | ||
==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 16:35, 6 May 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 Requested Performing Location level. This can set various default behaviors such as charge behavior, order detail, and much, much more.
- SSMT: OID - Order Defaults - Insurance/PatientLocation/Site - This allows you to specify orderable behavior on the insurance, patient location, or site level. It is used to set defaults such as the Default Requested Performing Location, Requested Performing Location Picklist, Internal/External Required behavior, Referred to Vendor Org required behavior, Referred to Location Site Required behavior, and Referred to Provider Required behavior.
- 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 Load, Step By Step
This bears repeating here:
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.
- See above, complete a database SQL backup
Error Messages
The SSMT tool returns various error messages. Here is a page dedicated to SSMT Error Messages