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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- university of minnesota college of education
- university of minnesota school of social work
- wharton school of the university of pennsylvania
- cost of university of scranton
- performance review quality of work sample
- university of minnesota school of education
- review systems of equations worksheet
- university of scranton cost of attendance
- university of south florida college of medicine
- movie review end of sentence
- 360 review examples of strengths
- city of aberdeen sd jobs