Forgot your password?
A database designed to capture details about percutaneous coronary intervention procedures.
This PCI Database is designed to capture details about percutaneous coronary interventional procedures. Procedure reports and GP letters can be created, the data can be analysed within the database, or exported for analysis. This database is designed to collect the dataset agreed by the British Cardiovascular Intervention Society (BCIS) / National Institute for Cardiovascular Outcomes Research (NICOR). It can create the comma separated values (csv) file required for upload data to the NICOR servers. I have written the database in Access 2002. Version 19.0 is the latest and incorporates library updates (as 2021)
The latest version of the database below is version 19.0. I suggest that anyone who wants to start from scratch using this database starts with version 19.0 The three files required are available for download here:
For earlier versions of the database:
May 2019 Menu Options update
To incorporate the new library options introduced in May 2019, 4 tables in the database need to be replaced with new versions. Instructions to do this are in this file.
The file containing those tables can be downloaded at this link (it will need to be unzipped once downloaded) BCIS database updated tables
This database is not locked so the code can be explored and modified if necessary (see Release Notes ‘getting inside the database’). You can ask your IT department to set up a link between this database and your local hospital Patient Administration System, so that patient demographics, NHS numbers etc. do not have to be entered manually. A link to the lab results server is also very helpful.
The database is designed so that most of the data is entered during and at the end of a PCI procedure, and a procedure report can be printed for the patient notes at that stage. A final set of data is entered after patient discharge.
The data can be analysed using the queries I have written, and in addition the full dataset (excluding sub-tables) can be exported to Microsoft Excel to be analysed elsewhere. In addition once the data are uploaded to NICOR (via the NCAP web site), there is a suite of tools to analyse the live data, with National comparisons available.
By Peter F Ludman, BCIS Audit Lead