Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CARE_ID | int | 4 | null |
|
|
|||||
| N7_1_SITE_CODE | varchar | 5 | √ | null |
|
|
||||
| N7_2_CONSULTANT | varchar | 8 | √ | null |
|
|
||||
| L_GRADE | varchar | 50 | √ | null |
|
|
||||
| N7_4_TREATMENT_INTENT | int | 4 | √ | null |
|
|
||||
| N7_9_SURGERY_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| L_PROCEDURE | int | 4 | √ | null |
|
|
||||
| L_PROCEDURE2 | int | 4 | √ | null |
|
|
||||
| L_PROCEDURE3 | int | 4 | √ | null |
|
|
||||
| UG_SUR_ID | int | 4 | null |
|
|
|||||
| SURGERY_ID | int | 4 | null |
|
|
|||||
| N_UG1_PHYSIO_SCORE | real | 4 | √ | null |
|
|
||||
| N_UG2_OP_SCORE | real | 4 | √ | null |
|
|
||||
| R_OUTCOME | varchar | 20 | √ | null |
|
|
||||
| R_DELAY | int | 4 | √ | null |
|
|
||||
| R_DELAY_REASON | varchar | 50 | √ | null |
|
|
||||
| R_NODAL | varchar | 50 | √ | null |
|
|
||||
| R_RECONSTRUCTION | varchar | 50 | √ | null |
|
|
||||
| R_ENDO_MORB | varchar | 50 | √ | null |
|
|
||||
| L_NUTRITIONAL_SUP | varchar | 50 | √ | null |
|
|
||||
| L_MORBIDITY | real | 4 | √ | null |
|
|
||||
| L_MORTALITY | real | 4 | √ | null |
|
|
||||
| L_START_TIME | char | 5 | √ | null |
|
|
||||
| L_END_TIME | char | 5 | √ | null |
|
|
||||
| L_INDICATION | varchar | 255 | √ | null |
|
|
||||
| L_INCISION | varchar | 255 | √ | null |
|
|
||||
| L_CLOSURE | varchar | 255 | √ | null |
|
|
||||
| L_PAIN | int | 4 | √ | null |
|
|
||||
| L_PAIN_DETAIL | varchar | 255 | √ | null |
|
|
||||
| L_THORACIC | int | 4 | √ | null |
|
|
||||
| L_ABDOMINAL | int | 4 | √ | null |
|
|
||||
| L_LIVER | int | 4 | √ | null |
|
|
||||
| L_PANCREAS | int | 4 | √ | null |
|
|
||||
| L_SPLEEN | int | 4 | √ | null |
|
|
||||
| L_COLON | int | 4 | √ | null |
|
|
||||
| L_OTHER_ORGAN | int | 4 | √ | null |
|
|
||||
| L_ANAESTHETIC | int | 4 | √ | null |
|
|
||||
| L_STENT_MULTIPLE | varchar | 1 | √ | null |
|
|
||||
| L_STENT_TYPE | int | 4 | √ | null |
|
|
||||
| L_STENT_PLACEMENT | int | 4 | √ | null |
|
|
||||
| L_STENT_JUNCTION | varchar | 1 | √ | null |
|
|
||||
| L_STENT_DEPLOYED | varchar | 1 | √ | null |
|
|
||||
| L_FINDINGS | text | 2147483647 | √ | null |
|
|
||||
| L_SPECIMENS | text | 2147483647 | √ | null |
|
|
||||
| L_DRAINS | text | 2147483647 | √ | null |
|
|
||||
| L_POST_OP | text | 2147483647 | √ | null |
|
|
||||
| L_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
| RETURN_TO_THEATRE | varchar | 1 | √ | null |
|
|
||||
| ENDO_COMP_NO_COMP | bit | 1 | √ | null |
|
|
||||
| ENDO_COMP_STRICTURE | bit | 1 | √ | null |
|
|
||||
| ENDO_COMP_PERFORATION | bit | 1 | √ | null |
|
|
||||
| ENDO_COMP_HAEMORRHAGE | bit | 1 | √ | null |
|
|
||||
| ENDO_COMP_PANCREATITIS | bit | 1 | √ | null |
|
|
||||
| ENDO_COMP_CHOLANGITIS | bit | 1 | √ | null |
|
|
||||
| ENDO_COMP_OTHER_COMP | bit | 1 | √ | null |
|
|
||||
| POST_OP_COMP_NONE | bit | 1 | √ | null |
|
|
||||
| POST_OP_COMP_HAEMORR | bit | 1 | √ | null |
|
|
||||
| EMR_ESD_USE | int | 4 | √ | null |
|
|
||||
| EMR_ESD_RESULT | int | 4 | √ | null |
|
|
||||
| EMR_PATHOLOGY | int | 4 | √ | null |
|
|
||||
| WEIGHT | real | 4 | √ | null |
|
|
||||
| HEIGHT | real | 4 | √ | null |
|
|
||||
| SMOKER | char | 1 | √ | null |
|
|
||||
| RADIO_PROC_TYPE | int | 4 | √ | null |
|
|
||||
| BIL_STENT_INTENT | int | 4 | √ | null |
|
|
||||
| PALLIATION_TYPE | int | 4 | √ | null |
|
|
||||
| LIVER_TRANSPLANT | varchar | 1 | √ | null |
|
|
||||
| PAL_TREAT_REASON | int | 4 | √ | null |
|
|
||||
| ABLATIVE_THERAPY_TYPE | varchar | 1 | √ | null |
|
|
||||
| RADIO_INSERTION | int | 4 | √ | null |
|
|
||||
| NOGCA_BRACHYTHERAPY | bit | 1 | √ | null |
|
|
||||
| SURGICAL_PATHWAY | int | 4 | √ | null |
|
|
||||
| ERAS_PATHWAY_COMPLETED | int | 4 | √ | null |
|
|
||||
| LiverTransplantWaitingListIndicator | int | 4 | √ | null |
|
|
||||
| LiverSurgeryTypeID | int | 4 | √ | null |
|
|
||||
| OtherAblativeSurgery | varchar | 50 | √ | null |
|
|
||||
| SurgicalApproachType | int | 4 | √ | null |
|
|
||||
| OpenApproachType | int | 4 | √ | null |
|
|
||||
| MinimallyInvasiveApproachType | int | 4 | √ | null |
|
|
||||
| AnastomosisType | int | 4 | √ | null |
|
|
||||
| OesophagealConduitType | int | 4 | √ | null |
|
|
||||
| NeckDissection | int | 4 | √ | null |
|
|
||||
| AdditionalComplications | varchar | 150 | √ | null |
|
|
||||
| ChyleLeakSeverity | int | 4 | √ | null |
|
|
||||
| LeakSeverity | int | 4 | √ | null |
|
|
||||
| RecurrentNerveInjury | int | 4 | √ | null |
|
|
||||
| ConduitNecrosisFailure | int | 4 | √ | null |
|
|
||||
| GradeOfComplications | int | 4 | √ | null |
|
|
||||
| ChangeInLevelOfCare | int | 4 | √ | null |
|
|
||||
| BloodProductUtilisation | int | 4 | √ | null |
|
|
||||
| NumberOfUnitsTransfused | int | 4 | √ | null |
|
|