Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| MDT_ID | varchar | 255 | null |
|
|
|||||
| MEETING_ID | int | 4 | √ | null |
|
|
||||
| UPDATED | varchar | 50 | √ | null |
|
|
MDT saved indicator (derived) |
|||
| MDT_SITE | varchar | 50 | √ | null |
|
|
MDT cancer site |
|||
| NEW_MDT | varchar | 50 | √ | null |
|
|
||||
| PLAN_ID | int | 4 | √ | null |
|
|
Care Plan Record ID |
|||
| NEW_PATH | varchar | 50 | √ | null |
|
|
||||
| PATH_ID | int | 4 | √ | null |
|
|
||||
| NEW_TRIAL | varchar | 50 | √ | null |
|
|
||||
| TRIAL_ID | int | 4 | √ | null |
|
|
||||
| NEW_NURSE | varchar | 50 | √ | null |
|
|
||||
| NURSE_ID | int | 4 | √ | null |
|
|
||||
| CARE_ID | int | 4 | √ | null |
|
|
Referral Record ID |
|||
| MDT_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| APP_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| CONSULTANT | varchar | 8 | √ | null |
|
|
||||
| HISTOLOGY | varchar | 255 | √ | null |
|
|
Morphology (SNOMed) |
|||
| GRADE | varchar | 255 | √ | null |
|
|
Grade of Differentiation |
|||
| DIAGNOSIS_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| CLINICAL_TNM_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| cTSTAGE | varchar | 2 | √ | null |
|
|
Final Pre-Treatment (Clinical) Staging (T) |
|||
| cNSTAGE | varchar | 2 | √ | null |
|
|
Final Pre-Treatment (Clinical) Staging N Stage |
|||
| cMSTAGE | varchar | 2 | √ | null |
|
|
Final Pre-Treatment (Clinical) Staging M Stage |
|||
| TNM_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| TSTAGE | varchar | 5 | √ | null |
|
|
||||
| NSTAGE | varchar | 5 | √ | null |
|
|
||||
| MSTAGE | varchar | 5 | √ | null |
|
|
||||
| DUKES | varchar | 50 | √ | null |
|
|
||||
| DUKES_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| DIAGNOSIS | varchar | 50 | √ | null |
|
|
||||
| STATUS | int | 4 | √ | null |
|
|
Tumour Staus |
|||
| LOCATION | varchar | 50 | √ | null |
|
|
||||
| ACTION_BY | varchar | 255 | √ | null |
|
|
||||
| CARE_INTENT | char | 1 | √ | null |
|
|
||||
| TREATMENT_1 | varchar | 3 | √ | null |
|
|
||||
| TREATMENT_2 | varchar | 3 | √ | null |
|
|
||||
| TREATMENT_3 | varchar | 3 | √ | null |
|
|
||||
| TREATMENT_4 | varchar | 3 | √ | null |
|
|
||||
| NO_TREATMENT | varchar | 50 | √ | null |
|
|
||||
| NODES | int | 4 | √ | null |
|
|
Nodes Examined |
|||
| POS_NODES | int | 4 | √ | null |
|
|
Positive Nodes |
|||
| VASCULAR | varchar | 3 | √ | null |
|
|
||||
| LOCAL_INV | varchar | 100 | √ | null |
|
|
||||
| TRIAL_STATUS | varchar | 2 | √ | null |
|
|
Clinical Trial Status |
|||
| PRE_POST | varchar | 4 | √ | null |
|
|
||||
| FULL_COLONIC | varchar | 5 | √ | null |
|
|
||||
| SYNC_CA | varchar | 5 | √ | null |
|
|
||||
| SYNC_CAECUM | varchar | 1 | √ | null |
|
|
||||
| SYNC_APPENDIX | varchar | 1 | √ | null |
|
|
||||
| SYNC_ASCENDING | varchar | 1 | √ | null |
|
|
||||
| SYNC_HEPATIC | varchar | 1 | √ | null |
|
|
||||
| SYNC_TRANSVERSE | varchar | 1 | √ | null |
|
|
||||
| SYNC_SPLENIC | varchar | 1 | √ | null |
|
|
||||
| SYNC_DESCENDING | varchar | 1 | √ | null |
|
|
||||
| SYNC_SIGMOID | varchar | 1 | √ | null |
|
|
||||
| SYNC_RECTOSIGMOID | varchar | 1 | √ | null |
|
|
||||
| SYNC_RECTUM | varchar | 1 | √ | null |
|
|
||||
| POLYPS | varchar | 5 | √ | null |
|
|
||||
| LIVER_METS | varchar | 5 | √ | null |
|
|
||||
| CYSTS | varchar | 5 | √ | null |
|
|
||||
| HAEMANGIOMA | varchar | 5 | √ | null |
|
|
||||
| SIG_BIOPSY | varchar | 5 | √ | null |
|
|
||||
| REFERRED_TO | varchar | 50 | √ | null |
|
|
Referred To |
|||
| WHO_REFERRED_TO | varchar | 8 | √ | null |
|
|
Who Referred To |
|||
| PATH_REVIEW | varchar | 50 | √ | null |
|
|
Reviewd by Pathologist prior to MDT |
|||
| REVIEW_WHO | varchar | 50 | √ | null |
|
|
Reviewed by |
|||
| OTHER_TRUST | varchar | 5 | √ | null |
|
|
Oranisation Referred To |
|||
| TERTIARY_REASON | int | 4 | √ | null |
|
|
Reason for Referral |
|||
| KEY_WORKER | varchar | 255 | √ | null |
|
|
Key Worker |
|||
| DATE_NETWORK_MEETING | smalldatetime | 16 | √ | null |
|
|
Date of Network MDT |
|||
| NETWORK_ACTIONED | varchar | 255 | √ | null |
|
|
Network MDT To Be Actioned By |
|||
| CARE_PLAN_AGREED_MDT | char | 1 | √ | null |
|
|
Care Plan agreed at MDT |
|||
| WHO_STATUS | int | 4 | √ | null |
|
|
Performance Status |
|||
| NETWORK_FEEDBACK | text | 2147483647 | √ | null |
|
|
Network Feedback |
|||
| NETWORK_COMMENTS | text | 2147483647 | √ | null |
|
|
Network Comments |
|||
| COMMENTS | text | 2147483647 | √ | null |
|
|
||||
| PATH_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
| cTLETTER | varchar | 5 | √ | null |
|
|
Final Pre-Treatment (Clinical) Staging T Letter |
|||
| cNLETTER | varchar | 5 | √ | null |
|
|
Final Pre-Treatment (Clinical) Staging N Letter |
|||
| cMLETTER | varchar | 5 | √ | null |
|
|
Final Pre-Treatment (Clinical) Staging M Letter |
|||
| TLETTER | varchar | 5 | √ | null |
|
|
||||
| NLETTER | varchar | 5 | √ | null |
|
|
||||
| MLETTER | varchar | 5 | √ | null |
|
|
||||
| cTNM_CATEGORY | varchar | 50 | √ | null |
|
|
||||
| cCERTAINTY_FACTORS_T | varchar | 50 | √ | null |
|
|
||||
| cCERTAINTY_FACTORS_N | varchar | 50 | √ | null |
|
|
||||
| cCERTAINTY_FACTORS_M | varchar | 50 | √ | null |
|
|
||||
| cCERTAINTY_FACTORS_OVERALL | varchar | 50 | √ | null |
|
|
||||
| FINAL_TNM_DATE | datetime | 16,3 | √ | null |
|
|
Final (Integrated) Staging Date |
|||
| fTSTAGE | varchar | 50 | √ | null |
|
|
Final (Integrated) Staging T Stage |
|||
| fTLETTER | varchar | 50 | √ | null |
|
|
Final (Integrated) Staging T Letter |
|||
| fNSTAGE | varchar | 50 | √ | null |
|
|
Final (Integrated) Staging N Stage |
|||
| fNLETTER | varchar | 50 | √ | null |
|
|
Final (Integrated) Staging N Letter |
|||
| fMSTAGE | varchar | 50 | √ | null |
|
|
Final (Integrated) Staging M Stage |
|||
| fMLETTER | varchar | 50 | √ | null |
|
|
Final (Integrated) Staging M Letter |
|||
| fTNM_CATEGORY | varchar | 50 | √ | null |
|
|
Final (Integrated) Staging Grouping |
|||
| fCERTAINTY_FACTORS_T | varchar | 50 | √ | null |
|
|
||||
| fCERTAINTY_FACTORS_N | varchar | 50 | √ | null |
|
|
||||
| fCERTAINTY_FACTORS_M | varchar | 50 | √ | null |
|
|
||||
| fCERTAINTY_FACTORS_OVERALL | varchar | 50 | √ | null |
|
|
||||
| HAGGITT | int | 4 | √ | null |
|
|
||||
| KIKUCHI | int | 4 | √ | null |
|
|
||||
| DUKES_STAGING | varchar | 50 | √ | null |
|
|
||||
| HAGGITT_STAGING | int | 4 | √ | null |
|
|
||||
| KIKUCHI_STAGING | int | 4 | √ | null |
|
|
||||
| GERM_CELL_NON_CNS_ID | int | 4 | √ | null |
|
|
TNM Stage Grouping for Non-CNS Germ Cell Tumours |
|||
| GERM_CELL_NON_CNS_PATH_ID | int | 4 | √ | null |
|
|
||||
| CO_MORBIDITY_ID | int | 4 | √ | null |
|
|
Co-morbidity Evaluation - 27 Score |
|||
| RECURRENCE_CANCER_SITE_ID | int | 4 | √ | null |
|
|
Cancer Site of Recurrence |
|||
| L_PATHOLOGY_TEXT | varchar | 2147483647 | √ | null |
|
|
Pathology Report Text |
|||
| PRIMARY_DIAGNOSIS_SUB_COMMENT | varchar | 50 | √ | null |
|
|
Primary Diagnosis Subsidiary Comment |
|||
| GONADOTROPIN_SERUM | int | 4 | √ | null |
|
|
Beta Human Chorionic Gonadotropin (Serum) |
|||
| FETOPROTEIN_SERUM | int | 4 | √ | null |
|
|
Alpha Fetoprotein (Serum) |
|||
| BASIS_DIAGNOSIS | int | 4 | √ | null |
|
|
Basis of Diagnosis |
|||
| REPORT_NUMBER | varchar | 50 | √ | null |
|
|
Report Number |
|||
| LATERALITY | varchar | 50 | √ | null |
|
|
Laterality |
|||
| NEXT_OPA | smalldatetime | 16 | √ | null |
|
|
||||
| TO_BE_SEEN_BY | varchar | 50 | √ | null |
|
|
||||
| PAT_INFORMED_MDT_OUTCOME | varchar | 2147483647 | √ | null |
|
|
Patient Informed of MDT Outcome |
|||
| R_NOT_CUR | varchar | 2 | √ | null |
|
|
||||
| LATERALITY_PATH | varchar | 50 | √ | null |
|
|
Tumour Laterality (Pathology) |
|||
| KEY_WORKER_NEW | int | 4 | √ | null |
|
|
Key Worker |
|||
| KEY_WORKER_OTHER | varchar | 255 | √ | null |
|
|
Key Worker (Other) |
|||
| EXCISION_MARGINS | varchar | 2 | √ | null |
|
|
||||
| REASON_PAT_DECLINED | bit | 1 | √ | null |
|
|
||||
| REASON_UNFIT_PERFORMANCE | bit | 1 | √ | null |
|
|
||||
| REASON_UNFIT_COMORBIDITY | bit | 1 | √ | null |
|
|
||||
| REASON_UNFIT_ADVANCED | bit | 1 | √ | null |
|
|
||||
| REASON_UNKNOWN_PRIMARY | bit | 1 | √ | null |
|
|
||||
| REASON_DIED | bit | 1 | √ | null |
|
|
||||
| REASON_NO_TREATMENT | bit | 1 | √ | null |
|
|
||||
| REASON_OTHER | bit | 1 | √ | null |
|
|
||||
| REASON_MONITORING | bit | 1 | √ | null |
|
|
||||
| REASON_NOT_KNOWN | bit | 1 | √ | null |
|
|
||||
| NON_CANCER_DIAGNOSIS_CHAPTER | int | 4 | √ | null |
|
|
||||
| NON_CANCER_DIAGNOSIS_GROUP | varchar | 5 | √ | null |
|
|
||||
| NON_CANCER_DIAGNOSIS_CODE | varchar | 5 | √ | null |
|
|
||||
| LIVER_METS_PATH | varchar | 5 | √ | null |
|
|
||||
| SNOMedCT | int | 4 | √ | null |
|
|
||||
| SNOMEDDiagnosisID | int | 4 | √ | null |
|
|
||||
| DATE_PT_INFORMED | datetime | 16,3 | √ | null |
|
|
||||
| NonPrimaryPathwayOptionsID | int | 4 | √ | null |
|
|
||||
| TNMOrganisation | int | 4 | √ | null |
|
|
||||
| TNMOrganisation_Integrated | int | 4 | √ | null |
|
|
||||
| LDHValue | int | 4 | √ | null |
|
|
||||
| DEPRECATED_21_01_LDH_NORMAL | int | 4 | √ | null |
|
|
||||
| L_ORG_CODE_DIAGNOSIS | varchar | 5 | √ | null |
|
|
||||
| MarkerLymphNode | varchar | 1 | √ | null |
|
|
||||
| HeightAboveAnalVerge | int | 4 | √ | null |
|
|
||||
| ReferralSubtypeID | int | 4 | √ | null |
|
|
||||
| MDTDiscussionType | int | 4 | √ | null |
|
|
||||
| MiscLabReportDate | smalldatetime | 16 | √ | null |
|
|
||||
| MiscLabReportOrgID | int | 4 | √ | null |
|
|
||||
| SNOMEDMorph | int | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblCOLORECTAL_MDT | Primary key | Asc | MDT_ID |