DATABASE-REVIEW by sdaferv

VIEWS: 18 PAGES: 10

More Info
									Institute of Applied Health Sciences University of Aberdeen

DATABASE REVIEW

Grampian University Hospitals NHS Trust

THE ABERDEEN BREAST CANCER DATABASE

The Aberdeen Breast Cancer Database Page 1

April 2001 DATABASE CODE: ABC

Institute of Applied Health Sciences University of Aberdeen

Contents
Contents Introduction
History Overview of Database

2 3
3 3

Database Structure Main Table Summary
CRN - Basic Patient Data tblStatus / tblStatus_2 - Current Patient Status tblbiochem / tblbiochem_2 - Biochemistry Results tblCFindings / tblCFindings_2 - Clinical Findings from First Contact tblChemo / tblChemo_2 - Chemotherapy Follow-up tblDSmetast / tblDSmetast_2 - Metastases Information tblEpidemiology / tblEpidemiology_2 - Epidemiology from First Contact tblfoll_surgery / tblfoll_surgery_2

4 5
5 5 5 5 6 6 6 6 6 7 7 7 7 7 8 8 8 9

- Surgery Details from Follow-up

tblhormther / tblhormther_2 - Details of Hormone Therapy Courses tblOtherapies / tblOtherapies_2 - Initial Chemotherapy Hormone Therapy tblPathol / tblPathol_2 - Details of Initial Contact Pathology Data tblRadioth/ tblRadioth_2 - Details of Initial Radiotherapy Treatment tblRad / tblRad_2 - Details of Investigations tblReferral / tblReferral_2 - Initial Patient Contact Information tblReview / tblReview_2 - Review Data tblscans / tblscans_2 - Details of Follow on Scans X-Rays tblsummary / tblsummary_2 - Treatment Summary tblsurgery/ tblsurgery_2 - Surgery Follow-up Details

Associated Publications

10

The Aberdeen Breast Cancer Database Page 2

April 2001 DATABASE CODE: ABC

Institute of Applied Health Sciences University of Aberdeen

Introduction
History The Aberdeen Breast Cancer Database was created on an ACCESS Database in 1999 and populated with data for all Grampian patients diagnosed with breast cancer between 1991 and 1995. The data had originally been recorded on Aberdeen Royal Infirmary’s Patient Records System (PRS). In the United Kingdom, breast cancer is the most common malignancy in women and the leading cause of death in women in their 40s. The purpose of the Aberdeen Breast Cancer Database was to maintain information on a group of patients over a 10 year follow-up period and assess the effectiveness of the various treatments given. The database holds current information for approximately 2500 patients and includes basic patient identification, referral details, epidemiology, family history, clinical findings, initial investigation and details on surgery, pathology, radiotherapy, hormone therapy and chemotherapy. No new patients have been added since 1995, but the initial set of patients are followed up regularly and the database updated as appropriate. Overview of Database The Aberdeen Breast Cancer Data is held on an ACCESS Relational Database on a Personal Computer (PC), within Aberdeen Royal Infirmary. The ACCESS database has been developed to allow data input using a form layout and selection buttons to perform simple queries and produce reports. There are no external links to any other systems and access is for single users only via a security password. Information on approximately 2,500 patients is held on the database amounting to approximately 25 Megabytes of storage across 53 relational database tables, 41 of which contain the basic data detailed in the Main Table Definitions Section and a further 12 tables used for reference. Apart from the patient registration details, all of the other tables are duplicated with _2 added to the second table name. The first set of tables contains Standard Backpack Information for patients diagnosed for the first time with breast cancer. The second set of tables contains details of patients previously diagnosed with breast cancer, who now present with a contralateral tumour. These patients are recorded with Standard Backpack Information in the first set of tables, corresponding to the first incidence of cancer in a particular breast, and also recorded in the second set of tables with the data corresponding to diagnosis of breast cancer in the other breast. All patients are followed up on a yearly basis and their details added to the database.

The Aberdeen Breast Cancer Database Page 3

April 2001 DATABASE CODE: ABC

