The Upload Tool allows you to update multiple exam name mappings at one time. You can also use the tool to export all exam mappings to an Excel file which you can then edit and upload back into the application to update your exam name mappings. Only the records you modify are changed.
The tool may be used for mapping CT exam names to RPIDs and for mapping Fluoro exam names to ACR Common Procedure IDs.
Use the following steps to complete the process:
Click the Export All to Excel button to download all mapping data for your facility into an Excel file. The downloaded Excel file has the naming convention DIR_<your NRDR facility ID>_ExamName-Mappings_<date of download>.xlsx. You may want to make a copy of the downloaded file as a backup. The Excel file contains four columns:
RPID or Predicate values (for CT) or ACRCommonID (for Fluoro), and
The RecordID is the unique key for each exam-mapping record.
DO NOT change or delete any of the RecordIDs; otherwise the system will not be able to locate the exam mapping record or may perform an incorrect mapping.
Both the Study Description and Status columns are displayed as a reference. You do not need to make changes to them; the tool will change the status accordingly in the database after the upload.
To map Not Tagged exams, enter the RPID code (for example RPID145) in the RPID or Predicate values column for the corresponding study. For Fluoro, enter the Common Procedure ID number.
Note: You are not required to enter the Shortname or predicate values for the RPID or Common Procedure ID.
If you need to remap a Tagging Completed mapping, replace the current RPID/Common Procedure ID with a new one.
To change the mapping of a study to Not Tagged, remove the current RPID/Common Procedure ID for that study, so that the column is blank.
To mark an exam as Unwanted for CT , enter RPID-UW in the RPID or Predicate values column for that study. Alternatively, you may use RPID00 to mark an exam as Guidance. To mark an exam as unwanted for Fluoro, enter Common ID 9999999 Common Name FLUOR.Unwanted or Common ID 9999998 Common Name INV-FLUOR.Unwanted as appropriate. To mark an exam as unwanted for Digital Radiography enter Common ID 9999997 Common Name XRAY.Unwanted.
Note: Using either RPID-UW (Unwanted), RPID00 (Guidance), 9999999 (FLUOR.Unwanted), 9999998 (INV-FLUOR.Unwanted), or 9999997 (XRAY.Unwanted) prevents the exam from being included in quarterly aggregate feedback reports.
When you are done, save the file to your hard drive. Go back to the mapping tool and click the Choose File button and search for the Excel file you just updated. Select the file, click Open, and then click the Upload button.
The system asks if you want to proceed; click OK to start the upload.
The upload tool validates the changes you entered in the Excel file. If incorrect RPIDs are found, the tool displays a window to show the upload result and the invalid rows. The number of successfully tagged exams and invalid rows are summarized at the top of the window. Details for invalid records are displayed below the summary counts.
Note: A record may be invalid because it has an invalid RPID or Common Procedure ID number (see above).
If you know the correct RPID or predicate values you may correct them in this window and click Update Invalid Record to complete the update.
Click the red X to close the window.