Logbook Structure

20 02 2009

The Logbook is a lot more extensive than when I started, so I thought it would be useful to re-document the Query Structure.  I started with a simple structure, and have extended it since for Query naming:

  • Diagnostic Angiography: d
  • PCI / Intervention: p
  • Echocardiography: u
  • DCCV: e
  • Pericardiocentesis: c
  • Basic Investigations: b
  • Pacing & Devices: r

The other naming criteria are unchanged, and are generally self-evident.


Basic Investigations Logbook

20 02 2009

The latest logbook (BasicBD15.odb) can be considered a Beta test version.

Everything is complete, I just need to give it a bit of time to ensure that it works appropriately.  If any bugs or flaws are found, just reply with comments here.

I will be transferring my genuine data to it and giving it a proper trial over the next few weeks to ensure it behaves as expected.

Future additions may occur for non-invasive imaging or GUCH follow-up Logbooks, if I feel these features would be useful.

Echocardiography added…

17 02 2009

The logbook is now fully functional (I think).

The Basic Investigations is yet to be done, but the important specialist procedures are now included as planned:

  • Angiography / PCI
  • Pacing / Devices
  • Pericardiocentesis
  • Echocardiography
  • DC Cardioversion

All the various Data Entry and RITA / ARCP Summary forms appear to work correctly.

I’ll get started on the Basic Investigations section soon.  After which, I’ll take a few more screenshots and upload PDFs of example Summary forms.  Perhaps I’ll include a How-to use the logbook section on this website if there is enough interest from other users.

It is called BasicDB11.odb at the usual Download location (password avaialble on Downloads page).

DCCV Logbook uploaded

16 02 2009

Managed to get the DCCV Logbook done too.

It just required a lot of copy & paste from the Pericardiocentesis one, with a few SQL edits, as previously.

The relevant queries all start with “e” for Electricity; not good planning, since I now need to find an alternative for Echocardiography!

I’ve uploaded it to drop.io again as DccvDB5.odb – it includes all the previous logbooks in the one file.

Next up, the Echocardiography Logbook, which will be pretty basic, so shouldn’t take too long.

Pericardiocentesis done…

15 02 2009

Moving forwards again :)

Found a minor error in the Pacing Logbook, which I have now fixed.  The Primary Key was not set to Autonumber.

Having sorted that, I’ve managed to finish the Pericardiocentesis Logbook too.  Not had much opportunity to experiment with it, so testers are welcome.

Just grab the PericardioDB7 file from drop.io (see the Downloads page for details).  It includes the Angiography and Pacing logs too.

I think the next task will be DCCV Logbook.  Watch this space…

Working on the rest…

14 02 2009

I am a bit busy with regular work at the moment, but will be looking to get the rest of the database up and running over the next few weeks.

Plans are in place for:

  • Pericardiocentesis
  • DC Cardioversions
  • Basic Investigations (inc ETT, 24hr-ECG, Tilt-Table, 24hr-BP)
  • Echocardiograms (for RITA / ARCP  rather than BSE)

If you have any further ideas – let me know in the comments.  Once these are done, there is no reason why other procedures shouldn’t be included too.  I anticipate including a Myocardial Perfusion Imaging and / or Cardiac MRI would be useful, but have not decided what details are necessary for them yet (and I have no personal need for them yet).