Data collection for PCI: How it works

Mechanisms for Collection of PCI Data

Section detailing the mechanisms in place for collection of PCI data.

The original BCIS-CCAD dataset for PCI was introduced in 2002 and has since been updated on several occasions.  Details are on the ‘BCIS-CCAD datasets and history’ page. There are several ways in which units can collect these data.

Basic set-up

All units need to have a copy of Lotus Notes software installed on a local PC. This is the mechanism by which data are sent centrally in a secure fashion to CCAD, and is available free of charge from CCAD.

1. Direct data entry

Patient and PCI data can be entered directly into this Lotus Notes database (option 1 in figure). Each trust is given one free licence per cardiac audit, though additional licences can be purchase from IBM for approximately £90 each.

2. Data entry via dedicated database program:

There are several advantages to this approach (option 2 in figure). The program can be developed under your control and therefore be used to collect any other data you might require and to create customised reports and analyses.

The database can be networked to allow access from any networked computer and facilitate the use of hospital Trust based back-up systems and security policies. In addition it can be linked to hospital PAS systems, lab results servers and other databases to allow auto-population of many fields.

Any database used for this purpose must be able to produce an export file that can be sent to Lotus Notes for data upload. There are strict specifications for this file, whose format is a comma separated values (csv) file. The specification can be downloaded from the BCIS-CCAD datasets and history page.

 

2.1 BCIS PCI Database

I have designed a PCI database program using Microsoft Access. This is available for free download on the ‘Current PCI database’ page. In addition to providing procedure reports and a variety of analyses, it creates a commas separated values (csv) file in the format required for upload into your local copy of the Lotus Notes program.  Lotus Notes then deals with encryption and transmission to the central CCAD servers, and gives you access to these data and centrally programmed analyses.

2.2 Commercial databases

There are a number of commercially available database systems. These also all work by extracting the required data to create a csv file in the appropriate format for upload to the Lotus Notes application on your local PC.

3. Web Browser

There is a web based data entry system under development that will allow both BCIS and MINAP data to be entered into the Lotus Notes servers directly, and so could be used with any computer with a web browser. For details contact CCAD.

 

Peter Ludman 2013

Current PCI database

Capturing details about percutaneous coronary intervention procedures

Current PCI database

CCAD datasets and history

Current PCI Dataset

CCAD datasets and history