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_SITE | varchar | 50 | √ | null |
|
|
||||
NEW_MDT | varchar | 50 | √ | null |
|
|
||||
PLAN_ID | int | 4 | √ | null |
|
|
||||
NEW_PATH | varchar | 50 | √ | null |
|
|
Indicator for creation of new pathology record |
|||
PATH_ID | int | 4 | √ | null |
|
|
||||
NEW_NURSE | varchar | 50 | √ | null |
|
|
Indicator for creation of new CNS contact |
|||
NURSE_ID | int | 4 | √ | null |
|
|
||||
CARE_ID | int | 4 | √ | null |
|
|
||||
APP_DATE | smalldatetime | 16 | √ | null |
|
|
Date First Appointment |
|||
CONSULTANT | varchar | 8 | √ | null |
|
|
Consultant |
|||
MDT_DATE | smalldatetime | 16 | √ | null |
|
|
MDT Date |
|||
LOCATION | varchar | 50 | √ | null |
|
|
MDT Location |
|||
ACTION_BY | varchar | 255 | √ | null |
|
|
||||
CARE_INTENT | char | 1 | √ | null |
|
|
Care Plan Intent |
|||
TREATMENT_1 | varchar | 3 | √ | null |
|
|
Care plan treatment 1 |
|||
TREATMENT_2 | varchar | 3 | √ | null |
|
|
Care plan treatment 2 |
|||
TREATMENT_3 | varchar | 3 | √ | null |
|
|
Care plan treatment 3 |
|||
TREATMENT_4 | varchar | 3 | √ | null |
|
|
Care plan treatment 4 |
|||
NO_TREATMENT | varchar | 50 | √ | null |
|
|
No treatment reason |
|||
REFERRED_TO | varchar | 50 | √ | null |
|
|
||||
WHO_REFERRED_TO | varchar | 8 | √ | null |
|
|
||||
HISTOLOGY | varchar | 255 | √ | null |
|
|
||||
RESULT_DATE | smalldatetime | 16 | √ | null |
|
|
||||
WHO | int | 4 | √ | null |
|
|
Performance status |
|||
DIAGNOSIS | varchar | 50 | √ | null |
|
|
Diagnosis |
|||
DIAGNOSIS_DATE | smalldatetime | 16 | √ | null |
|
|
Diagnosis date |
|||
SEIZURES | int | 4 | √ | null |
|
|
Seizures |
|||
WHO_STATUS | int | 4 | √ | null |
|
|
||||
SURGERY | int | 4 | √ | null |
|
|
Surgery |
|||
PATH_REVIEW | varchar | 50 | √ | null |
|
|
||||
REVIEW_WHO | varchar | 50 | √ | null |
|
|
||||
LATERALITY | varchar | 50 | √ | null |
|
|
||||
STATUS | int | 4 | √ | null |
|
|
||||
PRE_POST | varchar | 4 | √ | null |
|
|
Pre/post-treatment indicator |
|||
OTHER_TRUST | varchar | 5 | √ | null |
|
|
||||
TERTIARY_REASON | int | 4 | √ | null |
|
|
||||
KEY_WORKER | varchar | 255 | √ | null |
|
|
||||
DATE_NETWORK_MEETING | smalldatetime | 16 | √ | null |
|
|
||||
NETWORK_ACTIONED | varchar | 255 | √ | null |
|
|
||||
CARE_PLAN_AGREED_MDT | char | 1 | √ | null |
|
|
||||
NETWORK_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
NETWORK_FEEDBACK | text | 2147483647 | √ | null |
|
|
||||
COMMENTS | text | 2147483647 | √ | null |
|
|
MDT Comments |
|||
REPORT_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
GRADE | varchar | 100 | √ | null |
|
|
||||
cTSTAGE | varchar | 2 | √ | null |
|
|
||||
cTLETTER | varchar | 2 | √ | null |
|
|
||||
cNSTAGE | varchar | 2 | √ | null |
|
|
||||
cNLETTER | varchar | 2 | √ | null |
|
|
||||
cMSTAGE | varchar | 2 | √ | null |
|
|
||||
cMLETTER | varchar | 2 | √ | null |
|
|
||||
pTSTAGE | varchar | 2 | √ | null |
|
|
||||
pTLETTER | varchar | 2 | √ | null |
|
|
||||
pNSTAGE | varchar | 2 | √ | null |
|
|
||||
pNLETTER | varchar | 2 | √ | null |
|
|
||||
pMSTAGE | varchar | 2 | √ | null |
|
|
||||
pMLETTER | varchar | 2 | √ | 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 |
|
|
||||
fTSTAGE | varchar | 50 | √ | null |
|
|
||||
fTLETTER | varchar | 50 | √ | null |
|
|
||||
fNSTAGE | varchar | 50 | √ | null |
|
|
||||
fNLETTER | varchar | 50 | √ | null |
|
|
||||
fMSTAGE | varchar | 50 | √ | null |
|
|
||||
fMLETTER | varchar | 50 | √ | null |
|
|
||||
fTNM_CATEGORY | varchar | 50 | √ | null |
|
|
||||
fCERTAINTY_FACTORS_T | varchar | 50 | √ | null |
|
|
||||
fCERTAINTY_FACTORS_N | varchar | 50 | √ | null |
|
|
||||
fCERTAINTY_FACTORS_M | varchar | 50 | √ | null |
|
|
||||
fCERTAINTY_FACTORS_OVERALL | varchar | 50 | √ | null |
|
|
||||
CHANG_ID | int | 4 | √ | null |
|
|
||||
CHANG_PATH_ID | int | 4 | √ | null |
|
|
||||
CO_MORBIDITY_ID | int | 4 | √ | null |
|
|
||||
TRIAL_STATUS | varchar | 2 | √ | null |
|
|
||||
NEW_TRIAL | varchar | 50 | √ | null |
|
|
Indicator for creation of new clinical trial record |
|||
TRIAL_ID | int | 4 | √ | null |
|
|
||||
RECURRENCE_CANCER_SITE_ID | int | 4 | √ | null |
|
|
||||
L_PATHOLOGY_TEXT | varchar | 2147483647 | √ | null |
|
|
||||
LESION_LOCATION_ID | int | 4 | √ | null |
|
|
||||
LESION_NO_RADIOLOGICAL | int | 4 | √ | null |
|
|
||||
LESION_SIZE_RADIOLOGICAL | real | 4 | √ | null |
|
|
||||
DIAGNOSTIC_IMAGING_TYPE | int | 4 | √ | null |
|
|
||||
DIAGNOSIS_MDT_PROVISIONAL | varchar | 5 | √ | null |
|
|
||||
DIAGNOSIS_RADIOLOGICAL | varchar | 5 | √ | null |
|
|
||||
PRIMARY_DIAGNOSIS_SUB_COMMENT | varchar | 50 | √ | null |
|
|
||||
CONTRAST_ENHANCEMENT | int | 4 | √ | null |
|
|
||||
CALCIFICATION | int | 4 | √ | null |
|
|
||||
MASS_EFFECT | int | 4 | √ | null |
|
|
||||
HYDROCEPHALUS | int | 4 | √ | null |
|
|
||||
HAEMORRHAGE | int | 4 | √ | null |
|
|
||||
CYSTIC | int | 4 | √ | null |
|
|
||||
DURAL_TAIL | int | 4 | √ | null |
|
|
||||
BRAIN_OEDEMA | int | 4 | √ | null |
|
|
||||
CORD_SIGNAL_CHANGE | int | 4 | √ | null |
|
|
||||
CORD_COMPRESSION | int | 4 | √ | null |
|
|
||||
FETOPROTEIN | int | 4 | √ | null |
|
|
||||
GONADOTROPIN | int | 4 | √ | null |
|
|
||||
GONADOTROPIN_SERUM | int | 4 | √ | null |
|
|
||||
FETOPROTEIN_SERUM | int | 4 | √ | null |
|
|
||||
BASIS_DIAGNOSIS | int | 4 | √ | null |
|
|
||||
GERM_CELL_NON_CNS_ID | int | 4 | √ | null |
|
|
||||
REPORT_NUMBER | varchar | 50 | √ | null |
|
|
||||
NEXT_OPA | smalldatetime | 16 | √ | null |
|
|
Next OPA |
|||
TO_BE_SEEN_BY | varchar | 50 | √ | null |
|
|
To be seen by |
|||
PAT_INFORMED_MDT_OUTCOME | varchar | 2147483647 | √ | null |
|
|
||||
LATERALITY_PATH | varchar | 50 | √ | null |
|
|
||||
KEY_WORKER_NEW | int | 4 | √ | null |
|
|
||||
KEY_WORKER_OTHER | varchar | 255 | √ | null |
|
|
||||
MARGINS | varchar | 50 | √ | null |
|
|
||||
R_NOT_CUR | varchar | 2 | √ | null |
|
|
||||
REASON_PAT_DECLINED | bit | 1 | √ | null |
|
|
Reason Not Curative - Patient Declined Treatment |
|||
REASON_UNFIT_PERFORMANCE | bit | 1 | √ | null |
|
|
Reason Not Curative - Unfit: Poor Performance Status |
|||
REASON_UNFIT_COMORBIDITY | bit | 1 | √ | null |
|
|
Reason Not Curative - Unfit: Significant Co-morbidity |
|||
REASON_UNFIT_ADVANCED | bit | 1 | √ | null |
|
|
Reason Not Curative - Unfit: Advanced Stage Cancer |
|||
REASON_UNKNOWN_PRIMARY | bit | 1 | √ | null |
|
|
Reason Not Curative - Unknown Primary Site |
|||
REASON_DIED | bit | 1 | √ | null |
|
|
Reason Not Curative - Died Before Treatment |
|||
REASON_NO_TREATMENT | bit | 1 | √ | null |
|
|
Reason Not Curative - No Anti-Cancer Treatment Available |
|||
REASON_OTHER | bit | 1 | √ | null |
|
|
Reason Not Curative - Other |
|||
REASON_MONITORING | bit | 1 | √ | null |
|
|
Reason Not Curative - Monitoring Only |
|||
REASON_NOT_KNOWN | bit | 1 | √ | null |
|
|
Reason Not Curative - Not Known |
|||
NON_CANCER_DIAGNOSIS_CHAPTER | int | 4 | √ | null |
|
|
Non-cancer diagnosis chapter |
|||
NON_CANCER_DIAGNOSIS_GROUP | varchar | 5 | √ | null |
|
|
Non-cancer diagnosis group |
|||
NON_CANCER_DIAGNOSIS_CODE | varchar | 5 | √ | null |
|
|
Non-cancer diagnosis code |
|||
INSS_ID | int | 4 | √ | null |
|
|
||||
INSS_DATE | datetime | 16,3 | √ | null |
|
|
||||
INPC_ID | int | 4 | √ | null |
|
|
||||
SNOmedCT | int | 4 | √ | null |
|
|
||||
CLINICAL_TNM_DATE | datetime | 16,3 | √ | null |
|
|
||||
SNOMEDDiagnosisID | int | 4 | √ | null |
|
|
||||
DATE_PT_INFORMED | datetime | 16,3 | √ | null |
|
|
||||
NonPrimaryPathwayOptionsID | int | 4 | √ | null |
|
|
||||
TNMOrganisation | int | 4 | √ | null |
|
|
||||
VisualAcuityLeft | int | 4 | √ | null |
|
|
||||
VisualAcuityRight | int | 4 | √ | null |
|
|
||||
VisualFieldsLeft | int | 4 | √ | null |
|
|
||||
VisualFieldsRight | 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 |
|
|
||||
ReferralSubtypeID | int | 4 | √ | null |
|
|
||||
MDTDiscussionType | int | 4 | √ | null |
|
|
||||
StageBrainReportDate | smalldatetime | 16 | √ | null |
|
|
||||
LabReportOrgID | int | 4 | √ | null |
|
|
||||
LabReportDate | smalldatetime | 16 | √ | null |
|
|
||||
UrineVMACreatinineRatio | real | 4 | √ | null |
|
|
||||
INRGStagingSystem | int | 4 | √ | null |
|
|
||||
StageBrainOrgID | int | 4 | √ | null |
|
|
||||
MiscLabReportDate | smalldatetime | 16 | √ | null |
|
|
||||
MiscLabReportOrgID | int | 4 | √ | null |
|
|
||||
SNOMEDMorph | int | 4 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PK_tblBRAIN_MDT | Primary key | Asc | MDT_ID |