Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CR_SUR_ID | int identity | 4 | √ | null |
|
|
Unique Record ID (Auto) |
|||
| SURGERY_ID | int | 4 | null |
|
|
Surgery Record ID |
||||
| R_THROMBO_PROPHYL | varchar | 3 | √ | null |
|
|
Heparin Prophylaxis |
|||
| R_ANTIBIOTIC_PROPHYL | varchar | 3 | √ | null |
|
|
Antibiotic Prophylaxis |
|||
| R_REASON_PALLIATIVE | varchar | 50 | √ | null |
|
|
Reason Palliative |
|||
| R_OTHER_PALLIATIVE | varchar | 255 | √ | null |
|
|
Other Reason |
|||
| R_REASON_UNCERT | varchar | 50 | √ | null |
|
|
Reason Not Known |
|||
| R_OTHER_UNCERT | varchar | 255 | √ | null |
|
|
Other Reason |
|||
| R_PERINEAL | varchar | 50 | √ | null |
|
|
Perineal Surgeon |
|||
| R_GRADE_PERINEAL | varchar | 50 | √ | null |
|
|
Grade of Perineal Surgeon |
|||
| L_SCRUB | varchar | 8 | √ | null |
|
|
Unscrubbed Supervisor |
|||
| R_START_TIME | char | 5 | √ | null |
|
|
Start Time (Knife to Skin) |
|||
| R_END_TIME | char | 5 | √ | null |
|
|
End Time (Wound Closure) |
|||
| R_MINOR_COMPS | varchar | 50 | √ | null |
|
|
Local Cancer Complications |
|||
| R_OTHER_COMPS | varchar | 255 | √ | null |
|
|
Complication Details |
|||
| R_DATE_TRANSFER | smalldatetime | 16 | √ | null |
|
|
Date Transferred (not used) |
|||
| R_DATE_DISCHARGE_CON | smalldatetime | 16 | √ | null |
|
|
Date of Discharge from Convalescent Hospital |
|||
| R_DATE_CLOSED | smalldatetime | 16 | √ | null |
|
|
Date Stoma Closed |
|||
| R_NO_OP | varchar | 255 | √ | null |
|
|
Operation not performed details |
|||
| R_OTHER_TREATMENT | varchar | 255 | √ | null |
|
|
Other treatment, if not surgery |
|||
| R_PERFORMED | varchar | 50 | √ | null |
|
|
Performed (not used) |
|||
| L_PHYSIO_SCORE | real | 4 | √ | null |
|
|
Physiological Score |
|||
| L_OP_SCORE | real | 4 | √ | null |
|
|
Operative Score |
|||
| L_MORBIDITY | real | 4 | √ | null |
|
|
% Morbidity |
|||
| L_MORTALITY | real | 4 | √ | null |
|
|
% Mortality |
|||
| R_NOT_OP | varchar | 3 | √ | null |
|
|
Operation not performed |
|||
| L_STOMA_THERAPIST | int | 4 | √ | null |
|
|
Seen by Stoma Therapist |
|||
| L_STOMA_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| L_PREP | varchar | 20 | √ | null |
|
|
Bowel Prep Pre-op |
|||
| L_NO_UNITS | real | 4 | √ | null |
|
|
Number of Units Transfused |
|||
| L_REF_ONCOLOGIST | int | 4 | √ | null |
|
|
Referred to Oncolgist prior to discharge |
|||
| L_CATHETER | int | 4 | √ | null |
|
|
Urinary Catheter |
|||
| L_ANTI_AUGMENTIN | int | 4 | √ | null |
|
|
Augmentin |
|||
| L_ANTI_METRONIDAZOLE | int | 4 | √ | null |
|
|
Metronidazole |
|||
| L_ANTI_CEFOTAXIME | int | 4 | √ | null |
|
|
Cefotaxime |
|||
| L_ANTI_OTHER | int | 4 | √ | null |
|
|
Other |
|||
| L_FIXITY | varchar | 15 | √ | null |
|
|
Fixity |
|||
| L_FINDINGS | varchar | 15 | √ | null |
|
|
Findings |
|||
| L_METASTASES | varchar | 20 | √ | null |
|
|
Evidence of Metastases |
|||
| L_INTRA_COMPS | varchar | 25 | √ | null |
|
|
Complications in Theatre |
|||
| L_MOBILISATION | int | 4 | √ | null |
|
|
Mobilisation of Splenic Flexure |
|||
| L_COMPLETE | varchar | 10 | √ | null |
|
|
Was excision macroscopically |
|||
| L_MESORECTAL | varchar | 10 | √ | null |
|
|
Mesorectal Excision |
|||
| L_SUTURES | varchar | 255 | √ | null |
|
|
Sutures for Closure |
|||
| L_HEIGHT_ANASTOMOSIS | real | 4 | √ | null |
|
|
Height of Anastomosis above anal verge |
|||
| L_ARTERY | int | 4 | √ | null |
|
|
High Tie Inferior Mesentric Artery |
|||
| L_VEIN | int | 4 | √ | null |
|
|
Inferior Mesentric Vein |
|||
| L_WASHOUT_WHAT | varchar | 10 | √ | null |
|
|
Tumoricidal Washout |
|||
| L_OUTCOME | varchar | 10 | √ | null |
|
|
At end of op, was the procedure considered |
|||
| L_DRAIN_TYPE | varchar | 10 | √ | null |
|
|
Drain |
|||
| L_SUTURES_CLOSURE | varchar | 255 | √ | null |
|
|
Sutures for Closure |
|||
| L_LAPAROSCOPIC | varchar | 50 | √ | null |
|
|
Open/Laparoscopic |
|||
| L_LAP_OPEN | varchar | 50 | √ | null |
|
|
Laparoscopy |
|||
| L_SITE_FIXITY | varchar | 50 | √ | null |
|
|
Site of Fixity |
|||
| R_NO_OP_REASON | int | 4 | √ | null |
|
|
Reason operation not performed |
|||
| R_LAP_CONVERSION | int | 4 | √ | null |
|
|
Reason for conversion |
|||
| R_LAP_DIVERSION | int | 4 | √ | null |
|
|
Bowel division |
|||
| R_LAP_ANASTOMOSIS | int | 4 | √ | null |
|
|
Type of anastomosis |
|||
| R_LAP_COMPS | int | 4 | √ | null |
|
|
Laparoscopic Complications |
|||
| R_PORT_COMPS | int | 4 | √ | null |
|
|
Early Port-Site Complications |
|||
| L_INCISION | varchar | 255 | √ | null |
|
|
Incision |
|||
| L_ANTIBIOTICS | varchar | 3 | √ | null |
|
|
Antibiotics |
|||
| L_ANTI_DETAILS | varchar | 2147483647 | √ | null |
|
|
Antibiotic Details |
|||
| L_COMMENTS | text | 2147483647 | √ | null |
|
|
Post-Op Instructions |
|||
| L_INDICATION | text | 2147483647 | √ | null |
|
|
Indication for Surgery |
|||
| L_FIND_COMMENTS | text | 2147483647 | √ | null |
|
|
Findings Comments |
|||
| L_PROC_COMMENTS | text | 2147483647 | √ | null |
|
|
Procedure Comments |
|||
| CPEX_ASSESS | real | 4 | √ | null |
|
|
||||
| PelvicSidewallClearanceID | tinyint | 1 | √ | null |
|
|
||||
| TransanalTMEID | tinyint | 1 | √ | null |
|
|
||||
| OtherBowelPrepPreOp | varchar | 50 | √ | null |
|
|
||||
| OtherAntibioticProphylaxis | varchar | 50 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblSURGERY_COLORECTAL | Primary key | Asc | CR_SUR_ID |
| IX_tblSURGERY_COLORECTAL | Performance | Asc | SURGERY_ID |