Difference between revisions of "Single Patient Identifier"

From EHS Help
Jump to: navigation, search
m
m
Line 19: Line 19:
 
=== Installation ===
 
=== Installation ===
  
The SPM installation file is available here: [[https://www.evolutionhealthcaresystems.co.uk/download/spm/]]
+
The SPM installation file is available here: [https://www.evolutionhealthcaresystems.co.uk/download/spm evolutionhealthcaresystems.co.uk/download/spm/]
  
 
To upgrade, install over-the-top of an existing SPM installation.
 
To upgrade, install over-the-top of an existing SPM installation.

Revision as of 09:35, 20 August 2019

Program Overview

  • Project: 179 MFT Single Patient Identifier
  • Specification: v1.1
  • Specification Date: 10-Dec-2018

The Aquila Substitution Program Module (SPM) is a Windows 32-bit application.

It provides functionality to import a mapping file; produce a legacy identifier report and perform identifier substitution.

** The SPM imports a mapping file and produces a summary and execution log files. It is strongly recommended that all file locations are on the local server and not on a network to avoid performance degredation.

If necessary copy the files to, and from, the required locations outside of the SPM program.

Installation

The SPM installation file is available here: evolutionhealthcaresystems.co.uk/download/spm/

To upgrade, install over-the-top of an existing SPM installation.

You will need to enter the connection details of an existing AquilaCRS SQL Server database.

Rollback Procedure

During testing and in the event of a problem, the roll-back procedure is to use SQL Server tools to restore the database to a point in time prior to the start of the process.

Therefore please ensure you have backed up the database prior to running the substitution.

Settings

The SPM settings are stored in the logged in users "local app data" folder, under the sub-folder AquilaSPM.

SPI Settings.png

The database connection information should be correct, but you can alter it here.

Add the output folders for the Summary Log and Execution Log. Both locations can be the same folder as the filenames are generated automatically. **

The creation of an execution log file is optional and can be turned off via the Output Execution Log option. (An execution log table is always created, so you have the option of outputting the execution log using SQL Server tools at a later point).

Additional settings can be altered if necessary, i.e. CSV separator, system code & name.

Press Save Settings when done. If the database connection has changed, a new connection will be made at this point.

Import Mapping File

Spi mapping import.png

Switch to the Mapping File tab. Press the Import button and select the mapping file **

The progress of the import will be shown at the foot of the window, & messages will appear in the log window. (information is posted every 50k records imported).

You can press "Cancel" at any point, this will roll-back all changes and the database will be returned to the state prior to the Import button being activated.

Existing mapping file records are deleted prior to import.

A list of previous mapping file imports can be seen on this page also.

Legacy Identifiers

Switch to the Legacy IDs tab and press the Legacy IDs button.

Progress will be shown at the foot of the screen and in the log window.

A file will be produced in the Execution Log Folder ** called `LEGACY_systemcode_yyyy-mm-dd_hhnnss.csv`

If a mapping file has been imported already, then the Legacy ID report will attempt to verify if a non-RM2 number is in fact an RM2 number missing it's prefix, by looking it up in the mapping file and comparing patient attributes.

If there is no mapping file imported, then the legacy report will consists of all entries that do not start with "RM2". For greater accuracy in this report, it is recommended that the mapping file be imported where possible.

Identifier Substitution

To initiate the identifier substitution, switch to the Identifier Substitution tab and press the ID Sub button.

Spi substitution.png

Once completed, the log files will be created in the folders** specified in the initial setup. The execution log creation is conditional on that option being selected in the settings page.

Utlities

Clean Up

This option removes all SPM related tables from the AquilaCRS database. To be used when the substitution has taken place and been verified and accepted by the burn unit.