Institute of Applied Health Sciences University of Aberdeen

Database Structure

EPIDEMIOLOGY

CRN

CLINICAL DATA CRN

BASIC PATIENT DATA

DRUGS CRN

CRN CRN

CRN

RADIOTHERAPY SCANS X-RAYS CRN

BIOCHEMISTRY

CRN

CHEMOTHERAPY CRN

HORMONE THERAPY

PATHOLOGY

SURGERY CRN

The Aberdeen Breast Cancer Database Page 4

April 2001 DATABASE CODE: ABC

Institute of Applied Health Sciences University of Aberdeen

Main Table Summary
CRN - Basic Patient Data       Unique Patient Identification Number Forename / Surname Patient Address, Postcode and Telephone Number Patient’s Sex Marital Status Date of Birth

tblStatus / tblStatus_2 - Current Patient Status    Unique Patient Identification Number Vital Status / Recurrence of Disease Status Date

tblbiochem / tblbiochem_2 - Biochemistry Results          Unique Patient Identification Number Date of result Alkaline phosphatase level Asparate aminotransferase level Gamma glutamyltransferase level Calcium level Haemoglobin level White Blood Cell count Platelet count

tblCFindings / tblCFindings_2 - Clinical Findings from First Contact      Unique Patient Identification Number Affected Side / Situation Vertical / Horizontal tumour size Tumour, Nodal and Metastasis Stage Details Metastases Details

The Aberdeen Breast Cancer Database Page 5

April 2001 DATABASE CODE: ABC

Institute of Applied Health Sciences University of Aberdeen
tblChemo / tblChemo_2 - Chemotherapy Follow-up     Unique Patient Identification Number Date of Follow-up Chemotherapy Treatment Drug Details

tblDSmetast / tblDSmetast_2 - Metastases Information     Unique Patient Identification Number Date of Record Creation Assessment of Metastasis Stage Metastases Details

tblEpidemiology / tblEpidemiology_2 - Epidemiology from First Contact       Unique Patient Identification Number Age at Menarche and at First and Last Pregnancy Menopausal Age, Menopausal Stage and Date of Last Period Family History of Breast Cancer and Relations Affected Family History of Non-Breast Cancer and Rrelations Affected Type of Hysterectomy / Age at Operation

tblfoll_surgery / tblfoll_surgery_2 - Surgery Details from Follow-up     Unique Patient Identification Number Date of Follow-up Information Breast / Axillary Surgery Treatment Code for Operative Procedure

tblhormther / tblhormther_2 - Details of Hormone Therapy Courses    Unique Patient Identification Number Date of Treatment Treatment Code for Hormone Therapy

The Aberdeen Breast Cancer Database Page 6

April 2001 DATABASE CODE: ABC

Institute of Applied Health Sciences University of Aberdeen
tblOtherapies / tblOtherapies_2 - Initial Chemotherapy Hormone Therapy          Unique Patient Identification Number Date of Hormone Treatment Adjuvant / Therapeutic Treatment Treatment Code for Hormone Therapy Type of Chemotherapy Date of Initial Chemotherapy / Date of Other Chemotherapy Date Contralateral Tumour Diagnosed Loco-regional Control at Death Breast Cancer Contribution to Death

tblPathol / tblPathol_2 - Details of Initial Contact Pathology Data        Unique Patient Identification Number Unique Pathology Identification Number Histology Details Axillary Nodes and Number of Nodes Involved / Removed Maximum Tumour Size and Tumour Grade Oestrogen and Progesterone Receptor Tumour Status and Value Human Epidermal Growth Factor Receptor- 2

tblRadioth/ tblRadioth_2 - Details of Initial Radiotherapy Treatment     Unique Patient Identification Number Codes for Radiotherapy Treatment Type Treatment Start Date, Site of Treatment and Dosage Boost Date, Duration and Dose

tblRad / tblRad_2 - Details of Investigations    Unique Patient Identification Number Date of Investigation Result of Chest and Skeletal X-Ray Examination

tblReferral / tblReferral_2 - Initial Patient Contact Information   Unique Patient Identification Number Patient’s date of birth / Age at referral

