tblUROLOGY_MDT


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
ORGAN varchar 50 √ null
NEW_MDT varchar 50 √ null
PLAN_ID int 4 √ null
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
tblMAIN_REFERRALS.CARE_ID FK_tblUROLOGY_MDT_tblMAIN_REFERRALSC
MDT_DATE smalldatetime 16 √ null
APP_DATE smalldatetime 16 √ null
CONSULTANT varchar 8 √ null
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
REFERRED_TO varchar 50 √ null
WHO_REFERRED_TO varchar 8 √ null
TRIAL_STATUS varchar 2 √ null
PRE_POST varchar 4 √ null
HISTOLOGY varchar 255 √ null
GRADE varchar 255 √ null
DIAGNOSIS varchar 50 √ null
DIAGNOSIS_DATE smalldatetime 16 √ null
LATERALITY varchar 1 √ null
PATH_REVIEW varchar 50 √ null
REVIEW_WHO varchar 50 √ null
DATE_PT_INFORMED datetime 16,3 √ null
CLINICAL_TNM_DATE smalldatetime 16 √ 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
PATH_TNM_DATE smalldatetime 16 √ 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
STATUS int 4 √ null
OTHER_TRUST varchar 5 √ null
TERTIARY_REASON int 4 √ null
KEY_WORKER varchar 255 √ null
METHOD_DIAGNOSIS varchar 50 √ null
PSA varchar 50 √ null
PROSTATE_VOL varchar 50 √ null
BX_GLEASON1 varchar 50 √ null
BX_GLEASON2 varchar 50 √ null
GLEASON1 varchar 50 √ null
GLEASON2 varchar 50 √ null
NO_CORES varchar 50 √ null
QUESTIONS varchar 500 √ null
REVIEW varchar 10 √ null
PRE_DATE_PATH_1 varchar 255 √ null
PRE_PATH_1 varchar 255 √ null
PRE_TREAT_1 varchar 500 √ null
PRE_DATE_PATH_2 varchar 255 √ null
PRE_PATH_2 varchar 255 √ null
PRE_TREAT_2 varchar 500 √ null
PRE_DATE_PATH_3 varchar 255 √ null
PRE_PATH_3 varchar 255 √ null
PRE_TREAT_3 varchar 500 √ null
PREFERENCE varchar 1000 √ null
FURTHER_INV varchar 1000 √ null
PATHWAY_COM varchar 1000 √ null
TREATMENT_COMMENTS varchar 1000 √ null
DATE_NETWORK_MEETING smalldatetime 16 √ null
NETWORK_ACTIONED varchar 255 √ null
CARE_PLAN_AGREED_MDT char 1 √ null
WHO_STATUS int 4 √ null
NETWORK_FEEDBACK text 2147483647 √ null
NETWORK_COMMENTS text 2147483647 √ null
COMMENTS text 2147483647 √ null
DIAG_COMMENTS text 2147483647 √ null
REPORT_COMMENTS text 2147483647 √ 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
BX_GLEASON_TERT varchar 50 √ null
F_GLEASON1 varchar 50 √ null
F_GLEASON2 varchar 50 √ null
F_GLEASON_TERT varchar 50 √ null
S_STAGE varchar 50 √ null
RMH_STAGE int 4 √ null
EXTRA_NODAL_METS varchar 50 √ null
LUNG_METS_SUB_STAGE int 4 √ null
RMH_STAGE_PATH int 4 √ null
WILMS_RENAL_ID int 4 √ null
WILMS_DATE smalldatetime 16 √ null
WILMS_RENAL_PATH_ID int 4 √ null
GERM_CELL_NON_CNS_ID int 4 √ null
GERM_CELL_NON_CNS_PATH_ID int 4 √ null
CO_MORBIDITY_ID int 4 √ null
RECURRENCE_CANCER_SITE_ID int 4 √ null
L_PATHOLOGY_TEXT varchar 2147483647 √ null
S_STAGE_PATH varchar 50 √ null
EXTRA_NODAL_METS_PATH varchar 50 √ null
LUNG_METS_SUB_STAGE_PATH varchar 50 √ null
EXTRA_NODAL_LIVER_PATH int 4 √ null
EXTRA_NODAL_BRAIN_PATH int 4 √ null
EXTRA_NODAL_MEDIASTINAL_PATH int 4 √ null
EXTRA_NODAL_NECK_PATH int 4 √ null
EXTRA_NODAL_LUNG_PATH int 4 √ null
PRIMARY_DIAGNOSIS_SUB_COMMENT varchar 50 √ null
RISK_CLASS_PATH_NEPHRECTOMY_ID int 4 √ null
RISK_CLASS_PATH_CHEMOTHERAPY_ID int 4 √ null
GONADOTROPIN_SERUM int 4 √ null
FETOPROTEIN_SERUM int 4 √ null
EGFR int 4 √ null
HYDRONEPHROSIS char 1 √ null
DEPRECATED_21_01_LDH_NORMAL int 4 √ null
SCATEGORY_AFP int 4 √ null
SCATEGORY_HCG int 4 √ null
SCATEGORY_LDH int 4 √ null
BASIS_DIAGNOSIS int 4 √ null
REPORT_NUMBER varchar 50 √ null
NEXT_OPA smalldatetime 16 √ null
TO_BE_SEEN_BY varchar 50 √ null
PAT_INFORMED_MDT_OUTCOME varchar 2147483647 √ null
ASA_PROSTATE int 4 √ null
MULTIPARA_MRI_PERF int 4 √ null
SPECIALIST_REF_APPTS int 4 √ null
PLANNED_PROS_TREAT_1 varchar 3 √ null
PLANNED_PROS_TREAT_2 varchar 3 √ null
PLANNED_RADIO_INTENT int 4 √ null
PLANNED_RADIO_TYPE int 4 √ null
PLANNED_IMAGE_GUIDANCE int 4 √ null
PLANNED_RADIO_FIELD int 4 √ null
PLANNED_BRACHY_TYPE int 4 √ null
PLANNED_BRACHY_TOTAL_DOSE int 4 √ null
PLANNED_BRACHY_TOTAL_FRACTIONS int 4 √ null
PLANNED_DUR_NEOADJ_AND_DEP_THERAPY int 4 √ null
PLANNED_TOT_DUR_ADJ_ANDR_DEPR int 4 √ null
PROST_CORES_POSITIVE int 4 √ null
PROST_PERINEURAL_INV varchar 1 √ null
PROST_GREATEST_PERC_CANCER int 4 √ 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_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
PROST_EXCISION_MARGINS int 4 √ null
NON_CANCER_DIAGNOSIS_CHAPTER int 4 √ null
NON_CANCER_DIAGNOSIS_GROUP varchar 5 √ null
NON_CANCER_DIAGNOSIS_CODE varchar 5 √ null
RISK_CATAGORY int 4 √ null
RMH_DATE smalldatetime 16 √ null
SNOMedCT int 4 √ null
SNOMEDDiagnosisID int 4 √ null
SNOMEDCTConcepts.ID FK_tblUROLOGY_MDT_SNOMEDCTConceptsR
NonPrimaryPathwayOptionsID int 4 √ null
ltblNonPrimaryPathwayOptions.NonPrimaryPathwayOptionsID FK_tblUROLOGY_MDT_ltblNonPrimaryPathwayOptionsR
TNMOrganisation int 4 √ null
TNMOrganisation_Integrated int 4 √ null
LDHValue int 4 √ null
L_ORG_CODE_DIAGNOSIS varchar 5 √ null
ReferralSubtypeID int 4 √ null
MDTDiscussionType int 4 √ null
ltblMDTDiscussionType.ID FK_tblUROLOGY_MDT_ltblMDTDiscussionTypeR
LabReportDate smalldatetime 16 √ null
LabReportOrgID int 4 √ null
OrganisationSites.ID FK_tblUROLOGY_MDT_OrganisationSitesR
LDHNormal int 4 √ null
R_STAGING_INVESTIGATIONS_NONE bit 1 ((0))
R_STAGING_INVESTIGATIONS_MRI bit 1 ((0))
R_STAGING_INVESTIGATIONS_BONESCAN bit 1 ((0))
R_STAGING_INVESTIGATIONS_CT bit 1 ((0))
StageTesticularReportDate smalldatetime 16 √ null
StageTesticularReportOrgID int 4 √ null
OrganisationSites.ID FK_tblUROLOGY_MDT_OrganisationSites1R
StageRenalReportDate smalldatetime 16 √ null
StageRenalReportOrgID int 4 √ null
OrganisationSites.ID FK_tblUROLOGY_MDT_OrganisationSites2R
GeneralLabReportDate smalldatetime 16 √ null
GeneralLabReportOrgID int 4 √ null
OrganisationSites.ID FK_tblUROLOGY_MDT_OrganisationSites3R
MultiparametricMRI int 4 √ null
ltblYNNK.YN_ID FK_tblUROLOGY_MDT_ltblYNNK1R
MRIFusionBiopsy int 4 √ null
ltblYNNK.YN_ID FK_tblUROLOGY_MDT_ltblYNNKR
MiscLabReportDate smalldatetime 16 √ null
MiscLabReportOrgID int 4 √ null
OrganisationSites.ID FK_tblUROLOGY_MDT_OrganisationMiscSitesR
SNOMEDMorph int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblUROLOGY_MDT Primary key Asc MDT_ID

Relationships

Close relationships within degrees of separation