This program has been developed to extract data from the INPS Vision medical system where patients' are on specific Repeat Master Prescription drug groups (known as BNF Action Groups) and to confirm that certain tests results have been carried out within a specific time period.

Important Note:
Currently Smart Blood Monitoring can only be run in a local server environment due to a Microsoft OLE DB Provider for Visual FoxPro (VfpOleDB.dll) which needs to be registered to access Visual FoxPro databases and tables in Vision.

Therefore until further notice practices' on remote server solutions (VES, WES, Bureau, CCA, etc..) will not be able to run this application as INPS do not currently register VfpOleDB.dll by default.

Smart Blood Monitoring outputs results in either PDF format or in a Microsoft Excel spreadsheet.

The Excel spreadsheet will include the search criteria together with patient names and address details for mail merge purposes.

Example

The pdf report will only display the Vision patient identifier, which is searchable in Vision using the Vision Identifier in the patient search drop down box.

Example

Search results are shown as Y or N to distinguish whether the test results have been carried out within the specified date period or not.

The drugs groups and test results are detailed in the search criteria below.

Using Smart Blood Monitoring

On the front screen you may select a single action group to search or all action groups.

If selecting a single action group the test results will automatically change to the relevant tests for that particular drug action group. Additionally, a single test may also be selected to search on as well (shown above).

The date period will automatically default to the correct time range for those particular test results. However, this may be changed using the From: and To: date fields or refer to Date Fields below for further information on entering dates.

Once the above information has been selected click either Print PDF or Microsoft Excel to initiate the search and the report output type.

Search Criteria:

The following search sequence is used to extract the data from Vision 3

Overview

1.    Search all active patients with a registration status of Applied, Permanent and GP with Special Interest

AND

2.    Only active repeat therapy data mentioned below using BNF Action Group

AND

3.    Test Results mentioned below have been recorded within the specific time period set by User

Drug Action Groups:

Only active repeat masters in the following BNF action groups are included in the search criteria:

Test Results & Time Periods:

% = includes all child levels and synonyms of the Read code

The criteria with regards to the default time period shown above will be used only if the user selects “All Action Groups” and “All Test Results” from the drop down lists.

This will be calculated using the current date in the To Date field and automatically enter a date period minus one year from that date.

The time period is calculated using the To Date: and searches back either yearly or within last 3 months for Lithium test results.

Date fields

When entering a date, you may type in DD/MM/YYYY format or select the calendar button.

Alternatively, you can use a date formula as in Vision:

• Type: T (for today’s date)

• Type: T-1y (for back one year) or T-12m (back 12 months)

You may use:

D for days, W for Weeks, M for months and Y for Years

Note: you may not search ahead of time, as results cannot be added in the future within Vision, therefore + is not valid.

Installation

Download and install the Microsoft OLE DB Provider for Visual FoxPro (VfpOleDB.dll)

1. Download Smart Blood Monitoring to a folder

2. Double click the BloodMonitor.exe file to extract the contents into a folder (or accept the default folder location of P:\Blood Monitoring).

   File Contents:

   • SmartBM.exe

   • BM_VDE.mdb

   • SMARTBM.chm

   • Register.dat

3. Double-click SmartBM.exe to start the Smart Blood Monitoring program

Note:

Smart Blood monitoring is installed with a default output location of P:\Blood Monitoring\Results\SmartBM [date] [time].xls

If you wish to amend the output location click the setup button on the front screen