Factsheet

Quest Interpreter Powerpoint zip Demo (right click & save)	A complete MIQUEST interpreter which uses transfer files generated by the host clinical system. Used by Torex Premiere, Seetec, CHIME, Protechnic (Exeter systems), Healthysoft, TCR.
Quest Browser Powerpoint zip Demo (right click & save)	A MIQUEST tool which allows practices to download ready-made query libraries from the web, issues them for use and displays the responses as graphs, reports etc. Uses in-built report objects to display results of audits and incentive schemes. Currently installed into ALL practices in Nottinghamshire.
Quest Central Powerpoint zip Demo (right click & save)	A centrally based MIQUEST tool which allows a PCT to receive responses electronically. Incoming data is aggregated or stored in a repository for further processing by the on-board reporting tools. Now purchased for ALL PCTs in Nottinghamshire.

Known issues with Data Extraction

The data extraction routine provided by Torex sometimes fails to extract all the history records from Premiere. They suggest it may be related to unmapped drugs, and recommend asking their support desk for the DRUG MAPPING UTILITY. In the meantime, for practices experiencing difficulty we have come up with a simple process that can establish if the extract is 'sensible'.

1. Download a copy of PFE32.ZIP from this site (right click on this link and choose 'save as' and save to your desktop). PFE32 is like notepad, but can open very large files. You will need to unzip it to use it. If you don't have WINZIP then you can download it from www.winzip.com

2. Run the extract on Premiere and locate the extracted files. There should be four of them in the \S4 directory. They are called PATIENTS.CSV, JOURNALS.CSV, REFERRAL.CSV and HCP.CSV. The journals.csv file is the one that contains the read coded history, and which sometimes contains less data than it should. The tendency seems to be for whole blocks of data to be missing.

3. Run PFE32 and open the journals.csv file. As it is opened a progress bar will show on the bottom of the PFE window, and a count of the records read will be shown. When it has finished reading the records make a note of the number of records shown.

4. Use the magnifying glass icon to open a search window and type in ~44P (this would search for any cholesterol results). Remember to search both up and down the file. If the practice is recording cholesterol results, and you don't find any with this search, then you know the extract hasn't worked properly. If you go ahead and import the files into QUEST, you will get zero returned when running queries searching for cholesterol.

5. You can search for any read codes by typing ~xxxxx eg ~246 for BP, ~G3 for heart disease. REMEMBER TO SEARCH TWICE (up and down).

6. Finally, if you are happy with the search results, run QUEST and import the files. QUEST keeps a log of the number of records imported, which you can compare with the number of records shown by PFE when you opened the file. They should be the same (this indicates that QUEST read ALL the records in).

7. IMPORTANT! QUEST deletes the transfer files when it has finished importing, so make a copy of them somewhere if you want to check anything later on. REMEMBER, QUEST can only report on the data it imports. If the information is not in the transfer files, then it won't be reported by QUEST.