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