DATABASE REVIEW by sofiaie

VIEWS: 3 PAGES: 7

									Institute of Applied Health Sciences University of Aberdeen

DATABASE REVIEW

Medicine Assessment Research Unit Grampian University Hospitals NHS Trust

LUNG CANCER DATABASE

Lung Cancer Database Page 1

March 2004 DATABASE CODE: LCD

Institute of Applied Health Sciences University of Aberdeen

Contents
Contents Introduction History Overview of Database Database Structure Main Table Summary PATIENT HISTORY – Patient History SUBSTANCE HISTORY – Substance History OCCUPATION HISTORY – Occupation History DRUG HISTORY – Drug / Medication History (at time of presentation) CHEMOTHERAPY HISTORY – Chemotherapy History RADIOTHERAPY HISTORY – Radiotherapy History MALIGNANCY HISTORY – Malignancy History FAMILY HISTORY – Family History of Malignancy SYMPTOM HISTORY – Symptom History INVESTIGATION HISTORY – Investigation History TISSUE DIAGNOSIS– Tissue Diagnosis Associated Publications 2 3 3 3 4 5 5 5 5 5 5 6 6 6 6 6 6 7

Lung Cancer Database Page 2

March 2004 DATABASE CODE: LCD

Institute of Applied Health Sciences University of Aberdeen

Introduction

History The Lung Cancer database was created in 2002 to record clinical information on approximately 1400 Grampian patients investigated for lung cancer during the period April 2000 to March 2002. Pathological data for these patients was downloaded from the APEX laboratory computer together with basic patient identification. Additional clinical and epidemiological information was extracted from the hospital notes for the patients and entered into the Lung Cancer database via customised data entry screens.

Overview of Database Lung cancer data is held in an Access database located on a confidential server on the University network. Information on approximately 1400 patients is held on the research database across 11 record types which are detailed in the Main Table Definitions Section.

Lung Cancer Database Page 3

March 2004 DATABASE CODE: LCD

Institute of Applied Health Sciences University of Aberdeen

Database Structure

OCCUPATION

PAS NO

PATIENT HISTORY

PAS NO

FAMILY HISTORY

PAS NO

PAS NO

MALIGNANCY HISTORY

SYMPTOM HISTORY

SUBSTANCE HISTORY

INVESTIGATION HISTORY

PAS NO

PAS NO

TISSUE DIAGNOSIS

PAS NO

CHEMOTHERAPY HISTORY

PAS NO

RADIOTHERAPY HISTORY

DRUG HISTORY

Lung Cancer Database Page 4

March 2004 DATABASE CODE: LCD

Institute of Applied Health Sciences University of Aberdeen

Main Table Summary
PATIENT HISTORY – Patient History        PAS Number / CHI Number Name / Date of Birth / Sex Date & Cause of Death Smoking – Status / Number of cigarettes/cigars/pipes smoked / Duration Alcohol – Status / Number of units Treatment – Chemotherapy / Radiotherapy Respiratory History – Asthma / Brocheiectasis / COPD / Interstitial lung disease / Pulmonary embolism infarction / Pleural plaques / Oropharyngolaryngeal disease / Pneumonia / Chest infection / Other History of Malignancy – Previous malignancy / Site / Family history of malignancy Diagnosis of Lung Cancer Tumour – Class / Histological subtype Resection – Date / Pathology report number / Site / Size of tumour / Presence of bronchoalveolar carcinoma or AHH / Clearance of tumour margins Tumour Staging – T / N / M / Stage

    

SUBSTANCE HISTORY – Substance History   PAS Number Type of Substance Abuse

OCCUPATION HISTORY – Occupation History  PAS Number  Occupation

DRUG HISTORY – Drug / Medication History (at time of presentation)  PAS Number   Name of Drug Route of Administration / Dose / Frequency / Duration

CHEMOTHERAPY HISTORY – Chemotherapy History  PAS Number  Name of Chemotherpeutic Drug

Lung Cancer Database Page 5

March 2004 DATABASE CODE: LCD

Institute of Applied Health Sciences University of Aberdeen
  Start & End Date Dose / Route / Number of Cycles

RADIOTHERAPY HISTORY – Radiotherapy History  PAS Number   Radiotherapy site / Total Dose Start & End Date

MALIGNANCY HISTORY – Malignancy History  PAS Number  Location of Previous Malignancy – Bladder / Bone / Brain / Breast / GI tract / Leukaemia / Lung / Lymphoma / Ovary / Prostate / Renal / Skin / Uterus

FAMILY HISTORY – Family History of Malignancy  PAS Number   Relative / Site of Malignancy Age at Onset / Age at Death

SYMPTOM HISTORY – Symptom History  PAS Number  Symptom

INVESTIGATION HISTORY – Investigation History  PAS Number  Investigation – Biopsy / Bronchoscopy / Brushings / Chest X-Ray / CT scan / Fine needle aspirate / Sputum cytology / Washings

TISSUE DIAGNOSIS– Tissue Diagnosis  PAS Number / Hospital Unit Number    Biopsy Number / Cytology Number / Full Specimen Number Request Date Results of Analysis – Sputum / Brushings / Washings / Biopsy / FNA

Lung Cancer Database Page 6

March 2004 DATABASE CODE: LCD

Institute of Applied Health Sciences University of Aberdeen

Associated Publications
None

Lung Cancer Database Page 7

March 2004 DATABASE CODE: LCD


								
To top