BIvwUpperGISurgeryDetail


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CARE_ID int 4 null
SURGERY_ID int 4 null
Radiological Stent or Drain varchar 50 null
Biliary Stent Insertion Reason varchar 30 null
Stent Deployed Successfully varchar 9 null
Endoscopic Complications No Complications bit 1 null
Endoscopic Complications Stricture bit 1 null
Endoscopic Complications Perforation bit 1 null
Endoscopic Complications Haemorrhage bit 1 null
Endoscopic Complications Other Complications bit 1 null
Endoscopic Complications Pancreatitis bit 1 null
Endoscopic Complications Cholangitis bit 1 null
ASA Grade varchar 100 null
Abdominal Access varchar 100 null
Thoracic Access varchar 50 null
Surgical Palliation Type varchar 30 null
Liver Transplant Performed varchar 9 null
Return to Theatre varchar 3 null
Reason for Palliative Treatment varchar 50 null
Ablative Therapy Type varchar 30 null

View Definition