DATABASE REVIEW - University of Aberdeen



DATABASE REVIEW

Department of General Practice

& Primary Care

NHS Trust

CORONARY HEART DISEASE

RISK ASSESSMENT DATABASE

Contents

Introduction 3

History 3

Overview of Database 3

Database Structure 4

Main Table Definitions 5

CHD Risk Assessment Data for Patients Diagnosed with CHD 5

Associated Publications 6

Introduction

History

The Coronary Heart Disease Risk Assessment database, funded by the Primary Care Alliance, was created on an Access Database in 1997 and populated with data for Grampian patients under 65 years of age, diagnosed with Coronary Heart Disease (CHD). The data was initially recorded by GPs on CHD Forms and entered into a single Microsoft Access database table for calculating Dundee Risk and Rank Scores, based on blood pressure, smoking habit, cholesterol and age/sex. This information is fed back to the GP Practices participating in the project.

Overview of Database

The Coronary Care Audit database is held on an Access Relational Database on a Personal Computer (PC), located in the David Anderson Building, within the Aberdeen Royal Infirmary complex. The Access database has been developed to allow data input directly to a main table with the facility to produce reports for the CHD Task Group and individual risk assessment reports for participating GP Practices. There are no external links to any other systems and access is for a single user only.

Information on approximately 4,300 patients is held on the database amounting to approximately 9 Megabytes of storage on one relational database table, which contains the basic data detailed in the Main Table Definitions Section. Tables are also used for expanding coded information and calculating Risk Scores.

The information held covers primary diagnosis of CHD, co-morbidity, baseline measurements of height, weight, blood pressure, cholesterol, smoking status and prescribed drugs. Patients are recalled on a regular basis and their current risk factor compared to their baseline risk factor. Currently, a maximum of 5 recalls are recorded.

Database Structure

| | | | | |

| | | | | |

| | | | | | |

| | | | | | |

| | | | | |

| | |CORONARY HEART | | |

| | |DISEASE | | |

| | | |DATA | | | |



Main Table Definitions

CHD Risk Assessment Data for Patients Diagnosed with CHD

Community Health Index Number

Date of Birth / Sex

Age at Diagnosis

Occupation

Practice and GP Code

Recall Sequence

Myocardial Infarction Code

Angina Code

Coronary Artery Bypass Grafting Code

Angioplasts Code

Hypertension Code

Cerebrovascular Accident Code

Hyperlipidaemia Code

Renal Code

Diabetes Code

Thyroid Code

Family History of Ischaemic Heart Disease

Cholesterol Details

Blood Pressure

Height / Weight / BMI

Alcohol Consumption

Exercise Level Measurement

Smoking Details

Left Ventricular Hypertrophy Established Code

Indication of Echocardiogram Record

Medication Given

Baseline Risk and Rank of coronary heart disease

Associated Publications

Maitland JM, Reid J, Taylor RJ.

Two stage audit of cerebrovascular and coronary heart disease risk factor recording: the effect of case finding and screening programmes.

British Journal of General Practice. 1991, 41(345): 144-6

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download