After you create the Procedure Master Translator (formerly referred to as the charge master), you must import it into your PowerScribe 360 | Reporting database. The method you use depends on whether you are loading the database for the first time, or maintaining an existing database.
Before you begin importing a Procedure Master Translator, be sure you have entered a standard clinical code in the ‘link’ column for each row and that you have identified all mammography procedures with ‘yes’ in the ‘mammography’ column.
To import a Procedure Master Translator:
1. In the Setup group, click the Procedures tab.
2. Click Import. The Procedure Code Import dialog box opens.
3. Select the appropriate site from the Sites drop-down list, if it is not already selected.
4. Click Browse. Navigate to and select the Procedure Master Translator file you want to import, and click Open. The path and file name appear in the File to import text box.
5. If your Procedure Master Translator file contains a heading row with column names, select the First line of import data includes column headings check box.
6. Click Next to continue. The dialog box displays:
The number of codes the software found in the Excel spreadsheet
The name of each column, along with a sample of that column’s contents. (If your Procedure Master Translator has a heading row with column names, the software uses these names. Otherwise, it generates its own column names.)
A drop-down list where you will indicate how you want the software to map the contents of each column during the import.
7. From each drop-down list in the Mapping column, select the name of the PowerScribe 360 | Reporting database column to which the software is to map the corresponding Procedure Master Translator column. For any column in your Procedure Master Translator that is not to be processed, select Skip Column.
8. Click Next. In the next dialog box, you will select options that control how the software handles the procedure codes you are importing.
9. In the Procedure code identification group box, indicate how your facility identifies each unique procedure.
|
Select this option... |
If your facility uses... |
|
Use code to identify procedure codes |
A code alone |
|
Use description to identify procedure codes |
A description alone |
|
Use code and (if fails) description to identify procedure codes |
A combination of a code and a description |
10. In the Unmapped procedure code action group box, indicate what you want the software to do if it finds a clinical code in your Procedure Master Translator that is not in the database. This happens if you enter an invalid code or leave the ‘link’ column blank.
Select Create new procedure code if you want the software to create a new row in the database without the clinical code. In this case, although your facility’s procedure code will be in the database, you will not be able to use it in the PowerScribe 360 | Reporting system until you either manually map it to a procedure code or import a Procedure Master Translator that contains a mapping for it.
Select Do nothing, log procedure details if you want the software to skip the unmapped code. You will be able to view an error log after the import.
11. In the Update Actions group box, indicate the action you want the software to take during the import:
|
Select this option... |
If you want to... |
|
Update procedure code data |
Replace the existing procedure code mappings with the new mappings. You will use this option in most cases. This option is available only if you selected Use code to identify procedure codes in Step 9. |
|
Clear existing procedure code mapping before import |
Remove all mappings of procedure codes to clinical codes before importing the new mappings. CAUTION: In most cases you should not use this option. It is unlikely you will need to clear the existing mappings except in unusual circumstances, such as when you are replacing an entire RIS. |
|
Clear existing section mapping before import |
Remove all mappings of procedure codes to section codes and clinical codes before importing the new mappings |
12. Click Import. The system imports the data from your Procedure Master Translator into the database. When it has finished, it displays a report. If errors occurred during the import, the number of errors is shown. Click the View link to see the errors. The error list shows the error/warning message and the row on which the error occurred.
13. When finished, click Close.