The Aberdeen Breast Cancer Database Page 7

April 2001 DATABASE CODE: ABC

Institute of Applied Health Sciences University of Aberdeen
       Postcode at referral Date of Referral Consultant / Hospital at Referral Radiotherapy Department Number and Radiotherapy Consultant Date of Anniversary of First Treatment Screen Detected Cancer Smoking Status

tblReview / tblReview_2 - Review Data            Unique Patient Identification Number Date of Review Tumour Present or Absent Primary site Nodes Present or Absent Skin / Breast Lymphoedema Brachial Plexopathy Metastasis Weight Treatment

tblscans / tblscans_2 - Details of Follow on Scans X-Rays     Unique Patient Identification Number Date of Follow-up Scans / X-Rays Bone Scan / Mammogram / Breast Ultrasound / Magnetic Resonance Imaging Results Fine Needle Aspiration

tblsummary / tblsummary_2 - Treatment Summary     Unique Patient Identification Number Date of Summary Drug Name / Prescribed Dose Course / Pulse Dates

The Aberdeen Breast Cancer Database Page 8

April 2001 DATABASE CODE: ABC

Institute of Applied Health Sciences University of Aberdeen
tblsurgery/ tblsurgery_2 - Surgery Follow-up Details      Unique Patient Identification Number Nature and Date of Follow-up for First Breast Procedure Axilla Details for First Date Nature and Date of Follow-up for Second Breast Procedure Axilla Details for Second Date

The Aberdeen Breast Cancer Database Page 9

April 2001 DATABASE CODE: ABC

Institute of Applied Health Sciences University of Aberdeen

Associated Publications
Johnstone AJ, Sarkar TK, Hussey JK. Primary hepatocellular carcinoma in a patient with breast carcinoma. Clin. Oncol. (Roy. Coll. Rad.) 1991, 3(3): 180-1 Heys SD, Sarkar TK, Ah-See AK, Eremin JM, Brittenden J, Eremin O. Multimodality treatment in the management of locally advanced breast cancer. J. Roy. Coll. Surg. Ed. 1993, 38(1): 9-15 Heys SD, Eremin J, Sarkar TK, Hutcheon AW, Ah-See AK, Eremin O. Role of multimodality therapy in the management of locally advanced breast cancer. J. Am Coll Surgeons 1994, 179(4): 493-504 Brittenden J, Heys SD, Miller I, Sarkar TK, Hutcheon AW, Needham G, Gilbert F, McKean M, AhSee AK, Eremin O. Dietary supplementation with L-arginine in patients with breast cancer (> 4 cm) receiving multimodality treatment: report of a feasibility study. Br. J. Cancer 1994, 69(5): 918-21 Heys SD, Ogston KN, Simpson WG, Walker LG, Hutcheon AW, Sarkar TK, Eremin O. Acute phase proteins in patients with large and locally advanced breast cancer treated with neoadjuvant chemotherapy: response and survival. Int. J. Oncol. 1998, 13(3): 589-94 Eltahir A, Heys SD, Hutcheon AW, Sarkar TK, Smith I, Walker LG, Ah-See AK, Eremin O. Treatment of large and locally advanced breast cancers using neoadjuvant chemotherapy. Am. J. Surg. 1998, 175(2): 127-32 Walker LG, Walker MB, Ogston K, Heys SD, Ah-See AK, Miller ID, Hutcheon AW, Sarkar TK, Eremin O. Psychological, clinical and pathological effects of relaxation training and guided imagery during primary chemotherapy. Br. J. Cancer 1999, 80(1-2): 262-8 Walker LG, Heys SD, Walker MB, Ogston K, Miller ID, Hutcheon AW, Sarkar TK, Ah-See AK, Eremin O. Psychological Factors can Predict the Response to Primary Chemotherapy in Patients with Locally Advanced Breast Cancer. Eur. J. Cancer 1999, 35:1783-8

The Aberdeen Breast Cancer Database Page 10

April 2001 DATABASE CODE: ABC


								
To top