Difference between revisions of "SSMT: Results Where Performed Identifiers"
Jump to navigation
Jump to search
Max.Stroud (talk | contribs) m (SSMT: Results Where Performed Indetifiers moved to SSMT: Results Where Performed Identifiers: spelling error) |
|||
| (5 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| + | [[Category:SSMT|Remove Where]] | ||
==Description== | ==Description== | ||
| − | This is an article describing the [[SSMT]] spreadsheet for the Results Where Performed Identifiers. | + | This is an article describing the [[SSMT 101: How to Load and Extract using SSMT|SSMT]] spreadsheet for the Results Where Performed Identifiers. |
| − | For details on building this dictionary refer to [[V11 Order and Result Dictionary Build and | + | For details on building this dictionary refer to [[V11 Order and Result Dictionary Build and Synchronization]] |
| − | == | + | Stored Procedures uses: |
| + | *Extracting data: ImpGetResultsWherePerformedIdentifiers | ||
| + | *Loading data: ImpSetResultsWherePerformedIdentifiers | ||
| + | |||
| + | ==Column Listing and Descriptions== | ||
The columns for this dictionary in TouchWorks v11.0.1 are as follows: | The columns for this dictionary in TouchWorks v11.0.1 are as follows: | ||
| − | * | + | *'''Result Item EntryCode''' - This is the Entry code of the Primary Lab vendors Result entry that you are synchronizing the secondary with. |
| − | * | + | *'''Result Item EntryName''' - This is the Entry Name of the Primary Lab Vendors Result entry that you are synchronizing the secondary with. |
| − | * | + | *'''Where Performed EntryName''' - This is the Entryname value of your secondary vendor from the [[Where Performed]] dictionary. |
| − | * | + | *'''Where Performed Specific Resultable Entryname''' - This is the EntryName of the secondary resultable that you are attempting to sync to the primary resultable. |
| − | * | + | *'''Where Performed Specific Resultable EntryCode''' - this is the EntryCode of the secondary resultable that you are attempting to sync to the primary resultable. |
| − | * | + | *'''Where Performed Specific Resultable EntryMnemonic''' - this is the EntryMnemonic of the secondary resultable that you are attempting to sync to the primary resultable. |
| − | * | + | *'''Delete''' - This is asking if you want to Delete the entry. If loading the values, set this to 'N'. If you'd like to remove the entry at a later time, you can extract the dictionary, set this column to 'Y' and reload the data. This will remove the link from the database. |
Latest revision as of 11:42, 19 July 2013
Description
This is an article describing the SSMT spreadsheet for the Results Where Performed Identifiers.
For details on building this dictionary refer to V11 Order and Result Dictionary Build and Synchronization
Stored Procedures uses:
- Extracting data: ImpGetResultsWherePerformedIdentifiers
- Loading data: ImpSetResultsWherePerformedIdentifiers
Column Listing and Descriptions
The columns for this dictionary in TouchWorks v11.0.1 are as follows:
- Result Item EntryCode - This is the Entry code of the Primary Lab vendors Result entry that you are synchronizing the secondary with.
- Result Item EntryName - This is the Entry Name of the Primary Lab Vendors Result entry that you are synchronizing the secondary with.
- Where Performed EntryName - This is the Entryname value of your secondary vendor from the Where Performed dictionary.
- Where Performed Specific Resultable Entryname - This is the EntryName of the secondary resultable that you are attempting to sync to the primary resultable.
- Where Performed Specific Resultable EntryCode - this is the EntryCode of the secondary resultable that you are attempting to sync to the primary resultable.
- Where Performed Specific Resultable EntryMnemonic - this is the EntryMnemonic of the secondary resultable that you are attempting to sync to the primary resultable.
- Delete - This is asking if you want to Delete the entry. If loading the values, set this to 'N'. If you'd like to remove the entry at a later time, you can extract the dictionary, set this column to 'Y' and reload the data. This will remove the link from the database.