Tuesday, 12 May 2009

BAUS Database overview

The database contains two tables titled “operation” and “follow up” that respectively gather the information from the two forms: “Baseline” and “Follow up”.

The list below describes the different fields from the tables and how they relate to the form.

“Operation” table (“Baseline” form).

- consultant : Consultant Number

- presentation : Presentation (1=”Via screening or Case Finding”; 2=”LUTS”; 3=”Other”)

- otherpresentation

- previousturp : Previous TURP (1=”Yes”; 2=”No”)

- ctstage : Clinical T

- cnstage : Clinical N

- cmstage : Clinical M

- psa: Pre-Operative PSA

- gleason1 : Biopsy Gleason Score 1

- gleason2 : Biopsy Gleason Score 2

- preoppottency : Pre-Operative Potency (1=”Impotent”; 2=”Partially Potent”; 3=”Fully Potent”)

- preopcontinence : Pre-Operative Continence (1=”Complete”; 2=”Minor stress leakage”; 3=”1 Pad per day”; 4=”>1 Pad per day”; 5=”Appliance”)

- opdate : Date of Operation

- surgeongrade : Grade of Main Operative Surgeon (1=”Consultant”; 2=”SpR”; 3=”Other”)

- trainingop : Supervised Training Operation (1=”Yes”; 2=”No”)

- asa : ASA Grade (1=”Grade 1”; 2=”Grade 2”; 3=”Grade 3”; 4=”Grade 4”; 5=”Grade 5”;)

- nervesparing : Nerve Sparing (1=”Bilateral”; 2=”Unilateral”; 3=”none”)

- retropubic : Retropubic/Perineal (1=”Retropubic”; 2=”Perineal”; 3=”Other”)

- laparoscopic : Laparoscopic (1=”Yes”; 2=”No”)

- converted : Converted (1=”Yes”; 2=”No”)

- conversionreason : If Converted, reason

- lnd : Lymph Node Dissection (1=”Yes”; 2=”No”)

- durationofop : Duration of Operation

- bloodtransfused : Number of Units Blood transfused

- bloodloss : Measured blood loss

- nointraopcomps : Intra operative Complications – No (1=”No”; 2=”Yes”)

- intraopcomps : Intra operative Complications – or specify

- nopostopcomps : Post operative Complications – No (1=”No”; 2=”Yes”)

- postopcomps : Post operative Complications – or specify

- significancecomplication : Significance of complication (1=”No action required”; 2=”Contributed to death”; 3=”Delayed discharged”; 4=”Medical treatment”; 5=”Required surgery”)

- dischargedate : Date of Discharge

- deathdate : Date of Death

- deathcause : Cause of Death

“Follow up” table (“Follow up” form).

- Datefu : Date of Follow-up

- psa : PSA

- psasmall : PSA < 0="”No”;" 1="">

- postoppotency : Post-Operative Potency (1=”Impotent”; 2=”Partially Potent”; 3=”Fully Potent”)

- postopcontinence : Post-Operative Continence (1=”Complete”; 2=”Minor stress leakage”; 3=”1 Pad per day”; 4=”>1 Pad per day”; 5=”Appliance”)

Section Q7: Intervention / Adjuvant Treatment

- nointervention : None (1=”checked”)

- dxt : DXT (1=”checked”)

- hormonetherapy : Hormone therapy (1=”checked”)

- cystoscopy : Cystoscopy (1=”checked”)

- urethraldilatation : Urethral dilatation (1=”checked”)

- otherint : Other (1=”checked”)

- otherintervention : specify

Section Q8: Late Complications

- nolatecomps : None (1=”checked”)

- recurrentuti : Recurrent UTI (1=”checked”)

- anaststricture : Anastamotic Stricture (1=”checked”)

- urethralstricture : Urethral stricture (1=”checked”)

- dvt : DVT (1=”checked”)

- testpain: Testicular pain (1=”checked”)

- hernia : Hernia (1=”checked”)

- othercomp : Other (1=”checked”)

- otherlatecomps : Specify

- lni : Lymph Nodes - Number sampled

- lniyes : Lymph Nodes - Number positive / containing cancer

- gleason1 : Surgical Specimen Gleason score 1

- gleason2 : Surgical Specimen Gleason score 2

- seminalvesicalinvolvement : Seminal Vesicle Involvement (1=”Yes”; 2=”No”)

- positivemargins : Positive Margins (1=”Yes”; 2=”No”)

- ptstage : Pathological T

- pnstage : Pathological N

- pmstage : Pathological M

- sparen4 : Weight of gland

- sparet1 : Size of gland

- status : Current status (1=” Alive with no evidence of prostate cancer”; 2=” Alive with local recurrence of prostate cancer”; 3=” Alive with lymph node involvement by prostate cancer”; 4=” Alive with metastatic disease”; 5=”Dead”)

- datelocalrecurrence : Date of diagnosis of local recurrence

- datelninvolvement : Date of diagnosis of lymph node involvement

- datemetastases : Date of diagnosis of metastatic disease

- deathdate : Date of death

- deathcause : Cause of Death (1=”Due to Cancer”; 2=”Non Cancer causes”; 3=”Not Known”)

NB: The “follow-up” table in the database also contains fields that are not related with any of the forms:

- volumeoftumour

- sparen1, sparen2 , sparen3, sparen 5, sparen6

- sparet2, sparet3, sparet4, sparet5, sparet6

- spared1, spared2, spared3, spared4

No comments:

Post a Comment